31qs4mfS

1-- Generation time: Mon, 17 Aug 2020 19:34:32 +0000
2-- Host: mysql.hostinger.ro
3-- DB name: u574849695_17
4/*!40030 SET NAMES UTF8 */;
5/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
6/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
7/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
8/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
9/*!40103 SET TIME_ZONE='+00:00' */;
10/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
11/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
12/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
13/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
14
15DROP TABLE IF EXISTS `brands`;
16CREATE TABLE `brands` (
17  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
18  `name` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
19  `owner_id` int(10) unsigned DEFAULT NULL,
20  PRIMARY KEY (`id`),
21  UNIQUE KEY `id` (`id`),
22  KEY `brands_ibfk_1` (`owner_id`),
23  CONSTRAINT `brands_ibfk_1` FOREIGN KEY (`owner_id`) REFERENCES `clients` (`id`)
24) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
25
26INSERT INTO `brands` VALUES ('1','ducimus','101'),
27('2','quaerat','102'),
28('3','temporibus','104'),
29('4','et','106'),
30('5','temporibus','109'),
31('6','rerum','110'),
32('7','id','115'),
33('8','a','116'),
34('9','doloremque','118'),
35('10','laborum','119'),
36('11','ratione','120'),
37('12','nesciunt','121'),
38('13','perferendis','125'),
39('14','ipsam','127'),
40('15','ad','130'),
41('16','nulla','135'),
42('17','est','137'),
43('18','in','139'),
44('19','modi','140'),
45('20','nihil','141'),
46('21','dolorem','142'),
47('22','at','147'),
48('23','est','148'),
49('24','voluptas','149'),
50('25','officia','151'); 
51
52
53DROP TABLE IF EXISTS `client_orders`;
54CREATE TABLE `client_orders` (
55  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
56  `client_id` int(10) unsigned DEFAULT NULL,
57  `manager_id` bigint(20) unsigned DEFAULT NULL,
58  `date_start` datetime DEFAULT current_timestamp(),
59  `date_end` datetime DEFAULT NULL,
60  PRIMARY KEY (`id`),
61  UNIQUE KEY `id` (`id`),
62  KEY `client_orders_ibfk_1` (`client_id`),
63  KEY `client_orders_ibfk_2` (`manager_id`),
64  CONSTRAINT `client_orders_ibfk_1` FOREIGN KEY (`client_id`) REFERENCES `clients` (`id`),
65  CONSTRAINT `client_orders_ibfk_2` FOREIGN KEY (`manager_id`) REFERENCES `managers` (`id`)
66) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
67
68INSERT INTO `client_orders` VALUES ('1','101','1','1999-09-09 00:00:00','1992-12-28 00:00:00'),
69('2','102','2','2010-08-15 00:00:00','1971-08-21 00:00:00'),
70('3','104','3','1986-10-25 00:00:00','1987-08-08 00:00:00'),
71('4','106','4','2018-04-12 00:00:00','2001-06-07 00:00:00'),
72('5','109','5','1991-03-29 00:00:00','1975-06-22 00:00:00'),
73('6','110','6','1979-03-22 00:00:00','1984-10-07 00:00:00'),
74('7','115','7','1978-09-05 00:00:00','2011-12-27 00:00:00'),
75('8','116','8','2004-03-22 00:00:00','1976-11-22 00:00:00'),
76('9','118','9','1982-05-03 00:00:00','1997-10-05 00:00:00'),
77('10','119','10','2006-01-07 00:00:00','1983-11-03 00:00:00'),
78('11','120','11','2011-06-12 00:00:00','2004-06-10 00:00:00'),
79('12','121','12','2010-12-10 00:00:00','2007-01-01 00:00:00'),
80('13','125','13','2014-12-28 00:00:00','1995-03-19 00:00:00'),
81('14','127','14','1989-11-19 00:00:00','2020-04-12 00:00:00'),
82('15','130','15','1996-09-16 00:00:00','2011-06-30 00:00:00'),
83('16','135','16','1975-01-30 00:00:00','1992-06-18 00:00:00'),
84('17','137','17','1980-12-31 00:00:00','1982-10-24 00:00:00'),
85('18','139','18','2011-09-23 00:00:00','1995-09-12 00:00:00'),
86('19','140','19','1970-01-31 00:00:00','2018-05-29 00:00:00'),
87('20','141','20','2012-12-30 00:00:00','1978-08-20 00:00:00'),
88('21','142','21','1990-05-15 00:00:00','2004-02-15 00:00:00'),
89('22','147','22','1972-10-31 00:00:00','2014-04-11 00:00:00'),
90('23','148','23','1985-07-02 00:00:00','2009-06-13 00:00:00'),
91('24','149','24','2014-09-08 00:00:00','1976-12-02 00:00:00'),
92('25','151','25','1981-03-09 00:00:00','1972-11-08 00:00:00'),
93('26','152','26','1977-01-29 00:00:00','1998-08-14 00:00:00'),
94('27','153','27','1977-03-14 00:00:00','2019-02-01 00:00:00'),
95('28','159','28','2010-09-10 00:00:00','1980-03-24 00:00:00'),
96('29','160','29','2008-06-23 00:00:00','1973-08-25 00:00:00'),
97('30','162','30','2008-07-24 00:00:00','1972-09-28 00:00:00'),
98('31','163','31','1993-08-11 00:00:00','1970-08-11 00:00:00'),
99('32','165','32','2008-03-18 00:00:00','1975-12-04 00:00:00'),
100('33','170','33','2012-08-20 00:00:00','2010-04-08 00:00:00'),
101('34','173','34','1992-02-23 00:00:00','1995-01-04 00:00:00'),
102('35','175','35','2014-11-27 00:00:00','2002-08-02 00:00:00'),
103('36','178','36','2005-11-02 00:00:00','1998-12-06 00:00:00'),
104('37','188','37','1970-06-16 00:00:00','1984-09-04 00:00:00'),
105('38','192','38','2015-06-20 00:00:00','2008-06-28 00:00:00'),
106('39','194','39','2020-04-27 00:00:00','2011-08-14 00:00:00'),
107('40','195','40','2017-02-26 00:00:00','2020-05-13 00:00:00'),
108('41','196','41','1990-04-10 00:00:00','1982-01-30 00:00:00'),
109('42','197','42','2009-12-23 00:00:00','2015-11-15 00:00:00'),
110('43','198','43','1973-04-07 00:00:00','1970-06-14 00:00:00'),
111('44','199','44','1986-12-28 00:00:00','1971-02-28 00:00:00'),
112('45','200','45','1977-05-26 00:00:00','1996-01-19 00:00:00'),
113('46','101','46','1976-01-29 00:00:00','1987-05-06 00:00:00'),
114('47','102','47','2012-01-10 00:00:00','2001-04-01 00:00:00'),
115('48','104','48','1999-05-11 00:00:00','1971-04-03 00:00:00'),
116('49','106','49','1979-04-10 00:00:00','1984-12-12 00:00:00'),
117('50','109','50','1998-11-12 00:00:00','2010-01-07 00:00:00'),
118('51','110','51','2007-07-15 00:00:00','1980-03-20 00:00:00'),
119('52','115','52','2007-06-27 00:00:00','2005-04-05 00:00:00'),
120('53','116','53','1979-10-17 00:00:00','2004-09-27 00:00:00'),
121('54','118','54','1991-09-23 00:00:00','1976-04-06 00:00:00'),
122('55','119','55','2002-11-24 00:00:00','2009-11-25 00:00:00'),
123('56','120','56','1999-05-30 00:00:00','1988-05-25 00:00:00'),
124('57','121','57','1997-12-13 00:00:00','1978-12-25 00:00:00'),
125('58','125','58','2004-06-19 00:00:00','1990-07-23 00:00:00'),
126('59','127','59','1988-12-23 00:00:00','1995-12-11 00:00:00'),
127('60','130','60','1979-08-26 00:00:00','2007-12-04 00:00:00'),
128('61','135','61','1987-06-10 00:00:00','2008-09-16 00:00:00'),
129('62','137','62','1983-08-27 00:00:00','2019-02-01 00:00:00'),
130('63','139','63','1997-11-24 00:00:00','1996-11-19 00:00:00'),
131('64','140','64','2009-08-28 00:00:00','2000-08-03 00:00:00'),
132('65','141','65','1992-11-18 00:00:00','1987-09-03 00:00:00'),
133('66','142','66','1970-03-14 00:00:00','1985-06-25 00:00:00'),
134('67','147','67','1979-12-07 00:00:00','1973-01-03 00:00:00'),
135('68','148','68','2011-05-08 00:00:00','1970-12-12 00:00:00'),
136('69','149','69','1971-10-23 00:00:00','1988-06-19 00:00:00'),
137('70','151','70','1998-10-06 00:00:00','1973-04-14 00:00:00'),
138('71','152','71','2018-02-26 00:00:00','1971-09-21 00:00:00'),
139('72','153','72','1984-07-14 00:00:00','1998-04-03 00:00:00'),
140('73','159','73','1998-10-06 00:00:00','2013-11-22 00:00:00'),
141('74','160','74','2009-07-31 00:00:00','2003-01-30 00:00:00'),
142('75','162','75','1978-04-17 00:00:00','2018-07-25 00:00:00'),
143('76','163','76','1970-10-04 00:00:00','1985-09-07 00:00:00'),
144('77','165','77','1979-07-03 00:00:00','1982-02-02 00:00:00'),
145('78','170','78','2006-08-19 00:00:00','2001-01-30 00:00:00'),
146('79','173','79','2005-09-07 00:00:00','2014-01-26 00:00:00'),
147('80','175','80','2020-05-10 00:00:00','1988-03-14 00:00:00'),
148('81','178','81','2003-03-18 00:00:00','2007-01-05 00:00:00'),
149('82','188','82','2016-08-26 00:00:00','2011-01-04 00:00:00'),
150('83','192','83','1995-09-04 00:00:00','1993-08-02 00:00:00'),
151('84','194','84','1990-11-13 00:00:00','1995-06-14 00:00:00'),
152('85','195','85','1970-01-12 00:00:00','2001-12-24 00:00:00'),
153('86','196','86','1997-01-31 00:00:00','2014-04-18 00:00:00'),
154('87','197','87','2010-06-08 00:00:00','1993-04-12 00:00:00'),
155('88','198','88','1985-10-15 00:00:00','2010-10-07 00:00:00'),
156('89','199','89','1979-08-23 00:00:00','1972-02-03 00:00:00'),
157('90','200','90','2005-08-10 00:00:00','1979-09-01 00:00:00'),
158('91','101','91','2014-08-19 00:00:00','2000-12-28 00:00:00'),
159('92','102','92','1972-01-27 00:00:00','1991-02-23 00:00:00'),
160('93','104','93','2013-01-30 00:00:00','1980-10-16 00:00:00'),
161('94','106','94','1999-05-11 00:00:00','2002-06-22 00:00:00'),
162('95','109','95','2013-04-19 00:00:00','1987-03-11 00:00:00'),
163('96','110','96','2017-04-21 00:00:00','1985-02-25 00:00:00'),
164('97','115','97','1987-11-02 00:00:00','1992-02-19 00:00:00'),
165('98','116','98','2016-03-04 00:00:00','2009-08-27 00:00:00'),
166('99','118','99','1977-12-24 00:00:00','2013-10-03 00:00:00'),
167('100','119','100','1983-05-03 00:00:00','2002-08-10 00:00:00'); 
168
169
170DROP TABLE IF EXISTS `clients`;
171CREATE TABLE `clients` (
172  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
173  `inn` int(10) unsigned DEFAULT NULL,
174  `type_legal_entity` bigint(20) unsigned DEFAULT NULL,
175  `name` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
176  `contract` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
177  `description` text COLLATE utf8_unicode_ci DEFAULT NULL,
178  PRIMARY KEY (`id`),
179  UNIQUE KEY `inn` (`inn`),
180  KEY `clients_ibfk_1` (`type_legal_entity`),
181  CONSTRAINT `clients_ibfk_1` FOREIGN KEY (`type_legal_entity`) REFERENCES `legal_entity` (`id`)
182) ENGINE=InnoDB AUTO_INCREMENT=201 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
183
184INSERT INTO `clients` VALUES ('101','4294967295','1','aut',NULL,'Laudantium a similique optio laudantium cum sint quo. Atque veritatis sed voluptas. Quas qui quo repellendus. Voluptates et sunt ullam.'),
185('102','3853558624','2','repudiandae',NULL,'Aliquam est explicabo quo beatae tempore qui. In deleniti dolores consequuntur sed omnis maiores autem. Ut unde consequuntur qui itaque rerum.'),
186('104','1348619634','1','aut',NULL,'Asperiores adipisci quo ratione fugit. Facilis totam enim voluptas est laboriosam. Aliquam aut qui omnis vel ut quod.'),
187('106','2367124205','3','enim',NULL,'Quidem cum illum debitis natus eum quia sed. Est quia ad et quas. Aut in voluptas vel reprehenderit. Voluptatum ullam eius et laboriosam nulla sit.'),
188('109','2461081279','3','fugit',NULL,'Quia odit incidunt nihil temporibus blanditiis rerum numquam dolorem. Ipsum nam fugiat omnis labore voluptates quasi. Molestias explicabo asperiores qui autem et modi. Est ut asperiores ipsum commodi.'),
189('110','1637656088','1','ut',NULL,'Qui placeat modi qui dignissimos harum earum. Iusto quo quod est. Voluptatem sit sed quae est. Quia qui repellat omnis aut.'),
190('115','1262559927','3','et',NULL,'Asperiores maxime ullam deserunt aut vel explicabo. Dicta pariatur aliquam expedita autem earum recusandae libero. Recusandae esse molestias illo tempora consectetur vero velit. Ut deleniti voluptatem esse aut enim.'),
191('116','1629309132','1','sapiente',NULL,'Omnis nulla qui quis dolore odit. Quos iste officia ut sunt molestiae distinctio eos. Perspiciatis ut nobis culpa corrupti.'),
192('118','3526923983','3','veritatis',NULL,'Laudantium dicta sit sed et. Dolore praesentium quia deleniti eum delectus. Quod quisquam possimus quam sit ipsam sequi.'),
193('119','3636451309','1','consequatur',NULL,'Est consectetur nihil provident excepturi et quaerat iusto illo. Enim praesentium possimus sed consequatur dolor ipsum. Assumenda dolorem vel quo aperiam quia et. Minus quo corporis cupiditate excepturi.'),
194('120','1131204768','2','quo',NULL,'Quidem nisi hic nisi. Sit alias veniam maiores corrupti molestiae inventore. Sit quisquam ut dolores. Ea maiores ut est neque aspernatur.'),
195('121','3554584760','3','quaerat',NULL,'Qui quidem sed mollitia corrupti ut aspernatur ut. Ut amet alias doloribus consectetur aut harum est libero. Consequatur quia quia illo ut et temporibus ab.'),
196('125','3889498801','1','et',NULL,'Sint ipsum illum magnam laudantium natus aut possimus. Sit velit voluptatem non et. Repudiandae quae repudiandae eos aspernatur odio omnis quia.'),
197('127','3473279699','3','odio',NULL,'Quidem consequatur excepturi voluptatem. Omnis quam voluptatem ut nihil modi fuga dolores. Odit qui et cupiditate ut totam cupiditate dolor.'),
198('130','1895998467','3','veniam',NULL,'Quia vel quia magnam est. Consequatur nisi aliquam molestias est. Dolores facilis asperiores rerum sit eum voluptas mollitia. Voluptatem itaque et rerum fuga sapiente maiores sed.'),
199('135','2918647908','2','ex',NULL,'Id voluptatum voluptatum eaque consequatur voluptatum ipsum consequatur. Adipisci voluptatum modi est sed sed ut sunt.'),
200('137','1255485965','1','nemo',NULL,'Cumque totam doloribus dolores non ex. Rerum aut sequi odit incidunt impedit odit ipsa nemo. Modi unde repellendus sunt quos et dolores sit sequi. Quis saepe excepturi a sint libero laboriosam.'),
201('139','2657282339','3','est',NULL,'Assumenda mollitia architecto sed sed. Magni est ullam esse quos. Consequatur qui in porro aut eum.'),
202('140','1282700312','1','in',NULL,'Corporis exercitationem nihil ex fuga qui. Magnam sint rerum inventore rerum officia corporis qui. Eveniet ut ab cum praesentium placeat. Qui rem ut id rerum sit.'),
203('141','3262971784','2','fugiat',NULL,'Est aspernatur voluptatem eum a saepe iusto aliquid voluptatem. Ab velit sit atque iusto sit. Quidem impedit nihil rerum accusamus. Perferendis et vero delectus labore ut facere.'),
204('142','2702506267','3','nemo',NULL,'Iusto et reprehenderit sunt tempore et. Provident voluptate et aperiam qui debitis. Iste illo ab qui natus quidem ex. Magnam aut placeat aut officiis quis ut natus.'),
205('147','2338177896','2','omnis',NULL,'Inventore quis vero in ipsam totam eum quia. Aut maxime unde omnis ut. Soluta nulla perspiciatis ut. Voluptate aliquam possimus nostrum eveniet qui aperiam rerum.'),
206('148','4205422686','3','voluptatem',NULL,'Dolores inventore molestias quibusdam qui omnis reiciendis temporibus. Consequuntur aut eius vitae animi exercitationem ab. Eius aperiam aut aut aut aut. Voluptatum illum placeat explicabo laborum magni nobis accusantium. Nemo incidunt nobis illo qui enim quisquam.'),
207('149','2535166326','1','exercitationem',NULL,'In tempore et sed minus voluptatibus animi quis et. Rerum autem et non aut. Ut et voluptatibus ea magnam quisquam.'),
208('151','3698573037','3','ipsum',NULL,'Velit rerum quisquam aliquam et eos aut. Ducimus hic sunt id repellat necessitatibus praesentium voluptas delectus.'),
209('152','3721111267','1','omnis',NULL,'Sint voluptas sunt aut id autem. Mollitia quidem alias rem cupiditate necessitatibus. Ut sequi est eos et at fugit. Consequuntur similique eos temporibus esse corrupti. Delectus quidem nobis omnis qui.'),
210('153','3899961987','2','tempora',NULL,'Provident eos incidunt dolores numquam molestiae quam soluta. Cum ut a voluptas minima quia et modi. Officia explicabo aut ex sed est. Et pariatur aut libero at perferendis dolore dolor. Mollitia aliquid dolor necessitatibus magni rerum quasi nobis.'),
211('159','1739920431','2','quidem',NULL,'Est aut aut omnis unde dolores et commodi. Fuga esse a debitis est. Aut non sint ullam distinctio.'),
212('160','3711559035','3','accusantium',NULL,'Sit nemo voluptatem dicta. Assumenda molestiae atque occaecati voluptatum et. A accusantium vel deleniti iusto.'),
213('162','3399561684','2','et',NULL,'Qui molestiae ut et facilis debitis. Officiis repellendus saepe excepturi. Qui aut natus excepturi nam. Eos qui enim aut cum ut molestiae voluptatem.'),
214('163','3092434948','3','eum',NULL,'Ut ut iste harum qui provident repudiandae. Distinctio facilis et ea in dolores. Inventore et reprehenderit non est unde et corrupti.'),
215('165','1619523068','2','enim',NULL,'Ut et illum vero maiores eveniet. Inventore sapiente praesentium sint exercitationem et sed. Accusamus ut quis nostrum qui animi odit sapiente. Dicta voluptas et ea excepturi incidunt asperiores distinctio.'),
216('170','3311170012','1','asperiores',NULL,'Voluptatem quibusdam autem voluptatem magnam. Qui facilis expedita quam. Dolorem rerum sed in. Libero voluptas dolores sunt tenetur.'),
217('173','2263174810','1','ratione',NULL,'Aut esse sunt voluptatem vel itaque. Provident quia eius voluptatem sed sed vitae iure. Occaecati officiis consequatur eligendi quis voluptatem cumque consectetur.'),
218('175','1416963802','3','corporis',NULL,'Ut nihil occaecati quia pariatur dolorum qui aperiam nobis. Pariatur eum recusandae eum magni dignissimos minima ullam qui. Aut consectetur ratione quo aliquid omnis perspiciatis. Voluptas aliquam id libero quisquam id iure natus ab.'),
219('178','1645212740','3','qui',NULL,'Tenetur et placeat aliquam autem possimus. Beatae perspiciatis et voluptas est. Et nam commodi ut molestiae quasi sit. Aliquam amet aut quis sapiente et. Molestias laboriosam veniam qui sit.'),
220('188','3995278481','1','dolor',NULL,'Delectus delectus omnis aliquam voluptates soluta incidunt. Numquam fugiat esse impedit sed vitae voluptate molestiae. Totam est illum quibusdam temporibus qui. Labore quidem provident est qui odit omnis distinctio.'),
221('192','3426142297','2','a',NULL,'Odio vel asperiores dolor et est nam. Saepe beatae rerum molestias. Est sunt eveniet rem veritatis facere laboriosam veniam. Aut consequuntur esse sit vero accusamus officiis autem. Debitis cum voluptatem facere nihil et consectetur.'),
222('194','3678836441','1','incidunt',NULL,'Odit velit et aut aliquam nam laudantium sint. Autem est tenetur ut rerum asperiores nihil aut.'),
223('195','3015162121','2','quia',NULL,'Voluptatem sed id ut et consequatur facilis. Eius qui eaque voluptates eveniet ut. Cumque nemo eaque dolorem qui consectetur dolorem. Et blanditiis possimus illum hic cum tempore minima tempora.'),
224('196','1559890322','3','et',NULL,'Delectus ad omnis minus delectus. Vel mollitia saepe voluptatibus doloribus. Cupiditate qui delectus quo deserunt.'),
225('197','1115004457','1','ut',NULL,'Ea voluptates accusamus voluptas et nulla saepe sint. Harum dicta consectetur vitae. Ex suscipit in ducimus in. Blanditiis accusantium blanditiis qui qui et et sapiente non. Atque ut repudiandae cum nulla atque architecto.'),
226('198','1836918352','2','culpa',NULL,'Dignissimos reiciendis minus rerum ea saepe dolore iusto. Delectus perspiciatis harum ea velit ipsam. Nesciunt autem deserunt vel laboriosam sunt. Ea sit quibusdam eligendi consectetur officiis quo.'),
227('199','4293380449','3','libero',NULL,'Aperiam dicta dolore voluptates non nemo consectetur. Fugit odit nesciunt aliquid veritatis veniam. Omnis id voluptatibus eaque quia voluptas. Voluptatem ut nostrum veniam ipsam. Id doloribus amet ipsam omnis voluptatibus officiis.'),
228('200','2410296300','1','enim',NULL,'Commodi asperiores distinctio voluptates dicta sed. Aut a ipsam veniam eum. Et aliquid provident accusantium dolore minus.'); 
229
230
231DROP TABLE IF EXISTS `legal_entity`;
232CREATE TABLE `legal_entity` (
233  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
234  `name` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
235  PRIMARY KEY (`id`),
236  UNIQUE KEY `id` (`id`)
237) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
238
239INSERT INTO `legal_entity` VALUES ('1','ИП'),
240('2','ПАО'),
241('3','ООО'); 
242
243
244DROP TABLE IF EXISTS `managers`;
245CREATE TABLE `managers` (
246  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
247  `first_name` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
248  `last_name` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
249  `position` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
250  `department` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
251  PRIMARY KEY (`id`),
252  UNIQUE KEY `id` (`id`)
253) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
254
255INSERT INTO `managers` VALUES ('1','Christ','Sipes','Начальник','Финансовый отдел'),
256('2','Freda','Crona','Начальник','СЭБ'),
257('3','Magdalen','Hansen','Начальник','Бухгалтерия'),
258('4','Bernhard','Howell','Начальник','Бухгалтерия'),
259('5','Alvera','Beahan','Менеджер','Бухгалтерия'),
260('6','Hassie','McKenzie','Менеджер','Бухгалтерия'),
261('7','Gussie','Mayert','Менеджер','Финансовый отдел'),
262('8','Beth','Wunsch','Менеджер','СЭБ'),
263('9','Ivah','Heaney','Менеджер','Бухгалтерия'),
264('10','Lamont','Koss','Начальник','СЭБ'),
265('11','Tobin','Koch','Начальник','Отдел закупок'),
266('12','Zack','Steuber','Начальник','Бухгалтерия'),
267('13','Brennan','Jakubowski','Менеджер','Отдел закупок'),
268('14','Aurelie','Ondricka','Начальник','Бухгалтерия'),
269('15','Robyn','Konopelski','Менеджер','Отдел закупок'),
270('16','Kevon','Franecki','Менеджер','Бухгалтерия'),
271('17','Lillie','Considine','Начальник','Отдел закупок'),
272('18','Reggie','Boehm','Начальник','Бухгалтерия'),
273('19','Ezequiel','Hagenes','Начальник','Отдел закупок'),
274('20','Florine','Glover','Начальник','Бухгалтерия'),
275('21','Jalon','Braun','Менеджер','СЭБ'),
276('22','Stephany','Hansen','Менеджер','Бухгалтерия'),
277('23','Nelda','O\'Conner','Менеджер','СЭБ'),
278('24','Kristofer','Pfannerstill','Начальник','Отдел закупок'),
279('25','Madonna','Bergnaum','Менеджер','Отдел закупок'),
280('26','Melyna','McLaughlin','Начальник','СЭБ'),
281('27','Flavie','Gerhold','Менеджер','Отдел закупок'),
282('28','Myrtis','Murazik','Менеджер','Финансовый отдел'),
283('29','Ona','Mosciski','Начальник','Отдел закупок'),
284('30','Flo','Strosin','Начальник','Бухгалтерия'),
285('31','Odie','Pouros','Менеджер','Финансовый отдел'),
286('32','Josie','Romaguera','Начальник','Финансовый отдел'),
287('33','Shyanne','Littel','Менеджер','Бухгалтерия'),
288('34','Nona','Doyle','Менеджер','СЭБ'),
289('35','Jordi','Ward','Начальник','Финансовый отдел'),
290('36','Elody','Buckridge','Начальник','Бухгалтерия'),
291('37','Tyson','Dibbert','Начальник','Отдел закупок'),
292('38','Brionna','Osinski','Менеджер','СЭБ'),
293('39','Holden','Konopelski','Начальник','Финансовый отдел'),
294('40','Winfield','Bashirian','Начальник','Отдел закупок'),
295('41','Mafalda','Hessel','Менеджер','Отдел закупок'),
296('42','Everett','Dickinson','Менеджер','Финансовый отдел'),
297('43','Macy','Haley','Начальник','СЭБ'),
298('44','Ethel','McKenzie','Менеджер','Отдел закупок'),
299('45','Hubert','Emard','Начальник','Бухгалтерия'),
300('46','Dora','Grant','Начальник','СЭБ'),
301('47','Felicita','Casper','Менеджер','Финансовый отдел'),
302('48','Gretchen','Satterfield','Начальник','СЭБ'),
303('49','Tyshawn','Murazik','Начальник','Отдел закупок'),
304('50','Reece','O\'Conner','Менеджер','Финансовый отдел'),
305('51','Bud','Rohan','Менеджер','Финансовый отдел'),
306('52','Norbert','Pacocha','Менеджер','Финансовый отдел'),
307('53','Stacey','Upton','Начальник','Бухгалтерия'),
308('54','Otilia','Fisher','Менеджер','Бухгалтерия'),
309('55','Neil','Runte','Менеджер','Финансовый отдел'),
310('56','Elvera','Herzog','Менеджер','Финансовый отдел'),
311('57','Mercedes','Price','Начальник','Бухгалтерия'),
312('58','Miguel','Goldner','Менеджер','Отдел закупок'),
313('59','Cade','Reichert','Менеджер','Финансовый отдел'),
314('60','Kariane','Wintheiser','Менеджер','Финансовый отдел'),
315('61','Mary','Lehner','Менеджер','Отдел закупок'),
316('62','Dulce','West','Начальник','Финансовый отдел'),
317('63','Teresa','Hermiston','Менеджер','Отдел закупок'),
318('64','Ivah','Kihn','Менеджер','Отдел закупок'),
319('65','Chester','Kub','Начальник','СЭБ'),
320('66','Geovanni','Grady','Начальник','Бухгалтерия'),
321('67','Deshawn','Predovic','Менеджер','Бухгалтерия'),
322('68','Carley','Vandervort','Менеджер','Финансовый отдел'),
323('69','Alvah','Wolf','Менеджер','СЭБ'),
324('70','Colin','Mayert','Менеджер','Финансовый отдел'),
325('71','Jaren','Bednar','Менеджер','СЭБ'),
326('72','Tessie','Huel','Начальник','Финансовый отдел'),
327('73','Alexander','Tromp','Начальник','Бухгалтерия'),
328('74','Ashley','Kunze','Начальник','Финансовый отдел'),
329('75','Janae','Bogan','Начальник','Бухгалтерия'),
330('76','Ozella','King','Менеджер','Отдел закупок'),
331('77','Jacklyn','Brekke','Начальник','Финансовый отдел'),
332('78','Anabel','Schinner','Менеджер','СЭБ'),
333('79','Johnson','Rippin','Начальник','СЭБ'),
334('80','Zoey','Bogan','Начальник','Финансовый отдел'),
335('81','Rowan','Windler','Начальник','СЭБ'),
336('82','Theodore','McCullough','Начальник','Бухгалтерия'),
337('83','Maurice','Hickle','Начальник','Бухгалтерия'),
338('84','Cristal','Brekke','Менеджер','Отдел закупок'),
339('85','Loraine','Hegmann','Начальник','СЭБ'),
340('86','Bulah','Bailey','Менеджер','СЭБ'),
341('87','Loy','Bauch','Менеджер','СЭБ'),
342('88','Ana','Gottlieb','Начальник','СЭБ'),
343('89','Jaycee','Reynolds','Менеджер','Бухгалтерия'),
344('90','Pasquale','Spencer','Менеджер','Финансовый отдел'),
345('91','Magnolia','Morissette','Менеджер','Отдел закупок'),
346('92','Freida','Nienow','Менеджер','Финансовый отдел'),
347('93','Assunta','Will','Начальник','Бухгалтерия'),
348('94','Katelin','Brown','Менеджер','Финансовый отдел'),
349('95','Maiya','Ernser','Начальник','СЭБ'),
350('96','Kendrick','Jakubowski','Начальник','Финансовый отдел'),
351('97','Carter','Pollich','Менеджер','Финансовый отдел'),
352('98','Hassie','Rutherford','Начальник','СЭБ'),
353('99','Katarina','Abbott','Начальник','Отдел закупок'),
354('100','Donnell','Bechtelar','Начальник','Отдел закупок'); 
355
356
357DROP TABLE IF EXISTS `product_composition`;
358CREATE TABLE `product_composition` (
359  `product_id` bigint(20) unsigned NOT NULL,
360  `raw_id` bigint(20) unsigned NOT NULL,
361  `count_prod` int(10) unsigned DEFAULT NULL,
362  `count_raw` float DEFAULT NULL,
363  `cost_raw` float DEFAULT NULL,
364  PRIMARY KEY (`product_id`,`raw_id`),
365  KEY `product_composition_ibfk_2` (`raw_id`),
366  CONSTRAINT `product_composition_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`),
367  CONSTRAINT `product_composition_ibfk_2` FOREIGN KEY (`raw_id`) REFERENCES `raw` (`id`)
368) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
369
370INSERT INTO `product_composition` VALUES ('1','1','100','193068','0'),
371('2','2','100000','8251600','534768000'),
372('3','3','1000','28082','35'),
373('4','4','100000','3372','96501400'),
374('5','5','1000','393033','71715'),
375('6','6','100000','15722500','0.73734'),
376('7','7','1000','3779480','4265.49'),
377('8','8','100000','745566','50.54'),
378('9','9','100','35','577.9'),
379('10','10','100000','5','2112100'),
380('11','11','100','114754000','7'),
381('12','12','1000','996619','45.3515'),
382('13','13','100','0','612.229'),
383('14','14','100000','6','45249500'),
384('15','15','100','403','278922000'),
385('16','16','100','45980800','0'),
386('17','17','100000','199884','193.49'),
387('18','18','1000','0','4445.26'),
388('19','19','1000','8855','4395.95'),
389('20','20','100000','28162','1125720'),
390('21','21','100','64170100','571256'),
391('22','22','1000','603481','203937000'),
392('23','23','100000','108462','0'),
393('24','24','1000','0','7138220'),
394('25','25','100','2155','1.9194'),
395('26','26','100','53','2.21065'),
396('27','27','100000','8880','261885000'),
397('28','28','1000','99474','0'),
398('29','29','100000','7','34'),
399('30','30','100','87402','907171'),
400('31','31','1000','131356000','43.87'),
401('32','32','100000','9','56.3792'),
402('33','33','100000','892','5'),
403('34','34','1000','5','52.0524'),
404('35','35','1000','0','162458'),
405('36','36','100000','53','56635.4'),
406('37','37','100000','32','3347560'),
407('38','38','100000','4227480','5849.09'),
408('39','39','1000','475','28075.9'),
409('40','40','100000','740337','706964'),
410('41','41','1000','265','44.623'),
411('42','42','100','71160300','1.37'),
412('43','43','100','1','61.4698'),
413('44','44','100','3075140','3.71767'),
414('45','45','100','9370910','525069'),
415('46','46','100000','609','2.05937'),
416('47','47','1000','154314000','2967470'),
417('48','48','100000','830324000','1055000'),
418('49','49','100000','401251000','5.519'),
419('50','50','100000','437','173.724'),
420('51','51','100000','2764000','1119.96'),
421('52','52','100000','723837000','0'),
422('53','53','1000','2338','159.573'),
423('54','54','100','0','18.9907'),
424('55','55','100','77200','23364.8'),
425('56','56','1000','0','57597800'),
426('57','57','1000','61588','23077.7'),
427('58','58','1000','21336','0.1426'),
428('59','59','100000','75246','2895.38'),
429('60','60','1000','1144','36738.6'),
430('61','61','100000','9','706609000'),
431('62','62','100','0','152153'),
432('63','63','1000','87','445132'),
433('64','64','1000','65039000','23251900'),
434('65','65','100000','115094','802285'),
435('66','66','100','267648','14620700'),
436('67','67','100','78','282190'),
437('68','68','100','689251000','2.04327'),
438('69','69','1000','149356000','1952.06'),
439('70','70','1000','751','18456.1'),
440('71','71','100000','9421280','11.83'),
441('72','72','1000','0','0'),
442('73','73','100','18900900','2.73756'),
443('74','74','100','7559120','13.3869'),
444('75','75','100000','49','159691'),
445('76','76','1000','531891000','40615400'),
446('77','77','100','399780','26216500'),
447('78','78','100','7','3.7'),
448('79','79','100','84','62.8282'),
449('80','80','1000','45888700','4461550'),
450('81','81','1000','7622990','26.8914'),
451('82','82','100','41704','253874'),
452('83','83','100000','2001190','72922.6'),
453('84','84','100','74973','68.95'),
454('85','85','100','9175','5469470'),
455('86','86','100','3','22230500'),
456('87','87','100','66049','0'),
457('88','88','100','29437600','4404210'),
458('89','89','100000','815610000','276.009'),
459('90','90','100','50174100','1958.98'),
460('91','91','100000','0','10638900'),
461('92','92','100','10669','164317000'),
462('93','93','100000','2','69334.1'),
463('94','94','100000','192030000','8586720'),
464('95','95','100000','902300','4.46123'),
465('96','96','1000','5951','7.38179'),
466('97','97','100000','598789000','344075000'),
467('98','98','100','851','3367.45'),
468('99','99','100','2','36192200'),
469('100','100','100','189279','4401.89'); 
470
471
472DROP TABLE IF EXISTS `products`;
473CREATE TABLE `products` (
474  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
475  `name` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
476  `unit` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
477  `manager_id` bigint(20) unsigned DEFAULT NULL,
478  `brand_id` bigint(20) unsigned DEFAULT NULL,
479  `status` enum('актуально','временно неактуально','неактуально') COLLATE utf8_unicode_ci DEFAULT NULL,
480  PRIMARY KEY (`id`),
481  KEY `products_ibfk_1` (`manager_id`),
482  KEY `products_ibfk_2` (`brand_id`),
483  CONSTRAINT `products_ibfk_1` FOREIGN KEY (`manager_id`) REFERENCES `managers` (`id`),
484  CONSTRAINT `products_ibfk_2` FOREIGN KEY (`brand_id`) REFERENCES `brands` (`id`)
485) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
486
487INSERT INTO `products` VALUES ('1','aut','шт','1','1','актуально'),
488('2','quaerat','кг','2','2','неактуально'),
489('3','ratione','кг','3','3','актуально'),
490('4','eius','кг','4','4','временно неактуально'),
491('5','expedita','кг','5','5','временно неактуально'),
492('6','vel','кг','6','6','временно неактуально'),
493('7','facere','шт','7','7','временно неактуально'),
494('8','autem','шт','8','8','актуально'),
495('9','expedita','шт','9','9','временно неактуально'),
496('10','quod','шт','10','10','актуально'),
497('11','debitis','л','11','11','актуально'),
498('12','est','шт','12','12','неактуально'),
499('13','suscipit','кг','13','13','временно неактуально'),
500('14','sed','шт','14','14','неактуально'),
501('15','quia','л','15','15','временно неактуально'),
502('16','et','кг','16','16','неактуально'),
503('17','praesentium','л','17','17','временно неактуально'),
504('18','nisi','шт','18','18','актуально'),
505('19','voluptas','кг','19','19','неактуально'),
506('20','corporis','л','20','20','неактуально'),
507('21','commodi','л','21','21','временно неактуально'),
508('22','illo','кг','22','22','актуально'),
509('23','et','шт','23','23','неактуально'),
510('24','maiores','кг','24','24','актуально'),
511('25','provident','кг','25','25','неактуально'),
512('26','ex','кг','26','1','актуально'),
513('27','fugit','шт','27','2','временно неактуально'),
514('28','voluptate','л','28','3','неактуально'),
515('29','deleniti','кг','29','4','актуально'),
516('30','quia','кг','30','5','временно неактуально'),
517('31','asperiores','шт','31','6','неактуально'),
518('32','rerum','шт','32','7','временно неактуально'),
519('33','voluptas','шт','33','8','временно неактуально'),
520('34','earum','кг','34','9','временно неактуально'),
521('35','maiores','кг','35','10','неактуально'),
522('36','sint','кг','36','11','актуально'),
523('37','veniam','шт','37','12','временно неактуально'),
524('38','vel','л','38','13','неактуально'),
525('39','voluptatem','шт','39','14','временно неактуально'),
526('40','sapiente','л','40','15','актуально'),
527('41','numquam','л','41','16','неактуально'),
528('42','aliquid','л','42','17','неактуально'),
529('43','autem','л','43','18','временно неактуально'),
530('44','amet','л','44','19','временно неактуально'),
531('45','eos','шт','45','20','временно неактуально'),
532('46','placeat','шт','46','21','временно неактуально'),
533('47','nostrum','кг','47','22','актуально'),
534('48','nemo','л','48','23','временно неактуально'),
535('49','similique','л','49','24','неактуально'),
536('50','dolores','л','50','25','временно неактуально'),
537('51','eos','шт','51','1','временно неактуально'),
538('52','et','кг','52','2','неактуально'),
539('53','eveniet','шт','53','3','актуально'),
540('54','consequuntur','л','54','4','актуально'),
541('55','sint','кг','55','5','актуально'),
542('56','nobis','шт','56','6','неактуально'),
543('57','tempora','л','57','7','временно неактуально'),
544('58','sit','шт','58','8','неактуально'),
545('59','quasi','шт','59','9','временно неактуально'),
546('60','corrupti','л','60','10','временно неактуально'),
547('61','cum','кг','61','11','временно неактуально'),
548('62','illum','кг','62','12','неактуально'),
549('63','quia','шт','63','13','временно неактуально'),
550('64','et','шт','64','14','временно неактуально'),
551('65','maiores','шт','65','15','неактуально'),
552('66','culpa','кг','66','16','неактуально'),
553('67','placeat','шт','67','17','неактуально'),
554('68','laudantium','л','68','18','актуально'),
555('69','qui','кг','69','19','неактуально'),
556('70','voluptate','кг','70','20','неактуально'),
557('71','quo','л','71','21','временно неактуально'),
558('72','neque','кг','72','22','временно неактуально'),
559('73','reiciendis','кг','73','23','временно неактуально'),
560('74','architecto','шт','74','24','неактуально'),
561('75','autem','шт','75','25','неактуально'),
562('76','temporibus','шт','76','1','временно неактуально'),
563('77','sed','л','77','2','временно неактуально'),
564('78','ut','л','78','3','временно неактуально'),
565('79','id','кг','79','4','неактуально'),
566('80','commodi','л','80','5','временно неактуально'),
567('81','harum','л','81','6','неактуально'),
568('82','delectus','кг','82','7','неактуально'),
569('83','non','л','83','8','актуально'),
570('84','magnam','кг','84','9','неактуально'),
571('85','odio','шт','85','10','временно неактуально'),
572('86','debitis','л','86','11','временно неактуально'),
573('87','suscipit','кг','87','12','актуально'),
574('88','temporibus','л','88','13','временно неактуально'),
575('89','ut','шт','89','14','неактуально'),
576('90','dignissimos','кг','90','15','актуально'),
577('91','laudantium','л','91','16','временно неактуально'),
578('92','vero','кг','92','17','неактуально'),
579('93','ut','кг','93','18','актуально'),
580('94','est','кг','94','19','неактуально'),
581('95','eveniet','кг','95','20','временно неактуально'),
582('96','quibusdam','кг','96','21','временно неактуально'),
583('97','sequi','кг','97','22','неактуально'),
584('98','vitae','кг','98','23','временно неактуально'),
585('99','optio','л','99','24','актуально'),
586('100','tenetur','кг','100','25','неактуально'); 
587
588
589DROP TABLE IF EXISTS `products_order`;
590CREATE TABLE `products_order` (
591  `order_id` bigint(20) unsigned NOT NULL,
592  `product_id` bigint(20) unsigned NOT NULL,
593  `count` float DEFAULT NULL,
594  `delivery_cost` float DEFAULT NULL,
595  `cost_raw` float DEFAULT NULL,
596  `another_cost` float DEFAULT NULL,
597  `nds` float DEFAULT NULL,
598  PRIMARY KEY (`order_id`,`product_id`),
599  KEY `products_order_ibfk_2` (`product_id`),
600  CONSTRAINT `products_order_ibfk_1` FOREIGN KEY (`order_id`) REFERENCES `client_orders` (`id`),
601  CONSTRAINT `products_order_ibfk_2` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`)
602) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
603
604INSERT INTO `products_order` VALUES ('1','1','162.262','111407','48.6548','34.9639','10'),
605('2','2','157.956','65760.7','36.6686','26.53','20'),
606('3','3','102.44','3316.53','94.4403','23.591','10'),
607('4','4','160.488','112891','22.08','32.2','10'),
608('5','5','66.415','5361.75','94.1431','22.6399','20'),
609('6','6','9.89274','26689.8','66','9.23997','20'),
610('7','7','56.4','129926','50.7772','11.729','10'),
611('8','8','7.85149','1736.1','44.5218','47','10'),
612('9','9','50.753','87399.3','21.5589','27.7948','20'),
613('10','10','82.5378','15432.2','75.2568','14','10'),
614('11','11','77.0988','106635','88.3773','46.4483','20'),
615('12','12','15.02','45862.7','24.0828','11.3585','10'),
616('13','13','177','1423.6','92.9893','27.6027','20'),
617('14','14','59.2173','149726','35.6','12.5578','20'),
618('15','15','80.318','82295','39.7201','35','10'),
619('16','16','27.963','5122.2','53','10.0528','20'),
620('17','17','184.751','42726.9','47.5321','49.745','10'),
621('18','18','37.3982','121424','90.0604','13.1468','20'),
622('19','19','32','109610','34.04','33.6519','10'),
623('20','20','185.327','105094','84.4457','21.8776','20'),
624('21','21','104.612','136164','72.9','28.2417','10'),
625('22','22','84.0579','122315','63.3612','1.941','10'),
626('23','23','73.207','7970.8','18.18','30','10'),
627('24','24','28.005','43811.6','89.4464','22.99','10'),
628('25','25','67.035','110591','99.4326','28.3628','10'),
629('26','26','198.431','82668.7','97.4281','26.6969','20'),
630('27','27','180.134','3901.34','50','14.4137','20'),
631('28','28','134','126159','9.27632','24.9705','10'),
632('29','29','74.9728','138602','31.7','27.309','20'),
633('30','30','180.764','66598.2','25.05','10.968','10'),
634('31','31','13.9','9042.07','38.63','46.6544','20'),
635('32','32','93.1592','34580.5','11.2083','36.28','10'),
636('33','33','133.91','65226','8.36637','38.993','10'),
637('34','34','95.9','90340.8','34.9801','8.44','20'),
638('35','35','48.4265','71507.5','20.6323','34.927','10'),
639('36','36','25.169','56652','93.8368','42.253','20'),
640('37','37','150.409','115932','96','29','10'),
641('38','38','100.803','13273','74.6975','3','10'),
642('39','39','2.173','79157.6','38.0785','20.7','20'),
643('40','40','45.258','27554.7','25.4641','22.8504','10'),
644('41','41','59.1879','141260','8.13024','28.7099','10'),
645('42','42','117.023','106366','72.6934','3.3025','20'),
646('43','43','59.9118','146685','26.484','26.1712','20'),
647('44','44','59.4664','68199.5','40.3797','48.3','10'),
648('45','45','148.733','49086','32.738','5','20'),
649('46','46','11.5026','145155','14.0759','14.2614','10'),
650('47','47','39.735','90382.5','21.9','23.3188','20'),
651('48','48','115.634','131530','79','12.0867','10'),
652('49','49','24.3358','5029.26','49.52','28.835','20'),
653('50','50','133','10108','86.41','12.824','10'),
654('51','51','191.497','139992','50.0517','36.6','10'),
655('52','52','161.476','9050.66','83.9133','20.7991','10'),
656('53','53','26.8605','149963','6.63047','25.3751','10'),
657('54','54','112.768','121938','75.1089','30.85','20'),
658('55','55','97.8742','586.316','73.9896','2','10'),
659('56','56','40.6845','31957.5','31.588','6.106','10'),
660('57','57','182.904','58141.7','35.2629','29.5825','20'),
661('58','58','196.067','38423.8','61.2339','39.181','20'),
662('59','59','43.0778','99056','34.5465','20.3806','20'),
663('60','60','186.677','2512.51','75.3','21.3427','20'),
664('61','61','102.05','113207','10.881','47.1991','20'),
665('62','62','108.2','65624.7','16.2931','37.09','10'),
666('63','63','184.357','65964.2','13','18.0628','20'),
667('64','64','68.1208','146267','13.1895','2.35968','10'),
668('65','65','174.8','26754','93.895','43.8','10'),
669('66','66','197.406','64877.4','78.6951','48.7595','10'),
670('67','67','33.4786','56356','70.089','20.123','10'),
671('68','68','81.3303','17651.5','63.17','27.3169','20'),
672('69','69','23.93','117383','29.8469','45','10'),
673('70','70','25','121916','13.8106','10.2023','10'),
674('71','71','8.14','111154','20.1393','34.5','20'),
675('72','72','137.194','82522.4','74.968','31.4497','10'),
676('73','73','36.3','26999.9','13.4284','6','10'),
677('74','74','96.0886','56083.5','98.3','39.1541','20'),
678('75','75','108.661','123707','86.5047','5.1','20'),
679('76','76','71.0594','134718','23.9','5.8261','20'),
680('77','77','135.75','129023','12.07','21.64','10'),
681('78','78','112.833','64894.8','80.4661','26.1','20'),
682('79','79','12.0048','83714.5','59.4468','44.829','20'),
683('80','80','154.693','37909.7','10.5083','24.5969','20'),
684('81','81','85.858','146567','13','16.03','20'),
685('82','82','94.739','43904.2','26.6','49.4','10'),
686('83','83','61','36710','80.8','37','20'),
687('84','84','122.478','6595.08','54.65','11','20'),
688('85','85','55','106102','71.4502','20.9','10'),
689('86','86','54.911','149341','6.788','24','10'),
690('87','87','191.08','111675','31.4','41.0295','10'),
691('88','88','152.17','51771.4','47','28.1923','10'),
692('89','89','125.3','26243.6','28.1934','7.8641','10'),
693('90','90','116.844','101261','82.7102','29','20'),
694('91','91','99.5958','123290','2.755','40.6273','20'),
695('92','92','182','40357','81.9547','9.3','10'),
696('93','93','154.546','108564','89.4714','29.3047','20'),
697('94','94','33.361','95685.4','34','5.15282','20'),
698('95','95','23.9895','128544','51.0838','11.8157','20'),
699('96','96','198','55747.6','99.1245','10.2905','10'),
700('97','97','124.411','29235','31.09','32','20'),
701('98','98','12.9924','86042.9','91.7482','17','20'),
702('99','99','28.082','35655.7','70.6965','24.8565','20'),
703('100','100','185.18','117812','81.831','16.7','20'); 
704
705
706DROP TABLE IF EXISTS `providers`;
707CREATE TABLE `providers` (
708  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
709  `inn` int(10) unsigned DEFAULT NULL,
710  `type_legal_entity` bigint(20) unsigned DEFAULT NULL,
711  `name` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
712  `contract` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
713  `description` text COLLATE utf8_unicode_ci DEFAULT NULL,
714  PRIMARY KEY (`id`),
715  UNIQUE KEY `inn` (`inn`),
716  KEY `providers_ibfk_1` (`type_legal_entity`),
717  CONSTRAINT `providers_ibfk_1` FOREIGN KEY (`type_legal_entity`) REFERENCES `legal_entity` (`id`)
718) ENGINE=InnoDB AUTO_INCREMENT=141 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
719
720INSERT INTO `providers` VALUES ('71','2974872435','1','earum',NULL,'Voluptatibus harum dolores occaecati magnam eum qui. Maxime sit dolore qui est voluptas et. Ut aut incidunt fugiat sapiente adipisci debitis nemo recusandae. Dolore unde qui sit.'),
721('72','1892455352','2','odit',NULL,'Et odio dicta ut optio occaecati. Tenetur repellendus nihil dolor ut. Et quo itaque commodi. Debitis fuga odit tempore iste. Beatae et vel aut temporibus et similique maiores.'),
722('73','4294967295','3','aliquam',NULL,'Sequi sit repudiandae autem praesentium officia. Molestias ab magnam odio hic. Voluptatem porro et vero at.'),
723('74','2655199935','1','a',NULL,'Deleniti fugit odio dignissimos deserunt qui fugiat pariatur. Ducimus voluptatem vero in culpa et et neque nihil. Vitae dolor dignissimos et numquam et ducimus. Sapiente eligendi architecto aut nam quas nisi quo.'),
724('80','1471093139','1','labore',NULL,'Cupiditate voluptatem debitis magnam nobis et veniam consequuntur. Iure reprehenderit voluptatibus consequatur dicta vitae. Quam adipisci aut aut aut qui dolores.'),
725('81','1572389192','2','aperiam',NULL,'Pariatur molestiae ipsam sit velit ipsa velit. Impedit repellat dolore harum quam provident sed dicta. Omnis pariatur porro ab natus. Velit consectetur rerum doloribus vitae eos eligendi et sint.'),
726('82','4143229056','3','aut',NULL,'Nostrum et asperiores in voluptatum. Cumque est laudantium facere nemo.'),
727('83','3662466605','1','atque',NULL,'Dolores qui et porro illo perspiciatis voluptas. Non quae eum fuga rerum est ipsum quia. Neque nisi et repellat aut provident voluptatum fugit. Qui et perferendis ipsum minima inventore.'),
728('88','1400550028','3','aliquid',NULL,'Nisi ut corrupti non officia modi natus. Qui soluta iure expedita.'),
729('89','1778717736','1','illo',NULL,'Architecto cupiditate voluptas in quia. Numquam consequatur excepturi consequatur praesentium fugit in. Sapiente reiciendis quo molestiae omnis sed consectetur.'),
730('90','2681252981','2','officia',NULL,'Eveniet sint totam sit reprehenderit. Dolor voluptatem in quis laboriosam magnam quia est. Voluptatibus tempore ab omnis et magnam aliquam iste. Et quam minus eum aliquid qui exercitationem.'),
731('94','2805221805','3','assumenda',NULL,'Quidem iure animi consequatur rerum cumque quia. Laborum porro iusto nihil esse qui. Consequatur ducimus omnis ea deleniti omnis. Necessitatibus reiciendis porro eum soluta ratione.'),
732('95','2018252135','1','quibusdam',NULL,'Veniam id corporis dolorem. Qui illum tempora magni voluptate asperiores nisi tenetur provident. Recusandae omnis blanditiis placeat vero assumenda. Iusto molestias itaque vel provident id.'),
733('101','2795365655','1','odio',NULL,'Nisi labore ut totam exercitationem ut. Est animi nihil sunt maiores nisi cum. Alias a tenetur illo sapiente dolorem culpa sint.'),
734('102','3157907922','2','qui',NULL,'Nihil voluptas beatae impedit eos labore. Sit est animi nobis dolorem officiis magnam alias. Quo blanditiis ut nemo dolores consequuntur.'),
735('103','3920745087','3','laboriosam',NULL,'Quidem sequi repellendus corrupti earum impedit autem. Animi et minima quos. Nam omnis aliquam ipsum et corporis ducimus eos.'),
736('104','2838890556','1','eligendi',NULL,'Rerum et repellendus eveniet est ut ut. Eligendi placeat deleniti iusto iusto minima. Vel sit veritatis saepe debitis sit. Nemo sunt et ut eum exercitationem.'),
737('107','2449540777','1','aut',NULL,'Nostrum soluta facere velit vel voluptate autem. Facere blanditiis sit et et magnam dolorem dignissimos. Molestiae vitae vero autem laudantium. Totam dolorem nihil eius maxime reprehenderit.'),
738('112','2881537816','3','voluptates',NULL,'Qui natus ad temporibus maxime numquam omnis. Ab sequi rerum non. Aut totam quisquam at. Impedit ipsum ullam non iusto reprehenderit.'),
739('113','3488908302','1','iusto',NULL,'Similique at voluptatem odit sit debitis omnis. Impedit corporis et doloribus illo eaque vel at. In odit est hic itaque.'),
740('115','2805654721','3','inventore',NULL,'Minima sed eius modi ut. Ex nulla optio fuga omnis voluptas deserunt facilis quaerat. Eum maiores omnis totam optio est labore. Ut velit aut dolorum velit deserunt dolorem dolores illum.'),
741('117','1244482989','2','qui',NULL,'Voluptatem quas ullam et. Perferendis at debitis ab. Et neque dicta quod ipsum.'),
742('118','3666568265','3','dolor',NULL,'Cumque quia tenetur dolores consequatur vel quo. Est eveniet rerum voluptas cumque aut. Rerum et error voluptatem illum.'),
743('124','1511050673','3','deleniti',NULL,'Inventore autem sed nesciunt doloribus. Optio qui et modi in id quia. Est architecto quod laudantium consequatur.'),
744('125','3156862548','1','accusamus',NULL,'Mollitia iure placeat maiores eum. Consequatur accusantium impedit officiis dolorem laborum. Pariatur eum corrupti sit cupiditate quos magnam. Accusantium quae accusamus rerum officiis culpa doloribus.'),
745('126','2467597764','2','aliquam',NULL,'Illum repudiandae optio vitae accusantium et impedit at. Est atque perspiciatis ut facere blanditiis vero. Odio optio quia enim odit dolorem. Necessitatibus tempora nisi ea asperiores quidem. Fugiat ut dolor quidem.'),
746('128','4031556451','1','ut',NULL,'Recusandae ut voluptatem earum consequatur sed fugiat. Quo consequuntur rerum rerum amet. Necessitatibus qui soluta dolores eos sapiente provident ipsa architecto.'),
747('131','3013329704','1','aut',NULL,'Quas necessitatibus consequatur qui fuga ratione quia. Et iure ipsam velit accusamus quisquam aliquid. Quis omnis similique id. Ut ipsum occaecati ut accusantium et.'),
748('132','3653605257','2','occaecati',NULL,'Vitae aut assumenda natus laboriosam. Eum molestiae et et qui qui modi. Sapiente officiis sed iste tempore iste rerum qui.'),
749('137','1969406948','1','et',NULL,'Omnis cum aspernatur voluptas atque atque dolor. Qui doloremque qui rem animi amet iusto mollitia fuga. Earum corporis odit quo numquam soluta. Id qui ratione est consequatur et fugiat sed.'),
750('139','3633342376','3','rerum',NULL,'Ad reprehenderit odit laborum amet adipisci libero. Et ut libero in possimus hic consequuntur explicabo.'); 
751
752
753DROP TABLE IF EXISTS `raw`;
754CREATE TABLE `raw` (
755  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
756  `name` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
757  `unit` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
758  `manager_id` bigint(20) unsigned DEFAULT NULL,
759  `status` enum('актуально','временно неактуально','неактуально') COLLATE utf8_unicode_ci DEFAULT NULL,
760  PRIMARY KEY (`id`),
761  KEY `raw_ibfk_1` (`manager_id`),
762  CONSTRAINT `raw_ibfk_1` FOREIGN KEY (`manager_id`) REFERENCES `managers` (`id`)
763) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
764
765INSERT INTO `raw` VALUES ('1','illum','л','1','неактуально'),
766('2','reiciendis','л','2','временно неактуально'),
767('3','dignissimos','кг','3','временно неактуально'),
768('4','consectetur','л','4','неактуально'),
769('5','adipisci','л','5','актуально'),
770('6','dolores','шт','6','неактуально'),
771('7','molestiae','шт','7','актуально'),
772('8','et','кг','8','временно неактуально'),
773('9','cumque','л','9','неактуально'),
774('10','est','л','10','актуально'),
775('11','nisi','кг','11','актуально'),
776('12','ut','л','12','неактуально'),
777('13','aut','шт','13','неактуально'),
778('14','omnis','кг','14','временно неактуально'),
779('15','odit','шт','15','актуально'),
780('16','nam','шт','16','неактуально'),
781('17','praesentium','шт','17','неактуально'),
782('18','modi','л','18','актуально'),
783('19','beatae','шт','19','временно неактуально'),
784('20','illum','кг','20','временно неактуально'),
785('21','aperiam','кг','21','временно неактуально'),
786('22','rerum','л','22','неактуально'),
787('23','magnam','шт','23','неактуально'),
788('24','labore','л','24','неактуально'),
789('25','dicta','шт','25','актуально'),
790('26','ut','шт','26','неактуально'),
791('27','voluptates','л','27','временно неактуально'),
792('28','maxime','л','28','временно неактуально'),
793('29','et','шт','29','актуально'),
794('30','maxime','шт','30','неактуально'),
795('31','blanditiis','шт','31','временно неактуально'),
796('32','ut','кг','32','неактуально'),
797('33','quo','шт','33','актуально'),
798('34','maxime','кг','34','неактуально'),
799('35','mollitia','кг','35','неактуально'),
800('36','architecto','кг','36','актуально'),
801('37','quaerat','кг','37','неактуально'),
802('38','tempora','л','38','актуально'),
803('39','nihil','л','39','временно неактуально'),
804('40','iure','л','40','актуально'),
805('41','quisquam','шт','41','актуально'),
806('42','doloremque','кг','42','неактуально'),
807('43','qui','л','43','актуально'),
808('44','aut','кг','44','временно неактуально'),
809('45','repellendus','кг','45','временно неактуально'),
810('46','minus','шт','46','актуально'),
811('47','velit','л','47','неактуально'),
812('48','ut','шт','48','актуально'),
813('49','pariatur','кг','49','временно неактуально'),
814('50','quaerat','л','50','временно неактуально'),
815('51','quia','л','51','временно неактуально'),
816('52','soluta','шт','52','неактуально'),
817('53','at','шт','53','неактуально'),
818('54','maiores','кг','54','неактуально'),
819('55','cumque','шт','55','неактуально'),
820('56','nostrum','кг','56','неактуально'),
821('57','quaerat','шт','57','неактуально'),
822('58','ipsam','кг','58','актуально'),
823('59','fugit','шт','59','временно неактуально'),
824('60','distinctio','кг','60','неактуально'),
825('61','quae','шт','61','актуально'),
826('62','minima','кг','62','актуально'),
827('63','esse','л','63','неактуально'),
828('64','et','л','64','актуально'),
829('65','quia','шт','65','временно неактуально'),
830('66','suscipit','шт','66','актуально'),
831('67','asperiores','кг','67','временно неактуально'),
832('68','ut','л','68','временно неактуально'),
833('69','atque','кг','69','актуально'),
834('70','fugiat','кг','70','временно неактуально'),
835('71','necessitatibus','кг','71','актуально'),
836('72','iusto','л','72','неактуально'),
837('73','aut','шт','73','актуально'),
838('74','explicabo','шт','74','временно неактуально'),
839('75','voluptas','кг','75','неактуально'),
840('76','id','шт','76','временно неактуально'),
841('77','delectus','шт','77','актуально'),
842('78','alias','л','78','актуально'),
843('79','nihil','кг','79','временно неактуально'),
844('80','repellat','шт','80','временно неактуально'),
845('81','et','шт','81','временно неактуально'),
846('82','mollitia','л','82','временно неактуально'),
847('83','laborum','кг','83','актуально'),
848('84','earum','л','84','временно неактуально'),
849('85','eum','кг','85','актуально'),
850('86','maxime','л','86','временно неактуально'),
851('87','ea','л','87','неактуально'),
852('88','vel','шт','88','неактуально'),
853('89','earum','л','89','временно неактуально'),
854('90','at','кг','90','временно неактуально'),
855('91','dolor','шт','91','актуально'),
856('92','nulla','кг','92','актуально'),
857('93','aut','шт','93','актуально'),
858('94','cumque','кг','94','временно неактуально'),
859('95','nobis','л','95','неактуально'),
860('96','et','кг','96','временно неактуально'),
861('97','numquam','л','97','неактуально'),
862('98','asperiores','шт','98','временно неактуально'),
863('99','voluptas','шт','99','временно неактуально'),
864('100','molestias','шт','100','неактуально'); 
865
866
867DROP TABLE IF EXISTS `warehouse_consumption`;
868CREATE TABLE `warehouse_consumption` (
869  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
870  `warehouse_id` bigint(20) unsigned DEFAULT NULL,
871  `raw_id` bigint(20) unsigned DEFAULT NULL,
872  `raw_count` float DEFAULT NULL,
873  `user_id` bigint(20) unsigned DEFAULT NULL,
874  `date` datetime DEFAULT NULL,
875  PRIMARY KEY (`id`),
876  UNIQUE KEY `id` (`id`),
877  KEY `warehouse_consumption_ibfk_1` (`raw_id`),
878  KEY `warehouse_consumption_ibfk_2` (`user_id`),
879  KEY `warehouse_consumption_ibfk_3` (`warehouse_id`),
880  CONSTRAINT `warehouse_consumption_ibfk_1` FOREIGN KEY (`raw_id`) REFERENCES `raw` (`id`),
881  CONSTRAINT `warehouse_consumption_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `managers` (`id`),
882  CONSTRAINT `warehouse_consumption_ibfk_3` FOREIGN KEY (`warehouse_id`) REFERENCES `warehouses` (`id`)
883) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
884
885INSERT INTO `warehouse_consumption` VALUES ('1','1','1','8949.26','1','1994-09-13 12:45:16'),
886('2','2','2','6696.07','2','1973-06-27 02:18:35'),
887('3','3','3','9496.9','3','1989-08-27 04:48:32'),
888('4','4','4','2940.86','4','1981-11-10 07:53:07'),
889('5','5','5','3161.3','5','1989-05-12 19:57:20'),
890('6','1','6','8266.05','6','2005-01-20 07:14:06'),
891('7','2','7','7998.21','7','1982-08-17 04:10:34'),
892('8','3','8','6121.72','8','2013-06-21 02:18:10'),
893('9','4','9','805.3','9','2007-12-30 09:14:16'),
894('10','5','10','4787.19','10','1995-03-02 09:10:43'),
895('11','1','11','8290','11','1971-03-02 18:21:46'),
896('12','2','12','4857.17','12','1979-06-04 10:14:41'),
897('13','3','13','152.9','13','2014-12-21 06:47:17'),
898('14','4','14','35.7644','14','2014-07-24 19:25:16'),
899('15','5','15','1757.48','15','2012-10-31 08:17:16'),
900('16','1','16','5441.32','16','1983-03-31 00:55:01'),
901('17','2','17','4109.01','17','1997-01-09 19:20:02'),
902('18','3','18','7258.24','18','1983-05-08 03:20:09'),
903('19','4','19','351.409','19','2006-09-02 06:42:41'),
904('20','5','20','5669.12','20','1995-04-18 04:04:20'),
905('21','1','21','3031.01','21','1980-08-09 04:37:04'),
906('22','2','22','1266.1','22','2000-08-04 03:59:36'),
907('23','3','23','7692.23','23','1972-07-02 16:23:04'),
908('24','4','24','8069.43','24','1979-10-08 15:16:32'),
909('25','5','25','9111.22','25','1981-07-04 12:59:29'),
910('26','1','26','1810.31','26','2017-02-15 14:22:09'),
911('27','2','27','5783.1','27','2013-03-15 22:44:18'),
912('28','3','28','3866.05','28','2008-04-21 16:16:07'),
913('29','4','29','5420.3','29','1973-05-21 14:40:45'),
914('30','5','30','6256.74','30','1978-03-16 07:28:48'),
915('31','1','31','9175.41','31','1991-08-29 01:48:20'),
916('32','2','32','889.658','32','1994-10-27 01:19:19'),
917('33','3','33','5981.98','33','2002-05-11 23:41:59'),
918('34','4','34','5472.8','34','1987-06-08 19:27:20'),
919('35','5','35','1237.74','35','1999-04-20 18:16:12'),
920('36','1','36','3866.2','36','2013-04-27 23:21:18'),
921('37','2','37','1991.1','37','2008-07-10 17:40:58'),
922('38','3','38','9612','38','1986-11-25 19:46:59'),
923('39','4','39','4377.13','39','2005-03-16 14:03:29'),
924('40','5','40','3490.62','40','2002-05-01 19:32:33'),
925('41','1','41','2578','41','1978-10-02 00:50:39'),
926('42','2','42','3462.14','42','1975-06-05 04:34:39'),
927('43','3','43','6144.73','43','2019-04-08 07:07:02'),
928('44','4','44','8252.22','44','1993-01-09 05:31:00'),
929('45','5','45','9667','45','1976-05-06 09:33:51'),
930('46','1','46','168.979','46','1976-08-09 20:02:04'),
931('47','2','47','9362','47','2001-11-14 03:19:55'),
932('48','3','48','1255.05','48','1995-09-25 23:07:23'),
933('49','4','49','179','49','1981-06-02 05:44:26'),
934('50','5','50','1493.65','50','2016-04-04 11:53:24'),
935('51','1','51','2432.97','51','1997-10-21 12:25:51'),
936('52','2','52','2536.18','52','1990-01-23 11:13:22'),
937('53','3','53','91.6','53','1988-05-26 21:13:11'),
938('54','4','54','2778.32','54','1972-08-24 09:07:17'),
939('55','5','55','5902.7','55','1975-05-09 21:01:47'),
940('56','1','56','5846','56','1986-04-08 07:42:10'),
941('57','2','57','5480.26','57','2020-01-23 16:29:29'),
942('58','3','58','5917.01','58','1987-04-01 03:33:55'),
943('59','4','59','2964','59','2000-12-14 08:03:18'),
944('60','5','60','7106.79','60','2018-08-14 23:08:47'),
945('61','1','61','7437.59','61','1990-07-17 02:29:50'),
946('62','2','62','6991','62','2013-11-10 11:11:33'),
947('63','3','63','2848.33','63','2005-04-26 16:36:35'),
948('64','4','64','3669.62','64','2011-03-02 21:11:49'),
949('65','5','65','9507.23','65','2013-07-31 15:07:18'),
950('66','1','66','2941.44','66','2003-03-21 19:09:35'),
951('67','2','67','5064.39','67','1979-01-30 16:45:41'),
952('68','3','68','6359.1','68','1970-04-21 23:48:15'),
953('69','4','69','6144.43','69','1978-05-10 10:43:11'),
954('70','5','70','416.41','70','1982-07-21 18:57:45'),
955('71','1','71','8208.73','71','1980-01-04 02:33:27'),
956('72','2','72','6273','72','2019-01-27 22:09:43'),
957('73','3','73','2334.07','73','1985-11-29 05:36:19'),
958('74','4','74','4876.61','74','1995-12-23 10:33:40'),
959('75','5','75','8754.55','75','2011-01-05 12:07:55'),
960('76','1','76','9895','76','1989-09-15 03:49:25'),
961('77','2','77','5798.86','77','1991-05-13 11:12:33'),
962('78','3','78','1289.34','78','2018-05-12 09:28:44'),
963('79','4','79','9458.76','79','2013-10-28 10:25:43'),
964('80','5','80','8764.17','80','1991-06-19 12:43:01'),
965('81','1','81','9560.84','81','1978-07-31 21:49:29'),
966('82','2','82','145.7','82','1995-02-25 17:02:51'),
967('83','3','83','2834.55','83','1975-07-17 09:26:40'),
968('84','4','84','9426','84','2020-01-26 20:32:17'),
969('85','5','85','9712.56','85','1972-12-13 18:09:13'),
970('86','1','86','3915','86','2007-12-15 06:22:17'),
971('87','2','87','5294.05','87','1994-08-06 19:25:46'),
972('88','3','88','668.76','88','1990-01-11 19:44:14'),
973('89','4','89','4063.1','89','1977-12-19 10:28:18'),
974('90','5','90','2397.35','90','1976-11-17 16:48:53'),
975('91','1','91','2243.36','91','1988-02-24 05:11:03'),
976('92','2','92','791.92','92','2010-04-25 15:10:29'),
977('93','3','93','5541.04','93','1983-03-11 15:45:58'),
978('94','4','94','1462.24','94','2009-05-01 15:21:35'),
979('95','5','95','2636.64','95','2011-12-13 01:10:14'),
980('96','1','96','4289.16','96','1982-09-26 15:50:44'),
981('97','2','97','624.432','97','2018-06-29 03:15:00'),
982('98','3','98','3522','98','2015-06-30 18:10:53'),
983('99','4','99','1631.3','99','2016-07-08 03:30:23'),
984('100','5','100','4534.61','100','2010-05-11 21:26:33'); 
985
986
987DROP TABLE IF EXISTS `warehouse_receipt`;
988CREATE TABLE `warehouse_receipt` (
989  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
990  `warehouse_id` bigint(20) unsigned DEFAULT NULL,
991  `provider_id` int(10) unsigned DEFAULT NULL,
992  `raw_id` bigint(20) unsigned DEFAULT NULL,
993  `raw_count` float DEFAULT NULL,
994  `raw_price` float DEFAULT NULL,
995  `date` datetime DEFAULT NULL,
996  PRIMARY KEY (`id`),
997  UNIQUE KEY `id` (`id`),
998  KEY `warehouse_receipt_ibfk_1` (`raw_id`),
999  KEY `warehouse_receipt_ibfk_2` (`provider_id`),
1000  KEY `warehouse_receipt_ibfk_3` (`warehouse_id`),
1001  CONSTRAINT `warehouse_receipt_ibfk_1` FOREIGN KEY (`raw_id`) REFERENCES `raw` (`id`),
1002  CONSTRAINT `warehouse_receipt_ibfk_2` FOREIGN KEY (`provider_id`) REFERENCES `providers` (`id`),
1003  CONSTRAINT `warehouse_receipt_ibfk_3` FOREIGN KEY (`warehouse_id`) REFERENCES `warehouses` (`id`)
1004) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1005
1006INSERT INTO `warehouse_receipt` VALUES ('1','1','71','1','4007.69','962.046','1983-01-16 06:55:15'),
1007('2','2','72','2','6473.48','925.38','2014-09-11 10:35:06'),
1008('3','3','73','3','2328.34','161.123','1984-12-05 03:17:02'),
1009('4','4','74','4','6495.58','185.72','1998-02-21 15:43:26'),
1010('5','5','80','5','8118.07','8.7','2017-07-28 20:44:01'),
1011('6','1','81','6','1490.7','998.951','1999-10-22 03:02:10'),
1012('7','2','82','7','1922','913.688','1981-08-02 04:18:54'),
1013('8','3','83','8','6115.9','791.728','1993-11-24 14:34:21'),
1014('9','4','88','9','3003.48','755.711','1977-06-06 03:17:31'),
1015('10','5','89','10','584','107.839','2018-07-25 02:00:25'),
1016('11','1','90','11','9706.61','254.591','1976-03-03 23:22:20'),
1017('12','2','94','12','4453.53','281.9','2015-09-14 22:29:28'),
1018('13','3','95','13','1555.93','131.352','2006-05-18 15:17:49'),
1019('14','4','101','14','8197.65','7.374','1981-11-13 21:18:19'),
1020('15','5','102','15','6940.27','893.335','2014-08-21 00:27:35'),
1021('16','1','103','16','6378.1','595.947','1992-03-29 09:13:57'),
1022('17','2','104','17','7166.89','394','2012-10-10 04:24:24'),
1023('18','3','107','18','4297.77','649.044','1973-04-11 10:13:24'),
1024('19','4','112','19','7487.7','199','1983-04-25 00:11:52'),
1025('20','5','113','20','7081.37','140.799','2013-10-10 05:59:43'),
1026('21','1','115','21','9805.38','975.495','1997-10-19 22:04:59'),
1027('22','2','117','22','1738.69','264.355','1977-01-03 01:33:15'),
1028('23','3','118','23','2211.36','728.964','2014-06-20 20:55:43'),
1029('24','4','124','24','1607.52','523.63','2002-01-24 09:27:45'),
1030('25','5','125','25','9343.31','595.03','2010-03-02 22:43:40'),
1031('26','1','126','26','3057.23','135.5','2009-05-28 12:29:31'),
1032('27','2','128','27','2133.04','350.922','1970-12-14 14:36:22'),
1033('28','3','131','28','1522.36','690.547','2015-03-01 05:36:03'),
1034('29','4','132','29','2741.87','602.12','1993-11-26 17:51:10'),
1035('30','5','137','30','1233.65','387.118','2003-09-07 06:42:28'),
1036('31','1','139','31','9352.93','713.988','1972-10-14 02:21:35'),
1037('32','2','71','32','132.435','303','2016-06-04 02:56:38'),
1038('33','3','72','33','4290.71','228.187','2012-05-08 06:15:36'),
1039('34','4','73','34','2712.39','209.556','2014-09-08 20:55:12'),
1040('35','5','74','35','729.651','808.269','1978-09-06 09:13:44'),
1041('36','1','80','36','1993.95','280.958','1988-11-27 00:25:14'),
1042('37','2','81','37','9262.69','447.23','1991-09-05 13:17:44'),
1043('38','3','82','38','9344.6','460.857','1982-12-07 11:49:11'),
1044('39','4','83','39','7307','498.982','1983-04-30 17:19:21'),
1045('40','5','88','40','6515.1','534.96','2004-05-13 13:24:40'),
1046('41','1','89','41','9235.41','832','1972-06-09 06:44:57'),
1047('42','2','90','42','4714.64','269.09','1995-07-22 07:42:15'),
1048('43','3','94','43','1866','806.79','2001-08-20 00:35:01'),
1049('44','4','95','44','3149.53','885.552','1984-07-23 23:53:07'),
1050('45','5','101','45','8309.98','265','1994-06-22 03:38:29'),
1051('46','1','102','46','7013.7','525.24','2014-12-01 10:01:59'),
1052('47','2','103','47','561','16.8969','2013-09-22 12:30:51'),
1053('48','3','104','48','5695.34','321','2008-03-31 14:35:42'),
1054('49','4','107','49','2744.62','534.436','1985-03-01 12:30:04'),
1055('50','5','112','50','8109.99','294.297','1992-06-01 07:06:37'),
1056('51','1','113','51','4225.89','569.98','1986-08-24 14:01:56'),
1057('52','2','115','52','1302.84','630.513','2007-09-17 08:41:23'),
1058('53','3','117','53','2484.13','111.717','1973-03-21 23:33:25'),
1059('54','4','118','54','3210.38','919.786','2015-05-17 03:20:45'),
1060('55','5','124','55','9844.39','110.462','2012-05-13 21:30:50'),
1061('56','1','125','56','2776.37','376.428','2004-04-21 07:35:27'),
1062('57','2','126','57','5495','428.33','1991-06-11 15:36:33'),
1063('58','3','128','58','9809.6','437.261','2019-03-09 17:34:52'),
1064('59','4','131','59','9312.99','608.84','1975-02-14 08:58:49'),
1065('60','5','132','60','315.474','640','1977-06-05 09:35:24'),
1066('61','1','137','61','611.268','870.02','1984-04-05 04:44:32'),
1067('62','2','139','62','4054.33','567.054','1998-02-27 21:30:51'),
1068('63','3','71','63','2794.59','78.5','1971-03-18 00:16:10'),
1069('64','4','72','64','344','617.74','1973-05-12 10:50:54'),
1070('65','5','73','65','3190','23','2013-04-03 05:19:59'),
1071('66','1','74','66','6235.65','632.276','2008-11-20 03:32:12'),
1072('67','2','80','67','4945.77','33','1986-02-14 17:38:57'),
1073('68','3','81','68','6446.29','975.361','2013-06-25 18:36:38'),
1074('69','4','82','69','9182.75','80.1297','1970-02-11 23:17:22'),
1075('70','5','83','70','9575','116.587','2013-05-06 05:49:49'),
1076('71','1','88','71','6360.62','322.234','2007-03-17 20:44:05'),
1077('72','2','89','72','188.262','488.161','1989-01-02 01:21:50'),
1078('73','3','90','73','7769.35','464.077','2001-02-20 11:09:22'),
1079('74','4','94','74','4243.79','310.64','2008-04-17 22:15:56'),
1080('75','5','95','75','7944.45','142.345','2009-03-09 03:09:14'),
1081('76','1','101','76','9721.06','134.491','1993-03-15 22:44:16'),
1082('77','2','102','77','7630.99','412.543','2014-01-11 13:08:06'),
1083('78','3','103','78','9787.12','211.537','1987-09-10 16:17:20'),
1084('79','4','104','79','1917.3','469.48','2001-05-02 04:14:34'),
1085('80','5','107','80','2829.9','584','1975-02-22 13:45:40'),
1086('81','1','112','81','9619.11','750.418','1997-05-05 17:43:56'),
1087('82','2','113','82','9461.1','377.48','2018-05-03 18:27:10'),
1088('83','3','115','83','156','388.9','1970-11-06 18:59:47'),
1089('84','4','117','84','6084.86','90.8419','2004-04-25 16:40:14'),
1090('85','5','118','85','6228.73','868.967','2019-05-12 12:01:55'),
1091('86','1','124','86','2728.37','101','1981-01-02 09:36:49'),
1092('87','2','125','87','308.9','54.42','2018-10-04 01:13:46'),
1093('88','3','126','88','4249.43','216.067','2010-02-13 05:04:39'),
1094('89','4','128','89','4329.23','249.741','1984-01-19 15:12:56'),
1095('90','5','131','90','6834.01','74.287','2019-07-22 06:54:39'),
1096('91','1','132','91','2816.1','809.356','1977-05-06 15:27:51'),
1097('92','2','137','92','1126.14','608.275','1978-06-06 03:36:19'),
1098('93','3','139','93','1515.73','565','2008-03-04 05:25:27'),
1099('94','4','71','94','3445.69','744.8','2017-10-14 14:22:55'),
1100('95','5','72','95','3649.52','561.575','2020-06-07 19:05:03'),
1101('96','1','73','96','1165.07','465.714','1977-12-21 06:08:33'),
1102('97','2','74','97','68.5632','193.403','1995-03-13 17:56:13'),
1103('98','3','80','98','5820.73','669.4','1994-02-11 22:59:05'),
1104('99','4','81','99','5376.56','204.347','1975-09-20 10:07:35'),
1105('100','5','82','100','2027.1','514.89','2019-06-18 07:01:19'); 
1106
1107
1108DROP TABLE IF EXISTS `warehouses`;
1109CREATE TABLE `warehouses` (
1110  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1111  `name` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
1112  PRIMARY KEY (`id`),
1113  UNIQUE KEY `id` (`id`)
1114) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1115
1116INSERT INTO `warehouses` VALUES ('1','accusamus'),
1117('2','est'),
1118('3','ad'),
1119('4','nesciunt'),
1120('5','vero'); 
1121
1122
1123
1124
1125/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1126/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1127/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1128/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1129/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1130/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1131/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
1132
1133