LEFT | RIGHT |
1 DROP TABLE IF EXISTS domains; | 1 DROP TABLE IF EXISTS domains; |
2 DROP TABLE IF EXISTS corrections; | 2 DROP TABLE IF EXISTS corrections; |
3 | 3 |
4 CREATE TABLE domains( | 4 CREATE TABLE domains( |
5 id INT NOT NULL AUTO_INCREMENT, | 5 id INT NOT NULL AUTO_INCREMENT, |
6 domain VARCHAR(50) NOT NULL, | 6 domain VARCHAR(50) NOT NULL, |
7 forceinclusion TINYINT(1) DEFAULT NULL, | 7 forceinclusion TINYINT(1) DEFAULT NULL, |
8 PRIMARY KEY(id), | 8 PRIMARY KEY(id), |
9 UNIQUE(domain) | 9 UNIQUE(domain) |
10 ); | 10 ); |
11 | 11 |
12 CREATE TABLE corrections( | 12 CREATE TABLE corrections( |
13 id INT NOT NULL AUTO_INCREMENT, | 13 id INT NOT NULL AUTO_INCREMENT, |
14 domain INT NOT NULL, | 14 domain INT NOT NULL, |
15 status INT NOT NULL, | 15 status INT NOT NULL, |
16 curr_month INT NOT NULL, | 16 curr_month INT NOT NULL, |
17 prev_month INT NOT NULL, | 17 prev_month INT NOT NULL, |
18 curr_year INT NOT NULL, | 18 curr_year INT NOT NULL, |
19 prev_year INT NOT NULL, | 19 prev_year INT NOT NULL, |
20 PRIMARY KEY(id), | 20 PRIMARY KEY(id), |
21 FOREIGN KEY(domain) REFERENCES domains(id), | 21 FOREIGN KEY(domain) REFERENCES domains(id), |
22 UNIQUE(domain, status) | 22 UNIQUE(domain, status) |
23 ); | 23 ); |
LEFT | RIGHT |