详细介绍K9宅基地安装配置步骤,7、手动创建两张表,此表是有关上传扫描件用的。(手动创建的原因,因为现在K9没有这个功能)
1、 创建两张表 UPFILESLIST
USE [ZJDX]----数据库名字
GO
/****** 对象: Table [dbo].[UPFILESLIST] 脚本日期: 04/16/2012 13:24:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[UPFILESLIST](
[ID0] [int] IDENTITY(1,1) NOT NULL,
[CASENO] [varchar](200) COLLATE Chinese_PRC_CI_AS NULL,
[MATERIALID] [int] NULL,
[MATERIALNAME] [varchar](200) COLLATE Chinese_PRC_CI_AS NULL,
[PAGECONTENT] [int] NULL,
[FILENO] [int] NOT NULL,
[FILENAME] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL,
[FILECONTENT] [image] NULL,
[REMARK] [varchar](1000) COLLATE Chinese_PRC_CI_AS NULL,
[RESERVE1] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL,
[RESERVE2] [varchar](200) COLLATE Chinese_PRC_CI_AS NULL,
[UPFILETIME] [datetime] NULL,
PRIMARY KEY CLUSTERED
(
[ID0] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
CASEMATERIALLIST
USE [ZJDX] ----数据库名字
GO
/****** 对象: Table [dbo].[CASEMATERIALLIST] 脚本日期: 04/16/2012 13:23:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[CASEMATERIALLIST](
[ID0] [int] IDENTITY(1,1) NOT NULL,
[CASENO] [varchar](200) COLLATE Chinese_PRC_CI_AS NULL,
[FLOWID] [bigint] NULL,
[CASENAME] [varchar](200) COLLATE Chinese_PRC_CI_AS NULL,
[MATERIALNAME] [varchar](1000) COLLATE Chinese_PRC_CI_AS NULL,
[UPMATERIALTYPE] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[MATERIALID] [int] NULL,
[PAGECONTENT] [int] NULL,
[ISMUST] [varchar](20) COLLATE Chinese_PRC_CI_AS NULL,
[SIGNINFLAG] [varchar](1) COLLATE Chinese_PRC_CI_AS NULL,
[REMARK] [varchar](1000) COLLATE Chinese_PRC_CI_AS NULL,
[RESERVE1] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL,
[RESERVE2] [varchar](200) COLLATE Chinese_PRC_CI_AS NULL,
[MATERIALDATE] [datetime] NULL,
[UPFILENAME] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[ActiveID] [varchar](200) COLLATE Chinese_PRC_CI_AS NULL,
PRIMARY KEY CLUSTERED
(
[ID0] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF