| Index: trunk/phase3/maintenance/postgres/archives/patch-protected_titles.sql |
| — | — | @@ -0,0 +1,11 @@ |
| | 2 | +CREATE TABLE protected_titles ( |
| | 3 | + pt_namespace SMALLINT NOT NULL, |
| | 4 | + pt_title TEXT NOT NULL, |
| | 5 | + pt_by INTEGER NOT NULL, |
| | 6 | + pt_reason TEXT, |
| | 7 | + pt_timestamp TIMESTAMPTZ NOT NULL, |
| | 8 | + pt_expiry TIMESTAMPTZ NULL, |
| | 9 | + pt_create_perm TEXT NOT NULL DEFAULT '' |
| | 10 | +); |
| | 11 | +CREATE UNIQUE INDEX protected_titles_unique ON protected_titles(pt_namespace, pt_title); |
| | 12 | +CREATE INDEX protected_titles_index ON protected_titles(pt_by, pt_timestamp); |
| Property changes on: trunk/phase3/maintenance/postgres/archives/patch-protected_titles.sql |
| ___________________________________________________________________ |
| Added: svn:eol-style |
| 1 | 13 | + native |
| Index: trunk/phase3/maintenance/postgres/tables.sql |
| — | — | @@ -506,6 +506,17 @@ |
| 507 | 507 | ); |
| 508 | 508 | CREATE UNIQUE INDEX pf_name_server ON profiling (pf_name, pf_server); |
| 509 | 509 | |
| | 510 | +CREATE TABLE protected_titles ( |
| | 511 | + pt_namespace SMALLINT NOT NULL, |
| | 512 | + pt_title TEXT NOT NULL, |
| | 513 | + pt_by INTEGER NOT NULL, |
| | 514 | + pt_reason TEXT, |
| | 515 | + pt_timestamp TIMESTAMPTZ NOT NULL, |
| | 516 | + pt_expiry TIMESTAMPTZ NULL, |
| | 517 | + pt_create_perm TEXT NOT NULL DEFAULT '' |
| | 518 | +); |
| | 519 | +CREATE UNIQUE INDEX protected_titles_unique ON protected_titles(pt_namespace, pt_title); |
| | 520 | +CREATE INDEX protected_titles_index ON protected_titles(pt_by, pt_timestamp); |
| 510 | 521 | |
| 511 | 522 | CREATE TABLE mediawiki_version ( |
| 512 | 523 | type TEXT NOT NULL, |
| — | — | @@ -528,4 +539,3 @@ |
| 529 | 540 | INSERT INTO mediawiki_version (type,mw_version,sql_version,sql_date) |
| 530 | 541 | VALUES ('Creation','??','$LastChangedRevision$','$LastChangedDate$'); |
| 531 | 542 | |
| 532 | | - |
| Index: trunk/phase3/maintenance/updaters.inc |
| — | — | @@ -1325,6 +1325,7 @@ |
| 1326 | 1326 | array("querycachetwo", "patch-querycachetwo.sql"), |
| 1327 | 1327 | array("page_restrictions", "patch-page_restrictions.sql"), |
| 1328 | 1328 | array("profiling", "patch-profiling.sql"), |
| | 1329 | + array("protected_titles", "patch-protected_titles.sql"), |
| 1329 | 1330 | array("redirect", "patch-redirect.sql"), |
| 1330 | 1331 | ); |
| 1331 | 1332 | |