| Index: branches/REL1_18/phase3/maintenance/oracle/archives/patch-uploadstash.sql |
| — | — | @@ -0,0 +1,25 @@ |
| | 2 | +define mw_prefix='{$wgDBprefix}'; |
| | 3 | + |
| | 4 | +CREATE SEQUENCE uploadstash_us_id_seq; |
| | 5 | +CREATE TABLE &mw_prefix.uploadstash ( |
| | 6 | + us_id NUMBER NOT NULL, |
| | 7 | + us_user NUMBER DEFAULT 0 NOT NULL, |
| | 8 | + us_key VARCHAR2(255) NOT NULL, |
| | 9 | + us_orig_path VARCHAR2(255) NOT NULL, |
| | 10 | + us_path VARCHAR2(255) NOT NULL, |
| | 11 | + us_source_type VARCHAR2(50), |
| | 12 | + us_timestamp TIMESTAMP(6) WITH TIME ZONE, |
| | 13 | + us_status VARCHAR2(50) NOT NULL, |
| | 14 | + us_size NUMBER NOT NULL, |
| | 15 | + us_sha1 VARCHAR2(32) NOT NULL, |
| | 16 | + us_mime VARCHAR2(255), |
| | 17 | + us_media_type VARCHAR2(32) DEFAULT NULL, |
| | 18 | + us_image_width NUMBER, |
| | 19 | + us_image_height NUMBER, |
| | 20 | + us_image_bits NUMBER |
| | 21 | +); |
| | 22 | +ALTER TABLE &mw_prefix.uploadstash ADD CONSTRAINT &mw_prefix.uploadstash_pk PRIMARY KEY (us_id); |
| | 23 | +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; |
| | 24 | +CREATE INDEX &mw_prefix.uploadstash_i01 ON &mw_prefix.uploadstash (us_user); |
| | 25 | +CREATE INDEX &mw_prefix.uploadstash_i02 ON &mw_prefix.uploadstash (us_timestamp); |
| | 26 | +CREATE UNIQUE INDEX &mw_prefix.uploadstash_u01 ON &mw_prefix.uploadstash (us_key); |
| Property changes on: branches/REL1_18/phase3/maintenance/oracle/archives/patch-uploadstash.sql |
| ___________________________________________________________________ |
| Added: svn:eol-style |
| 1 | 27 | + native |
| Index: branches/REL1_18/phase3/maintenance/oracle/archives/patch-user_former_groups.sql |
| — | — | @@ -0,0 +1,9 @@ |
| | 2 | +define mw_prefix='{$wgDBprefix}'; |
| | 3 | + |
| | 4 | +CREATE TABLE &mw_prefix.user_former_groups ( |
| | 5 | + ufg_user NUMBER DEFAULT 0 NOT NULL, |
| | 6 | + ufg_group VARCHAR2(16) NOT NULL |
| | 7 | +); |
| | 8 | +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; |
| | 9 | +CREATE UNIQUE INDEX &mw_prefix.user_former_groups_u01 ON &mw_prefix.user_former_groups (ufg_user,ufg_group); |
| | 10 | + |
| Property changes on: branches/REL1_18/phase3/maintenance/oracle/archives/patch-user_former_groups.sql |
| ___________________________________________________________________ |
| Added: svn:eol-style |
| 1 | 11 | + native |
| Index: branches/REL1_18/phase3/maintenance/oracle/archives/patch-user_email_index.sql |
| — | — | @@ -1,4 +1,4 @@ |
| 2 | 2 | define mw_prefix='{$wgDBprefix}'; |
| 3 | 3 | |
| 4 | | -CREATE INDEX &mw_prefix.mwuser_i02 ON &mw_prefix.mwuser (user_email, user_name); |
| | 4 | +CREATE INDEX &mw_prefix.mwuser_i02 ON &mw_prefix.mwuser (user_email); |
| 5 | 5 | |
| Index: branches/REL1_18/phase3/includes/installer/OracleUpdater.php |
| — | — | @@ -30,10 +30,12 @@ |
| 31 | 31 | array( 'doSchemaUpgrade17' ), |
| 32 | 32 | array( 'doInsertPage0' ), |
| 33 | 33 | array( 'doRemoveNotNullEmptyDefaults' ), |
| | 34 | + array( 'addTable', 'user_former_groups', 'patch-user_former_groups.sql' ), |
| 34 | 35 | |
| 35 | 36 | //1.18 |
| 36 | 37 | array( 'addIndex', 'user', 'i02', 'patch-user_email_index.sql' ), |
| 37 | 38 | array( 'modifyField', 'user_properties', 'up_property', 'patch-up_property.sql' ), |
| | 39 | + array( 'addTable', 'uploadstash', 'patch-uploadstash.sql' ), |
| 38 | 40 | |
| 39 | 41 | // till 2.0 i guess |
| 40 | 42 | array( 'doRebuildDuplicateFunction' ), |