| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748 | 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_ bytea,    PARENT_ID_ varchar(255),    primary key (ID_));create index ACT_IDX_MEMB_GROUP on ACT_ID_MEMBERSHIP(GROUP_ID_);alter table ACT_ID_MEMBERSHIP     add constraint ACT_FK_MEMB_GROUP    foreign key (GROUP_ID_)     references ACT_ID_GROUP (ID_);create index ACT_IDX_MEMB_USER on ACT_ID_MEMBERSHIP(USER_ID_);alter table ACT_ID_MEMBERSHIP     add constraint ACT_FK_MEMB_USER    foreign key (USER_ID_)     references ACT_ID_USER (ID_);
 |