sql/updates/7141_01_mangos_instance_template.sql

   1 ALTER TABLE db_version CHANGE COLUMN required_7133_02_mangos_spell_loot_template required_7141_01_mangos_instance_template bit;
   2
   3 ALTER TABLE instance_template ADD maxPlayersHeroic tinyint(3) unsigned NOT NULL default '0' AFTER maxPlayers;
   4
   5 UPDATE instance_template SET maxPlayersHeroic = maxPlayers;
   6
   7 DELETE FROM instance_template WHERE map IN (533,615,616,624);
   8 INSERT INTO instance_template VALUES
   9 (533,0,80,0,10,25,0,NULL,NULL,NULL,NULL,''),
  10 (615,0,80,0,10,25,0,NULL,NULL,NULL,NULL,''),
  11 (616,0,80,0,10,25,0,NULL,NULL,NULL,NULL,''),
  12 (624,0,80,0,10,25,0,NULL,NULL,NULL,NULL,'');