| 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_);
 
 
  |