DB_51aspx/数据库脚本.sql

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

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

USE [db_CCBData]
GO
/****** Object:  Table [dbo].[tb_NetPoint]    Script Date: 2017/3/18 21:28:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tb_NetPoint](
	[T_Pid] [nvarchar](20) NOT NULL,
	[T_PPassword] [nvarchar](30) NOT NULL,
	[T_PName] [nvarchar](100) NOT NULL,
	[T_Adress] [nvarchar](300) NULL,
	[T_Principal] [nvarchar](20) NULL,
	[T_Tel] [nvarchar](30) NULL,
	[T_AddDate] [datetime] NULL,
PRIMARY KEY CLUSTERED 
(
	[T_Pid] 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
/****** Object:  Table [dbo].[tb_OperationType]    Script Date: 2017/3/18 21:28:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tb_OperationType](
	[T_Opid] [int] IDENTITY(1,1) NOT NULL,
	[T_OpName] [nvarchar](20) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[T_Opid] 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
/****** Object:  Table [dbo].[tb_Project]    Script Date: 2017/3/18 21:28:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tb_Project](
	[T_ProID] [int] IDENTITY(1,1) NOT NULL,
	[T_ProContent] [nvarchar](300) NULL,
	[T_Option1] [nvarchar](100) NULL,
	[T_Option2] [nvarchar](100) NULL,
	[T_Option3] [nvarchar](100) NULL,
	[T_Option4] [nvarchar](100) NULL,
	[T_id] [int] NULL,
	[T_Opid] [int] NULL,
	[T_Date] [datetime] NULL,
	[T_Remark] [nvarchar](100) NULL,
PRIMARY KEY CLUSTERED 
(
	[T_ProID] 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