FpMUVQCM

1use test;
2
3CREATE TABLE IF NOT EXISTS orders
4(
5  id int NOT NULL AUTO_INCREMENT,
6  create_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP  NOT NULL,
7  order_item VARCHAR(50) NOT NULL,
8  PRIMARY KEY (id)
9);
10
11INSERT INTO orders
12(create_at, order_item) 
13VALUES
14('2019-09-11 12:17:17', '1,3'),
15('2019-09-11 14:13:17', '7'),
16('2019-09-11 14:14:17', '2'),
17('2019-09-11 23:17:37', '4,5,6');
18
19
20CREATE TABLE IF NOT EXISTS order_items
21(
22  id      int       NOT NULL AUTO_INCREMENT,
23  create_at     TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP  NOT NULL,
24  order_id int   NOT NULL,
25  commoditie_id int   NOT NULL,
26  PRIMARY KEY (id)
27);
28
29INSERT INTO order_items
30(create_at, order_id, commoditie_id) 
31VALUES
32('2019-09-11 13:17:17', 1, 1),
33('2019-09-11 13:17:17', 3, 1),
34('2019-09-11 13:17:17', 1, 2),
35('2019-09-11 13:17:17', 4, 2),
36('2019-09-11 13:17:17', 4, 3),
37('2019-09-11 13:17:17', 4, 4),
38('2019-09-11 13:17:17', 2, 2);
39
40
41CREATE TABLE IF NOT EXISTS  commodities
42(
43  id      int       NOT NULL AUTO_INCREMENT,
44  create_at     TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP  NOT NULL,
45  manufacture_time     TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP  NOT NULL,
46  PRIMARY KEY (id)
47);
48
49INSERT INTO commodities
50(create_at, manufacture_time) 
51VALUES
52('2019-09-11 13:17:17', '2019-09-12 03:00:00'),
53('2019-09-11 13:18:17', '2019-09-13 06:30:00'),
54('2019-09-11 13:19:17', '2019-09-14 13:00:00'),
55('2019-09-11 13:20:17', '2019-09-15 21:30:00');