rJTaKQKC

1# создание таблиц
2CREATE DATABASE IF NOT EXISTS study_database;
3USE study_database;
4# создание таблиц
5CREATE TABLE brands (
6  id int(11) NOT NULL AUTO_INCREMENT,
7  brand varchar(45) NOT NULL,
8  PRIMARY KEY (id)
9) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
10
11CREATE TABLE categories (
12  id int(11) NOT NULL AUTO_INCREMENT,
13  category varchar(45) NOT NULL DEFAULT 'name category',
14  description varchar(100) DEFAULT NULL,
15  PRIMARY KEY (id),
16  UNIQUE KEY category_UNIQUE (category)
17) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
18
19CREATE TABLE suppliers (
20  id INT NOT NULL AUTO_INCREMENT,
21  supplier VARCHAR(50) NOT NULL,
22  address VARCHAR(50),
23  contacts VARCHAR(50),
24  PRIMARY KEY (id)
25  ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
26
27CREATE TABLE products (
28  id int(11) NOT NULL AUTO_INCREMENT,
29  category_id int(11) NOT NULL,
30  brand_id int(11) DEFAULT NULL,
31  product varchar(45) NOT NULL,
32  price decimal(10,2) DEFAULT '0.00',
33  description varchar(100) DEFAULT NULL,
34  PRIMARY KEY (id),
35  KEY FK_category_idx (category_id),
36  KEY FK_brand_idx (brand_id),
37  CONSTRAINT FK_brand FOREIGN KEY (brand_id) REFERENCES brands (id) ON UPDATE CASCADE,
38  CONSTRAINT FK_category FOREIGN KEY (category_id) REFERENCES categories (id) ON UPDATE CASCADE
39) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
40
41CREATE TABLE actions (
42  id int(11) NOT NULL AUTO_INCREMENT,
43  action_date datetime NOT NULL,
44  product_id int(11) NOT NULL,
45  supplier_id int(11) NOT NULL,
46  qty decimal(10,3) NOT NULL DEFAULT '0.000',
47  price decimal(10,2) NOT NULL DEFAULT '0.00',
48  PRIMARY KEY (id),
49  INDEX FK_product_idx (product_id),
50  CONSTRAINT FK_product FOREIGN KEY (product_id) REFERENCES products (id),
51  CONSTRAINT FK_supplier FOREIGN KEY (supplier_id) REFERENCES suppliers (id)
52) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
53
54# Вставка категорий товаров
55INSERT INTO categories (category, description) VALUES ('HDD', 'Жесткие диски');
56INSERT INTO categories (category, description) VALUES ('Monitors', 'Мониторы');
57INSERT INTO categories (category, description) VALUES ('Motherboards', 'Материнские платы');
58INSERT INTO categories (category, description) VALUES ('DDR', 'Оперативная память');
59#INSERT INTO categories (category, description) VALUES ('Smartphones', 'Смартфоны');
60
61# Вставка брендов
62INSERT INTO brands (brand) VALUES ('Samsung');
63INSERT INTO brands (brand) VALUES ('ASUS');
64INSERT INTO brands (brand) VALUES ('Acer');
65
66# Вставка поставщиков
67INSERT INTO suppliers (supplier, address, contacts) VALUES ('Silk Road','Shanghai 6-7/115','mr.Lee p:234-177-123-456-6');
68INSERT INTO suppliers (supplier, address, contacts) VALUES ('Cargo Transfer','Shanghai, Mao av. 899-1201', Null);
69INSERT INTO suppliers (supplier, address, contacts) VALUES ('4U','Urumchi','');
70INSERT INTO suppliers (supplier, address, contacts) VALUES ('IDT','Beijing','');
71
72# Вставка товара 1
73INSERT INTO products (category_id, brand_id, product, price, description)
74VALUES ((SELECT id FROM categories where category='HDD'),
75(SELECT id FROM brands where brand='Samsung'),
76'S1 HDD 1T, 7200 rpm', 125, '');
77# Вставка товара 2
78INSERT INTO products (category_id, brand_id, product, price, description)
79VALUES ((SELECT id FROM categories where category='HDD'),
80(SELECT id FROM brands where brand='Samsung'),
81'S2 HDD 500Gb, 7200 rpm', 85, '');
82# Вставка товара 3
83INSERT INTO products (category_id, brand_id, product, price, description)
84VALUES ((SELECT id FROM categories where category='HDD'),
85(SELECT id FROM brands where brand='Samsung'),
86'S3 HDD 250Gb, 10000 rpm', 150, '');
87# Вставка товара 4
88INSERT INTO products (category_id, brand_id, product, price, description)
89VALUES ((SELECT id FROM categories where category='HDD'),
90(SELECT id FROM brands where brand='Samsung'),
91'S4 HDD 1T, 7200rpm', 127, '');
92# Вставка товара 5
93INSERT INTO products (category_id, brand_id, product, price, description)
94VALUES ((SELECT id FROM categories where category='HDD'),
95(SELECT id FROM brands where brand='Samsung'),
96'S5 HDD 500Gb, 7200rpm', 92, '');
97# Вставка товара 6
98INSERT INTO products (category_id, brand_id, product, price, description)
99VALUES ((SELECT id FROM categories where category='HDD'),
100(SELECT id FROM brands where brand='Acer'),
101'Z1 HDD 750Gb, 72000rpm', 100, '');
102# Вставка товара 7
103INSERT INTO products (category_id, brand_id, product, price, description)
104VALUES ((SELECT id FROM categories where category='HDD'),
105(SELECT id FROM brands where brand='Acer'),
106'Z2 HDD 750Gb, 72000rpm', 110, '');
107# Вставка товара 8
108INSERT INTO products (category_id, brand_id, product, price, description)
109VALUES ((SELECT id FROM categories where category='HDD'),
110NULL, 'UN1 HDD 750Gb, 72000rpm', 105, '');
111# Вставка товара 9
112INSERT INTO products (category_id, brand_id, product, price, description)
113VALUES ((SELECT id FROM categories where category='Monitors'),
114(SELECT id FROM brands where brand='Samsung'),
115'Monitor B19', 135, '');
116# Вставка товара 10
117INSERT INTO products (category_id, brand_id, product, price, description)
118VALUES ((SELECT id FROM categories where category='Monitors'),
119(SELECT id FROM brands where brand='Samsung'),
120'Monitor B22', 170, '');
121# Вставка товара 11
122INSERT INTO products (category_id, brand_id, product, price, description)
123VALUES ((SELECT id FROM categories where category='Monitors'),
124(SELECT id FROM brands where brand='Samsung'),
125'Monitor B25', 320, '');
126# Вставка товара 12
127INSERT INTO products (category_id, brand_id, product, price, description)
128VALUES ((SELECT id FROM categories where category='Monitors'),
129(SELECT id FROM brands where brand='Acer'),
130'Monitor A20', 150, '');
131# Вставка товара 13
132INSERT INTO products (category_id, brand_id, product, price, description)
133VALUES ((SELECT id FROM categories where category='Monitors'),
134(SELECT id FROM brands where brand='Acer'),
135'Monitor A21', 170, '');
136# Вставка товара 14
137INSERT INTO products (category_id, brand_id, product, price, description)
138VALUES ((SELECT id FROM categories where category='Monitors'),
139(SELECT id FROM brands where brand='ASUS'),
140'Monitor DD27', 370, '');
141# Вставка товара 15
142INSERT INTO products (category_id, brand_id, product, price, description)
143VALUES ((SELECT id FROM categories where category='DDR'),
144(SELECT id FROM brands where brand='Samsung'),
145'DDR3 SST 2Gb', 25, '');
146# Вставка товара 16
147INSERT INTO products (category_id, brand_id, product, price, description)
148VALUES ((SELECT id FROM categories where category='DDR'),
149(SELECT id FROM brands where brand='Samsung'),
150'DDR3 SST 4Gb', 42, '');
151# Вставка товара 17
152INSERT INTO products (category_id, brand_id, product, price, description)
153VALUES ((SELECT id FROM categories where category='DDR'),
154(SELECT id FROM brands where brand='ASUS'),
155'DDR3 BTT 4Gb', 48, '');
156# Вставка товара 18
157INSERT INTO products (category_id, brand_id, product, price, description)
158VALUES ((SELECT id FROM categories where category='DDR'),
159(SELECT id FROM brands where brand='ASUS'),
160'DDR3 BTT 8Gb', 90, '');
161# Вставка товара 19
162INSERT INTO products (category_id, brand_id, product, price, description)
163VALUES ((SELECT id FROM categories where category='DDR'),
164(SELECT id FROM brands where brand='ASUS'),
165'DDR3 ZPP 4Gb', 45, '');
166# Вставка товара 20
167INSERT INTO products (category_id, brand_id, product, price, description)
168VALUES ((SELECT id FROM categories where category='DDR'),
169NULL,'DDR3 UNK 2Gb', 24, '');
170# Вставка товара 21
171INSERT INTO products (category_id, brand_id, product, price, description)
172VALUES ((SELECT id FROM categories where category='DDR'),
173NULL,'DDR2 UNK 1Gb', 17, '');
174# Вставка товара 22
175INSERT INTO products (category_id, brand_id, product, price, description)
176VALUES ((SELECT id FROM categories where category='Motherboards'),
177(SELECT id FROM brands where brand='Samsung'),
178'MB-1', 75, '');
179# Вставка товара 23
180INSERT INTO products (category_id, brand_id, product, price, description)
181VALUES ((SELECT id FROM categories where category='Motherboards'),
182(SELECT id FROM brands where brand='Samsung'),
183'MB-2', 76, '');
184# Вставка товара 24
185INSERT INTO products (category_id, brand_id, product, price, description)
186VALUES ((SELECT id FROM categories where category='Motherboards'),
187(SELECT id FROM brands where brand='ASUS'),
188'MB-3', 80, '');
189# Вставка товара 25
190INSERT INTO products (category_id, brand_id, product, price, description)
191VALUES ((SELECT id FROM categories where category='Motherboards'),
192(SELECT id FROM brands where brand='ASUS'),
193'MB-4', 95, '');
194# Вставка товара 26
195INSERT INTO products (category_id, brand_id, product, price, description)
196VALUES ((SELECT id FROM categories where category='Motherboards'),
197(SELECT id FROM brands where brand='ASUS'),
198'MB-5', 160, '');
199# Вставка товара 27
200INSERT INTO products (category_id, brand_id, product, price, description)
201VALUES ((SELECT id FROM categories where category='Motherboards'),
202(SELECT id FROM brands where brand='Acer'),
203'MB-6', 180, '');
204# Вставка товара 28
205INSERT INTO products (category_id, brand_id, product, price, description)
206VALUES ((SELECT id FROM categories where category='Motherboards'),
207(SELECT id FROM brands where brand='Acer'),
208'MB-7', 200, '');
209# Вставка товара 29
210INSERT INTO products (category_id, brand_id, product, price, description)
211VALUES ((SELECT id FROM categories where category='Motherboards'),
212NULL, 'MB-8', 250, '');
213
214# Silk Road
215#Вставка поступлений товара actions 1
216INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
217VALUES ('2015-07-25 12:30:33', 
218(select id from products where product='S3 HDD 250Gb, 10000 rpm'), # product
219(select id from suppliers where supplier='Silk Road'), # supplier
220100, # qty
221110);
222#Вставка поступлений товара actions 2
223INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
224VALUES ('2015-07-25 12:30:33', 
225(select id from products where product='S5 HDD 500Gb, 7200rpm'), # product
226(select id from suppliers where supplier='Silk Road'), # supplier
22780, # qty
22895);
229#Вставка поступлений товара actions 3
230INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
231VALUES ('2015-07-25 12:30:33', 
232(select id from products where product='UN1 HDD 750Gb, 72000rpm'), # product
233(select id from suppliers where supplier='Silk Road'), # supplier
23448, # qty
23584);
236#Вставка поступлений товара actions 4
237INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
238VALUES ('2015-07-25 12:30:33', 
239(select id from products where product='Monitor B25'), # product
240(select id from suppliers where supplier='Silk Road'), # supplier
24116, # qty
242340);
243#Вставка поступлений товара actions 5
244INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
245VALUES ('2015-07-30 09:30:00', 
246(select id from products where product='Monitor B25'), # product
247(select id from suppliers where supplier='Silk Road'), # supplier
24810, # qty
249345);
250#Вставка поступлений товара actions 6
251INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
252VALUES ('2015-07-30 09:30:00', 
253(select id from products where product='DDR3 SST 2Gb'), # product
254(select id from suppliers where supplier='Silk Road'), # supplier
25550, # qty
25640);
257#Вставка поступлений товара actions 7
258INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
259VALUES ('2015-07-30 09:30:00', 
260(select id from products where product='DDR3 SST 4Gb'), # product
261(select id from suppliers where supplier='Silk Road'), # supplier
26240, # qty
26355);
264#Вставка поступлений товара actions 8
265INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
266VALUES ('2015-08-14 15:30:00', 
267(select id from products where product='DDR3 BTT 4Gb'), # product
268(select id from suppliers where supplier='Silk Road'), # supplier
26950, # qty
27060);
271#Вставка поступлений товара actions 9
272INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
273VALUES ('2015-08-14 15:30:00', 
274(select id from products where product='S5 HDD 500Gb, 7200rpm'), # product
275(select id from suppliers where supplier='Silk Road'), # supplier
27650, # qty
27798);
278#Вставка поступлений товара actions 10
279INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
280VALUES ('2015-08-20 10:05:00', 
281(select id from products where product='Monitor DD27'), # product
282(select id from suppliers where supplier='Silk Road'), # supplier
28310, # qty
284330);
285#13.02.2017
286#Вставка поступлений товара actions 11
287INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
288VALUES ('2015-08-25 12:15:00', 
289(select id from products where product='S3 HDD 250Gb, 10000 rpm'), # product
290(select id from suppliers where supplier='Silk Road'), # supplier
29150, # qty
292115);
293#Вставка поступлений товара actions 12
294INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
295VALUES ('2015-08-25 12:15:00', 
296(select id from products where product='DDR3 BTT 4Gb'), # product
297(select id from suppliers where supplier='Silk Road'), # supplier
29815, # qty
29986);
300#Вставка поступлений товара actions 13
301INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
302VALUES ('2015-08-25 12:15:00', 
303(select id from products where product='S4 HDD 1T, 7200rpm'), # product
304(select id from suppliers where supplier='Silk Road'), # supplier
30525, # qty
306117);
307#Вставка поступлений товара actions 14
308INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
309VALUES ('2015-08-25 14:33:00', 
310(select id from products where product='S4 HDD 1T, 7200rpm'), # product
311(select id from suppliers where supplier='Silk Road'), # supplier
31225, # qty
313117);
314#Вставка поступлений товара actions 15
315INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
316VALUES ('2015-10-04 12:50:00', 
317(select id from products where product='S1 HDD 1T, 7200 rpm'), # product
318(select id from suppliers where supplier='Silk Road'), # supplier
31930, # qty
320121);
321#Вставка поступлений товара actions 16
322INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
323VALUES ('2015-10-27 09:18:00', 
324(select id from products where product='S4 HDD 1T, 7200rpm'), # product
325(select id from suppliers where supplier='Silk Road'), # supplier
3265, # qty
327125);
328#Вставка поступлений товара actions 17
329INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
330VALUES ('2015-12-11 09:20:00', 
331(select id from products where product='S3 HDD 250Gb, 10000 rpm'), # product
332(select id from suppliers where supplier='Silk Road'), # supplier
33310, # qty
334143);
335#Вставка поступлений товара actions 18
336INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
337VALUES ('2016-02-07 09:43:00', 
338(select id from products where product='DDR3 BTT 4Gb'), # product
339(select id from suppliers where supplier='Silk Road'), # supplier
34051, # qty
34143);
342#Вставка поступлений товара actions 19
343INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
344VALUES ('2016-03-12 09:21:00', 
345(select id from products where product='DDR3 SST 2Gb'), # product
346(select id from suppliers where supplier='Silk Road'), # supplier
34770, # qty
34818);
349#Вставка поступлений товара actions 20
350INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
351VALUES ('2016-06-28 08:55:00', 
352(select id from products where product='DDR3 SST 4Gb'), # product
353(select id from suppliers where supplier='Silk Road'), # supplier
35435, # qty
35536);
356#Вставка поступлений товара actions 21
357INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
358VALUES ('2016-07-15 10:02:00', 
359(select id from products where product='Monitor A20'), # product
360(select id from suppliers where supplier='Silk Road'), # supplier
36120, # qty
362135);
363#Вставка поступлений товара actions 22
364INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
365VALUES ('2016-07-16 09:57:00', 
366(select id from products where product='S1 HDD 1T, 7200 rpm'), # product
367(select id from suppliers where supplier='Silk Road'), # supplier
36845, # qty
369116);
370#Вставка поступлений товара actions 23
371INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
372VALUES ('2016-09-15 09:15:00', 
373(select id from products where product='Monitor A20'), # product
374(select id from suppliers where supplier='Silk Road'), # supplier
3755, # qty
376142);
377#Вставка поступлений товара actions 24
378INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
379VALUES ('2016-09-20 10:03:00', 
380(select id from products where product='S2 HDD 500Gb, 7200 rpm'), # product
381(select id from suppliers where supplier='Silk Road'), # supplier
38213, # qty
38374);
384#Вставка поступлений товара actions 25
385INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
386VALUES ('2016-10-02 11:10:00', 
387(select id from products where product='Monitor B19'), # product
388(select id from suppliers where supplier='Silk Road'), # supplier
38924, # qty
390121);
391#Вставка поступлений товара actions 26
392INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
393VALUES ('2016-10-23 10:02:00', 
394(select id from products where product='DDR3 BTT 8Gb'), # product
395(select id from suppliers where supplier='Silk Road'), # supplier
39655, # qty
39779);
398#Вставка поступлений товара actions 27
399INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
400VALUES ('2016-10-23 10:03:00', 
401(select id from products where product='Monitor B25'), # product
402(select id from suppliers where supplier='Silk Road'), # supplier
4036, # qty
404295);
405#Вставка поступлений товара actions 28
406INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
407VALUES ('2016-10-23 10:04:00', 
408(select id from products where product='S4 HDD 1T, 7200rpm'), # product
409(select id from suppliers where supplier='Silk Road'), # supplier
410100, # qty
411108);
412#Вставка поступлений товара actions 29
413INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
414VALUES ('2016-11-11 09:44:00', 
415(select id from products where product='DDR3 ZPP 4Gb'), # product
416(select id from suppliers where supplier='Silk Road'), # supplier
41775, # qty
41831);
419#Вставка поступлений товара actions 30
420INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
421VALUES ('2016-12-17 11:00:00', 
422(select id from products where product='DDR3 BTT 8Gb'), # product
423(select id from suppliers where supplier='Silk Road'), # supplier
42420, # qty
42577);
426#Вставка поступлений товара actions 31
427INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
428VALUES ('2016-12-20 08:50:00', 
429(select id from products where product='DDR3 BTT 4Gb'), # product
430(select id from suppliers where supplier='Silk Road'), # supplier
43112, # qty
43240);
433#Вставка поступлений товара actions 32
434INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
435VALUES ('2017-01-12 11:01:00', 
436(select id from products where product='Monitor DD27'), # product
437(select id from suppliers where supplier='Silk Road'), # supplier
43810, # qty
439340);
440#Вставка поступлений товара actions 33
441INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
442VALUES ('2017-01-12 11:02:00', 
443(select id from products where product='DDR3 BTT 8Gb'), # product
444(select id from suppliers where supplier='Silk Road'), # supplier
44525, # qty
44676);
447#Вставка поступлений товара actions 34
448INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
449VALUES ('2017-01-12 11:03:00 ', 
450(select id from products where product='S1 HDD 1T, 7200 rpm'), # product
451(select id from suppliers where supplier='Silk Road'), # supplier
45237, # qty
453115);
454#Вставка поступлений товара actions 35
455INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
456VALUES ('2017-02-25 13:50:00', 
457(select id from products where product='S3 HDD 250Gb, 10000 rpm'), # product
458(select id from suppliers where supplier='Silk Road'), # supplier
45950, # qty
460128);
461#Вставка поступлений товара actions 36
462INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
463VALUES ('2017-02-26 09:30:00', 
464(select id from products where product='Monitor B25'), # product
465(select id from suppliers where supplier='Silk Road'), # supplier
46619, # qty
467302);
468#Вставка поступлений товара actions 37
469INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
470VALUES ('2017-02-27 09:36:00', 
471(select id from products where product='S4 HDD 1T, 7200rpm'), # product
472(select id from suppliers where supplier='Silk Road'), # supplier
47311, # qty
474119);
475#Вставка поступлений товара actions 38
476INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
477VALUES ('2017-03-02 09:44:00', 
478(select id from products where product='S5 HDD 500Gb, 7200rpm'), # product
479(select id from suppliers where supplier='Silk Road'), # supplier
48040, # qty
48180);
482
483#Cargo Transfer
484#Вставка поступлений товара actions 39
485INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
486VALUES ('2015-07-26 08:30:00', 
487(select id from products where product='MB-1'), # product
488(select id from suppliers where supplier='Cargo Transfer'), # supplier
48925, # qty
49076);
491#Вставка поступлений товара actions 40
492INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
493VALUES ('2015-07-26 08:30:00', 
494(select id from products where product='MB-2'), # product
495(select id from suppliers where supplier='Cargo Transfer'), # supplier
49615, # qty
49779);
498#Вставка поступлений товара actions 41
499INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
500VALUES ('2015-07-26 08:30:00', 
501(select id from products where product='MB-3'), # product
502(select id from suppliers where supplier='Cargo Transfer'), # supplier
50320, # qty
50485);
505#Вставка поступлений товара actions 42
506INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
507VALUES ('2015-07-26 08:30:00', 
508(select id from products where product='MB-4'), # product
509(select id from suppliers where supplier='Cargo Transfer'), # supplier
51023, # qty
51188);
512#Вставка поступлений товара actions 43
513INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
514VALUES ('2015-07-26 08:30:00', 
515(select id from products where product='MB-5'), # product
516(select id from suppliers where supplier='Cargo Transfer'), # supplier
51710, # qty
51894);
519#Вставка поступлений товара actions 44
520INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
521VALUES ('2015-07-28 08:45:00', 
522(select id from products where product='MB-2'), # product
523(select id from suppliers where supplier='Cargo Transfer'), # supplier
52410, # qty
52579);
526#Вставка поступлений товара actions 45
527INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
528VALUES ('2015-07-28 08:45:00', 
529(select id from products where product='MB-4'), # product
530(select id from suppliers where supplier='Cargo Transfer'), # supplier
5317, # qty
53289);
533#Вставка поступлений товара actions 46
534INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
535VALUES ('2015-08-07 08:45:00', 
536(select id from products where product='MB-1'), # product
537(select id from suppliers where supplier='Cargo Transfer'), # supplier
53830, # qty
53976);
540#Вставка поступлений товара actions 47
541INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
542VALUES ('2015-08-07 08:45:00', 
543(select id from products where product='S3 HDD 250Gb, 10000 rpm'), # product
544(select id from suppliers where supplier='Cargo Transfer'), # supplier
54524, # qty
546105);
547#Вставка поступлений товара actions 48
548INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
549VALUES ('2015-08-13 11:12:00', 
550(select id from products where product='MB-1'), # product
551(select id from suppliers where supplier='Cargo Transfer'), # supplier
55210, # qty
55375);
554#Вставка поступлений товара actions 49
555INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
556VALUES ('2015-08-13 11:12:00', 
557(select id from products where product='MB-4'), # product
558(select id from suppliers where supplier='Cargo Transfer'), # supplier
55925, # qty
56077);
561#13.02.2017
562#Вставка поступлений товара actions 50
563INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
564VALUES ('2015-11-20 12:30:00', 
565(select id from products where product='MB-7'), # product
566(select id from suppliers where supplier='Cargo Transfer'), # supplier
56717, # qty
568181);
569#Вставка поступлений товара actions 51
570INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
571VALUES ('2015-11-20 12:31:00', 
572(select id from products where product='MB-6'), # product
573(select id from suppliers where supplier='Cargo Transfer'), # supplier
5746, # qty
575168);
576#Вставка поступлений товара actions 52
577INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
578VALUES ('2016-04-03 11:25:00', 
579(select id from products where product='MB-2'), # product
580(select id from suppliers where supplier='Cargo Transfer'), # supplier
58150, # qty
58257);
583#Вставка поступлений товара actions 53
584INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
585VALUES ('2016-04-24 10:35:00', 
586(select id from products where product='MB-3'), # product
587(select id from suppliers where supplier='Cargo Transfer'), # supplier
58860, # qty
58963);
590#Вставка поступлений товара actions 54
591INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
592VALUES ('2016-07-03 10:45:00', 
593(select id from products where product='MB-6'), # product
594(select id from suppliers where supplier='Cargo Transfer'), # supplier
59511, # qty
596169);
597#Вставка поступлений товара actions 55
598INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
599VALUES ('2016-07-07 13:07:00', 
600(select id from products where product='MB-2'), # product
601(select id from suppliers where supplier='Cargo Transfer'), # supplier
60220, # qty
60370);
604#Вставка поступлений товара actions 56
605INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
606VALUES ('2016-07-07 13:08:00', 
607(select id from products where product='MB-5'), # product
608(select id from suppliers where supplier='Cargo Transfer'), # supplier
60925, # qty
610144);
611#Вставка поступлений товара actions 57
612INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
613VALUES ('2016-07-07 13:09:00', 
614(select id from products where product='MB-4'), # product
615(select id from suppliers where supplier='Cargo Transfer'), # supplier
61640, # qty
61781);
618#Вставка поступлений товара actions 58
619INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
620VALUES ('2016-07-16 14:02:00', 
621(select id from products where product='MB-8'), # product
622(select id from suppliers where supplier='Cargo Transfer'), # supplier
62310, # qty
624236);
625#Вставка поступлений товара actions 59
626INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
627VALUES ('2016-08-12 11:37:00', 
628(select id from products where product='MB-7'), # product
629(select id from suppliers where supplier='Cargo Transfer'), # supplier
63012, # qty
631180);
632#Вставка поступлений товара actions 60
633INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
634VALUES ('2016-08-20 10:04:00', 
635(select id from products where product='MB-2'), # product
636(select id from suppliers where supplier='Cargo Transfer'), # supplier
63730, # qty
63868);
639#Вставка поступлений товара actions 61
640INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
641VALUES ('2016-09-11 11:14:00', 
642(select id from products where product='MB-3'), # product
643(select id from suppliers where supplier='Cargo Transfer'), # supplier
644100, # qty
64562);
646#Вставка поступлений товара actions 62
647INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
648VALUES ('2016-10-06 09:57:00', 
649(select id from products where product='S2 HDD 500Gb, 7200 rpm'), # product
650(select id from suppliers where supplier='Cargo Transfer'), # supplier
65110, # qty
65274);
653#Вставка поступлений товара actions 63
654INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
655VALUES ('2016-10-06 09:59:00', 
656(select id from products where product='MB-6'), # product
657(select id from suppliers where supplier='Cargo Transfer'), # supplier
65819, # qty
659159);
660#Вставка поступлений товара actions 64
661INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
662VALUES ('2016-10-7 13:20:00', 
663(select id from products where product='MB-2'), # product
664(select id from suppliers where supplier='Cargo Transfer'), # supplier
66511, # qty
66677);
667#Вставка поступлений товара actions 65
668INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
669VALUES ('2016-10-16 09:48:00', 
670(select id from products where product='MB-4'), # product
671(select id from suppliers where supplier='Cargo Transfer'), # supplier
6723, # qty
67391);
674#Вставка поступлений товара actions 66
675INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
676VALUES ('2016-10-19 10:06:00', 
677(select id from products where product='MB-7'), # product
678(select id from suppliers where supplier='Cargo Transfer'), # supplier
6798, # qty
680188);
681#Вставка поступлений товара actions 67
682INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
683VALUES ('2016-10-27 10:45:00', 
684(select id from products where product='MB-3'), # product
685(select id from suppliers where supplier='Cargo Transfer'), # supplier
68620, # qty
68772);
688#Вставка поступлений товара actions 68
689INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
690VALUES ('2017-02-25 11:12:00', 
691(select id from products where product='MB-1'), # product
692(select id from suppliers where supplier='Cargo Transfer'), # supplier
69325, # qty
69463);
695#Вставка поступлений товара actions 69
696INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
697VALUES ('2017-03-03 14:25:00', 
698(select id from products where product='MB-8'), # product
699(select id from suppliers where supplier='Cargo Transfer'), # supplier
70015, # qty
701234);
702#Вставка поступлений товара actions 70
703INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
704VALUES ('2017-03-06 09:52:00', 
705(select id from products where product='S2 HDD 500Gb, 7200 rpm'), # product
706(select id from suppliers where supplier='Cargo Transfer'), # supplier
70725, # qty
70876);
709
710#4U
711#Вставка поступлений товара actions 71
712INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
713VALUES ('2015-07-25 09:05:00', 
714(select id from products where product='S1 HDD 1T, 7200 rpm'), # product
715(select id from suppliers where supplier='4U'), # supplier
71633, # qty
717115);
718#Вставка поступлений товара actions 72
719INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
720VALUES ('2015-07-25 09:05:00', 
721(select id from products where product='Z1 HDD 750Gb, 72000rpm'), # product
722(select id from suppliers where supplier='4U'), # supplier
72340, # qty
72490);
725#Вставка поступлений товара actions 73
726INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
727VALUES ('2015-07-26 16:45:00', 
728(select id from products where product='UN1 HDD 750Gb, 72000rpm'), # product
729(select id from suppliers where supplier='4U'), # supplier
730100, # qty
73194);
732#Вставка поступлений товара actions 74
733INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
734VALUES ('2015-07-28 09:10:00', 
735(select id from products where product='S5 HDD 500Gb, 7200rpm'), # product
736(select id from suppliers where supplier='4U'), # supplier
73780, # qty
73886);
739#Вставка поступлений товара actions 75
740INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
741VALUES ('2015-08-03 14:15:00', 
742(select id from products where product='DDR3 SST 4Gb'), # product
743(select id from suppliers where supplier='4U'), # supplier
744100, # qty
74534);
746#Вставка поступлений товара actions 76
747INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
748VALUES ('2015-08-03 14:15:00', 
749(select id from products where product='Monitor DD27'), # product
750(select id from suppliers where supplier='4U'), # supplier
75110, # qty
752345);
753#Вставка поступлений товара actions 77
754INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
755VALUES ('2015-08-13 10:00:00', 
756(select id from products where product='Monitor DD27'), # product
757(select id from suppliers where supplier='4U'), # supplier
7585, # qty
759345);
760#Вставка поступлений товара actions 78
761INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
762VALUES ('2015-08-13 10:00:00', 
763(select id from products where product='MB-8'), # product
764(select id from suppliers where supplier='4U'), # supplier
76530, # qty
766235);
767#Вставка поступлений товара actions 79
768INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
769VALUES ('2015-08-15 17:15:00', 
770(select id from products where product='DDR3 BTT 4Gb'), # product
771(select id from suppliers where supplier='4U'), # supplier
772100, # qty
77339);
774#Вставка поступлений товара actions 80
775INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
776VALUES ('2015-08-16 09:45:00', 
777(select id from products where product='MB-7'), # product
778(select id from suppliers where supplier='4U'), # supplier
77950, # qty
780180);
781#Вставка поступлений товара actions 81
782INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
783VALUES ('2015-08-16 09:45:00', 
784(select id from products where product='Monitor DD27'), # product
785(select id from suppliers where supplier='4U'), # supplier
78612, # qty
787350);
788#13.02.2017
789#Вставка поступлений товара actions 82
790INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
791VALUES ('2015-12-19 09:23:00', 
792(select id from products where product='Z1 HDD 750Gb, 72000rpm'), # product
793(select id from suppliers where supplier='4U'), # supplier
79450, # qty
79579);
796#Вставка поступлений товара actions 83
797INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
798VALUES ('2016-01-07 10:10:00', 
799(select id from products where product='Z2 HDD 750Gb, 72000rpm'), # product
800(select id from suppliers where supplier='4U'), # supplier
80130, # qty
80294);
803#Вставка поступлений товара actions 84
804INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
805VALUES ('2016-01-09 10:23:00', 
806(select id from products where product='DDR3 UNK 2Gb'), # product
807(select id from suppliers where supplier='4U'), # supplier
80825, # qty
80918);
810#Вставка поступлений товара actions 85
811INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
812VALUES ('2016-01-23 15:45:00', 
813(select id from products where product='DDR3 BTT 4Gb'), # product
814(select id from suppliers where supplier='4U'), # supplier
81560, # qty
81639);
817#Вставка поступлений товара actions 86
818INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
819VALUES ('2016-01-25 13:17:00', 
820(select id from products where product='Z1 HDD 750Gb, 72000rpm'), # product
821(select id from suppliers where supplier='4U'), # supplier
8225, # qty
823101);
824#Вставка поступлений товара actions 87
825INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
826VALUES ('2016-02-01 09:45:00', 
827(select id from products where product='Monitor DD27'), # product
828(select id from suppliers where supplier='4U'), # supplier
8295, # qty
830351);
831#Вставка поступлений товара actions 88
832INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
833VALUES ('2016-02-25 09:15:00', 
834(select id from products where product='MB-8'), # product
835(select id from suppliers where supplier='4U'), # supplier
83620, # qty
837225);
838#Вставка поступлений товара actions 89
839INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
840VALUES ('2016-02-25 10:03:00', 
841(select id from products where product='UN1 HDD 750Gb, 72000rpm'), # product
842(select id from suppliers where supplier='4U'), # supplier
84316, # qty
84493);
845#Вставка поступлений товара actions 90
846INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
847VALUES ('2016-03-09 17:43:00', 
848(select id from products where product='DDR3 BTT 8Gb'), # product
849(select id from suppliers where supplier='4U'), # supplier
85024, # qty
85175);
852#Вставка поступлений товара actions 91
853INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
854VALUES ('2016-03-18 13:06:00', 
855(select id from products where product='MB-7'), # product
856(select id from suppliers where supplier='4U'), # supplier
85710, # qty
858183);
859#Вставка поступлений товара actions 92
860INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
861VALUES ('2016-03-24 11:18:00', 
862(select id from products where product='Z1 HDD 750Gb, 72000rpm'), # product
863(select id from suppliers where supplier='4U'), # supplier
86440, # qty
86592);
866#Вставка поступлений товара actions 93
867INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
868VALUES ('2016-03-24 11:19:00', 
869(select id from products where product='Z2 HDD 750Gb, 72000rpm'), # product
870(select id from suppliers where supplier='4U'), # supplier
87135, # qty
87299);
873#Вставка поступлений товара actions 94
874INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
875VALUES ('2016-03-24 11:20:00', 
876(select id from products where product='DDR3 ZPP 4Gb'), # product
877(select id from suppliers where supplier='4U'), # supplier
87820, # qty
87937);
880#Вставка поступлений товара actions 95
881INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
882VALUES ('2016-04-12 15:55:00', 
883(select id from products where product='UN1 HDD 750Gb, 72000rpm'), # product
884(select id from suppliers where supplier='4U'), # supplier
88550, # qty
88695);
887#Вставка поступлений товара actions 96
888INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
889VALUES ('2016-05-18 13:15:00', 
890(select id from products where product='MB-8'), # product
891(select id from suppliers where supplier='4U'), # supplier
8921, # qty
893255);
894#Вставка поступлений товара actions 97
895INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
896VALUES ('2016-05-18 13:15:00', 
897(select id from products where product='MB-7'), # product
898(select id from suppliers where supplier='4U'), # supplier
8993, # qty
900196);
901#Вставка поступлений товара actions 98
902INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
903VALUES ('2016-06-01 10:05:00', 
904(select id from products where product='DDR3 ZPP 4Gb'), # product
905(select id from suppliers where supplier='4U'), # supplier
90660, # qty
90734);
908#Вставка поступлений товара actions 99
909INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
910VALUES ('2016-07-01 12:21:00', 
911(select id from products where product='Monitor DD27'), # product
912(select id from suppliers where supplier='4U'), # supplier
9137, # qty
914348);
915#Вставка поступлений товара actions 100
916INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
917VALUES ('2016-12-13 09:52:00', 
918(select id from products where product='DDR3 ZPP 4Gb'), # product
919(select id from suppliers where supplier='4U'), # supplier
92010, # qty
92142);
922#Вставка поступлений товара actions 101
923INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
924VALUES ('2017-01-20 15:35:00', 
925(select id from products where product='S1 HDD 1T, 7200 rpm'), # product
926(select id from suppliers where supplier='4U'), # supplier
92720, # qty
928115);
929#Вставка поступлений товара actions 102
930INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
931VALUES ('2017-02-25 16:05:00', 
932(select id from products where product='DDR3 SST 4Gb'), # product
933(select id from suppliers where supplier='4U'), # supplier
93480, # qty
93536);
936#Вставка поступлений товара actions 103
937INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
938VALUES ('2017-03-12 12:45:00', 
939(select id from products where product='DDR3 BTT 4Gb'), # product
940(select id from suppliers where supplier='4U'), # supplier
94150, # qty
94239);
943
944#IDT
945#Вставка поступлений товара actions 104
946INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
947VALUES ('2015-07-29 13:00:00', 
948(select id from products where product='S5 HDD 500Gb, 7200rpm'), # product
949(select id from suppliers where supplier='IDT'), # supplier
950120, # qty
95178);
952#Вставка поступлений товара actions 105
953INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
954VALUES ('2015-07-29 13:00:00', 
955(select id from products where product='S3 HDD 250Gb, 10000 rpm'), # product
956(select id from suppliers where supplier='IDT'), # supplier
95780, # qty
958130);
959#Вставка поступлений товара actions 106
960INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
961VALUES ('2015-08-10 09:50:00', 
962(select id from products where product='S5 HDD 500Gb, 7200rpm'), # product
963(select id from suppliers where supplier='IDT'), # supplier
96460, # qty
96578);
966#Вставка поступлений товара actions 107
967INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
968VALUES ('2015-08-12 10:10:00', 
969(select id from products where product='S3 HDD 250Gb, 10000 rpm'), # product
970(select id from suppliers where supplier='IDT'), # supplier
97185, # qty
972129);
973#13.02.2017
974#Вставка поступлений товара actions 108
975INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
976VALUES ('2016-02-12 09:15:00', 
977(select id from products where product='S3 HDD 250Gb, 10000 rpm'), # product
978(select id from suppliers where supplier='IDT'), # supplier
979100, # qty
980127);
981#Вставка поступлений товара actions 109
982INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
983VALUES ('2016-02-25 17:02:00', 
984(select id from products where product='S2 HDD 500Gb, 7200 rpm'), # product
985(select id from suppliers where supplier='IDT'), # supplier
98650, # qty
98773);
988#Вставка поступлений товара actions 110
989INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
990VALUES ('2016-02-25 17:03:00', 
991(select id from products where product='S1 HDD 1T, 7200 rpm'), # product
992(select id from suppliers where supplier='IDT'), # supplier
99363, # qty
99499);
995#Вставка поступлений товара actions 111
996INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
997VALUES ('2016-02-25 17:03:00', 
998(select id from products where product='S5 HDD 500Gb, 7200rpm'), # product
999(select id from suppliers where supplier='IDT'), # supplier
100020, # qty
100182);
1002#Вставка поступлений товара actions 112
1003INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
1004VALUES ('2016-06-14 16:03:00', 
1005(select id from products where product='S3 HDD 250Gb, 10000 rpm'), # product
1006(select id from suppliers where supplier='IDT'), # supplier
100725, # qty
1008127);
1009#Вставка поступлений товара actions 113
1010INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
1011VALUES ('2016-07-19 10:25:00', 
1012(select id from products where product='S3 HDD 250Gb, 10000 rpm'), # product
1013(select id from suppliers where supplier='IDT'), # supplier
101420, # qty
1015127);
1016#Вставка поступлений товара actions 114
1017INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
1018VALUES ('2016-09-01 09:25:00', 
1019(select id from products where product='S1 HDD 1T, 7200 rpm'), # product
1020(select id from suppliers where supplier='IDT'), # supplier
102130, # qty
1022116);
1023#Вставка поступлений товара actions 115
1024INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
1025VALUES ('2016-11-01 10:10:00', 
1026(select id from products where product='S2 HDD 500Gb, 7200 rpm'), # product
1027(select id from suppliers where supplier='IDT'), # supplier
102830, # qty
102973);
1030#Вставка поступлений товара actions 116
1031INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
1032VALUES ('2016-12-25 13:09:00', 
1033(select id from products where product='S5 HDD 500Gb, 7200rpm'), # product
1034(select id from suppliers where supplier='IDT'), # supplier
103520, # qty
103683);
1037#Вставка поступлений товара actions 117
1038INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
1039VALUES ('2017-01-11 09:15:00', 
1040(select id from products where product='S4 HDD 1T, 7200rpm'), # product
1041(select id from suppliers where supplier='IDT'), # supplier
104215, # qty
1043120);
1044#Вставка поступлений товара actions 118
1045INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
1046VALUES ('2017-01-14 10:22:00', 
1047(select id from products where product='S3 HDD 250Gb, 10000 rpm'), # product
1048(select id from suppliers where supplier='IDT'), # supplier
104990, # qty
1050127);
1051#Вставка поступлений товара actions 119
1052INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
1053VALUES ('2017-01-29 10:30:00', 
1054(select id from products where product='S2 HDD 500Gb, 7200 rpm'), # product
1055(select id from suppliers where supplier='IDT'), # supplier
105640, # qty
105777);
1058#Вставка поступлений товара actions 120
1059INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
1060VALUES ('2017-02-10 15:56:00', 
1061(select id from products where product='S4 HDD 1T, 7200rpm'), # product
1062(select id from suppliers where supplier='IDT'), # supplier
106320, # qty
1064118);
1065#Вставка поступлений товара actions 121
1066INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
1067VALUES ('2017-02-10 15:57:00', 
1068(select id from products where product='S1 HDD 1T, 7200 rpm'), # product
1069(select id from suppliers where supplier='IDT'), # supplier
107025, # qty
1071116);
1072#Вставка поступлений товара actions 122
1073INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
1074VALUES ('2017-02-22 11:37:00', 
1075(select id from products where product='S5 HDD 500Gb, 7200rpm'), # product
1076(select id from suppliers where supplier='IDT'), # supplier
107765, # qty
107880);
1079#Вставка поступлений товара actions 123
1080INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
1081VALUES ('2017-02-28 08:47:00', 
1082(select id from products where product='S3 HDD 250Gb, 10000 rpm'), # product
1083(select id from suppliers where supplier='IDT'), # supplier
108410, # qty
1085145);
1086#Вставка поступлений товара actions 124
1087INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
1088VALUES ('2017-03-05 10:45:00', 
1089(select id from products where product='S4 HDD 1T, 7200rpm'), # product
1090(select id from suppliers where supplier='IDT'), # supplier
1091100, # qty
1092109);
1093#Вставка поступлений товара actions 125
1094INSERT INTO actions (action_date, product_id, supplier_id, qty, price)
1095VALUES ('2017-03-10 13:23:00', 
1096(select id from products where product='S5 HDD 500Gb, 7200rpm'), # product
1097(select id from suppliers where supplier='IDT'), # supplier
109845, # qty
109984);