From 154b11461543d89429f313dc9725d98112448bc1 Mon Sep 17 00:00:00 2001 From: Azazel Date: Fri, 25 Feb 2011 15:03:36 +0600 Subject: Core/SQL: change script from bcd7e45e1227741a3800 commit to make it more simple and safe in case of multiple executions. --- .../2011_02_24_1_characters_character_tutorial.sql | 23 ++-------------------- 1 file changed, 2 insertions(+), 21 deletions(-) (limited to 'sql/updates') 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'; -- cgit v1.2.3