diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/characters_database.sql | 16 | ||||
| -rw-r--r-- | sql/updates/characters/2014_09_13_00_characters_groups.sql | 9 |
2 files changed, 17 insertions, 8 deletions
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; |