DB_51aspx/CRM2016_N2.sql

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

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

USE [Easy2016]
GO
/****** Object:  Table [dbo].[CRM_Module]    Script Date: 03/11/2016 17:27:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[CRM_Module](
	[ID] [varchar](50) NOT NULL,
	[Name] [varchar](200) NOT NULL,
	[ParentID] [varchar](50) NULL,
	[Url] [varchar](200) NULL,
	[Sort] [int] NULL,
	[CreateUserID] [varchar](50) NULL,
	[CreateTime] [datetime] NULL,
	[IsLast] [bit] NULL,
	[Version] [timestamp] NULL,
	[Enable] [bit] NOT NULL,
 CONSTRAINT [PK_CRM_MODULE] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[CRM_Module] ([ID], [Name], [ParentID], [Url], [Sort], [CreateUserID], [CreateTime], [IsLast], [Enable]) VALUES (N'Cus', N'客户管理', N'0', NULL, 0, N'admin', CAST(0x0000A5BE0122B2C0 AS DateTime), 0, 1)
INSERT [dbo].[CRM_Module] ([ID], [Name], [ParentID], [Url], [Sort], [CreateUserID], [CreateTime], [IsLast], [Enable]) VALUES (N'CusInfo', N'客户信息管理', N'Cus', NULL, 0, N'admin', CAST(0x0000A5BF00A16279 AS DateTime), 0, 1)
INSERT [dbo].[CRM_Module] ([ID], [Name], [ParentID], [Url], [Sort], [CreateUserID], [CreateTime], [IsLast], [Enable]) VALUES (N'Customer', N'客户通讯', N'CusInfo', N'Customer/CRM_Customer', 1, N'admin', CAST(0x0000A5BF00A207B0 AS DateTime), 1, 1)
/****** Object:  Table [dbo].[CRM_Dept]    Script Date: 03/11/2016 17:27:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CRM_Dept](
	[DeptID] [int] IDENTITY(1,1) NOT NULL,
	[DeptName] [nvarchar](50) NULL,
	[ParentID] [int] NULL,
	[Des] [nvarchar](50) NULL,
	[IsEnable] [bit] NOT NULL,
	[IsDelete] [bit] NOT NULL,
 CONSTRAINT [PK_CRM_DEPT] PRIMARY KEY CLUSTERED 
(
	[DeptID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[CRM_Dept] ON
INSERT [dbo].[CRM_Dept] ([DeptID], [DeptName], [ParentID], [Des], [IsEnable], [IsDelete]) VALUES (1, N'集团总公司', 0, N'总公司', 1, 0)
INSERT [dbo].[CRM_Dept] ([DeptID], [DeptName], [ParentID], [Des], [IsEnable], [IsDelete]) VALUES (3, N'IT部', 1, N'12312312313', 1, 0)
INSERT [dbo].[CRM_Dept] ([DeptID], [DeptName], [ParentID], [Des], [IsEnable], [IsDelete]) VALUES (4, N'研发一部', 3, N'研发一部', 1, 0)
INSERT [dbo].[CRM_Dept] ([DeptID], [DeptName], [ParentID], [Des], [IsEnable], [IsDelete]) VALUES (8, N'234234234', 4, N'234234', 1, 1)
SET IDENTITY_INSERT [dbo].[CRM_Dept] OFF
/****** Object:  Table [dbo].[CRM_RoleUser]    Script Date: 03/11/2016 17:27:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO