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

Delta Between Two Patch Sets: sitescripts/urlfixer/schema.sql

Issue 8943045: Implemented extraction of URL Fixer data (Closed)
Left Patch Set: Created Nov. 28, 2012, 10:48 a.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.
Jump to:
Left: Side by side diff | Download
Right: Side by side diff | Download
« 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') | Show Comments Hide Comments ('s')
LEFTRIGHT
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 );
LEFTRIGHT

Powered by Google App Engine
This is Rietveld