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] ) )