From f7af49291bea4497082e62e11480cd070495210e Mon Sep 17 00:00:00 2001 From: leak Date: Thu, 20 Jan 2011 02:11:49 +0100 Subject: SQL: Characters db storage type cleanup No. 7 (final) - Note: - It is _strongly_ recommended to extensively test the recent changes before applying them to live data - To fully resync the character db layout with TC releases it is recommended to dump the characters table with mysqldump --no-data characters > characters_database_livedata.sql and use a diff tool to compare it against sql/base/characters_database.sql --- .../2011_01_20_0_characters_item_soulbound_trace_data.sql | 3 +++ sql/updates/2011_01_20_0_characters_lag_reports.sql | 6 ++++++ sql/updates/2011_01_20_0_characters_mail.sql | 11 +++++++++++ sql/updates/2011_01_20_0_characters_mail_items.sql | 4 ++++ sql/updates/2011_01_20_0_characters_pet_aura.sql | 10 ++++++++++ sql/updates/2011_01_20_0_characters_pet_spell.sql | 5 +++++ sql/updates/2011_01_20_0_characters_pet_spell_cooldown.sql | 4 ++++ sql/updates/2011_01_20_0_characters_petition.sql | 4 ++++ sql/updates/2011_01_20_0_characters_petition_sign.sql | 6 ++++++ sql/updates/2011_01_20_0_characters_worldstates.sql | 5 +++++ 10 files changed, 58 insertions(+) create mode 100644 sql/updates/2011_01_20_0_characters_item_soulbound_trace_data.sql create mode 100644 sql/updates/2011_01_20_0_characters_lag_reports.sql create mode 100644 sql/updates/2011_01_20_0_characters_mail.sql create mode 100644 sql/updates/2011_01_20_0_characters_mail_items.sql create mode 100644 sql/updates/2011_01_20_0_characters_pet_aura.sql create mode 100644 sql/updates/2011_01_20_0_characters_pet_spell.sql create mode 100644 sql/updates/2011_01_20_0_characters_pet_spell_cooldown.sql create mode 100644 sql/updates/2011_01_20_0_characters_petition.sql create mode 100644 sql/updates/2011_01_20_0_characters_petition_sign.sql create mode 100644 sql/updates/2011_01_20_0_characters_worldstates.sql (limited to 'sql/updates') diff --git a/sql/updates/2011_01_20_0_characters_item_soulbound_trace_data.sql b/sql/updates/2011_01_20_0_characters_item_soulbound_trace_data.sql new file mode 100644 index 00000000000..ff07610bb8f --- /dev/null +++ b/sql/updates/2011_01_20_0_characters_item_soulbound_trace_data.sql @@ -0,0 +1,3 @@ +ALTER TABLE `item_soulbound_trade_data` +ROW_FORMAT=DEFAULT, +CHANGE `itemGuid` `itemGuid` INT(10) UNSIGNED NOT NULL COMMENT 'Item GUID'; \ No newline at end of file diff --git a/sql/updates/2011_01_20_0_characters_lag_reports.sql b/sql/updates/2011_01_20_0_characters_lag_reports.sql new file mode 100644 index 00000000000..ed10b9a473f --- /dev/null +++ b/sql/updates/2011_01_20_0_characters_lag_reports.sql @@ -0,0 +1,6 @@ +ALTER TABLE `lag_reports` +ROW_FORMAT=DEFAULT, +CHANGE `report_id` `report_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, +CHANGE `player` `player` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `lag_type` `lag_type` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `map` `map` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL; \ No newline at end of file diff --git a/sql/updates/2011_01_20_0_characters_mail.sql b/sql/updates/2011_01_20_0_characters_mail.sql new file mode 100644 index 00000000000..5115e97d585 --- /dev/null +++ b/sql/updates/2011_01_20_0_characters_mail.sql @@ -0,0 +1,11 @@ +ALTER TABLE `mail` +ROW_FORMAT=DEFAULT, +CHANGE `id` `id` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Identifier', +CHANGE `mailTemplateId` `mailTemplateId` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `sender` `sender` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Character Global Unique Identifier', +CHANGE `receiver` `receiver` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Character Global Unique Identifier', +CHANGE `expire_time` `expire_time` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `deliver_time` `deliver_time` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `money` `money` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `cod` `cod` INT(10) UNSIGNED DEFAULT '0' NOT NULL; + diff --git a/sql/updates/2011_01_20_0_characters_mail_items.sql b/sql/updates/2011_01_20_0_characters_mail_items.sql new file mode 100644 index 00000000000..b7618915564 --- /dev/null +++ b/sql/updates/2011_01_20_0_characters_mail_items.sql @@ -0,0 +1,4 @@ +ALTER TABLE `mail_items` +CHANGE `mail_id` `mail_id` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `item_guid` `item_guid` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `receiver` `receiver` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Character Global Unique Identifier'; \ No newline at end of file diff --git a/sql/updates/2011_01_20_0_characters_pet_aura.sql b/sql/updates/2011_01_20_0_characters_pet_aura.sql new file mode 100644 index 00000000000..38b3b82c0f1 --- /dev/null +++ b/sql/updates/2011_01_20_0_characters_pet_aura.sql @@ -0,0 +1,10 @@ +ALTER TABLE `pet_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, +CHANGE `amount0` `amount0` MEDIUMINT(8) NOT NULL, +CHANGE `amount1` `amount1` MEDIUMINT(8) NOT NULL, +CHANGE `amount2` `amount2` MEDIUMINT(8) NOT NULL, +CHANGE `base_amount0` `base_amount0` MEDIUMINT(8) NOT NULL, +CHANGE `base_amount1` `base_amount1` MEDIUMINT(8) NOT NULL, +CHANGE `base_amount2` `base_amount2` MEDIUMINT(8) NOT NULL; \ No newline at end of file diff --git a/sql/updates/2011_01_20_0_characters_pet_spell.sql b/sql/updates/2011_01_20_0_characters_pet_spell.sql new file mode 100644 index 00000000000..e95c83f5f6f --- /dev/null +++ b/sql/updates/2011_01_20_0_characters_pet_spell.sql @@ -0,0 +1,5 @@ +ALTER TABLE `pet_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', +CHANGE `active` `active` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL; \ No newline at end of file diff --git a/sql/updates/2011_01_20_0_characters_pet_spell_cooldown.sql b/sql/updates/2011_01_20_0_characters_pet_spell_cooldown.sql new file mode 100644 index 00000000000..4d8b5dfd491 --- /dev/null +++ b/sql/updates/2011_01_20_0_characters_pet_spell_cooldown.sql @@ -0,0 +1,4 @@ +ALTER TABLE `pet_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 `time` `time` INT(10) UNSIGNED DEFAULT '0' NOT NULL; \ No newline at end of file diff --git a/sql/updates/2011_01_20_0_characters_petition.sql b/sql/updates/2011_01_20_0_characters_petition.sql new file mode 100644 index 00000000000..a149c568429 --- /dev/null +++ b/sql/updates/2011_01_20_0_characters_petition.sql @@ -0,0 +1,4 @@ +ALTER TABLE `petition` +ROW_FORMAT=DEFAULT, +CHANGE `name` `name` VARCHAR(24) NOT NULL, +CHANGE `type` `type` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL; \ No newline at end of file diff --git a/sql/updates/2011_01_20_0_characters_petition_sign.sql b/sql/updates/2011_01_20_0_characters_petition_sign.sql new file mode 100644 index 00000000000..2d55505764d --- /dev/null +++ b/sql/updates/2011_01_20_0_characters_petition_sign.sql @@ -0,0 +1,6 @@ +ALTER TABLE `petition_sign` +ROW_FORMAT=DEFAULT, +CHANGE `petitionguid` `petitionguid` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `playerguid` `playerguid` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `player_account` `player_account` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `type` `type` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL; \ No newline at end of file diff --git a/sql/updates/2011_01_20_0_characters_worldstates.sql b/sql/updates/2011_01_20_0_characters_worldstates.sql new file mode 100644 index 00000000000..f05d04f4a03 --- /dev/null +++ b/sql/updates/2011_01_20_0_characters_worldstates.sql @@ -0,0 +1,5 @@ +ALTER TABLE `worldstates` +ROW_FORMAT=DEFAULT, +CHANGE `entry` `entry` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `value` `value` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `comment` `comment` TINYTEXT; -- cgit v1.2.3