From c7fe2fa1712847a76866981e4cfed3554925f93a Mon Sep 17 00:00:00 2001 From: Jure Kajzer Date: Fri, 4 Nov 2011 07:17:13 +0000 Subject: [PATCH] * fixed a typo in oracle/tables.sql * readded the sha1 fields (installer & upgrader) --- includes/installer/OracleUpdater.php | 2 ++ maintenance/oracle/archives/patch-ar_sha1_field.sql | 3 +++ maintenance/oracle/archives/patch-rev_sha1_field.sql | 4 ++++ maintenance/oracle/tables.sql | 10 ++++------ 4 files changed, 13 insertions(+), 6 deletions(-) create mode 100644 maintenance/oracle/archives/patch-ar_sha1_field.sql create mode 100644 maintenance/oracle/archives/patch-rev_sha1_field.sql diff --git a/includes/installer/OracleUpdater.php b/includes/installer/OracleUpdater.php index 027244c69a..82031ad2cb 100644 --- a/includes/installer/OracleUpdater.php +++ b/includes/installer/OracleUpdater.php @@ -44,6 +44,8 @@ class OracleUpdater extends DatabaseUpdater { array( 'addTable', 'globaltemplatelinks', 'patch-globaltemplatelinks.sql' ), array( 'addTable', 'globalnamespaces', 'patch-globalnamespaces.sql' ), array( 'addTable', 'globalinterwiki', 'patch-globalinterwiki.sql' ), + array( 'addField', 'revision', 'rev_sha1', 'patch-rev_sha1_field.sql' ), + array( 'addField', 'archive', 'ar_sha1', 'patch-ar_sha1_field.sql' ), // till 2.0 i guess array( 'doRebuildDuplicateFunction' ), diff --git a/maintenance/oracle/archives/patch-ar_sha1_field.sql b/maintenance/oracle/archives/patch-ar_sha1_field.sql new file mode 100644 index 0000000000..de723ce756 --- /dev/null +++ b/maintenance/oracle/archives/patch-ar_sha1_field.sql @@ -0,0 +1,3 @@ +define mw_prefix='{$wgDBprefix}'; + +ALTER TABLE &mw_prefix.archive ADD ar_sha1 VARCHAR2(32); diff --git a/maintenance/oracle/archives/patch-rev_sha1_field.sql b/maintenance/oracle/archives/patch-rev_sha1_field.sql new file mode 100644 index 0000000000..80544e897f --- /dev/null +++ b/maintenance/oracle/archives/patch-rev_sha1_field.sql @@ -0,0 +1,4 @@ +define mw_prefix='{$wgDBprefix}'; + +ALTER TABLE &mw_prefix.revision ADD rev_sha1 VARCHAR2(32); + diff --git a/maintenance/oracle/tables.sql b/maintenance/oracle/tables.sql index f50aae06fb..c9fc05f404 100644 --- a/maintenance/oracle/tables.sql +++ b/maintenance/oracle/tables.sql @@ -44,10 +44,6 @@ CREATE TABLE &mw_prefix.user_former_groups ( 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); - -CREATE UNIQUE INDEX /*i*/ufg_user_group ON /*_*/user_former_groups (ufg_user,ufg_group); - - CREATE TABLE &mw_prefix.user_newtalk ( user_id NUMBER DEFAULT 0 NOT NULL, user_ip VARCHAR2(40) NULL, @@ -108,7 +104,8 @@ CREATE TABLE &mw_prefix.revision ( rev_minor_edit CHAR(1) DEFAULT '0' NOT NULL, rev_deleted CHAR(1) DEFAULT '0' NOT NULL, rev_len NUMBER NULL, - rev_parent_id NUMBER DEFAULT NULL + rev_parent_id NUMBER DEFAULT NULL, + rev_sha1 VARCHAR2(32) NULL ); ALTER TABLE &mw_prefix.revision ADD CONSTRAINT &mw_prefix.revision_pk PRIMARY KEY (rev_id); 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 @@ CREATE TABLE &mw_prefix.archive ( ar_deleted CHAR(1) DEFAULT '0' NOT NULL, ar_len NUMBER, ar_page_id NUMBER, - ar_parent_id NUMBER + ar_parent_id NUMBER, + ar_sha1 VARCHAR2(32) NULL ); 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; CREATE INDEX &mw_prefix.archive_i01 ON &mw_prefix.archive (ar_namespace,ar_title,ar_timestamp); -- 2.20.1