diff options
author | coadde [Márcio Alexandre Silva Delgado] <coadde@parabola.nu> | 2016-07-04 16:01:35 -0300 |
---|---|---|
committer | coadde [Márcio Alexandre Silva Delgado] <coadde@parabola.nu> | 2016-07-04 16:01:35 -0300 |
commit | 7a31146918cdceef14689bf05d8f1602ec05bfcb (patch) | |
tree | d52097466c0e690ac95e8ef20376c4ed4e9cc4cd /maintenance/oracle/archives/patch-sites.sql | |
parent | c54534b54ae0f8d50fb0367e3bae8ab4a10bfbb3 (diff) |
remove nonfree Database support
Diffstat (limited to 'maintenance/oracle/archives/patch-sites.sql')
-rw-r--r-- | maintenance/oracle/archives/patch-sites.sql | 34 |
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); |