From a0e50ea35fca61447bf07fc45d93c98234ba59f7 Mon Sep 17 00:00:00 2001 From: Shauren Date: Sun, 14 Sep 2014 16:14:12 +0200 Subject: Core/Entities: Use ObjectGuid class in game project --- sql/base/characters_database.sql | 16 ++++++++-------- .../characters/2014_09_13_00_characters_groups.sql | 9 +++++++++ 2 files changed, 17 insertions(+), 8 deletions(-) create mode 100644 sql/updates/characters/2014_09_13_00_characters_groups.sql (limited to 'sql') diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 6e3ab43e4ac..f3e013529fc 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -1621,14 +1621,14 @@ CREATE TABLE `groups` ( `lootMethod` tinyint(3) unsigned NOT NULL, `looterGuid` int(10) unsigned NOT NULL, `lootThreshold` tinyint(3) unsigned NOT NULL, - `icon1` int(10) unsigned NOT NULL, - `icon2` int(10) unsigned NOT NULL, - `icon3` int(10) unsigned NOT NULL, - `icon4` int(10) unsigned NOT NULL, - `icon5` int(10) unsigned NOT NULL, - `icon6` int(10) unsigned NOT NULL, - `icon7` int(10) unsigned NOT NULL, - `icon8` int(10) unsigned NOT NULL, + `icon1` bigint(20) unsigned NOT NULL, + `icon2` bigint(20) unsigned NOT NULL, + `icon3` bigint(20) unsigned NOT NULL, + `icon4` bigint(20) unsigned NOT NULL, + `icon5` bigint(20) unsigned NOT NULL, + `icon6` bigint(20) unsigned NOT NULL, + `icon7` bigint(20) unsigned NOT NULL, + `icon8` bigint(20) unsigned NOT NULL, `groupType` tinyint(3) unsigned NOT NULL, `difficulty` tinyint(3) unsigned NOT NULL DEFAULT '0', `raiddifficulty` tinyint(3) unsigned NOT NULL DEFAULT '0', diff --git a/sql/updates/characters/2014_09_13_00_characters_groups.sql b/sql/updates/characters/2014_09_13_00_characters_groups.sql new file mode 100644 index 00000000000..b1dc9855249 --- /dev/null +++ b/sql/updates/characters/2014_09_13_00_characters_groups.sql @@ -0,0 +1,9 @@ +ALTER TABLE `groups` + MODIFY `icon1` BIGINT(20) UNSIGNED NOT NULL, + MODIFY `icon2` BIGINT(20) UNSIGNED NOT NULL, + MODIFY `icon3` BIGINT(20) UNSIGNED NOT NULL, + MODIFY `icon4` BIGINT(20) UNSIGNED NOT NULL, + MODIFY `icon5` BIGINT(20) UNSIGNED NOT NULL, + MODIFY `icon6` BIGINT(20) UNSIGNED NOT NULL, + MODIFY `icon7` BIGINT(20) UNSIGNED NOT NULL, + MODIFY `icon8` BIGINT(20) UNSIGNED NOT NULL; -- cgit v1.2.3