------------------------------------------------------------------------------------
--  Purpose:  Create function RENAME_SEQUENCE() that is required for renaming the sequences belonging to tables
------------------------------------------------------------------------------------

CREATE ALIAS RENAME_SEQUENCE FOR "ch.systemsx.cisd.dbmigration.h2.H2StoredProcedures.renameSequence";

------------------------------------------------------------------------------------
--  Purpose:  Create trigger CONTROLLED_VOCABULARY_CHECK 
------------------------------------------------------------------------------------

CREATE TRIGGER CONTROLLED_VOCABULARY_CHECK_INSERT BEFORE INSERT ON PROPERTY_TYPES
    FOR EACH ROW CALL "ch.systemsx.cisd.lims.server.dataaccess.db.h2.H2ControlledVocabularyCheckTrigger";
CREATE TRIGGER CONTROLLED_VOCABULARY_CHECK_UPDATE BEFORE UPDATE ON PROPERTY_TYPES
    FOR EACH ROW CALL "ch.systemsx.cisd.lims.server.dataaccess.db.h2.H2ControlledVocabularyCheckTrigger";

