summaryrefslogtreecommitdiffstats
path: root/kubernetes/config/docker/init/src/config/mso/mariadb/docker-entrypoint-initdb.d/db-sql-scripts/camunda/mysql_updates_7.3.0.sql
blob: 09c53ea059c43a81fb480bd1f15ed30d8893b953 (plain)
1
2
3
4
5
6
7
8
9
10
11
# MSO updates to the default camunda schema.
USE `camundabpmn`;
ALTER TABLE ACT_HI_VARINST MODIFY TEXT_ LONGTEXT;

ALTER TABLE ACT_HI_DETAIL MODIFY TEXT_ LONGTEXT;

ALTER TABLE ACT_RU_VARIABLE MODIFY TEXT_ LONGTEXT;

INSERT INTO ACT_GE_PROPERTY VALUES ('historyLevel','3',1) ON DUPLICATE KEY UPDATE VALUE_='3';

CREATE TABLE IF NOT EXISTS ATT_URN_MAPPING AS SELECT * FROM ACT_GE_PROPERTY WHERE NAME_='-';