/*==============================================================*/
/* DBMS name:      Microsoft SQL Server 2000                    */
/* Created on:     2006-9-1 13:33:14                            */
/*==============================================================*/


if exists (select 1
            from  sysobjects
           where  id = object_id('ACLENTRIES_2')
            and   type = 'U')
   drop table ACLENTRIES_2
go

if exists (select 1
            from  sysobjects
           where  id = object_id('ACLS_2')
            and   type = 'U')
   drop table ACLS_2
go

if exists (select 1
            from  sysobjects
           where  id = object_id('ACLS_WITH_RESOURCE_1')
            and   type = 'U')
   drop table ACLS_WITH_RESOURCE_1
go

if exists (select 1
            from  sysobjects
           where  id = object_id('ALIASES_1')
            and   type = 'U')
   drop table ALIASES_1
go

if exists (select 1
            from  sysobjects
           where  id = object_id('CATALOGVERSION_2')
            and   type = 'U')
   drop table CATALOGVERSION_2
go

if exists (select 1
            from  sysobjects
           where  id = object_id('COMPLETEDPUBLISHTABLE_2')
            and   type = 'U')
   drop table COMPLETEDPUBLISHTABLE_2
go

if exists (select 1
            from  sysobjects
           where  id = object_id('COMPLETEDRESULTTABLE_3')
            and   type = 'U')
   drop table COMPLETEDRESULTTABLE_3
go

if exists (select 1
            from  sysobjects
           where  id = object_id('COMPLETEDTABLE_4')
            and   type = 'U')
   drop table COMPLETEDTABLE_4
go

if exists (select 1
            from  sysobjects
           where  id = object_id('DRESULT_2')
            and   type = 'U')
   drop table DRESULT_2
go

if exists (select 1
            from  sysobjects
           where  id = object_id('DYNAMICNODE_2')
            and   type = 'U')
   drop table DYNAMICNODE_2
go

if exists (select 1
            from  sysobjects
           where  id = object_id('DYNAMICRESULT_1')
            and   type = 'U')
   drop table DYNAMICRESULT_1
go

if exists (select 1
            from  sysobjects
           where  id = object_id('EXTENDACLENTRIES_2')
            and   type = 'U')
   drop table EXTENDACLENTRIES_2
go

if exists (select 1
            from  sysobjects
           where  id = object_id('FOLDERS_3')
            and   type = 'U')
   drop table FOLDERS_3
go

if exists (select 1
            from  sysobjects
           where  id = object_id('GROUPPROFILES_1')
            and   type = 'U')
   drop table GROUPPROFILES_1
go

if exists (select 1
            from  sysobjects
           where  id = object_id('GROUPS_1')
            and   type = 'U')
   drop table GROUPS_1
go

if exists (select 1
            from  sysobjects
           where  id = object_id('GUPROFILES_1')
            and   type = 'U')
   drop table GUPROFILES_1
go

if exists (select 1
            from  sysobjects
           where  id = object_id('NODES_3')
            and   type = 'U')
   drop table NODES_3
go

if exists (select 1
            from  sysobjects
           where  id = object_id('REPORTVERSION_2')
            and   type = 'U')
   drop table REPORTVERSION_2
go

if exists (select 1
            from  sysobjects
           where  id = object_id('RESOURCEMAP_1')
            and   type = 'U')
   drop table RESOURCEMAP_1
go

if exists (select 1
            from  sysobjects
           where  id = object_id('RESOURCENODES_3')
            and   type = 'U')
   drop table RESOURCENODES_3
go

if exists (select 1
            from  sysobjects
           where  id = object_id('RESULTVERSION_2')
            and   type = 'U')
   drop table RESULTVERSION_2
go

if exists (select 1
            from  sysobjects
           where  id = object_id('RESULT_2')
            and   type = 'U')
   drop table RESULT_2
go

if exists (select 1
            from  sysobjects
           where  id = object_id('RGPROFILES_1')
            and   type = 'U')
   drop table RGPROFILES_1
go

if exists (select 1
            from  sysobjects
           where  id = object_id('ROLEPROFILES_2')
            and   type = 'U')
   drop table ROLEPROFILES_2
go

