蓝鲸音乐馆.rar蓝鲸音乐asp.net实训项目

USE [BlueWhale] GO /****** Object: User [TTT] Script Date: 12/10/2020 21:36:44 ******/ CREATE USER [TTT] FOR LOGIN [TTT] WITH DEFAULT_SCHEMA=[dbo] GO /****** Object: Table [dbo].[MusicTypes] Script Date: 12/10/2020 21:36:44 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[MusicTypes]( [t_id] [nvarchar](20) NOT NULL, [t_name] [nvarchar](20) NOT NULL, [t_description] [nvarchar](1000) NULL, [t_parentid] [int] NULL, CONSTRAINT [PK_MusicTypes] PRIMARY KEY CLUSTERED ( [t_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 INSERT [dbo].[MusicTypes] ([t_id], [t_name], [t_description], [t_parentid]) VALUES (N'001', N'流行', NULL, NULL) INSERT [dbo].[MusicTypes] ([t_id], [t_name], [t_description], [t_parentid]) VALUES (N'002', N'Hip Hop', NULL, NULL) INSERT [dbo].[MusicTypes] ([t_id], [t_name], [t_description], [t_parentid]) VALUES (N'003', N'民谣', NULL, NULL) INSERT [dbo].[MusicTypes] ([t_id], [t_name], [t_description], [t_parentid]) VALUES (N'004', N'欧美', NULL, 1) INSERT [dbo].[MusicTypes] ([t_id], [t_name], [t_description], [t_parentid]) VALUES (N'005', N'粤语', NULL, 1) /****** Object: Table [dbo].[Administrator] Script Date: 12/10/2020 21:36:44 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Administrator]( [a_id] [nvarchar](20) NOT NULL, [a_password] [nvarchar](20) NOT NULL, [a_name] [nvarchar](20) NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[Users] Script Date: 12/10/2020 21:36:44 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Users]( [u_id] [nvarchar](20) NOT NULL, [u_name] [nvarchar](20) NOT NULL, [u_password] [nvarchar](20) NOT NULL, [u_cord] [int] IDENTITY(1,1) NOT NULL, [u_sex] [nvarchar](20) NULL, [u_photo] [nvarchar](1000) NULL, [u_time] [datetime] NULL, [u_description] [nvarchar](1000) NULL, [u_age] [int] NULL, CONSTRAINT [PK_Users] PRIMARY KEY CLUSTERED ( [u_cord] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [IX_Users] UNIQUE NONCLUSTERED ( [u_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].[Users] ON INSERT [dbo].[Users] ([u_id], [u_name], [u_password], [u_cord], [u_sex], [u_photo], [u_time], [u_description], [u_age]) VALUES (N'111', N'邰帅', N'aaa', 1, N'男', N'../img/s副本.png', NULL, N'HHH', 19) INSERT [dbo].[Users] ([u_id], [u_name], [u_password], [u_cord], [u_sex], [u_photo], [u_time], [u_description], [u_age]) VALUES (N'222', N'渣渣凯', N'aaa', 2, N'男', N'../img/tx.jpg', NULL, N'', 20) INSERT [dbo].[Users] ([u_id], [u_name], [u_password], [u_cord], [u_sex], [u_photo], [u_time], [u_description], [u_age]) VALUES (N'333', N'www', N'aaa', 3, N'男', N'../img/tx.jpg', NULL, N'', 21) INSERT [dbo].[Users] ([u_id], [u_name], [u_password], [u_cord], [u_sex], [u_photo], [u_time], [u_description], [u_age]) VALUES (N'999999', N'李梦洁', N'aaaaaa', 4, N'女', N'../img/李梦杰.png', NULL, N'美女', 18) INSERT [dbo].[Users] ([u_id], [u_name], [u_password], [u_cord], [u_sex], [u_photo], [u_time], [u_description], [u_age]) VALUES (N'123', N'刘思懿', N'aaaaaa', 5, NULL, N'../img/tx.jpg', NULL, NULL, NULL) SET IDENTITY_INSERT [dbo].[Users] OFF /****** Object: Table [dbo].[NewlyBuild] Script Date: 12/10/2020 21:36:44 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[NewlyBuild]( [n_id] [int] IDENTITY(1,1) NOT NULL, [n_name] [nvarchar](50) NULL, [u_cord] [int] NULL, [n_photo] [nvarchar](200) NULL, CONSTRAINT [PK_NewlyBuild] PRIMARY KEY CLUSTERED ( [n_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].[NewlyBuild] ON INSERT [dbo].[NewlyBuild] ([n_id], [n_name], [u_cord], [n_photo]) VALUES (3, N'ttts', 1, N'../img/tx.jpg') INSERT [dbo].[NewlyBuild] ([n_id], [n_name], [u_cord], [n_photo]) VALUES (4, N'歌单1', 4, N'../img/tx.jpg') INSERT [dbo].[NewlyBuild] ([n_id], [n_name], [u_cord], [n_photo]) VALUES (5, N'歌单1', 2, N'../img/tx.jpg') INSERT [dbo].[NewlyBuild] ([n_id], [n_name], [u_cord], [n_photo]) VALUES (6, N'歌单2', 2, N'../img/tx.jpg') INSERT [dbo].[NewlyBuild] ([n_id], [n_name], [u_cord], [n_photo]) VALUES (7, N'歌单3', 2, N'../img/tx.jpg') SET IDENTITY_INSERT [dbo].[NewlyBuild] OFF /****** Object: Table [dbo].[Music] Script Date: 12/10/2020 21:36:44 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Music]( [m_id] [nvarchar](20) NOT NULL, [m_name] [nvarchar](100) NOT NULL, [m_authors] [nvarchar](100) NULL, [m_photo] [nvarchar](1000) NULL, [m_description] [nvarchar](2000) NULL, [m_publishdate] [datetime] NULL, [m_mediafile] [nvarchar](1000) NULL, [m_typeid] [nvarchar](20) NOT NULL, [m_clicknum] [int] NOT NULL, [m_mvfile] [nvarchar](1000) NULL, CONSTRAINT [PK_Music] PRIMARY KEY CLUSTERED ( [m_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 INSERT [dbo].[Music] ([m_id], [m_name], [m_authors], [m_photo], [m_description], [m_publishdate], [m_mediafile], [m_typeid], [m_clicknum], [m_mvfile]) VALUES (N'01', N'陪我长大', N'火箭少女101段奥娟', N'../img/陪我长大-火箭少女101段奥娟.png', N'', CAST(0x0000A93500000000 AS DateTime), N'../music/陪我长大 - 火箭少女101段奥娟.mp3', N'001', 21123, NULL) INSERT [dbo].[Music] ([m_id], [m_name], [m_authors], [m_photo], [m_description], [m_publishdate], [m_mediafile], [m_typeid], [m_clicknum], [m_mvfile]) VALUES (N'02', N'Mojito', N'周杰伦', N'../img/Mojito-周杰伦.png', N'', CAST(0x0000864300000000 AS DateTime), N'../music/Mojito - 周杰伦.mp3', N'001', 11131, N'') INSERT [dbo].[Music] ([m_id], [m_name], [m_authors], [m_photo], [m_description], [m_publishdate], [m_mediafile], [m_typeid], [m_clicknum], [m_mvfile]) VALUES (N'03', N'皆可', N'田馥甄', N'../img/皆可-田馥甄.png', N'2020年世界彷佛被按下暂停键，人们习以为常的生活型态因此改变，抛开既定的规则和方向，开启了新的生活方式，用新的逻辑有了各种新的选择，结束也可以是另一个重整的开始。在珍惜平安健康，细细体验生活的同时，无论我们可以或不可以去哪里，有什么可得不可得，可能不可能，可以不可以，面对未知，一切由心，一切皆可。', CAST(0x0000ABD700000000 AS DateTime), N'../music/皆可 - 田馥甄.mp3', N'001', 10, NULL) INSERT [dbo].[Music] ([m_id], [m_name], [m_authors], [m_photo], [m_description], [m_publishdate], [m_mediafile], [m_typeid], [m_clicknum], [m_mvfile]) VALUES (N'04', N'庐州月', N'许嵩', N'../img/庐州月-许嵩.png', N'', CAST(0x00009CF600000000 AS DateTime), N'../music/庐州月 - 许嵩.mp3', N'001', 4, NULL) INSERT [dbo].[Music] ([m_id], [m_name], [m_authors], [m_photo], [m_description], [m_publishdate], [m_mediafile], [m_typeid], [m_clicknum], [m_mvfile]) VALUES (N'05', N'那些年', N'胡夏', N'../img/那些年-胡夏.png', N'', CAST(0x0000A00100000000 AS DateTime), N'../music/那些年 - 胡夏.mp3', N'001', 8, NULL) INSERT [dbo].[Music] ([m_id], [m_name], [m_authors], [m_photo], [m_description], [m_publishdate], [m_mediafile], [m_typeid], [m_clicknum], [m_mvfile]) VALUES (N'06', N'我的一个道姑朋友', N'LON', N'../img/我的一个道姑朋友-LON.png', N'', CAST(0x0000A76300000000 AS DateTime), N'../music/我的一个道姑朋友 - LON.mp3', N'001', 5, NULL) INSERT [dbo].[Music] ([m_id], [m_name], [m_authors], [m_photo], [m_description], [m_publishdate], [m_mediafile], [m_typeid], [m_clicknum], [m_mvfile]) VALUES (N'07', N'剑心', N'张杰', N'../img/剑心-张杰.png', N'', CAST(0x0000A35800000000 AS DateTime), N'../music/剑心 - 张杰.mp3', N'001', 5, NULL) INSERT [dbo].[Music] ([