From 9662e23755f4fe0360b621098050ba3c45efb608 Mon Sep 17 00:00:00 2001 From: Erik Moeller Date: Mon, 11 Oct 2004 03:28:18 +0000 Subject: [PATCH] this seems to have sneaked into HEAD somehow, belongs in SCHEMA_WORK only --- .../patch-remove-old-title-namespace.sql | 16 ---------------- 1 file changed, 16 deletions(-) delete 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 deleted file mode 100644 index 8e1b9dbbee..0000000000 --- a/maintenance/archives/patch-remove-old-title-namespace.sql +++ /dev/null @@ -1,16 +0,0 @@ --- 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