if exists (select 1
            from  sysobjects
           where  id = object_id('ROLES_2')
            and   type = 'U')
   drop table ROLES_2
go

if exists (select 1
            from  sysobjects
           where  id = object_id('SCHDLASTEXETIME_1')
            and   type = 'U')
   drop table SCHDLASTEXETIME_1
go

if exists (select 1
            from  sysobjects
           where  id = object_id('TBL_IDGENRATOR_JINFONET')
            and   type = 'U')
   drop table TBL_IDGENRATOR_JINFONET
go

if exists (select 1
            from  sysobjects
           where  id = object_id('TRIGGERS_1')
            and   type = 'U')
   drop table TRIGGERS_1
go

if exists (select 1
            from  sysobjects
           where  id = object_id('UPDATEDETAILS_1')
            and   type = 'U')
   drop table UPDATEDETAILS_1
go

if exists (select 1
            from  sysobjects
           where  id = object_id('USERPROFILES_2')
            and   type = 'U')
   drop table USERPROFILES_2
go

if exists (select 1
            from  sysobjects
           where  id = object_id('USERS_3')
            and   type = 'U')
   drop table USERS_3
go

if exists (select 1
            from  sysobjects
           where  id = object_id('VERSIONNODES_2')
            and   type = 'U')
   drop table VERSIONNODES_2
go

if exists (select 1
            from  sysobjects
           where  id = object_id('TASKCONTEXT')
            and   type = 'U')
   drop table TASKCONTEXT
go


/*==============================================================*/
/* Table: ACLENTRIES_2                                          */
/*==============================================================*/
create table ACLENTRIES_2 (
   ENTRY_ID             INTEGER              not null,
   ACL_ID               INTEGER              not null,
   PRINCIPAL_TYPE       TINYINT              not null,
   PRINCIPAL_NAME       VARCHAR(64)          not null,
   IS_POSITIVE          BIT                  not null,
   PERMISSIONS          INTEGER              not null,
   constraint PK_ACLENTRIES_2 primary key (ENTRY_ID)
)
go

/*==============================================================*/
/* 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               null,
   constraint PK_ACLS_2 primary key (ID)
)
go

/*==============================================================*/
/* Table: ACLS_WITH_RESOURCE_1                                  */
/*==============================================================*/
create table ACLS_WITH_RESOURCE_1 (
   ID                   INTEGER              not null,
   RESOURCE_PATH        VARCHAR(256)         not null,
   VERSION_NUMBER       INTEGER              not null,
   ACL_NAME             VARCHAR(64)          not null,
   CREATE_NAME          VARCHAR(32)          not null,
   CREATE_TIME          BIGINT               null,
   constraint PK_ACLS_WITH_RESOURCE_1 primary key (ID)
)
go

/*==============================================================*/
/* Table: ALIASES_1                                             */
/*==============================================================*/
create table ALIASES_1 (
   ID                   INTEGER              not null,
   PRINCIPAL_NAME       VARCHAR(128)         not null,
   PRINCIPAL_TYPE       TINYINT              not null,
   ALIAS_NAME           VARCHAR(256)         not null,
   PARENT_NAME          VARCHAR(256)         null,
   MAP_RESOURCE         VARCHAR(256)         not null,
   HIDDEN               BIT                  not null,
   constraint AK_KEY_1_ALIASES_ unique (ID)
)
go

/*==============================================================*/
/* Table: CATALOGVERSION_2                                      */
/*==============================================================*/
create table CATALOGVERSION_2 (
   VERSIONNUMBER        INTEGER              not null,
   VERSIONNAME          VARCHAR(128)         null,
   RESOURCEID           INTEGER              not null,
   CREATOR              VARCHAR(128)         null,
   CREATEDTIME          BIGINT               not null,
   MODIFIER             VARCHAR(128)         null,
   MODIFIEDTIME         BIGINT               not null,
   CATALOGFILE          VARCHAR(128)         not null,
   ID                   BIGINT               not null,
   constraint AK_KEY_1_CATALOGV unique (ID)
)
go

