DB_51aspx/CourseTeachingWeb.sql

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

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

USE [CourseTeachingWeb]
GO
/****** Object:  Table [dbo].[Video]    Script Date: 03/30/2016 19:12:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Video](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[VideoName] [nvarchar](50) NULL,
	[VideoDs] [text] NULL,
	[VideoPath] [nvarchar](50) NULL,
	[Ename] [nvarchar](50) NULL,
	[FileName] [nvarchar](50) NULL,
	[Addtime] [datetime] NULL,
	[Photo] [nvarchar](50) NULL,
 CONSTRAINT [PK_Video] 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] TEXTIMAGE_ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[Video] ON
INSERT [dbo].[Video] ([id], [VideoName], [VideoDs], [VideoPath], [Ename], [FileName], [Addtime], [Photo]) VALUES (1, N'第一章视频', N'第一章视频', N'2016310211349.mp4', N'.mp4', N'第一章视频', CAST(0x0000A5BF00F8DF21 AS DateTime), N'20120322230011.jpg')
INSERT [dbo].[Video] ([id], [VideoName], [VideoDs], [VideoPath], [Ename], [FileName], [Addtime], [Photo]) VALUES (2, N'第二章视频', N'第二章视频', N'20120304150600.swf', N'.swf', N'第二章视频', CAST(0x0000A5BF00F8DF21 AS DateTime), N'20120322230011.jpg')
INSERT [dbo].[Video] ([id], [VideoName], [VideoDs], [VideoPath], [Ename], [FileName], [Addtime], [Photo]) VALUES (3, N'第三章视频', N'第三章视频', N'20120304150600.swf', N'.swf', N'第三章视频', CAST(0x0000A5BF00F8DF21 AS DateTime), N'20120322230011.jpg')
INSERT [dbo].[Video] ([id], [VideoName], [VideoDs], [VideoPath], [Ename], [FileName], [Addtime], [Photo]) VALUES (15, N'第四章视频', N'第四章视频', N'2016310213014.mp4', N'.mp4', N'第四章视频', CAST(0x0000A5C5016275A0 AS DateTime), N'20120322230011.jpg')
SET IDENTITY_INSERT [dbo].[Video] OFF
/****** Object:  Table [dbo].[Users]    Script Date: 03/30/2016 19:12:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Users](
	[id] [int] IDENTITY(1001,1) NOT NULL,
	[UserName] [nvarchar](50) NULL,
	[XingMing] [nvarchar](50) NULL,
	[Sex] [nvarchar](50) NULL,
	[Age] [nvarchar](50) NULL,
	[Ds] [text] NULL,
	[emal] [nvarchar](50) NULL,
	[pwd] [nvarchar](50) NULL,
	[UserType] [nvarchar](50) NULL,
	[Photo] [nvarchar](50) NULL,
	[Tel] [nvarchar](50) NULL,
 CONSTRAINT [PK_Student] 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] TEXTIMAGE_ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[Users] ON
INSERT [dbo].[Users] ([id], [UserName], [XingMing], [Sex], [Age], [Ds], [emal], [pwd], [UserType], [Photo], [Tel]) VALUES (1001, N'111', N'李雷', N'男', N'23', N'', N'lilei@126.com', N'111', N'学生', N'2016312180616.jpg', N'1371615494')
INSERT [dbo].[Users] ([id], [UserName], [XingMing], [Sex], [Age], [Ds], [emal], [pwd], [UserType], [Photo], [Tel]) VALUES (1002, N'222', N'王浩', N'男', N'23', N'', N'wanghao@126.com', N'222', N'学生', N'2016312180638.jpg', N'1381515426')
INSERT [dbo].[Users] ([id], [UserName], [XingMing], [Sex], [Age], [Ds], [emal], [pwd], [UserType], [Photo], [Tel]) VALUES (1003, N'333', N'王伟', N'男', N'23', N'', N'wangwei@163.com', N'333', N'学生', N'2016312180659.jpg', N'1371115444')
INSERT [dbo].[Users] ([id], [UserName], [XingMing], [Sex], [Age], [Ds], [emal], [pwd], [UserType], [Photo], [Tel]) VALUES (1004, N'444', N'黄刚', N'男', N'23', N'', N'huanggang@163.com', N'444', N'学生', N'2016312180722.jpg', N'1381215423')
INSERT [dbo].[Users] ([id], [UserName], [XingMing], [Sex], [Age], [Ds], [emal], [pwd], [UserType], [Photo], [Tel]) VALUES (1005, N'555', N'王艳', N'女', N'22', N'', N'wangyan@163.com', N'555', N'学生', N'20120304140322.jpg', N'1371115444')
INSERT [dbo].[Users] ([id], [UserName], [XingMing], [Sex], [Age], [Ds], [emal], [pwd], [UserType], [Photo], [Tel]) VALUES (1006, N'666', N'李娜', N'女', N'23', N'', N'lina@126.com', N'666', N'学生', N'2016312180829.jpeg', N'1321345478')
INSERT [dbo].[Users] ([id], [UserName], [XingMing], [Sex], [Age], [Ds], [emal], [pwd], [UserType], [Photo], [Tel]) VALUES (1007, N'777', N'程昱', N'男', N'23', N'', N'chengyu@qq.com', N'777', N'学生', N'2016312180852.jpg', N'1371115448')