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 PRIMARY KEY(id) | 7 PRIMARY KEY(id), |
| 8 UNIQUE(domain) |
8 ); | 9 ); |
9 | 10 |
10 CREATE TABLE corrections( | 11 CREATE TABLE corrections( |
11 id INT NOT NULL AUTO_INCREMENT, | 12 id INT NOT NULL AUTO_INCREMENT, |
12 domain INT NOT NULL, | 13 domain INT NOT NULL, |
13 status INT NOT NULL, | 14 status INT NOT NULL, |
14 curr_month INT NOT NULL, | 15 curr_month INT NOT NULL, |
15 prev_month INT NOT NULL, | 16 prev_month INT NOT NULL, |
16 curr_year INT NOT NULL, | 17 curr_year INT NOT NULL, |
17 prev_year INT NOT NULL, | 18 prev_year INT NOT NULL, |
18 PRIMARY KEY(id), | 19 PRIMARY KEY(id), |
19 FOREIGN KEY(domain) REFERENCES domains(id) | 20 FOREIGN KEY(domain) REFERENCES domains(id), |
| 21 UNIQUE(domain, status) |
20 ); | 22 ); |
21 | |
22 CREATE UNIQUE INDEX idx_domain ON domains(domain); | |
23 CREATE UNIQUE INDEX idx_domain_status ON corrections(domain, status); | |
LEFT | RIGHT |