From 5b45e526c74faf55110ff0afdcba19797d7e0f4d Mon Sep 17 00:00:00 2001 From: Evgeny Fadeev Date: Fri, 10 Jul 2009 19:14:09 -0400 Subject: deleted all --- sql_scripts/update_2009_02_26_001.sql | 19 ------------------- 1 file changed, 19 deletions(-) delete mode 100644 sql_scripts/update_2009_02_26_001.sql (limited to 'sql_scripts/update_2009_02_26_001.sql') diff --git a/sql_scripts/update_2009_02_26_001.sql b/sql_scripts/update_2009_02_26_001.sql deleted file mode 100644 index 9cc80974..00000000 --- a/sql_scripts/update_2009_02_26_001.sql +++ /dev/null @@ -1,19 +0,0 @@ -ALTER TABLE answer ADD COLUMN `accepted_at` datetime default null; - -/* Update accepted_at column with answer added datetime for existing data */ -UPDATE answer -SET accepted_at = added_at -WHERE accepted = 1 AND accepted_at IS NULL; - -/* workround for c# url problem on bluehost server */ -UPDATE tag -SET name = 'csharp' -WHERE name = 'c#' - -UPDATE question -SET tagnames = replace(tagnames, 'c#', 'csharp') -WHERE tagnames like '%c#%' - -UPDATE question_revision -SET tagnames = replace(tagnames, 'c#', 'csharp') -WHERE tagnames like '%c#%' \ No newline at end of file -- cgit v1.2.3-1-g7c22