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

-- AddressType
CREATE TRIGGER AUDITADDRESSTYPEINSERT AFTER INSERT ON ADDRESS_TYPE FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAuditAddressType"
CREATE TRIGGER AUDITADDRESSTYPEDELETE BEFORE DELETE ON ADDRESS_TYPE FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAuditAddressType"
CREATE TRIGGER AUDITADDRESSTYPEUPDATE BEFORE UPDATE ON ADDRESS_TYPE FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAuditAddressType"

-- Asset
CREATE TRIGGER AUDITASSETINSERT AFTER INSERT ON ASSET FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAuditAsset"
CREATE TRIGGER AUDITASSETDELETE BEFORE DELETE ON ASSET FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAuditAsset"
CREATE TRIGGER AUDITASSETUPDATE BEFORE UPDATE ON ASSET FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAuditAsset"

-- Asset Instance
CREATE TRIGGER AUDITASSETINSTANCEINSERT AFTER INSERT ON ASSET_INSTANCE FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAuditAssetInstance"
CREATE TRIGGER AUDITASSETINSTANCEDELETE BEFORE DELETE ON ASSET_INSTANCE FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAuditAssetInstance"
CREATE TRIGGER AUDITASSETINSTANCEUPDATE BEFORE UPDATE ON ASSET_INSTANCE FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAuditAssetInstance"

-- Asset Status
CREATE TRIGGER AUDITASSETSTATUSINSERT AFTER INSERT ON ASSET_TYPE FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAuditAssetStatus"
CREATE TRIGGER AUDITASSETSTATUSDELETE BEFORE DELETE ON ASSET_TYPE FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAuditAssetStatus"
CREATE TRIGGER AUDITASSETSTATUSUPDATE BEFORE UPDATE ON ASSET_TYPE FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAuditAssetStatus"

-- Asset Type
CREATE TRIGGER AUDITASSETTYPEINSERT AFTER INSERT ON ASSET_TYPE FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAuditAssetType"
CREATE TRIGGER AUDITASSETTYPEDELETE BEFORE DELETE ON ASSET_TYPE FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAuditAssetType"
CREATE TRIGGER AUDITASSETTYPEUPDATE BEFORE UPDATE ON ASSET_TYPE FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAuditAssetType"

-- Email
CREATE TRIGGER AUDITEMAILINSERT AFTER INSERT ON EMAIL FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAuditEmail"
CREATE TRIGGER AUDITEMAILDELETE BEFORE DELETE ON EMAIL FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAuditEmail"
CREATE TRIGGER AUDITEMAILUPDATE BEFORE UPDATE ON EMAIL FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAuditEmail"

-- Entity
CREATE TRIGGER AUDITENTITYINSERT AFTER INSERT ON ENTITY FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAuditEntity"
CREATE TRIGGER AUDITENTITYDELETE BEFORE DELETE ON ENTITY FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAuditEntity"
CREATE TRIGGER AUDITENTITYUPDATE BEFORE UPDATE ON ENTITY FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAuditEntity"

-- EntityMatter
CREATE TRIGGER AUDITENTITYMATTERINSERT AFTER INSERT ON ENTITY_MATTER FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAuditEntityMatter"
CREATE TRIGGER AUDITENTITYMATTERDELETE BEFORE DELETE ON ENTITY_MATTER FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAuditEntityMatter"
CREATE TRIGGER AUDITENTITYMATTERUPDATE BEFORE UPDATE ON ENTITY_MATTER FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAuditEntityMatter"

-- EntityMatterRole
CREATE TRIGGER AUDITENTITYMATTERROLEINSERT AFTER INSERT ON ENTITY_MATTER_ROLE FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAuditEntityMatterRole"
CREATE TRIGGER AUDITENTITYMATTERROLEDELETE BEFORE DELETE ON ENTITY_MATTER_ROLE FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAuditEntityMatterRole"
CREATE TRIGGER AUDITENTITYMATTERROLEUPDATE BEFORE UPDATE ON ENTITY_MATTER_ROLE FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAuditEntityMatterRole"

-- EntityParty
CREATE TRIGGER AUDITENTITYPARTYINSERT AFTER INSERT ON ENTITY_PARTY FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAuditEntityParty"
CREATE TRIGGER AUDITENTITYPARTYDELETE BEFORE DELETE ON ENTITY_PARTY FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAuditEntityParty"
CREATE TRIGGER AUDITENTITYPARTYUPDATE BEFORE UPDATE ON ENTITY_PARTY FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAuditEntityParty"

-- EntityRelationship
CREATE TRIGGER AUDITENTITYRELATIONSHIPINSERT AFTER INSERT ON ENTITY_RELATIONSHIP FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAuditEntityRelationship"
CREATE TRIGGER AUDITENTITYRELATIONSHIPDELETE BEFORE DELETE ON ENTITY_RELATIONSHIP FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAuditEntityRelationship"
CREATE TRIGGER AUDITENTITYRELATIONSHIPUPDATE BEFORE UPDATE ON ENTITY_RELATIONSHIP FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAuditEntityRelationship"