/*==============================================================*/
/* Table: COMPLETEDPUBLISHTABLE_2                               */
/*==============================================================*/
create table COMPLETEDPUBLISHTABLE_2 (
   ID                   INTEGER              not null,
   RECORDID             VARCHAR(40)          not null,
   SHEETNAME            VARCHAR(256)         not null,
   DISPLAYNAME          VARCHAR(256)         null,
   PUB_TYPE             VARCHAR(64)          not null
)
go

/*==============================================================*/
/* Table: COMPLETEDRESULTTABLE_3                                */
/*==============================================================*/
create table COMPLETEDRESULTTABLE_3 (
   PUBLISHID            INTEGER              not null,
   RECORDID             VARCHAR(40)          not null,
   PUB_TYPE             VARCHAR(128)          not null,
   STATUS               INTEGER              not null,
   DETAIL               VARCHAR(256)         not null
)
go

/*==============================================================*/
/* Table: COMPLETEDTABLE_4                                      */
/*==============================================================*/
create table COMPLETEDTABLE_4 (
   ID                   INTEGER              not null,
   RECORDID             VARCHAR(128)         null,
   TASKID               VARCHAR(128)         not null,
   TASKCLASS            VARCHAR(256)         not null,
   CATFILE              VARCHAR(256)         null,
   RPTFILE              VARCHAR(256)         null,
   PARAMFILE            VARCHAR(256)         null,
   RESULTFILE           VARCHAR(512)         null,
   ERROR                VARCHAR(256)         null,
   ENGMSG               VARCHAR(512)         null,
   SUBMITTER            VARCHAR(128)         null,
   COMPLETEDTIME        BIGINT               null,
   FORMATEXISTS         INTEGER              null,
   FORMATSUCCESSFUL     INTEGER              null,
   VERSIONID            INTEGER              null,
   LAUNCHTYPE           INTEGER              null,
   ISSUCCESSFUL         BIT                  not null,
   TASKNAME             VARCHAR(128)         null,
   ISMISSED             BIT                  not null,
   SCHEDULETRIGGER      VARCHAR(80)          null,
   CONDITIONSLOGIC      VARCHAR(16)          null,
   REPORTNAMES          VARCHAR(512)         null
)
go

/*==============================================================*/
/* Table: DRESULT_2                                             */
/*==============================================================*/
create table DRESULT_2 (
   REPORTSET            VARCHAR(128)         null,
   VERSIONNUMBER        BIGINT               not null,
   REPORT               VARCHAR(128)         not null,
   REPORTDISPLAYNAME    VARCHAR(128)         null,
   RESULT               VARCHAR(128)         not null,
   VIEWEDFORMATS        BIGINT               null,
   PLSRESULTFMTS        BIGINT               null,
   SECCONSTRAINTFMTS    BIGINT               null
)
go

/*==============================================================*/
/* Table: DYNAMICNODE_2                                         */
/*==============================================================*/
create table DYNAMICNODE_2 (
   NAME                 VARCHAR(128)         not null,
   ROOT                 VARCHAR(128)         not null,
   REALPATH             VARCHAR(256)         not null,
   NODETYPE             TINYINT              not null,
   ENABLEARCHIVEPOLICY  BIT                  not null,
   DELETED              BIT                  not null,
   ACLID                INTEGER              null,
   DESCRIPTION          VARCHAR(256)         null,
   MAXVERSIONAMOUNT     INTEGER              null,
   ENABLELINKEDCAT      BIT		             null, 
   LINKEDCAT            VARCHAR(256)         null, 
   USEINHERITED         BIT		             null
)
go

/*==============================================================*/
/* 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)         null,
   RESULTFILE           VARCHAR(128)         not null,
   RESULTFMTS           BIGINT               not null,
   LAUNCHTYPE           INTEGER              not null,
   TASKID               VARCHAR(128)         null,
   EXPIRATIONTIME       BIGINT               not null,
   EXPIRE               BIT                  not null,
   EXPIRATIONMETHOD     INTEGER              null,
   REPORTAMOUNT         INTEGER              null
)
go

/*==============================================================*/
/* Table: EXTENDACLENTRIES_2                                    */
/*==============================================================*/
create table EXTENDACLENTRIES_2 (
   PRINCIPAL_NAME       VARCHAR(64)          not null,
   PRINCIPAL_TYPE       TINYINT              not null,
   PERMISSIONS          INTEGER              not null,
   constraint AK_KEY_1_EXTENDAC unique (PRINCIPAL_NAME, PRINCIPAL_TYPE)
)
go

