Skip to content

Instantly share code, notes, and snippets.

@uso5

uso5/sample_data_companies.sql

Last active August 25, 2021 09:57
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save uso5/936cca1bc00e513f195eb715f20fbe43 to your computer and use it in GitHub Desktop.
Save uso5/936cca1bc00e513f195eb715f20fbe43 to your computer and use it in GitHub Desktop.
Download ZIP
sample_data_companies
Raw
sample_data_companies.sql
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
# Dump of table companies
# ------------------------------------------------------------
CREATE TABLE `companies` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`company_name` varchar(255) NOT NULL DEFAULT '',
`phone` varchar(255) NOT NULL DEFAULT '',
`email` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
LOCK TABLES `companies` WRITE;
/*!40000 ALTER TABLE `companies` DISABLE KEYS */;
INSERT INTO `companies` (`id`, `company_name`, `phone`, `email`)
VALUES
(1,'Non Lacinia At Ltd','(013559) 84345','volutpat.Nulla@ipsum.ca'),
(2,'Bibendum Donec Felis Inc.','0500 732414','Cras.dolor@ullamcorper.net'),
(3,'Primis Inc.','0890 447 5802','eros.Proin.ultrices@mieleifendegestas.edu'),
(4,'Felis Eget Varius Corporation','(01404) 553687','est.vitae.sodales@mattis.edu'),
(5,'Gravida Molestie Arcu Company','(028) 3477 5402','a@velit.com'),
(6,'In Corp.','0369 452 7131','in.faucibus@lorem.edu'),
(7,'Dui Incorporated','(01059) 85765','Quisque@ametconsectetuer.edu'),
(8,'Varius Nam Porttitor Incorporated','(01313) 32554','ornare@feugiatSednec.com'),
(9,'Semper Auctor Corp.','(01659) 80072','consequat@vulputatelacusCras.ca'),
(10,'Nec Tempus Industries','0848 408 8770','luctus.ipsum@sitamet.org'),
(11,'Mauris Rhoncus Id Institute','(021) 8118 9389','ligula.Nullam@velit.net'),
(12,'Dolor Incorporated','(01567) 980347','massa.Integer.vitae@maurisrhoncusid.co.uk'),
(13,'Et Lacinia Vitae Incorporated','(016977) 9620','enim@Quisqueimperdiet.org'),
(14,'Porttitor Tellus Non LLC','07035 825039','Duis.elementum.dui@ligula.com'),
(15,'Dictum Foundation','070 0910 7716','morbi.tristique.senectus@necurna.com'),
(16,'Nunc In At Incorporated','(024) 9876 2142','tortor.at.risus@Maecenas.ca'),
(17,'Ut Industries','070 2728 1360','nisi.nibh.lacinia@loremeu.com'),
(18,'Faucibus Orci Corporation','(01905) 23026','nascetur@sapiencursus.co.uk'),
(19,'Nonummy Associates','0856 889 5448','mi.eleifend.egestas@Maecenas.com'),
(20,'Eget Industries','055 4082 6009','tempus.non@massarutrum.co.uk'),
(21,'Sociis Natoque Foundation','07599 097417','tellus@Aliquamultricesiaculis.co.uk'),
(22,'Tristique Limited','0389 081 1873','malesuada.fames@velitin.net'),
(23,'Venenatis Consulting','0800 168 9090','eu@ullamcorper.co.uk'),
(24,'Pharetra Felis Eget Institute','(016785) 92335','vestibulum.neque@dapibusligula.com'),
(25,'Donec LLC','07521 034703','nec@faucibusidlibero.net'),
(26,'Urna Justo Faucibus Institute','0800 858346','non@variusNam.ca'),
(27,'Malesuada Fames Ac Company','056 7484 3981','justo.Proin@purusmaurisa.co.uk'),
(28,'Donec Company','(016977) 6511','tristique.pellentesque.tellus@vehiculaet.ca'),
(29,'Nunc Incorporated','055 1106 6961','Nullam.ut@ligula.edu'),
(30,'Sagittis Inc.','076 8849 6457','Donec.dignissim.magna@dictummagnaUt.co.uk'),
(31,'Lacus Nulla Tincidunt Incorporated','076 4790 0731','Aenean.gravida.nunc@auctornunc.ca'),
(32,'Massa Quisque PC','0973 432 7063','Nunc@nonummy.co.uk'),
(33,'Pellentesque Ut Ipsum Corp.','(0171) 122 7211','fringilla@quamvel.edu'),
(34,'Tempor Augue Ac Associates','(01822) 11693','mi.eleifend@estmauris.ca'),
(35,'Ut Cursus Company','0800 420 1035','sed.pede@luctussit.co.uk'),
(36,'Morbi Consulting','0897 340 2907','porttitor.vulputate@semsempererat.co.uk'),
(37,'Tempor Company','0800 1111','dui.augue@lacinia.org'),
(38,'Donec Nibh Industries','0800 683326','nec.euismod@at.org'),
(39,'Ac Mattis Velit Foundation','0800 574121','Vestibulum@magnanec.ca'),
(40,'Montes Nascetur Corporation','0500 650271','dolor@diamdictum.edu'),
(41,'Rutrum Justo PC','07624 247016','Pellentesque.tincidunt.tempus@egestas.net'),
(42,'Posuere Enim Foundation','(027) 9411 2468','enim.commodo@sollicitudin.ca'),
(43,'Nec Ligula Consectetuer Ltd','(01321) 78246','Nulla@sed.ca'),
(44,'Mauris Limited','0845 46 41','parturient.montes.nascetur@et.edu'),
(45,'Aptent Ltd','070 1283 2398','convallis@rutrum.net'),
(46,'Netus Incorporated','(011495) 54982','nisl.Nulla@auctorvitae.org'),
(47,'Consectetuer Adipiscing Elit Foundation','076 4491 4588','rhoncus.Nullam.velit@ultrices.net'),
(48,'Tristique Pellentesque Limited','055 5698 4973','malesuada.augue@netusetmalesuada.co.uk'),
(49,'Lectus Justo Eu Limited','(01532) 72878','lectus.quis@sitamet.com'),
(50,'Lectus Inc.','(022) 1586 1587','Phasellus@Nunccommodo.com'),
(51,'Suspendisse Limited','(0110) 081 4613','non.lacinia.at@turpis.org'),
(52,'Diam PC','0367 313 2171','metus.vitae@Seddiam.net'),
(53,'Iaculis Enim Industries','0964 852 4779','leo.Morbi.neque@Maecenasiaculis.com'),
(54,'In Ltd','0800 636275','sagittis.placerat@consectetueradipiscing.net'),
(55,'Nec Mauris Blandit Associates','0800 038941','aliquet.nec@NullafacilisiSed.co.uk'),
(56,'Ultrices Mauris Institute','055 8707 5242','semper.cursus.Integer@temporaugue.co.uk'),
(57,'Donec Sollicitudin Consulting','0500 364954','leo.elementum.sem@tellusfaucibus.ca'),
(58,'Nec Metus Facilisis Inc.','(0119) 306 8549','parturient@fringillamilacinia.edu'),
(59,'Sed Corporation','(014603) 81194','tellus.justo@consectetuer.org'),
(60,'Odio LLC','0354 407 9003','eu@miDuisrisus.net'),
(61,'Non Feugiat Nec Industries','(01421) 64139','fringilla.est@eueratsemper.com'),
(62,'Neque Institute','(01382) 854764','Praesent.eu.dui@lacusEtiam.co.uk'),
(63,'Quis Pede Suspendisse Associates','0845 46 47','dui.quis@velit.ca'),
(64,'Dictum Sapien LLP','056 1135 6470','consequat@litoratorquentper.net'),
(65,'Blandit Corp.','(0101) 854 7120','odio.a.purus@acipsum.ca'),
(66,'Dui Semper Industries','(016977) 4885','sagittis.placerat.Cras@ametrisusDonec.net'),
(67,'Dui Lectus Rutrum Corp.','(01729) 413550','In@estacmattis.co.uk'),
(68,'Morbi Neque Tellus LLP','(016977) 5014','Duis@orciconsectetuer.co.uk'),
(69,'Aliquam Iaculis Limited','076 8501 7290','nec.leo.Morbi@consequat.org'),
(70,'Natoque Penatibus Et Industries','0301 991 3952','cursus.Integer.mollis@metus.com'),
(71,'Fringilla Mi Foundation','0845 46 40','magna.nec@nulla.ca'),
(72,'Enim Mauris Associates','(0141) 254 4793','gravida.Praesent.eu@nuncullamcorper.net'),
(73,'Ac Corporation','0845 46 46','egestas.blandit.Nam@miloremvehicula.com'),
(74,'Neque LLC','07278 789111','egestas.Aliquam@pharetra.ca'),
(75,'Mauris Limited','070 5127 2803','sit.amet.risus@velit.net'),
(76,'Lorem Eget Corp.','070 2000 7938','libero.Proin.mi@Aliquamnisl.co.uk'),
(77,'Semper Erat In LLP','07350 071332','elementum.purus@acorciUt.edu'),
(78,'Dignissim Pharetra Nam PC','0500 214086','sapien.imperdiet@nuncullamcorpereu.ca'),
(79,'Cursus Non Egestas Company','070 8181 5371','Duis.ac.arcu@egestasurna.com'),
(80,'Amet Metus Aliquam Ltd','0994 268 4792','lorem.tristique.aliquet@malesuadaInteger.ca'),
(81,'Nisi Corporation','(015077) 89552','nonummy.ipsum.non@vitae.ca'),
(82,'Proin Dolor Nulla Consulting','0800 390258','interdum@mollisPhaselluslibero.ca'),
(83,'Pellentesque Habitant Institute','0347 545 5623','fringilla@consectetuer.edu'),
(84,'Volutpat Nulla Incorporated','0800 040 9192','Nulla@parturientmontesnascetur.edu'),
(85,'Rutrum Fusce Dolor LLP','(01361) 621166','dis.parturient@lobortis.co.uk'),
(86,'Ac Orci Ut Consulting','0800 519676','lectus.Nullam@faucibusorci.co.uk'),
(87,'Pellentesque Habitant Morbi LLP','0399 265 0505','ac.turpis@nisi.org'),
(88,'Enim Corp.','0944 069 7047','Vivamus.molestie@convallis.ca'),
(89,'Sit Associates','07269 849698','in.tempus@Aeneanegetmagna.ca'),
(90,'Lorem Vehicula Consulting','07310 632430','tristique.ac.eleifend@Fuscedolor.edu'),
(91,'Congue In Scelerisque LLC','0845 46 43','pretium.et.rutrum@sitametdiam.org'),
(92,'Mi Ac Mattis Consulting','056 7504 0171','Quisque.nonummy.ipsum@necmauris.com'),
(93,'Adipiscing Elit Curabitur Corp.','(021) 2081 0236','Nunc@vitaesemperegestas.com'),
(94,'Molestie Industries','(01520) 841185','pretium.aliquet@turpisegestasAliquam.com'),
(95,'Egestas Fusce Aliquet Institute','(0114) 596 1248','vitae.purus@dolor.com'),
(96,'Elit Associates','0800 865687','ultrices.Vivamus@volutpat.com'),
(97,'Purus Incorporated','0386 164 9795','vestibulum@Aliquam.co.uk'),
(98,'Odio A Purus Limited','0800 1111','ultricies.ligula.Nullam@ipsum.com'),
(99,'At Risus Nunc Corporation','(01043) 599202','sollicitudin.adipiscing.ligula@elitelit.edu'),
(100,'Nunc Mauris Morbi Associates','(0111) 180 7434','bibendum.Donec@fermentumvel.org');
/*!40000 ALTER TABLE `companies` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table calls
# ------------------------------------------------------------
CREATE TABLE `calls` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`company_id` int(11) unsigned NOT NULL,
`call_rating` int(11) NOT NULL,
`created` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `company_id` (`company_id`),
CONSTRAINT `calls_ibfk_1` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
LOCK TABLES `calls` WRITE;
/*!40000 ALTER TABLE `calls` DISABLE KEYS */;
INSERT INTO `calls` (`id`, `company_id`, `call_rating`, `created`)
VALUES
(1,24,2,'2022-01-27 00:09:10'),
(2,46,3,'2022-05-30 02:18:35'),
(3,70,9,'2021-11-19 06:43:43'),
(4,29,8,'2021-09-03 21:10:19'),
(5,100,1,'2022-02-13 16:00:29'),
(6,11,10,'2020-10-24 23:28:52'),
(7,33,4,'2021-10-06 15:41:41'),
(8,57,4,'2022-02-18 03:21:57'),
(9,41,7,'2021-01-12 19:54:02'),
(10,22,5,'2021-12-09 20:14:33'),
(11,19,8,'2022-03-21 13:18:31'),
(12,97,5,'2021-10-09 21:16:49'),
(13,80,9,'2021-10-16 00:18:10'),
(14,13,7,'2020-12-02 17:59:13'),
(15,14,1,'2021-10-12 22:10:24'),
(16,14,10,'2021-08-27 16:13:09'),
(17,100,1,'2021-02-01 15:03:28'),
(18,20,1,'2022-01-18 13:33:29'),
(19,69,8,'2021-01-15 04:42:00'),
(20,15,3,'2021-09-27 20:30:23'),
(21,37,4,'2022-04-13 13:46:53'),
(22,83,5,'2021-02-03 11:33:50'),
(23,11,7,'2022-04-26 18:51:53'),
(24,41,9,'2022-04-03 14:53:30'),
(25,87,4,'2021-01-10 20:36:16'),
(26,75,8,'2020-10-10 16:04:33'),
(27,44,9,'2020-11-12 11:39:45'),
(28,31,3,'2022-06-19 19:07:16'),
(29,46,8,'2020-09-24 09:49:04'),
(30,57,5,'2021-11-11 07:53:07'),
(31,80,5,'2022-03-02 19:57:26'),
(32,72,4,'2021-07-08 20:21:39'),
(33,29,1,'2021-08-04 21:37:02'),
(34,95,9,'2020-11-09 15:28:08'),
(35,34,4,'2022-06-03 03:07:43'),
(36,32,3,'2021-09-19 05:08:10'),
(37,84,6,'2022-07-22 06:08:22'),
(38,35,10,'2021-11-13 03:20:54'),
(39,54,2,'2021-09-06 03:16:26'),
(40,13,1,'2020-09-24 06:26:23'),
(41,14,10,'2021-08-11 23:05:32'),
(42,30,5,'2021-10-30 23:38:32'),
(43,59,8,'2021-08-05 12:26:59'),
(44,88,8,'2022-04-02 04:30:57'),
(45,61,5,'2021-03-02 18:15:40'),
(46,9,2,'2021-07-26 00:22:06'),
(47,40,6,'2021-02-04 01:49:13'),
(48,75,3,'2021-04-17 14:23:54'),
(49,78,8,'2022-01-20 18:34:44'),
(50,57,1,'2021-06-18 10:02:13'),
(51,18,3,'2022-05-03 09:41:01'),
(52,11,3,'2022-02-10 11:33:39'),
(53,49,5,'2022-03-07 22:56:29'),
(54,54,10,'2022-07-20 03:07:35'),
(55,14,8,'2021-02-16 22:25:12'),
(56,49,3,'2021-09-23 09:50:04'),
(57,13,1,'2021-11-26 08:23:38'),
(58,1,1,'2022-05-16 14:20:28'),
(59,80,7,'2022-07-10 12:56:27'),
(60,35,6,'2021-10-06 08:46:02'),
(61,60,10,'2021-08-11 02:34:09'),
(62,95,3,'2022-05-18 06:59:47'),
(63,25,4,'2022-03-26 17:49:35'),
(64,15,10,'2021-04-05 22:24:31'),
(65,91,2,'2020-11-05 07:08:50'),
(66,94,4,'2020-09-21 02:04:29'),
(67,40,6,'2022-02-23 02:26:03'),
(68,21,5,'2021-06-19 04:44:19'),
(69,62,3,'2020-12-15 22:50:57'),
(70,41,8,'2021-06-12 10:04:43'),
(71,13,9,'2021-11-10 13:23:28'),
(72,89,4,'2021-06-17 06:03:10'),
(73,28,2,'2021-02-03 06:36:35'),
(74,24,1,'2021-09-16 12:33:09'),
(75,4,7,'2020-12-24 03:42:10'),
(76,90,1,'2021-01-30 21:52:51'),
(77,23,2,'2022-07-23 05:14:47'),
(78,8,6,'2020-10-27 06:41:08'),
(79,16,7,'2021-02-22 10:45:44'),
(80,84,1,'2022-07-09 21:19:11'),
(81,11,4,'2021-06-30 08:26:15'),
(82,81,8,'2021-04-17 02:31:58'),
(83,41,4,'2021-08-07 16:12:32'),
(84,6,3,'2022-04-06 02:07:18'),
(85,23,9,'2021-10-25 16:56:35'),
(86,87,6,'2021-05-18 08:24:12'),
(87,39,8,'2020-11-13 00:39:41'),
(88,27,10,'2022-03-31 00:01:11'),
(89,52,8,'2022-05-25 04:54:00'),
(90,55,6,'2020-11-29 17:07:49'),
(91,7,1,'2022-04-13 03:14:29'),
(92,48,2,'2022-04-25 04:04:09'),
(93,64,10,'2022-07-04 15:07:35'),
(94,88,10,'2021-04-14 11:16:26'),
(95,76,10,'2021-11-22 01:16:54'),
(96,24,2,'2022-04-14 01:35:27'),
(97,71,5,'2021-02-18 05:48:25'),
(98,66,4,'2021-10-16 01:29:06'),
(99,24,4,'2020-09-23 14:30:28'),
(100,66,10,'2022-04-19 12:59:52');
/*!40000 ALTER TABLE `calls` ENABLE KEYS */;
UNLOCK TABLES;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment