2 -- patch-archive-drop-ar_user.sql
4 -- T188327. Drop old xx_user and xx_user_text fields, and defaults from xx_actor fields.
8 DROP TABLE IF EXISTS /*_*/archive_tmp
;
9 CREATE TABLE /*_*/archive_tmp (
10 ar_id
int unsigned
NOT NULL PRIMARY KEY AUTO_INCREMENT
,
11 ar_namespace
int NOT NULL default 0,
12 ar_title
varchar(255) binary NOT NULL default '',
13 ar_comment_id
bigint unsigned
NOT NULL,
14 ar_actor
bigint unsigned
NOT NULL,
15 ar_timestamp
binary(14) NOT NULL default '',
16 ar_minor_edit tinyint
NOT NULL default 0,
17 ar_rev_id
int unsigned
NOT NULL,
18 ar_text_id
int unsigned
NOT NULL DEFAULT 0,
19 ar_deleted tinyint unsigned
NOT NULL default 0,
21 ar_page_id
int unsigned
,
22 ar_parent_id
int unsigned
default NULL,
23 ar_sha1
varbinary(32) NOT NULL default '',
24 ar_content_model
varbinary(32) DEFAULT NULL,
25 ar_content_format
varbinary(64) DEFAULT NULL
26 ) /*$wgDBTableOptions*/;
28 INSERT OR IGNORE INTO /*_*/archive_tmp (
29 ar_id
, ar_namespace
, ar_title
, ar_comment_id
, ar_actor
,
30 ar_timestamp
, ar_minor_edit
, ar_rev_id
, ar_text_id
, ar_deleted
,
31 ar_len
, ar_page_id
, ar_parent_id
, ar_sha1
, ar_content_model
, ar_content_format
33 ar_id
, ar_namespace
, ar_title
, ar_comment_id
, ar_actor
,
34 ar_timestamp
, ar_minor_edit
, ar_rev_id
, ar_text_id
, ar_deleted
,
35 ar_len
, ar_page_id
, ar_parent_id
, ar_sha1
, ar_content_model
, ar_content_format
38 DROP TABLE /*_*/archive
;
39 ALTER TABLE /*_*/archive_tmp
RENAME TO /*_*/archive
;
40 CREATE INDEX /*i*/name_title_timestamp
ON /*_*/archive (ar_namespace
,ar_title
,ar_timestamp
);
41 CREATE INDEX /*i*/ar_actor_timestamp
ON /*_*/archive (ar_actor
,ar_timestamp
);
42 CREATE UNIQUE INDEX /*i*/ar_revid_uniq
ON /*_*/archive (ar_rev_id
);