· 7 years ago · Oct 06, 2018, 05:30 PM
1DROP TABLE IF EXISTS product;
2CREATE TABLE product (
3 id int(11) NOT NULL AUTO_INCREMENT,
4 name varchar(255) NOT NULL,
5 model varchar(55) NOT NULL,
6 price float(8) DEFAULT 199.99 NOT NULL,
7 PRIMARY KEY (id)
8) ENGINE=InnoDB;
9
10DROP TABLE IF EXISTS purchase;
11CREATE TABLE purchase (
12 id int(11) NOT NULL AUTO_INCREMENT,
13 order_number varchar(55) NOT NULL,
14 pid int(11) NOT NULL,
15 date DATETIME NOT NULL,
16 qty int(11) NOT NULL DEFAULT,
17 FOREIGN KEY (pid) REFERENCES product(id)
18) ENGINE=InnoDB;