App_Data/XSCJ.sql

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

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

USE [XSCJ]
GO
/****** Object:  Table [dbo].[Teachter]    Script Date: 12/29/2017 20:51:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Teachter](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](200) NULL,
	[Sex] [nvarchar](50) NULL,
	[NianJi] [nvarchar](50) NULL,
	[GongHao] [nvarchar](100) NULL,
	[chushengriqi] [nvarchar](50) NULL,
	[Addtime] [datetime] NULL,
	[Ds] [text] NULL,
	[Photo] [nvarchar](200) NULL,
	[Pwd] [nvarchar](50) NULL,
 CONSTRAINT [PK_Teachter] 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].[Teachter] ON
INSERT [dbo].[Teachter] ([id], [Name], [Sex], [NianJi], [GongHao], [chushengriqi], [Addtime], [Ds], [Photo], [Pwd]) VALUES (1, N'李鸿飞', N'男', N'高中一年级', N't1', N'2015-11-21', CAST(0x0000A5E5013C9230 AS DateTime), N'1212', N'21191228743.jpg', N't1')
SET IDENTITY_INSERT [dbo].[Teachter] OFF
/****** Object:  Table [dbo].[Student]    Script Date: 12/29/2017 20:51:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Student](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](200) NULL,
	[Sex] [nvarchar](50) NULL,
	[NianJi] [nvarchar](50) NULL,
	[GongHao] [nvarchar](100) NULL,
	[chushengriqi] [nvarchar](50) NULL,
	[Addtime] [datetime] NULL,
	[Ds] [text] NULL,
	[Photo] [nvarchar](200) NULL,
	[Pwd] [nvarchar](50) NULL,
	[ClassId] [int] NULL,
	[ClassName] [nvarchar](50) NULL,
	[XueHao] [nvarchar](50) NULL,
	[ZhuZhi] [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].[Student] ON
INSERT [dbo].[Student] ([id], [Name], [Sex], [NianJi], [GongHao], [chushengriqi], [Addtime], [Ds], [Photo], [Pwd], [ClassId], [ClassName], [XueHao], [ZhuZhi]) VALUES (1, N'李宏', N'男', N'高中一年级', N'st1', N'2015-11-03', CAST(0x0000A5E5013C9230 AS DateTime), N'', N'21191436879.jpg', N'st1', 1, N'高一101班', N'2015001', N'上海市浦东区')
INSERT [dbo].[Student] ([id], [Name], [Sex], [NianJi], [GongHao], [chushengriqi], [Addtime], [Ds], [Photo], [Pwd], [ClassId], [ClassName], [XueHao], [ZhuZhi]) VALUES (2, N'刘鸿', N'男', N'高中一年级', N'222', N'2015-11-03', CAST(0x0000A5E5013C9230 AS DateTime), N'', N'21191436879.jpg', N'222', 1, N'高一101班', N'2015002', N'上海市浦东区')
INSERT [dbo].[Student] ([id], [Name], [Sex], [NianJi], [GongHao], [chushengriqi], [Addtime], [Ds], [Photo], [Pwd], [ClassId], [ClassName], [XueHao], [ZhuZhi]) VALUES (3, N'刘峰', N'男', N'高中一年级', N'333', N'2015-11-03', CAST(0x0000A5E5013C9230 AS DateTime), N'', N'21191436879.jpg', N'333', 1, N'高一101班', N'2015003', N'上海市浦东区')
INSERT [dbo].[Student] ([id], [Name], [Sex], [NianJi], [GongHao], [chushengriqi], [Addtime], [Ds], [Photo], [Pwd], [ClassId], [ClassName], [XueHao], [ZhuZhi]) VALUES (4, N'李菲菲', N'男', N'高中一年级', N'444', N'2015-11-03', CAST(0x0000A5E5013C9230 AS DateTime), N'', N'21191436879.jpg', N'444', 1, N'高一101班', N'2015004', N'上海市浦东区')
INSERT [dbo].[Student] ([id], [Name], [Sex], [NianJi], [GongHao], [chushengriqi], [Addtime], [Ds], [Photo], [Pwd], [ClassId], [ClassName], [XueHao], [ZhuZhi]) VALUES (5, N'王静', N'男', N'高中一年级', N'555', N'2015-11-03', CAST(0x0000A5E5013C9230 AS DateTime), N'', N'21191436879.jpg', N'555', 1, N'高一101班', N'2015005', N'上海市浦东区')