updating helm/docker files and database config files

[it/otf.git] / otf-helm / otf / charts / databases / charts / mysqldb / scripts / mysql_identity_7.10.0.sql

diff --git a/otf-helm/otf/charts/databases/charts/mysqldb/scripts/mysql_identity_7.10.0.sql b/otf-helm/otf/charts/databases/charts/mysqldb/scripts/mysql_identity_7.10.0.sql
deleted file mode 100644 (file)
index 113240d..0000000
--- a/otf-helm/otf/charts/databases/charts/mysqldb/scripts/mysql_identity_7.10.0.sql
+++ /dev/null
@@ -1,103 +0,0 @@
---\r
--- Copyright © 2012 - 2018 camunda services GmbH and various authors (info@camunda.com)\r
---\r
--- Licensed under the Apache License, Version 2.0 (the "License");\r
--- you may not use this file except in compliance with the License.\r
--- You may obtain a copy of the License at\r
---\r
---     http://www.apache.org/licenses/LICENSE-2.0\r
---\r
--- Unless required by applicable law or agreed to in writing, software\r
--- distributed under the License is distributed on an "AS IS" BASIS,\r
--- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.\r
--- See the License for the specific language governing permissions and\r
--- limitations under the License.\r
---\r
-\r
-create table ACT_ID_GROUP (\r
-    ID_ varchar(64),\r
-    REV_ integer,\r
-    NAME_ varchar(255),\r
-    TYPE_ varchar(255),\r
-    primary key (ID_)\r
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;\r
-\r
-create table ACT_ID_MEMBERSHIP (\r
-    USER_ID_ varchar(64),\r
-    GROUP_ID_ varchar(64),\r
-    primary key (USER_ID_, GROUP_ID_)\r
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;\r
-\r
-create table ACT_ID_USER (\r
-    ID_ varchar(64),\r
-    REV_ integer,\r
-    FIRST_ varchar(255),\r
-    LAST_ varchar(255),\r
-    EMAIL_ varchar(255),\r
-    PWD_ varchar(255),\r
-    SALT_ varchar(255),\r
-    LOCK_EXP_TIME_ timestamp NULL,\r
-    ATTEMPTS_ integer,\r
-    PICTURE_ID_ varchar(64),\r
-    primary key (ID_)\r
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;\r
-\r
-create table ACT_ID_INFO (\r
-    ID_ varchar(64),\r
-    REV_ integer,\r
-    USER_ID_ varchar(64),\r
-    TYPE_ varchar(64),\r
-    KEY_ varchar(255),\r
-    VALUE_ varchar(255),\r
-    PASSWORD_ LONGBLOB,\r
-    PARENT_ID_ varchar(255),\r
-    primary key (ID_)\r
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;\r
-\r
-create table ACT_ID_TENANT (\r
-    ID_ varchar(64),\r
-    REV_ integer,\r
-    NAME_ varchar(255),\r
-    primary key (ID_)\r
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;\r
-\r
-create table ACT_ID_TENANT_MEMBER (\r
-    ID_ varchar(64) not null,\r
-    TENANT_ID_ varchar(64) not null,\r
-    USER_ID_ varchar(64),\r
-    GROUP_ID_ varchar(64),\r
-    primary key (ID_)\r
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;\r
-\r
-alter table ACT_ID_MEMBERSHIP\r
-    add constraint ACT_FK_MEMB_GROUP\r
-    foreign key (GROUP_ID_)\r
-    references ACT_ID_GROUP (ID_);\r
-\r
-alter table ACT_ID_MEMBERSHIP\r
-    add constraint ACT_FK_MEMB_USER\r
-    foreign key (USER_ID_)\r
-    references ACT_ID_USER (ID_);\r
-\r
-alter table ACT_ID_TENANT_MEMBER\r
-    add constraint ACT_UNIQ_TENANT_MEMB_USER\r
-    unique (TENANT_ID_, USER_ID_);\r
-\r
-alter table ACT_ID_TENANT_MEMBER\r
-    add constraint ACT_UNIQ_TENANT_MEMB_GROUP\r
-    unique (TENANT_ID_, GROUP_ID_);\r
-\r
-alter table ACT_ID_TENANT_MEMBER\r
-    add constraint ACT_FK_TENANT_MEMB\r
-    foreign key (TENANT_ID_)\r
-    references ACT_ID_TENANT (ID_);\r
-\r
-alter table ACT_ID_TENANT_MEMBER\r
-    add constraint ACT_FK_TENANT_MEMB_USER\r
-    foreign key (USER_ID_)\r
-    references ACT_ID_USER (ID_);\r
-\r
-alter table ACT_ID_TENANT_MEMBER\r
-    add constraint ACT_FK_TENANT_MEMB_GROUP\r
-    foreign key (GROUP_ID_)\r
-    references ACT_ID_GROUP (ID_);\r