| Index: trunk/extensions/FlaggedRevs/FlaggedRevs.pg.sql |
| — | — | @@ -10,8 +10,8 @@ |
| 11 | 11 | fp_quality INTEGER NULL default NULL, |
| 12 | 12 | PRIMARY KEY (fp_page_id) |
| 13 | 13 | ); |
| 14 | | -CREATE INDEX fp_reviewed_page ON flaggedpages (fp_reviewed,fp_page_id), |
| 15 | | -CREATE INDEX fp_quality_page ON flaggedpages (fp_quality,fp_page_id) |
| | 14 | +CREATE INDEX fp_reviewed_page ON flaggedpages (fp_reviewed,fp_page_id); |
| | 15 | +CREATE INDEX fp_quality_page ON flaggedpages (fp_quality,fp_page_id); |
| 16 | 16 | |
| 17 | 17 | CREATE TABLE flaggedrevs ( |
| 18 | 18 | fr_page_id INTEGER NOT NULL DEFAULT 0, |
| — | — | @@ -36,7 +36,7 @@ |
| 37 | 37 | fpc_select INTEGER NOT NULL DEFAULT 0, |
| 38 | 38 | fpc_override INTEGER NOT NULL, |
| 39 | 39 | fpc_expiry TIMESTAMPTZ NULL |
| 40 | | -) |
| | 40 | +); |
| 41 | 41 | CREATE INDEX fpc_expiry ON flaggedpage_config (fpc_expiry); |
| 42 | 42 | |
| 43 | 43 | CREATE TABLE flaggedtemplates ( |
| — | — | @@ -50,7 +50,7 @@ |
| 51 | 51 | CREATE TABLE flaggedimages ( |
| 52 | 52 | fi_rev_id INTEGER NOT NULL DEFAULT 0, |
| 53 | 53 | fi_name TEXT NOT NULL DEFAULT '', |
| 54 | | - fi_img_timestamp TIMESTAMPTZ NOT NULL DEFAULT '', |
| | 54 | + fi_img_timestamp TIMESTAMPTZ NOT NULL, |
| 55 | 55 | fi_img_sha1 CHAR(64) NOT NULL DEFAULT '', |
| 56 | 56 | PRIMARY KEY (fi_rev_id,fi_name) |
| 57 | 57 | ); |