| Index: trunk/extensions/FlaggedRevs/FlaggedRevs.sql |
| — | — | @@ -89,7 +89,7 @@ |
| 90 | 90 | -- Name of included image |
| 91 | 91 | fi_name varchar(255) binary NOT NULL default '', |
| 92 | 92 | -- Timestamp of image used when reviewed |
| 93 | | - fi_img_timestamp char(14) NOT NULL, |
| | 93 | + fi_img_timestamp char(14) NOT NULL default '', |
| 94 | 94 | -- Statistically unique SHA-1 key |
| 95 | 95 | fi_img_sha1 varbinary(32) NOT NULL default '', |
| 96 | 96 | |
| Index: trunk/extensions/FlaggedRevs/FlaggedRevs.pg.sql |
| — | — | @@ -48,10 +48,10 @@ |
| 49 | 49 | ); |
| 50 | 50 | |
| 51 | 51 | CREATE TABLE flaggedimages ( |
| 52 | | - fi_rev_id INTEGER NOT NULL DEFAULT 0, |
| 53 | | - fi_name TEXT NOT NULL, |
| 54 | | - fi_img_timestamp TIMESTAMPTZ, |
| 55 | | - fi_img_sha1 CHAR(64), |
| | 52 | + fi_rev_id INTEGER NOT NULL DEFAULT 0, |
| | 53 | + fi_name TEXT NOT NULL DEFAULT '', |
| | 54 | + fi_img_timestamp TIMESTAMPTZ NOT NULL DEFAULT '', |
| | 55 | + fi_img_sha1 CHAR(64) NOT NULL DEFAULT '', |
| 56 | 56 | PRIMARY KEY (fi_rev_id,fi_name) |
| 57 | 57 | ); |
| 58 | 58 | |