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 ++++++++-------- 1 file changed, 8 insertions(+), 8 deletions(-) (limited to 'sql/base') 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', -- cgit v1.2.3 From 09f9f3b6b12545e603cca4ef9c50b5415dca9d9a Mon Sep 17 00:00:00 2001 From: DDuarte Date: Fri, 19 Sep 2014 18:17:48 +0100 Subject: SQL: Update dev/world_database.sql --- sql/base/dev/world_database.sql | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) (limited to 'sql/base') diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql index 72faba49b8b..fd711888814 100644 --- a/sql/base/dev/world_database.sql +++ b/sql/base/dev/world_database.sql @@ -620,8 +620,9 @@ CREATE TABLE `creature_text` ( `emote` mediumint(8) unsigned NOT NULL DEFAULT '0', `duration` mediumint(8) unsigned NOT NULL DEFAULT '0', `sound` mediumint(8) unsigned NOT NULL DEFAULT '0', + `BroadcastTextId` mediumint(6) NOT NULL DEFAULT '0', + `TextRange` tinyint(3) unsigned NOT NULL DEFAULT '0', `comment` varchar(255) DEFAULT '', - `BroadcastTextID` mediumint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`entry`,`groupid`,`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; @@ -983,7 +984,7 @@ CREATE TABLE `game_tele` ( `map` smallint(5) unsigned NOT NULL DEFAULT '0', `name` varchar(100) NOT NULL DEFAULT '', PRIMARY KEY (`id`) -) ENGINE=MyISAM AUTO_INCREMENT=1424 DEFAULT CHARSET=utf8 COMMENT='Tele Command'; +) ENGINE=MyISAM AUTO_INCREMENT=1425 DEFAULT CHARSET=utf8 COMMENT='Tele Command'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -3634,4 +3635,4 @@ CREATE TABLE `waypoints` ( /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2014-08-27 14:06:19 +-- Dump completed on 2014-09-19 18:15:42 -- cgit v1.2.3 From eeaf7ef6fab3765d2d5b383541d72cf1235d442f Mon Sep 17 00:00:00 2001 From: DDuarte Date: Fri, 19 Sep 2014 18:42:09 +0100 Subject: Revert "SQL: Update dev/world_database.sql" This reverts commit 09f9f3b6b12545e603cca4ef9c50b5415dca9d9a. I forgot that world_database.sql should only get updated in TDB releases. --- sql/base/dev/world_database.sql | 7 +++---- 1 file changed, 3 insertions(+), 4 deletions(-) (limited to 'sql/base') diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql index fd711888814..72faba49b8b 100644 --- a/sql/base/dev/world_database.sql +++ b/sql/base/dev/world_database.sql @@ -620,9 +620,8 @@ CREATE TABLE `creature_text` ( `emote` mediumint(8) unsigned NOT NULL DEFAULT '0', `duration` mediumint(8) unsigned NOT NULL DEFAULT '0', `sound` mediumint(8) unsigned NOT NULL DEFAULT '0', - `BroadcastTextId` mediumint(6) NOT NULL DEFAULT '0', - `TextRange` tinyint(3) unsigned NOT NULL DEFAULT '0', `comment` varchar(255) DEFAULT '', + `BroadcastTextID` mediumint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`entry`,`groupid`,`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; @@ -984,7 +983,7 @@ CREATE TABLE `game_tele` ( `map` smallint(5) unsigned NOT NULL DEFAULT '0', `name` varchar(100) NOT NULL DEFAULT '', PRIMARY KEY (`id`) -) ENGINE=MyISAM AUTO_INCREMENT=1425 DEFAULT CHARSET=utf8 COMMENT='Tele Command'; +) ENGINE=MyISAM AUTO_INCREMENT=1424 DEFAULT CHARSET=utf8 COMMENT='Tele Command'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -3635,4 +3634,4 @@ CREATE TABLE `waypoints` ( /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2014-09-19 18:15:42 +-- Dump completed on 2014-08-27 14:06:19 -- cgit v1.2.3