| Index: trunk/extensions/FlaggedRevs/postgres/patch-flaggedpages.sql |
| — | — | @@ -1,10 +1,10 @@ |
| 2 | 2 | BEGIN; |
| 3 | 3 | |
| 4 | 4 | CREATE TABLE flaggedpages ( |
| 5 | | - fp_page_id INTEGER NOT NULL DEFAULT 0 , |
| 6 | | - fp_reviewed INTEGER NOT NULL DEFAULT 0 , |
| 7 | | - fp_stable INTEGER NULL, |
| 8 | | - fp_quality INTEGER default NULL, |
| | 5 | + fp_page_id BIGINT NOT NULL DEFAULT 0, |
| | 6 | + fp_reviewed INTEGER NOT NULL DEFAULT 0, |
| | 7 | + fp_stable BIGINT NOT NULL DEFAULT 0, |
| | 8 | + fp_quality INTEGER default NULL, |
| 9 | 9 | PRIMARY KEY (fp_page_id) |
| 10 | 10 | ); |
| 11 | 11 | CREATE INDEX fp_reviewed_page ON flaggedpages (fp_reviewed,fp_page_id), |