onap on kubernetes source files

[oom.git] / kubernetes / config / docker / init / src / config / mso / mariadb / docker-entrypoint-initdb.d / db-sql-scripts / camunda / mysql_updates_7.3.0.sql

diff --git a/kubernetes/config/docker/init/src/config/mso/mariadb/docker-entrypoint-initdb.d/db-sql-scripts/camunda/mysql_updates_7.3.0.sql b/kubernetes/config/docker/init/src/config/mso/mariadb/docker-entrypoint-initdb.d/db-sql-scripts/camunda/mysql_updates_7.3.0.sql
new file mode 100755 (executable)
index 0000000..09c53ea
--- /dev/null
+++ b/kubernetes/config/docker/init/src/config/mso/mariadb/docker-entrypoint-initdb.d/db-sql-scripts/camunda/mysql_updates_7.3.0.sql
@@ -0,0 +1,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_='-';