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 alter table ACT_ID_MEMBERSHIP
43 add constraint ACT_FK_MEMB_GROUP
44 foreign key (GROUP_ID_)
45 references ACT_ID_GROUP (ID_);
47 alter table ACT_ID_MEMBERSHIP
48 add constraint ACT_FK_MEMB_USER
49 foreign key (USER_ID_)
50 references ACT_ID_USER (ID_);