diff options
Diffstat (limited to 'sql_scripts/update_2009_02_26_001.sql')
-rw-r--r-- | sql_scripts/update_2009_02_26_001.sql | 19 |
1 files changed, 0 insertions, 19 deletions
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 a6af5931..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#%' |