From bcd7e45e1227741a38001423d9a713e6614edd3f Mon Sep 17 00:00:00 2001 From: Azazel Date: Thu, 24 Feb 2011 23:57:43 +0600 Subject: CharDB Schema/Cleanup: cleanup character_tutorial table: * rename table to account_tutorial, because it holds account specific data; * rename column account to accountId; * introduce prepared statements for table. --- .../2011_02_24_1_characters_character_tutorial.sql | 21 +++++++++++++++++++++ 1 file changed, 21 insertions(+) create mode 100644 sql/updates/auth_char/2011_02_24_1_characters_character_tutorial.sql (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 new file mode 100644 index 00000000000..5c65282678d --- /dev/null +++ b/sql/updates/auth_char/2011_02_24_1_characters_character_tutorial.sql @@ -0,0 +1,21 @@ +-- +-- 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`; -- cgit v1.2.3