musichouse 数据库

最新推荐文章于 2011-09-09 17:15:08 发布

原创最新推荐文章于 2011-09-09 17:15:08 发布 · 351 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

标签

#table #insert #null #character #structure

数据库专栏收录该内容

69 篇文章

订阅专栏

本文档详细介绍了音乐数据库的设计，包括歌曲、歌手、专辑等表格的结构与字段说明。通过具体实例展示了每张表的数据插入示例。

# 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 */;