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