| Index: trunk/extensions/FlaggedRevs/FlaggedRevs.sql |
| — | — | @@ -94,7 +94,7 @@ |
| 95 | 95 | -- Name of included image |
| 96 | 96 | fi_name varchar(255) binary NOT NULL default '', |
| 97 | 97 | -- Timestamp of image used when reviewed |
| 98 | | - fi_img_timestamp char(14) NOT NULL default '', |
| | 98 | + fi_img_timestamp char(14) NULL, |
| 99 | 99 | -- Statistically unique SHA-1 key |
| 100 | 100 | fi_img_sha1 varbinary(32) NOT NULL default '', |
| 101 | 101 | |
| Index: trunk/extensions/FlaggedRevs/FlaggedRevs.pg.sql |
| — | — | @@ -53,8 +53,7 @@ |
| 54 | 54 | CREATE TABLE flaggedimages ( |
| 55 | 55 | fi_rev_id BIGINT NOT NULL DEFAULT 0, |
| 56 | 56 | fi_name TEXT NOT NULL DEFAULT '', |
| 57 | | - -- MW timestamp |
| 58 | | - fi_img_timestamp TIMESTAMPTZ NOT NULL, |
| | 57 | + fi_img_timestamp TIMESTAMPTZ NULL DEFAULT NULL, |
| 59 | 58 | fi_img_sha1 CHAR(64) NOT NULL DEFAULT '', |
| 60 | 59 | PRIMARY KEY (fi_rev_id,fi_name) |
| 61 | 60 | ); |
| Index: trunk/extensions/FlaggedRevs/archives/patch-fi_img_timestamp.sql |
| — | — | @@ -0,0 +1,6 @@ |
| | 2 | +-- Fix bad fi_img_timestamp definition |
| | 3 | +ALTER TABLE /*$wgDBprefix*/flaggedimages |
| | 4 | + CHANGE fi_img_timestamp fi_img_timestamp char(14) NULL; |
| | 5 | +-- Move bad values over to NULL |
| | 6 | +UPDATE /*$wgDBprefix*/flaggedimages |
| | 7 | + SET fi_img_timestamp = NULL WHERE fi_img_timestamp = '0\0\0\0\0\0\0\0\0\0\0\0\0\0'; |
| Property changes on: trunk/extensions/FlaggedRevs/archives/patch-fi_img_timestamp.sql |
| ___________________________________________________________________ |
| Name: svn:eol-style |
| 1 | 8 | + native |
| Index: trunk/extensions/FlaggedRevs/postgres/patch-fi_img_timestamp.sql |
| — | — | @@ -0,0 +1,6 @@ |
| | 2 | +BEGIN; |
| | 3 | + |
| | 4 | +ALTER TABLE flaggedimages |
| | 5 | + CHANGE fi_img_timestamp fi_img_timestamp TIMESTAMPTZ NULL; |
| | 6 | + |
| | 7 | +COMMIT; |
| Property changes on: trunk/extensions/FlaggedRevs/postgres/patch-fi_img_timestamp.sql |
| ___________________________________________________________________ |
| Name: svn:eol-style |
| 1 | 8 | + native |