| Index: trunk/phase3/maintenance/archives/patch-ar_len.sql |
| — | — | @@ -0,0 +1,3 @@ |
| | 2 | +ALTER TABLE /*$wgDBprefix*/archive |
| | 3 | + ADD ar_len INT(8) UNSIGNED; |
| | 4 | + |
| Index: trunk/phase3/maintenance/postgres/tables.sql |
| — | — | @@ -136,8 +136,9 @@ |
| 137 | 137 | ar_rev_id INTEGER, |
| 138 | 138 | ar_text_id INTEGER, |
| 139 | 139 | ar_deleted INTEGER NOT NULL DEFAULT '0', |
| | 140 | + ar_len INTEGER NULL, |
| 140 | 141 | ); |
| 141 | | -CREATE INDEX archive_name_title_timestamp ON archive2 (ar_namespace,ar_title,ar_timestamp); |
| | 142 | +CREATE INDEX archive_name_title_timestamp ON archive (ar_namespace,ar_title,ar_timestamp); |
| 142 | 143 | |
| 143 | 144 | CREATE TABLE redirect ( |
| 144 | 145 | rd_from INTEGER NOT NULL REFERENCES page(page_id) ON DELETE CASCADE, |
| Index: trunk/phase3/maintenance/updaters.inc |
| — | — | @@ -74,6 +74,7 @@ |
| 75 | 75 | array( 'filearchive', 'fa_deleted', 'patch-fa_deleted.sql' ), |
| 76 | 76 | array( 'page_restrictions', 'pr_id', 'patch-page_restrictions_sortkey.sql' ), |
| 77 | 77 | array( 'revision', 'rev_len', 'patch-rev_len.sql' ), |
| | 78 | + array( 'archive', 'ar_len', 'patch-ar_len.sql' ), |
| 78 | 79 | array( 'revision', 'rev_parent_id', 'patch-rev_parent_id.sql' ), |
| 79 | 80 | ); |
| 80 | 81 | |
| Index: trunk/phase3/maintenance/mysql5/tables.sql |
| — | — | @@ -385,7 +385,9 @@ |
| 386 | 386 | |
| 387 | 387 | -- rev_deleted for archives |
| 388 | 388 | ar_deleted tinyint(1) unsigned NOT NULL default '0', |
| 389 | | - |
| | 389 | + -- Length of this revision in bytes |
| | 390 | + rev_len int(8) unsigned, |
| | 391 | + |
| 390 | 392 | KEY name_title_timestamp (ar_namespace,ar_title,ar_timestamp) |
| 391 | 393 | |
| 392 | 394 | ) ENGINE=InnoDB, DEFAULT CHARSET=utf8; |
| Index: trunk/phase3/maintenance/mysql5/tables-binary.sql |
| — | — | @@ -394,7 +394,9 @@ |
| 395 | 395 | |
| 396 | 396 | -- rev_deleted for archives |
| 397 | 397 | ar_deleted tinyint(1) unsigned NOT NULL default '0', |
| 398 | | - |
| | 398 | + -- Length of this revision in bytes |
| | 399 | + ar_len int(8) unsigned, |
| | 400 | + |
| 399 | 401 | KEY name_title_timestamp (ar_namespace,ar_title,ar_timestamp) |
| 400 | 402 | |
| 401 | 403 | ) ENGINE=InnoDB, DEFAULT CHARSET=binary; |
| Index: branches/phase3_rev_deleted/maintenance/tables.sql |
| — | — | @@ -257,6 +257,8 @@ |
| 258 | 258 | |
| 259 | 259 | -- Not yet used; reserved for future changes to the deletion system. |
| 260 | 260 | rev_deleted tinyint(1) unsigned NOT NULL default '0', |
| | 261 | + -- Length of this revision in bytes |
| | 262 | + rev_len int(8) unsigned, |
| 261 | 263 | |
| 262 | 264 | PRIMARY KEY rev_page_id (rev_page, rev_id), |
| 263 | 265 | UNIQUE INDEX rev_id (rev_id), |
| — | — | @@ -353,7 +355,10 @@ |
| 354 | 356 | |
| 355 | 357 | -- rev_deleted for archives |
| 356 | 358 | ar_deleted tinyint(1) unsigned NOT NULL default '0', |
| | 359 | + -- Length of this revision in bytes |
| | 360 | + ar_len int(8) unsigned, |
| 357 | 361 | |
| | 362 | + |
| 358 | 363 | KEY name_title_timestamp (ar_namespace,ar_title,ar_timestamp) |
| 359 | 364 | |
| 360 | 365 | ) TYPE=InnoDB; |