| Index: trunk/extensions/FlaggedRevs/schema/postgres/FlaggedRevs.pg.sql |
| — | — | @@ -82,4 +82,12 @@ |
| 83 | 83 | frp_user_params TEXT NOT NULL default '' |
| 84 | 84 | ); |
| 85 | 85 | |
| | 86 | +CREATE TABLE flaggedrevs_statistics ( |
| | 87 | + frs_timestamp TIMESTAMPTZ NOT NULL, |
| | 88 | + frs_stat_key TEXT NOT NULL, |
| | 89 | + frs_stat_val BIGINT NOT NULL, |
| | 90 | + PRIMARY KEY(frs_stat_key,frs_timestamp) |
| | 91 | +) /*$wgDBTableOptions*/; |
| | 92 | +CREATE INDEX frs_timestamp ON flaggedrevs_statistics (frs_timestamp); |
| | 93 | + |
| 86 | 94 | COMMIT; |