From a063c8f0f1f03d14c176b2d79218e91c41239930 Mon Sep 17 00:00:00 2001 From: Brion Vibber Date: Fri, 9 Feb 2007 19:41:31 +0000 Subject: [PATCH] Revert r19843 for now; unreviewed schema changes --- RELEASE-NOTES | 1 - maintenance/archives/patch-rev_parent_id.sql | 9 --------- maintenance/mysql5/tables-binary.sql | 4 ---- maintenance/mysql5/tables.sql | 4 ---- maintenance/postgres/tables.sql | 4 +--- maintenance/tables.sql | 4 ---- maintenance/updaters.inc | 2 -- 7 files changed, 1 insertion(+), 27 deletions(-) delete mode 100644 maintenance/archives/patch-rev_parent_id.sql diff --git a/RELEASE-NOTES b/RELEASE-NOTES index 2a899256f2..e6c14684bd 100644 --- a/RELEASE-NOTES +++ b/RELEASE-NOTES @@ -184,7 +184,6 @@ lighter making things easier to read. of other tables while they work. * Message names changed for AlphabeticPager introduced with r19758 for better localisations. -* Tree structure has been added to revision table == Languages updated == diff --git a/maintenance/archives/patch-rev_parent_id.sql b/maintenance/archives/patch-rev_parent_id.sql deleted file mode 100644 index 971122bb76..0000000000 --- a/maintenance/archives/patch-rev_parent_id.sql +++ /dev/null @@ -1,9 +0,0 @@ --- --- Key to revision.rev_id --- This field is used to add support for a tree structure (The Adjacency List Model) --- --- 2007-03-04 --- - -ALTER TABLE /*$wgDBprefix*/revision - ADD rev_parent_id int(8) unsigned default NULL; diff --git a/maintenance/mysql5/tables-binary.sql b/maintenance/mysql5/tables-binary.sql index 0d98f5f0c8..7f970f94ae 100644 --- a/maintenance/mysql5/tables-binary.sql +++ b/maintenance/mysql5/tables-binary.sql @@ -292,10 +292,6 @@ CREATE TABLE /*$wgDBprefix*/revision ( -- Not yet used; reserved for future changes to the deletion system. rev_deleted tinyint(1) unsigned NOT NULL default '0', - --Key to revision.rev_id - --This field is used to add support for a tree structure (The Adjacency List Model) - rev_parent_id int(8) unsigned default NULL, - PRIMARY KEY rev_page_id (rev_page, rev_id), UNIQUE INDEX rev_id (rev_id), INDEX rev_timestamp (rev_timestamp), diff --git a/maintenance/mysql5/tables.sql b/maintenance/mysql5/tables.sql index 9afbd7d93f..11c9b16514 100644 --- a/maintenance/mysql5/tables.sql +++ b/maintenance/mysql5/tables.sql @@ -283,10 +283,6 @@ CREATE TABLE /*$wgDBprefix*/revision ( -- Not yet used; reserved for future changes to the deletion system. rev_deleted tinyint(1) unsigned NOT NULL default '0', - --Key to revision.rev_id - --This field is used to add support for a tree structure (The Adjacency List Model) - rev_parent_id int(8) unsigned default NULL, - PRIMARY KEY rev_page_id (rev_page, rev_id), UNIQUE INDEX rev_id (rev_id), INDEX rev_timestamp (rev_timestamp), diff --git a/maintenance/postgres/tables.sql b/maintenance/postgres/tables.sql index 1f7162b9e0..62e021e87a 100644 --- a/maintenance/postgres/tables.sql +++ b/maintenance/postgres/tables.sql @@ -92,9 +92,7 @@ CREATE TABLE revision ( rev_user_text TEXT NOT NULL, rev_timestamp TIMESTAMPTZ NOT NULL, rev_minor_edit CHAR NOT NULL DEFAULT '0', - rev_deleted CHAR NOT NULL DEFAULT '0', - rev_parent_id INTEGER DEFAULT NULL - + rev_deleted CHAR NOT NULL DEFAULT '0' ); CREATE UNIQUE INDEX revision_unique ON revision (rev_page, rev_id); CREATE INDEX rev_text_id_idx ON revision (rev_text_id); diff --git a/maintenance/tables.sql b/maintenance/tables.sql index d2235f0161..28339f6c07 100644 --- a/maintenance/tables.sql +++ b/maintenance/tables.sql @@ -270,10 +270,6 @@ CREATE TABLE /*$wgDBprefix*/revision ( -- Not yet used; reserved for future changes to the deletion system. rev_deleted tinyint(1) unsigned NOT NULL default '0', - --Key to revision.rev_id - --This field is used to add support for a tree structure (The Adjacency List Model) - rev_parent_id int(8) unsigned default NULL, - PRIMARY KEY rev_page_id (rev_page, rev_id), UNIQUE INDEX rev_id (rev_id), INDEX rev_timestamp (rev_timestamp), diff --git a/maintenance/updaters.inc b/maintenance/updaters.inc index efd4f51597..99cd39c5d0 100644 --- a/maintenance/updaters.inc +++ b/maintenance/updaters.inc @@ -67,7 +67,6 @@ $wgNewFields = array( array( 'user', 'user_newpass_time','patch-user_newpass_time.sql' ), array( 'user', 'user_editcount', 'patch-user_editcount.sql' ), array( 'logging', 'log_id', 'patch-log_id.sql' ), - array( 'revision', 'rev_parent_id', 'patch-rev_parent_id.sql' ), ); function rename_table( $from, $to, $patch ) { @@ -413,7 +412,6 @@ function do_schema_restructuring() { rev_timestamp char(14) binary NOT NULL default '', rev_minor_edit tinyint(1) unsigned NOT NULL default '0', rev_deleted tinyint(1) unsigned NOT NULL default '0', - rev_parent_id int(8) unsigned default NULL, PRIMARY KEY rev_page_id (rev_page, rev_id), UNIQUE INDEX rev_id (rev_id), -- 2.20.1