2 -- Copyright © 2012 - 2018 camunda services GmbH and various authors (info@camunda.com)
4 -- Licensed under the Apache License, Version 2.0 (the "License");
5 -- you may not use this file except in compliance with the License.
6 -- You may obtain a copy of the License at
8 -- http://www.apache.org/licenses/LICENSE-2.0
10 -- Unless required by applicable law or agreed to in writing, software
11 -- distributed under the License is distributed on an "AS IS" BASIS,
12 -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
13 -- See the License for the specific language governing permissions and
14 -- limitations under the License.
19 create table ACT_ID_GROUP (
25 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
27 create table ACT_ID_MEMBERSHIP (
29 GROUP_ID_ varchar(64),
30 primary key (USER_ID_, GROUP_ID_)
31 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
33 create table ACT_ID_USER (
41 LOCK_EXP_TIME_ timestamp(3) NULL,
43 PICTURE_ID_ varchar(64),
45 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
47 create table ACT_ID_INFO (
55 PARENT_ID_ varchar(255),
57 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
59 create table ACT_ID_TENANT (
64 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
66 create table ACT_ID_TENANT_MEMBER (
67 ID_ varchar(64) not null,
68 TENANT_ID_ varchar(64) not null,
70 GROUP_ID_ varchar(64),
72 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
74 alter table ACT_ID_MEMBERSHIP
75 add constraint ACT_FK_MEMB_GROUP
76 foreign key (GROUP_ID_)
77 references ACT_ID_GROUP (ID_);
79 alter table ACT_ID_MEMBERSHIP
80 add constraint ACT_FK_MEMB_USER
81 foreign key (USER_ID_)
82 references ACT_ID_USER (ID_);
84 alter table ACT_ID_TENANT_MEMBER
85 add constraint ACT_UNIQ_TENANT_MEMB_USER
86 unique (TENANT_ID_, USER_ID_);
88 alter table ACT_ID_TENANT_MEMBER
89 add constraint ACT_UNIQ_TENANT_MEMB_GROUP
90 unique (TENANT_ID_, GROUP_ID_);
92 alter table ACT_ID_TENANT_MEMBER
93 add constraint ACT_FK_TENANT_MEMB
94 foreign key (TENANT_ID_)
95 references ACT_ID_TENANT (ID_);
97 alter table ACT_ID_TENANT_MEMBER
98 add constraint ACT_FK_TENANT_MEMB_USER
99 foreign key (USER_ID_)
100 references ACT_ID_USER (ID_);
102 alter table ACT_ID_TENANT_MEMBER
103 add constraint ACT_FK_TENANT_MEMB_GROUP
104 foreign key (GROUP_ID_)
105 references ACT_ID_GROUP (ID_);