| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748 | create table ACT_ID_GROUP (    ID_ NVARCHAR2(64),    REV_ INTEGER,    NAME_ NVARCHAR2(255),    TYPE_ NVARCHAR2(255),    primary key (ID_));create table ACT_ID_MEMBERSHIP (    USER_ID_ NVARCHAR2(64),    GROUP_ID_ NVARCHAR2(64),    primary key (USER_ID_, GROUP_ID_));create table ACT_ID_USER (    ID_ NVARCHAR2(64),    REV_ INTEGER,    FIRST_ NVARCHAR2(255),    LAST_ NVARCHAR2(255),    EMAIL_ NVARCHAR2(255),    PWD_ NVARCHAR2(255),    PICTURE_ID_ NVARCHAR2(64),    primary key (ID_));create table ACT_ID_INFO (    ID_ NVARCHAR2(64),    REV_ INTEGER,    USER_ID_ NVARCHAR2(64),    TYPE_ NVARCHAR2(64),    KEY_ NVARCHAR2(255),    VALUE_ NVARCHAR2(255),    PASSWORD_ BLOB,    PARENT_ID_ NVARCHAR2(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_);
 |