| Index: trunk/phase3/maintenance/oracle/archives/patch-rev_sha1_field.sql |
| — | — | @@ -0,0 +1,4 @@ |
| | 2 | +define mw_prefix='{$wgDBprefix}'; |
| | 3 | + |
| | 4 | +ALTER TABLE &mw_prefix.revision ADD rev_sha1 VARCHAR2(32); |
| | 5 | + |
| Property changes on: trunk/phase3/maintenance/oracle/archives/patch-rev_sha1_field.sql |
| ___________________________________________________________________ |
| Added: svn:eol-style |
| 1 | 6 | + native |
| Index: trunk/phase3/maintenance/oracle/archives/patch-ar_sha1_field.sql |
| — | — | @@ -0,0 +1,3 @@ |
| | 2 | +define mw_prefix='{$wgDBprefix}'; |
| | 3 | + |
| | 4 | +ALTER TABLE &mw_prefix.archive ADD ar_sha1 VARCHAR2(32); |
| Property changes on: trunk/phase3/maintenance/oracle/archives/patch-ar_sha1_field.sql |
| ___________________________________________________________________ |
| Added: svn:eol-style |
| 1 | 5 | + native |
| Index: trunk/phase3/maintenance/oracle/tables.sql |
| — | — | @@ -44,10 +44,6 @@ |
| 45 | 45 | 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; |
| 46 | 46 | CREATE UNIQUE INDEX &mw_prefix.user_former_groups_u01 ON &mw_prefix.user_former_groups (ufg_user,ufg_group); |
| 47 | 47 | |
| 48 | | - |
| 49 | | -CREATE UNIQUE INDEX /*i*/ufg_user_group ON /*_*/user_former_groups (ufg_user,ufg_group); |
| 50 | | - |
| 51 | | - |
| 52 | 48 | CREATE TABLE &mw_prefix.user_newtalk ( |
| 53 | 49 | user_id NUMBER DEFAULT 0 NOT NULL, |
| 54 | 50 | user_ip VARCHAR2(40) NULL, |
| — | — | @@ -108,7 +104,8 @@ |
| 109 | 105 | rev_minor_edit CHAR(1) DEFAULT '0' NOT NULL, |
| 110 | 106 | rev_deleted CHAR(1) DEFAULT '0' NOT NULL, |
| 111 | 107 | rev_len NUMBER NULL, |
| 112 | | - rev_parent_id NUMBER DEFAULT NULL |
| | 108 | + rev_parent_id NUMBER DEFAULT NULL, |
| | 109 | + rev_sha1 VARCHAR2(32) NULL |
| 113 | 110 | ); |
| 114 | 111 | ALTER TABLE &mw_prefix.revision ADD CONSTRAINT &mw_prefix.revision_pk PRIMARY KEY (rev_id); |
| 115 | 112 | 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; |
| — | — | @@ -142,7 +139,8 @@ |
| 143 | 140 | ar_deleted CHAR(1) DEFAULT '0' NOT NULL, |
| 144 | 141 | ar_len NUMBER, |
| 145 | 142 | ar_page_id NUMBER, |
| 146 | | - ar_parent_id NUMBER |
| | 143 | + ar_parent_id NUMBER, |
| | 144 | + ar_sha1 VARCHAR2(32) NULL |
| 147 | 145 | ); |
| 148 | 146 | 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; |
| 149 | 147 | CREATE INDEX &mw_prefix.archive_i01 ON &mw_prefix.archive (ar_namespace,ar_title,ar_timestamp); |
| Index: trunk/phase3/includes/installer/OracleUpdater.php |
| — | — | @@ -44,6 +44,8 @@ |
| 45 | 45 | array( 'addTable', 'globaltemplatelinks', 'patch-globaltemplatelinks.sql' ), |
| 46 | 46 | array( 'addTable', 'globalnamespaces', 'patch-globalnamespaces.sql' ), |
| 47 | 47 | array( 'addTable', 'globalinterwiki', 'patch-globalinterwiki.sql' ), |
| | 48 | + array( 'addField', 'revision', 'rev_sha1', 'patch-rev_sha1_field.sql' ), |
| | 49 | + array( 'addField', 'archive', 'ar_sha1', 'patch-ar_sha1_field.sql' ), |
| 48 | 50 | |
| 49 | 51 | // till 2.0 i guess |
| 50 | 52 | array( 'doRebuildDuplicateFunction' ), |