Core/SQL: change script from bcd7e45e1227741a3800 commit to make it more simple and safe in case of multiple executions.

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';