1 -- remove old_title and old_namespace, replace with old_articleid
5 DROP COLUMN old_namespace,
6 ADD COLUMN old_articleid INT(8) UNSIGNED NOT NULL;
9 SET old_articleid=cur_id
10 WHERE old_title=cur_title
11 AND old_namespace=cur_namespace;
13 DROP INDEX name_title_timestamp ON old;
14 DROP INDEX name_title ON old;
15 CREATE INDEX articleid_timestamp ON old (old_articleid, old_timestamp);
16 CREATE INDEX articleid ON old (old_articleid);