/*==============================================================*/
/* Table: FOLDERS_3                                             */
/*==============================================================*/
create table FOLDERS_3 (
   ID                   INTEGER              not null,
   REALPATH             VARCHAR(256)         null,
   OWNERNAME            VARCHAR(32)          null,
   MAXVERSIONAMOUNT     INTEGER              not null,
   ARCHIVENEWVERSION    BIT                  not null,
   ENABLEARCHIVEPOLICY  BIT                  not null,
   IS_SHARED            BIT                  not null,
   ENABLEDYNAMICRESOURCE BIT                  not null
)
go

/*==============================================================*/
/* Table: GROUPPROFILES_1                                       */
/*==============================================================*/
create table GROUPPROFILES_1 (
   GROUP_NAME           VARCHAR(32)          null,
   SUB_GROUP_NAME       VARCHAR(32)          null
)
go

/*==============================================================*/
/* Table: GROUPS_1                                              */
/*==============================================================*/
create table GROUPS_1 (
   NAME                 VARCHAR(32)          not null,
   BUILDIN              BIT                  not null,
   DESCRIPTION          VARCHAR(32)          null,
   GROUP_TYPE           INTEGER              not null,
   constraint PK_GROUPS_1 primary key (NAME)
)
go

/*==============================================================*/
/* Table: GUPROFILES_1                                          */
/*==============================================================*/
create table GUPROFILES_1 (
   GROUP_NAME           VARCHAR(32)          null,
   USER_NAME            VARCHAR(32)          null
)
go

/*==============================================================*/
/* Table: NODES_3                                               */
/*==============================================================*/
create table NODES_3 (
   ID                   INTEGER              not null,
   NAME                 VARCHAR(64)          not null,
   CREATORNAME          VARCHAR(32)          not null,
   CREATETIME           BIGINT               not null,
   PARENTID             INTEGER              not null,
   NODETYPE             TINYINT              not null,
   ACLID                INTEGER              null,
   DESCRIPTION          VARCHAR(256)         null,
   ENABLELINKEDCAT      BIT, 
   LINKEDCAT            VARCHAR(256), 
   USEINHERITED         BIT
)
go

/*==============================================================*/
/* Table: REPORTVERSION_2                                       */
/*==============================================================*/
create table REPORTVERSION_2 (
   VERSIONNUMBER        INTEGER              not null,
   VERSIONNAME          VARCHAR(128)         null,
   RESOURCEID           INTEGER              not null,
   CREATOR              VARCHAR(128)         null,
   CREATETIME           BIGINT               not null,
   MODIFIER             VARCHAR(128)         null,
   MODIFIEDTIME         BIGINT               not null,
   REPORTFILE           VARCHAR(128)         not null,
   ID                   BIGINT               not null,
   constraint AK_KEY_1_REPORTVE unique (RESOURCEID, ID)
)
go

/*==============================================================*/
/* Table: RESOURCEMAP_1                                         */
/*==============================================================*/
create table RESOURCEMAP_1 (
   RESOURCEID           INTEGER              not null,
   RESOURCENAME         VARCHAR(128)         not null,
   RESOURCETYPE         TINYINT              not null
)
go

/*==============================================================*/
/* Table: RESOURCENODES_3                                       */
/*==============================================================*/
create table RESOURCENODES_3 (
   ID                   INTEGER              not null,
   RESOURCETYPE         TINYINT              not null,
   REALPATH             VARCHAR(256)         null,
   MAXVERSIONAMOUNT     INTEGER              not null,
   ARCHIVENEWVERSION    BIT                  not null,
   ENABLEARCHIVEPOLICY  BIT                  not null,
   PROFILENAME             VARCHAR(256)         null
)
go

