music.sql

1、上传所有文件至服务器目录。 2、使用 MYSQL 管理工具

DROP TABLE IF EXISTS music_box;
CREATE TABLE music_box (
   ID int(10) unsigned NOT NULL auto_increment,
   UserID int(10) unsigned NOT NULL,
   MusicID int(10) unsigned NOT NULL,
   webmusic smallint(6) NOT NULL,
   MusicName varchar(255) NOT NULL,
   Singer varchar(255) NOT NULL,
   ClassID int(10) unsigned NOT NULL,
   SClassID int(10) unsigned NOT NULL,
   NClassID int(10) unsigned NOT NULL,
   PRIMARY KEY (ID),
   KEY UserID (UserID)
);




DROP TABLE IF EXISTS music_class;
CREATE TABLE music_class (
   ClassID int(10) unsigned NOT NULL auto_increment,
   ClassName varchar(50) NOT NULL,
   PRIMARY KEY (ClassID)
);

INSERT INTO music_class VALUES('1', '所有类别');



DROP TABLE IF EXISTS music_lyric;
CREATE TABLE music_lyric (
   lyricid int(10) unsigned NOT NULL auto_increment,
   userid int(10) unsigned NOT NULL,
   musicid int(10) unsigned NOT NULL,
   visible smallint(6) NOT NULL,
   dateline int(10) unsigned NOT NULL,
   lyric mediumtext NOT NULL,
   PRIMARY KEY (lyricid),
   KEY musicid (musicid)
);




DROP TABLE IF EXISTS music_musiclist;
CREATE TABLE music_musiclist (
   ID int(10) unsigned NOT NULL auto_increment,
   FileName varchar(255) NOT NULL,
   MusicName varchar(100) NOT NULL,
   Singer varchar(50) NOT NULL,
   ClassID int(10) unsigned NOT NULL,
   SClassID int(10) unsigned NOT NULL,
   NClassID int(10) unsigned NOT NULL,
   Hits int(10) unsigned NOT NULL,
   SpecialID int(10) unsigned NOT NULL,
   IsGood tinyint(1) unsigned NOT NULL,
   PRIMARY KEY (ID),
   KEY Hits (Hits)
);

INSERT INTO music_musiclist VALUES('51246', 'new/20037/54/01.wma', 'Better Man (林忆莲“Better Man”原曲) - Robbie Williams', 'Modern Love', '1', '4', '2149', '390', '4203', '0');
INSERT INTO music_musiclist VALUES('51247', 'new/20037/54/02.wma', 'Words (电讯广告歌) - Boyzone', 'Modern Love', '1', '4', '2149', '315', '4203', '0');
INSERT INTO music_musiclist VALUES('51248', 'new/20037/54/03.wma', 'My Love - Westlife', 'Modern Love', '1', '4', '2149', '328', '4203', '0');
INSERT INTO music_musiclist VALUES('51249', 'new/20037/54/04.wma', 'Only Love (张学友“Only Love”原曲) - Trademark', 'Modern Love', '1', '4', '2149', '341', '4203', '0');
INSERT INTO music_musiclist VALUES('51250', 'new/20037/54/05.wma', 'What Can I Do - The Corrs', 'Modern Love', '1', '4', '2149', '252', '4203', '0');
INSERT INTO music_musiclist VALUES('51251', 'new/20037/54/06.wma', 'I\'m Not A Girl，Not Yet A Woman - Britney Spears', 'Modern Love', '1', '4', '2149', '246', '4203', '0');
INSERT INTO music_musiclist VALUES('51252', 'new/20037/54/07.wma', 'When You Say Nothing At All(电影“摘星奇缘”插曲)-Ronan Keating', 'Modern Love', '1', '4', '2149', '307', '4203', '0');
INSERT INTO music_musiclist VALUES('51253', 'new/20037/54/08.wma', 'If You Come Back - Blue', 'Modern Love', '1', '4', '2149', '244', '4203', '0');
INSERT INTO music_musiclist VALUES('51254', 'new/20037/54/09.wma', 'Pretty Boy - M2M', 'Modern Love', '1', '4', '2149', '289', '4203', '0');
INSERT INTO music_musiclist VALUES('51255', 'new/20037/54/10.wma', 'Kiss Me(电影“忽然爱上你”插曲)-Sixpence None The Richer', 'Modern Love', '1', '4', '2149', '303', '4203', '0');
INSERT INTO music_musiclist VALUES('51256', 'new/20037/54/11.wma', 'Emotion - Destingy\'s Child', 'Modern Love', '1', '4', '2149', '233', '4203', '0');
INSERT INTO music_musiclist VALUES('51257', 'new/20037/54/12.wma', '7 Days - Craig David', 'Modern Love', '1', '4', '2149', '231', '4203', '0');
INSERT INTO music_musiclist VALUES('51258', 'new/20037/54/13.wma', 'Torn - Natalie Imbruglia', 'Modern Love', '1', '4', '2149', '219', '4203', '0');
INSERT INTO music_musiclist VALUES('51259', 'new/20037/54/14.wma', 'This I Promise You - NSync', 'Modern Love', '1', '4', '2149', '224', '4203', '0');
INSERT INTO music_musiclist VALUES('51260', 'new/20037/54/15.wma', 'I\'ll Never Break Your Heart - Backstreet Boys', 'Modern Love', '1', '4', '2149', '217', '4203', '0');
INSERT INTO music_musiclist VALUES('51261', 'new/20037/54/16.wma', 'How Do I Live - LeAnn Rimes', 'Modern Love', '1', '4', '2149', '221', '4203', '0');
INSERT INTO music_musiclist VALUES('51262', 'new/20037/54/17.wma', 'There You\'ll Be(电影“珍珠港”主题曲)-Faith Hill', 'Modern Love', '1', '4', '2149', '304', '4203', '0');
INSERT INTO music_musiclist VALUES('51263', 'new/20037/54/18.wma', 'To Where You Are(电视剧 Ally Mcbeal插曲)-Josh Groban', 'Modern Love', '1', '4', '2149', '227', '4203', '0');
INSERT INTO music_musiclist VALUES('51276', 'new/20037/56/01.wma', '我该用什么样的心来对你', '黄品源[Huang, Pin Yuan]', '1', '1', '127', '37', '4205', '0');
INSERT INTO music_musiclist VALUES('51277', 'new/20037/56/02.wma', '小薇', '黄品源[Huang, Pin Yuan]', '1', '1', '127', '44', '4205', '0');
INSERT INTO music_musiclist VALUES('51278', 'new/20037/56/03.wma', '狠不下心', '黄品源[Huang, Pin Yuan]', '1', '1', '127', '35', '4205', '0');
INSERT INTO music_musiclist VALUES('51279', 'new/20037/56/04.wma', '海浪', '黄品源[Huang, Pin Yuan]', '1', '1', '127', '38', '4205', '0');
INSERT INTO music_musiclist VALUES('51280', 'new/20037/56/05.wma', '浪花一朵朵', '黄品源[Huang, Pin Yuan]', '1', '1', '127', '38', '4205', '0');