-- =============================================
-- 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...  

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

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

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

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

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

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

--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');

--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

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

create table t1(id int, name varchar(1024), age int);
create table t2(id int, age int);
--the trigger calls itself

     DROP TABLE LOGTABLE 
GO
CREATE TABLE LOGTABLE (logMsg varchar(MAX), modified datetime);
--------------------------------------
-- Service Broker Setup

--
-- Trigger recursion test
--
-- test the maximum recursion level to be less than 16

create table t1(id int, name varchar(1024), age int);
create table t2(id int, age int);
create trigger test_0 after insert on t1

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;

--this test only tests the sintax
--the semantic should also be tested after the syntax test
create table t1 (id int, name varchar(1024));
insert into t1 values(10, 'monetdb');
insert into t1 values(20, 'monet');

#
# By: Ron Cordell - roncordell
#  I didn't see this anywhere, so I thought I'd post it here. This is the script from Quartz to create the tables in a MySQ...  
DROP TABLE IF EXISTS QRTZ_JOB_LISTENERS;
DROP TABLE IF EXISTS QRTZ_TRIGGER_LISTENERS;

#
# By: Ron Cordell - roncordell
#  I didn't see this anywhere, so I thought I'd post it here. This is the script from Quartz to create the tables in a MySQ...  
DROP TABLE IF EXISTS QRTZ_JOB_LISTENERS;
DROP TABLE IF EXISTS QRTZ_TRIGGER_LISTENERS;

#
# By: Ron Cordell - roncordell
#  I didn't see this anywhere, so I thought I'd post it here. This is the script from Quartz to create the tables in a MySQ...  
DROP TABLE IF EXISTS QRTZ_JOB_LISTENERS;
DROP TABLE IF EXISTS QRTZ_TRIGGER_LISTENERS;

#
# By: Ron Cordell - roncordell
#  I didn't see this anywhere, so I thought I'd post it here. This is the script from Quartz to create the tables in a MySQ...  
DROP TABLE IF EXISTS QRTZ_JOB_LISTENERS;
DROP TABLE IF EXISTS QRTZ_TRIGGER_LISTENERS;

** 
** By: Ron Cordell - roncordell
** I didn't see this anywhere, so I thought I'd post it here. This is the script from Quartz to create the tables in a MySQ...  
*/
DROP TABLE IF EXISTS QRTZ_JOB_LISTENERS;