From 8a8471dd96dbf06ec6bc47386af02c1845e8405f Mon Sep 17 00:00:00 2001 From: maximius Date: Fri, 14 Aug 2009 17:56:31 -0700 Subject: *Use less destructive method, in an attempt to preserve `character_action` --HG-- branch : trunk --- sql/updates/5036_character_updates_dual_spec.sql | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to 'sql') diff --git a/sql/updates/5036_character_updates_dual_spec.sql b/sql/updates/5036_character_updates_dual_spec.sql index fa1bd4a965b..9bd44573055 100644 --- a/sql/updates/5036_character_updates_dual_spec.sql +++ b/sql/updates/5036_character_updates_dual_spec.sql @@ -4,7 +4,7 @@ DELETE FROM `character_spell` WHERE `spell` IN (11083,12351,11094,13043,11095,12 ALTER TABLE `characters` ADD `speccount` tinyint(3) unsigned NOT NULL default 1 AFTER `arena_pending_points`; ALTER TABLE `characters` ADD `activespec` tinyint(3) unsigned NOT NULL default 0 AFTER `speccount`; -DROP TABLE IF EXISTS `character_action`; +ALTER TABLE `character_action` RENAME `character_action_old`; CREATE TABLE `character_action` ( `guid` int(11) unsigned NOT NULL default '0', `spec` tinyint(3) unsigned NOT NULL default '0', @@ -13,6 +13,8 @@ CREATE TABLE `character_action` ( `type` tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (`guid`,`spec`,`button`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; +INSERT INTO `character_action` (`guid`,`button`,`action`,`type`) SELECT `guid`,`button`,`action`,`type` FROM `character_action_old`; +DROP TABLE `character_action_old`; DROP TABLE IF EXISTS `character_glyphs`; CREATE TABLE `character_glyphs` ( -- cgit v1.2.3