DROP TABLE TBL_IDGENRATOR_JINFONET;
CREATE TABLE TBL_IDGENRATOR_JINFONET(TF_NAME VARCHAR(64) NOT NULL,NEXT_ID INTEGER NOT NULL, PRIMARY KEY(TF_NAME));
	INSERT INTO TBL_IDGENRATOR_JINFONET (TF_NAME,NEXT_ID) VALUES ('NODES_2_ID',0);
	INSERT INTO TBL_IDGENRATOR_JINFONET (TF_NAME,NEXT_ID) VALUES ('CATALOGVERSION_2_ID',0);
	INSERT INTO TBL_IDGENRATOR_JINFONET (TF_NAME,NEXT_ID) VALUES ('REPORTVERSION_2_ID',0);
	INSERT INTO TBL_IDGENRATOR_JINFONET (TF_NAME,NEXT_ID) VALUES ('RESULTVERSION_2_ID',0);
	INSERT INTO TBL_IDGENRATOR_JINFONET (TF_NAME,NEXT_ID) VALUES ('ACLS_2_ID',0);
	INSERT INTO TBL_IDGENRATOR_JINFONET (TF_NAME,NEXT_ID) VALUES ('ACLENTRIES_2_ENTRY_ID',0);
	INSERT INTO TBL_IDGENRATOR_JINFONET (TF_NAME,NEXT_ID) VALUES ('COMPLETEDTABLE_3_ID',0);

DROP TABLE NODES_2;
CREATE TABLE NODES_2(ID INTEGER NOT NULL,NAME VARCHAR(64) NOT NULL,CREATORNAME VARCHAR(32) NOT NULL,CREATETIME BIGINT NOT NULL,PARENTID INTEGER NOT NULL,NODETYPE SMALLINT NOT NULL,ACLID INTEGER,DESCRIPTION VARCHAR(256));

DROP TABLE FOLDERS_3;
CREATE TABLE FOLDERS_3(ID INTEGER NOT NULL,REALPATH VARCHAR(256),OWNERNAME VARCHAR(32),MAXVERSIONAMOUNT INTEGER NOT NULL,ARCHIVENEWVERSION SMALLINT NOT NULL,ENABLEARCHIVEPOLICY SMALLINT NOT NULL,IS_SHARED SMALLINT NOT NULL,ENABLEDYNAMICRESOURCE SMALLINT NOT NULL);

DROP TABLE RESOURCENODES_2;
CREATE TABLE RESOURCENODES_2(ID INTEGER NOT NULL,RESOURCETYPE SMALLINT NOT NULL,REALPATH VARCHAR(256),MAXVERSIONAMOUNT INTEGER NOT NULL,ARCHIVENEWVERSION SMALLINT NOT NULL,ENABLEARCHIVEPOLICY SMALLINT NOT NULL);

DROP TABLE VERSIONNODES_2;
CREATE TABLE VERSIONNODES_2(ID INTEGER NOT NULL,RESOURCEID INTEGER NOT NULL,VERSIONNUMBER INTEGER NOT NULL,EXPIRATIONTIME BIGINT NOT NULL);

DROP TABLE CATALOGVERSION_2;
CREATE TABLE CATALOGVERSION_2(VERSIONNUMBER INTEGER NOT NULL,VERSIONNAME VARCHAR(128),RESOURCEID INTEGER NOT NULL,CREATOR VARCHAR(128),CREATEDTIME BIGINT NOT NULL,MODIFIER VARCHAR(128),MODIFIEDTIME BIGINT NOT NULL,CATALOGFILE VARCHAR(128) NOT NULL,ID BIGINT NOT NULL, UNIQUE(ID));

DROP TABLE REPORTVERSION_2;
CREATE TABLE REPORTVERSION_2(VERSIONNUMBER INTEGER NOT NULL,VERSIONNAME VARCHAR(128),RESOURCEID INTEGER NOT NULL,CREATOR VARCHAR(128),CREATETIME BIGINT NOT NULL,MODIFIER VARCHAR(128),MODIFIEDTIME BIGINT NOT NULL,REPORTFILE VARCHAR(128) NOT NULL,ID BIGINT NOT NULL, UNIQUE(RESOURCEID,ID));

