SQL: Characters db storage type cleanup No. 2

1 files changed, 52 insertions, 52 deletions

diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index 9fb176d16d2..c1437dcb847 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -314,10 +314,10 @@ DROP TABLE IF EXISTS `character_action`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `character_action` (
-  `guid` int(11) unsigned NOT NULL DEFAULT '0',
+  `guid` int(10) unsigned NOT NULL DEFAULT '0',
   `spec` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `button` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `action` int(11) unsigned NOT NULL DEFAULT '0',
+  `action` int(10) unsigned NOT NULL DEFAULT '0',
   `type` tinyint(3) unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`guid`,`spec`,`button`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
@@ -341,7 +341,7 @@ DROP TABLE IF EXISTS `character_arena_stats`;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `character_arena_stats` (
   `guid` int(10) NOT NULL,
-  `slot` smallint(1) NOT NULL,
+  `slot` tinyint(3) NOT NULL,
   `personal_rating` int(10) NOT NULL,
   `matchmaker_rating` int(10) NOT NULL,
   PRIMARY KEY (`guid`,`slot`)
@@ -365,10 +365,10 @@ DROP TABLE IF EXISTS `character_aura`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `character_aura` (
-  `guid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
+  `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
   `caster_guid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Full Global Unique Identifier',
   `item_guid` bigint(20) unsigned NOT NULL DEFAULT '0',
-  `spell` int(11) unsigned NOT NULL DEFAULT '0',
+  `spell` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `effect_mask` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `recalculate_mask` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `stackcount` tinyint(3) unsigned NOT NULL DEFAULT '1',
@@ -402,12 +402,12 @@ DROP TABLE IF EXISTS `character_banned`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `character_banned` (
-  `guid` int(11) NOT NULL DEFAULT '0' COMMENT 'Account id',
-  `bandate` bigint(40) NOT NULL DEFAULT '0',
-  `unbandate` bigint(40) NOT NULL DEFAULT '0',
+  `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Account id',
+  `bandate` int(10) unsigned NOT NULL DEFAULT '0',
+  `unbandate` int(10) unsigned NOT NULL DEFAULT '0',
   `bannedby` varchar(50) NOT NULL,
   `banreason` varchar(255) NOT NULL,
-  `active` tinyint(4) NOT NULL DEFAULT '1',
+  `active` tinyint(3) unsigned NOT NULL DEFAULT '1',
   PRIMARY KEY (`guid`,`bandate`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Ban List';
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -429,17 +429,17 @@ DROP TABLE IF EXISTS `character_battleground_data`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `character_battleground_data` (
-  `guid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
-  `instance_id` int(11) unsigned NOT NULL DEFAULT '0',
-  `team` int(11) unsigned NOT NULL DEFAULT '0',
+  `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
+  `instance_id` int(10) unsigned NOT NULL,
+  `team` smallint(5) unsigned NOT NULL,
   `join_x` float NOT NULL DEFAULT '0',
   `join_y` float NOT NULL DEFAULT '0',
   `join_z` float NOT NULL DEFAULT '0',
   `join_o` float NOT NULL DEFAULT '0',
-  `join_map` int(11) NOT NULL DEFAULT '0',
-  `taxi_start` int(11) NOT NULL DEFAULT '0',
-  `taxi_end` int(11) NOT NULL DEFAULT '0',
-  `mount_spell` int(11) NOT NULL DEFAULT '0',
+  `join_map` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `taxi_start` int(10) unsigned NOT NULL DEFAULT '0',
+  `taxi_end` int(10) unsigned NOT NULL DEFAULT '0',
+  `mount_spell` mediumint(8) unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`guid`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -461,7 +461,7 @@ DROP TABLE IF EXISTS `character_battleground_random`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `character_battleground_random` (
-  `guid` int(11) unsigned NOT NULL DEFAULT '0',
+  `guid` int(10) unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`guid`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -483,7 +483,7 @@ DROP TABLE IF EXISTS `character_declinedname`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `character_declinedname` (
-  `guid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
+  `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
   `genitive` varchar(15) NOT NULL DEFAULT '',
   `dative` varchar(15) NOT NULL DEFAULT '',
   `accusative` varchar(15) NOT NULL DEFAULT '',
@@ -510,30 +510,30 @@ DROP TABLE IF EXISTS `character_equipmentsets`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `character_equipmentsets` (
-  `guid` int(11) NOT NULL DEFAULT '0',
+  `guid` int(10) NOT NULL DEFAULT '0',
   `setguid` bigint(20) NOT NULL AUTO_INCREMENT,
-  `setindex` tinyint(4) NOT NULL DEFAULT '0',
-  `name` varchar(100) NOT NULL,
+  `setindex` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `name` varchar(31) NOT NULL,
   `iconname` varchar(100) NOT NULL,
-  `item0` int(11) NOT NULL DEFAULT '0',
-  `item1` int(11) NOT NULL DEFAULT '0',
-  `item2` int(11) NOT NULL DEFAULT '0',
-  `item3` int(11) NOT NULL DEFAULT '0',
-  `item4` int(11) NOT NULL DEFAULT '0',
-  `item5` int(11) NOT NULL DEFAULT '0',
-  `item6` int(11) NOT NULL DEFAULT '0',
-  `item7` int(11) NOT NULL DEFAULT '0',
-  `item8` int(11) NOT NULL DEFAULT '0',
-  `item9` int(11) NOT NULL DEFAULT '0',
-  `item10` int(11) NOT NULL DEFAULT '0',
-  `item11` int(11) NOT NULL DEFAULT '0',
-  `item12` int(11) NOT NULL DEFAULT '0',
-  `item13` int(11) NOT NULL DEFAULT '0',
-  `item14` int(11) NOT NULL DEFAULT '0',
-  `item15` int(11) NOT NULL DEFAULT '0',
-  `item16` int(11) NOT NULL DEFAULT '0',
-  `item17` int(11) NOT NULL DEFAULT '0',
-  `item18` int(11) NOT NULL DEFAULT '0',
+  `item0` int(10) unsigned NOT NULL DEFAULT '0',
+  `item1` int(10) unsigned NOT NULL DEFAULT '0',
+  `item2` int(10) unsigned NOT NULL DEFAULT '0',
+  `item3` int(10) unsigned NOT NULL DEFAULT '0',
+  `item4` int(10) unsigned NOT NULL DEFAULT '0',
+  `item5` int(10) unsigned NOT NULL DEFAULT '0',
+  `item6` int(10) unsigned NOT NULL DEFAULT '0',
+  `item7` int(10) unsigned NOT NULL DEFAULT '0',
+  `item8` int(10) unsigned NOT NULL DEFAULT '0',
+  `item9` int(10) unsigned NOT NULL DEFAULT '0',
+  `item10` int(10) unsigned NOT NULL DEFAULT '0',
+  `item11` int(10) unsigned NOT NULL DEFAULT '0',
+  `item12` int(10) unsigned NOT NULL DEFAULT '0',
+  `item13` int(10) unsigned NOT NULL DEFAULT '0',
+  `item14` int(10) unsigned NOT NULL DEFAULT '0',
+  `item15` int(10) unsigned NOT NULL DEFAULT '0',
+  `item16` int(10) unsigned NOT NULL DEFAULT '0',
+  `item17` int(10) unsigned NOT NULL DEFAULT '0',
+  `item18` int(10) unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`setguid`),
   UNIQUE KEY `idx_set` (`guid`,`setguid`,`setindex`),
   KEY `Idx_setindex` (`setindex`)
@@ -557,10 +557,10 @@ DROP TABLE IF EXISTS `character_gifts`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `character_gifts` (
-  `guid` int(20) unsigned NOT NULL DEFAULT '0',
-  `item_guid` int(11) unsigned NOT NULL DEFAULT '0',
-  `entry` int(20) unsigned NOT NULL DEFAULT '0',
-  `flags` int(20) unsigned NOT NULL DEFAULT '0',
+  `guid` int(10) unsigned NOT NULL DEFAULT '0',
+  `item_guid` int(10) unsigned NOT NULL DEFAULT '0',
+  `entry` int(10) unsigned NOT NULL DEFAULT '0',
+  `flags` int(10) unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`item_guid`),
   KEY `idx_guid` (`guid`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
@@ -583,14 +583,14 @@ DROP TABLE IF EXISTS `character_glyphs`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `character_glyphs` (
-  `guid` int(11) unsigned NOT NULL,
+  `guid` int(10) unsigned NOT NULL,
   `spec` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `glyph1` int(11) unsigned NOT NULL DEFAULT '0',
-  `glyph2` int(11) unsigned DEFAULT '0',
-  `glyph3` int(11) unsigned DEFAULT '0',
-  `glyph4` int(11) unsigned DEFAULT '0',
-  `glyph5` int(11) unsigned DEFAULT '0',
-  `glyph6` int(11) unsigned DEFAULT '0',
+  `glyph1` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `glyph2` smallint(5) unsigned DEFAULT '0',
+  `glyph3` smallint(5) unsigned DEFAULT '0',
+  `glyph4` smallint(5) unsigned DEFAULT '0',
+  `glyph5` smallint(5) unsigned DEFAULT '0',
+  `glyph6` smallint(5) unsigned DEFAULT '0',
   PRIMARY KEY (`guid`,`spec`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -2198,4 +2198,4 @@ UNLOCK TABLES;
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2011-01-19  4:18:09
+-- Dump completed on 2011-01-19 16:00:01