summaryrefslogtreecommitdiffstats
path: root/packages/root-pack-extras/config-resources/mariadb/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_='-';