| Index: trunk/extensions/FlaggedRevs/FlaggedRevs.sql |
| — | — | @@ -46,7 +46,7 @@ |
| 47 | 47 | -- Foreign key to revision.rev_id |
| 48 | 48 | fr_rev_id integer unsigned NOT NULL, |
| 49 | 49 | -- Foreign key to user.user_id |
| 50 | | - fr_user int(5) NOT NULL, |
| | 50 | + fr_user integer unsigned NOT NULL, |
| 51 | 51 | fr_timestamp char(14) NOT NULL, |
| 52 | 52 | fr_comment mediumblob NOT NULL, |
| 53 | 53 | -- Store the precedence level |
| Index: trunk/extensions/FlaggedRevs/FlaggedRevs.pg.sql |
| — | — | @@ -4,10 +4,10 @@ |
| 5 | 5 | BEGIN; |
| 6 | 6 | |
| 7 | 7 | CREATE TABLE flaggedpages ( |
| 8 | | - fp_page_id INTEGER NOT NULL DEFAULT 0, |
| | 8 | + fp_page_id BIGINT NOT NULL DEFAULT 0, |
| 9 | 9 | fp_reviewed INTEGER NOT NULL DEFAULT 0, |
| 10 | 10 | fp_pending_since TIMESTAMPTZ NULL, |
| 11 | | - fp_stable INTEGER NOT NULL DEFAULT 0, |
| | 11 | + fp_stable BIGINT NOT NULL DEFAULT 0, |
| 12 | 12 | fp_quality INTEGER NULL default NULL, |
| 13 | 13 | PRIMARY KEY (fp_page_id) |
| 14 | 14 | ); |
| — | — | @@ -16,21 +16,21 @@ |
| 17 | 17 | CREATE INDEX fp_pending_since ON flaggedpages (fp_pending_since); |
| 18 | 18 | |
| 19 | 19 | CREATE TABLE flaggedpage_pending ( |
| 20 | | - fpp_page_id INTEGER UNSIGNED NOT NULL, |
| | 20 | + fpp_page_id BIGINT NOT NULL, |
| 21 | 21 | fpp_quality INTEGER NOT NULL, |
| 22 | | - fpp_rev_id INTEGER UNSIGNED NOT NULL, |
| | 22 | + fpp_rev_id BIGINT NOT NULL, |
| 23 | 23 | fpp_pending_since TIMESTAMPTZ NULL, |
| 24 | 24 | PRIMARY KEY (fpp_page_id,fpp_quality) |
| 25 | 25 | ); |
| 26 | 26 | CREATE INDEX fpp_quality_pending ON flaggedpage_pending (fpp_quality,fpp_pending_since); |
| 27 | 27 | |
| 28 | 28 | CREATE TABLE flaggedrevs ( |
| 29 | | - fr_page_id INTEGER NOT NULL DEFAULT 0, |
| 30 | | - fr_rev_id INTEGER NOT NULL DEFAULT 0, |
| 31 | | - fr_user INTEGER NULL REFERENCES mwuser(user_id) ON DELETE SET NULL, |
| | 29 | + fr_page_id BIGINT NOT NULL DEFAULT 0, |
| | 30 | + fr_rev_id BIGINT NOT NULL DEFAULT 0, |
| | 31 | + fr_user BIGINT NULL REFERENCES mwuser(user_id) ON DELETE SET NULL, |
| 32 | 32 | fr_timestamp TIMESTAMPTZ, |
| 33 | 33 | fr_comment TEXT NOT NULL DEFAULT '', |
| 34 | | - fr_quality INTEGER NOT NULL DEFAULT 0, |
| | 34 | + fr_quality INTEGER NOT NULL DEFAULT 0, |
| 35 | 35 | fr_tags TEXT NOT NULL DEFAULT '', |
| 36 | 36 | fr_text TEXT NOT NULL DEFAULT '', |
| 37 | 37 | fr_flags TEXT NOT NULL, |
| — | — | @@ -42,43 +42,43 @@ |
| 43 | 43 | CREATE INDEX page_qal_rev ON flaggedrevs (fr_page_id,fr_quality,fr_rev_id); |
| 44 | 44 | CREATE INDEX fr_img_sha1 ON flaggedrevs (fr_img_sha1); |
| 45 | 45 | |
| 46 | | -CREATE TABLE flaggedpage_config ( |
| 47 | | - fpc_page_id INTEGER NOT NULL PRIMARY KEY DEFAULT 0, |
| 48 | | - fpc_select INTEGER NOT NULL, |
| 49 | | - fpc_override INTEGER NOT NULL, |
| 50 | | - fpc_level TEXT NULL, |
| 51 | | - fpc_expiry TIMESTAMPTZ NULL |
| 52 | | -); |
| 53 | | -CREATE INDEX fpc_expiry ON flaggedpage_config (fpc_expiry); |
| 54 | | - |
| 55 | 46 | CREATE TABLE flaggedtemplates ( |
| 56 | | - ft_rev_id INTEGER NOT NULL DEFAULT 0 , |
| | 47 | + ft_rev_id BIGINT NOT NULL DEFAULT 0 , |
| 57 | 48 | ft_namespace SMALLINT NOT NULL DEFAULT 0, |
| 58 | | - ft_title TEXT NOT NULL DEFAULT '', |
| 59 | | - ft_tmp_rev_id INTEGER NOT NULL DEFAULT 0, |
| | 49 | + ft_title TEXT NOT NULL DEFAULT '', |
| | 50 | + ft_tmp_rev_id BIGINT NOT NULL DEFAULT 0, |
| 60 | 51 | PRIMARY KEY (ft_rev_id,ft_namespace,ft_title) |
| 61 | 52 | ); |
| 62 | 53 | |
| 63 | 54 | CREATE TABLE flaggedimages ( |
| 64 | | - fi_rev_id INTEGER NOT NULL DEFAULT 0, |
| | 55 | + fi_rev_id BIGINT NOT NULL DEFAULT 0, |
| 65 | 56 | fi_name TEXT NOT NULL DEFAULT '', |
| 66 | 57 | -- MW timestamp |
| 67 | 58 | fi_img_timestamp TIMESTAMPTZ NOT NULL, |
| 68 | | - fi_img_sha1 CHAR(64) NOT NULL DEFAULT '', |
| | 59 | + fi_img_sha1 CHAR(64) NOT NULL DEFAULT '', |
| 69 | 60 | PRIMARY KEY (fi_rev_id,fi_name) |
| 70 | 61 | ); |
| 71 | 62 | |
| | 63 | +CREATE TABLE flaggedpage_config ( |
| | 64 | + fpc_page_id BIGINT NOT NULL PRIMARY KEY DEFAULT 0, |
| | 65 | + fpc_select INTEGER NOT NULL, |
| | 66 | + fpc_override INTEGER NOT NULL, |
| | 67 | + fpc_level TEXT NULL, |
| | 68 | + fpc_expiry TIMESTAMPTZ NULL |
| | 69 | +); |
| | 70 | +CREATE INDEX fpc_expiry ON flaggedpage_config (fpc_expiry); |
| | 71 | + |
| 72 | 72 | CREATE TABLE flaggedrevs_tracking ( |
| 73 | | - ftr_from INTEGER NOT NULL DEFAULT 0, |
| 74 | | - ftr_namespace SMALLINT NOT NULL DEFAULT 0, |
| | 73 | + ftr_from BIGINT NOT NULL DEFAULT 0, |
| | 74 | + ftr_namespace SMALLINT NOT NULL DEFAULT 0, |
| 75 | 75 | ftr_title TEXT NOT NULL DEFAULT '', |
| 76 | 76 | PRIMARY KEY (ftr_from,ftr_namespace,ftr_title) |
| 77 | 77 | ); |
| 78 | 78 | CREATE INDEX namespace_title_from ON flaggedrevs_tracking (ftr_namespace,ftr_title,ftr_from); |
| 79 | 79 | |
| 80 | 80 | CREATE TABLE flaggedrevs_promote ( |
| 81 | | - frp_user_id INTEGER NOT NULL PRIMARY KEY default 0, |
| 82 | | - frp_user_params TEXT NOT NULL default '' |
| | 81 | + frp_user_id BIGINT NOT NULL PRIMARY KEY default 0, |
| | 82 | + frp_user_params TEXT NOT NULL default '' |
| 83 | 83 | ); |
| 84 | 84 | |
| 85 | 85 | COMMIT; |