musichouse 数据库

 # MySQL-Front 3.2  (Build 13.0)

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES */;

/*!40101 SET NAMES gb2312 */;

# Host: .    Database: musichouse
# ------------------------------------------------------
# Server version 4.0.24-nt

#
# Table structure for table comment
#

DROP TABLE IF EXISTS `comment`;  //用户评论
CREATE TABLE `comment` (
  `id` int(11) NOT NULL auto_increment,
  `content` text,
  `saytime` datetime default NULL,
  `music_id` int(11) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Dumping data for table comment
#

#
# Table structure for table music  //歌曲
#

DROP TABLE IF EXISTS `music`;
CREATE TABLE `music` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(100) default NULL,
  `singer_id` varchar(11) default NULL,
  `picurl` varchar(11) default NULL,
  `url` text,
  `format` varchar(11) default 'mp3',
  `type_id` varchar(11) default '1',
  `lyric` text,
  `special_id` int(11) default '0',
  `clicknum` int(11) default '0',
  `tuijian` int(11) default '0',
  `redian` int(11) default '0',
  `newss` int(11) default '0',
  `publictime` datetime default NULL,
  `orders` int(11) default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Dumping data for table music
#

INSERT INTO `music` VALUES (1,'生命之光','1','d:/tu/1.jpg','E:/music/周笔畅 - 生命之光.mp3','mp3','4','mamadeyayaa11',0,0,0,0,0,NULL,0);
INSERT INTO `music` VALUES (2,'等着你回来','1','d:/tu/2.jpg','E:/music/周惠-等着你回来.mp3','mp3','4','mamadeyayaa222',0,0,0,0,0,NULL,0);
INSERT INTO `music` VALUES (3,'张韶涵-亲爱的那不是爱情.mp3','1','d:/tu/2.jpg','E:/music/张韶涵-亲爱的那不是爱情.mp3','mp3','2','mamadeyayaa333',0,0,0,0,0,NULL,0);
INSERT INTO `music` VALUES (4,'庾澄庆-情非得已(流星花园主题曲).mp3','1','d:/tu/4.jpg','E:/music/庾澄庆-情非得已(流星花园主题曲).mp3','mp3','2','mamadeyayaa334444',0,0,0,0,0,NULL,0);

#
# Table structure for table singer
#

DROP TABLE IF EXISTS `singer`;   //歌手
CREATE TABLE `singer` (
  `id` int(11) NOT NULL auto_increment,
  `singername` varchar(11) default NULL,
  `singer_type_id` int(11) default NULL,
  `hot` int(11) default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Dumping data for table singer
#

INSERT INTO `singer` VALUES (1,'周笔畅',2,0);

#
# Table structure for table singer_type
#

DROP TABLE IF EXISTS `singer_type`;  //歌手类别
CREATE TABLE `singer_type` (
  `id` int(11) NOT NULL auto_increment,
  `type` varchar(11) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Dumping data for table singer_type
#

INSERT INTO `singer_type` VALUES (1,'内地男歌手');
INSERT INTO `singer_type` VALUES (2,'内地女歌手');
INSERT INTO `singer_type` VALUES (3,'内地组合');
INSERT INTO `singer_type` VALUES (4,'欧美歌手');
INSERT INTO `singer_type` VALUES (7,'日韩男歌');
INSERT INTO `singer_type` VALUES (8,'日韩女歌');
INSERT INTO `singer_type` VALUES (9,'日韩组合');
INSERT INTO `singer_type` VALUES (10,'港台男歌手');
INSERT INTO `singer_type` VALUES (11,'港台女歌手');
INSERT INTO `singer_type` VALUES (12,'港台组合');

#
# Table structure for table smusic
#

DROP TABLE IF EXISTS `smusic`;   //静态歌曲,就是生成了html的播放歌曲页
CREATE TABLE `smusic` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(100) default NULL,
  `filesrc` text,
  `singer_id` varchar(11) default NULL,
  `type_id` varchar(11) default '1',
  `special_id` int(11) default '0',
  `tuijian` int(11) default '0',
  `redian` int(11) default '0',
  `newss` int(11) default '0',
  `publictime` datetime default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Dumping data for table smusic
#

INSERT INTO `smusic` VALUES (6,'彩虹天堂.','2008-07-16/1216200066859.html',NULL,NULL,NULL,NULL,NULL,NULL,'2008-07-16 00:00:00');

#
# Table structure for table special
#

DROP TABLE IF EXISTS `special`;   //专辑
CREATE TABLE `special` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(11) default NULL,
  `picurl` varchar(11) default NULL,
  `singer_id` int(11) default NULL,
  `intro` text,
  `tuijian` int(11) default '0',
  `newss` int(11) default '0',
  `redian` int(11) default '0',
  `orders` int(11) default '0',
  `publiccompany` varchar(11) default NULL,
  `publictime` datetime default NULL,
  `language` varchar(11) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Dumping data for table special
#

#
# Table structure for table type
#

DROP TABLE IF EXISTS `type`;  //歌曲类型
CREATE TABLE `type` (
  `id` int(11) NOT NULL auto_increment,
  `type` varchar(11) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Dumping data for table type
#

INSERT INTO `type` VALUES (1,'动漫');
INSERT INTO `type` VALUES (2,'影视');
INSERT INTO `type` VALUES (3,'摇滚');
INSERT INTO `type` VALUES (4,'其它');
INSERT INTO `type` VALUES (5,'专辑');
INSERT INTO `type` VALUES (6,'港台');
INSERT INTO `type` VALUES (7,'内地');
INSERT INTO `type` VALUES (8,'欧美');
INSERT INTO `type` VALUES (9,'日韩');

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;