Side by Side Diff: sitescripts/urlfixer/schema.sql
Issue 8483155:
Added typo data collection (/submitData) (Closed)
Patch Set:
Created Oct. 9, 2012, 2:27 p.m.
| Left: | ||
| Right: |
Use n/p to move between diff chunks;
N/P to move between comments.
« no previous file with comments
|
« sitescripts/urlfixer/__init__.py ('k')
|
sitescripts/urlfixer/web/__init__.py » ('j')
|
no next file with comments »
Toggle Intra-line Diffs ('i') | Expand Comments ('e') | Collapse Comments ('c') | Hide Comments ('s')
Toggle Intra-line Diffs ('i') | Expand Comments ('e') | Collapse Comments ('c') | Hide Comments ('s')
| OLD | NEW |
|---|---|
| (Empty) | |
| 1 DROP TABLE IF EXISTS domains; | |
| 2 DROP TABLE IF EXISTS corrections; | |
| 3 | |
| 4 CREATE TABLE domains( | |
| 5 id INT NOT NULL AUTO_INCREMENT, | |
| 6 domain VARCHAR(50) NOT NULL, | |
| 7 PRIMARY KEY(id), | |
| 8 UNIQUE(domain) | |
| 9 ); | |
| 10 | |
| 11 CREATE TABLE corrections( | |
| 12 id INT NOT NULL AUTO_INCREMENT, | |
| 13 domain INT NOT NULL, | |
| 14 status INT NOT NULL, | |
| 15 curr_month INT NOT NULL, | |
| 16 prev_month INT NOT NULL, | |
| 17 curr_year INT NOT NULL, | |
| 18 prev_year INT NOT NULL, | |
| 19 PRIMARY KEY(id), | |
| 20 FOREIGN KEY(domain) REFERENCES domains(id), | |
| 21 UNIQUE(domain, status) | |
| 22 ); | |
| OLD | NEW |
« no previous file with comments
|
« sitescripts/urlfixer/__init__.py ('k')
|
sitescripts/urlfixer/web/__init__.py » ('j')
|
no next file with comments »
