SQL: Characters db storage type cleanup No. 4

10 files changed, 77 insertions, 0 deletions

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