tcaV6byV

1DROP TABLE IF EXISTS orders;
2DROP TABLE IF EXISTS order_line_item;
3DROP TABLE IF EXISTS orders_line_items;
4
5CREATE TABLE order_line_item (
6  id                   BIGINT(20) NOT NULL AUTO_INCREMENT,
7  amount               DECIMAL(19, 2)      DEFAULT NULL,
8  availability         DATETIME            DEFAULT NULL,
9  available_from       DATETIME            DEFAULT NULL,
10  available_to         DATETIME            DEFAULT NULL,
11  description          VARCHAR(255)        DEFAULT NULL,
12  name                 VARCHAR(255)        DEFAULT NULL,
13  order_line_item_type VARCHAR(255)        DEFAULT NULL,
14  ordering_number      INT(11)             DEFAULT NULL,
15  product_id           BIGINT(20)          DEFAULT NULL,
16  quantity             INT(11)             DEFAULT NULL,
17  order_id             BIGINT(20)          DEFAULT NULL,
18  PRIMARY KEY (id),
19  KEY FKbgsq1dd0vi98leb4g7irlei84 (order_id),
20  CONSTRAINT FKbgsq1dd0vi98leb4g7irlei84 FOREIGN KEY (order_id) REFERENCES ORDERS (id)
21)
22  ENGINE = InnoDB
23  DEFAULT CHARSET = utf8;
24
25CREATE TABLE ORDERS (
26  id           BIGINT(20) NOT NULL AUTO_INCREMENT,
27  account_id   BIGINT(20)          DEFAULT NULL,
28  contact      VARCHAR(255)        DEFAULT NULL,
29  email        VARCHAR(255)        DEFAULT NULL,
30  name         VARCHAR(255)        DEFAULT NULL,
31  created      DATETIME            DEFAULT NULL,
32  discount     DECIMAL(19, 2)      DEFAULT NULL,
33  order_status VARCHAR(255)        DEFAULT NULL,
34  subtotal     DECIMAL(19, 2)      DEFAULT NULL,
35  PRIMARY KEY (id)
36)
37  ENGINE = InnoDB
38  DEFAULT CHARSET = utf8;
39
40CREATE TABLE orders_line_items (
41  order_id      BIGINT(20) NOT NULL,
42  line_items_id BIGINT(20) NOT NULL,
43  UNIQUE KEY UK_frp259x5fvoyc35w6dd1rnj84  (line_items_id),
44  KEY FKemt0roi7rjadfixob26kp6u4q  (order_id),
45  CONSTRAINT FKemt0roi7rjadfixob26kp6u4q FOREIGN KEY (order_id) REFERENCES ORDERS (id),
46  CONSTRAINT FKsy09cay6jwmyk4jrh9r7y9h2x FOREIGN KEY (line_items_id) REFERENCES order_line_item (id)
47)
48  ENGINE = InnoDB
49  DEFAULT CHARSET = utf8;