/*==============================================================*/
/* 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)         null,
   CREATEDTIME          BIGINT               not null,
   MODIFIER             VARCHAR(128)         null,
   MODIFIEDTIME         BIGINT               not null,
   CATALOGVERNUM        INTEGER              not null,
   CATALOGRESNUM        INTEGER              not null,
   REPORTVERNUM         INTEGER              not null,
   REPORTRESNUM         INTEGER              not null,
   PARAMFILE            VARCHAR(128)         null,
   RESULTFILE           VARCHAR(128)         not null,
   RESULTFMTS           BIGINT               not null,
   LAUNCHTYPE           INTEGER              not null,
   TASKID               VARCHAR(128)         null,
   EXPIRATIONTIME       BIGINT               not null,
   EXPIRE               BIT                  not null,
   EXPIREATIONMETHOD    INTEGER              null,
   SPECIFIEDFOLDER      VARCHAR(128)         null,
   REPORTAMOUNT         INTEGER              null,
   constraint AK_KEY_1_RESULTVE unique (ID, RESOURCEID)
)
go

/*==============================================================*/
/* Table: RESULT_2                                              */
/*==============================================================*/
create table RESULT_2 (
   RESOURCEID           BIGINT               not null,
   VERSIONNUMBER        BIGINT               not null,
   REPORT               VARCHAR(128)         not null,
   REPORTDISPLAYNAME    VARCHAR(128)         null,
   RESULT               VARCHAR(128)         not null,
   VIEWEDFORMATS        BIGINT               null,
   PLSRESULTFMTS        BIGINT               null,
   SECCONSTRAINTFMTS    BIGINT               null
)
go

/*==============================================================*/
/* Table: RGPROFILES_1                                          */
/*==============================================================*/
create table RGPROFILES_1 (
   ROLE_NAME            VARCHAR(32)          null,
   GROUP_NAME           VARCHAR(32)          null
)
go

/*==============================================================*/
/* Table: ROLEPROFILES_2                                        */
/*==============================================================*/
create table ROLEPROFILES_2 (
   ROLE_NAME            VARCHAR(32)          null,
   SUB_ROLE_NAME        VARCHAR(32)          null
)
go

/*==============================================================*/
/* Table: ROLES_2                                               */
/*==============================================================*/
create table ROLES_2 (
   NAME                 VARCHAR(32)          not null,
   BUILDIN              BIT                  not null,
   DESCRIPTION          VARCHAR(32)          null,
   ROLE_TYPE            INTEGER              not null,
   constraint PK_ROLES_2 primary key (NAME)
)
go

/*==============================================================*/
/* Table: SCHDLASTEXETIME_1                                     */
/*==============================================================*/
create table SCHDLASTEXETIME_1 (
   TASKID               VARCHAR(40)          not null,
   LASTEXETIME          BIGINT               not null
)
go

/*==============================================================*/
/* Table: TBL_IDGENRATOR_JINFONET                               */
/*==============================================================*/
create table TBL_IDGENRATOR_JINFONET (
   TF_NAME              varchar(64)          not null,
   NEXT_ID              int                  not null,
   constraint PK_TBL_IDGENRATOR_JINFONET primary key (TF_NAME)
)
go

/*==============================================================*/
/* Table: TRIGGERS_1                                            */
/*==============================================================*/
create table TRIGGERS_1 (
   TRIGGER_NAME         VARCHAR(80)          not null,
   DESCRIPTION          VARCHAR(255)         null,
   TRIGGER_TYPE         TINYINT              not null,
   TRIGGER_STATE        BIT                  not null,
   PREV_FIRE_TIME       BIGINT               null,
   NEXT_FIRE_TIME       BIGINT               null,
   constraint PK_TRIGGERS_1 primary key (TRIGGER_NAME)
)
go

/*==============================================================*/
/* Table: UPDATEDETAILS_1                                       */
/*==============================================================*/
create table UPDATEDETAILS_1 (
   UPDATE_ITEM          VARCHAR(32)          not null,
   UPDATE_STATE         BIT                  not null,
   constraint PK_UPDATEDETAILS_1 primary key (UPDATE_ITEM)
)
go

/*==============================================================*/
/* Table: USERPROFILES_2                                        */
/*==============================================================*/
create table USERPROFILES_2 (
   USER_NAME            VARCHAR(32)          null,
   ROLE_NAME            VARCHAR(32)          null
)
go

