nvEg4HXZ

1#
2# TABLE STRUCTURE FOR: employe_categories
3#
4DROP DATABASE IF EXISTS MasterBeatTest;
5CREATE DATABASE MasterBeatTest;
6USE MasterBeatTest;
7
8#
9# TABLE STRUCTURE FOR: users
10#
11
12DROP TABLE IF EXISTS employees;
13DROP TABLE IF EXISTS products;
14DROP TABLE IF EXISTS services;
15DROP TABLE IF EXISTS suppliers;
16DROP TABLE IF EXISTS employe_categories;
17DROP TABLE IF EXISTS product_categories;
18DROP TABLE IF EXISTS service_categories;
19DROP TABLE IF EXISTS supplier_categories;
20DROP TABLE IF EXISTS enterprises;
21DROP TABLE IF EXISTS users;
22DROP TABLE IF EXISTS pictures;
23
24CREATE TABLE `users` (
25  `id` int(11) NOT NULL AUTO_INCREMENT,
26  `email` varchar(200) NOT NULL,
27  `password` varchar(200) NOT NULL,
28  `created` datetime NOT NULL,
29  `modified` datetime NOT NULL,
30  PRIMARY KEY (`id`),
31  UNIQUE KEY `UNIQUE_EMAIL` (`email`)
32) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;
33
34INSERT INTO users (`id`, `email`, `password`, `created`, `modified`) VALUES (1, 'rhianna18@example.org', '7e63bdd7224854ab6713c10bf24e0fe024ab24a0', '2012-11-08 15:30:55', '2002-08-12 16:56:44');
35INSERT INTO users (`id`, `email`, `password`, `created`, `modified`) VALUES (2, 'moses04@example.org', '69758c672686c619a18f4e36ebd4dda6f2704930', '1972-06-04 16:58:01', '1988-02-07 23:21:45');
36INSERT INTO users (`id`, `email`, `password`, `created`, `modified`) VALUES (3, 'gunner.walker@example.com', '4182e076f6e92c9f42ed0ea79d6a33bae619fc83', '1998-01-29 16:28:01', '1972-03-19 20:54:25');
37INSERT INTO users (`id`, `email`, `password`, `created`, `modified`) VALUES (4, 'keara55@example.org', 'c8d97f48a29b5f95867ed392152c177cc2b7e170', '2015-01-01 12:09:25', '1989-09-14 02:40:05');
38INSERT INTO users (`id`, `email`, `password`, `created`, `modified`) VALUES (5, 'walsh.carol@example.net', 'b8aab5acd5944bb0e2877431e7d8043959a222c7', '1995-11-26 19:58:30', '2000-06-15 02:11:11');
39INSERT INTO users (`id`, `email`, `password`, `created`, `modified`) VALUES (6, 'wilkinson.montana@example.net', '57d78266dd3918e49f6f78695ca7e14d68b8a037', '2011-01-26 23:57:31', '1989-12-01 13:30:05');
40INSERT INTO users (`id`, `email`, `password`, `created`, `modified`) VALUES (7, 'ycormier@example.com', '1280cfebb3dc25ef694ff1c460c58bd652af8f73', '1983-06-25 01:40:31', '2001-06-28 23:18:56');
41INSERT INTO users (`id`, `email`, `password`, `created`, `modified`) VALUES (8, 'gpagac@example.net', '22fe89d6210463079290a0be9991dcd199a7813e', '1996-04-20 03:34:43', '1991-07-31 21:58:26');
42INSERT INTO users (`id`, `email`, `password`, `created`, `modified`) VALUES (9, 'kendra24@example.org', 'ce13191bc4c19c1b53d63072e6201d82fb6666ce', '2007-07-15 20:10:48', '1974-03-14 04:51:46');
43INSERT INTO users (`id`, `email`, `password`, `created`, `modified`) VALUES (10, 'hermiston.sam@example.net', 'ddbff6d0469a9a844606706a6dabb70a84e75bfc', '2001-05-25 00:34:51', '1992-09-26 20:33:20');
44INSERT INTO users (`id`, `email`, `password`, `created`, `modified`) VALUES (11, 'lucie.wuckert@example.org', '8a413c67a0108a53b75bac189377fc350997647c', '1999-03-28 14:57:46', '1988-03-17 08:29:41');
45INSERT INTO users (`id`, `email`, `password`, `created`, `modified`) VALUES (12, 'murl47@example.com', '226713d12c43f39a1f9a7545492ba7b2ce488992', '2017-03-17 21:40:14', '2011-03-11 21:20:30');
46INSERT INTO users (`id`, `email`, `password`, `created`, `modified`) VALUES (13, 'norene.mohr@example.com', '218d0f7e9775ac10e277c77a3dc45aeacf250e2d', '2009-01-03 21:23:08', '2009-12-22 11:23:43');
47INSERT INTO users (`id`, `email`, `password`, `created`, `modified`) VALUES (14, 'heaney.whitney@example.com', '58ca3a840e4953278324b32111d31ae220b5f56a', '1975-08-03 02:22:06', '1982-06-19 02:09:38');
48INSERT INTO users (`id`, `email`, `password`, `created`, `modified`) VALUES (15, 'angus86@example.com', 'be602845391d0879b2c0d0fed8da78ba26341e1f', '2000-04-11 00:28:35', '1971-02-07 07:00:44');
49INSERT INTO users (`id`, `email`, `password`, `created`, `modified`) VALUES (16, 'jean51@example.com', 'a142e2e2d3cce120f9f113f2ab0c458caabc1a67', '1975-08-23 12:54:34', '1982-08-21 13:41:47');
50INSERT INTO users (`id`, `email`, `password`, `created`, `modified`) VALUES (17, 'grady.kurt@example.org', 'a43b5188c323750ab3c972575ac409b49d38b3c6', '1996-08-20 03:25:23', '1983-12-16 22:49:55');
51INSERT INTO users (`id`, `email`, `password`, `created`, `modified`) VALUES (18, 'lbechtelar@example.net', '6eb1dd0a80fcb8ff007e3a0328245b5e453a45b4', '2011-07-23 09:26:21', '1972-01-30 05:07:19');
52INSERT INTO users (`id`, `email`, `password`, `created`, `modified`) VALUES (19, 'myrtice.bins@example.com', 'fc188b67face29c15ce75f4e4584f6f96c8bd61c', '1976-10-01 11:14:13', '2003-02-15 07:13:51');
53INSERT INTO users (`id`, `email`, `password`, `created`, `modified`) VALUES (20, 'carlee44@example.org', '1916ea2f804e6214d266945de2fb0175e26ba48d', '2007-12-15 14:59:26', '2002-06-18 09:14:29');
54
55
56
57#
58# TABLE STRUCTURE FOR: pictures
59#
60
61
62CREATE TABLE `pictures` (
63  `id` int(11) NOT NULL AUTO_INCREMENT,
64  `base64image` longtext NOT NULL,
65  `created` datetime NOT NULL,
66  `modified` datetime NOT NULL,
67  PRIMARY KEY (`id`)
68) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;
69
70INSERT INTO pictures (`id`, `base64image`, `created`, `modified`) VALUES (1, 'http://lorempixel.com/640/480/', '1979-02-03 20:27:00', '1978-03-19 01:54:38');
71INSERT INTO pictures (`id`, `base64image`, `created`, `modified`) VALUES (2, 'http://lorempixel.com/640/480/', '1999-06-26 12:36:59', '2005-01-22 21:10:14');
72INSERT INTO pictures (`id`, `base64image`, `created`, `modified`) VALUES (3, 'http://lorempixel.com/640/480/', '1995-07-25 15:39:46', '2010-12-26 05:11:43');
73INSERT INTO pictures (`id`, `base64image`, `created`, `modified`) VALUES (4, 'http://lorempixel.com/640/480/', '1978-10-23 04:30:36', '1994-03-24 03:49:21');
74INSERT INTO pictures (`id`, `base64image`, `created`, `modified`) VALUES (5, 'http://lorempixel.com/640/480/', '1979-04-01 08:47:09', '1991-09-28 19:16:14');
75INSERT INTO pictures (`id`, `base64image`, `created`, `modified`) VALUES (6, 'http://lorempixel.com/640/480/', '2001-12-23 22:44:23', '1980-02-25 21:09:42');
76INSERT INTO pictures (`id`, `base64image`, `created`, `modified`) VALUES (7, 'http://lorempixel.com/640/480/', '1988-03-04 09:30:41', '1980-01-11 17:32:16');
77INSERT INTO pictures (`id`, `base64image`, `created`, `modified`) VALUES (8, 'http://lorempixel.com/640/480/', '1985-08-22 00:04:35', '1972-04-18 11:12:09');
78INSERT INTO pictures (`id`, `base64image`, `created`, `modified`) VALUES (9, 'http://lorempixel.com/640/480/', '1991-10-20 20:12:37', '1986-10-31 08:23:08');
79INSERT INTO pictures (`id`, `base64image`, `created`, `modified`) VALUES (10, 'http://lorempixel.com/640/480/', '1984-02-02 13:46:43', '1971-04-20 15:37:19');
80INSERT INTO pictures (`id`, `base64image`, `created`, `modified`) VALUES (11, 'http://lorempixel.com/640/480/', '1990-10-13 02:33:24', '1981-05-12 22:32:14');
81INSERT INTO pictures (`id`, `base64image`, `created`, `modified`) VALUES (12, 'http://lorempixel.com/640/480/', '1997-04-15 09:20:09', '1986-12-30 17:55:26');
82INSERT INTO pictures (`id`, `base64image`, `created`, `modified`) VALUES (13, 'http://lorempixel.com/640/480/', '1976-02-13 02:08:52', '1982-04-02 23:40:33');
83INSERT INTO pictures (`id`, `base64image`, `created`, `modified`) VALUES (14, 'http://lorempixel.com/640/480/', '1978-07-18 08:27:23', '1991-09-26 05:08:33');
84INSERT INTO pictures (`id`, `base64image`, `created`, `modified`) VALUES (15, 'http://lorempixel.com/640/480/', '2004-05-27 03:52:05', '1987-06-13 19:55:59');
85INSERT INTO pictures (`id`, `base64image`, `created`, `modified`) VALUES (16, 'http://lorempixel.com/640/480/', '2005-10-17 09:46:24', '1987-06-21 06:04:35');
86INSERT INTO pictures (`id`, `base64image`, `created`, `modified`) VALUES (17, 'http://lorempixel.com/640/480/', '2007-08-02 03:50:39', '2009-05-15 09:33:41');
87INSERT INTO pictures (`id`, `base64image`, `created`, `modified`) VALUES (18, 'http://lorempixel.com/640/480/', '1979-10-07 12:26:16', '2015-04-16 13:03:12');
88INSERT INTO pictures (`id`, `base64image`, `created`, `modified`) VALUES (19, 'http://lorempixel.com/640/480/', '2005-08-27 19:02:05', '2001-12-20 15:17:40');
89INSERT INTO pictures (`id`, `base64image`, `created`, `modified`) VALUES (20, 'http://lorempixel.com/640/480/', '1979-12-12 22:08:02', '2006-05-25 13:02:01');
90
91#
92# TABLE STRUCTURE FOR: enterprises
93#
94
95
96CREATE TABLE `enterprises` (
97  `id` int(11) NOT NULL AUTO_INCREMENT,
98  `name` varchar(200) NOT NULL,
99  `domain_name` varchar(200) DEFAULT NULL,
100  `owner_id` int(11) NOT NULL,
101  `logo_id` int(11) NOT NULL,
102  `created` datetime NOT NULL,
103  `modified` datetime NOT NULL,
104  PRIMARY KEY (`id`),
105  UNIQUE KEY `UNIQUE_NAME` (`name`),
106  KEY `BY_OWNER_ID` (`owner_id`),
107  KEY `BY_LOGO_ID` (`logo_id`),
108  CONSTRAINT `enterprises_ibfk_1` FOREIGN KEY (`logo_id`) REFERENCES `pictures` (`id`),
109  CONSTRAINT `enterprises_ibfk_2` FOREIGN KEY (`owner_id`) REFERENCES `users` (`id`)
110) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;
111
112INSERT INTO enterprises (`id`, `name`, `domain_name`, `owner_id`, `logo_id`, `created`, `modified`) VALUES (1, 'dolorum', 'farrellschuppe.net', 4, 12, '1982-09-10 13:18:38', '2005-05-02 21:15:27');
113INSERT INTO enterprises (`id`, `name`, `domain_name`, `owner_id`, `logo_id`, `created`, `modified`) VALUES (2, 'delectus', 'kohler.com', 5, 10, '1995-08-21 02:44:57', '1981-11-04 12:52:09');
114INSERT INTO enterprises (`id`, `name`, `domain_name`, `owner_id`, `logo_id`, `created`, `modified`) VALUES (3, 'adipisci', 'lesch.net', 18, 14, '2006-04-17 20:03:05', '2004-03-03 07:19:55');
115INSERT INTO enterprises (`id`, `name`, `domain_name`, `owner_id`, `logo_id`, `created`, `modified`) VALUES (4, 'labore', 'hammes.com', 12, 10, '1993-08-14 03:48:41', '1998-11-08 20:16:02');
116INSERT INTO enterprises (`id`, `name`, `domain_name`, `owner_id`, `logo_id`, `created`, `modified`) VALUES (5, 'amet', 'turnercummings.biz', 4, 17, '1997-01-17 07:41:39', '2011-01-15 00:02:45');
117INSERT INTO enterprises (`id`, `name`, `domain_name`, `owner_id`, `logo_id`, `created`, `modified`) VALUES (6, 'nesciunt', 'rolfson.com', 9, 5, '2001-09-17 10:13:48', '1974-04-23 05:01:32');
118INSERT INTO enterprises (`id`, `name`, `domain_name`, `owner_id`, `logo_id`, `created`, `modified`) VALUES (7, 'perspiciatis', 'bartoletti.com', 17, 20, '1976-10-02 12:56:53', '1991-12-23 03:29:59');
119INSERT INTO enterprises (`id`, `name`, `domain_name`, `owner_id`, `logo_id`, `created`, `modified`) VALUES (8, 'officia', 'roweokon.org', 13, 6, '2011-01-19 19:31:48', '2001-10-29 10:35:33');
120INSERT INTO enterprises (`id`, `name`, `domain_name`, `owner_id`, `logo_id`, `created`, `modified`) VALUES (9, 'consequatur', 'langosh.com', 8, 11, '1993-07-05 00:55:08', '1980-04-26 21:00:13');
121INSERT INTO enterprises (`id`, `name`, `domain_name`, `owner_id`, `logo_id`, `created`, `modified`) VALUES (10, 'quos', 'zemlakwaelchi.com', 6, 2, '1975-08-14 12:52:41', '2004-05-07 10:19:13');
122INSERT INTO enterprises (`id`, `name`, `domain_name`, `owner_id`, `logo_id`, `created`, `modified`) VALUES (11, 'eligendi', 'labadienitzsche.biz', 12, 15, '2002-01-06 14:54:15', '1989-09-02 14:02:35');
123INSERT INTO enterprises (`id`, `name`, `domain_name`, `owner_id`, `logo_id`, `created`, `modified`) VALUES (12, 'vel', 'bogisich.org', 1, 15, '2014-12-07 16:24:21', '2000-06-25 16:31:36');
124INSERT INTO enterprises (`id`, `name`, `domain_name`, `owner_id`, `logo_id`, `created`, `modified`) VALUES (13, 'ipsum', 'rohan.com', 15, 2, '1973-05-02 07:46:45', '2012-07-21 18:55:23');
125INSERT INTO enterprises (`id`, `name`, `domain_name`, `owner_id`, `logo_id`, `created`, `modified`) VALUES (14, 'rerum', 'rolfsonhowe.com', 16, 15, '1978-04-27 00:32:36', '1985-02-06 12:38:22');
126INSERT INTO enterprises (`id`, `name`, `domain_name`, `owner_id`, `logo_id`, `created`, `modified`) VALUES (15, 'officiis', 'padbergmosciski.com', 7, 20, '1974-07-27 13:12:03', '1993-01-08 06:46:29');
127INSERT INTO enterprises (`id`, `name`, `domain_name`, `owner_id`, `logo_id`, `created`, `modified`) VALUES (16, 'eius', 'ortizpaucek.org', 12, 8, '1976-01-30 00:15:08', '2017-07-21 01:00:49');
128INSERT INTO enterprises (`id`, `name`, `domain_name`, `owner_id`, `logo_id`, `created`, `modified`) VALUES (17, 'ipsa', 'metz.com', 18, 12, '1970-05-19 10:19:55', '2008-04-20 21:58:28');
129INSERT INTO enterprises (`id`, `name`, `domain_name`, `owner_id`, `logo_id`, `created`, `modified`) VALUES (18, 'corporis', 'erdman.org', 5, 1, '1973-10-16 13:40:44', '1982-08-24 11:11:23');
130INSERT INTO enterprises (`id`, `name`, `domain_name`, `owner_id`, `logo_id`, `created`, `modified`) VALUES (19, 'dicta', 'wuckert.com', 3, 11, '1990-07-29 00:54:57', '1988-08-22 16:45:15');
131INSERT INTO enterprises (`id`, `name`, `domain_name`, `owner_id`, `logo_id`, `created`, `modified`) VALUES (20, 'ut', 'blanda.com', 18, 14, '1990-09-29 08:59:38', '2001-08-12 15:14:22');
132
133
134
135
136
137
138
139
140
141
142
143CREATE TABLE `employe_categories` (
144  `id` int(11) NOT NULL AUTO_INCREMENT,
145  `name` varchar(200) NOT NULL,
146  `enterprise_id` int(11) NOT NULL,
147  `created` datetime NOT NULL,
148  `modified` datetime NOT NULL,
149  PRIMARY KEY (`id`),
150  KEY `BY_ENTERPRISE_ID` (`enterprise_id`),
151  CONSTRAINT `employe_categories_ibfk_1` FOREIGN KEY (`enterprise_id`) REFERENCES `enterprises` (`id`)
152) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;
153
154INSERT INTO employe_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (1, 'quas', 14, '1994-12-11 03:45:18', '1992-04-17 03:59:04');
155INSERT INTO employe_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (2, 'ut', 7, '1992-05-23 22:19:41', '1980-11-02 22:32:57');
156INSERT INTO employe_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (3, 'suscipit', 20, '2002-07-21 20:22:28', '1971-04-08 06:41:59');
157INSERT INTO employe_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (4, 'recusandae', 13, '2004-07-14 10:12:15', '2003-07-18 23:16:40');
158INSERT INTO employe_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (5, 'dolores', 2, '2004-10-02 10:15:55', '1974-08-14 16:18:06');
159INSERT INTO employe_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (6, 'quasi', 4, '1996-01-12 14:57:32', '1983-11-04 13:15:53');
160INSERT INTO employe_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (7, 'itaque', 18, '2006-09-03 07:29:53', '2018-01-22 09:43:20');
161INSERT INTO employe_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (8, 'facere', 14, '1978-12-18 21:59:39', '1989-07-28 14:31:18');
162INSERT INTO employe_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (9, 'quia', 12, '1986-06-25 22:57:13', '1999-04-29 21:20:17');
163INSERT INTO employe_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (10, 'reiciendis', 12, '1990-06-10 21:34:55', '2012-11-06 10:44:23');
164INSERT INTO employe_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (11, 'qui', 12, '1997-01-23 11:23:04', '2011-09-25 13:10:46');
165INSERT INTO employe_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (12, 'architecto', 7, '2008-04-24 18:21:59', '1978-12-10 18:22:58');
166INSERT INTO employe_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (13, 'quia', 1, '1981-03-31 13:33:52', '1971-05-22 18:39:15');
167INSERT INTO employe_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (14, 'consequatur', 7, '1981-01-30 10:03:56', '2011-11-24 13:22:11');
168INSERT INTO employe_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (15, 'et', 12, '1986-12-28 03:01:13', '2017-04-30 16:22:03');
169INSERT INTO employe_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (16, 'incidunt', 13, '1993-07-25 12:38:39', '2006-02-09 22:30:15');
170INSERT INTO employe_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (17, 'rem', 1, '1980-10-20 00:42:42', '2000-08-04 14:23:08');
171INSERT INTO employe_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (18, 'animi', 8, '2014-04-27 05:50:29', '2016-08-22 01:47:48');
172INSERT INTO employe_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (19, 'natus', 6, '1993-09-14 13:05:50', '1985-03-07 06:16:23');
173INSERT INTO employe_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (20, 'aut', 17, '2006-11-30 15:23:59', '1993-08-29 13:34:27');
174
175
176#
177# TABLE STRUCTURE FOR: employees
178#
179
180
181CREATE TABLE `employees` (
182  `id` int(11) NOT NULL AUTO_INCREMENT,
183  `firstname` varchar(255) NOT NULL,
184  `lastname` varchar(255) NOT NULL,
185  `birthday` date NOT NULL,
186  `hire_date` date NOT NULL,
187  `address` text NOT NULL,
188  `employe_category_id` int(11) NOT NULL,
189  `picture_id` int(11) NOT NULL,
190  `created` datetime NOT NULL,
191  `modified` datetime NOT NULL,
192  PRIMARY KEY (`id`),
193  KEY `BY_EMPLOYE_CATEGORY_ID` (`employe_category_id`),
194  KEY `BY_PICTURE_ID` (`picture_id`),
195  CONSTRAINT `employees_ibfk_1` FOREIGN KEY (`employe_category_id`) REFERENCES `employe_categories` (`id`),
196  CONSTRAINT `employees_ibfk_2` FOREIGN KEY (`picture_id`) REFERENCES `pictures` (`id`)
197) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;
198
199INSERT INTO employees (`id`, `firstname`, `lastname`, `birthday`, `hire_date`, `address`, `employe_category_id`, `picture_id`, `created`, `modified`) VALUES (1, 'Cleora', 'Bernier', '1997-12-18', '1980-04-06', '9440 Kunde Trace Apt. 187\nWardmouth, NH 42152', 19, 8, '1987-11-04 19:08:53', '1982-03-05 09:19:29');
200INSERT INTO employees (`id`, `firstname`, `lastname`, `birthday`, `hire_date`, `address`, `employe_category_id`, `picture_id`, `created`, `modified`) VALUES (2, 'Chester', 'Nitzsche', '1986-09-13', '1983-10-12', '63203 Boehm Fork\nSouth Franz, MT 04492-7076', 6, 9, '1989-05-24 05:12:02', '2007-03-20 21:49:24');
201INSERT INTO employees (`id`, `firstname`, `lastname`, `birthday`, `hire_date`, `address`, `employe_category_id`, `picture_id`, `created`, `modified`) VALUES (3, 'Mandy', 'Swaniawski', '1974-07-17', '1995-11-13', '7925 Aylin Meadow Apt. 452\nPort Gonzalo, WV 42047', 7, 4, '1971-02-28 19:09:48', '2009-06-10 17:05:11');
202INSERT INTO employees (`id`, `firstname`, `lastname`, `birthday`, `hire_date`, `address`, `employe_category_id`, `picture_id`, `created`, `modified`) VALUES (4, 'Van', 'Kohler', '1980-12-02', '1988-01-10', '211 Pfannerstill Ferry\nLake Dayna, WV 11865', 11, 20, '1982-03-19 22:36:39', '2009-05-30 21:02:08');
203INSERT INTO employees (`id`, `firstname`, `lastname`, `birthday`, `hire_date`, `address`, `employe_category_id`, `picture_id`, `created`, `modified`) VALUES (5, 'Obie', 'Hintz', '1988-07-25', '2012-06-28', '83332 Myah Branch Suite 438\nLuellachester, NE 23290', 3, 17, '1979-03-21 09:45:36', '1980-03-29 13:35:39');
204INSERT INTO employees (`id`, `firstname`, `lastname`, `birthday`, `hire_date`, `address`, `employe_category_id`, `picture_id`, `created`, `modified`) VALUES (6, 'Shemar', 'Barton', '1987-09-12', '2010-06-03', '289 Walter Extensions Apt. 131\nLake Reva, KY 60448-4377', 19, 8, '1971-10-10 16:25:11', '1993-09-10 11:25:26');
205INSERT INTO employees (`id`, `firstname`, `lastname`, `birthday`, `hire_date`, `address`, `employe_category_id`, `picture_id`, `created`, `modified`) VALUES (7, 'Ray', 'Witting', '1990-12-15', '2005-06-03', '73400 Koch Haven Apt. 976\nEast Robertmouth, WI 37469-0854', 9, 1, '1985-05-16 06:37:56', '2005-01-30 02:51:25');
206INSERT INTO employees (`id`, `firstname`, `lastname`, `birthday`, `hire_date`, `address`, `employe_category_id`, `picture_id`, `created`, `modified`) VALUES (8, 'Jazmin', 'Fay', '1986-06-16', '2010-12-06', '721 Sigrid Circle Suite 124\nEast Romaine, SC 33261', 5, 2, '1972-12-09 21:56:46', '1978-08-23 16:14:32');
207INSERT INTO employees (`id`, `firstname`, `lastname`, `birthday`, `hire_date`, `address`, `employe_category_id`, `picture_id`, `created`, `modified`) VALUES (9, 'Karl', 'Boehm', '2005-05-10', '1983-11-11', '0842 Janie Ports Suite 543\nGarettville, TX 49610-1942', 20, 19, '1992-08-17 19:17:13', '2015-06-09 21:48:01');
208INSERT INTO employees (`id`, `firstname`, `lastname`, `birthday`, `hire_date`, `address`, `employe_category_id`, `picture_id`, `created`, `modified`) VALUES (10, 'Kelli', 'Beer', '1986-06-25', '1972-07-23', '3033 Turcotte Haven Suite 903\nNew Nataliamouth, MS 39527', 4, 20, '2016-06-16 07:54:19', '2017-03-11 03:14:53');
209INSERT INTO employees (`id`, `firstname`, `lastname`, `birthday`, `hire_date`, `address`, `employe_category_id`, `picture_id`, `created`, `modified`) VALUES (11, 'Ocie', 'Hyatt', '2011-07-15', '1995-05-31', '30662 Everardo Cove\nKochmouth, UT 16226', 17, 4, '1984-07-13 14:58:48', '1970-09-22 11:14:08');
210INSERT INTO employees (`id`, `firstname`, `lastname`, `birthday`, `hire_date`, `address`, `employe_category_id`, `picture_id`, `created`, `modified`) VALUES (12, 'Ewell', 'Morar', '1998-03-26', '2005-07-31', '63778 Vernon Crest Suite 259\nFerryton, NH 96090', 20, 13, '1978-12-11 05:59:51', '2008-01-10 03:21:28');
211INSERT INTO employees (`id`, `firstname`, `lastname`, `birthday`, `hire_date`, `address`, `employe_category_id`, `picture_id`, `created`, `modified`) VALUES (13, 'Tabitha', 'Dickinson', '1971-08-31', '2006-08-23', '6931 Abernathy Stravenue Apt. 148\nKayashire, WY 12484', 7, 9, '2012-04-22 20:15:29', '1995-03-18 23:21:12');
212INSERT INTO employees (`id`, `firstname`, `lastname`, `birthday`, `hire_date`, `address`, `employe_category_id`, `picture_id`, `created`, `modified`) VALUES (14, 'Mason', 'Schmidt', '2017-12-22', '2006-11-25', '66328 Botsford Pass\nNorth Carissaborough, OH 97368-4975', 9, 15, '2016-12-14 00:41:53', '1989-06-04 03:58:45');
213INSERT INTO employees (`id`, `firstname`, `lastname`, `birthday`, `hire_date`, `address`, `employe_category_id`, `picture_id`, `created`, `modified`) VALUES (15, 'Della', 'Lebsack', '2003-04-16', '1976-08-09', '10501 Beer Court\nD\'Amorechester, GA 35807-9511', 18, 6, '2004-03-13 18:49:41', '2005-12-18 10:09:19');
214INSERT INTO employees (`id`, `firstname`, `lastname`, `birthday`, `hire_date`, `address`, `employe_category_id`, `picture_id`, `created`, `modified`) VALUES (16, 'Dandre', 'McClure', '1993-10-26', '1988-06-04', '512 Brown Flat Apt. 454\nNew Brant, DE 93503', 10, 13, '2005-09-23 16:19:51', '1999-11-12 03:38:15');
215INSERT INTO employees (`id`, `firstname`, `lastname`, `birthday`, `hire_date`, `address`, `employe_category_id`, `picture_id`, `created`, `modified`) VALUES (17, 'Finn', 'Fisher', '1994-09-10', '2012-10-03', '8624 Pollich Ways\nNorth Blairfurt, MS 18863-3485', 4, 14, '2014-05-22 17:30:44', '2016-09-20 19:38:18');
216INSERT INTO employees (`id`, `firstname`, `lastname`, `birthday`, `hire_date`, `address`, `employe_category_id`, `picture_id`, `created`, `modified`) VALUES (18, 'Viva', 'Sporer', '1995-05-21', '1998-02-21', '20427 Danyka Springs\nPort Zanderchester, ID 33440', 17, 12, '1987-03-07 03:46:50', '2001-07-20 07:56:38');
217INSERT INTO employees (`id`, `firstname`, `lastname`, `birthday`, `hire_date`, `address`, `employe_category_id`, `picture_id`, `created`, `modified`) VALUES (19, 'Beau', 'Hagenes', '2012-01-01', '2014-08-25', '9268 Verlie Rapids\nAgustinaburgh, ID 95307', 20, 13, '1987-10-12 01:24:08', '1995-05-27 16:12:49');
218INSERT INTO employees (`id`, `firstname`, `lastname`, `birthday`, `hire_date`, `address`, `employe_category_id`, `picture_id`, `created`, `modified`) VALUES (20, 'Rollin', 'Crona', '2011-03-15', '1984-09-19', '520 Ward Forge\nKraigland, SD 85369-9519', 10, 18, '2015-05-23 13:02:55', '1987-09-30 04:55:06');
219
220
221
222#
223# TABLE STRUCTURE FOR: phinxlog
224#
225
226DROP TABLE IF EXISTS phinxlog;
227
228CREATE TABLE `phinxlog` (
229  `version` bigint(20) NOT NULL,
230  `migration_name` varchar(100) DEFAULT NULL,
231  `start_time` timestamp NULL DEFAULT NULL,
232  `end_time` timestamp NULL DEFAULT NULL,
233  `breakpoint` tinyint(1) NOT NULL DEFAULT '0',
234  PRIMARY KEY (`version`)
235) ENGINE=InnoDB DEFAULT CHARSET=utf8;
236
237INSERT INTO phinxlog (`version`, `migration_name`, `start_time`, `end_time`, `breakpoint`) VALUES (0, 'qui', '1982-04-26 21:30:26', '1974-05-07 09:06:50', 0);
238
239#
240# TABLE STRUCTURE FOR: product_categories
241#
242
243
244CREATE TABLE `product_categories` (
245  `id` int(11) NOT NULL AUTO_INCREMENT,
246  `name` varchar(200) NOT NULL,
247  `enterprise_id` int(11) NOT NULL,
248  `created` datetime NOT NULL,
249  `modified` datetime NOT NULL,
250  PRIMARY KEY (`id`),
251  KEY `BY_ENTERPRISE_ID` (`enterprise_id`),
252  CONSTRAINT `product_categories_ibfk_1` FOREIGN KEY (`enterprise_id`) REFERENCES `enterprises` (`id`)
253) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;
254
255INSERT INTO product_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (1, 'odit', 7, '1992-01-27 04:39:54', '2014-06-11 08:11:23');
256INSERT INTO product_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (2, 'repellat', 7, '2015-01-24 16:49:39', '1993-12-07 09:53:52');
257INSERT INTO product_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (3, 'a', 19, '1996-10-10 15:37:36', '1981-03-25 13:58:40');
258INSERT INTO product_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (4, 'iusto', 17, '1985-03-12 23:30:43', '2000-06-03 08:33:11');
259INSERT INTO product_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (5, 'et', 10, '1976-10-15 18:23:20', '1982-06-30 07:11:26');
260INSERT INTO product_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (6, 'odio', 7, '1977-07-15 23:11:52', '1979-08-21 21:09:22');
261INSERT INTO product_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (7, 'dicta', 2, '1973-07-30 04:11:52', '2004-04-04 20:33:05');
262INSERT INTO product_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (8, 'accusantium', 14, '2005-04-04 18:30:49', '2017-02-15 13:42:55');
263INSERT INTO product_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (9, 'id', 20, '1971-12-17 11:00:22', '2012-03-30 12:47:41');
264INSERT INTO product_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (10, 'quasi', 11, '1998-04-02 05:52:19', '1973-07-30 02:59:29');
265INSERT INTO product_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (11, 'voluptatem', 3, '1988-03-05 12:59:34', '1983-05-20 06:43:31');
266INSERT INTO product_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (12, 'reiciendis', 10, '1991-09-05 22:22:43', '2003-12-26 14:22:56');
267INSERT INTO product_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (13, 'non', 9, '2014-04-01 15:01:35', '2004-12-14 11:06:06');
268INSERT INTO product_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (14, 'dolores', 18, '1986-09-17 06:31:32', '2015-11-17 05:55:12');
269INSERT INTO product_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (15, 'consectetur', 7, '1985-12-19 15:02:21', '1982-01-31 05:19:34');
270INSERT INTO product_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (16, 'voluptatem', 16, '2014-08-24 17:07:19', '1992-08-05 14:50:47');
271INSERT INTO product_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (17, 'quasi', 6, '1988-09-15 16:23:25', '1981-06-15 05:39:53');
272INSERT INTO product_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (18, 'consectetur', 1, '2001-04-17 00:16:27', '1995-10-10 07:06:18');
273INSERT INTO product_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (19, 'doloremque', 7, '2008-10-09 05:01:40', '1997-03-17 20:57:48');
274INSERT INTO product_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (20, 'autem', 10, '2011-09-22 22:27:24', '2013-02-26 18:33:53');
275
276
277#
278# TABLE STRUCTURE FOR: products
279#
280
281
282CREATE TABLE `products` (
283  `id` int(11) NOT NULL AUTO_INCREMENT,
284  `name` varchar(255) NOT NULL,
285  `price` varchar(255) NOT NULL,
286  `quantity_available` varchar(255) NOT NULL,
287  `quantity_min_limit` varchar(255) NOT NULL,
288  `quantity_max_limit` varchar(255) NOT NULL,
289  `product_category_id` int(11) NOT NULL,
290  `picture_id` int(11) NOT NULL,
291  `created` datetime NOT NULL,
292  `modified` datetime NOT NULL,
293  PRIMARY KEY (`id`),
294  KEY `BY_PRODUCT_CATEGORY_ID` (`product_category_id`),
295  KEY `BY_PICTURE_ID` (`picture_id`),
296  CONSTRAINT `products_ibfk_1` FOREIGN KEY (`product_category_id`) REFERENCES `product_categories` (`id`),
297  CONSTRAINT `products_ibfk_2` FOREIGN KEY (`picture_id`) REFERENCES `pictures` (`id`)
298) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;
299
300INSERT INTO products (`id`, `name`, `price`, `quantity_available`, `quantity_min_limit`, `quantity_max_limit`, `product_category_id`, `picture_id`, `created`, `modified`) VALUES (1, 'et', '10920', '314.4376359', '66.904', '40783', 10, 17, '1983-05-22 04:29:16', '1997-03-20 18:35:39');
301INSERT INTO products (`id`, `name`, `price`, `quantity_available`, `quantity_min_limit`, `quantity_max_limit`, `product_category_id`, `picture_id`, `created`, `modified`) VALUES (2, 'aut', '', '46197338.063788', '36677', '56852952', 2, 5, '1996-09-07 09:46:21', '2017-12-27 14:16:07');
302INSERT INTO products (`id`, `name`, `price`, `quantity_available`, `quantity_min_limit`, `quantity_max_limit`, `product_category_id`, `picture_id`, `created`, `modified`) VALUES (3, 'ad', '8515467.8307', '184075063.4', '3763.64368', '6159', 9, 20, '2000-08-29 10:10:17', '1985-07-23 08:37:47');
303INSERT INTO products (`id`, `name`, `price`, `quantity_available`, `quantity_min_limit`, `quantity_max_limit`, `product_category_id`, `picture_id`, `created`, `modified`) VALUES (4, 'beatae', '3314.066352', '2376.820572106', '2592.209206', '92658', 17, 10, '2008-07-03 13:17:04', '1993-09-13 11:34:59');
304INSERT INTO products (`id`, `name`, `price`, `quantity_available`, `quantity_min_limit`, `quantity_max_limit`, `product_category_id`, `picture_id`, `created`, `modified`) VALUES (5, 'labore', '', '58.43', '', '4632', 13, 5, '2002-04-26 20:03:34', '1993-04-13 18:12:19');
305INSERT INTO products (`id`, `name`, `price`, `quantity_available`, `quantity_min_limit`, `quantity_max_limit`, `product_category_id`, `picture_id`, `created`, `modified`) VALUES (6, 'exercitationem', '24', '4113.8', '2361', '81', 15, 17, '2007-11-03 00:33:37', '1985-03-14 06:16:27');
306INSERT INTO products (`id`, `name`, `price`, `quantity_available`, `quantity_min_limit`, `quantity_max_limit`, `product_category_id`, `picture_id`, `created`, `modified`) VALUES (7, 'vel', '5', '19283688.48828', '1619', '8', 7, 14, '2005-01-12 00:01:39', '1970-11-22 10:12:49');
307INSERT INTO products (`id`, `name`, `price`, `quantity_available`, `quantity_min_limit`, `quantity_max_limit`, `product_category_id`, `picture_id`, `created`, `modified`) VALUES (8, 'et', '20785364.8', '1567062.8670872', '24.339523', '3417830', 3, 1, '1974-12-11 21:46:17', '2016-01-15 02:54:00');
308INSERT INTO products (`id`, `name`, `price`, `quantity_available`, `quantity_min_limit`, `quantity_max_limit`, `product_category_id`, `picture_id`, `created`, `modified`) VALUES (9, 'minus', '', '1.5673', '300', '2257', 8, 8, '1973-02-06 00:26:38', '1991-10-05 04:26:07');
309INSERT INTO products (`id`, `name`, `price`, `quantity_available`, `quantity_min_limit`, `quantity_max_limit`, `product_category_id`, `picture_id`, `created`, `modified`) VALUES (10, 'praesentium', '29.31189', '18515350.60334', '389054500.18771', '800023032', 16, 9, '1993-10-25 08:18:21', '2012-04-03 18:20:35');
310INSERT INTO products (`id`, `name`, `price`, `quantity_available`, `quantity_min_limit`, `quantity_max_limit`, `product_category_id`, `picture_id`, `created`, `modified`) VALUES (11, 'voluptate', '13626750.95462', '75767.5902221', '2.89725', '1416', 12, 1, '1980-03-29 08:10:10', '1971-06-22 22:24:26');
311INSERT INTO products (`id`, `name`, `price`, `quantity_available`, `quantity_min_limit`, `quantity_max_limit`, `product_category_id`, `picture_id`, `created`, `modified`) VALUES (12, 'consequatur', '468', '2836.1581', '17944930.987667', '98297', 7, 2, '1994-12-28 11:32:54', '2010-07-18 14:46:19');
312INSERT INTO products (`id`, `name`, `price`, `quantity_available`, `quantity_min_limit`, `quantity_max_limit`, `product_category_id`, `picture_id`, `created`, `modified`) VALUES (13, 'perspiciatis', '124', '4852378.412', '', '1', 12, 11, '1984-07-28 20:15:28', '2013-04-21 00:31:15');
313INSERT INTO products (`id`, `name`, `price`, `quantity_available`, `quantity_min_limit`, `quantity_max_limit`, `product_category_id`, `picture_id`, `created`, `modified`) VALUES (14, 'non', '201.9010569', '56.031', '692', '3062982', 9, 11, '1982-03-05 04:25:15', '2002-06-10 07:12:19');
314INSERT INTO products (`id`, `name`, `price`, `quantity_available`, `quantity_min_limit`, `quantity_max_limit`, `product_category_id`, `picture_id`, `created`, `modified`) VALUES (15, 'voluptatum', '', '28.971', '1537817.1395', '2', 2, 11, '1992-07-18 13:48:10', '2001-08-16 02:42:31');
315INSERT INTO products (`id`, `name`, `price`, `quantity_available`, `quantity_min_limit`, `quantity_max_limit`, `product_category_id`, `picture_id`, `created`, `modified`) VALUES (16, 'accusamus', '5.124773', '4680419.6', '3277.514', '8754', 9, 19, '2017-10-19 06:27:15', '1976-02-20 00:18:18');
316INSERT INTO products (`id`, `name`, `price`, `quantity_available`, `quantity_min_limit`, `quantity_max_limit`, `product_category_id`, `picture_id`, `created`, `modified`) VALUES (17, 'maiores', '3.24', '101812712.89', '3.40326191', '35257920', 6, 6, '2010-11-23 02:24:32', '1971-08-20 18:56:17');
317INSERT INTO products (`id`, `name`, `price`, `quantity_available`, `quantity_min_limit`, `quantity_max_limit`, `product_category_id`, `picture_id`, `created`, `modified`) VALUES (18, 'ut', '52407.972340579', '18362817.844', '', '', 17, 6, '1986-10-28 04:48:42', '1976-09-05 10:04:56');
318INSERT INTO products (`id`, `name`, `price`, `quantity_available`, `quantity_min_limit`, `quantity_max_limit`, `product_category_id`, `picture_id`, `created`, `modified`) VALUES (19, 'quia', '1.3387621', '5.62', '1.9532525', '1636044', 2, 7, '1981-05-14 07:43:44', '2016-03-24 16:40:05');
319INSERT INTO products (`id`, `name`, `price`, `quantity_available`, `quantity_min_limit`, `quantity_max_limit`, `product_category_id`, `picture_id`, `created`, `modified`) VALUES (20, 'aut', '216585', '26.26', '50871.515', '979', 16, 15, '1972-07-16 23:49:43', '1984-02-22 21:38:26');
320
321
322#
323# TABLE STRUCTURE FOR: service_categories
324#
325
326
327CREATE TABLE `service_categories` (
328  `id` int(11) NOT NULL AUTO_INCREMENT,
329  `name` varchar(200) NOT NULL,
330  `enterprise_id` int(11) NOT NULL,
331  `created` datetime NOT NULL,
332  `modified` datetime NOT NULL,
333  PRIMARY KEY (`id`),
334  KEY `BY_ENTERPRISE_ID` (`enterprise_id`),
335  CONSTRAINT `service_categories_ibfk_1` FOREIGN KEY (`enterprise_id`) REFERENCES `enterprises` (`id`)
336) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;
337
338INSERT INTO service_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (1, 'sed', 20, '1972-03-14 16:50:51', '1982-06-22 21:02:47');
339INSERT INTO service_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (2, 'eius', 12, '1980-02-18 22:27:05', '1994-04-26 01:22:38');
340INSERT INTO service_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (3, 'odit', 7, '1995-02-28 01:49:14', '1976-03-14 02:43:22');
341INSERT INTO service_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (4, 'est', 1, '2007-05-12 03:22:05', '1999-07-16 03:14:16');
342INSERT INTO service_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (5, 'fugit', 5, '2004-10-25 16:40:38', '1995-04-19 00:24:01');
343INSERT INTO service_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (6, 'enim', 14, '2015-04-25 14:40:15', '1993-09-08 04:40:50');
344INSERT INTO service_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (7, 'quam', 17, '1972-11-24 04:12:41', '1996-05-20 05:08:02');
345INSERT INTO service_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (8, 'libero', 4, '1977-11-16 02:28:57', '1988-10-20 20:33:44');
346INSERT INTO service_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (9, 'mollitia', 14, '1971-01-08 03:59:56', '1973-10-21 03:34:42');
347INSERT INTO service_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (10, 'debitis', 19, '1980-05-17 00:42:50', '2011-10-23 21:22:18');
348INSERT INTO service_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (11, 'id', 12, '1999-04-10 07:56:46', '1994-10-07 18:17:37');
349INSERT INTO service_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (12, 'perferendis', 9, '1996-12-26 02:52:36', '1980-09-18 04:16:58');
350INSERT INTO service_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (13, 'laborum', 16, '1987-08-09 07:33:02', '1990-02-14 14:28:11');
351INSERT INTO service_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (14, 'accusantium', 2, '1989-04-01 01:25:41', '2010-09-14 21:46:15');
352INSERT INTO service_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (15, 'recusandae', 1, '2009-11-29 14:49:30', '1992-01-17 13:40:46');
353INSERT INTO service_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (16, 'vel', 7, '1975-05-14 19:29:08', '2015-12-15 11:30:54');
354INSERT INTO service_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (17, 'et', 12, '2008-02-04 00:26:07', '2014-07-03 14:28:35');
355INSERT INTO service_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (18, 'illo', 9, '2009-10-24 14:26:09', '1987-04-19 08:37:45');
356INSERT INTO service_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (19, 'provident', 17, '1998-09-04 06:08:51', '1988-11-15 21:45:16');
357INSERT INTO service_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (20, 'iusto', 11, '1978-09-02 19:32:32', '2002-01-31 23:48:56');
358
359
360#
361# TABLE STRUCTURE FOR: services
362#
363
364
365CREATE TABLE `services` (
366  `id` int(11) NOT NULL AUTO_INCREMENT,
367  `name` varchar(255) NOT NULL,
368  `price` varchar(255) NOT NULL,
369  `created` datetime NOT NULL,
370  `modified` datetime NOT NULL,
371  `service_category_id` int(11) NOT NULL,
372  `picture_id` int(11) NOT NULL,
373  PRIMARY KEY (`id`),
374  KEY `BY_SERVICE_CATEGORY_ID` (`service_category_id`),
375  KEY `BY_PICTURE_ID` (`picture_id`),
376  CONSTRAINT `services_ibfk_1` FOREIGN KEY (`service_category_id`) REFERENCES `service_categories` (`id`)
377) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;
378
379INSERT INTO services (`id`, `name`, `price`, `created`, `modified`, `service_category_id`, `picture_id`) VALUES (1, 'quae', '1454.9811', '2001-04-02 21:51:04', '2014-01-28 14:07:23', 8, 9);
380INSERT INTO services (`id`, `name`, `price`, `created`, `modified`, `service_category_id`, `picture_id`) VALUES (2, 'officia', '4.51', '1982-11-05 03:21:54', '2007-07-05 16:55:19', 9, 2);
381INSERT INTO services (`id`, `name`, `price`, `created`, `modified`, `service_category_id`, `picture_id`) VALUES (3, 'nam', '305159014.9632', '2004-07-10 04:50:11', '1982-11-12 15:57:06', 9, 3);
382INSERT INTO services (`id`, `name`, `price`, `created`, `modified`, `service_category_id`, `picture_id`) VALUES (4, 'occaecati', '54844438.18321', '1998-08-09 08:00:58', '1980-01-05 19:42:01', 8, 14);
383INSERT INTO services (`id`, `name`, `price`, `created`, `modified`, `service_category_id`, `picture_id`) VALUES (5, 'non', '', '1984-02-24 22:03:32', '1994-04-29 09:29:41', 18, 18);
384INSERT INTO services (`id`, `name`, `price`, `created`, `modified`, `service_category_id`, `picture_id`) VALUES (6, 'aperiam', '50327482.93', '1981-06-22 06:18:40', '1997-06-25 19:13:50', 17, 3);
385INSERT INTO services (`id`, `name`, `price`, `created`, `modified`, `service_category_id`, `picture_id`) VALUES (7, 'voluptas', '', '2007-07-17 06:45:44', '2013-06-14 22:38:20', 1, 1);
386INSERT INTO services (`id`, `name`, `price`, `created`, `modified`, `service_category_id`, `picture_id`) VALUES (8, 'accusantium', '2357.307357', '1998-05-10 01:05:26', '1977-01-09 01:53:50', 3, 12);
387INSERT INTO services (`id`, `name`, `price`, `created`, `modified`, `service_category_id`, `picture_id`) VALUES (9, 'ut', '47851896', '1985-12-08 23:10:05', '1994-10-25 03:48:10', 9, 13);
388INSERT INTO services (`id`, `name`, `price`, `created`, `modified`, `service_category_id`, `picture_id`) VALUES (10, 'laborum', '431095867.34', '2001-07-05 15:09:47', '1998-10-01 18:26:12', 15, 4);
389INSERT INTO services (`id`, `name`, `price`, `created`, `modified`, `service_category_id`, `picture_id`) VALUES (11, 'consequatur', '7070626.1064694', '1971-04-02 18:27:08', '2015-09-19 05:27:20', 5, 20);
390INSERT INTO services (`id`, `name`, `price`, `created`, `modified`, `service_category_id`, `picture_id`) VALUES (12, 'dignissimos', '32508948.6523', '1983-11-01 13:52:59', '1986-05-25 13:58:21', 19, 10);
391INSERT INTO services (`id`, `name`, `price`, `created`, `modified`, `service_category_id`, `picture_id`) VALUES (13, 'autem', '5.0971758', '1987-08-23 01:11:44', '2017-12-09 22:58:48', 5, 2);
392INSERT INTO services (`id`, `name`, `price`, `created`, `modified`, `service_category_id`, `picture_id`) VALUES (14, 'qui', '1.702', '1983-09-22 11:32:11', '2015-12-06 12:33:21', 16, 3);
393INSERT INTO services (`id`, `name`, `price`, `created`, `modified`, `service_category_id`, `picture_id`) VALUES (15, 'quia', '318.72071', '2009-03-18 03:01:10', '1984-12-05 19:10:02', 14, 10);
394INSERT INTO services (`id`, `name`, `price`, `created`, `modified`, `service_category_id`, `picture_id`) VALUES (16, 'quas', '2009.228103', '2004-12-25 03:46:36', '1985-09-20 11:33:00', 8, 7);
395INSERT INTO services (`id`, `name`, `price`, `created`, `modified`, `service_category_id`, `picture_id`) VALUES (17, 'architecto', '5.3779', '2013-03-31 13:30:20', '1992-01-30 20:40:47', 10, 19);
396INSERT INTO services (`id`, `name`, `price`, `created`, `modified`, `service_category_id`, `picture_id`) VALUES (18, 'deserunt', '1977013.973', '1987-04-22 23:08:31', '1978-07-06 19:31:27', 12, 14);
397INSERT INTO services (`id`, `name`, `price`, `created`, `modified`, `service_category_id`, `picture_id`) VALUES (19, 'beatae', '86985719.7', '1997-04-03 07:59:36', '2005-06-28 08:26:03', 4, 12);
398INSERT INTO services (`id`, `name`, `price`, `created`, `modified`, `service_category_id`, `picture_id`) VALUES (20, 'qui', '1038.016793902', '2017-10-10 13:00:45', '1977-02-15 21:44:13', 12, 9);
399
400
401#
402# TABLE STRUCTURE FOR: supplier_categories
403#
404
405
406CREATE TABLE `supplier_categories` (
407  `id` int(11) NOT NULL AUTO_INCREMENT,
408  `name` varchar(200) NOT NULL,
409  `enterprise_id` int(11) NOT NULL,
410  `created` datetime NOT NULL,
411  `modified` datetime NOT NULL,
412  PRIMARY KEY (`id`),
413  KEY `BY_ENTERPRISE_ID` (`enterprise_id`),
414  CONSTRAINT `supplier_categories_ibfk_1` FOREIGN KEY (`enterprise_id`) REFERENCES `enterprises` (`id`)
415) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;
416
417INSERT INTO supplier_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (1, 'quis', 2, '1982-04-01 03:42:53', '1991-09-15 01:43:31');
418INSERT INTO supplier_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (2, 'placeat', 17, '1973-06-30 00:10:31', '1976-10-04 22:09:29');
419INSERT INTO supplier_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (3, 'deserunt', 7, '2000-05-25 18:08:50', '1980-06-07 02:49:03');
420INSERT INTO supplier_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (4, 'consequuntur', 9, '1971-07-25 04:54:40', '1971-02-25 11:08:01');
421INSERT INTO supplier_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (5, 'minus', 15, '1988-05-01 12:21:30', '1979-04-19 20:04:56');
422INSERT INTO supplier_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (6, 'distinctio', 15, '2010-04-16 14:11:37', '1988-05-27 19:12:57');
423INSERT INTO supplier_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (7, 'laborum', 14, '1970-04-14 12:55:26', '1978-03-12 06:45:01');
424INSERT INTO supplier_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (8, 'deleniti', 17, '1985-11-10 00:26:45', '1984-07-28 22:59:35');
425INSERT INTO supplier_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (9, 'vero', 4, '2016-07-27 08:07:11', '2007-08-05 21:22:40');
426INSERT INTO supplier_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (10, 'quia', 1, '2002-03-16 09:44:46', '1979-07-25 09:32:24');
427INSERT INTO supplier_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (11, 'omnis', 6, '2009-11-18 14:26:12', '2014-12-03 14:49:36');
428INSERT INTO supplier_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (12, 'excepturi', 1, '2002-04-03 19:54:30', '1996-08-12 11:08:27');
429INSERT INTO supplier_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (13, 'id', 14, '1996-07-29 03:33:31', '2016-12-28 15:56:55');
430INSERT INTO supplier_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (14, 'aperiam', 13, '2013-01-02 21:46:46', '1992-05-04 01:06:32');
431INSERT INTO supplier_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (15, 'sapiente', 4, '1971-09-11 01:46:26', '2011-08-22 11:10:40');
432INSERT INTO supplier_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (16, 'quidem', 15, '1982-05-01 18:02:18', '2015-08-10 03:42:49');
433INSERT INTO supplier_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (17, 'quia', 7, '1982-07-11 03:35:17', '1985-02-07 04:49:58');
434INSERT INTO supplier_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (18, 'sapiente', 6, '2005-06-18 12:15:27', '1973-11-06 14:50:33');
435INSERT INTO supplier_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (19, 'sed', 9, '1998-05-31 11:29:03', '2010-09-05 05:13:17');
436INSERT INTO supplier_categories (`id`, `name`, `enterprise_id`, `created`, `modified`) VALUES (20, 'earum', 10, '2011-03-11 04:49:03', '1995-06-15 05:57:55');
437
438
439#
440# TABLE STRUCTURE FOR: suppliers
441#
442
443
444CREATE TABLE `suppliers` (
445  `id` int(11) NOT NULL AUTO_INCREMENT,
446  `name` varchar(255) NOT NULL,
447  `address` text NOT NULL,
448  `created` datetime NOT NULL,
449  `modified` datetime NOT NULL,
450  `supplier_category_id` int(11) NOT NULL,
451  `picture_id` int(11) NOT NULL,
452  PRIMARY KEY (`id`),
453  KEY `BY_SUPPLIER_CATEGORY_ID` (`supplier_category_id`),
454  KEY `BY_PICTURE_ID` (`picture_id`),
455  CONSTRAINT `suppliers_ibfk_1` FOREIGN KEY (`supplier_category_id`) REFERENCES `supplier_categories` (`id`),
456  CONSTRAINT `suppliers_ibfk_2` FOREIGN KEY (`picture_id`) REFERENCES `pictures` (`id`)
457) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;
458
459INSERT INTO suppliers (`id`, `name`, `address`, `created`, `modified`, `supplier_category_id`, `picture_id`) VALUES (1, 'voluptate', '165 Ocie Falls Suite 199\nEast Benjamin, VT 66639-7582', '2014-01-12 17:58:06', '1979-02-23 22:49:42', 4, 4);
460INSERT INTO suppliers (`id`, `name`, `address`, `created`, `modified`, `supplier_category_id`, `picture_id`) VALUES (2, 'ea', '7286 Moore Station\nSouth Thalia, DE 32991-9858', '1992-01-13 09:17:30', '2003-03-21 19:00:36', 15, 4);
461INSERT INTO suppliers (`id`, `name`, `address`, `created`, `modified`, `supplier_category_id`, `picture_id`) VALUES (3, 'ab', '594 Candelario Hollow Apt. 467\nPort Desireeville, IN 41294', '1977-06-11 09:39:01', '2015-10-08 18:45:40', 18, 4);
462INSERT INTO suppliers (`id`, `name`, `address`, `created`, `modified`, `supplier_category_id`, `picture_id`) VALUES (4, 'tenetur', '82573 Cronin Spurs\nMelvinaton, WA 92103', '2006-07-30 15:51:07', '1982-07-01 16:52:26', 18, 10);
463INSERT INTO suppliers (`id`, `name`, `address`, `created`, `modified`, `supplier_category_id`, `picture_id`) VALUES (5, 'harum', '47821 Walsh Fort\nFreddiechester, WI 19022-3538', '2010-10-20 16:12:04', '1980-06-23 02:33:11', 12, 1);
464INSERT INTO suppliers (`id`, `name`, `address`, `created`, `modified`, `supplier_category_id`, `picture_id`) VALUES (6, 'a', '997 Leilani Grove Suite 403\nEulahshire, FL 99093-5155', '2009-03-29 21:56:02', '1984-01-17 06:40:09', 16, 16);
465INSERT INTO suppliers (`id`, `name`, `address`, `created`, `modified`, `supplier_category_id`, `picture_id`) VALUES (7, 'sit', '19671 Edythe Islands Apt. 005\nAustenland, MT 69912-9818', '1980-10-31 06:26:38', '1988-08-02 02:13:49', 9, 19);
466INSERT INTO suppliers (`id`, `name`, `address`, `created`, `modified`, `supplier_category_id`, `picture_id`) VALUES (8, 'at', '482 Ali Way Apt. 707\nNew Mustafa, TX 04039-4206', '2014-05-15 13:52:14', '1970-01-08 04:10:32', 13, 3);
467INSERT INTO suppliers (`id`, `name`, `address`, `created`, `modified`, `supplier_category_id`, `picture_id`) VALUES (9, 'omnis', '77975 Bechtelar Groves Suite 322\nWest Josiahfort, NC 13072', '2007-05-04 13:47:28', '2011-05-03 13:23:12', 17, 8);
468INSERT INTO suppliers (`id`, `name`, `address`, `created`, `modified`, `supplier_category_id`, `picture_id`) VALUES (10, 'velit', '013 Trisha Curve\nPort Darbymouth, MN 05508', '1974-01-21 22:59:07', '2007-01-02 20:09:42', 18, 4);
469INSERT INTO suppliers (`id`, `name`, `address`, `created`, `modified`, `supplier_category_id`, `picture_id`) VALUES (11, 'est', '03196 Koch Hollow Suite 499\nPadbergtown, TX 71706-5120', '1992-09-27 02:40:26', '1980-02-11 20:06:03', 19, 17);
470INSERT INTO suppliers (`id`, `name`, `address`, `created`, `modified`, `supplier_category_id`, `picture_id`) VALUES (12, 'minus', '5320 Catherine Causeway Suite 618\nNorth Olin, CT 20269', '1982-05-07 02:37:54', '2007-08-08 01:45:43', 20, 14);
471INSERT INTO suppliers (`id`, `name`, `address`, `created`, `modified`, `supplier_category_id`, `picture_id`) VALUES (13, 'sed', '43965 Madge Forge\nLake Annetta, NV 69806', '2012-01-14 01:31:35', '1982-07-19 05:15:19', 2, 1);
472INSERT INTO suppliers (`id`, `name`, `address`, `created`, `modified`, `supplier_category_id`, `picture_id`) VALUES (14, 'officiis', '008 Cathrine Lakes\nBaileyfort, FL 80517-0880', '1970-10-14 20:13:03', '1998-05-22 20:27:29', 20, 19);
473INSERT INTO suppliers (`id`, `name`, `address`, `created`, `modified`, `supplier_category_id`, `picture_id`) VALUES (15, 'fuga', '0358 Bauch Oval Suite 600\nEloiseland, NH 24722-8660', '1999-09-18 07:24:10', '1992-11-18 23:58:07', 10, 3);
474INSERT INTO suppliers (`id`, `name`, `address`, `created`, `modified`, `supplier_category_id`, `picture_id`) VALUES (16, 'et', '67462 Hudson Glen Apt. 326\nFramitown, IA 15332-2436', '1975-01-22 18:24:46', '1976-04-07 02:34:34', 8, 10);
475INSERT INTO suppliers (`id`, `name`, `address`, `created`, `modified`, `supplier_category_id`, `picture_id`) VALUES (17, 'fuga', '26854 Gleichner Shoal\nWittingside, PA 99129-2807', '2002-10-30 06:26:58', '1989-08-29 07:50:28', 18, 5);
476INSERT INTO suppliers (`id`, `name`, `address`, `created`, `modified`, `supplier_category_id`, `picture_id`) VALUES (18, 'laborum', '059 Annabelle Green\nArlieshire, AR 46861-2357', '2014-04-10 15:22:42', '1974-10-24 11:05:22', 7, 14);
477INSERT INTO suppliers (`id`, `name`, `address`, `created`, `modified`, `supplier_category_id`, `picture_id`) VALUES (19, 'et', '5239 Reanna Camp Apt. 214\nNorth Marcellaport, MS 00694', '2011-03-10 06:37:37', '2001-08-14 08:19:49', 3, 20);
478INSERT INTO suppliers (`id`, `name`, `address`, `created`, `modified`, `supplier_category_id`, `picture_id`) VALUES (20, 'enim', '12735 Princess Lakes\nCarolynfort, DC 55295', '1991-05-01 19:49:02', '2010-05-03 07:45:09', 1, 10);
479
480
481#
482# TABLE STRUCTURE FOR: user_rentals
483#
484
485-- DROP TABLE IF EXISTS user_rentals;
486-- 
487-- CREATE ALGORITHM=UNDEFINED DEFINER=`u574849695_8`@`10.2.1.33` SQL SECURITY DEFINER VIEW `user_rentals` AS select 1 AS `userId`;
488-- 
489-- utf8_general_ci;
490-- 
491-- INSERT INTO user_rentals (`userId`) VALUES (1);