Implement extension registration from an extension.json file
[mediawiki.git] / maintenance / oracle / archives / patch-page_restrictions_pkuk_fix.sql
blob56c392c13306d7f7797cbde06606f6edc1aa45fb
1 define mw_prefix='{$wgDBprefix}';
3 ALTER TABLE &mw_prefix.page_restrictions DROP CONSTRAINT &mw_prefix.page_restrictions_pk;
5 ALTER TABLE &mw_prefix.page_restrictions ADD CONSTRAINT &mw_prefix.page_restrictions_pk PRIMARY KEY (pr_id);
7 CREATE UNIQUE INDEX &mw_prefix.page_restrictions_u01 ON &mw_prefix.page_restrictions (pr_page,pr_type);