• Home
• pro.taskana
• taskana-common
• 6.3.1
• source code
• taskana_schema_update_5.0.0_to_5.1.0_postgres.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.postgres.taskana_schema_update_5.0.0_to_5.1.0_postgres.sql Maven / Gradle / Ivy

-- this script updates the TASKANA database schema from version 5.0.0 to version 5.1.0.

SET search_path = %schemaName%;

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

DROP INDEX IF EXISTS IDX_TASK_POR_VALUE;

 CREATE INDEX IDX_TASK_LOWER_POR_VALUE ON TASK
   (LOWER(POR_VALUE) ASC, WORKBASKET_ID ASC);
   COMMIT WORK ;
 CREATE INDEX IDX_TASK_POR_VALUE ON TASK
   (POR_VALUE ASC, WORKBASKET_ID ASC);
   COMMIT WORK ;