--
-- Drops triggers for synchronization
--
drop trigger customer_insert;

exec sp__helpdepends %s, 'trigger'

exec sp__helpdepends %s, 'trigger'

-- =============================================
-- Create trigger basic template(After trigger)
-- =============================================
IF EXISTS (SELECT name

-- =============================================
-- Create trigger basic template(After trigger)
-- =============================================
IF EXISTS (SELECT name

-- Address
CREATE TRIGGER AUDITADDRESSINSERT AFTER INSERT ON ADDRESS FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAudit...  
CREATE TRIGGER AUDITADDRESSDELETE BEFORE DELETE ON ADDRESS FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAudi...  
CREATE TRIGGER AUDITADDRESSUPDATE BEFORE UPDATE ON ADDRESS FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAudi...  

prompt disabling triggers
REM Disable the Trigger
ALTER TRIGGER CMS_DOCS$ESI$UPDATE DISABLE;

prompt enabling triggers
REM Enable the Trigger
ALTER TRIGGER CMS_DOCS$ESI$UPDATE ENABLE;

/* need to fix a bug with the trigger that updates our Entry, Story, Feedback, and PingTrack counts */
if exists (select * from dbo.sysobjects where id = object_id(N'[<dbUser,varchar,dbo>].[subtext_Content_Trigger]') and OBJEC...  
drop trigger [<dbUser,varchar,dbo>].[subtext_Content_Trigger]

-- test plperl triggers
CREATE TABLE trigger_test (
        i int,

--test the owner restriction for triggers
create trigger test2 after insert on t2
     insert into t1 values(12);

-- DDL Statements for object removal
---------------------------------------------------------
DROP TRIGGER partsgroupid;
DROP TRIGGER projectid;
DROP TRIGGER employeeid;

alter table resource_task add is_closed tinyint default 0;
--
-- Drops triggers for synchronization
--
drop trigger customer_insert;

-- =============================================
-- Create basic Instead Of Trigger
-- =============================================
IF EXISTS (SELECT name

-- =============================================
-- Create basic Instead Of Trigger
-- =============================================
IF EXISTS (SELECT name

-- test plperl triggers
CREATE TABLE trigger_test (
        i int,

--test the if the triggers action is accepted when the trigger event has BEFORE OR AFTER
--when the trigger event contains BEFORE the trigger action can only contain (DECLARE TABLE, DECLARE CURSOR,
--OPEN, CLOSE, FETCH, SELECT (for a single row), FREE LOCATOR, HOLD LOCATOR, CALL, RETURN and GET DIAGNOSTIC

CREATE TRIGGER customer_insert AFTER INSERT ON customer
    FOR EACH ROW call "de.inovex.timer.profiling.hsql.HistoryTrigger";
CREATE TRIGGER customer_update AFTER update ON customer

ALTER DATABASE AdventureWorks SET enable_broker;
--Services
IF exists (SELECT name FROM sys.services WHERE name = 'AsynchTriggerInitiatorService')
     DROP SERVICE AsynchTriggerInitiatorService
GO

select trigger_name
from user_triggers
order by 1

create table t1(id int, name varchar(1024), age int);
create table t2(id int, age int);
--the trigger calls itself
create trigger test_0 after insert on t1
     insert into t1 values(3, 'mo', 27);

--test if it is allowed to execute schema operations with triggers
create table t1 (id int, name varchar(1024));
insert into t1 values(1, 'monetdb');

delete from qrtz_job_listeners;
delete from qrtz_trigger_listeners;
delete from qrtz_fired_triggers;
delete from qrtz_simple_triggers;

#
DROP TABLE IF EXISTS QRTZ_JOB_LISTENERS;
DROP TABLE IF EXISTS QRTZ_TRIGGER_LISTENERS;
DROP TABLE IF EXISTS QRTZ_FIRED_TRIGGERS;
DROP TABLE IF EXISTS QRTZ_SIMPLE_TRIGGERS;

# Thanks to Patrick Lightbody for submitting this...
drop table qrtz_job_listeners;
drop table qrtz_trigger_listeners;
drop table qrtz_fired_triggers;
drop table qrtz_simple_triggers;