• Home
• pro.taskana
• taskana-common
• 6.3.1
• source code
• taskana_schema_update_1.1.5_to_1.2.1_h2.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

sql.h2.taskana_schema_update_1.1.5_to_1.2.1_h2.sql Maven / Gradle / Ivy

-- this script adds a unique constraint to WORKBASKET_ACCESS_LIST
-- allowing a maximum of one WORKBASKET_ACCESS_LIST per workbasket and access_id
-- Please replace %schemaName% before executing the script

SET SCHEMA %schemaName%;

INSERT INTO TASKANA_SCHEMA_VERSION (VERSION, CREATED) VALUES ('1.2.1', CURRENT_TIMESTAMP);

-- If the database contains records that violate this constraint, the following statement will fail.
-- In this case it is required to remove the conflicting records before the constraint can be added

ALTER TABLE WORKBASKET_ACCESS_LIST ADD CONSTRAINT UC_ACCESSID_WBID UNIQUE (ACCESS_ID, WORKBASKET_ID);