| Index: branches/roman/trunk/phase3/maintenance/archives/patch-rev_text_id.sql |
| — | — | @@ -1,17 +0,0 @@ |
| 2 | | - |
| 3 | | -ALTER TABLE /*$wgDBprefix*/revision |
| 4 | | - ADD rev_text_id int(8) unsigned NOT NULL; |
| 5 | | - |
| 6 | | -UPDATE /*$wgDBprefix*/revision |
| 7 | | - SET rev_text_id=rev_id; |
| Index: branches/roman/trunk/phase3/maintenance/archives/patch-rev_parent_id.sql |
| — | — | @@ -0,0 +1,9 @@ |
| | 2 | +-- |
| | 3 | +-- Key to revision.rev_id |
| | 4 | +-- This field is used to add support for a tree structure (The Adjacency List Model) |
| | 5 | +-- |
| | 6 | +-- 2007-03-04 |
| | 7 | +-- |
| | 8 | + |
| | 9 | +ALTER TABLE /*$wgDBprefix*/revision |
| | 10 | + ADD rev_parent_id int(8) unsigned default NULL; |
| Index: branches/roman/trunk/phase3/maintenance/postgres/tables.sql |
| — | — | @@ -92,7 +92,10 @@ |
| 93 | 93 | rev_user_text TEXT NOT NULL, |
| 94 | 94 | rev_timestamp TIMESTAMPTZ NOT NULL, |
| 95 | 95 | rev_minor_edit CHAR NOT NULL DEFAULT '0', |
| 96 | | - rev_deleted CHAR NOT NULL DEFAULT '0' |
| | 96 | + rev_deleted CHAR NOT NULL DEFAULT '0', |
| | 97 | + rev_parent_id INTEGER DEFAULT NULL |
| | 98 | + |
| | 99 | + |
| 97 | 100 | ); |
| 98 | 101 | CREATE UNIQUE INDEX revision_unique ON revision (rev_page, rev_id); |
| 99 | 102 | CREATE INDEX rev_text_id_idx ON revision (rev_text_id); |
| Index: branches/roman/trunk/phase3/maintenance/tables.sql |
| — | — | @@ -270,6 +270,10 @@ |
| 271 | 271 | -- Not yet used; reserved for future changes to the deletion system. |
| 272 | 272 | rev_deleted tinyint(1) unsigned NOT NULL default '0', |
| 273 | 273 | |
| | 274 | + --Key to revision.rev_id |
| | 275 | + --This field is used to add support for a tree structure (The Adjacency List Model) |
| | 276 | + rev_parent_id int(8) unsigned default NULL, |
| | 277 | + |
| 274 | 278 | PRIMARY KEY rev_page_id (rev_page, rev_id), |
| 275 | 279 | UNIQUE INDEX rev_id (rev_id), |
| 276 | 280 | INDEX rev_timestamp (rev_timestamp), |
| Index: branches/roman/trunk/phase3/maintenance/mysql5/tables.sql |
| — | — | @@ -282,7 +282,12 @@ |
| 283 | 283 | |
| 284 | 284 | -- Not yet used; reserved for future changes to the deletion system. |
| 285 | 285 | rev_deleted tinyint(1) unsigned NOT NULL default '0', |
| 286 | | - |
| | 286 | + |
| | 287 | + --Key to revision.rev_id |
| | 288 | + --This field is used to add support for a tree structure (The Adjacency List Model) |
| | 289 | + rev_parent_id int(8) unsigned default NULL, |
| | 290 | + |
| | 291 | + |
| 287 | 292 | PRIMARY KEY rev_page_id (rev_page, rev_id), |
| 288 | 293 | UNIQUE INDEX rev_id (rev_id), |
| 289 | 294 | INDEX rev_timestamp (rev_timestamp), |
| Index: branches/roman/trunk/phase3/maintenance/mysql5/tables-binary.sql |
| — | — | @@ -292,11 +292,10 @@ |
| 293 | 293 | -- Not yet used; reserved for future changes to the deletion system. |
| 294 | 294 | rev_deleted tinyint(1) unsigned NOT NULL default '0', |
| 295 | 295 | |
| 296 | | - --Key to revision.rev_id |
| | 296 | + --Key to revision.rev_id |
| 297 | 297 | --This field is used to add support for a tree structure (The Adjacency List Model) |
| 298 | 298 | rev_parent_id int(8) unsigned default NULL, |
| 299 | 299 | |
| 300 | | - |
| 301 | 300 | PRIMARY KEY rev_page_id (rev_page, rev_id), |
| 302 | 301 | UNIQUE INDEX rev_id (rev_id), |
| 303 | 302 | INDEX rev_timestamp (rev_timestamp), |