diff options
| author | leak <leakzx@googlemail.com> | 2011-01-20 00:08:45 +0100 |
|---|---|---|
| committer | leak <leakzx@googlemail.com> | 2011-01-20 00:08:45 +0100 |
| commit | a486eb0c2fcc6bb43693e3c5404f8f82988e2531 (patch) | |
| tree | b5603d78e7c95f0ba32d780a002bf440d444460e /sql/updates | |
| parent | a7df9ddff1a4dc24d02e0c28276ff7a5f18dd764 (diff) | |
SQL: Characters db storage type cleanup No. 5
Diffstat (limited to 'sql/updates')
10 files changed, 77 insertions, 0 deletions
diff --git a/sql/updates/2011_01_20_0_characters_game_event_save.sql b/sql/updates/2011_01_20_0_characters_game_event_save.sql new file mode 100644 index 00000000000..06cc0976974 --- /dev/null +++ b/sql/updates/2011_01_20_0_characters_game_event_save.sql @@ -0,0 +1,3 @@ +ALTER TABLE `game_event_save` +CHANGE `event_id` `event_id` SMALLINT(5) UNSIGNED NOT NULL, +CHANGE `next_start` `next_start` INT(10) UNSIGNED DEFAULT '0' NOT NULL;
\ No newline at end of file diff --git a/sql/updates/2011_01_20_0_characters_gameobject_respawn.sql b/sql/updates/2011_01_20_0_characters_gameobject_respawn.sql new file mode 100644 index 00000000000..bf83a59a67e --- /dev/null +++ b/sql/updates/2011_01_20_0_characters_gameobject_respawn.sql @@ -0,0 +1,3 @@ +ALTER TABLE `gameobject_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_20_0_characters_gm_subsurveys.sql b/sql/updates/2011_01_20_0_characters_gm_subsurveys.sql new file mode 100644 index 00000000000..51af89da7f0 --- /dev/null +++ b/sql/updates/2011_01_20_0_characters_gm_subsurveys.sql @@ -0,0 +1,6 @@ +ALTER TABLE `gm_subsurveys` +ROW_FORMAT=DEFAULT, +CHANGE `surveyid` `surveyid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, +CHANGE `subsurveyid` `subsurveyid` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `rank` `rank` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `comment` `comment` TEXT NOT NULL;
\ No newline at end of file diff --git a/sql/updates/2011_01_20_0_characters_gm_surveys.sql b/sql/updates/2011_01_20_0_characters_gm_surveys.sql new file mode 100644 index 00000000000..93c37b7b45e --- /dev/null +++ b/sql/updates/2011_01_20_0_characters_gm_surveys.sql @@ -0,0 +1,6 @@ +ALTER TABLE `gm_surveys` +ROW_FORMAT=DEFAULT, +CHANGE `surveyid` `surveyid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, +CHANGE `player` `player` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `mainSurvey` `mainSurvey` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `timestamp` `timestamp` INT(10) UNSIGNED DEFAULT '0' NOT NULL;
\ No newline at end of file diff --git a/sql/updates/2011_01_20_0_characters_gm_tickets.sql b/sql/updates/2011_01_20_0_characters_gm_tickets.sql new file mode 100644 index 00000000000..44e88f44390 --- /dev/null +++ b/sql/updates/2011_01_20_0_characters_gm_tickets.sql @@ -0,0 +1,13 @@ +ALTER TABLE `gm_tickets` +ROW_FORMAT=DEFAULT, +CHANGE `guid` `guid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, +CHANGE `playerGuid` `playerGuid` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `name` `name` VARCHAR(12) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, +CHANGE `createtime` `createtime` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `map` `map` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `timestamp` `timestamp` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `closed` `closed` INT(11) DEFAULT '0' NOT NULL, +CHANGE `assignedto` `assignedto` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `completed` `completed` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `escalated` `escalated` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `viewed` `viewed` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL;
\ No newline at end of file diff --git a/sql/updates/2011_01_20_0_characters_group_instance.sql b/sql/updates/2011_01_20_0_characters_group_instance.sql new file mode 100644 index 00000000000..ae7f6fccf2d --- /dev/null +++ b/sql/updates/2011_01_20_0_characters_group_instance.sql @@ -0,0 +1,4 @@ +ALTER TABLE `group_instance` +CHANGE `guid` `guid` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `instance` `instance` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `permanent` `permanent` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL;
\ No newline at end of file diff --git a/sql/updates/2011_01_20_0_characters_group_member.sql b/sql/updates/2011_01_20_0_characters_group_member.sql new file mode 100644 index 00000000000..03bcbe66b3d --- /dev/null +++ b/sql/updates/2011_01_20_0_characters_group_member.sql @@ -0,0 +1,4 @@ +ALTER TABLE `group_member` +ROW_FORMAT=DEFAULT, +CHANGE `guid` `guid` INT(10) UNSIGNED NOT NULL, +CHANGE `memberGuid` `memberGuid` INT(10) UNSIGNED NOT NULL;
\ No newline at end of file diff --git a/sql/updates/2011_01_20_0_characters_groups.sql b/sql/updates/2011_01_20_0_characters_groups.sql new file mode 100644 index 00000000000..b986d402c8f --- /dev/null +++ b/sql/updates/2011_01_20_0_characters_groups.sql @@ -0,0 +1,17 @@ +ALTER TABLE `groups` +ROW_FORMAT=DEFAULT, +CHANGE `guid` `guid` INT(10) UNSIGNED NOT NULL, +CHANGE `leaderGuid` `leaderGuid` INT(10) UNSIGNED NOT NULL, +CHANGE `lootMethod` `lootMethod` TINYINT(3) UNSIGNED NOT NULL, +CHANGE `looterGuid` `looterGuid` INT(10) UNSIGNED NOT NULL, +CHANGE `lootThreshold` `lootThreshold` TINYINT(3) UNSIGNED NOT NULL, +CHANGE `icon1` `icon1` INT(10) UNSIGNED NOT NULL, +CHANGE `icon2` `icon2` INT(10) UNSIGNED NOT NULL, +CHANGE `icon3` `icon3` INT(10) UNSIGNED NOT NULL, +CHANGE `icon4` `icon4` INT(10) UNSIGNED NOT NULL, +CHANGE `icon5` `icon5` INT(10) UNSIGNED NOT NULL, +CHANGE `icon6` `icon6` INT(10) UNSIGNED NOT NULL, +CHANGE `icon7` `icon7` INT(10) UNSIGNED NOT NULL, +CHANGE `icon8` `icon8` INT(10) UNSIGNED NOT NULL, +CHANGE `groupType` `groupType` TINYINT(3) UNSIGNED NOT NULL, +CHANGE `raiddifficulty` `raiddifficulty` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL;
\ No newline at end of file diff --git a/sql/updates/2011_01_20_0_characters_guild.sql b/sql/updates/2011_01_20_0_characters_guild.sql new file mode 100644 index 00000000000..f384947a338 --- /dev/null +++ b/sql/updates/2011_01_20_0_characters_guild.sql @@ -0,0 +1,13 @@ +ALTER TABLE `guild` +ROW_FORMAT=DEFAULT, +CHANGE `guildid` `guildid` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `name` `name` VARCHAR(24) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' NOT NULL, +CHANGE `leaderguid` `leaderguid` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `EmblemStyle` `EmblemStyle` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `EmblemColor` `EmblemColor` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `BorderStyle` `BorderStyle` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `BorderColor` `BorderColor` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `BackgroundColor` `BackgroundColor` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `motd` `motd` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' NOT NULL, +CHANGE `createdate` `createdate` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `BankMoney` `BankMoney` BIGINT(20) UNSIGNED DEFAULT '0' NOT NULL;
\ No newline at end of file diff --git a/sql/updates/2011_01_20_0_characters_guild_bank_eventlog.sql b/sql/updates/2011_01_20_0_characters_guild_bank_eventlog.sql new file mode 100644 index 00000000000..627020be62f --- /dev/null +++ b/sql/updates/2011_01_20_0_characters_guild_bank_eventlog.sql @@ -0,0 +1,8 @@ +ALTER TABLE `guild_bank_eventlog` +CHANGE `guildid` `guildid` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Guild Identificator', +CHANGE `LogGuid` `LogGuid` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Log record identificator - auxiliary column', +CHANGE `PlayerGuid` `PlayerGuid` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `ItemOrMoney` `ItemOrMoney` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `ItemStackCount` `ItemStackCount` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0', +CHANGE `DestTabId` `DestTabId` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Destination Tab Id', +CHANGE `TimeStamp` `TimeStamp` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Event UNIX time';
\ No newline at end of file |