• Home
• pro.taskana
• taskana-common
• 6.3.1
• source code
• taskana_schema_update_4.0.0_to_4.3.0_db2.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.db2.taskana_schema_update_4.0.0_to_4.3.0_db2.sql Maven / Gradle / Ivy

-- this script updates the tables TASKANA_SCHEMA_VERSION and ATTACHMENT.

SET SCHEMA %schemaName%;

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

ALTER TABLE ATTACHMENT ALTER COLUMN REF_SYSTEM DROP NOT NULL ALTER COLUMN REF_INSTANCE DROP NOT NULL;

CALL SYSPROC.ADMIN_CMD ('REORG TABLE ATTACHMENT');