| Index: trunk/extensions/FlaggedRevs/FlaggedRevs.sql |
| — | — | @@ -10,7 +10,7 @@ |
| 11 | 11 | -- Is the stable version synced? |
| 12 | 12 | fp_reviewed bool NOT NULL default '0', |
| 13 | 13 | -- When (or NULL) the first edit after the stable version was made |
| 14 | | - fp_pending_since char(14) NULL, |
| | 14 | + fp_pending_since varbinary(14) NULL, |
| 15 | 15 | -- Foreign key to flaggedrevs.fr_rev_id |
| 16 | 16 | fp_stable integer unsigned NOT NULL, |
| 17 | 17 | -- The highest quality of the page's reviewed revisions. |
| — | — | @@ -31,7 +31,7 @@ |
| 32 | 32 | -- The last rev ID with this quality |
| 33 | 33 | fpp_rev_id integer unsigned NOT NULL, |
| 34 | 34 | -- Time of the first edit after the last revision reviewed to this level |
| 35 | | - fpp_pending_since char(14) NOT NULL, |
| | 35 | + fpp_pending_since varbinary(14) NOT NULL, |
| 36 | 36 | |
| 37 | 37 | PRIMARY KEY (fpp_page_id,fpp_quality) |
| 38 | 38 | ) /*$wgDBTableOptions*/; |
| — | — | @@ -47,7 +47,7 @@ |
| 48 | 48 | fr_rev_id integer unsigned NOT NULL, |
| 49 | 49 | -- Foreign key to user.user_id |
| 50 | 50 | fr_user integer unsigned NOT NULL, |
| 51 | | - fr_timestamp char(14) NOT NULL, |
| | 51 | + fr_timestamp varbinary(14) NOT NULL, |
| 52 | 52 | fr_comment mediumblob NOT NULL, |
| 53 | 53 | -- Store the precedence level |
| 54 | 54 | fr_quality tinyint(1) NOT NULL default 0, |
| — | — | @@ -66,7 +66,7 @@ |
| 67 | 67 | -- Name of included image (NULL if n/a) |
| 68 | 68 | fr_img_name varchar(255) binary NULL default NULL, |
| 69 | 69 | -- Timestamp of file (when uploaded) (NULL if n/a) |
| 70 | | - fr_img_timestamp char(14) NULL default NULL, |
| | 70 | + fr_img_timestamp varbinary(14) NULL default NULL, |
| 71 | 71 | -- Statistically unique SHA-1 key (NULL if n/a) |
| 72 | 72 | fr_img_sha1 varbinary(32) NULL default NULL, |
| 73 | 73 | |
| — | — | @@ -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) NULL, |
| | 98 | + fi_img_timestamp varbinary(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/mysql/patch-flaggedpage_pending.sql |
| — | — | @@ -7,7 +7,7 @@ |
| 8 | 8 | -- The last rev ID with this quality |
| 9 | 9 | fpp_rev_id integer unsigned NOT NULL, |
| 10 | 10 | -- Time (or NULL) of the first edit after the last revision reviewed to this level |
| 11 | | - fpp_pending_since char(14) NOT NULL, |
| | 11 | + fpp_pending_since varbinary(14) NOT NULL, |
| 12 | 12 | |
| 13 | 13 | PRIMARY KEY (fpp_page_id,fpp_quality), |
| 14 | 14 | INDEX fpp_quality_pending (fpp_quality,fpp_pending_since) |
| Index: trunk/extensions/FlaggedRevs/mysql/patch-fp_pending_since.sql |
| — | — | @@ -1,4 +1,4 @@ |
| 2 | 2 | -- Add timestamp column of first unreviewed rev for flaggedrevs |
| 3 | 3 | ALTER TABLE /*$wgDBprefix*/flaggedpages |
| 4 | | - ADD fp_pending_since char(14) NULL, |
| | 4 | + ADD fp_pending_since varbinary(14) NULL, |
| 5 | 5 | ADD INDEX fp_pending_since (fp_pending_since); |
| Index: trunk/extensions/FlaggedRevs/mysql/patch-fi_img_timestamp.sql |
| — | — | @@ -1,6 +1,6 @@ |
| 2 | 2 | -- Fix bad fi_img_timestamp definition |
| 3 | 3 | ALTER TABLE /*$wgDBprefix*/flaggedimages |
| 4 | | - CHANGE fi_img_timestamp fi_img_timestamp char(14) NULL; |
| | 4 | + CHANGE fi_img_timestamp fi_img_timestamp varbinary(14) NULL; |
| 5 | 5 | -- Move bad values over to NULL |
| 6 | 6 | UPDATE /*$wgDBprefix*/flaggedimages |
| 7 | 7 | SET fi_img_timestamp = NULL WHERE LOCATE( '\0', fi_img_timestamp ); |
| Index: trunk/extensions/FlaggedRevs/mysql/patch-fr_img_name.sql |
| — | — | @@ -3,7 +3,7 @@ |
| 4 | 4 | -- Name of included image |
| 5 | 5 | ADD fr_img_name varchar(255) binary NULL default NULL, |
| 6 | 6 | -- Timestamp of file (when uploaded) |
| 7 | | - ADD fr_img_timestamp char(14) NULL default NULL, |
| | 7 | + ADD fr_img_timestamp varbinary(14) NULL default NULL, |
| 8 | 8 | -- Statistically unique SHA-1 key |
| 9 | 9 | ADD fr_img_sha1 varbinary(32) NULL default NULL, |
| 10 | 10 | ADD INDEX fr_img_sha1 (fr_img_sha1); |