summaryrefslogtreecommitdiff
path: root/maintenance/oracle/archives/patch-sites.sql
diff options
context:
space:
mode:
Diffstat (limited to 'maintenance/oracle/archives/patch-sites.sql')
-rw-r--r--maintenance/oracle/archives/patch-sites.sql34
1 files changed, 0 insertions, 34 deletions
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);