diff options
| author | River Tarnell <river@users.mediawiki.org> | 2007-03-08 02:39:03 +0000 |
|---|---|---|
| committer | River Tarnell <river@users.mediawiki.org> | 2007-03-08 02:39:03 +0000 |
| commit | bbfad4fc598c2b46cb97566012d8534b4af05697 (patch) | |
| tree | 432160597ea35ed844414944b6c475e8ce78580d /maintenance/postgres/archives/patch-page_restrictions.sql | |
| parent | 21f50c06f4a24668c1dd728ee9a16d55bb10d14c (diff) | |
| download | mediawikicore-bbfad4fc598c2b46cb97566012d8534b4af05697.tar.gz mediawikicore-bbfad4fc598c2b46cb97566012d8534b4af05697.zip | |
* (bug 9222) PostgreSQL updater should not be version-specific
Notes
Notes:
http://mediawiki.org/wiki/Special:Code/MediaWiki/20219
Diffstat (limited to 'maintenance/postgres/archives/patch-page_restrictions.sql')
| -rw-r--r-- | maintenance/postgres/archives/patch-page_restrictions.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/maintenance/postgres/archives/patch-page_restrictions.sql b/maintenance/postgres/archives/patch-page_restrictions.sql new file mode 100644 index 000000000000..1faa14a92e20 --- /dev/null +++ b/maintenance/postgres/archives/patch-page_restrictions.sql @@ -0,0 +1,10 @@ +CREATE TABLE page_restrictions ( + pr_page INTEGER NULL REFERENCES page (page_id) ON DELETE CASCADE, + pr_type TEXT NOT NULL, + pr_level TEXT NOT NULL, + pr_cascade SMALLINT NOT NULL, + pr_user INTEGER NULL, + pr_expiry TIMESTAMPTZ NULL +); +ALTER TABLE page_restrictions ADD CONSTRAINT page_restrictions_pk PRIMARY KEY (pr_page,pr_type); + |