| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546 | create table ACT_ID_GROUP (  ID_ varchar(64),  REV_ integer,  NAME_ varchar(255),  TYPE_ varchar(255),  primary key (ID_));create table ACT_ID_MEMBERSHIP (  USER_ID_ varchar(64),  GROUP_ID_ varchar(64),  primary key (USER_ID_, GROUP_ID_));create table ACT_ID_USER (  ID_ varchar(64),  REV_ integer,  FIRST_ varchar(255),  LAST_ varchar(255),  EMAIL_ varchar(255),  PWD_ varchar(255),  PICTURE_ID_ varchar(64),  primary key (ID_));create table ACT_ID_INFO (  ID_ varchar(64),  REV_ integer,  USER_ID_ varchar(64),  TYPE_ varchar(64),  KEY_ varchar(255),  VALUE_ varchar(255),  PASSWORD_ longvarbinary,  PARENT_ID_ varchar(255),  primary key (ID_));alter table ACT_ID_MEMBERSHIPadd constraint ACT_FK_MEMB_GROUPforeign key (GROUP_ID_)references ACT_ID_GROUP;alter table ACT_ID_MEMBERSHIPadd constraint ACT_FK_MEMB_USERforeign key (USER_ID_)references ACT_ID_USER;
 |