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; |