DROP TABLE RESULTVERSION_2;
CREATE TABLE RESULTVERSION_2(ID BIGINT NOT NULL,VERSIONNUMBER INTEGER NOT NULL,VERSIONNAME VARCHAR(128) NOT NULL,RESOURCEID INTEGER NOT NULL,CREATOR VARCHAR(128),CREATEDTIME BIGINT NOT NULL,MODIFIER VARCHAR(128),MODIFIEDTIME BIGINT NOT NULL,CATALOGVERNUM INTEGER NOT NULL,CATALOGRESNUM INTEGER NOT NULL,REPORTVERNUM INTEGER NOT NULL,REPORTRESNUM INTEGER NOT NULL,PARAMFILE VARCHAR(128),RESULTFILE VARCHAR(128) NOT NULL,RESULTFMTS BIGINT NOT NULL,LAUNCHTYPE INTEGER NOT NULL,TASKID VARCHAR(128),EXPIRATIONTIME BIGINT NOT NULL,EXPIRE SMALLINT NOT NULL,EXPIREATIONMETHOD INTEGER,SPECIFIEDFOLDER VARCHAR(128),REPORTAMOUNT INTEGER, UNIQUE(ID,RESOURCEID));

DROP TABLE DYNAMICNODE_1;
CREATE TABLE DYNAMICNODE_1(NAME VARCHAR(128) NOT NULL,ROOT VARCHAR(128) NOT NULL,REALPATH VARCHAR(256) NOT NULL,NODETYPE SMALLINT NOT NULL,ENABLEARCHIVEPOLICY SMALLINT NOT NULL,DELETED SMALLINT NOT NULL,ACLID INTEGER,DESCRIPTION VARCHAR(256),MAXVERSIONAMOUNT INTEGER);

DROP TABLE DYNAMICRESULT_1;
CREATE TABLE DYNAMICRESULT_1(ID INTEGER NOT NULL,REPORTNAME VARCHAR(128) NOT NULL,VERSIONNUMBER INTEGER NOT NULL,CREATOR VARCHAR(128) NOT NULL,CREATEDTIME BIGINT NOT NULL,CATALOGVERNUM INTEGER NOT NULL,CATALOGRESNUM INTEGER NOT NULL,REPORTVERNUM INTEGER NOT NULL,REPORTRESNUM INTEGER NOT NULL,PARAMFILE VARCHAR(128),RESULTFILE VARCHAR(128) NOT NULL,RESULTFMTS BIGINT NOT NULL,LAUNCHTYPE INTEGER NOT NULL,TASKID VARCHAR(128),EXPIRATIONTIME BIGINT NOT NULL,EXPIRE SMALLINT NOT NULL,EXPIRATIONMETHOD INTEGER,REPORTAMOUNT INTEGER);

DROP TABLE RESOURCEMAP_1;
CREATE TABLE RESOURCEMAP_1(RESOURCEID INTEGER NOT NULL,RESOURCENAME VARCHAR(128) NOT NULL,RESOURCETYPE SMALLINT NOT NULL);

DROP TABLE USERS_2;
CREATE TABLE USERS_2(NAME VARCHAR(32) NOT NULL,FULL_NAME VARCHAR(128),DESCRIPTION VARCHAR(128),EMAIL VARCHAR(128),CREATE_TIME BIGINT NOT NULL,PASSWORD VARCHAR(128),BUILDIN SMALLINT NOT NULL,ENABLE SMALLINT NOT NULL,MIN_PS_LENGTH INTEGER,LAST_MODIFY_TIME BIGINT,NEVER_EXPIRE SMALLINT NOT NULL,EXPIRE_TIME INTEGER,ACCOUNT_DISABLE SMALLINT NOT NULL,ACCESS_EVENT_SUC SMALLINT NOT NULL,ACCESS_EVENT_FAIL SMALLINT NOT NULL,MANAGEMENT_EVENT_SUC SMALLINT NOT NULL,MANAGEMENT_EVENT_FAIL SMALLINT NOT NULL,NO_AUDIT SMALLINT NOT NULL,AUTH_TYPE INTEGER NOT NULL,LDAP_TYPE INTEGER, PRIMARY KEY(NAME));

