| Index: branches/wmf/1.18wmf1/extensions/FlaggedRevs/schema/mysql/patch-flaggedrevs_statistics-wmf.sql |
| — | — | @@ -0,0 +1,11 @@ |
| | 2 | +-- This stores overall stats |
| | 3 | +CREATE TABLE /*_*/flaggedrevs_statistics ( |
| | 4 | + -- Timestamp stat was recorded |
| | 5 | + frs_timestamp varbinary(14) NOT NULL, |
| | 6 | + -- Stat key name, colons separate paramaters |
| | 7 | + frs_stat_key varchar(255) NOT NULL, |
| | 8 | + -- Stat value as an integer |
| | 9 | + frs_stat_val bigint NOT NULL, |
| | 10 | + PRIMARY KEY(frs_stat_key,frs_timestamp) |
| | 11 | +) /*$wgDBTableOptions*/; |
| | 12 | +CREATE INDEX /*i*/frs_timestamp ON /*_*/flaggedrevs_statistics (frs_timestamp); |