8WtqrPSJ

1DROP TABLE IF EXISTS user;
2DROP TABLE IF EXISTS deals;
3DROP TABLE IF EXISTS inst;
4DROP TABLE IF EXISTS cpty;
5
6CREATE TABLE user
7(
8    id       INT NOT NULL AUTO_INCREMENT,
9    username VARCHAR(45),
10    pass     VARCHAR(255),
11    PRIMARY KEY (id)
12) ENGINE = InnoDB
13  DEFAULT CHARSET = utf8
14  COLLATE = utf8_unicode_ci;
15
16
17create table inst
18(
19    inst_id   INT         NOT NULL AUTO_INCREMENT,
20    inst_name VARCHAR(20) NOT NULL,
21
22    PRIMARY KEY (inst_id)
23) ENGINE = INNODB;
24
25CREATE TABLE cpty
26(
27    cpty_id   INT         NOT NULL AUTO_INCREMENT,
28    cpty_name VARCHAR(20) NOT NULL,
29
30    PRIMARY KEY (cpty_id)
31) ENGINE = INNODB;
32
33CREATE TABLE deals
34(
35    deal_id   INT NOT NULL AUTO_INCREMENT,
36    inst_id   INT,
37    cpty_id   INT,
38    price     FLOAT(20, 13),
39    deal_type CHAR,
40    quantity  INT,
41    deal_time VARCHAR(30),
42
43    PRIMARY KEY (deal_id),
44    FOREIGN KEY (inst_id) REFERENCES inst (inst_id),
45    FOREIGN KEY (cpty_id) REFERENCES cpty (cpty_id)
46) ENGINE = INNODB;