Rietveld Code Review Tool
Help | Bug tracker | Discussion group | Source code

Unified Diff: sitescripts/crawler/schema.sql

Issue 8327353: Crawler backend (Closed)
Patch Set: Created Sept. 14, 2012, 2:23 p.m.
Use n/p to move between diff chunks; N/P to move between comments.
Jump to:
View side-by-side diff with in-line comments
Download patch
Index: sitescripts/crawler/schema.sql
===================================================================
--- a/sitescripts/crawler/schema.sql
+++ b/sitescripts/crawler/schema.sql
@@ -5,7 +5,7 @@
CREATE TABLE crawler_sites (
id INT NOT NULL AUTO_INCREMENT,
PRIMARY KEY (id),
- url VARCHAR(255) NOT NULL
+ url VARCHAR(512) NOT NULL
);
CREATE TABLE crawler_runs (
@@ -21,6 +21,6 @@
FOREIGN KEY (run) REFERENCES crawler_runs (id),
site INT NOT NULL,
FOREIGN KEY (site) REFERENCES crawler_sites (id),
- request_url VARCHAR(255) NOT NULL,
- document_url VARCHAR(255) NOT NULL
+ url VARCHAR(512) NOT NULL,
+ filtered BOOLEAN NOT NULL
);

Powered by Google App Engine
This is Rietveld