diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/mangos.sql | 10 | ||||
| -rw-r--r-- | sql/realmd.sql | 22 | ||||
| -rw-r--r-- | sql/updates/3649_world.sql | 2 | ||||
| -rw-r--r-- | sql/updates/3689_TC1_1534_world.sql (renamed from sql/updates/TC1_1534_world.sql) | 3 | ||||
| -rw-r--r-- | sql/updates/3691_TC1_919_world.sql | 2 | ||||
| -rw-r--r-- | sql/updates/3715_mangos_7932_01_characters_character_pet.sql (renamed from sql/updates/7932_01_characters_character_pet.sql) | 5 | ||||
| -rw-r--r-- | sql/updates/3724_world.sql | 2 | ||||
| -rw-r--r-- | sql/updates/3729_mangos_7938_01_realmd_account.sql | 4 | ||||
| -rw-r--r-- | sql/updates/3736_world_spell_(dk).sql | 3 | ||||
| -rw-r--r-- | sql/updates/3747_mangos_7945_01_quest_template.sql | 9 | ||||
| -rw-r--r-- | sql/updates/919_world.sql | 3 |
11 files changed, 53 insertions, 12 deletions
diff --git a/sql/mangos.sql b/sql/mangos.sql index e8455a0c4ee..346495436d3 100644 --- a/sql/mangos.sql +++ b/sql/mangos.sql @@ -23,7 +23,7 @@ DROP TABLE IF EXISTS `db_version`; CREATE TABLE `db_version` ( `version` varchar(120) default NULL, `creature_ai_version` varchar(120) default NULL, - `required_7908_03_mangos_creature_template_addon` bit(1) default NULL + `required_7945_01_mangos_quest_template` bit(1) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Used DB version notes'; -- @@ -13264,12 +13264,20 @@ CREATE TABLE `quest_template` ( `DetailsEmote2` smallint(5) unsigned NOT NULL default '0', `DetailsEmote3` smallint(5) unsigned NOT NULL default '0', `DetailsEmote4` smallint(5) unsigned NOT NULL default '0', + `DetailsEmoteDelay1` int(11) unsigned NOT NULL default '0', + `DetailsEmoteDelay2` int(11) unsigned NOT NULL default '0', + `DetailsEmoteDelay3` int(11) unsigned NOT NULL default '0', + `DetailsEmoteDelay4` int(11) unsigned NOT NULL default '0', `IncompleteEmote` smallint(5) unsigned NOT NULL default '0', `CompleteEmote` smallint(5) unsigned NOT NULL default '0', `OfferRewardEmote1` smallint(5) unsigned NOT NULL default '0', `OfferRewardEmote2` smallint(5) unsigned NOT NULL default '0', `OfferRewardEmote3` smallint(5) unsigned NOT NULL default '0', `OfferRewardEmote4` smallint(5) unsigned NOT NULL default '0', + `OfferRewardEmoteDelay1` int(11) unsigned NOT NULL default '0', + `OfferRewardEmoteDelay2` int(11) unsigned NOT NULL default '0', + `OfferRewardEmoteDelay3` int(11) unsigned NOT NULL default '0', + `OfferRewardEmoteDelay4` int(11) unsigned NOT NULL default '0', `StartScript` mediumint(8) unsigned NOT NULL default '0', `CompleteScript` mediumint(8) unsigned NOT NULL default '0', PRIMARY KEY (`entry`) diff --git a/sql/realmd.sql b/sql/realmd.sql index fcd7d166359..f9d49de526c 100644 --- a/sql/realmd.sql +++ b/sql/realmd.sql @@ -15,13 +15,33 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; +/* +-- +-- Table structure for table `realmd_db_version` +-- + +DROP TABLE IF EXISTS `realmd_db_version`; +CREATE TABLE `realmd_db_version` ( + `required_7938_01_realmd_account` bit(1) default NULL +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Last applied sql update to DB'; + +-- +-- Dumping data for table `realmd_db_version` +-- + +LOCK TABLES `realmd_db_version` WRITE; +INSERT INTO `realmd_db_version` VALUES +(NULL); +UNLOCK TABLES; +*/ + -- -- Table structure for table `account` -- DROP TABLE IF EXISTS `account`; CREATE TABLE `account` ( - `id` bigint(20) unsigned NOT NULL auto_increment COMMENT 'Identifier', + `id` int(11) unsigned NOT NULL auto_increment COMMENT 'Identifier', `username` varchar(32) NOT NULL default '', `sha_pass_hash` varchar(40) NOT NULL default '', `gmlevel` tinyint(3) unsigned NOT NULL default '0', diff --git a/sql/updates/3649_world.sql b/sql/updates/3649_world.sql index a75ebe7b158..4d1948c753e 100644 --- a/sql/updates/3649_world.sql +++ b/sql/updates/3649_world.sql @@ -3,4 +3,4 @@ UPDATE `gameobject_template` SET `ScriptName` = 'go_ethereum_stasis' WHERE `entr UPDATE `gameobject_template` SET `ScriptName` = 'go_ethereum_stasis' WHERE `entry` = 184595; UPDATE `gameobject_template` SET `ScriptName` = 'go_ethereum_stasis' WHERE `entry` BETWEEN 185461 AND 185464; -UPDATE `creature_template` SET `ScriptName` = 'npc_engineering_tele_trinket' WHERE `entry` IN (14742, 14743, 21493, 21494); +UPDATE `creature_template` SET `ScriptName` = 'npc_engineering_tele_trinket' WHERE `entry` IN (14742, 14743, 21493, 21494);
\ No newline at end of file diff --git a/sql/updates/TC1_1534_world.sql b/sql/updates/3689_TC1_1534_world.sql index cd80a785278..774e0f7ec1b 100644 --- a/sql/updates/TC1_1534_world.sql +++ b/sql/updates/3689_TC1_1534_world.sql @@ -1,3 +1,2 @@ UPDATE `creature_template` SET `ScriptName` = 'mob_ethereal_apprentice' WHERE `entry` = 18430; - -DELETE FROM `creature` WHERE `id` = 18431; +DELETE FROM `creature` WHERE `id` = 18431;
\ No newline at end of file diff --git a/sql/updates/3691_TC1_919_world.sql b/sql/updates/3691_TC1_919_world.sql new file mode 100644 index 00000000000..02e35d5a423 --- /dev/null +++ b/sql/updates/3691_TC1_919_world.sql @@ -0,0 +1,2 @@ +ALTER TABLE version + ADD `core_revision` varchar(120) AFTER `core_version`;
\ No newline at end of file diff --git a/sql/updates/7932_01_characters_character_pet.sql b/sql/updates/3715_mangos_7932_01_characters_character_pet.sql index f797a79774c..7f272c92004 100644 --- a/sql/updates/7932_01_characters_character_pet.sql +++ b/sql/updates/3715_mangos_7932_01_characters_character_pet.sql @@ -1,9 +1,8 @@ --- ALTER TABLE character_db_version CHANGE COLUMN required_7903_01_characters_character_pet required_7932_01_characters_character_pet bit; +/*ALTER TABLE character_db_version CHANGE COLUMN required_7903_01_characters_character_pet required_7932_01_characters_character_pet bit;*/ UPDATE character_pet SET abdata = CONCAT(REPLACE(TRIM(abdata),' ',' '),' '); UPDATE character_pet SET abdata = SUBSTRING_INDEX(SUBSTRING_INDEX(abdata,' ',(10-3)*2),' ',-(10-3-3)*2) - WHERE length(SUBSTRING_INDEX(abdata, ' ', 20)) < length(abdata) and length(SUBSTRING_INDEX(abdata, ' ', 21)) >= length(abdata); - + WHERE length(SUBSTRING_INDEX(abdata, ' ', 20)) < length(abdata) and length(SUBSTRING_INDEX(abdata, ' ', 21)) >= length(abdata);
\ No newline at end of file diff --git a/sql/updates/3724_world.sql b/sql/updates/3724_world.sql index 1269925e0ee..36c8a75c3d1 100644 --- a/sql/updates/3724_world.sql +++ b/sql/updates/3724_world.sql @@ -7,4 +7,4 @@ UPDATE creature_template SET `ScriptName`='npc_ros_dark_rider' WHERE `entry`=287 -- Spellclick spell to mount deathcharger DELETE FROM npc_spellclick_spells WHERE `npc_entry`=28782; INSERT INTO npc_spellclick_spells (`npc_entry`, `spell_id`, `quest_id`, `quest_status`, `cast_flags`) VALUES -(28782, 52280, 12687, 3, 1); +(28782, 52280, 12687, 3, 1);
\ No newline at end of file diff --git a/sql/updates/3729_mangos_7938_01_realmd_account.sql b/sql/updates/3729_mangos_7938_01_realmd_account.sql new file mode 100644 index 00000000000..01c16d0b0bb --- /dev/null +++ b/sql/updates/3729_mangos_7938_01_realmd_account.sql @@ -0,0 +1,4 @@ +/*ALTER TABLE realmd_db_version CHANGE COLUMN required_7867_01_realmd_account required_7938_01_realmd_account bit;*/ + +ALTER TABLE account + CHANGE id id int(11) unsigned NOT NULL auto_increment COMMENT 'Identifier';
\ No newline at end of file diff --git a/sql/updates/3736_world_spell_(dk).sql b/sql/updates/3736_world_spell_(dk).sql new file mode 100644 index 00000000000..4aa0c6b557c --- /dev/null +++ b/sql/updates/3736_world_spell_(dk).sql @@ -0,0 +1,3 @@ +DELETE FROM spell_area WHERE spell = 52693; +INSERT INTO spell_area (`spell`, `area`, `quest_start`, `quest_start_active`, `quest_end`, `aura_spell`, `racemask`, `gender`, `autocast`) VALUES +(52693, 4298, 12687, 1, 12687, 0, 0, 0, 1);
\ No newline at end of file diff --git a/sql/updates/3747_mangos_7945_01_quest_template.sql b/sql/updates/3747_mangos_7945_01_quest_template.sql new file mode 100644 index 00000000000..ab28ccd50f3 --- /dev/null +++ b/sql/updates/3747_mangos_7945_01_quest_template.sql @@ -0,0 +1,9 @@ +ALTER TABLE quest_template + ADD COLUMN `DetailsEmoteDelay1` int(11) unsigned NOT NULL default '0' AFTER `DetailsEmote4`, + ADD COLUMN `DetailsEmoteDelay2` int(11) unsigned NOT NULL default '0' AFTER `DetailsEmoteDelay1`, + ADD COLUMN `DetailsEmoteDelay3` int(11) unsigned NOT NULL default '0' AFTER `DetailsEmoteDelay2`, + ADD COLUMN `DetailsEmoteDelay4` int(11) unsigned NOT NULL default '0' AFTER `DetailsEmoteDelay3`, + ADD COLUMN `OfferRewardEmoteDelay1` int(11) unsigned NOT NULL default '0' AFTER `OfferRewardEmote4`, + ADD COLUMN `OfferRewardEmoteDelay2` int(11) unsigned NOT NULL default '0' AFTER `OfferRewardEmoteDelay1`, + ADD COLUMN `OfferRewardEmoteDelay3` int(11) unsigned NOT NULL default '0' AFTER `OfferRewardEmoteDelay2`, + ADD COLUMN `OfferRewardEmoteDelay4` int(11) unsigned NOT NULL default '0' AFTER `OfferRewardEmoteDelay3`; diff --git a/sql/updates/919_world.sql b/sql/updates/919_world.sql deleted file mode 100644 index 7aa9fa363e6..00000000000 --- a/sql/updates/919_world.sql +++ /dev/null @@ -1,3 +0,0 @@ -ALTER TABLE version - ADD `core_revision` varchar(120) AFTER `core_version`; - |