diff options
Diffstat (limited to 'sql')
11 files changed, 134 insertions, 63 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index b350b7b27fa..f2658f8e805 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -916,15 +916,12 @@ DROP TABLE IF EXISTS `character_social`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `character_social` ( - `guid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier', - `friend` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Friend Global Unique Identifier', - `flags` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT 'Friend Flags', + `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier', + `friend` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Friend Global Unique Identifier', + `flags` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Friend Flags', `note` varchar(48) NOT NULL DEFAULT '' COMMENT 'Friend Note', PRIMARY KEY (`guid`,`friend`,`flags`), - KEY `guid` (`guid`), - KEY `friend` (`friend`), - KEY `guid_flags` (`guid`,`flags`), - KEY `friend_flags` (`friend`,`flags`) + KEY `friend` (`friend`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -945,8 +942,8 @@ DROP TABLE IF EXISTS `character_spell`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `character_spell` ( - `guid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', - `spell` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Spell Identifier', + `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', + `spell` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Spell Identifier', `active` tinyint(3) unsigned NOT NULL DEFAULT '1', `disabled` tinyint(3) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`spell`) @@ -970,10 +967,10 @@ DROP TABLE IF EXISTS `character_spell_cooldown`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `character_spell_cooldown` ( - `guid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier, Low part', - `spell` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Spell Identifier', - `item` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Item Identifier', - `time` bigint(20) unsigned NOT NULL DEFAULT '0', + `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier, Low part', + `spell` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Spell Identifier', + `item` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Item Identifier', + `time` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`spell`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; @@ -995,7 +992,7 @@ DROP TABLE IF EXISTS `character_stats`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `character_stats` ( - `guid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier, Low part', + `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier, Low part', `maxhealth` int(10) unsigned NOT NULL DEFAULT '0', `maxpower1` int(10) unsigned NOT NULL DEFAULT '0', `maxpower2` int(10) unsigned NOT NULL DEFAULT '0', @@ -1046,8 +1043,8 @@ DROP TABLE IF EXISTS `character_talent`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `character_talent` ( - `guid` int(11) unsigned NOT NULL, - `spell` int(11) unsigned NOT NULL, + `guid` int(10) unsigned NOT NULL, + `spell` mediumint(8) unsigned NOT NULL, `spec` tinyint(3) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`spell`,`spec`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; @@ -1070,18 +1067,16 @@ 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` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Account Identifier', - `realmid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Realm Identifier', - `tut0` int(11) unsigned NOT NULL DEFAULT '0', - `tut1` int(11) unsigned NOT NULL DEFAULT '0', - `tut2` int(11) unsigned NOT NULL DEFAULT '0', - `tut3` int(11) unsigned NOT NULL DEFAULT '0', - `tut4` int(11) unsigned NOT NULL DEFAULT '0', - `tut5` int(11) unsigned NOT NULL DEFAULT '0', - `tut6` int(11) unsigned NOT NULL DEFAULT '0', - `tut7` int(11) unsigned NOT NULL DEFAULT '0', - PRIMARY KEY (`account`,`realmid`), - KEY `acc_key` (`account`) + `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 */; @@ -1102,8 +1097,8 @@ DROP TABLE IF EXISTS `characters`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `characters` ( - `guid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', - `account` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Account Identifier', + `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', + `account` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Account Identifier', `name` varchar(12) NOT NULL DEFAULT '', `race` tinyint(3) unsigned NOT NULL DEFAULT '0', `class` tinyint(3) unsigned NOT NULL DEFAULT '0', @@ -1117,30 +1112,30 @@ CREATE TABLE `characters` ( `position_x` float NOT NULL DEFAULT '0', `position_y` float NOT NULL DEFAULT '0', `position_z` float NOT NULL DEFAULT '0', - `map` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier', - `instance_id` int(11) unsigned NOT NULL DEFAULT '0', - `instance_mode_mask` tinyint(2) unsigned NOT NULL DEFAULT '0', + `map` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier', + `instance_id` int(10) unsigned NOT NULL DEFAULT '0', + `instance_mode_mask` tinyint(3) unsigned NOT NULL DEFAULT '0', `orientation` float NOT NULL DEFAULT '0', - `taximask` longtext, + `taximask` text NOT NULL, `online` tinyint(3) unsigned NOT NULL DEFAULT '0', `cinematic` tinyint(3) unsigned NOT NULL DEFAULT '0', - `totaltime` int(11) unsigned NOT NULL DEFAULT '0', - `leveltime` int(11) unsigned NOT NULL DEFAULT '0', - `logout_time` bigint(20) unsigned NOT NULL DEFAULT '0', + `totaltime` int(10) unsigned NOT NULL DEFAULT '0', + `leveltime` int(10) unsigned NOT NULL DEFAULT '0', + `logout_time` int(10) unsigned NOT NULL DEFAULT '0', `is_logout_resting` tinyint(3) unsigned NOT NULL DEFAULT '0', `rest_bonus` float NOT NULL DEFAULT '0', - `resettalents_cost` int(11) unsigned NOT NULL DEFAULT '0', - `resettalents_time` bigint(20) unsigned NOT NULL DEFAULT '0', + `resettalents_cost` int(10) unsigned NOT NULL DEFAULT '0', + `resettalents_time` int(10) unsigned NOT NULL DEFAULT '0', `trans_x` float NOT NULL DEFAULT '0', `trans_y` float NOT NULL DEFAULT '0', `trans_z` float NOT NULL DEFAULT '0', `trans_o` float NOT NULL DEFAULT '0', - `transguid` bigint(20) unsigned NOT NULL DEFAULT '0', - `extra_flags` int(11) unsigned NOT NULL DEFAULT '0', - `stable_slots` tinyint(1) unsigned NOT NULL DEFAULT '0', - `at_login` int(11) unsigned NOT NULL DEFAULT '0', - `zone` int(11) unsigned NOT NULL DEFAULT '0', - `death_expire_time` bigint(20) unsigned NOT NULL DEFAULT '0', + `transguid` mediumint(8) unsigned NOT NULL DEFAULT '0', + `extra_flags` smallint(5) unsigned NOT NULL DEFAULT '0', + `stable_slots` tinyint(3) unsigned NOT NULL DEFAULT '0', + `at_login` smallint(5) unsigned NOT NULL DEFAULT '0', + `zone` smallint(5) unsigned NOT NULL DEFAULT '0', + `death_expire_time` int(10) unsigned NOT NULL DEFAULT '0', `taxi_path` text, `arenaPoints` int(10) unsigned NOT NULL DEFAULT '0', `totalHonorPoints` int(10) unsigned NOT NULL DEFAULT '0', @@ -1151,7 +1146,7 @@ CREATE TABLE `characters` ( `yesterdayKills` smallint(5) unsigned NOT NULL DEFAULT '0', `chosenTitle` int(10) unsigned NOT NULL DEFAULT '0', `knownCurrencies` bigint(20) unsigned NOT NULL DEFAULT '0', - `watchedFaction` bigint(10) unsigned NOT NULL DEFAULT '0', + `watchedFaction` int(10) unsigned NOT NULL DEFAULT '0', `drunk` smallint(5) unsigned NOT NULL DEFAULT '0', `health` int(10) unsigned NOT NULL DEFAULT '0', `power1` int(10) unsigned NOT NULL DEFAULT '0', @@ -1161,7 +1156,7 @@ CREATE TABLE `characters` ( `power5` int(10) unsigned NOT NULL DEFAULT '0', `power6` int(10) unsigned NOT NULL DEFAULT '0', `power7` int(10) unsigned NOT NULL DEFAULT '0', - `latency` int(11) unsigned NOT NULL DEFAULT '0', + `latency` mediumint(8) unsigned NOT NULL DEFAULT '0', `speccount` tinyint(3) unsigned NOT NULL DEFAULT '1', `activespec` tinyint(3) unsigned NOT NULL DEFAULT '0', `exploredZones` longtext, @@ -1169,9 +1164,9 @@ CREATE TABLE `characters` ( `ammoId` int(10) unsigned NOT NULL DEFAULT '0', `knownTitles` longtext, `actionBars` tinyint(3) unsigned NOT NULL DEFAULT '0', - `deleteInfos_Account` int(11) unsigned DEFAULT NULL, + `deleteInfos_Account` int(10) unsigned DEFAULT NULL, `deleteInfos_Name` varchar(12) DEFAULT NULL, - `deleteDate` bigint(20) DEFAULT NULL, + `deleteDate` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`guid`), KEY `idx_account` (`account`), KEY `idx_online` (`online`), @@ -1196,25 +1191,24 @@ DROP TABLE IF EXISTS `corpse`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `corpse` ( - `guid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', - `player` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier', + `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', + `player` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier', `position_x` float NOT NULL DEFAULT '0', `position_y` float NOT NULL DEFAULT '0', `position_z` float NOT NULL DEFAULT '0', `orientation` float NOT NULL DEFAULT '0', - `zone` int(11) unsigned NOT NULL DEFAULT '38' COMMENT 'Zone Identifier', - `map` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier', - `phaseMask` smallint(5) unsigned NOT NULL DEFAULT '1', + `map` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier', + `phaseMask` tinyint(3) unsigned NOT NULL DEFAULT '1', `displayId` int(10) unsigned NOT NULL DEFAULT '0', `itemCache` text NOT NULL, `bytes1` int(10) unsigned NOT NULL DEFAULT '0', `bytes2` int(10) unsigned NOT NULL DEFAULT '0', `guild` int(10) unsigned NOT NULL DEFAULT '0', - `flags` int(10) unsigned NOT NULL DEFAULT '0', - `dynFlags` int(10) unsigned NOT NULL DEFAULT '0', - `time` bigint(20) unsigned NOT NULL DEFAULT '0', + `flags` tinyint(3) unsigned NOT NULL DEFAULT '0', + `dynFlags` tinyint(3) unsigned NOT NULL DEFAULT '0', + `time` int(10) unsigned NOT NULL DEFAULT '0', `corpse_type` tinyint(3) unsigned NOT NULL DEFAULT '0', - `instance` int(11) unsigned NOT NULL DEFAULT '0', + `instance` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`), KEY `idx_type` (`corpse_type`), KEY `instance` (`instance`), @@ -1241,8 +1235,8 @@ DROP TABLE IF EXISTS `creature_respawn`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `creature_respawn` ( `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', - `respawntime` bigint(20) unsigned NOT NULL DEFAULT '0', - `instance` mediumint(8) unsigned NOT NULL DEFAULT '0', + `respawntime` int(10) unsigned NOT NULL DEFAULT '0', + `instance` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`instance`), KEY `instance` (`instance`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Grid Loading System'; @@ -1265,8 +1259,8 @@ DROP TABLE IF EXISTS `game_event_condition_save`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `game_event_condition_save` ( - `event_id` mediumint(8) unsigned NOT NULL, - `condition_id` mediumint(8) unsigned NOT NULL DEFAULT '0', + `event_id` smallint(5) unsigned NOT NULL, + `condition_id` int(10) unsigned NOT NULL DEFAULT '0', `done` float DEFAULT '0', PRIMARY KEY (`event_id`,`condition_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; @@ -2198,4 +2192,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2011-01-19 20:29:23 +-- Dump completed on 2011-01-19 22:45:57 diff --git a/sql/updates/2011_01_19_0_characters_character_social.sql b/sql/updates/2011_01_19_0_characters_character_social.sql new file mode 100644 index 00000000000..54a605b0de7 --- /dev/null +++ b/sql/updates/2011_01_19_0_characters_character_social.sql @@ -0,0 +1,8 @@ +ALTER TABLE `character_social` +ROW_FORMAT=DEFAULT, +CHANGE `guid` `guid` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Character Global Unique Identifier', +CHANGE `friend` `friend` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Friend Global Unique Identifier', +CHANGE `flags` `flags` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Friend Flags', +DROP INDEX `guid`, +DROP INDEX `guid_flags`, +DROP INDEX `friend_flags`;
\ No newline at end of file diff --git a/sql/updates/2011_01_19_0_characters_character_spell.sql b/sql/updates/2011_01_19_0_characters_character_spell.sql new file mode 100644 index 00000000000..cbc8b45c677 --- /dev/null +++ b/sql/updates/2011_01_19_0_characters_character_spell.sql @@ -0,0 +1,4 @@ +ALTER TABLE `character_spell` +ROW_FORMAT=DEFAULT, +CHANGE `guid` `guid` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Global Unique Identifier', +CHANGE `spell` `spell` MEDIUMINT(8) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Spell Identifier';
\ No newline at end of file diff --git a/sql/updates/2011_01_19_0_characters_character_spell_cooldown.sql b/sql/updates/2011_01_19_0_characters_character_spell_cooldown.sql new file mode 100644 index 00000000000..f4558168bcb --- /dev/null +++ b/sql/updates/2011_01_19_0_characters_character_spell_cooldown.sql @@ -0,0 +1,5 @@ +ALTER TABLE `character_spell_cooldown` +CHANGE `guid` `guid` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Global Unique Identifier, Low part', +CHANGE `spell` `spell` MEDIUMINT(8) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Spell Identifier', +CHANGE `item` `item` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Item Identifier', +CHANGE `time` `time` INT(10) UNSIGNED DEFAULT '0' NOT NULL;
\ No newline at end of file diff --git a/sql/updates/2011_01_19_0_characters_character_stats.sql b/sql/updates/2011_01_19_0_characters_character_stats.sql new file mode 100644 index 00000000000..5cf885950c3 --- /dev/null +++ b/sql/updates/2011_01_19_0_characters_character_stats.sql @@ -0,0 +1,2 @@ +ALTER TABLE `character_stats` +CHANGE `guid` `guid` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Global Unique Identifier, Low part';
\ No newline at end of file diff --git a/sql/updates/2011_01_19_0_characters_character_talent.sql b/sql/updates/2011_01_19_0_characters_character_talent.sql new file mode 100644 index 00000000000..47c7bd1ade0 --- /dev/null +++ b/sql/updates/2011_01_19_0_characters_character_talent.sql @@ -0,0 +1,3 @@ +ALTER TABLE `character_talent` +CHANGE `guid` `guid` INT(10) UNSIGNED NOT NULL, +CHANGE `spell` `spell` MEDIUMINT(8) UNSIGNED NOT NULL;
\ No newline at end of file diff --git a/sql/updates/2011_01_19_0_characters_character_tutorial.sql b/sql/updates/2011_01_19_0_characters_character_tutorial.sql new file mode 100644 index 00000000000..17e54576050 --- /dev/null +++ b/sql/updates/2011_01_19_0_characters_character_tutorial.sql @@ -0,0 +1,15 @@ +ALTER TABLE `character_tutorial` +ROW_FORMAT=DEFAULT, +CHANGE `account` `account` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Account Identifier', +DROP PRIMARY KEY, +ADD PRIMARY KEY (`account`), +DROP `realmid`, +CHANGE `tut0` `tut0` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `tut1` `tut1` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `tut2` `tut2` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `tut3` `tut3` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `tut4` `tut4` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `tut5` `tut5` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `tut6` `tut6` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `tut7` `tut7` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +DROP KEY `acc_key`;
\ No newline at end of file diff --git a/sql/updates/2011_01_19_0_characters_characters.sql b/sql/updates/2011_01_19_0_characters_characters.sql new file mode 100644 index 00000000000..08cf4c0d630 --- /dev/null +++ b/sql/updates/2011_01_19_0_characters_characters.sql @@ -0,0 +1,23 @@ +ALTER TABLE `characters` +ROW_FORMAT=DEFAULT, +CHANGE `guid` `guid` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Global Unique Identifier', +CHANGE `account` `account` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Account Identifier', +CHANGE `map` `map` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Map Identifier', +CHANGE `instance_id` `instance_id` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `instance_mode_mask` `instance_mode_mask` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `taximask` `taximask` TEXT NOT NULL, +CHANGE `totaltime` `totaltime` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `leveltime` `leveltime` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `logout_time` `logout_time` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `resettalents_cost` `resettalents_cost` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `resettalents_time` `resettalents_time` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `transguid` `transguid` MEDIUMINT(8) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `extra_flags` `extra_flags` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `stable_slots` `stable_slots` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `at_login` `at_login` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `zone` `zone` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `death_expire_time` `death_expire_time` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `watchedFaction` `watchedFaction` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `latency` `latency` MEDIUMINT(8) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `deleteInfos_Account` `deleteInfos_Account` INT(10) UNSIGNED NULL , +CHANGE `deleteDate` `deleteDate` INT(10) UNSIGNED NULL ;
\ No newline at end of file diff --git a/sql/updates/2011_01_19_0_characters_corpse.sql b/sql/updates/2011_01_19_0_characters_corpse.sql new file mode 100644 index 00000000000..9902583b5cb --- /dev/null +++ b/sql/updates/2011_01_19_0_characters_corpse.sql @@ -0,0 +1,11 @@ +ALTER TABLE `corpse` +ROW_FORMAT=DEFAULT, +CHANGE `guid` `guid` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Global Unique Identifier', +CHANGE `player` `player` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Character Global Unique Identifier', +DROP COLUMN `zone`, +CHANGE `map` `map` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Map Identifier', +CHANGE `phaseMask` `phaseMask` TINYINT(3) UNSIGNED DEFAULT '1' NOT NULL, +CHANGE `flags` `flags` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `dynFlags` `dynFlags` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `time` `time` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `instance` `instance` INT(10) UNSIGNED DEFAULT '0' NOT NULL;
\ No newline at end of file diff --git a/sql/updates/2011_01_19_0_characters_creature_respawn.sql b/sql/updates/2011_01_19_0_characters_creature_respawn.sql new file mode 100644 index 00000000000..eb476844361 --- /dev/null +++ b/sql/updates/2011_01_19_0_characters_creature_respawn.sql @@ -0,0 +1,3 @@ +ALTER TABLE `creature_respawn` +CHANGE `respawntime` `respawntime` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `instance` `instance` INT(10) UNSIGNED DEFAULT '0' NOT NULL;
\ No newline at end of file diff --git a/sql/updates/2011_01_19_0_characters_game_event_condition_save.sql b/sql/updates/2011_01_19_0_characters_game_event_condition_save.sql new file mode 100644 index 00000000000..06dec4e9ead --- /dev/null +++ b/sql/updates/2011_01_19_0_characters_game_event_condition_save.sql @@ -0,0 +1,3 @@ +ALTER TABLE `game_event_condition_save` +CHANGE `event_id` `event_id` SMALLINT(5) UNSIGNED NOT NULL, +CHANGE `condition_id` `condition_id` INT(10) UNSIGNED DEFAULT '0' NOT NULL;
\ No newline at end of file |