www.gusucode.com > 智软JSP表单引擎实例源码源码程序 > 智软JSP表单引擎实例源码/自定义表单引擎/自定义表单引擎/数据库建表语句及示例数据/mssql数据库/自定义表单引擎建表语句.txt

    CREATE TABLE [COLL_CONFIG_OPERATE_FIELD](
	[ID] [varchar](8) NOT NULL,
	[FID] [varchar](10) NULL,
	[FIELD] [varchar](50) NULL,
	[ISDISPLAY] [varchar](1) NULL,
	[ISEDIT] [varchar](1) NULL,
	[ISMUSTFILL] [varchar](1) NULL,
	[DEFAULT1] [varchar](1000) NULL,
	[ISFORCE] [char](1) NULL
 CONSTRAINT [PK_COLL_CONFIG_OPERATE_FIELD] PRIMARY KEY CLUSTERED 
(
	[ID]
)
)



CREATE TABLE [COLL_DOC_CONFIG](
	[ID] [varchar](8) NOT NULL,
	[DOCNAME] [varchar](100) NULL,
	[TEMPLAET] [varchar](80) NULL,
	[OTHERFIELD] [varchar](8) NULL,
	[MAINTABLE] [varchar](4) NULL,
	[DOCTYPE] [varchar](1) NULL,
        [DCODE] [varchar](64) NULL
 CONSTRAINT [PK_COLL_DOC_CONFIG] PRIMARY KEY CLUSTERED 
(
	[ID]
)
)



CREATE TABLE [COLL_DOC_PRINT](
	[ID] [varchar](8) NOT NULL,
	[DOCID] [varchar](8) NULL,
	[TEMPLAET] [varchar](80)  NULL,
	[PAGE] [numeric](2, 0) NULL
 CONSTRAINT [PK_COLL_DOC_PRINT] PRIMARY KEY CLUSTERED 
(
	[ID]
)
)