diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/characters_database.sql | 60 | ||||
| -rw-r--r-- | sql/updates/auth_char/2011_02_24_1_characters_character_tutorial.sql | 21 |
2 files changed, 51 insertions, 30 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 13678facdc2..9f7766dac4c 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -66,6 +66,36 @@ UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; -- +-- Table structure for table `account_tutorial` +-- + +DROP TABLE IF EXISTS `account_tutorial`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `account_tutorial` +-- + +LOCK TABLES `account_tutorial` WRITE; +/*!40000 ALTER TABLE `account_tutorial` DISABLE KEYS */; +/*!40000 ALTER TABLE `account_tutorial` ENABLE KEYS */; +UNLOCK TABLES; + +-- -- Table structure for table `addons` -- @@ -1086,36 +1116,6 @@ LOCK TABLES `character_talent` WRITE; UNLOCK TABLES; -- --- Table structure for table `character_tutorial` --- - -DROP TABLE IF EXISTS `character_tutorial`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `character_tutorial` ( - `account` int(10) unsigned NOT NULL AUTO_INCREMENT 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 (`account`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System'; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `character_tutorial` --- - -LOCK TABLES `character_tutorial` WRITE; -/*!40000 ALTER TABLE `character_tutorial` DISABLE KEYS */; -/*!40000 ALTER TABLE `character_tutorial` ENABLE KEYS */; -UNLOCK TABLES; - --- -- Table structure for table `characters` -- 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`; |