蓝鲸音乐网站数据库设计源代码

- 日理万妓 2023-10-09 22:11 39阅读 0赞

蓝鲸音乐网站数据库设计源代码

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] ([m_id], [m_name], [m_authors], [m_photo], [m_description], [m_publishdate], [m_mediafile], [m_typeid], [m_clicknum], [m_mvfile]) VALUES (N'08', N'云烟成雨', N'房东的猫', N'../img/云烟成雨-房东的猫.png', N'', CAST(0x0000A91200000000 AS DateTime), N'../music/云烟成雨 - 房东的猫.mp3', N'003', 9, 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'09', N'在一起嘛好不好', N'李荣浩', N'../img/在一起嘛好不好-李荣浩.png', N'', CAST(0x0000ABCF00000000 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'10', N'刚刚好', N'薛之谦', N'../img/刚刚好-薛之谦.png', N'', CAST(0x0000A64700000000 AS DateTime), N'../music/刚刚好 - 薛之谦.mp3', N'001', 24, 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'11', N'入海', N'毛不易', N'../img/入海-毛不易.png', N'', CAST(0x0000ABC100000000 AS DateTime), N'../music/入海 - 毛不易.mp3', N'001', 2, 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'12', N'富士山下', N'陈奕迅', N'../img/富士山下-陈奕迅.png', N'', CAST(0x0000988200000000 AS DateTime), N'../music/富士山下 - 陈奕迅.mp3', N'005', 3, 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'13', N'红玫瑰', N'陈奕迅', N'../img/红玫瑰-陈奕迅.png', N'', CAST(0x0000991A00000000 AS DateTime), N'../music/红玫瑰 - 陈奕迅.mp3', N'001', 2, 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'14', N'不要说话', N'陈奕迅', N'../img/不要说话-陈奕迅.png', N'', CAST(0x00009ACB00000000 AS DateTime), N'../music/不要说话 - 陈奕迅.mp3', N'001', 34, 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'15', N'无人之岛', N'任然', N'../img/无人之岛-任然.png', N'', CAST(0x0000A7E000000000 AS DateTime), N'../music/无人之岛 - 任然.mp3', N'001', 1, 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'16', N'Salt', N'AvaMax', N'../img/Salt-AvaMax.png', N'', CAST(0x0000AB9F00000000 AS DateTime), N'../music/Salt - AvaMax.mp3', N'004', 11, 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'17', N'雨幕', N'许嵩', N'../img/雨幕-许嵩.png', N'', CAST(0x0000AAE500000000 AS DateTime), N'../music/雨幕 - 许嵩.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'18', N'只要平凡', N'张杰', N'../img/只要平凡-张杰.png', N'', CAST(0x0000A90A00000000 AS DateTime), N'../music/只要平凡 - 张杰.mp3', N'001', 0, 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'19', N'爱人啊', N'张杰', N'../img/爱人啊-张杰.png', N'', CAST(0x0000ABAB00000000 AS DateTime), N'../music/爱人啊 - 张杰.mp3', N'001', 2, 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'20', N'我乐意', N'许嵩', N'../img/我乐意-许嵩.png', N'', CAST(0x0000A8C700000000 AS DateTime), N'../music/我乐意 - 许嵩.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'21', N'6', N'吴亦凡', N'../img/6-吴亦凡.png', N'“6”是一首复古亚特兰大陷阱曲风的hip-hop，为了让“6”这首歌的嘻哈灵魂更为彰显，制作上以吴亦凡低音调的唱腔衬搭笛声音效、大量的808踢鼓、脚踏钹与有层次的合成器来融汇东西方音乐成分。这首歌的歌词诉说着人们心中皆有特“6”特牛的乌托邦，但很多人只知道眼红别人拥有的一切却忽略别人为此而付出的努力，唯有拥有实力才能主宰世界并掌握资源，与其自怨自艾、坐以待毙，倒不如背水一战、筑梦踏实。', CAST(0x0000A7BB00000000 AS DateTime), N'../music/6 - 吴亦凡.mp3', N'002', 125, 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'22', N'不分手的恋爱', N'汪苏泷', N'../img/不分手的恋爱-汪苏泷.png', N'', CAST(0x00009F5900000000 AS DateTime), N'../music/不分手的恋爱 - 汪苏泷.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'23', N'有点甜', N'汪苏泷', N'../img/有点甜-汪苏泷.png', N'', CAST(0x0000A09000000000 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'24', N'犯贱', N'徐良', N'../img/犯贱-徐良.png', N'', CAST(0x00009E5600000000 AS DateTime), N'../music/犯贱 - 徐良.mp3', N'001', 2, 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'25', N'光辉岁月', N'BEYOND', N'../img/光辉岁月-BEYOND.png', N'', CAST(0x00009A5200000000 AS DateTime), N'../music/光辉岁月 - BEYOND.mp3', N'005', 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'26', N'旧梦一场', N'阿悠悠', N'../img/旧梦一场-阿悠悠.png', N'', CAST(0x0000ABA500000000 AS DateTime), N'../music/旧梦一场 - 阿悠悠.mp3', N'001', 2, 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'27', N'好久不见', N'陈奕迅', N'../img/好久不见-陈奕迅.png', N'', CAST(0x0000991A00000000 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'28', N'Take Me Hand', N'DAISHI DANCE', N'../img/TakeMeHand-DAISHIDANCE.png', N'', CAST(0x0000A10900000000 AS DateTime), N'../music/TakeMeHand  - DAISHIDANCE.mp3', N'004', 10, 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'29', N'SomethingJustLikeThis', N'TheChainsmokersColdplay', N'../img/SomethingJustLikeThis-TheChainsmokersColdplay.png', N'', CAST(0x0000A74E00000000 AS DateTime), N'../music/SomethingJustLikeThis - TheChainsmokersColdplay.mp3', N'004', 7, 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'30', N'BecauseOfYou', N'KellyClarkson', N'../img/BecauseOfYou-KellyClarkson.png', N'', CAST(0x000095AF00000000 AS DateTime), N'../music/BecauseOfYou - KellyClarkson.mp3', N'004', 4, 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'31', N'Closer', N'TheChainsmokersHalsey', N'../img/Closer-TheChainsmokersHalsey.png', N'', CAST(0x0000A6B400000000 AS DateTime), N'../music/Closer - TheChainsmokersHalsey.mp3', N'004', 4, 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'32', N'春娇与志明', N'街道办GDC _ 欧阳耀莹', N'../img/春娇与志明-街道办GDC _ 欧阳耀莹.png', N'', CAST(0x0000A79D00000000 AS DateTime), N'../music/春娇与志明 - 街道办GDC _ 欧阳耀莹.mp3', N'005', 2, 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'33', N'你瞒我瞒', N'陈柏宇', N'../img/你瞒我瞒-陈柏宇.png', N'', CAST(0x00009C0600000000 AS DateTime), N'../music/你瞒我瞒 - 陈柏宇.mp3', N'005', 2, 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'34', N'讲不出再见', N'谭咏麟', N'../img/讲不出再见-谭咏麟.png', N'', CAST(0x0000864300000000 AS DateTime), N'../music/讲不出再见 - 谭咏麟.mp3', N'005', 23, 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'35', N'当我唱起这首歌', N'小贱', N'../img/当我唱起这首歌-小贱.png', N'', CAST(0x00009EC400000000 AS DateTime), N'../music/当我唱起这首歌 - 小贱.mp3', N'001', 33, 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'36', N'天分', N'薛之谦', N'../img/天分-薛之谦.png', N'无', CAST(0x0000ABCE00000000 AS DateTime), N'../music/天份 - 薛之谦.mp3', N'001', 45, 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'37', N'Blumming', N'IU', N'../img/iu.png', N'TS', CAST(0x0000ABCE00000000 AS DateTime), N'../music/Blueming - IU.mp3', N'001', 134, 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'38', N'你若成风', N'许嵩', N'../img/我乐意-许嵩.png', N'无', CAST(0x0000ABCE00000000 AS DateTime), N'../music/你若成风 - 许嵩.mp3', N'001', 1, NULL)
    /****** Object:  Table [dbo].[Comment]    Script Date: 12/10/2020 21:36:44 ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[Comment](
    	[m_id] [nvarchar](20) NULL,
    	[comment] [nvarchar](1000) NULL,
    	[u_cord] [int] NULL,
    	[times] [datetime] NULL
    ) ON [PRIMARY]
    GO
    INSERT [dbo].[Comment] ([m_id], [comment], [u_cord], [times]) VALUES (N'02', N'TTTS', 1, CAST(0x0000ABDC00D29498 AS DateTime))
    INSERT [dbo].[Comment] ([m_id], [comment], [u_cord], [times]) VALUES (N'02', N'饿了', 4, CAST(0x0000ABDC01118838 AS DateTime))
    INSERT [dbo].[Comment] ([m_id], [comment], [u_cord], [times]) VALUES (N'23', N'有点甜', 2, CAST(0x0000ABDD0126E430 AS DateTime))
    INSERT [dbo].[Comment] ([m_id], [comment], [u_cord], [times]) VALUES (N'37', N'IU我要给你生猴子', 1, CAST(0x0000AC3500A4CF04 AS DateTime))
    INSERT [dbo].[Comment] ([m_id], [comment], [u_cord], [times]) VALUES (N'31', N'klklklk', 2, CAST(0x0000AC8D00BCB1DC AS DateTime))
    /****** Object:  Table [dbo].[CollectMusic]    Script Date: 12/10/2020 21:36:44 ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[CollectMusic](
    	[c_musicid] [nvarchar](20) NOT NULL,
    	[c_usercord] [int] NOT NULL
    ) ON [PRIMARY]
    GO
    INSERT [dbo].[CollectMusic] ([c_musicid], [c_usercord]) VALUES (N'02', 4)
    INSERT [dbo].[CollectMusic] ([c_musicid], [c_usercord]) VALUES (N'02', 1)
    INSERT [dbo].[CollectMusic] ([c_musicid], [c_usercord]) VALUES (N'01', 4)
    INSERT [dbo].[CollectMusic] ([c_musicid], [c_usercord]) VALUES (N'03', 1)
    INSERT [dbo].[CollectMusic] ([c_musicid], [c_usercord]) VALUES (N'37', 1)
    INSERT [dbo].[CollectMusic] ([c_musicid], [c_usercord]) VALUES (N'36', 1)
    INSERT [dbo].[CollectMusic] ([c_musicid], [c_usercord]) VALUES (N'04', 3)
    INSERT [dbo].[CollectMusic] ([c_musicid], [c_usercord]) VALUES (N'17', 3)
    INSERT [dbo].[CollectMusic] ([c_musicid], [c_usercord]) VALUES (N'20', 3)
    INSERT [dbo].[CollectMusic] ([c_musicid], [c_usercord]) VALUES (N'38', 3)
    INSERT [dbo].[CollectMusic] ([c_musicid], [c_usercord]) VALUES (N'02', 2)
    INSERT [dbo].[CollectMusic] ([c_musicid], [c_usercord]) VALUES (N'08', 2)
    INSERT [dbo].[CollectMusic] ([c_musicid], [c_usercord]) VALUES (N'09', 2)
    INSERT [dbo].[CollectMusic] ([c_musicid], [c_usercord]) VALUES (N'36', 2)
    INSERT [dbo].[CollectMusic] ([c_musicid], [c_usercord]) VALUES (N'14', 2)
    INSERT [dbo].[CollectMusic] ([c_musicid], [c_usercord]) VALUES (N'19', 2)
    /****** Object:  Table [dbo].[BuildMusic]    Script Date: 12/10/2020 21:36:44 ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[BuildMusic](
    	[m_id] [nvarchar](20) NULL,
    	[n_id] [int] NULL,
    	[u_cord] [int] NULL
    ) ON [PRIMARY]
    GO
    INSERT [dbo].[BuildMusic] ([m_id], [n_id], [u_cord]) VALUES (N'23', 5, 2)
    INSERT [dbo].[BuildMusic] ([m_id], [n_id], [u_cord]) VALUES (N'01', 6, 2)
    INSERT [dbo].[BuildMusic] ([m_id], [n_id], [u_cord]) VALUES (N'07', 7, 2)
    INSERT [dbo].[BuildMusic] ([m_id], [n_id], [u_cord]) VALUES (N'16', 5, 2)
    INSERT [dbo].[BuildMusic] ([m_id], [n_id], [u_cord]) VALUES (N'28', 5, 2)
    INSERT [dbo].[BuildMusic] ([m_id], [n_id], [u_cord]) VALUES (N'29', 7, 2)
    INSERT [dbo].[BuildMusic] ([m_id], [n_id], [u_cord]) VALUES (N'34', 5, 2)
    INSERT [dbo].[BuildMusic] ([m_id], [n_id], [u_cord]) VALUES (N'25', 5, 2)
    INSERT [dbo].[BuildMusic] ([m_id], [n_id], [u_cord]) VALUES (N'36', 5, 2)
    INSERT [dbo].[BuildMusic] ([m_id], [n_id], [u_cord]) VALUES (N'21', 6, 2)
    INSERT [dbo].[BuildMusic] ([m_id], [n_id], [u_cord]) VALUES (N'08', 7, 2)
    /****** Object:  ForeignKey [FK_NewlyBuild_NewlyBuild]    Script Date: 12/10/2020 21:36:44 ******/
    ALTER TABLE [dbo].[NewlyBuild]  WITH CHECK ADD  CONSTRAINT [FK_NewlyBuild_NewlyBuild] FOREIGN KEY([u_cord])
    REFERENCES [dbo].[Users] ([u_cord])
    GO
    ALTER TABLE [dbo].[NewlyBuild] CHECK CONSTRAINT [FK_NewlyBuild_NewlyBuild]
    GO
    /****** Object:  ForeignKey [FK_Music_MusicTypes]    Script Date: 12/10/2020 21:36:44 ******/
    ALTER TABLE [dbo].[Music]  WITH CHECK ADD  CONSTRAINT [FK_Music_MusicTypes] FOREIGN KEY([m_typeid])
    REFERENCES [dbo].[MusicTypes] ([t_id])
    GO
    ALTER TABLE [dbo].[Music] CHECK CONSTRAINT [FK_Music_MusicTypes]
    GO
    /****** Object:  ForeignKey [FK_Comment_Music]    Script Date: 12/10/2020 21:36:44 ******/
    ALTER TABLE [dbo].[Comment]  WITH CHECK ADD  CONSTRAINT [FK_Comment_Music] FOREIGN KEY([m_id])
    REFERENCES [dbo].[Music] ([m_id])
    GO
    ALTER TABLE [dbo].[Comment] CHECK CONSTRAINT [FK_Comment_Music]
    GO
    /****** Object:  ForeignKey [FK_Comment_Users]    Script Date: 12/10/2020 21:36:44 ******/
    ALTER TABLE [dbo].[Comment]  WITH CHECK ADD  CONSTRAINT [FK_Comment_Users] FOREIGN KEY([u_cord])
    REFERENCES [dbo].[Users] ([u_cord])
    GO
    ALTER TABLE [dbo].[Comment] CHECK CONSTRAINT [FK_Comment_Users]
    GO
    /****** Object:  ForeignKey [FK_CollectMusic_Music]    Script Date: 12/10/2020 21:36:44 ******/
    ALTER TABLE [dbo].[CollectMusic]  WITH CHECK ADD  CONSTRAINT [FK_CollectMusic_Music] FOREIGN KEY([c_musicid])
    REFERENCES [dbo].[Music] ([m_id])
    GO
    ALTER TABLE [dbo].[CollectMusic] CHECK CONSTRAINT [FK_CollectMusic_Music]
    GO
    /****** Object:  ForeignKey [FK_CollectMusic_Users]    Script Date: 12/10/2020 21:36:44 ******/
    ALTER TABLE [dbo].[CollectMusic]  WITH CHECK ADD  CONSTRAINT [FK_CollectMusic_Users] FOREIGN KEY([c_usercord])
    REFERENCES [dbo].[Users] ([u_cord])
    GO
    ALTER TABLE [dbo].[CollectMusic] CHECK CONSTRAINT [FK_CollectMusic_Users]
    GO
    /****** Object:  ForeignKey [FK_BuildMusic_Music]    Script Date: 12/10/2020 21:36:44 ******/
    ALTER TABLE [dbo].[BuildMusic]  WITH CHECK ADD  CONSTRAINT [FK_BuildMusic_Music] FOREIGN KEY([m_id])
    REFERENCES [dbo].[Music] ([m_id])
    GO
    ALTER TABLE [dbo].[BuildMusic] CHECK CONSTRAINT [FK_BuildMusic_Music]
    GO
    /****** Object:  ForeignKey [FK_BuildMusic_NewlyBuild]    Script Date: 12/10/2020 21:36:44 ******/
    ALTER TABLE [dbo].[BuildMusic]  WITH CHECK ADD  CONSTRAINT [FK_BuildMusic_NewlyBuild] FOREIGN KEY([n_id])
    REFERENCES [dbo].[NewlyBuild] ([n_id])
    GO
    ALTER TABLE [dbo].[BuildMusic] CHECK CONSTRAINT [FK_BuildMusic_NewlyBuild]
    GO