| Index: trunk/extensions/FlaggedRevs/schema/mysql/FlaggedRevs.sql |
| — | — | @@ -36,7 +36,7 @@ |
| 37 | 37 | ) /*$wgDBTableOptions*/; |
| 38 | 38 | |
| 39 | 39 | CREATE INDEX /*i*/fpp_quality_pending |
| 40 | | - ON /*_*/flaggedpage_pending (fpp_quality,fpp_pending_since); |
| | 40 | + ON /*_*/flaggedpage_pending (fpp_quality,fpp_pending_since); |
| 41 | 41 | |
| 42 | 42 | -- This stores all of our revision reviews; it is the main table |
| 43 | 43 | -- The template/file version data is stored in the next two tables |
| — | — | @@ -128,9 +128,9 @@ |
| 129 | 129 | ) /*$wgDBTableOptions*/; |
| 130 | 130 | |
| 131 | 131 | CREATE UNIQUE INDEX /*i*/from_namespace_title |
| 132 | | - ON /*_*/flaggedrevs_tracking (ftr_from,ftr_namespace,ftr_title); |
| | 132 | + ON /*_*/flaggedrevs_tracking (ftr_from,ftr_namespace,ftr_title); |
| 133 | 133 | CREATE INDEX /*i*/namespace_title_from |
| 134 | | - ON /*_*/flaggedrevs_tracking (ftr_namespace,ftr_title,ftr_from); |
| | 134 | + ON /*_*/flaggedrevs_tracking (ftr_namespace,ftr_title,ftr_from); |
| 135 | 135 | |
| 136 | 136 | -- This stores user demotions and stats |
| 137 | 137 | CREATE TABLE IF NOT EXISTS /*_*/flaggedrevs_promote ( |
| — | — | @@ -141,12 +141,12 @@ |
| 142 | 142 | |
| 143 | 143 | -- This stores overall stats |
| 144 | 144 | CREATE TABLE /*_*/flaggedrevs_statistics ( |
| 145 | | - -- Timestamp stat was recorded |
| 146 | | - frs_timestamp varbinary(14) NOT NULL, |
| 147 | | - -- Stat key name, colons separate paramaters |
| 148 | | - frs_stat_key varchar(255) NOT NULL, |
| 149 | | - -- Stat value as an integer |
| 150 | | - frs_stat_val bigint NOT NULL, |
| 151 | | - PRIMARY KEY(frs_stat_key,frs_timestamp) |
| | 145 | + -- Timestamp stat was recorded |
| | 146 | + frs_timestamp varbinary(14) NOT NULL, |
| | 147 | + -- Stat key name, colons separate paramaters |
| | 148 | + frs_stat_key varchar(255) NOT NULL, |
| | 149 | + -- Stat value as an integer |
| | 150 | + frs_stat_val bigint NOT NULL, |
| | 151 | + PRIMARY KEY(frs_stat_key,frs_timestamp) |
| 152 | 152 | ) /*$wgDBTableOptions*/; |
| 153 | 153 | CREATE INDEX /*i*/frs_timestamp ON /*_*/flaggedrevs_statistics (frs_timestamp); |