Delta Between Two Patch Sets: sitescripts/urlfixer/schema.sql
Issue 8943045:
Implemented extraction of URL Fixer data (Closed)
Left Patch Set:
Created Nov. 23, 2012, 4:36 p.m.
Right Patch Set: Larger blacklist
Created Nov. 28, 2012, 11:29 a.m.
| Left: | ||
| Right: |
Use n/p to move between diff chunks;
N/P to move between comments.
« no previous file with change/comment
|
« sitescripts/urlfixer/bin/topDomains.py ('k')
|
no next file »
|
no next file with change/comment »
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')
| 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 |
« sitescripts/urlfixer/bin/topDomains.py ('k')
|
no next file »
|
Toggle Intra-line Diffs ('i')
|
Expand Comments ('e')
|
Collapse Comments ('c')
|
Toggle Comments ('s')
