1 # Start of statements added for MSO
3 # End of statements added for MSO
5 create table ACT_ID_GROUP (
11 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
13 create table ACT_ID_MEMBERSHIP (
15 GROUP_ID_ varchar(64),
16 primary key (USER_ID_, GROUP_ID_)
17 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
19 create table ACT_ID_USER (
26 PICTURE_ID_ varchar(64),
28 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
30 create table ACT_ID_INFO (
38 PARENT_ID_ varchar(255),
40 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
42 create table ACT_ID_TENANT (
47 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
49 create table ACT_ID_TENANT_MEMBER (
50 ID_ varchar(64) not null,
51 TENANT_ID_ varchar(64) not null,
53 GROUP_ID_ varchar(64),
55 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
57 alter table ACT_ID_MEMBERSHIP
58 add constraint ACT_FK_MEMB_GROUP
59 foreign key (GROUP_ID_)
60 references ACT_ID_GROUP (ID_);
62 alter table ACT_ID_MEMBERSHIP
63 add constraint ACT_FK_MEMB_USER
64 foreign key (USER_ID_)
65 references ACT_ID_USER (ID_);
67 alter table ACT_ID_TENANT_MEMBER
68 add constraint ACT_UNIQ_TENANT_MEMB_USER
69 unique (TENANT_ID_, USER_ID_);
71 alter table ACT_ID_TENANT_MEMBER
72 add constraint ACT_UNIQ_TENANT_MEMB_GROUP
73 unique (TENANT_ID_, GROUP_ID_);
75 alter table ACT_ID_TENANT_MEMBER
76 add constraint ACT_FK_TENANT_MEMB
77 foreign key (TENANT_ID_)
78 references ACT_ID_TENANT (ID_);
80 alter table ACT_ID_TENANT_MEMBER
81 add constraint ACT_FK_TENANT_MEMB_USER
82 foreign key (USER_ID_)
83 references ACT_ID_USER (ID_);
85 alter table ACT_ID_TENANT_MEMBER
86 add constraint ACT_FK_TENANT_MEMB_GROUP
87 foreign key (GROUP_ID_)
88 references ACT_ID_GROUP (ID_);