| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546 | 
							- create table ACT_ID_GROUP (
 
-     ID_ varchar(64),
 
-     REV_ integer,
 
-     NAME_ varchar(255),
 
-     TYPE_ varchar(255),
 
-     primary key (ID_)
 
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
 
- create table ACT_ID_MEMBERSHIP (
 
-     USER_ID_ varchar(64),
 
-     GROUP_ID_ varchar(64),
 
-     primary key (USER_ID_, GROUP_ID_)
 
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
 
- 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_)
 
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
 
- create table ACT_ID_INFO (
 
-     ID_ varchar(64),
 
-     REV_ integer,
 
-     USER_ID_ varchar(64),
 
-     TYPE_ varchar(64),
 
-     KEY_ varchar(255),
 
-     VALUE_ varchar(255),
 
-     PASSWORD_ LONGBLOB,
 
-     PARENT_ID_ varchar(255),
 
-     primary key (ID_)
 
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
 
- alter table ACT_ID_MEMBERSHIP 
 
-     add constraint ACT_FK_MEMB_GROUP 
 
-     foreign key (GROUP_ID_) 
 
-     references ACT_ID_GROUP (ID_);
 
- alter table ACT_ID_MEMBERSHIP 
 
-     add constraint ACT_FK_MEMB_USER 
 
-     foreign key (USER_ID_) 
 
-     references ACT_ID_USER (ID_);
 
 
  |