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

Side by Side Diff: sitescripts/urlfixer/schema.sql

Issue 8943045: Implemented extraction of URL Fixer data (Closed)
Patch Set: Created Nov. 28, 2012, 10:48 a.m.
Left:
Right:
Use n/p to move between diff chunks; N/P to move between comments.
Jump to:
View unified diff | Download patch
« no previous file with comments | « sitescripts/urlfixer/bin/topDomains.py ('k') | no next file » | no next file with comments »
Toggle Intra-line Diffs ('i') | Expand Comments ('e') | Collapse Comments ('c') | Show Comments Hide Comments ('s')
OLDNEW
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 PRIMARY KEY(id), 8 PRIMARY KEY(id),
8 UNIQUE(domain) 9 UNIQUE(domain)
9 ); 10 );
10 11
11 CREATE TABLE corrections( 12 CREATE TABLE corrections(
12 id INT NOT NULL AUTO_INCREMENT, 13 id INT NOT NULL AUTO_INCREMENT,
13 domain INT NOT NULL, 14 domain INT NOT NULL,
14 status INT NOT NULL, 15 status INT NOT NULL,
15 curr_month INT NOT NULL, 16 curr_month INT NOT NULL,
16 prev_month INT NOT NULL, 17 prev_month INT NOT NULL,
17 curr_year INT NOT NULL, 18 curr_year INT NOT NULL,
18 prev_year INT NOT NULL, 19 prev_year INT NOT NULL,
19 PRIMARY KEY(id), 20 PRIMARY KEY(id),
20 FOREIGN KEY(domain) REFERENCES domains(id), 21 FOREIGN KEY(domain) REFERENCES domains(id),
21 UNIQUE(domain, status) 22 UNIQUE(domain, status)
22 ); 23 );
OLDNEW
« no previous file with comments | « sitescripts/urlfixer/bin/topDomains.py ('k') | no next file » | no next file with comments »

Powered by Google App Engine
This is Rietveld