From 4063392a82f37a69d62a6bdab8d01a53a0b784f0 Mon Sep 17 00:00:00 2001
From: Brion Vibber <brion@users.mediawiki.org>
Date: Fri, 9 Mar 2007 20:50:11 +0000
Subject: [PATCH] Since we're making other changes, let's bring in that
 rev_parent_id field from branches/roman

---
 maintenance/archives/patch-rev_parent_id.sql | 9 +++++++++
 maintenance/mysql5/tables-binary.sql         | 9 ++++++++-
 maintenance/mysql5/tables.sql                | 9 ++++++++-
 maintenance/postgres/tables.sql              | 3 ++-
 maintenance/tables.sql                       | 4 ++++
 maintenance/updaters.inc                     | 3 ++-
 6 files changed, 33 insertions(+), 4 deletions(-)
 create mode 100644 maintenance/archives/patch-rev_parent_id.sql

diff --git a/maintenance/archives/patch-rev_parent_id.sql b/maintenance/archives/patch-rev_parent_id.sql
new file mode 100644
index 0000000000..971122bb76
--- /dev/null
+++ b/maintenance/archives/patch-rev_parent_id.sql
@@ -0,0 +1,9 @@
+--
+-- 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 d7d3b2cbca..e75e903f12 100644
--- a/maintenance/mysql5/tables-binary.sql
+++ b/maintenance/mysql5/tables-binary.sql
@@ -291,7 +291,14 @@ CREATE TABLE /*$wgDBprefix*/revision (
   
   -- Not yet used; reserved for future changes to the deletion system.
   rev_deleted tinyint(1) unsigned NOT NULL default '0',
-  
+
+  -- Length of this revision in bytes
+  rev_len int(8) unsigned,
+
+  --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 6ea624324c..8a8fed1ca0 100644
--- a/maintenance/mysql5/tables.sql
+++ b/maintenance/mysql5/tables.sql
@@ -282,7 +282,14 @@ CREATE TABLE /*$wgDBprefix*/revision (
   
   -- Not yet used; reserved for future changes to the deletion system.
   rev_deleted tinyint(1) unsigned NOT NULL default '0',
-  
+
+  -- Length of this revision in bytes
+  rev_len int(8) unsigned,
+
+  --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 bdbf2e180a..b8412ba474 100644
--- a/maintenance/postgres/tables.sql
+++ b/maintenance/postgres/tables.sql
@@ -93,7 +93,8 @@ CREATE TABLE revision (
   rev_timestamp   TIMESTAMPTZ  NOT NULL,
   rev_minor_edit  CHAR         NOT NULL  DEFAULT '0',
   rev_deleted     CHAR         NOT NULL  DEFAULT '0',
-  rev_len         INTEGER          NULL
+  rev_len         INTEGER          NULL,
+  rev_parent_id   INTEGER      	   DEFAULT NULL
 );
 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 ba1a885a4b..8a75ce76be 100644
--- a/maintenance/tables.sql
+++ b/maintenance/tables.sql
@@ -273,6 +273,10 @@ CREATE TABLE /*$wgDBprefix*/revision (
   -- Length of this revision in bytes
   rev_len int(8) unsigned,
 
+  --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 902a38cf61..ca2da347b8 100644
--- a/maintenance/updaters.inc
+++ b/maintenance/updaters.inc
@@ -69,6 +69,7 @@ $wgNewFields = array(
 	array( 'logging',	'log_id',		'patch-log_id.sql' ),
 	array( 'page_restrictions', 'pr_id',		'patch-page_restrictions_sortkey.sql' ),
 	array( 'revision',	'rev_len',              'patch-rev_len.sql' ),
+ 	array( 'revision',	'rev_parent_id',        'patch-rev_parent_id.sql' ),
 );
 
 function rename_table( $from, $to, $patch ) {
@@ -414,7 +415,7 @@ 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),
   			INDEX rev_timestamp (rev_timestamp),
-- 
2.20.1