Side by Side Diff: sitescripts/urlfixer/schema.sql
Issue 8483155:
Added typo data collection (/submitData) (Closed)
Patch Set:
Created Oct. 9, 2012, 1:46 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')
|
sitescripts/urlfixer/web/submitData.py » ('J')
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 ); | |
| 9 | |
| 10 CREATE TABLE corrections( | |
| 11 id INT NOT NULL AUTO_INCREMENT, | |
| 12 domain INT NOT NULL, | |
| 13 status INT NOT NULL, | |
| 14 curr_month INT NOT NULL, | |
| 15 prev_month INT NOT NULL, | |
| 16 curr_year INT NOT NULL, | |
| 17 prev_year INT NOT NULL, | |
| 18 PRIMARY KEY(id), | |
| 19 FOREIGN KEY(domain) REFERENCES domains(id) | |
| 20 ); | |
| 21 | |
| 22 CREATE UNIQUE INDEX idx_domain ON domains(domain); | |
| 23 CREATE UNIQUE INDEX idx_domain_status ON corrections(domain, status); | |
| OLD | NEW |
« no previous file with comments
|
« sitescripts/urlfixer/__init__.py ('k')
|
sitescripts/urlfixer/web/__init__.py » ('j')
|
sitescripts/urlfixer/web/submitData.py » ('J')
