DB_51aspx/EnglishTeachingSystem.sql

（开头部分） 53KB

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


USE [EnglishTeachingSystem]
GO
/****** Object:  Table [dbo].[FileType]    Script Date: 11/05/2014 15:02:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FileType](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](50) NULL,
 CONSTRAINT [PK_FileType] 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 IDENTITY_INSERT [dbo].[FileType] ON
INSERT [dbo].[FileType] ([id], [Name]) VALUES (1, N'教学课件')
INSERT [dbo].[FileType] ([id], [Name]) VALUES (2, N'参考资料')
INSERT [dbo].[FileType] ([id], [Name]) VALUES (3, N'课程习题')
SET IDENTITY_INSERT [dbo].[FileType] OFF
/****** Object:  Table [dbo].[FileInfo]    Script Date: 11/05/2014 15:02:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FileInfo](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[TitleName] [nvarchar](50) NULL,
	[FileDs] [text] NULL,
	[FilePath] [nvarchar](50) NULL,
	[Ename] [nvarchar](50) NULL,
	[FileName] [nvarchar](50) NULL,
	[AddTime] [datetime] NULL,
	[Click] [int] NULL,
	[typeid] [int] NULL,
	[TypeName] [nvarchar](50) NULL,
 CONSTRAINT [PK_FileInfo] 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].[FileInfo] ON
INSERT [dbo].[FileInfo] ([id], [TitleName], [FileDs], [FilePath], [Ename], [FileName], [AddTime], [Click], [typeid], [TypeName]) VALUES (1, N'英语资料', N'<p>比较好的英语参考资料</p>', N'3103917694.rar', N'.rar', N'27142231913', CAST(0x0000A2FB00ECEA40 AS DateTime), 0, 1, N'教学课件')
INSERT [dbo].[FileInfo] ([id], [TitleName], [FileDs], [FilePath], [Ename], [FileName], [AddTime], [Click], [typeid], [TypeName]) VALUES (2, N'计算机学习资料', N'<p>&nbsp;111</p>', N'3104138922.docx', N'.docx', N'3104053645', CAST(0x0000A3D5000B42D4 AS DateTime), 0, 1, N'教学课件')
INSERT [dbo].[FileInfo] ([id], [TitleName], [FileDs], [FilePath], [Ename], [FileName], [AddTime], [Click], [typeid], [TypeName]) VALUES (3, N'作业', N'<p>&nbsp;请下载作业</p>', N'3104222754.docx', N'.docx', N'3104222754', CAST(0x0000A3D5000BAFE3 AS DateTime), 0, 3, N'课程习题')
INSERT [dbo].[FileInfo] ([id], [TitleName], [FileDs], [FilePath], [Ename], [FileName], [AddTime], [Click], [typeid], [TypeName]) VALUES (4, N'C#学习资料', N'<p>&nbsp;啊啊啊</p>', N'3104310717.docx', N'.docx', N'3104310717', CAST(0x0000A3D5000BE2EC AS DateTime), 0, 2, N'参考资料')
INSERT [dbo].[FileInfo] ([id], [TitleName], [FileDs], [FilePath], [Ename], [FileName], [AddTime], [Click], [typeid], [TypeName]) VALUES (5, N'11', N'<p>&nbsp;111</p>', N'3114345554.exe', N'.exe', N'3114345554', CAST(0x0000A3D5001C84FB AS DateTime), 0, 2, N'参考资料')
INSERT [dbo].[FileInfo] ([id], [TitleName], [FileDs], [FilePath], [Ename], [FileName], [AddTime], [Click], [typeid], [TypeName]) VALUES (6, N'222', N'<p>&nbsp;111</p>', N'41262534.accdb', N'.accdb', N'41262534', CAST(0x0000A3D90017C17A AS DateTime), 0, 1, N'教学课件')
SET IDENTITY_INSERT [dbo].[FileInfo] OFF
/****** Object:  Table [dbo].[DaYi]    Script Date: 11/05/2014 15:02:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[DaYi](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[Topic] [text] NULL,
后面还有 378 行代码，购买后查看完整代码

24 小时内免费解锁 3 个项目，之后 1 算力/个。 规则说明

AI 解读 AI

登录后可用，每次 10 算力，解读结果公开显示在下面。

还没有人解读过这个文件。