From db17f97f9e76d71bcdf92a13c9716abba175392f Mon Sep 17 00:00:00 2001 From: River Tarnell Date: Sun, 26 Sep 2004 14:43:50 +0000 Subject: [PATCH] include sql patch --- .../patch-remove-old-title-namespace.sql | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) create mode 100644 maintenance/archives/patch-remove-old-title-namespace.sql diff --git a/maintenance/archives/patch-remove-old-title-namespace.sql b/maintenance/archives/patch-remove-old-title-namespace.sql new file mode 100644 index 0000000000..8e1b9dbbee --- /dev/null +++ b/maintenance/archives/patch-remove-old-title-namespace.sql @@ -0,0 +1,16 @@ +-- remove old_title and old_namespace, replace with old_articleid + +ALTER TABLE old + DROP COLUMN old_title, + DROP COLUMN old_namespace, + ADD COLUMN old_articleid INT(8) UNSIGNED NOT NULL; + +UPDATE old,cur + SET old_articleid=cur_id + WHERE old_title=cur_title + AND old_namespace=cur_namespace; + +DROP INDEX name_title_timestamp ON old; +DROP INDEX name_title ON old; +CREATE INDEX articleid_timestamp ON old (old_articleid, old_timestamp); +CREATE INDEX articleid ON old (old_articleid); -- 2.20.1