| Index: trunk/extensions/ArticleAssessmentPilot/ArticleAssessmentPilot.sql |
| — | — | @@ -21,11 +21,13 @@ |
| 22 | 22 | -- Store article assessments |
| 23 | 23 | CREATE TABLE IF NOT EXISTS /*$wgDBprefix*/article_assessment_pages ( |
| 24 | 24 | -- Foreign key to page.page_id |
| 25 | | - aa_page_id integer unsigned NOT NULL, |
| | 25 | + aap_page_id integer unsigned NOT NULL, |
| 26 | 26 | -- Foreign key to revision.rev_id |
| 27 | | - aa_revision integer unsigned NOT NULL, |
| 28 | | - aa_total integer unsigned NOT NULL, |
| 29 | | - aa_count integer unsigned NOT NULL, |
| 30 | | - aa_dimension integer unsigned NOT NULL, |
| 31 | | - PRIMARY KEY (aa_page_id, aa_revision, aa_dimension) |
| 32 | | -) /*$wgDBTableOptions*/; |
| \ No newline at end of file |
| | 27 | + aap_revision integer unsigned NOT NULL, |
| | 28 | + aap_total integer unsigned NOT NULL, |
| | 29 | + aap_count integer unsigned NOT NULL, |
| | 30 | + aap_dimension integer unsigned NOT NULL, |
| | 31 | + PRIMARY KEY (aap_page_id, aap_revision, aap_dimension) |
| | 32 | +) /*$wgDBTableOptions*/; |
| | 33 | + |
| | 34 | +CREATE INDEX /*i*/revision ON /*_*/article_assessment_pages (aap_revision, aap_page_id, aap_dimension); |
| \ No newline at end of file |