cesg

-- ----------------------------------- --
-- Cristian Soto González  --
-- ----------------------------------- --
/* Datos a utilizar */
-- set @p_rut := '7654384-1';
-- set @c_edf := 03;
-- set @c_lect01 := 01;
-- set @c_lect02 := 02;

-- 1

cesg

# 2
alter table session 
add constraint fk_session_evento
foreign key (cod_evento) references `evento`(cod_evento)
on delete restrict on update restrict;

alter table session 
add constraint fk_session_periodo
foreign key (num_periodo) references `periodo`(num_periodo)
on delete restrict on update restrict;

cesg

 /*
 * Boss para reemplazar Gunship Battle de icc
 *@Autor: Vertex
 *@Version: 24-10-2011
 */
 #include "ScriptMgr.h"
 #include "ScriptedCreature.h"
 #include "MapManager.h"
 #include "icecrown_citadel.h"
 //#include "ScriptPCH.h"

cesg

enum eQuest
{
	q10866 = 10866
};
/*########################################################
# Unlocking Zuluhed's Chains
##########################################################*/
class spell_zuluhed :  public SpellScriptLoader
{
public:

cesg

UPDATE `quest_template` SET `ReqSpellCast1` = 0 WHERE entry = 10866;