Unified Diff: sitescripts/urlfixer/schema.sql
Issue 8943045:
Implemented extraction of URL Fixer data (Closed)
Patch Set:
Created Nov. 23, 2012, 4:36 p.m.
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 »
Expand Comments ('e') | Collapse Comments ('c') | Hide Comments ('s')
Expand Comments ('e') | Collapse Comments ('c') | Hide Comments ('s')
| Index: sitescripts/urlfixer/schema.sql |
| =================================================================== |
| --- a/sitescripts/urlfixer/schema.sql |
| +++ b/sitescripts/urlfixer/schema.sql |
| @@ -1,14 +1,15 @@ |
| DROP TABLE IF EXISTS domains; |
| DROP TABLE IF EXISTS corrections; |
| CREATE TABLE domains( |
| id INT NOT NULL AUTO_INCREMENT, |
| domain VARCHAR(50) NOT NULL, |
| + forceinclusion TINYINT(1) DEFAULT NULL, |
| PRIMARY KEY(id), |
| UNIQUE(domain) |
| ); |
| CREATE TABLE corrections( |
| id INT NOT NULL AUTO_INCREMENT, |
| domain INT NOT NULL, |
| status INT NOT NULL, |
« sitescripts/urlfixer/bin/topDomains.py ('K')
|
« sitescripts/urlfixer/bin/topDomains.py ('k')
|
no next file »
|
no next file with comments »
