WebSite/Handlers/SQL.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

USE [CRMOA]
;
/****** Object:  Table [dbo].[TCWL_ZPXiaoShouJiHui]    Script Date: 09/12/2015 15:18:27 ******/
SET ANSI_NULLS ON
;
SET QUOTED_IDENTIFIER ON
;
CREATE TABLE [TCWL_ZPXiaoShouJiHui](
	[ID] [nvarchar](36) NOT NULL,
	[ZhiPaiName] [nvarchar](50) NULL,
	[ZhiPaiShiJian] [datetime] NULL,
	[ZhiPaiRenYuan] [nvarchar](50) NULL,
	[GongSiID] [nvarchar](50) NULL,
	[ServiceID] [nvarchar](50) NULL,
	[TimeStr] [datetime] NULL
) ON [PRIMARY]
;
/****** Object:  Table [dbo].[TCWL_ZDKaiFaJiHua]    Script Date: 09/12/2015 15:18:27 ******/
SET ANSI_NULLS ON
;
SET QUOTED_IDENTIFIER ON
;
CREATE TABLE [TCWL_ZDKaiFaJiHua](
	[ID] [nvarchar](36) NOT NULL,
	[JiHuaNeiRong] [nvarchar](100) NULL,
	[JiHuaShiJian] [datetime] NULL,
	[JiHuaName] [nvarchar](50) NULL,
	[JiHuiBianHao] [nvarchar](50) NULL,
	[JiHuaZhuangTai] [nvarchar](50) NULL,
	[JiHuiZhuangTai] [nvarchar](50) NULL,
	[GongSiID] [nvarchar](50) NULL,
	[ServiceID] [nvarchar](50) NULL,
	[TimeStr] [datetime] NULL
) ON [PRIMARY]
;
/****** Object:  Table [dbo].[TCWL_YongHuZhuCe]    Script Date: 09/12/2015 15:18:27 ******/
SET ANSI_NULLS ON
;
SET QUOTED_IDENTIFIER ON
;
CREATE TABLE [TCWL_YongHuZhuCe](
	[ID] [nvarchar](36) NOT NULL,
	[DanWeiMingCheng] [nvarchar](50) NULL,
	[DanWeiDiZhi] [nvarchar](50) NULL,
	[ShouJiHaoMa] [nvarchar](50) NULL,
	[ChuanZhen] [nvarchar](50) NULL,
	[GuDingDianHua] [nvarchar](50) NULL,
	[YouBian] [nvarchar](50) NULL,
	[QQ] [nvarchar](50) NULL,
	[MSN] [nvarchar](50) NULL,
	[YouXiang] [nvarchar](50) NULL,
	[ZhuangTai] [nvarchar](50) NULL,
	[ServiceID] [nvarchar](50) NULL,
	[TimeStr] [datetime] NULL
) ON [PRIMARY]
;
/****** Object:  Table [dbo].[TCWL_YongHuGuanLi]    Script Date: 09/12/2015 15:18:27 ******/
SET ANSI_NULLS ON
;
SET QUOTED_IDENTIFIER ON