/*==============================================================*/
/* Table: USERS_3                                               */
/*==============================================================*/
create table USERS_3 (
   NAME                 VARCHAR(32)          not null,
   FULL_NAME            VARCHAR(128)         null,
   DESCRIPTION          VARCHAR(128)         null,
   EMAIL                VARCHAR(128)         null,
   CREATE_TIME          BIGINT               not null,
   USER_PSWD            VARCHAR(128)         null,
   BUILDIN              BIT                  not null,
   ENABLE               BIT                  not null,
   MIN_PS_LENGTH        INTEGER              null,
   LAST_MODIFY_TIME     BIGINT               null,
   NEVER_EXPIRE         BIT                  not null,
   EXPIRE_TIME          INTEGER              null,
   ACCOUNT_DISABLE      BIT                  not null,
   ACCESS_EVENT_SUC     BIT                  not null,
   ACCESS_EVENT_FAIL    BIT                  not null,
   MANAGEMENT_EVENT_SUC BIT                  not null,
   MANAGEMENT_EVENT_FAIL BIT                  not null,
   NO_AUDIT             BIT                  not null,
   AUTH_TYPE            INTEGER              not null,
   LDAP_TYPE            INTEGER              null,
   constraint PK_USERS_3 primary key (NAME)
)
go

/*==============================================================*/
/* Table: VERSIONNODES_2                                        */
/*==============================================================*/
create table VERSIONNODES_2 (
   ID                   INTEGER              not null,
   RESOURCEID           INTEGER              not null,
   VERSIONNUMBER        INTEGER              not null,
   EXPIRATIONTIME       BIGINT               not null
)
go


/*==============================================================*/
/* Table: TASKCONTEXT                                        */
/*==============================================================*/
CREATE TABLE TASKCONTEXT (
	ID 					INTEGER NOT NULL,
	VS_RPT_NAME 		VARCHAR(255),
	VI_TSK_TYPE 		INTEGER,
	VI_TSK_STATUS 		INTEGER,
	TS_TSK_SUBMIT 		DATETIME,
	TS_ENG_START 		DATETIME,
	TS_ENG_EXITS 		DATETIME,
	TS_TSK_COMPLETE 	DATETIME,
	TC_TSK_TOTAL 		BIGINT,
	TC_TSK_WAITED 		BIGINT,
	TC_ENG_TOTAL 		BIGINT,
	TC_ENG_LOAD 		BIGINT,
	TC_ENG_EXPORT 		BIGINT,
	TC_ENG_OTHER 		BIGINT,
	TC_TSK_OTHER 		BIGINT,
	NC_RPT_PAGES 		BIGINT,
	NC_RPT_FORMATS 		BIGINT,
	NC_ENG_CONCURRENT 	BIGINT,
	NC_QUE_LENGTH 		BIGINT, 
	PRIMARY KEY(ID)
)
go


INSERT INTO TBL_IDGENRATOR_JINFONET (TF_NAME,NEXT_ID) VALUES ('NODES_3_ID',0)
go

INSERT INTO TBL_IDGENRATOR_JINFONET (TF_NAME,NEXT_ID) VALUES ('CATALOGVERSION_2_ID',0)
go

INSERT INTO TBL_IDGENRATOR_JINFONET (TF_NAME,NEXT_ID) VALUES ('REPORTVERSION_2_ID',0)
go

INSERT INTO TBL_IDGENRATOR_JINFONET (TF_NAME,NEXT_ID) VALUES ('RESULTVERSION_2_ID',0)
go

INSERT INTO TBL_IDGENRATOR_JINFONET (TF_NAME,NEXT_ID) VALUES ('ACLS_2_ID',0)
go

INSERT INTO TBL_IDGENRATOR_JINFONET (TF_NAME,NEXT_ID) VALUES ('ACLENTRIES_2_ENTRY_ID',0)
go

INSERT INTO TBL_IDGENRATOR_JINFONET (TF_NAME,NEXT_ID) VALUES ('COMPLETEDTABLE_4_ID',0)
go

INSERT INTO TBL_IDGENRATOR_JINFONET (TF_NAME,NEXT_ID) VALUES ('ACLS_WITH_RESOURCE_1_ID',0)
go