2 -- Adds a default value to the rev_text_id field in the revision table.
3 -- This is to allow the Multi Content Revisions migration to happen where
4 -- rows will have to be added to the revision table with no rev_text_id.
11 DROP TABLE IF EXISTS /*_*/revision_tmp
;
13 CREATE TABLE /*_*/revision_tmp (
14 rev_id
int unsigned
NOT NULL PRIMARY KEY AUTO_INCREMENT
,
15 rev_page
int unsigned
NOT NULL,
16 rev_text_id
int unsigned
NOT NULL default 0,
17 rev_comment
varbinary(767) NOT NULL default '',
18 rev_user
int unsigned
NOT NULL default 0,
19 rev_user_text
varchar(255) binary NOT NULL default '',
20 rev_timestamp
binary(14) NOT NULL default '',
21 rev_minor_edit tinyint unsigned
NOT NULL default 0,
22 rev_deleted tinyint unsigned
NOT NULL default 0,
24 rev_parent_id
int unsigned
default NULL,
25 rev_sha1
varbinary(32) NOT NULL default '',
26 rev_content_model
varbinary(32) DEFAULT NULL,
27 rev_content_format
varbinary(64) DEFAULT NULL
29 ) /*$wgDBTableOptions*/ MAX_ROWS
=10000000 AVG_ROW_LENGTH
=1024;
31 INSERT OR IGNORE INTO /*_*/revision_tmp (
32 rev_id
, rev_page
, rev_text_id
, rev_comment
, rev_user
, rev_user_text
,
33 rev_timestamp
, rev_minor_edit
, rev_deleted
, rev_len
, rev_parent_id
,
34 rev_sha1
, rev_content_model
, rev_content_format
37 rev_id
, rev_page
, rev_text_id
, rev_comment
, rev_user
, rev_user_text
,
38 rev_timestamp
, rev_minor_edit
, rev_deleted
, rev_len
, rev_parent_id
,
39 rev_sha1
, rev_content_model
, rev_content_format
42 DROP TABLE /*_*/revision
;
44 ALTER TABLE /*_*/revision_tmp
RENAME TO /*_*/revision
;
46 CREATE INDEX /*i*/rev_page_id
ON /*_*/revision (rev_page
, rev_id
);
47 CREATE INDEX /*i*/rev_timestamp
ON /*_*/revision (rev_timestamp
);
48 CREATE INDEX /*i*/page_timestamp
ON /*_*/revision (rev_page
,rev_timestamp
);
49 CREATE INDEX /*i*/user_timestamp
ON /*_*/revision (rev_user
,rev_timestamp
);
50 CREATE INDEX /*i*/usertext_timestamp
ON /*_*/revision (rev_user_text
,rev_timestamp
);
51 CREATE INDEX /*i*/page_user_timestamp
ON /*_*/revision (rev_page
,rev_user
,rev_timestamp
);