diff options
| -rw-r--r-- | sql/updates/auth_char/2011_02_24_1_characters_character_tutorial.sql | 23 |
1 files changed, 2 insertions, 21 deletions
diff --git a/sql/updates/auth_char/2011_02_24_1_characters_character_tutorial.sql b/sql/updates/auth_char/2011_02_24_1_characters_character_tutorial.sql index 5c65282678d..b5e3594f5b0 100644 --- a/sql/updates/auth_char/2011_02_24_1_characters_character_tutorial.sql +++ b/sql/updates/auth_char/2011_02_24_1_characters_character_tutorial.sql @@ -1,21 +1,2 @@ --- --- Table structure for table `account_tutorial` --- -DROP TABLE IF EXISTS `account_tutorial`; -CREATE TABLE `account_tutorial` ( - `accountId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Account Identifier', - `tut0` int(10) unsigned NOT NULL DEFAULT '0', - `tut1` int(10) unsigned NOT NULL DEFAULT '0', - `tut2` int(10) unsigned NOT NULL DEFAULT '0', - `tut3` int(10) unsigned NOT NULL DEFAULT '0', - `tut4` int(10) unsigned NOT NULL DEFAULT '0', - `tut5` int(10) unsigned NOT NULL DEFAULT '0', - `tut6` int(10) unsigned NOT NULL DEFAULT '0', - `tut7` int(10) unsigned NOT NULL DEFAULT '0', - PRIMARY KEY (`accountId`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System'; - -INSERT INTO `account_tutorial`(`accountId`,`tut0`,`tut1`,`tut2`,`tut3`,`tut4`,`tut5`,`tut6`,`tut7`) -SELECT `account`,`tut0`,`tut1`,`tut2`,`tut3`,`tut4`,`tut5`,`tut6`,`tut7` FROM `character_tutorial`; - -DROP TABLE `character_tutorial`; +RENAME TABLE `character_tutorial` TO `account_tutorial`; +ALTER TABLE `account_tutorial` CHANGE COLUMN `account` `accountId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Account Identifier'; |