diff options
Diffstat (limited to 'maintenance/oracle/archives')
46 files changed, 0 insertions, 701 deletions
diff --git a/maintenance/oracle/archives/patch-ar_sha1_field.sql b/maintenance/oracle/archives/patch-ar_sha1_field.sql deleted file mode 100644 index de723ce7..00000000 --- a/maintenance/oracle/archives/patch-ar_sha1_field.sql +++ /dev/null @@ -1,3 +0,0 @@ -define mw_prefix='{$wgDBprefix}'; - -ALTER TABLE &mw_prefix.archive ADD ar_sha1 VARCHAR2(32); diff --git a/maintenance/oracle/archives/patch-archive-ar_content_format.sql b/maintenance/oracle/archives/patch-archive-ar_content_format.sql deleted file mode 100644 index 0c0c0d94..00000000 --- a/maintenance/oracle/archives/patch-archive-ar_content_format.sql +++ /dev/null @@ -1,3 +0,0 @@ -define mw_prefix='{$wgDBprefix}'; - -ALTER TABLE &mw_prefix.archive ADD ar_content_format VARCHAR2(64); diff --git a/maintenance/oracle/archives/patch-archive-ar_content_model.sql b/maintenance/oracle/archives/patch-archive-ar_content_model.sql deleted file mode 100644 index d18fc9e4..00000000 --- a/maintenance/oracle/archives/patch-archive-ar_content_model.sql +++ /dev/null @@ -1,3 +0,0 @@ -define mw_prefix='{$wgDBprefix}'; - -ALTER TABLE &mw_prefix.archive ADD ar_content_model VARCHAR2(32); diff --git a/maintenance/oracle/archives/patch-archive-ar_id.sql b/maintenance/oracle/archives/patch-archive-ar_id.sql deleted file mode 100644 index a43f7602..00000000 --- a/maintenance/oracle/archives/patch-archive-ar_id.sql +++ /dev/null @@ -1,6 +0,0 @@ -define mw_prefix='{$wgDBprefix}'; - -ALTER TABLE &mw_prefix.archive ADD ( -ar_id NUMBER NOT NULL, -); -ALTER TABLE &mw_prefix.archive ADD CONSTRAINT &mw_prefix.archive_pk PRIMARY KEY (ar_id); diff --git a/maintenance/oracle/archives/patch-cat_hidden.sql b/maintenance/oracle/archives/patch-cat_hidden.sql deleted file mode 100644 index d1649c7c..00000000 --- a/maintenance/oracle/archives/patch-cat_hidden.sql +++ /dev/null @@ -1,4 +0,0 @@ -define mw_prefix='{$wgDBprefix}'; - -ALTER TABLE &mw_prefix.category DROP COLUMN cat_hidden; - diff --git a/maintenance/oracle/archives/patch-externallinks-el_id.sql b/maintenance/oracle/archives/patch-externallinks-el_id.sql deleted file mode 100644 index a8c443f4..00000000 --- a/maintenance/oracle/archives/patch-externallinks-el_id.sql +++ /dev/null @@ -1,4 +0,0 @@ -define mw_prefix='{$wgDBprefix}'; - -ALTER TABLE &mw_prefix.externallinks ADD el_id NUMBER NOT NULL; -ALTER TABLE &mw_prefix.externallinks ADD CONSTRAINT &mw_prefix.externallinks_pk PRIMARY KEY (el_id);
\ No newline at end of file diff --git a/maintenance/oracle/archives/patch-fa_sha1.sql b/maintenance/oracle/archives/patch-fa_sha1.sql deleted file mode 100644 index 70c9e60c..00000000 --- a/maintenance/oracle/archives/patch-fa_sha1.sql +++ /dev/null @@ -1,5 +0,0 @@ -define mw_prefix='{$wgDBprefix}'; - -ALTER TABLE &mw_prefix.filearchive ADD fa_sha1 VARCHAR2(32); -CREATE INDEX &mw_prefix.filearchive_i05 ON &mw_prefix.filearchive (fa_sha1); - diff --git a/maintenance/oracle/archives/patch-ipblocks_i05_index.sql b/maintenance/oracle/archives/patch-ipblocks_i05_index.sql deleted file mode 100644 index 14275383..00000000 --- a/maintenance/oracle/archives/patch-ipblocks_i05_index.sql +++ /dev/null @@ -1,4 +0,0 @@ -define mw_prefix='{$wgDBprefix}'; - -CREATE INDEX &mw_prefix.ipblocks_i05 ON &mw_prefix.ipblocks (ipb_parent_block_id); - diff --git a/maintenance/oracle/archives/patch-job_attempts.sql b/maintenance/oracle/archives/patch-job_attempts.sql deleted file mode 100644 index b05c8779..00000000 --- a/maintenance/oracle/archives/patch-job_attempts.sql +++ /dev/null @@ -1,4 +0,0 @@ -define mw_prefix='{$wgDBprefix}'; - -ALTER TABLE &mw_prefix.job ADD job_attempts NUMBER DEFAULT 0 NOT NULL; -CREATE INDEX &mw_prefix.job_i05 ON &mw_prefix.job (job_attempts); diff --git a/maintenance/oracle/archives/patch-job_timestamp_field.sql b/maintenance/oracle/archives/patch-job_timestamp_field.sql deleted file mode 100644 index 4901c87c..00000000 --- a/maintenance/oracle/archives/patch-job_timestamp_field.sql +++ /dev/null @@ -1,4 +0,0 @@ -define mw_prefix='{$wgDBprefix}'; - -ALTER TABLE &mw_prefix.job ADD job_timestamp TIMESTAMP(6) WITH TIME ZONE NULL; - diff --git a/maintenance/oracle/archives/patch-job_timestamp_index.sql b/maintenance/oracle/archives/patch-job_timestamp_index.sql deleted file mode 100644 index 6db43046..00000000 --- a/maintenance/oracle/archives/patch-job_timestamp_index.sql +++ /dev/null @@ -1,4 +0,0 @@ -define mw_prefix='{$wgDBprefix}'; - -CREATE INDEX &mw_prefix.job_i02 ON &mw_prefix.job (job_timestamp); - diff --git a/maintenance/oracle/archives/patch-job_token.sql b/maintenance/oracle/archives/patch-job_token.sql deleted file mode 100644 index 1a730e95..00000000 --- a/maintenance/oracle/archives/patch-job_token.sql +++ /dev/null @@ -1,12 +0,0 @@ -define mw_prefix='{$wgDBprefix}'; - -ALTER TABLE &mw_prefix.job ADD ( - job_random NUMBER DEFAULT 0 NOT NULL, - job_token VARCHAR2(32), - job_token_timestamp TIMESTAMP(6) WITH TIME ZONE, - job_sha1 VARCHAR2(32) -); - -CREATE INDEX &mw_prefix.job_i03 ON &mw_prefix.job (job_sha1); -CREATE INDEX &mw_prefix.job_i04 ON &mw_prefix.job (job_cmd,job_token,job_random); - diff --git a/maintenance/oracle/archives/patch-logging_type_action_index.sql b/maintenance/oracle/archives/patch-logging_type_action_index.sql deleted file mode 100644 index d30e0cfc..00000000 --- a/maintenance/oracle/archives/patch-logging_type_action_index.sql +++ /dev/null @@ -1,4 +0,0 @@ -define mw_prefix='{$wgDBprefix}'; - -CREATE INDEX &mw_prefix.logging_i05 ON &mw_prefix.logging (log_type, log_action, log_timestamp); - diff --git a/maintenance/oracle/archives/patch-logging_user_text_time_index.sql b/maintenance/oracle/archives/patch-logging_user_text_time_index.sql deleted file mode 100644 index e04abf5f..00000000 --- a/maintenance/oracle/archives/patch-logging_user_text_time_index.sql +++ /dev/null @@ -1,4 +0,0 @@ -define mw_prefix='{$wgDBprefix}'; - -CREATE INDEX &mw_prefix.logging_i07 ON &mw_prefix.logging (log_user_text, log_timestamp); - diff --git a/maintenance/oracle/archives/patch-logging_user_text_type_time_index.sql b/maintenance/oracle/archives/patch-logging_user_text_type_time_index.sql deleted file mode 100644 index c1c0d4f2..00000000 --- a/maintenance/oracle/archives/patch-logging_user_text_type_time_index.sql +++ /dev/null @@ -1,4 +0,0 @@ -define mw_prefix='{$wgDBprefix}'; - -CREATE INDEX &mw_prefix.logging_i06 ON &mw_prefix.logging (log_user_text, log_type, log_timestamp); - diff --git a/maintenance/oracle/archives/patch-page-page_content_model.sql b/maintenance/oracle/archives/patch-page-page_content_model.sql deleted file mode 100644 index e5839d9a..00000000 --- a/maintenance/oracle/archives/patch-page-page_content_model.sql +++ /dev/null @@ -1,3 +0,0 @@ -define mw_prefix='{$wgDBprefix}'; - -ALTER TABLE &mw_prefix.page ADD page_content_model VARCHAR2(32); diff --git a/maintenance/oracle/archives/patch-page-page_lang.sql b/maintenance/oracle/archives/patch-page-page_lang.sql deleted file mode 100644 index cae7cf90..00000000 --- a/maintenance/oracle/archives/patch-page-page_lang.sql +++ /dev/null @@ -1,3 +0,0 @@ -define mw_prefix='{$wgDBprefix}'; - -ALTER TABLE &mw_prefix.page ADD page_lang VARCHAR2(35); diff --git a/maintenance/oracle/archives/patch-page_links_updated.sql b/maintenance/oracle/archives/patch-page_links_updated.sql deleted file mode 100644 index 53603294..00000000 --- a/maintenance/oracle/archives/patch-page_links_updated.sql +++ /dev/null @@ -1,4 +0,0 @@ -define mw_prefix='{$wgDBprefix}'; - -ALTER TABLE &mw_prefix.page ADD page_links_updated TIMESTAMP(6) WITH TIME ZONE; - diff --git a/maintenance/oracle/archives/patch-page_redirect_namespace_len.sql b/maintenance/oracle/archives/patch-page_redirect_namespace_len.sql deleted file mode 100644 index 1f8b9d9a..00000000 --- a/maintenance/oracle/archives/patch-page_redirect_namespace_len.sql +++ /dev/null @@ -1,4 +0,0 @@ -define mw_prefix='{$wgDBprefix}'; - -CREATE INDEX &mw_prefix.page_i03 ON &mw_prefix.page (page_is_redirect, page_namespace, page_len); - diff --git a/maintenance/oracle/archives/patch-page_restrictions_pkuk_fix.sql b/maintenance/oracle/archives/patch-page_restrictions_pkuk_fix.sql deleted file mode 100644 index 56c392c1..00000000 --- a/maintenance/oracle/archives/patch-page_restrictions_pkuk_fix.sql +++ /dev/null @@ -1,7 +0,0 @@ -define mw_prefix='{$wgDBprefix}'; - -ALTER TABLE &mw_prefix.page_restrictions DROP CONSTRAINT &mw_prefix.page_restrictions_pk; - -ALTER TABLE &mw_prefix.page_restrictions ADD CONSTRAINT &mw_prefix.page_restrictions_pk PRIMARY KEY (pr_id); - -CREATE UNIQUE INDEX &mw_prefix.page_restrictions_u01 ON &mw_prefix.page_restrictions (pr_page,pr_type); diff --git a/maintenance/oracle/archives/patch-rc_moved.sql b/maintenance/oracle/archives/patch-rc_moved.sql deleted file mode 100644 index 2a71315d..00000000 --- a/maintenance/oracle/archives/patch-rc_moved.sql +++ /dev/null @@ -1,4 +0,0 @@ -define mw_prefix='{$wgDBprefix}'; - -ALTER TABLE &mw_prefix.recentchanges DROP ( rc_moved_to_ns, rc_moved_to_title ); - diff --git a/maintenance/oracle/archives/patch-rc_source.sql b/maintenance/oracle/archives/patch-rc_source.sql deleted file mode 100644 index 0c80afab..00000000 --- a/maintenance/oracle/archives/patch-rc_source.sql +++ /dev/null @@ -1,3 +0,0 @@ -define mw_prefix='{$wgDBprefix}'; - -ALTER TABLE &mw_prefix.recentchanges ADD rc_source VARCHAR2(16); diff --git a/maintenance/oracle/archives/patch-rev_sha1_field.sql b/maintenance/oracle/archives/patch-rev_sha1_field.sql deleted file mode 100644 index 80544e89..00000000 --- a/maintenance/oracle/archives/patch-rev_sha1_field.sql +++ /dev/null @@ -1,4 +0,0 @@ -define mw_prefix='{$wgDBprefix}'; - -ALTER TABLE &mw_prefix.revision ADD rev_sha1 VARCHAR2(32); - diff --git a/maintenance/oracle/archives/patch-revision-rev_content_format.sql b/maintenance/oracle/archives/patch-revision-rev_content_format.sql deleted file mode 100644 index ebde71c9..00000000 --- a/maintenance/oracle/archives/patch-revision-rev_content_format.sql +++ /dev/null @@ -1,3 +0,0 @@ -define mw_prefix='{$wgDBprefix}'; - -ALTER TABLE &mw_prefix.revision ADD rev_content_format VARCHAR2(64); diff --git a/maintenance/oracle/archives/patch-revision-rev_content_model.sql b/maintenance/oracle/archives/patch-revision-rev_content_model.sql deleted file mode 100644 index dd226423..00000000 --- a/maintenance/oracle/archives/patch-revision-rev_content_model.sql +++ /dev/null @@ -1,3 +0,0 @@ -define mw_prefix='{$wgDBprefix}'; - -ALTER TABLE &mw_prefix.revision ADD rev_content_model VARCHAR2(32); diff --git a/maintenance/oracle/archives/patch-revision_i05_index.sql b/maintenance/oracle/archives/patch-revision_i05_index.sql deleted file mode 100644 index 929c7b31..00000000 --- a/maintenance/oracle/archives/patch-revision_i05_index.sql +++ /dev/null @@ -1,4 +0,0 @@ -define mw_prefix='{$wgDBprefix}'; - -CREATE INDEX &mw_prefix.revision_i05 ON &mw_prefix.revision (rev_page,rev_user,rev_timestamp); - diff --git a/maintenance/oracle/archives/patch-sites.sql b/maintenance/oracle/archives/patch-sites.sql deleted file mode 100644 index 868b210f..00000000 --- a/maintenance/oracle/archives/patch-sites.sql +++ /dev/null @@ -1,34 +0,0 @@ -define mw_prefix='{$wgDBprefix}'; - -CREATE SEQUENCE sites_site_id_seq MINVALUE 0 START WITH 0; -CREATE TABLE &mw_prefix.sites ( - site_id NUMBER NOT NULL, - site_global_key VARCHAR2(32) NOT NULL, - site_type VARCHAR2(32) NOT NULL, - site_group VARCHAR2(32) NOT NULL, - site_source VARCHAR2(32) NOT NULL, - site_language VARCHAR2(32) NOT NULL, - site_protocol VARCHAR2(32) NOT NULL, - site_domain VARCHAR2(255) NOT NULL, - site_data BLOB NOT NULL, - site_forward NUMBER(1) NOT NULL, - site_config BLOB NOT NULL -); -ALTER TABLE &mw_prefix.sites ADD CONSTRAINT &mw_prefix.sites_pk PRIMARY KEY (site_id); -CREATE UNIQUE INDEX &mw_prefix.sites_u01 ON &mw_prefix.sites (site_global_key); -CREATE INDEX &mw_prefix.sites_i01 ON &mw_prefix.sites (site_type); -CREATE INDEX &mw_prefix.sites_i02 ON &mw_prefix.sites (site_group); -CREATE INDEX &mw_prefix.sites_i03 ON &mw_prefix.sites (site_source); -CREATE INDEX &mw_prefix.sites_i04 ON &mw_prefix.sites (site_language); -CREATE INDEX &mw_prefix.sites_i05 ON &mw_prefix.sites (site_protocol); -CREATE INDEX &mw_prefix.sites_i06 ON &mw_prefix.sites (site_domain); -CREATE INDEX &mw_prefix.sites_i07 ON &mw_prefix.sites (site_forward); - -CREATE TABLE &mw_prefix.site_identifiers ( - si_site NUMBER NOT NULL, - si_type VARCHAR2(32) NOT NULL, - si_key VARCHAR2(32) NOT NULL -); -CREATE UNIQUE INDEX &mw_prefix.site_identifiers_u01 ON &mw_prefix.site_identifiers (si_type, si_key); -CREATE INDEX &mw_prefix.site_identifiers_i01 ON &mw_prefix.site_identifiers (si_site); -CREATE INDEX &mw_prefix.site_identifiers_i02 ON &mw_prefix.site_identifiers (si_key); diff --git a/maintenance/oracle/archives/patch-ss_admins.sql b/maintenance/oracle/archives/patch-ss_admins.sql deleted file mode 100644 index c2e9242e..00000000 --- a/maintenance/oracle/archives/patch-ss_admins.sql +++ /dev/null @@ -1,4 +0,0 @@ -define mw_prefix='{$wgDBprefix}'; - -ALTER TABLE &mw_prefix.site_stats DROP COLUMN ss_admins; - diff --git a/maintenance/oracle/archives/patch-testrun.sql b/maintenance/oracle/archives/patch-testrun.sql deleted file mode 100644 index 84facabc..00000000 --- a/maintenance/oracle/archives/patch-testrun.sql +++ /dev/null @@ -1,37 +0,0 @@ --- --- Optional tables for parserTests recording mode --- With --record option, success data will be saved to these tables, --- and comparisons of what's changed from the previous run will be --- displayed at the end of each run. --- --- defines must comply with ^define\s*([^\s=]*)\s*=\s?'\{\$([^\}]*)\}'; -define mw_prefix='{$wgDBprefix}'; - -DROP TABLE &mw_prefix.testitem CASCADE CONSTRAINTS; -DROP TABLE &mw_prefix.testrun CASCADE CONSTRAINTS; - -CREATE SEQUENCE testrun_tr_id_seq; -CREATE TABLE &mw_prefix.testrun ( - tr_id NUMBER NOT NULL, - tr_date DATE, - tr_mw_version BLOB, - tr_php_version BLOB, - tr_db_version BLOB, - tr_uname BLOB, -); -ALTER TABLE &mw_prefix.testrun ADD CONSTRAINT &mw_prefix.testrun_pk PRIMARY KEY (tr_id); -CREATE OR REPLACE TRIGGER &mw_prefix.testrun_bir -BEFORE UPDATE FOR EACH ROW -ON &mw_prefix.testrun -BEGIN - SELECT testrun_tr_id_seq.NEXTVAL into :NEW.tr_id FROM dual; -END; - -CREATE TABLE /*$wgDBprefix*/testitem ( - ti_run NUMBER NOT NULL REFERENCES &mw_prefix.testrun (tr_id) ON DELETE CASCADE, - ti_name VARCHAR22(255), - ti_success NUMBER(1) -); -CREATE UNIQUE INDEX &mw_prefix.testitem_u01 ON &mw_prefix.testitem (ti_run, ti_name); -CREATE UNIQUE INDEX &mw_prefix.testitem_u01 ON &mw_prefix.testitem (ti_run, ti_success); - diff --git a/maintenance/oracle/archives/patch-ufg_group-length-increase-255.sql b/maintenance/oracle/archives/patch-ufg_group-length-increase-255.sql deleted file mode 100644 index 6a4a7517..00000000 --- a/maintenance/oracle/archives/patch-ufg_group-length-increase-255.sql +++ /dev/null @@ -1,9 +0,0 @@ -define mw_prefix='{$wgDBprefix}'; - -/*$mw$*/ -BEGIN - EXECUTE IMMEDIATE 'ALTER TABLE &mw_prefix.user_former_groups MODIFY ufg_group VARCHAR2(255) NOT NULL'; -EXCEPTION WHEN OTHERS THEN - IF (SQLCODE = -01442) THEN NULL; ELSE RAISE; END IF; -END; -/*$mw$*/ diff --git a/maintenance/oracle/archives/patch-ug_group-length-increase-255.sql b/maintenance/oracle/archives/patch-ug_group-length-increase-255.sql deleted file mode 100644 index 00a5e7b2..00000000 --- a/maintenance/oracle/archives/patch-ug_group-length-increase-255.sql +++ /dev/null @@ -1,9 +0,0 @@ -define mw_prefix='{$wgDBprefix}'; - -/*$mw$*/ -BEGIN - EXECUTE IMMEDIATE 'ALTER TABLE &mw_prefix.user_groups MODIFY ug_group VARCHAR2(255) NOT NULL'; -EXCEPTION WHEN OTHERS THEN - IF (SQLCODE = -01442) THEN NULL; ELSE RAISE; END IF; -END; -/*$mw$*/ diff --git a/maintenance/oracle/archives/patch-up_property.sql b/maintenance/oracle/archives/patch-up_property.sql deleted file mode 100644 index c8e2dd95..00000000 --- a/maintenance/oracle/archives/patch-up_property.sql +++ /dev/null @@ -1,3 +0,0 @@ -define mw_prefix='{$wgDBprefix}'; - -ALTER TABLE &mw_prefix.user_properties MODIFY up_property varchar2(255); diff --git a/maintenance/oracle/archives/patch-uploadstash-us_props.sql b/maintenance/oracle/archives/patch-uploadstash-us_props.sql deleted file mode 100644 index 8962dc7c..00000000 --- a/maintenance/oracle/archives/patch-uploadstash-us_props.sql +++ /dev/null @@ -1,4 +0,0 @@ -define mw_prefix='{$wgDBprefix}'; - -ALTER TABLE &mw_prefix.uploadstash ADD us_props BLOB; - diff --git a/maintenance/oracle/archives/patch-uploadstash.sql b/maintenance/oracle/archives/patch-uploadstash.sql deleted file mode 100644 index 3e37ceff..00000000 --- a/maintenance/oracle/archives/patch-uploadstash.sql +++ /dev/null @@ -1,25 +0,0 @@ -define mw_prefix='{$wgDBprefix}'; - -CREATE SEQUENCE uploadstash_us_id_seq; -CREATE TABLE &mw_prefix.uploadstash ( - us_id NUMBER NOT NULL, - us_user NUMBER DEFAULT 0 NOT NULL, - us_key VARCHAR2(255) NOT NULL, - us_orig_path VARCHAR2(255) NOT NULL, - us_path VARCHAR2(255) NOT NULL, - us_source_type VARCHAR2(50), - us_timestamp TIMESTAMP(6) WITH TIME ZONE, - us_status VARCHAR2(50) NOT NULL, - us_size NUMBER NOT NULL, - us_sha1 VARCHAR2(32) NOT NULL, - us_mime VARCHAR2(255), - us_media_type VARCHAR2(32) DEFAULT NULL, - us_image_width NUMBER, - us_image_height NUMBER, - us_image_bits NUMBER -); -ALTER TABLE &mw_prefix.uploadstash ADD CONSTRAINT &mw_prefix.uploadstash_pk PRIMARY KEY (us_id); -ALTER TABLE &mw_prefix.uploadstash ADD CONSTRAINT &mw_prefix.uploadstash_fk1 FOREIGN KEY (us_user) REFERENCES &mw_prefix.mwuser(user_id) ON DELETE SET NULL DEFERRABLE INITIALLY DEFERRED; -CREATE INDEX &mw_prefix.uploadstash_i01 ON &mw_prefix.uploadstash (us_user); -CREATE INDEX &mw_prefix.uploadstash_i02 ON &mw_prefix.uploadstash (us_timestamp); -CREATE UNIQUE INDEX &mw_prefix.uploadstash_u01 ON &mw_prefix.uploadstash (us_key); diff --git a/maintenance/oracle/archives/patch-us_chunk_inx_field.sql b/maintenance/oracle/archives/patch-us_chunk_inx_field.sql deleted file mode 100644 index 43ee16ec..00000000 --- a/maintenance/oracle/archives/patch-us_chunk_inx_field.sql +++ /dev/null @@ -1,4 +0,0 @@ -define mw_prefix='{$wgDBprefix}'; - -ALTER TABLE &mw_prefix.uploadstash ADD us_chunk_inx NUMBER; - diff --git a/maintenance/oracle/archives/patch-user_email_index.sql b/maintenance/oracle/archives/patch-user_email_index.sql deleted file mode 100644 index e34d8656..00000000 --- a/maintenance/oracle/archives/patch-user_email_index.sql +++ /dev/null @@ -1,4 +0,0 @@ -define mw_prefix='{$wgDBprefix}'; - -CREATE INDEX &mw_prefix.mwuser_i02 ON &mw_prefix.mwuser (user_email); - diff --git a/maintenance/oracle/archives/patch-user_former_groups.sql b/maintenance/oracle/archives/patch-user_former_groups.sql deleted file mode 100644 index c14824eb..00000000 --- a/maintenance/oracle/archives/patch-user_former_groups.sql +++ /dev/null @@ -1,9 +0,0 @@ -define mw_prefix='{$wgDBprefix}'; - -CREATE TABLE &mw_prefix.user_former_groups ( - ufg_user NUMBER DEFAULT 0 NOT NULL, - ufg_group VARCHAR2(255) NOT NULL -); -ALTER TABLE &mw_prefix.user_former_groups ADD CONSTRAINT &mw_prefix.user_former_groups_fk1 FOREIGN KEY (ufg_user) REFERENCES &mw_prefix.mwuser(user_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED; -CREATE UNIQUE INDEX &mw_prefix.user_former_groups_u01 ON &mw_prefix.user_former_groups (ufg_user,ufg_group); - diff --git a/maintenance/oracle/archives/patch-user_password_expire.sql b/maintenance/oracle/archives/patch-user_password_expire.sql deleted file mode 100644 index 824cc820..00000000 --- a/maintenance/oracle/archives/patch-user_password_expire.sql +++ /dev/null @@ -1,3 +0,0 @@ -define mw_prefix='{$wgDBprefix}'; - -ALTER TABLE &mw_prefix.mwuser ADD user_password_expires TIMESTAMP(6) WITH TIME ZONE; diff --git a/maintenance/oracle/archives/patch_16_17_schema_changes.sql b/maintenance/oracle/archives/patch_16_17_schema_changes.sql deleted file mode 100644 index cd99f7cc..00000000 --- a/maintenance/oracle/archives/patch_16_17_schema_changes.sql +++ /dev/null @@ -1,98 +0,0 @@ -define mw_prefix='{$wgDBprefix}'; - -ALTER TABLE &mw_prefix.archive MODIFY ar_user DEFAULT 0 NOT NULL; -ALTER TABLE &mw_prefix.archive MODIFY ar_deleted CHAR(1); -CREATE INDEX &mw_prefix.archive_i03 ON &mw_prefix.archive (ar_rev_id); - -ALTER TABLE &mw_prefix.page MODIFY page_is_redirect default '0'; -ALTER TABLE &mw_prefix.page MODIFY page_is_new default '0'; -ALTER TABLE &mw_prefix.page MODIFY page_latest default 0; -ALTER TABLE &mw_prefix.page MODIFY page_len default 0; - -ALTER TABLE &mw_prefix.categorylinks MODIFY cl_sortkey VARCHAR2(230); -ALTER TABLE &mw_prefix.categorylinks ADD cl_sortkey_prefix VARCHAR2(255) DEFAULT '' NOT NULL; -ALTER TABLE &mw_prefix.categorylinks ADD cl_collation VARCHAR2(32) DEFAULT '' NOT NULL; -ALTER TABLE &mw_prefix.categorylinks ADD cl_type VARCHAR2(6) DEFAULT 'page' NOT NULL; -DROP INDEX &mw_prefix.categorylinks_i01; -CREATE INDEX &mw_prefix.categorylinks_i01 ON &mw_prefix.categorylinks (cl_to,cl_type,cl_sortkey,cl_from); -CREATE INDEX &mw_prefix.categorylinks_i03 ON &mw_prefix.categorylinks (cl_collation); - -ALTER TABLE &mw_prefix.filearchive MODIFY fa_deleted_user DEFAULT 0 NOT NULL; -ALTER TABLE &mw_prefix.filearchive MODIFY fa_size DEFAULT 0; -ALTER TABLE &mw_prefix.filearchive MODIFY fa_width DEFAULT 0; -ALTER TABLE &mw_prefix.filearchive MODIFY fa_height DEFAULT 0; -ALTER TABLE &mw_prefix.filearchive MODIFY fa_bits DEFAULT 0 NOT NULL; -ALTER TABLE &mw_prefix.filearchive MODIFY fa_user DEFAULT 0 NOT NULL; -ALTER TABLE &mw_prefix.filearchive MODIFY fa_deleted DEFAULT 0; - -ALTER TABLE &mw_prefix.image MODIFY img_size DEFAULT 0; -ALTER TABLE &mw_prefix.image MODIFY img_width DEFAULT 0; -ALTER TABLE &mw_prefix.image MODIFY img_height DEFAULT 0; -ALTER TABLE &mw_prefix.image MODIFY img_bits DEFAULT 0 NOT NULL; -ALTER TABLE &mw_prefix.image MODIFY img_user DEFAULT 0 NOT NULL; - -ALTER TABLE &mw_prefix.interwiki ADD iw_api BLOB DEFAULT EMPTY_BLOB(); -ALTER TABLE &mw_prefix.interwiki MODIFY iw_api DEFAULT NULL NOT NULL; -ALTER TABLE &mw_prefix.interwiki ADD iw_wikiid VARCHAR2(64); - -ALTER TABLE &mw_prefix.ipblocks MODIFY ipb_user DEFAULT 0 NOT NULL; -ALTER TABLE &mw_prefix.ipblocks MODIFY ipb_by DEFAULT 0; - -CREATE TABLE &mw_prefix.iwlinks ( - iwl_from NUMBER DEFAULT 0 NOT NULL, - iwl_prefix VARCHAR2(20) DEFAULT '' NOT NULL, - iwl_title VARCHAR2(255) DEFAULT '' NOT NULL -); -CREATE UNIQUE INDEX &mw_prefix.iwlinks_ui01 ON &mw_prefix.iwlinks (iwl_from, iwl_prefix, iwl_title); -CREATE UNIQUE INDEX &mw_prefix.iwlinks_ui02 ON &mw_prefix.iwlinks (iwl_prefix, iwl_title, iwl_from); - -ALTER TABLE &mw_prefix.logging MODIFY log_user DEFAULT 0 NOT NULL; -ALTER TABLE &mw_prefix.logging MODIFY log_deleted CHAR(1); - -CREATE TABLE &mw_prefix.module_deps ( - md_module VARCHAR2(255) NOT NULL, - md_skin VARCHAR2(32) NOT NULL, - md_deps BLOB NOT NULL -); -CREATE UNIQUE INDEX &mw_prefix.module_deps_u01 ON &mw_prefix.module_deps (md_module, md_skin); - -CREATE TABLE &mw_prefix.msg_resource_links ( - mrl_resource VARCHAR2(255) NOT NULL, - mrl_message VARCHAR2(255) NOT NULL -); -CREATE UNIQUE INDEX &mw_prefix.msg_resource_links_u01 ON &mw_prefix.msg_resource_links (mrl_message, mrl_resource); - -CREATE TABLE &mw_prefix.msg_resource ( - mr_resource VARCHAR2(255) NOT NULL, - mr_lang varchar2(32) NOT NULL, - mr_blob BLOB NOT NULL, - mr_timestamp TIMESTAMP(6) WITH TIME ZONE NOT NULL -); -CREATE UNIQUE INDEX &mw_prefix.msg_resource_u01 ON &mw_prefix.msg_resource (mr_resource, mr_lang); - -ALTER TABLE &mw_prefix.oldimage MODIFY oi_name DEFAULT 0; -ALTER TABLE &mw_prefix.oldimage MODIFY oi_size DEFAULT 0; -ALTER TABLE &mw_prefix.oldimage MODIFY oi_width DEFAULT 0; -ALTER TABLE &mw_prefix.oldimage MODIFY oi_height DEFAULT 0; -ALTER TABLE &mw_prefix.oldimage MODIFY oi_bits DEFAULT 0; -ALTER TABLE &mw_prefix.oldimage MODIFY oi_user DEFAULT 0 NOT NULL; - -ALTER TABLE &mw_prefix.querycache MODIFY qc_value DEFAULT 0; - -ALTER TABLE &mw_prefix.recentchanges MODIFY rc_user DEFAULT 0 NOT NULL; -ALTER TABLE &mw_prefix.recentchanges MODIFY rc_cur_id DEFAULT 0 NOT NULL; -ALTER TABLE &mw_prefix.recentchanges MODIFY rc_this_oldid DEFAULT 0; -ALTER TABLE &mw_prefix.recentchanges MODIFY rc_last_oldid DEFAULT 0; -ALTER TABLE &mw_prefix.recentchanges MODIFY rc_moved_to_ns DEFAULT 0 NOT NULL; -ALTER TABLE &mw_prefix.recentchanges MODIFY rc_deleted CHAR(1); -ALTER TABLE &mw_prefix.recentchanges MODIFY rc_logid DEFAULT 0; - -ALTER TABLE &mw_prefix.revision MODIFY rev_page NOT NULL; -ALTER TABLE &mw_prefix.revision MODIFY rev_user DEFAULT 0; - -ALTER TABLE &mw_prefix.updatelog ADD ul_value BLOB; - -ALTER TABLE &mw_prefix.user_groups MODIFY ug_user DEFAULT 0 NOT NULL; - -ALTER TABLE &mw_prefix.user_newtalk MODIFY user_id DEFAULT 0; - diff --git a/maintenance/oracle/archives/patch_create_17_functions.sql b/maintenance/oracle/archives/patch_create_17_functions.sql deleted file mode 100644 index 6c9c9542..00000000 --- a/maintenance/oracle/archives/patch_create_17_functions.sql +++ /dev/null @@ -1,125 +0,0 @@ -define mw_prefix='{$wgDBprefix}'; - -/*$mw$*/ -CREATE OR REPLACE PROCEDURE duplicate_table(p_tabname IN VARCHAR2, - p_oldprefix IN VARCHAR2, - p_newprefix IN VARCHAR2, - p_temporary IN BOOLEAN) IS - e_table_not_exist EXCEPTION; - PRAGMA EXCEPTION_INIT(e_table_not_exist, -00942); - l_temp_ei_sql VARCHAR2(2000); -BEGIN - BEGIN - EXECUTE IMMEDIATE 'DROP TABLE ' || p_newprefix || p_tabname || - ' CASCADE CONSTRAINTS'; - EXCEPTION - WHEN e_table_not_exist THEN - NULL; - END; - IF (p_temporary) THEN - EXECUTE IMMEDIATE 'CREATE GLOBAL TEMPORARY TABLE ' || p_newprefix || - p_tabname || ' AS SELECT * FROM ' || p_oldprefix || - p_tabname || ' WHERE ROWNUM = 0'; - ELSE - EXECUTE IMMEDIATE 'CREATE TABLE ' || p_newprefix || p_tabname || - ' AS SELECT * FROM ' || p_oldprefix || p_tabname || - ' WHERE ROWNUM = 0'; - END IF; - FOR rc IN (SELECT column_name, data_default - FROM user_tab_columns - WHERE table_name = p_oldprefix || p_tabname - AND data_default IS NOT NULL) LOOP - EXECUTE IMMEDIATE 'ALTER TABLE ' || p_newprefix || p_tabname || - ' MODIFY ' || rc.column_name || ' DEFAULT ' || - SUBSTR(rc.data_default, 1, 2000); - END LOOP; - FOR rc IN (SELECT REPLACE(REPLACE(DBMS_LOB.SUBSTR(DBMS_METADATA.get_ddl('CONSTRAINT', - constraint_name), - 32767, - 1), - USER || '"."' || p_oldprefix, - USER || '"."' || p_newprefix), - '"' || constraint_name || '"', - '"' || p_newprefix || constraint_name || '"') DDLVC2, - constraint_name - FROM user_constraints uc - WHERE table_name = p_oldprefix || p_tabname - AND constraint_type = 'P') LOOP - l_temp_ei_sql := SUBSTR(rc.ddlvc2, 1, INSTR(rc.ddlvc2, 'PCTFREE') - 1); - l_temp_ei_sql := SUBSTR(l_temp_ei_sql, 1, INSTR(l_temp_ei_sql, ')', INSTR(l_temp_ei_sql, 'PRIMARY KEY')+1)+1); - EXECUTE IMMEDIATE l_temp_ei_sql; - END LOOP; - IF (NOT p_temporary) THEN - FOR rc IN (SELECT REPLACE(DBMS_LOB.SUBSTR(DBMS_METADATA.get_ddl('REF_CONSTRAINT', - constraint_name), - 32767, - 1), - USER || '"."' || p_oldprefix, - USER || '"."' || p_newprefix) DDLVC2, - constraint_name - FROM user_constraints uc - WHERE table_name = p_oldprefix || p_tabname - AND constraint_type = 'R') LOOP - EXECUTE IMMEDIATE rc.ddlvc2; - END LOOP; - END IF; - FOR rc IN (SELECT REPLACE(REPLACE(DBMS_LOB.SUBSTR(DBMS_METADATA.get_ddl('INDEX', - index_name), - 32767, - 1), - USER || '"."' || p_oldprefix, - USER || '"."' || p_newprefix), - '"' || index_name || '"', - '"' || p_newprefix || index_name || '"') DDLVC2, - index_name, - index_type - FROM user_indexes ui - WHERE table_name = p_oldprefix || p_tabname - AND index_type NOT IN ('LOB', 'DOMAIN') - AND NOT EXISTS - (SELECT NULL - FROM user_constraints - WHERE table_name = ui.table_name - AND constraint_name = ui.index_name)) LOOP - l_temp_ei_sql := SUBSTR(rc.ddlvc2, 1, INSTR(rc.ddlvc2, 'PCTFREE') - 1); - l_temp_ei_sql := SUBSTR(l_temp_ei_sql, 1, INSTR(l_temp_ei_sql, ')', INSTR(l_temp_ei_sql, '"' || USER || '"."' || p_newprefix || '"')+1)+1); - EXECUTE IMMEDIATE l_temp_ei_sql; - END LOOP; - FOR rc IN (SELECT REPLACE(REPLACE(UPPER(DBMS_LOB.SUBSTR(DBMS_METADATA.get_ddl('TRIGGER', - trigger_name), - 32767, - 1)), - USER || '"."' || p_oldprefix, - USER || '"."' || p_newprefix), - ' ON ' || p_oldprefix || p_tabname, - ' ON ' || p_newprefix || p_tabname) DDLVC2, - trigger_name - FROM user_triggers - WHERE table_name = p_oldprefix || p_tabname) LOOP - l_temp_ei_sql := SUBSTR(rc.ddlvc2, 1, INSTR(rc.ddlvc2, 'ALTER ') - 1); - dbms_output.put_line(l_temp_ei_sql); - EXECUTE IMMEDIATE l_temp_ei_sql; - END LOOP; -END; -/*$mw$*/ - -CREATE OR REPLACE TYPE GET_OUTPUT_TYPE IS TABLE OF VARCHAR2(255); - -/*$mw$*/ -CREATE OR REPLACE FUNCTION GET_OUTPUT_LINES RETURN GET_OUTPUT_TYPE PIPELINED AS - v_line VARCHAR2(255); - v_status INTEGER := 0; -BEGIN - - LOOP - DBMS_OUTPUT.GET_LINE(v_line, v_status); - IF (v_status = 0) THEN RETURN; END IF; - PIPE ROW (v_line); - END LOOP; - RETURN; -EXCEPTION - WHEN OTHERS THEN - RETURN; -END; -/*$mw$*/ - diff --git a/maintenance/oracle/archives/patch_fk_rename_deferred.sql b/maintenance/oracle/archives/patch_fk_rename_deferred.sql deleted file mode 100644 index ca9c997f..00000000 --- a/maintenance/oracle/archives/patch_fk_rename_deferred.sql +++ /dev/null @@ -1,40 +0,0 @@ -define mw_prefix='{$wgDBprefix}'; - -/*$mw$*/ -BEGIN --- drop all, recreate manual in case anyone was missing - FOR cc1 IN (SELECT uc.table_name, - uc.constraint_name - FROM user_constraints uc - WHERE uc.constraint_type = 'R') LOOP - EXECUTE IMMEDIATE 'ALTER TABLE &mw_prefix.' || cc1.table_name || - ' DROP CONSTRAINT ' || cc1.constraint_name; - END LOOP; -END; -/*$mw$*/ - -ALTER TABLE &mw_prefix.user_groups ADD CONSTRAINT &mw_prefix.user_groups_fk1 FOREIGN KEY (ug_user) REFERENCES &mw_prefix.mwuser(user_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED; -ALTER TABLE &mw_prefix.user_newtalk ADD CONSTRAINT &mw_prefix.user_newtalk_fk1 FOREIGN KEY (user_id) REFERENCES &mw_prefix.mwuser(user_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED; -ALTER TABLE &mw_prefix.revision ADD CONSTRAINT &mw_prefix.revision_fk1 FOREIGN KEY (rev_page) REFERENCES &mw_prefix.page(page_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED; -ALTER TABLE &mw_prefix.revision ADD CONSTRAINT &mw_prefix.revision_fk2 FOREIGN KEY (rev_user) REFERENCES &mw_prefix.mwuser(user_id) DEFERRABLE INITIALLY DEFERRED; -ALTER TABLE &mw_prefix.archive ADD CONSTRAINT &mw_prefix.archive_fk1 FOREIGN KEY (ar_user) REFERENCES &mw_prefix.mwuser(user_id) ON DELETE SET NULL DEFERRABLE INITIALLY DEFERRED; -ALTER TABLE &mw_prefix.pagelinks ADD CONSTRAINT &mw_prefix.pagelinks_fk1 FOREIGN KEY (pl_from) REFERENCES &mw_prefix.page(page_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED; -ALTER TABLE &mw_prefix.templatelinks ADD CONSTRAINT &mw_prefix.templatelinks_fk1 FOREIGN KEY (tl_from) REFERENCES &mw_prefix.page(page_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED; -ALTER TABLE &mw_prefix.imagelinks ADD CONSTRAINT &mw_prefix.imagelinks_fk1 FOREIGN KEY (il_from) REFERENCES &mw_prefix.page(page_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED; -ALTER TABLE &mw_prefix.categorylinks ADD CONSTRAINT &mw_prefix.categorylinks_fk1 FOREIGN KEY (cl_from) REFERENCES &mw_prefix.page(page_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED; -ALTER TABLE &mw_prefix.externallinks ADD CONSTRAINT &mw_prefix.externallinks_fk1 FOREIGN KEY (el_from) REFERENCES &mw_prefix.page(page_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED; -ALTER TABLE &mw_prefix.langlinks ADD CONSTRAINT &mw_prefix.langlinks_fk1 FOREIGN KEY (ll_from) REFERENCES &mw_prefix.page(page_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED; -ALTER TABLE &mw_prefix.ipblocks ADD CONSTRAINT &mw_prefix.ipblocks_fk1 FOREIGN KEY (ipb_user) REFERENCES &mw_prefix.mwuser(user_id) ON DELETE SET NULL DEFERRABLE INITIALLY DEFERRED; -ALTER TABLE &mw_prefix.ipblocks ADD CONSTRAINT &mw_prefix.ipblocks_fk2 FOREIGN KEY (ipb_by) REFERENCES &mw_prefix.mwuser(user_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED; -ALTER TABLE &mw_prefix.image ADD CONSTRAINT &mw_prefix.image_fk1 FOREIGN KEY (img_user) REFERENCES &mw_prefix.mwuser(user_id) ON DELETE SET NULL DEFERRABLE INITIALLY DEFERRED; -ALTER TABLE &mw_prefix.oldimage ADD CONSTRAINT &mw_prefix.oldimage_fk1 FOREIGN KEY (oi_name) REFERENCES &mw_prefix.image(img_name) ON DELETE SET NULL DEFERRABLE INITIALLY DEFERRED; -ALTER TABLE &mw_prefix.oldimage ADD CONSTRAINT &mw_prefix.oldimage_fk2 FOREIGN KEY (oi_user) REFERENCES &mw_prefix.mwuser(user_id) ON DELETE SET NULL DEFERRABLE INITIALLY DEFERRED; -ALTER TABLE &mw_prefix.filearchive ADD CONSTRAINT &mw_prefix.filearchive_fk1 FOREIGN KEY (fa_deleted_user) REFERENCES &mw_prefix.mwuser(user_id) ON DELETE SET NULL DEFERRABLE INITIALLY DEFERRED; -ALTER TABLE &mw_prefix.filearchive ADD CONSTRAINT &mw_prefix.filearchive_fk2 FOREIGN KEY (fa_user) REFERENCES &mw_prefix.mwuser(user_id) ON DELETE SET NULL DEFERRABLE INITIALLY DEFERRED; -ALTER TABLE &mw_prefix.recentchanges ADD CONSTRAINT &mw_prefix.recentchanges_fk1 FOREIGN KEY (rc_user) REFERENCES &mw_prefix.mwuser(user_id) ON DELETE SET NULL DEFERRABLE INITIALLY DEFERRED; -ALTER TABLE &mw_prefix.recentchanges ADD CONSTRAINT &mw_prefix.recentchanges_fk2 FOREIGN KEY (rc_cur_id) REFERENCES &mw_prefix.page(page_id) ON DELETE SET NULL DEFERRABLE INITIALLY DEFERRED; -ALTER TABLE &mw_prefix.watchlist ADD CONSTRAINT &mw_prefix.watchlist_fk1 FOREIGN KEY (wl_user) REFERENCES &mw_prefix.mwuser(user_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED; -ALTER TABLE &mw_prefix.logging ADD CONSTRAINT &mw_prefix.logging_fk1 FOREIGN KEY (log_user) REFERENCES &mw_prefix.mwuser(user_id) ON DELETE SET NULL DEFERRABLE INITIALLY DEFERRED; -ALTER TABLE &mw_prefix.redirect ADD CONSTRAINT &mw_prefix.redirect_fk1 FOREIGN KEY (rd_from) REFERENCES &mw_prefix.page(page_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED; -ALTER TABLE &mw_prefix.page_restrictions ADD CONSTRAINT &mw_prefix.page_restrictions_fk1 FOREIGN KEY (pr_page) REFERENCES &mw_prefix.page(page_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED; - diff --git a/maintenance/oracle/archives/patch_namespace_defaults.sql b/maintenance/oracle/archives/patch_namespace_defaults.sql deleted file mode 100644 index 24c95643..00000000 --- a/maintenance/oracle/archives/patch_namespace_defaults.sql +++ /dev/null @@ -1,17 +0,0 @@ -define mw_prefix='{$wgDBprefix}'; - -ALTER TABLE &mw_prefix.page MODIFY page_namespace DEFAULT 0; -ALTER TABLE &mw_prefix.archive MODIFY ar_namespace DEFAULT 0; -ALTER TABLE &mw_prefix.pagelinks MODIFY pl_namespace DEFAULT 0; -ALTER TABLE &mw_prefix.templatelinks MODIFY tl_namespace DEFAULT 0; -ALTER TABLE &mw_prefix.recentchanges MODIFY rc_namespace DEFAULT 0; -ALTER TABLE &mw_prefix.querycache MODIFY qc_namespace DEFAULT 0; -ALTER TABLE &mw_prefix.logging MODIFY log_namespace DEFAULT 0; -ALTER TABLE &mw_prefix.job MODIFY job_namespace DEFAULT 0; -ALTER TABLE &mw_prefix.redirect MODIFY rd_namespace DEFAULT 0; -ALTER TABLE &mw_prefix.protected_titles MODIFY pt_namespace DEFAULT 0; -ALTER TABLE &mw_prefix.archive MODIFY ar_namespace DEFAULT 0; -ALTER TABLE &mw_prefix.archive MODIFY ar_namespace DEFAULT 0; -ALTER TABLE &mw_prefix.archive MODIFY ar_namespace DEFAULT 0; -ALTER TABLE &mw_prefix.archive MODIFY ar_namespace DEFAULT 0; - diff --git a/maintenance/oracle/archives/patch_rebuild_dupfunc.sql b/maintenance/oracle/archives/patch_rebuild_dupfunc.sql deleted file mode 100644 index 56ee5b3e..00000000 --- a/maintenance/oracle/archives/patch_rebuild_dupfunc.sql +++ /dev/null @@ -1,149 +0,0 @@ -/*$mw$*/ -CREATE OR REPLACE PROCEDURE duplicate_table(p_tabname IN VARCHAR2, - p_oldprefix IN VARCHAR2, - p_newprefix IN VARCHAR2, - p_temporary IN BOOLEAN) IS - e_table_not_exist EXCEPTION; - PRAGMA EXCEPTION_INIT(e_table_not_exist, -00942); - l_temp_ei_sql VARCHAR2(2000); - l_temporary BOOLEAN := p_temporary; -BEGIN - BEGIN - EXECUTE IMMEDIATE 'DROP TABLE ' || p_newprefix || p_tabname || - ' CASCADE CONSTRAINTS PURGE'; - EXCEPTION - WHEN e_table_not_exist THEN - NULL; - END; - IF (p_tabname = 'SEARCHINDEX') THEN - l_temporary := FALSE; - END IF; - IF (l_temporary) THEN - EXECUTE IMMEDIATE 'CREATE GLOBAL TEMPORARY TABLE ' || p_newprefix || - p_tabname || - ' ON COMMIT PRESERVE ROWS AS SELECT * FROM ' || - p_oldprefix || p_tabname || ' WHERE ROWNUM = 0'; - ELSE - EXECUTE IMMEDIATE 'CREATE TABLE ' || p_newprefix || p_tabname || - ' AS SELECT * FROM ' || p_oldprefix || p_tabname || - ' WHERE ROWNUM = 0'; - END IF; - FOR rc IN (SELECT column_name, data_default - FROM user_tab_columns - WHERE table_name = p_oldprefix || p_tabname - AND data_default IS NOT NULL) LOOP - EXECUTE IMMEDIATE 'ALTER TABLE ' || p_newprefix || p_tabname || - ' MODIFY ' || rc.column_name || ' DEFAULT ' || - SUBSTR(rc.data_default, 1, 2000); - END LOOP; - FOR rc IN (SELECT REPLACE(REPLACE(DBMS_LOB.SUBSTR(DBMS_METADATA.get_ddl('CONSTRAINT', - constraint_name), - 32767, - 1), - USER || '"."' || p_oldprefix, - USER || '"."' || p_newprefix), - '"' || constraint_name || '"', - '"' || p_newprefix || constraint_name || '"') DDLVC2, - constraint_name - FROM user_constraints uc - WHERE table_name = p_oldprefix || p_tabname - AND constraint_type = 'P') LOOP - l_temp_ei_sql := SUBSTR(rc.ddlvc2, 1, INSTR(rc.ddlvc2, 'PCTFREE') - 1); - l_temp_ei_sql := SUBSTR(l_temp_ei_sql, - 1, - INSTR(l_temp_ei_sql, - ')', - INSTR(l_temp_ei_sql, 'PRIMARY KEY') + 1) + 1); - IF nvl(length(l_temp_ei_sql), 0) > 0 THEN - EXECUTE IMMEDIATE l_temp_ei_sql; - END IF; - END LOOP; - IF (NOT l_temporary) THEN - FOR rc IN (SELECT REPLACE(DBMS_LOB.SUBSTR(DBMS_METADATA.get_ddl('REF_CONSTRAINT', - constraint_name), - 32767, - 1), - USER || '"."' || p_oldprefix, - USER || '"."' || p_newprefix) DDLVC2, - constraint_name - FROM user_constraints uc - WHERE table_name = p_oldprefix || p_tabname - AND constraint_type = 'R') LOOP - IF nvl(length(l_temp_ei_sql), 0) > 0 AND - INSTR(l_temp_ei_sql, 'PRIMARY KEY') = 0 THEN - EXECUTE IMMEDIATE l_temp_ei_sql; - END IF; - END LOOP; - END IF; - FOR rc IN (SELECT REPLACE(REPLACE(DBMS_LOB.SUBSTR(DBMS_METADATA.get_ddl('INDEX', - index_name), - 32767, - 1), - USER || '"."' || p_oldprefix, - USER || '"."' || p_newprefix), - '"' || index_name || '"', - '"' || p_newprefix || index_name || '"') DDLVC2, - index_name, - index_type - FROM user_indexes ui - WHERE table_name = p_oldprefix || p_tabname - AND index_type NOT IN ('LOB', 'DOMAIN') - AND NOT EXISTS - (SELECT NULL - FROM user_constraints - WHERE table_name = ui.table_name - AND constraint_name = ui.index_name)) LOOP - l_temp_ei_sql := SUBSTR(rc.ddlvc2, 1, INSTR(rc.ddlvc2, 'PCTFREE') - 1); - l_temp_ei_sql := SUBSTR(l_temp_ei_sql, - 1, - INSTR(l_temp_ei_sql, - ')', - INSTR(l_temp_ei_sql, - '"' || USER || '"."' || p_newprefix || '"') + 1) + 1); - IF nvl(length(l_temp_ei_sql), 0) > 0 THEN - EXECUTE IMMEDIATE l_temp_ei_sql; - END IF; - END LOOP; - FOR rc IN (SELECT REPLACE(REPLACE(DBMS_LOB.SUBSTR(DBMS_METADATA.get_ddl('INDEX', - index_name), - 32767, - 1), - USER || '"."' || p_oldprefix, - USER || '"."' || p_newprefix), - '"' || index_name || '"', - '"' || p_newprefix || index_name || '"') DDLVC2, - index_name, - index_type - FROM user_indexes ui - WHERE table_name = p_oldprefix || p_tabname - AND index_type = 'DOMAIN' - AND NOT EXISTS - (SELECT NULL - FROM user_constraints - WHERE table_name = ui.table_name - AND constraint_name = ui.index_name)) LOOP - l_temp_ei_sql := rc.ddlvc2; - IF nvl(length(l_temp_ei_sql), 0) > 0 THEN - EXECUTE IMMEDIATE l_temp_ei_sql; - END IF; - END LOOP; - FOR rc IN (SELECT REPLACE(REPLACE(UPPER(DBMS_LOB.SUBSTR(DBMS_METADATA.get_ddl('TRIGGER', - trigger_name), - 32767, - 1)), - USER || '"."' || p_oldprefix, - USER || '"."' || p_newprefix), - ' ON ' || p_oldprefix || p_tabname, - ' ON ' || p_newprefix || p_tabname) DDLVC2, - trigger_name - FROM user_triggers - WHERE table_name = p_oldprefix || p_tabname) LOOP - l_temp_ei_sql := SUBSTR(rc.ddlvc2, 1, INSTR(rc.ddlvc2, 'ALTER ') - 1); - IF nvl(length(l_temp_ei_sql), 0) > 0 THEN - EXECUTE IMMEDIATE l_temp_ei_sql; - END IF; - END LOOP; -END; - -/*$mw$*/ - diff --git a/maintenance/oracle/archives/patch_recentchanges_fk2_cascade.sql b/maintenance/oracle/archives/patch_recentchanges_fk2_cascade.sql deleted file mode 100644 index 45509518..00000000 --- a/maintenance/oracle/archives/patch_recentchanges_fk2_cascade.sql +++ /dev/null @@ -1,5 +0,0 @@ -define mw_prefix='{$wgDBprefix}'; - -ALTER TABLE &mw_prefix.recentchanges DROP CONSTRAINT &mw_prefix.recentchanges_fk2; -ALTER TABLE &mw_prefix.recentchanges ADD CONSTRAINT &mw_prefix.recentchanges_fk2 FOREIGN KEY (rc_cur_id) REFERENCES &mw_prefix.page(page_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED; - diff --git a/maintenance/oracle/archives/patch_remove_not_null_empty_defs.sql b/maintenance/oracle/archives/patch_remove_not_null_empty_defs.sql deleted file mode 100644 index 76e50a0a..00000000 --- a/maintenance/oracle/archives/patch_remove_not_null_empty_defs.sql +++ /dev/null @@ -1,9 +0,0 @@ -define mw_prefix='{$wgDBprefix}'; - -ALTER TABLE &mw_prefix.categorylinks MODIFY cl_sortkey_prefix DEFAULT NULL NULL; -ALTER TABLE &mw_prefix.categorylinks MODIFY cl_collation DEFAULT NULL NULL; -ALTER TABLE &mw_prefix.iwlinks MODIFY iwl_prefix DEFAULT NULL NULL; -ALTER TABLE &mw_prefix.iwlinks MODIFY iwl_title DEFAULT NULL NULL; -ALTER TABLE &mw_prefix.searchindex MODIFY si_title DEFAULT NULL NULL; -ALTER TABLE &mw_prefix.querycachetwo MODIFY qcc_title DEFAULT NULL NULL; -ALTER TABLE &mw_prefix.querycachetwo MODIFY qcc_titletwo DEFAULT NULL NULL; diff --git a/maintenance/oracle/archives/patch_remove_not_null_empty_defs2.sql b/maintenance/oracle/archives/patch_remove_not_null_empty_defs2.sql deleted file mode 100644 index f7a38a05..00000000 --- a/maintenance/oracle/archives/patch_remove_not_null_empty_defs2.sql +++ /dev/null @@ -1,3 +0,0 @@ -define mw_prefix='{$wgDBprefix}'; - -ALTER TABLE &mw_prefix.ipblocks MODIFY ipb_by_text DEFAULT NULL NULL; |