DROP TABLE USERPROFILES_2;
CREATE TABLE USERPROFILES_2(USER_NAME VARCHAR(32),ROLE_NAME VARCHAR(32));

DROP TABLE ROLES_2;
CREATE TABLE ROLES_2(NAME VARCHAR(32) NOT NULL,BUILDIN SMALLINT NOT NULL,DESCRIPTION VARCHAR(32),ROLE_TYPE INTEGER NOT NULL, PRIMARY KEY(NAME));

DROP TABLE ACLS_2;
CREATE TABLE ACLS_2(ID INTEGER NOT NULL,NAME VARCHAR(64) NOT NULL,CREATE_NAME VARCHAR(32) NOT NULL,CREATE_TIME BIGINT, PRIMARY KEY(ID));

DROP TABLE ACLENTRIES_2;
CREATE TABLE ACLENTRIES_2(ENTRY_ID INTEGER NOT NULL,ACL_ID INTEGER NOT NULL,PRINCIPAL_TYPE SMALLINT NOT NULL,PRINCIPAL_NAME VARCHAR(64) NOT NULL,IS_POSITIVE SMALLINT NOT NULL,PERMISSIONS INTEGER NOT NULL, PRIMARY KEY(ENTRY_ID));

DROP TABLE ROLEPROFILES_2;
CREATE TABLE ROLEPROFILES_2(ROLE_NAME VARCHAR(32),SUB_ROLE_NAME VARCHAR(32));

DROP TABLE GROUPS_1;
CREATE TABLE GROUPS_1(NAME VARCHAR(32) NOT NULL,BUILDIN SMALLINT NOT NULL,DESCRIPTION VARCHAR(32),GROUP_TYPE INTEGER NOT NULL, PRIMARY KEY(NAME));

DROP TABLE GROUPPROFILES_1;
CREATE TABLE GROUPPROFILES_1(GROUP_NAME VARCHAR(32),SUB_GROUP_NAME VARCHAR(32));

DROP TABLE RGPROFILES_1;
CREATE TABLE RGPROFILES_1(ROLE_NAME VARCHAR(32),GROUP_NAME VARCHAR(32));

DROP TABLE GUPROFILES_1;
CREATE TABLE GUPROFILES_1(GROUP_NAME VARCHAR(32),USER_NAME VARCHAR(32));

DROP TABLE EXTENDACLENTRIES_2;
CREATE TABLE EXTENDACLENTRIES_2(PRINCIPAL_NAME VARCHAR(64) NOT NULL,PRINCIPAL_TYPE SMALLINT NOT NULL,PERMISSIONS INTEGER NOT NULL, UNIQUE(PRINCIPAL_NAME,PRINCIPAL_TYPE));

DROP TABLE COMPLETEDTABLE_3;
CREATE TABLE COMPLETEDTABLE_3(ID INTEGER NOT NULL,RECORDID VARCHAR(128),TASKID VARCHAR(128) NOT NULL,TASKCLASS VARCHAR(256) NOT NULL,CATFILE VARCHAR(256),RPTFILE VARCHAR(256),PARAMFILE VARCHAR(256),RESULTFILE VARCHAR(512),ERROR VARCHAR(256),ENGMSG VARCHAR(512),SUBMITTER VARCHAR(128),COMPLETEDTIME BIGINT,FORMATEXISTS INTEGER,FORMATSUCCESSFUL INTEGER,VERSIONID INTEGER,LAUNCHTYPE INTEGER,ISSUCCESSFUL SMALLINT NOT NULL,TASKNAME VARCHAR(128));