use test;

CREATE TABLE IF NOT EXISTS orders
(
  id int NOT NULL AUTO_INCREMENT,
  create_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP  NOT NULL,
  order_item VARCHAR(50) NOT NULL,
  PRIMARY KEY (id)
);

INSERT INTO orders
(create_at, order_item)
VALUES
('2019-09-11 12:17:17', '1,3'),
('2019-09-11 14:13:17', '7'),
('2019-09-11 14:14:17', '2'),
('2019-09-11 23:17:37', '4,5,6');


CREATE TABLE IF NOT EXISTS order_items
(
  id      int       NOT NULL AUTO_INCREMENT,
  create_at     TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP  NOT NULL,
  order_id int   NOT NULL,
  commoditie_id int   NOT NULL,
  PRIMARY KEY (id)
);

INSERT INTO order_items
(create_at, order_id, commoditie_id)
VALUES
('2019-09-11 13:17:17', 1, 1),
('2019-09-11 13:17:17', 3, 1),
('2019-09-11 13:17:17', 1, 2),
('2019-09-11 13:17:17', 4, 2),
('2019-09-11 13:17:17', 4, 3),
('2019-09-11 13:17:17', 4, 4),
('2019-09-11 13:17:17', 2, 2);


CREATE TABLE IF NOT EXISTS  commodities
(
  id      int       NOT NULL AUTO_INCREMENT,
  create_at     TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP  NOT NULL,
  manufacture_time     TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP  NOT NULL,
  PRIMARY KEY (id)
);

INSERT INTO commodities
(create_at, manufacture_time)
VALUES
('2019-09-11 13:17:17', '2019-09-12 03:00:00'),
('2019-09-11 13:18:17', '2019-09-13 06:30:00'),
('2019-09-11 13:19:17', '2019-09-14 13:00:00'),
('2019-09-11 13:20:17', '2019-09-15 21:30:00');