SQL: Characters db storage type cleanup No. 3 - Note:

There is a chance that you will be getting importing errors / data truncation warnings because of ancient invalid pet names.
SELECT * FROM character_pet WHERE CHAR_LENGTH(`name`) > 21;

11 files changed, 128 insertions, 55 deletions

diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index c1437dcb847..b350b7b27fa 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -612,9 +612,9 @@ DROP TABLE IF EXISTS `character_homebind`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `character_homebind` (
-  `guid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
-  `map` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier',
-  `zone` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Zone Identifier',
+  `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
+  `map` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier',
+  `zone` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Zone Identifier',
   `position_x` float NOT NULL DEFAULT '0',
   `position_y` float NOT NULL DEFAULT '0',
   `position_z` float NOT NULL DEFAULT '0',
@@ -639,9 +639,9 @@ DROP TABLE IF EXISTS `character_instance`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `character_instance` (
-  `guid` int(11) unsigned NOT NULL DEFAULT '0',
-  `instance` int(11) unsigned NOT NULL DEFAULT '0',
-  `permanent` tinyint(1) unsigned NOT NULL DEFAULT '0',
+  `guid` int(10) unsigned NOT NULL DEFAULT '0',
+  `instance` int(10) unsigned NOT NULL DEFAULT '0',
+  `permanent` tinyint(3) unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`guid`,`instance`),
   KEY `instance` (`instance`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
@@ -664,10 +664,10 @@ DROP TABLE IF EXISTS `character_inventory`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `character_inventory` (
-  `guid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
-  `bag` int(11) unsigned NOT NULL DEFAULT '0',
+  `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
+  `bag` int(10) unsigned NOT NULL DEFAULT '0',
   `slot` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `item` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Item Global Unique Identifier',
+  `item` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Item Global Unique Identifier',
   PRIMARY KEY (`item`),
   KEY `idx_guid` (`guid`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
@@ -690,25 +690,25 @@ DROP TABLE IF EXISTS `character_pet`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `character_pet` (
-  `id` int(11) unsigned NOT NULL DEFAULT '0',
-  `entry` int(11) unsigned NOT NULL DEFAULT '0',
-  `owner` int(11) unsigned NOT NULL DEFAULT '0',
-  `modelid` int(11) unsigned DEFAULT '0',
-  `CreatedBySpell` int(11) unsigned NOT NULL DEFAULT '0',
+  `id` int(10) unsigned NOT NULL DEFAULT '0',
+  `entry` int(10) unsigned NOT NULL DEFAULT '0',
+  `owner` int(10) unsigned NOT NULL DEFAULT '0',
+  `modelid` int(10) unsigned DEFAULT '0',
+  `CreatedBySpell` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `PetType` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `level` int(11) unsigned NOT NULL DEFAULT '1',
-  `exp` int(11) unsigned NOT NULL DEFAULT '0',
-  `Reactstate` tinyint(1) unsigned NOT NULL DEFAULT '0',
-  `name` varchar(100) DEFAULT 'Pet',
-  `renamed` tinyint(1) unsigned NOT NULL DEFAULT '0',
-  `slot` int(11) unsigned NOT NULL DEFAULT '0',
-  `curhealth` int(11) unsigned NOT NULL DEFAULT '1',
-  `curmana` int(11) unsigned NOT NULL DEFAULT '0',
-  `curhappiness` int(11) unsigned NOT NULL DEFAULT '0',
-  `savetime` bigint(20) unsigned NOT NULL DEFAULT '0',
-  `resettalents_cost` int(11) unsigned NOT NULL DEFAULT '0',
-  `resettalents_time` bigint(20) unsigned NOT NULL DEFAULT '0',
-  `abdata` longtext,
+  `level` smallint(5) unsigned NOT NULL DEFAULT '1',
+  `exp` int(10) unsigned NOT NULL DEFAULT '0',
+  `Reactstate` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `name` varchar(21) NOT NULL DEFAULT 'Pet',
+  `renamed` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `slot` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `curhealth` int(10) unsigned NOT NULL DEFAULT '1',
+  `curmana` int(10) unsigned NOT NULL DEFAULT '0',
+  `curhappiness` int(10) unsigned NOT NULL DEFAULT '0',
+  `savetime` int(10) unsigned NOT NULL DEFAULT '0',
+  `resettalents_cost` int(10) unsigned NOT NULL DEFAULT '0',
+  `resettalents_time` int(10) unsigned NOT NULL DEFAULT '0',
+  `abdata` text,
   PRIMARY KEY (`id`),
   KEY `owner` (`owner`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Pet System';
@@ -731,8 +731,8 @@ DROP TABLE IF EXISTS `character_pet_declinedname`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `character_pet_declinedname` (
-  `id` int(11) unsigned NOT NULL DEFAULT '0',
-  `owner` int(11) unsigned NOT NULL DEFAULT '0',
+  `id` int(10) unsigned NOT NULL DEFAULT '0',
+  `owner` int(10) unsigned NOT NULL DEFAULT '0',
   `genitive` varchar(12) NOT NULL DEFAULT '',
   `dative` varchar(12) NOT NULL DEFAULT '',
   `accusative` varchar(12) NOT NULL DEFAULT '',
@@ -760,19 +760,19 @@ DROP TABLE IF EXISTS `character_queststatus`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `character_queststatus` (
-  `guid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
-  `quest` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier',
-  `status` tinyint(1) unsigned NOT NULL DEFAULT '0',
-  `explored` tinyint(1) unsigned NOT NULL DEFAULT '0',
-  `timer` bigint(20) unsigned NOT NULL DEFAULT '0',
-  `mobcount1` smallint(3) unsigned NOT NULL DEFAULT '0',
-  `mobcount2` smallint(3) unsigned NOT NULL DEFAULT '0',
-  `mobcount3` smallint(3) unsigned NOT NULL DEFAULT '0',
-  `mobcount4` smallint(3) unsigned NOT NULL DEFAULT '0',
-  `itemcount1` smallint(3) unsigned NOT NULL DEFAULT '0',
-  `itemcount2` smallint(3) unsigned NOT NULL DEFAULT '0',
-  `itemcount3` smallint(3) unsigned NOT NULL DEFAULT '0',
-  `itemcount4` smallint(3) unsigned NOT NULL DEFAULT '0',
+  `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
+  `quest` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier',
+  `status` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `explored` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `timer` int(10) unsigned NOT NULL DEFAULT '0',
+  `mobcount1` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `mobcount2` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `mobcount3` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `mobcount4` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `itemcount1` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `itemcount2` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `itemcount3` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `itemcount4` smallint(5) unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`guid`,`quest`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -794,9 +794,9 @@ DROP TABLE IF EXISTS `character_queststatus_daily`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `character_queststatus_daily` (
-  `guid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
-  `quest` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier',
-  `time` bigint(20) unsigned NOT NULL DEFAULT '0',
+  `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
+  `quest` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier',
+  `time` int(10) unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`guid`,`quest`),
   KEY `idx_guid` (`guid`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
@@ -842,8 +842,8 @@ DROP TABLE IF EXISTS `character_queststatus_weekly`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `character_queststatus_weekly` (
-  `guid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
-  `quest` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier',
+  `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
+  `quest` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier',
   PRIMARY KEY (`guid`,`quest`),
   KEY `idx_guid` (`guid`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
@@ -866,10 +866,10 @@ DROP TABLE IF EXISTS `character_reputation`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `character_reputation` (
-  `guid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
-  `faction` int(11) unsigned NOT NULL DEFAULT '0',
+  `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
+  `faction` smallint(5) unsigned NOT NULL DEFAULT '0',
   `standing` int(11) NOT NULL DEFAULT '0',
-  `flags` int(11) NOT NULL DEFAULT '0',
+  `flags` smallint(5) unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`guid`,`faction`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -891,10 +891,10 @@ DROP TABLE IF EXISTS `character_skills`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `character_skills` (
-  `guid` int(11) unsigned NOT NULL COMMENT 'Global Unique Identifier',
-  `skill` mediumint(9) unsigned NOT NULL,
-  `value` mediumint(9) unsigned NOT NULL,
-  `max` mediumint(9) unsigned NOT NULL,
+  `guid` int(10) unsigned NOT NULL COMMENT 'Global Unique Identifier',
+  `skill` smallint(5) unsigned NOT NULL,
+  `value` smallint(5) unsigned NOT NULL,
+  `max` smallint(5) unsigned NOT NULL,
   PRIMARY KEY (`guid`,`skill`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
 /*!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 16:00:01
+-- Dump completed on 2011-01-19 20:29:23
diff --git a/sql/updates/2011_01_19_0_characters_character_homebind.sql b/sql/updates/2011_01_19_0_characters_character_homebind.sql
new file mode 100644
index 00000000000..49c450011fc
--- /dev/null
+++ b/sql/updates/2011_01_19_0_characters_character_homebind.sql
@@ -0,0 +1,5 @@
+ALTER TABLE `character_homebind`
+ROW_FORMAT=DEFAULT,
+CHANGE `guid` `guid` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Global Unique Identifier',
+CHANGE `map` `map` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Map Identifier',
+CHANGE `zone` `zone` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Zone Identifier';
\ No newline at end of file
diff --git a/sql/updates/2011_01_19_0_characters_character_instance.sql b/sql/updates/2011_01_19_0_characters_character_instance.sql
new file mode 100644
index 00000000000..aba0047f7e1
--- /dev/null
+++ b/sql/updates/2011_01_19_0_characters_character_instance.sql
@@ -0,0 +1,4 @@
+ALTER TABLE `character_instance`
+CHANGE `guid` `guid` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
+CHANGE `instance` `instance` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
+CHANGE `permanent` `permanent` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL;
\ No newline at end of file
diff --git a/sql/updates/2011_01_19_0_characters_character_inventory.sql b/sql/updates/2011_01_19_0_characters_character_inventory.sql
new file mode 100644
index 00000000000..aca08d1ec38
--- /dev/null
+++ b/sql/updates/2011_01_19_0_characters_character_inventory.sql
@@ -0,0 +1,5 @@
+ALTER TABLE `character_inventory`
+ROW_FORMAT=DEFAULT,
+CHANGE `guid` `guid` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Global Unique Identifier',
+CHANGE `bag` `bag` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
+CHANGE `item` `item` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Item Global Unique Identifier';
\ No newline at end of file
diff --git a/sql/updates/2011_01_19_0_characters_character_pet.sql b/sql/updates/2011_01_19_0_characters_character_pet.sql
new file mode 100644
index 00000000000..51a4c7e0260
--- /dev/null
+++ b/sql/updates/2011_01_19_0_characters_character_pet.sql
@@ -0,0 +1,20 @@
+ALTER TABLE `character_pet`
+ROW_FORMAT=DEFAULT,
+CHANGE `id` `id` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
+CHANGE `entry` `entry` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
+CHANGE `owner` `owner` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
+CHANGE `modelid` `modelid` INT(10) UNSIGNED DEFAULT '0' NULL ,
+CHANGE `CreatedBySpell` `CreatedBySpell` MEDIUMINT(8) UNSIGNED DEFAULT '0' NOT NULL,
+CHANGE `level` `level` SMALLINT(5) UNSIGNED DEFAULT '1' NOT NULL,
+CHANGE `exp` `exp` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
+CHANGE `Reactstate` `Reactstate` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL,
+CHANGE `name` `name` VARCHAR(21) DEFAULT 'Pet' NOT NULL,
+CHANGE `renamed` `renamed` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL,
+CHANGE `slot` `slot` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL,
+CHANGE `curhealth` `curhealth` INT(10) UNSIGNED DEFAULT '1' NOT NULL,
+CHANGE `curmana` `curmana` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
+CHANGE `curhappiness` `curhappiness` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
+CHANGE `savetime` `savetime` 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 `abdata` `abdata` TEXT NULL;
\ No newline at end of file
diff --git a/sql/updates/2011_01_19_0_characters_character_pet_declinedname.sql b/sql/updates/2011_01_19_0_characters_character_pet_declinedname.sql
new file mode 100644
index 00000000000..f0adc06c763
--- /dev/null
+++ b/sql/updates/2011_01_19_0_characters_character_pet_declinedname.sql
@@ -0,0 +1,4 @@
+ALTER TABLE `character_pet_declinedname`
+ROW_FORMAT=DEFAULT,
+CHANGE `id` `id` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
+CHANGE `owner` `owner` INT(10) UNSIGNED DEFAULT '0' NOT NULL;
\ No newline at end of file
diff --git a/sql/updates/2011_01_19_0_characters_character_queststatus.sql b/sql/updates/2011_01_19_0_characters_character_queststatus.sql
new file mode 100644
index 00000000000..4bc7eddd39a
--- /dev/null
+++ b/sql/updates/2011_01_19_0_characters_character_queststatus.sql
@@ -0,0 +1,15 @@
+ALTER TABLE `character_queststatus`
+ROW_FORMAT=DEFAULT,
+CHANGE `guid` `guid` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Global Unique Identifier',
+CHANGE `quest` `quest` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Quest Identifier',
+CHANGE `status` `status` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL,
+CHANGE `explored` `explored` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL,
+CHANGE `timer` `timer` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
+CHANGE `mobcount1` `mobcount1` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL,
+CHANGE `mobcount2` `mobcount2` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL,
+CHANGE `mobcount3` `mobcount3` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL,
+CHANGE `mobcount4` `mobcount4` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL,
+CHANGE `itemcount1` `itemcount1` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL,
+CHANGE `itemcount2` `itemcount2` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL,
+CHANGE `itemcount3` `itemcount3` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL,
+CHANGE `itemcount4` `itemcount4` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL;
\ No newline at end of file
diff --git a/sql/updates/2011_01_19_0_characters_character_queststatus_daily.sql b/sql/updates/2011_01_19_0_characters_character_queststatus_daily.sql
new file mode 100644
index 00000000000..334123e8df6
--- /dev/null
+++ b/sql/updates/2011_01_19_0_characters_character_queststatus_daily.sql
@@ -0,0 +1,5 @@
+ALTER TABLE `character_queststatus_daily`
+ROW_FORMAT=DEFAULT,
+CHANGE `guid` `guid` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Global Unique Identifier',
+CHANGE `quest` `quest` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Quest 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_queststatus_weekly.sql b/sql/updates/2011_01_19_0_characters_character_queststatus_weekly.sql
new file mode 100644
index 00000000000..fcf54ce0c14
--- /dev/null
+++ b/sql/updates/2011_01_19_0_characters_character_queststatus_weekly.sql
@@ -0,0 +1,4 @@
+ALTER TABLE `character_queststatus_weekly`
+ROW_FORMAT=DEFAULT,
+CHANGE `guid` `guid` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Global Unique Identifier',
+CHANGE `quest` `quest` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Quest Identifier';
\ No newline at end of file
diff --git a/sql/updates/2011_01_19_0_characters_character_reputation.sql b/sql/updates/2011_01_19_0_characters_character_reputation.sql
new file mode 100644
index 00000000000..04acd20bd6c
--- /dev/null
+++ b/sql/updates/2011_01_19_0_characters_character_reputation.sql
@@ -0,0 +1,5 @@
+ALTER TABLE `character_reputation`
+ROW_FORMAT=DEFAULT,
+CHANGE `guid` `guid` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Global Unique Identifier',
+CHANGE `faction` `faction` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL,
+CHANGE `flags` `flags` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL;
\ No newline at end of file
diff --git a/sql/updates/2011_01_19_0_characters_character_skills.sql b/sql/updates/2011_01_19_0_characters_character_skills.sql
new file mode 100644
index 00000000000..99bd2e754aa
--- /dev/null
+++ b/sql/updates/2011_01_19_0_characters_character_skills.sql
@@ -0,0 +1,6 @@
+ALTER TABLE `character_skills`
+ROW_FORMAT=DEFAULT,
+CHANGE `guid` `guid` INT(10) UNSIGNED NOT NULL COMMENT 'Global Unique Identifier',
+CHANGE `skill` `skill` SMALLINT(5) UNSIGNED NOT NULL,
+CHANGE `value` `value` SMALLINT(5) UNSIGNED NOT NULL,
+CHANGE `max` `max` SMALLINT(5) UNSIGNED NOT NULL;
\ No newline at end of file