Side by Side Diff: sitescripts/urlfixer/schema.sql
Issue 8943045:
Implemented extraction of URL Fixer data (Closed)
Patch Set:
Created Nov. 23, 2012, 4:36 p.m.
| Left: | ||
| Right: |
Use n/p to move between diff chunks;
N/P to move between comments.
« sitescripts/urlfixer/bin/topDomains.py ('K')
|
« sitescripts/urlfixer/bin/topDomains.py ('k')
|
no next file »
|
no next file with comments »
Toggle Intra-line Diffs ('i') | Expand Comments ('e') | Collapse Comments ('c') | Hide Comments ('s')
Toggle Intra-line Diffs ('i') | Expand Comments ('e') | Collapse Comments ('c') | Hide Comments ('s')
| OLD | NEW |
|---|---|
| 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 PRIMARY KEY(id), | 8 PRIMARY KEY(id), |
| 8 UNIQUE(domain) | 9 UNIQUE(domain) |
| 9 ); | 10 ); |
| 10 | 11 |
| 11 CREATE TABLE corrections( | 12 CREATE TABLE corrections( |
| 12 id INT NOT NULL AUTO_INCREMENT, | 13 id INT NOT NULL AUTO_INCREMENT, |
| 13 domain INT NOT NULL, | 14 domain INT NOT NULL, |
| 14 status INT NOT NULL, | 15 status INT NOT NULL, |
| 15 curr_month INT NOT NULL, | 16 curr_month INT NOT NULL, |
| 16 prev_month INT NOT NULL, | 17 prev_month INT NOT NULL, |
| 17 curr_year INT NOT NULL, | 18 curr_year INT NOT NULL, |
| 18 prev_year INT NOT NULL, | 19 prev_year INT NOT NULL, |
| 19 PRIMARY KEY(id), | 20 PRIMARY KEY(id), |
| 20 FOREIGN KEY(domain) REFERENCES domains(id), | 21 FOREIGN KEY(domain) REFERENCES domains(id), |
| 21 UNIQUE(domain, status) | 22 UNIQUE(domain, status) |
| 22 ); | 23 ); |
| OLD | NEW |
« sitescripts/urlfixer/bin/topDomains.py ('K')
|
« sitescripts/urlfixer/bin/topDomains.py ('k')
|
no next file »
|
no next file with comments »
