| Index: sitescripts/urlfixer/schema.sql |
| =================================================================== |
| new file mode 100644 |
| --- /dev/null |
| +++ b/sitescripts/urlfixer/schema.sql |
| @@ -0,0 +1,23 @@ |
| +DROP TABLE IF EXISTS domains; |
| +DROP TABLE IF EXISTS corrections; |
| + |
| +CREATE TABLE domains( |
| + id INT NOT NULL AUTO_INCREMENT, |
| + domain VARCHAR(50) NOT NULL, |
| + PRIMARY KEY(id) |
| +); |
| + |
| +CREATE TABLE corrections( |
| + id INT NOT NULL AUTO_INCREMENT, |
| + domain INT NOT NULL, |
| + status INT NOT NULL, |
| + curr_month INT NOT NULL, |
| + prev_month INT NOT NULL, |
| + curr_year INT NOT NULL, |
| + prev_year INT NOT NULL, |
| + PRIMARY KEY(id), |
| + FOREIGN KEY(domain) REFERENCES domains(id) |
| +); |
| + |
| +CREATE UNIQUE INDEX idx_domain ON domains(domain); |
| +CREATE UNIQUE INDEX idx_domain_status ON corrections(domain, status); |