| Index: trunk/extensions/PageTriage/sql/PageTriage.sql |
| — | — | @@ -2,12 +2,12 @@ |
| 3 | 3 | -- mapping table for users to revisions |
| 4 | 4 | -- this information persists forever. |
| 5 | 5 | CREATE TABLE /*_*/pagetriage ( |
| 6 | | - ptr_user_id int UNSIGNED NOT NULL, |
| | 6 | + ptr_user int UNSIGNED NOT NULL, |
| 7 | 7 | ptr_recentchanges_id int NOT NULL, |
| 8 | 8 | ptr_timestamp varbinary(14) NOT NULL |
| 9 | 9 | ) /*$wgDBTableOptions*/; |
| 10 | 10 | |
| 11 | | -CREATE UNIQUE INDEX /*i*/ptr_user_rc ON /*_*/pagetriage (ptr_user_id,ptr_recentchanges_id); |
| | 11 | +CREATE UNIQUE INDEX /*i*/ptr_user_rc ON /*_*/pagetriage (ptr_user,ptr_recentchanges_id); |
| 12 | 12 | |
| 13 | 13 | -- this stores when a page was checked. we'll be interested in that sometimes. |
| 14 | 14 | CREATE INDEX /*i*/ptr_timestamp ON /*_*/pagetriage (ptr_timestamp); |
| — | — | @@ -18,9 +18,9 @@ |
| 19 | 19 | -- If it's cleared, it'll lead to edit conflicts for a few minutes but it's not a big deal. |
| 20 | 20 | CREATE TABLE /*_*/pagetriage_checkouts ( |
| 21 | 21 | ptc_id int UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, |
| 22 | | - ptc_user_id int UNSIGNED NOT NULL, |
| | 22 | + ptc_user int UNSIGNED NOT NULL, |
| 23 | 23 | ptc_recentchanges_id int NOT NULL, |
| 24 | 24 | ptc_timestamp varbinary(14) NOT NULL |
| 25 | 25 | ) /*$wgDBTableOptions*/; |
| 26 | 26 | |
| 27 | | -CREATE UNIQUE INDEX /*i*/ptc_user_rc ON /*_*/pagetriage_checkouts (ptc_user_id,ptc_recentchanges_id); |
| | 27 | +CREATE UNIQUE INDEX /*i*/ptc_user_rc ON /*_*/pagetriage_checkouts (ptc_user,ptc_recentchanges_id); |