-- EntityRelationshipGroup
CREATE TRIGGER AUDITENTITYRELATIONSHIPGROUPINSERT AFTER INSERT ON ENTITY_RELATIONSHIP_GROUP FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAuditEntityRelationshipGroup"
CREATE TRIGGER AUDITENTITYRELATIONSHIPGROUPDELETE BEFORE DELETE ON ENTITY_RELATIONSHIP_GROUP FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAuditEntityRelationshipGroup"
CREATE TRIGGER AUDITENTITYRELATIONSHIPGROUPUPDATE BEFORE UPDATE ON ENTITY_RELATIONSHIP_GROUP FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAuditEntityRelationshipGroup"

-- EntityRelationshipType
CREATE TRIGGER AUDITENTITYRELATIONSHIPTYPEINSERT AFTER INSERT ON ENTITY_RELATIONSHIP_TYPE FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAuditEntityRelationshipType"
CREATE TRIGGER AUDITENTITYRELATIONSHIPTYPEDELETE BEFORE DELETE ON ENTITY_RELATIONSHIP_TYPE FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAuditEntityRelationshipType"
CREATE TRIGGER AUDITENTITYRELATIONSHIPTYPEUPDATE BEFORE UPDATE ON ENTITY_RELATIONSHIP_TYPE FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAuditEntityRelationshipType"

-- Matter
CREATE TRIGGER AUDITMATTERINSERT AFTER INSERT ON MATTER FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAuditMatter"
CREATE TRIGGER AUDITMATTERDELETE BEFORE DELETE ON MATTER FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAuditMatter"
CREATE TRIGGER AUDITMATTERUPDATE BEFORE UPDATE ON MATTER FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAuditMatter"

-- MatterType
CREATE TRIGGER AUDITMATTERTYPEINSERT AFTER INSERT ON MATTER_TYPE FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAuditMatterType"
CREATE TRIGGER AUDITMATTERTYPEDELETE BEFORE DELETE ON MATTER_TYPE FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAuditMatterType"
CREATE TRIGGER AUDITMATTERTYPEUPDATE BEFORE UPDATE ON MATTER_TYPE FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAuditMatterType"

-- Party
CREATE TRIGGER AUDITPARTYINSERT AFTER INSERT ON PARTY FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAuditParty"
CREATE TRIGGER AUDITPARTYDELETE BEFORE DELETE ON PARTY FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAuditParty"
CREATE TRIGGER AUDITPARTYUPDATE BEFORE UPDATE ON PARTY FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAuditParty"

-- Phone
CREATE TRIGGER AUDITPHONEINSERT AFTER INSERT ON PHONE FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAuditPhone"
CREATE TRIGGER AUDITPHONEDELETE BEFORE DELETE ON PHONE FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAuditPhone"
CREATE TRIGGER AUDITPHONEUPDATE BEFORE UPDATE ON PHONE FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAuditPhone"

-- PhoneType
CREATE TRIGGER AUDITPHONETYPEINSERT AFTER INSERT ON PHONE_TYPE FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAuditPhoneType"
CREATE TRIGGER AUDITPHONETYPEDELETE BEFORE DELETE ON PHONE_TYPE FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAuditPhoneType"
CREATE TRIGGER AUDITPHONETYPEUPDATE BEFORE UPDATE ON PHONE_TYPE FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAuditPhoneType"

-- TimeTrack
CREATE TRIGGER AUDITTIMETRACKINSERT AFTER INSERT ON PHONE_TYPE FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAuditTimeTrack"
CREATE TRIGGER AUDITTIMETRACKDELETE BEFORE DELETE ON PHONE_TYPE FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAuditTimeTrack"
CREATE TRIGGER AUDITTIMETRACKUPDATE BEFORE UPDATE ON PHONE_TYPE FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAuditTimeTrack"

-- UserSessionSetServerTime
CREATE TRIGGER AUDITUSERSESSIONINSERT AFTER INSERT ON USER_SESSION FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAuditUserSession"
CREATE TRIGGER AUDITUSERSESSIONDELETE BEFORE DELETE ON USER_SESSION FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAuditUserSession"
CREATE TRIGGER AUDITUSERSESSIONUPDATE BEFORE UPDATE ON USER_SESSION FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerAuditUserSession"


-- Server Time
CREATE TRIGGER USERCOMMENTSETSERVERTIME AFTER INSERT ON USER_COMMENT FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerCommentSetServerTime"
CREATE TRIGGER USERSESSIONSETSERVERTIME AFTER INSERT ON USER_SESSION FOR EACH ROW  CALL "com.genoprime.ct.db.hsql.trigger.TriggerUserSessionSetServerTime"