diff options
Diffstat (limited to 'sql/updates')
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 |