diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/characters.sql | 24 | ||||
| -rw-r--r-- | sql/updates/5532_8433_characters_character_account_data.sql | 16 |
2 files changed, 39 insertions, 1 deletions
diff --git a/sql/characters.sql b/sql/characters.sql index b431c09e800..e56bc26cd08 100644 --- a/sql/characters.sql +++ b/sql/characters.sql @@ -23,7 +23,7 @@ DROP TABLE IF EXISTS `character_db_version`; CREATE TABLE `character_db_version` ( - `required_8409_01_characters_guild` bit(1) default NULL + `required_8433_01_characters_character_account_data` bit(1) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Last applied sql update to DB'; -- @@ -348,6 +348,28 @@ LOCK TABLES `characters` WRITE; UNLOCK TABLES; -- +-- Table structure for table `character_account_data` +-- + +DROP TABLE IF EXISTS `character_account_data`; +CREATE TABLE `character_account_data` ( + `guid` int(11) unsigned NOT NULL default '0', + `type` int(11) unsigned NOT NULL default '0', + `time` bigint(11) unsigned NOT NULL default '0', + `data` longtext NOT NULL, + PRIMARY KEY (`guid`,`type`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- +-- Dumping data for table `character_account_data` +-- + +LOCK TABLES `character_account_data` WRITE; +/*!40000 ALTER TABLE `character_account_data` DISABLE KEYS */; +/*!40000 ALTER TABLE `character_account_data` ENABLE KEYS */; +UNLOCK TABLES; + +-- -- Table structure for table `character_achievement` -- diff --git a/sql/updates/5532_8433_characters_character_account_data.sql b/sql/updates/5532_8433_characters_character_account_data.sql new file mode 100644 index 00000000000..a4569b76639 --- /dev/null +++ b/sql/updates/5532_8433_characters_character_account_data.sql @@ -0,0 +1,16 @@ +-- ALTER TABLE character_db_version CHANGE COLUMN required_8409_01_characters_guild required_8433_01_characters_character_account_data bit; + +DROP TABLE IF EXISTS `character_account_data`; +CREATE TABLE `character_account_data` ( + `guid` int(11) unsigned NOT NULL default '0', + `type` int(11) unsigned NOT NULL default '0', + `time` bigint(11) unsigned NOT NULL default '0', + `data` longtext NOT NULL, + PRIMARY KEY (`guid`,`type`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +INSERT INTO character_account_data +SELECT c.guid as guid, a.type as type, a.time as time, a.data as data +FROM characters c LEFT JOIN account_data a ON c.account = a.account WHERE a.type IN (1, 3, 5, 6, 7); + +DELETE FROM account_data WHERE type IN (1, 3, 5, 6, 7);
\ No newline at end of file |