Unified Diff: sitescripts/crawler/schema.sql
Issue 9045097:
sitescripts: Unmerged changes (Closed)
Patch Set:
Created Dec. 21, 2012, 9:39 a.m.
Use n/p to move between diff chunks;
N/P to move between comments.
« sitescripts/crawler/bin/import_sites.py ('K')
|
« sitescripts/crawler/bin/import_sites.py ('k')
|
sitescripts/crawler/web/crawler.py » ('j')
|
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/crawler/schema.sql |
| =================================================================== |
| --- a/sitescripts/crawler/schema.sql |
| +++ b/sitescripts/crawler/schema.sql |
| @@ -1,11 +1,11 @@ |
| DROP TABLE IF EXISTS crawler_sites; |
| DROP TABLE IF EXISTS crawler_runs; |
| -DROP TABLE IF EXISTS crawler_data; |
| +DROP TABLE IF EXISTS crawler_requests; |
| CREATE TABLE crawler_sites ( |
| id INT NOT NULL AUTO_INCREMENT, |
| PRIMARY KEY (id), |
| - url VARCHAR(512) NOT NULL, |
| + url VARCHAR(1000) BINARY NOT NULL, |
| UNIQUE (url) |
| ); |
| @@ -15,7 +15,7 @@ |
| timestamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP |
| ); |
| -CREATE TABLE crawler_data ( |
| +CREATE TABLE crawler_requests ( |
| id INT NOT NULL AUTO_INCREMENT, |
| PRIMARY KEY (id), |
| run INT NOT NULL, |
« sitescripts/crawler/bin/import_sites.py ('K')
|
« sitescripts/crawler/bin/import_sites.py ('k')
|
sitescripts/crawler/web/crawler.py » ('j')
|
no next file with comments »
