SQL: Characters db storage type cleanup No. 6

10 files changed, 76 insertions, 0 deletions

diff --git a/sql/updates/2011_01_20_0_characters_guild_bank_item.sql b/sql/updates/2011_01_20_0_characters_guild_bank_item.sql
new file mode 100644
index 00000000000..d3c0157ff51
--- /dev/null
+++ b/sql/updates/2011_01_20_0_characters_guild_bank_item.sql
@@ -0,0 +1,4 @@
+ALTER TABLE `guild_bank_item`
+CHANGE `guildid` `guildid` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
+CHANGE `TabId` `TabId` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL,
+CHANGE `item_guid` `item_guid` INT(10) UNSIGNED DEFAULT '0' NOT NULL;
\ No newline at end of file
diff --git a/sql/updates/2011_01_20_0_characters_guild_bank_right.sql b/sql/updates/2011_01_20_0_characters_guild_bank_right.sql
new file mode 100644
index 00000000000..9c72527ca5d
--- /dev/null
+++ b/sql/updates/2011_01_20_0_characters_guild_bank_right.sql
@@ -0,0 +1,5 @@
+ALTER TABLE `guild_bank_right`
+CHANGE `guildid` `guildid` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
+CHANGE `TabId` `TabId` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL,
+CHANGE `rid` `rid` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL,
+CHANGE `SlotPerDay` `SlotPerDay` INT(10) UNSIGNED DEFAULT '0' NOT NULL;
\ No newline at end of file
diff --git a/sql/updates/2011_01_20_0_characters_guild_bank_tab.sql b/sql/updates/2011_01_20_0_characters_guild_bank_tab.sql
new file mode 100644
index 00000000000..a096a0836cc
--- /dev/null
+++ b/sql/updates/2011_01_20_0_characters_guild_bank_tab.sql
@@ -0,0 +1,5 @@
+ALTER TABLE `guild_bank_tab`
+CHANGE `guildid` `guildid` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
+CHANGE `TabId` `TabId` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL,
+CHANGE `TabName` `TabName` VARCHAR(16) DEFAULT '' NOT NULL,
+CHANGE `TabText` `TabText` VARCHAR(500) NULL;
\ No newline at end of file
diff --git a/sql/updates/2011_01_20_0_characters_guild_eventlog.sql b/sql/updates/2011_01_20_0_characters_guild_eventlog.sql
new file mode 100644
index 00000000000..cf5f71a347c
--- /dev/null
+++ b/sql/updates/2011_01_20_0_characters_guild_eventlog.sql
@@ -0,0 +1,8 @@
+ALTER TABLE `guild_eventlog`
+CHANGE `guildid` `guildid` INT(10) UNSIGNED NOT NULL COMMENT 'Guild Identificator',
+CHANGE `LogGuid` `LogGuid` INT(10) UNSIGNED NOT NULL COMMENT 'Log record identificator - auxiliary column',
+CHANGE `EventType` `EventType` TINYINT(3) UNSIGNED NOT NULL COMMENT 'Event type',
+CHANGE `PlayerGuid1` `PlayerGuid1` INT(10) UNSIGNED NOT NULL COMMENT 'Player 1',
+CHANGE `PlayerGuid2` `PlayerGuid2` INT(10) UNSIGNED NOT NULL COMMENT 'Player 2',
+CHANGE `NewRank` `NewRank` TINYINT(3) UNSIGNED NOT NULL COMMENT 'New rank(in case promotion/demotion)',
+CHANGE `TimeStamp` `TimeStamp` INT(10) UNSIGNED NOT NULL COMMENT 'Event UNIX time';
\ No newline at end of file
diff --git a/sql/updates/2011_01_20_0_characters_guild_member.sql b/sql/updates/2011_01_20_0_characters_guild_member.sql
new file mode 100644
index 00000000000..f1d2f78727e
--- /dev/null
+++ b/sql/updates/2011_01_20_0_characters_guild_member.sql
@@ -0,0 +1,21 @@
+ALTER TABLE `guild_member`
+ROW_FORMAT=DEFAULT,
+CHANGE `guildid` `guildid` INT(10) UNSIGNED NOT NULL COMMENT 'Guild Identificator',
+CHANGE `guid` `guid` INT(10) UNSIGNED NOT NULL,
+CHANGE `rank` `rank` TINYINT(3) UNSIGNED NOT NULL,
+CHANGE `pnote` `pnote` varchar(31) NOT NULL DEFAULT '',
+CHANGE `offnote` `offnote` varchar(31) NOT NULL DEFAULT '',
+CHANGE `BankResetTimeMoney` `BankResetTimeMoney` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `BankRemMoney` `BankRemMoney` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `BankResetTimeTab0` `BankResetTimeTab0` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `BankRemSlotsTab0` `BankRemSlotsTab0` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `BankResetTimeTab1` `BankResetTimeTab1` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `BankRemSlotsTab1` `BankRemSlotsTab1` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `BankResetTimeTab2` `BankResetTimeTab2` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `BankRemSlotsTab2` `BankRemSlotsTab2` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `BankResetTimeTab3` `BankResetTimeTab3` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `BankRemSlotsTab3` `BankRemSlotsTab3` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `BankResetTimeTab4` `BankResetTimeTab4` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `BankRemSlotsTab4` `BankRemSlotsTab4` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `BankResetTimeTab5` `BankResetTimeTab5` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `BankRemSlotsTab5` `BankRemSlotsTab5` INT(10) UNSIGNED NOT NULL DEFAULT '0';
\ No newline at end of file
diff --git a/sql/updates/2011_01_20_0_characters_guild_rank.sql b/sql/updates/2011_01_20_0_characters_guild_rank.sql
new file mode 100644
index 00000000000..f66102bd112
--- /dev/null
+++ b/sql/updates/2011_01_20_0_characters_guild_rank.sql
@@ -0,0 +1,7 @@
+ALTER TABLE `guild_rank`
+ROW_FORMAT=DEFAULT,
+CHANGE `guildid` `guildid` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
+CHANGE `rid` `rid` TINYINT(3) UNSIGNED NOT NULL,
+CHANGE `rname` `rname` VARCHAR(15) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' NOT NULL,
+CHANGE `rights` `rights` MEDIUMINT(8) UNSIGNED DEFAULT '0' NOT NULL,
+CHANGE `BankMoneyPerDay` `BankMoneyPerDay` INT(10) UNSIGNED DEFAULT '0' NOT NULL;
\ No newline at end of file
diff --git a/sql/updates/2011_01_20_0_characters_instance.sql b/sql/updates/2011_01_20_0_characters_instance.sql
new file mode 100644
index 00000000000..2b1be5718b5
--- /dev/null
+++ b/sql/updates/2011_01_20_0_characters_instance.sql
@@ -0,0 +1,6 @@
+ALTER TABLE `instance`
+CHANGE `id` `id` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
+CHANGE `map` `map` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL,
+CHANGE `resettime` `resettime` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
+CHANGE `difficulty` `difficulty` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL,
+CHANGE `data` `data` TINYTEXT NOT NULL;
\ No newline at end of file
diff --git a/sql/updates/2011_01_20_0_characters_instance_reset.sql b/sql/updates/2011_01_20_0_characters_instance_reset.sql
new file mode 100644
index 00000000000..6c72951339d
--- /dev/null
+++ b/sql/updates/2011_01_20_0_characters_instance_reset.sql
@@ -0,0 +1,4 @@
+ALTER TABLE `instance_reset`
+CHANGE `mapid` `mapid` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL,
+CHANGE `difficulty` `difficulty` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL,
+CHANGE `resettime` `resettime` INT(10) UNSIGNED DEFAULT '0' NOT NULL;
\ No newline at end of file
diff --git a/sql/updates/2011_01_20_0_characters_item_instance.sql b/sql/updates/2011_01_20_0_characters_item_instance.sql
new file mode 100644
index 00000000000..649f87c4616
--- /dev/null
+++ b/sql/updates/2011_01_20_0_characters_item_instance.sql
@@ -0,0 +1,10 @@
+ALTER TABLE `item_instance`
+ROW_FORMAT=DEFAULT,
+CHANGE `guid` `guid` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
+CHANGE `owner_guid` `owner_guid` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
+CHANGE `charges` `charges` TINYTEXT,
+CHANGE `duration` `duration` INT(10) DEFAULT '0' NOT NULL,
+CHANGE `flags` `flags` MEDIUMINT(8) UNSIGNED DEFAULT '0' NOT NULL,
+CHANGE `randomPropertyId` `randomPropertyId` SMALLINT(5) DEFAULT '0' NOT NULL,
+CHANGE `durability` `durability` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL,
+CHANGE `text` `text` TEXT NULL;
diff --git a/sql/updates/2011_01_20_0_characters_item_refund_instance.sql b/sql/updates/2011_01_20_0_characters_item_refund_instance.sql
new file mode 100644
index 00000000000..0bd992e4bc3
--- /dev/null
+++ b/sql/updates/2011_01_20_0_characters_item_refund_instance.sql
@@ -0,0 +1,6 @@
+ALTER TABLE `item_refund_instance`
+ROW_FORMAT=DEFAULT,
+CHANGE `item_guid` `item_guid` INT(10) UNSIGNED NOT NULL COMMENT 'Item GUID',
+CHANGE `player_guid` `player_guid` INT(10) UNSIGNED NOT NULL COMMENT 'Player GUID',
+CHANGE `paidMoney` `paidMoney` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
+CHANGE `paidExtendedCost` `paidExtendedCost` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL;
\ No newline at end of file