SQL: Characters db storage type cleanup No. 2

11 files changed, 67 insertions, 1 deletions

diff --git a/sql/updates/2011_01_19_0_characters_bug_report.sql b/sql/updates/2011_01_19_0_characters_bug_report.sql
deleted file mode 100644
index e9c40877e69..00000000000
--- a/sql/updates/2011_01_19_0_characters_bug_report.sql
+++ /dev/null
@@ -1 +0,0 @@
-ALTER TABLE `addons` ROW_FORMAT=DEFAULT;
\ No newline at end of file
diff --git a/sql/updates/2011_01_19_0_characters_character_action.sql b/sql/updates/2011_01_19_0_characters_character_action.sql
new file mode 100644
index 00000000000..d2d235e270c
--- /dev/null
+++ b/sql/updates/2011_01_19_0_characters_character_action.sql
@@ -0,0 +1,4 @@
+ALTER TABLE `character_action`
+ROW_FORMAT=DEFAULT,
+CHANGE `guid` `guid` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
+CHANGE `action` `action` INT(10) UNSIGNED DEFAULT '0' NOT NULL;
\ No newline at end of file
diff --git a/sql/updates/2011_01_19_0_characters_character_arena_stats.sql b/sql/updates/2011_01_19_0_characters_character_arena_stats.sql
new file mode 100644
index 00000000000..e68048d2f0e
--- /dev/null
+++ b/sql/updates/2011_01_19_0_characters_character_arena_stats.sql
@@ -0,0 +1,3 @@
+ALTER TABLE `character_arena_stats`
+ENGINE=InnoDB,
+CHANGE `slot` `slot` TINYINT(3) NOT NULL;
\ No newline at end of file
diff --git a/sql/updates/2011_01_19_0_characters_character_aura.sql b/sql/updates/2011_01_19_0_characters_character_aura.sql
new file mode 100644
index 00000000000..072c88235e7
--- /dev/null
+++ b/sql/updates/2011_01_19_0_characters_character_aura.sql
@@ -0,0 +1,4 @@
+ALTER TABLE `character_aura`
+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;
\ No newline at end of file
diff --git a/sql/updates/2011_01_19_0_characters_character_banned.sql b/sql/updates/2011_01_19_0_characters_character_banned.sql
new file mode 100644
index 00000000000..da3d46d9929
--- /dev/null
+++ b/sql/updates/2011_01_19_0_characters_character_banned.sql
@@ -0,0 +1,6 @@
+ALTER TABLE `character_banned`
+ROW_FORMAT=DEFAULT,
+CHANGE `guid` `guid` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Account id',
+CHANGE `bandate` `bandate` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
+CHANGE `unbandate` `unbandate` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
+CHANGE `active` `active` TINYINT(3) UNSIGNED DEFAULT '1' NOT NULL;
\ No newline at end of file
diff --git a/sql/updates/2011_01_19_0_characters_character_battleground_data.sql b/sql/updates/2011_01_19_0_characters_character_battleground_data.sql
new file mode 100644
index 00000000000..09f24ed8bf9
--- /dev/null
+++ b/sql/updates/2011_01_19_0_characters_character_battleground_data.sql
@@ -0,0 +1,9 @@
+ALTER TABLE `character_battleground_data`
+ROW_FORMAT=DEFAULT,
+CHANGE `guid` `guid` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Global Unique Identifier',
+CHANGE `instance_id` `instance_id` INT(10) UNSIGNED NOT NULL, 
+CHANGE `team` `team` SMALLINT(5) UNSIGNED NOT NULL,
+CHANGE `join_map` `join_map` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL,
+CHANGE `taxi_start` `taxi_start` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
+CHANGE `taxi_end` `taxi_end` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
+CHANGE `mount_spell` `mount_spell` MEDIUMINT(8) UNSIGNED DEFAULT '0' NOT NULL;
\ No newline at end of file
diff --git a/sql/updates/2011_01_19_0_characters_character_battleground_random.sql b/sql/updates/2011_01_19_0_characters_character_battleground_random.sql
new file mode 100644
index 00000000000..cf76a17fc0c
--- /dev/null
+++ b/sql/updates/2011_01_19_0_characters_character_battleground_random.sql
@@ -0,0 +1,2 @@
+ALTER TABLE `character_battleground_random`
+CHANGE `guid` `guid` INT(10) UNSIGNED DEFAULT '0' NOT NULL;
\ No newline at end of file
diff --git a/sql/updates/2011_01_19_0_characters_character_declinedname.sql b/sql/updates/2011_01_19_0_characters_character_declinedname.sql
new file mode 100644
index 00000000000..912db55712b
--- /dev/null
+++ b/sql/updates/2011_01_19_0_characters_character_declinedname.sql
@@ -0,0 +1,3 @@
+ALTER TABLE `character_declinedname`
+ROW_FORMAT=DEFAULT,
+CHANGE `guid` `guid` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Global Unique Identifier';
\ No newline at end of file
diff --git a/sql/updates/2011_01_19_0_characters_character_equipmentsets.sql b/sql/updates/2011_01_19_0_characters_character_equipmentsets.sql
new file mode 100644
index 00000000000..3f4fe76d189
--- /dev/null
+++ b/sql/updates/2011_01_19_0_characters_character_equipmentsets.sql
@@ -0,0 +1,23 @@
+ALTER TABLE `character_equipmentsets`
+CHANGE `guid` `guid` INT(10) DEFAULT '0' NOT NULL,
+CHANGE `setindex` `setindex` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL,
+CHANGE `name` `name` VARCHAR(31) NOT NULL,
+CHANGE `item0` `item0` INT(10) UNSIGNED NOT NULL DEFAULT '0', 
+CHANGE `item1` `item1` INT(10) UNSIGNED NOT NULL DEFAULT '0', 
+CHANGE `item2` `item2` INT(10) UNSIGNED NOT NULL DEFAULT '0', 
+CHANGE `item3` `item3` INT(10) UNSIGNED NOT NULL DEFAULT '0', 
+CHANGE `item4` `item4` INT(10) UNSIGNED NOT NULL DEFAULT '0', 
+CHANGE `item5` `item5` INT(10) UNSIGNED NOT NULL DEFAULT '0', 
+CHANGE `item6` `item6` INT(10) UNSIGNED NOT NULL DEFAULT '0', 
+CHANGE `item7` `item7` INT(10) UNSIGNED NOT NULL DEFAULT '0', 
+CHANGE `item8` `item8` INT(10) UNSIGNED NOT NULL DEFAULT '0', 
+CHANGE `item9` `item9` INT(10) UNSIGNED NOT NULL DEFAULT '0', 
+CHANGE `item10` `item10` INT(10) UNSIGNED NOT NULL DEFAULT '0', 
+CHANGE `item11` `item11` INT(10) UNSIGNED NOT NULL DEFAULT '0', 
+CHANGE `item12` `item12` INT(10) UNSIGNED NOT NULL DEFAULT '0', 
+CHANGE `item13` `item13` INT(10) UNSIGNED NOT NULL DEFAULT '0', 
+CHANGE `item14` `item14` INT(10) UNSIGNED NOT NULL DEFAULT '0', 
+CHANGE `item15` `item15` INT(10) UNSIGNED NOT NULL DEFAULT '0', 
+CHANGE `item16` `item16` INT(10) UNSIGNED NOT NULL DEFAULT '0', 
+CHANGE `item17` `item17` INT(10) UNSIGNED NOT NULL DEFAULT '0', 
+CHANGE `item18` `item18` INT(10) UNSIGNED NOT NULL DEFAULT '0';
\ No newline at end of file
diff --git a/sql/updates/2011_01_19_0_characters_character_gifts.sql b/sql/updates/2011_01_19_0_characters_character_gifts.sql
new file mode 100644
index 00000000000..2012eb96315
--- /dev/null
+++ b/sql/updates/2011_01_19_0_characters_character_gifts.sql
@@ -0,0 +1,5 @@
+ALTER TABLE `character_gifts`
+CHANGE `guid` `guid` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
+CHANGE `item_guid` `item_guid` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
+CHANGE `entry` `entry` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
+CHANGE `flags` `flags` INT(10) UNSIGNED DEFAULT '0' NOT NULL;
\ No newline at end of file
diff --git a/sql/updates/2011_01_19_0_characters_character_glyphs.sql b/sql/updates/2011_01_19_0_characters_character_glyphs.sql
new file mode 100644
index 00000000000..73bb65f4ef9
--- /dev/null
+++ b/sql/updates/2011_01_19_0_characters_character_glyphs.sql
@@ -0,0 +1,8 @@
+ALTER TABLE `character_glyphs`
+CHANGE `guid` `guid` INT(10) UNSIGNED NOT NULL,
+CHANGE `glyph1` `glyph1` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL,
+CHANGE `glyph2` `glyph2` SMALLINT(5) UNSIGNED DEFAULT '0' NULL ,
+CHANGE `glyph3` `glyph3` SMALLINT(5) UNSIGNED DEFAULT '0' NULL ,
+CHANGE `glyph4` `glyph4` SMALLINT(5) UNSIGNED DEFAULT '0' NULL ,
+CHANGE `glyph5` `glyph5` SMALLINT(5) UNSIGNED DEFAULT '0' NULL ,
+CHANGE `glyph6` `glyph6` SMALLINT(5) UNSIGNED DEFAULT '0' NULL ;
\ No newline at end of file