DB_51aspx/StudentCallNameDB.sql

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

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

USE [StudentCallNameDB]
GO
/****** Object:  Table [dbo].[Users]    Script Date: 07/16/2016 16:14:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Users](
	[UserId] [int] IDENTITY(1,1) NOT NULL,
	[UserName] [nvarchar](50) NOT NULL,
	[UserPassword] [nvarchar](50) NOT NULL,
	[RealName] [nvarchar](50) NULL,
	[Email] [nvarchar](50) NOT NULL,
	[Telephone] [nvarchar](50) NOT NULL,
	[Sn] [nvarchar](50) NOT NULL,
	[Sex] [nvarchar](2) NOT NULL,
	[ClassId] [int] NULL,
 CONSTRAINT [PK_Users] PRIMARY KEY CLUSTERED 
(
	[UserId] 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].[Users] ON
INSERT [dbo].[Users] ([UserId], [UserName], [UserPassword], [RealName], [Email], [Telephone], [Sn], [Sex], [ClassId]) VALUES (1, N'1001', N'123456', N'王杰', N'wangjie@126.com', N'15201530543', N'421127198404223236', N'男', 1)
INSERT [dbo].[Users] ([UserId], [UserName], [UserPassword], [RealName], [Email], [Telephone], [Sn], [Sex], [ClassId]) VALUES (2, N'1002', N'123456', N'张晓', N'457236432@qq.com', N'15346730478', N'371101199810243231', N'女', 1)
INSERT [dbo].[Users] ([UserId], [UserName], [UserPassword], [RealName], [Email], [Telephone], [Sn], [Sex], [ClassId]) VALUES (3, N'1003', N'123456', N'李煜', N'liyu@163.com', N'18171703093', N'421127199204223236', N'男', 2)
INSERT [dbo].[Users] ([UserId], [UserName], [UserPassword], [RealName], [Email], [Telephone], [Sn], [Sex], [ClassId]) VALUES (4, N'1004', N'123456', N'王明', N'wangming@126.com', N'15201030437', N'372119951022343580', N'男', 2)
SET IDENTITY_INSERT [dbo].[Users] OFF
/****** Object:  Table [dbo].[Teachers]    Script Date: 07/16/2016 16:14:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Teachers](
	[UserId] [int] IDENTITY(1,1) NOT NULL,
	[UserName] [nvarchar](50) NOT NULL,
	[UserPassword] [nvarchar](50) NOT NULL,
	[RealName] [nvarchar](50) NOT NULL,
	[Email] [nvarchar](50) NOT NULL,
	[Telephone] [nvarchar](50) NOT NULL,
	[Sn] [nvarchar](50) NOT NULL,
	[Sex] [nvarchar](2) NOT NULL,
	[CourseId] [int] NULL
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[Teachers] ON
INSERT [dbo].[Teachers] ([UserId], [UserName], [UserPassword], [RealName], [Email], [Telephone], [Sn], [Sex], [CourseId]) VALUES (1, N'wh', N'123456', N'王华', N'wanghua@126.com', N'15101430238', N'421126198804332338', N'男', 1)
INSERT [dbo].[Teachers] ([UserId], [UserName], [UserPassword], [RealName], [Email], [Telephone], [Sn], [Sex], [CourseId]) VALUES (2, N'hyl', N'123456', N'黄玉兰', N'hyl@126.com', N'18101430345', N'421127198504335677', N'女', 2)
INSERT [dbo].[Teachers] ([UserId], [UserName], [UserPassword], [RealName], [Email], [Telephone], [Sn], [Sex], [CourseId]) VALUES (3, N'zhw', N'123456', N'张伟', N'zhangwei@163.com', N'18101430894', N'411106198004452344', N'男', 3)
INSERT [dbo].[Teachers] ([UserId], [UserName], [UserPassword], [RealName], [Email], [Telephone], [Sn], [Sex], [CourseId]) VALUES (4, N'jb', N'123456', N'姜波', N'jiangbo@sohu.com', N'18945130609', N'371106197202455624', N'男', 4)
INSERT [dbo].[Teachers] ([UserId], [UserName], [UserPassword], [RealName], [Email], [Telephone], [Sn], [Sex], [CourseId]) VALUES (5, N'wx', N'123456', N'王肖', N'wangxiaoen@126.com', N'15301430358', N'421126198304332243', N'男', 5)
INSERT [dbo].[Teachers] ([UserId], [UserName], [UserPassword], [RealName], [Email], [Telephone], [Sn], [Sex], [CourseId]) VALUES (6, N'll', N'123456', N'李丽', N'lili@126.com', N'18234530656', N'311140198504335623', N'女', 1)
INSERT [dbo].[Teachers] ([UserId], [UserName], [UserPassword], [RealName], [Email], [Telephone], [Sn], [Sex], [CourseId]) VALUES (7, N'zqw', N'123456', N'张庆伟', N'zhangqinwei@163.com', N'13101430457', N'401123198004452344', N'男', 2)
INSERT [dbo].[Teachers] ([UserId], [UserName], [UserPassword], [RealName], [Email], [Telephone], [Sn], [Sex], [CourseId]) VALUES (9, N'lx', N'123456', N'李翔', N'lixiang@163.com', N'15201030358', N'372119800822343534', N'男', 3)
INSERT [dbo].[Teachers] ([UserId], [UserName], [UserPassword], [RealName], [Email], [Telephone], [Sn], [Sex], [CourseId]) VALUES (10, N'jf', N'123456', N'江枫', N'jiangfeng@126.com', N'18173803023', N'230115198204223232', N'男', 4)
INSERT [dbo].[Teachers] ([UserId], [UserName], [UserPassword], [RealName], [Email], [Telephone], [Sn], [Sex], [CourseId]) VALUES (8, N'ft', N'123456', N'冯涛', N'fengtao@sohu.com', N'18012460987', N'371106195402467624', N'男', 5)
SET IDENTITY_INSERT [dbo].[Teachers] OFF
/****** Object:  Table [dbo].[Majors]    Script Date: 07/16/2016 16:14:38 ******/