[ID] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO
/****** 对象: Table [dbo].[Feedback] 脚本日期: 07/02/2009 20:56:27 ******/ CREATE TABLE [dbo].[Feedback]( (
[ID] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO
/****** 对象: Table [dbo].[ReNew] 脚本日期: 07/02/2009 20:55:13 ******/ CREATE TABLE [dbo].[ReNew]( (
[ID] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO
/****** 对象: Table [dbo].[CallBoard] 脚本日期: 07/02/2009 21:00:15 ******/ CREATE TABLE [dbo].[RetchTemp_CallBoard](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Title] [varchar](500) COLLATE Chinese_PRC_CI_AS NULL, [Content] [text] COLLATE Chinese_PRC_CI_AS NULL,
[SendID] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL, [SendTime] [smalldatetime] NULL,
[ClassID] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL, [ID] [int] IDENTITY(1,1) NOT NULL,
[ScantyCode] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL, [IsDelete] [int] NULL,
[Title] [nvarchar](200) COLLATE Chinese_PRC_CI_AS NULL, [SubmitTime] [smalldatetime] NULL, [SysTime] [datetime] NULL,
[ID] [int] IDENTITY(1,1) NOT NULL,
[ScantyCode] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL,
[IsDelete] [int] NULL CONSTRAINT [DF_Feedback_IsDelete] DEFAULT ((0)), [Feedbacker] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL, [SysTime] [datetime] NULL,
[Content] [nvarchar](4000) COLLATE Chinese_PRC_CI_AS NULL, [Photo] [image] NULL,
CONSTRAINT [PK_Feedback] PRIMARY KEY CLUSTERED
PRIMARY KEY CLUSTERED
(
[IsDelete] [bit] NULL,
CONSTRAINT [PK_RetchTemp_CallBoard] PRIMARY KEY CLUSTERED
[ID] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO
/****** 对象: Table [dbo].[CallState] 脚本日期: 07/02/2009 21:01:46 ******/ CREATE TABLE [dbo].[RetchTemp_CallState]( (
[ID] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO
/****** 对象: Table [dbo].[Affair] 脚本日期: 07/02/2009 21:08:41 ******/ CREATE TABLE [dbo].[AffairDealInfo]( (
[ID] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO
[ID] [int] IDENTITY(1,1) NOT NULL,
[ScantyCode] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL,
[IsDelete] [int] NULL CONSTRAINT [DF_AffairDealInfo_IsDelete] DEFAULT [AffairID] [int] NULL,
[AffairApplyID] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL, [AffairDealID] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL, [StartTime] [datetime] NULL, [EndTime] [datetime] NULL,
[AffairInputTime] [datetime] NULL,
[AffairTypeID] [int] NULL CONSTRAINT [DF_AffairDealInfo_AffairTypeID] [Cause] [text] COLLATE Chinese_PRC_CI_AS NULL,
[ReMark] [varchar](500) COLLATE Chinese_PRC_CI_AS NULL, [ID] [int] IDENTITY(1,1) NOT NULL,
[ClassID] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL, [ClassName] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL,
CONSTRAINT [PK_RetchTemp_CallState] PRIMARY KEY CLUSTERED
(0),
DEFAULT (0),
CONSTRAINT [PK_AffairDealInfo] PRIMARY KEY CLUSTERED
/****** 对象: Table [dbo].[AffairInfo] 脚本日期: 07/02/2009 21:09:57 ******/ GO
CREATE TABLE [dbo].[AffairInfo](
[ID] [int] IDENTITY(1,1) NOT NULL,
[ScantyCode] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL,
[IsDelete] [int] NULL CONSTRAINT [DF_AffairInfo_IsDelete] DEFAULT (0), [CommCode] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [AffairName] [varchar](300) COLLATE Chinese_PRC_CI_AS NULL, [AffairContent] [nvarchar](2000) COLLATE Chinese_PRC_CI_AS NULL, [AffairInputTime] [datetime] NULL,
[State] [int] NULL CONSTRAINT [DF_AffairInfo_State] DEFAULT (1), [Important] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT
[DF_AffairInfo_CommID] DEFAULT (0),
[DF_AffairInfo_Import] DEFAULT (0),
CONSTRAINT [PK_AffairInfo] PRIMARY KEY CLUSTERED (
[ID] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO
/****** 对象: Table [dbo].[AffType] 脚本日期: 07/02/2009 21:10:23 ******/ CREATE TABLE [dbo].[AffTypeInfo]( (
[ID] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO
/*** 对象: Table [dbo].[BrowseRecord] 脚本日期: 07/02/2009 21:11:05 ****/ CREATE TABLE [dbo].[BrowseRecord](
[ID] [int] IDENTITY(1,1) NOT NULL,
[ScantyCode] [varchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL,
[IsDelete] [int] NULL CONSTRAINT [DF_BrowseRecord_IsDelete] DEFAULT (0), [FatherCode] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL, [OriginPagePath] [varchar](200) COLLATE Chinese_PRC_CI_AS NULL, [PagePath] [varchar](200) COLLATE Chinese_PRC_CI_AS NULL, [AccessTime] [datetime] NULL, [ExitTime] [datetime] NULL,
[ID] [int] IDENTITY(1,1) NOT NULL,
[AffTypeName] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [AffTypeID] [int] NULL,
CONSTRAINT [PK_AffTypeInfo] PRIMARY KEY CLUSTERED
CONSTRAINT [PK_BrowseRecord] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO
/*** 对象: Table [dbo].[ClientRecord] 脚本日期: 07/02/2009 21:11:55 ****/ CREATE TABLE [dbo].[ClientRecord]( (
[ID] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO
/*** 对象: Table [dbo].[CommTypeInfo] 脚本日期: 07/02/2009 21:12:25 ****/ CREATE TABLE [dbo].[CommTypeInfo]( (
[ID] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO
/*** 对象: Table [dbo].[CommunicateInfo] 脚本日期: 07/02/2009 21:12:55 **/ CREATE TABLE [dbo].[CommunicateInfo](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Scantycode] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL, [CompanyCode] [varchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [CommName] [varchar](500) COLLATE Chinese_PRC_CI_AS NULL, [CommContent] [varchar](2000) COLLATE Chinese_PRC_CI_AS NULL, [CommTime] [smalldatetime] NULL,
[CommUserID] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL, [ID] [int] IDENTITY(1,1) NOT NULL,
[CommTypeName] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [CommTypeID] [int] NULL,
[ID] [int] IDENTITY(1,1) NOT NULL,
[ScantyCode] [varchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL,
[IsDelete] [int] NULL CONSTRAINT [DF_ClientRecord_IsDelete] DEFAULT (0), [IPAddr] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [LoginTime] [datetime] NULL, [ExitTime] [datetime] NULL,
[UserScantyCode] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL, [IPArea] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NULL,
CONSTRAINT [PK_ClientRecord] PRIMARY KEY CLUSTERED
CONSTRAINT [PK_CommTypeInfo] PRIMARY KEY CLUSTERED