/*
Navicat MySQL Data Transfer
Source Server : 47.94.156.208
Source Server Version : 50648
Source Host : 47.94.156.208:3306
Source Database : mp3
Target Server Type : MYSQL
Target Server Version : 50648
File Encoding : 65001
Date: 2021-09-17 14:36:51
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for fa_lm_category
-- ----------------------------
DROP TABLE IF EXISTS `fa_lm_category`;
CREATE TABLE `fa_lm_category` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`nickname` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`cover_image` text COLLATE utf8mb4_unicode_ci,
`keywords` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`createtime` int(10) DEFAULT NULL COMMENT '创建时间',
`updatetime` int(10) DEFAULT NULL COMMENT '更新时间',
`weigh` int(10) NOT NULL DEFAULT '0' COMMENT '权重',
`status` tinyint(1) DEFAULT '1' COMMENT '状态:0=异常,1=正常',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='音乐分类';
-- ----------------------------
-- Records of fa_lm_category
-- ----------------------------
INSERT INTO `fa_lm_category` VALUES ('1', 'Rock and roll', '摇滚', 'https://gimg2.baidu.com/image_search/src=http%3A%2F%2Ffile.adquan.com%2Fuploads_img%2F741xo1563345435.jpg&refer=http%3A%2F%2Ffile.adquan.com&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=jpeg?sec=1634448298&t=b65a8f309cae01911e55848f0544ac90', '摇滚', '摇滚', '1631856424', '1631856424', '0', '1');
INSERT INTO `fa_lm_category` VALUES ('2', 'popular', '流行', 'https://gimg2.baidu.com/image_search/src=http%3A%2F%2Ffile.adquan.com%2Fuploads_img%2F741xo1563345435.jpg&refer=http%3A%2F%2Ffile.adquan.com&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=jpeg?sec=1634448298&t=b65a8f309cae01911e55848f0544ac90', '流行', '流行', '1631856424', '1631856424', '0', '1');
INSERT INTO `fa_lm_category` VALUES ('3', 'Sir', '爵士', 'https://gimg2.baidu.com/image_search/src=http%3A%2F%2Ffile.adquan.com%2Fuploads_img%2F741xo1563345435.jpg&refer=http%3A%2F%2Ffile.adquan.com&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=jpeg?sec=1634448298&t=b65a8f309cae01911e55848f0544ac90', '爵士', '爵士', '1631856424', '1631856424', '0', '1');
INSERT INTO `fa_lm_category` VALUES ('4', 'folk', '民谣', 'https://gimg2.baidu.com/image_search/src=http%3A%2F%2Ffile.adquan.com%2Fuploads_img%2F741xo1563345435.jpg&refer=http%3A%2F%2Ffile.adquan.com&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=jpeg?sec=1634448298&t=b65a8f309cae01911e55848f0544ac90', '民谣', '民谣', '1631856424', '1631856424', '0', '1');
INSERT INTO `fa_lm_category` VALUES ('5', 'electronic', '电子', 'https://gimg2.baidu.com/image_search/src=http%3A%2F%2Ffile.adquan.com%2Fuploads_img%2F741xo1563345435.jpg&refer=http%3A%2F%2Ffile.adquan.com&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=jpeg?sec=1634448298&t=b65a8f309cae01911e55848f0544ac90', '电子', '电子', '1631856424', '1631856424', '0', '1');
INSERT INTO `fa_lm_category` VALUES ('6', 'metal', '金属', 'https://gimg2.baidu.com/image_search/src=http%3A%2F%2Ffile.adquan.com%2Fuploads_img%2F741xo1563345435.jpg&refer=http%3A%2F%2Ffile.adquan.com&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=jpeg?sec=1634448298&t=b65a8f309cae01911e55848f0544ac90', '金属', '金属', '1631856424', '1631856424', '0', '1');
INSERT INTO `fa_lm_category` VALUES ('7', 'Hip hop', '嘻哈', 'https://gimg2.baidu.com/image_search/src=http%3A%2F%2Ffile.adquan.com%2Fuploads_img%2F741xo1563345435.jpg&refer=http%3A%2F%2Ffile.adquan.com&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=jpeg?sec=1634448298&t=b65a8f309cae01911e55848f0544ac90', '嘻哈', '嘻哈', '1631856424', '1631856424', '0', '1');
INSERT INTO `fa_lm_category` VALUES ('8', 'The classical', '古典', 'https://gimg2.baidu.com/image_search/src=http%3A%2F%2Ffile.adquan.com%2Fuploads_img%2F741xo1563345435.jpg&refer=http%3A%2F%2Ffile.adquan.com&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=jpeg?sec=1634448298&t=b65a8f309cae01911e55848f0544ac90', '古典', '古典', '1631856424', '1631856424', '0', '1');
INSERT INTO `fa_lm_category` VALUES ('9', 'R&B', '布鲁斯', 'https://gimg2.baidu.com/image_search/src=http%3A%2F%2Ffile.adquan.com%2Fuploads_img%2F741xo1563345435.jpg&refer=http%3A%2F%2Ffile.adquan.com&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=jpeg?sec=1634448298&t=b65a8f309cae01911e55848f0544ac90', '布鲁斯', '布鲁斯', '1631856424', '1631856424', '0', '1');
INSERT INTO `fa_lm_category` VALUES ('10', 'rural', '乡村', 'https://gimg2.baidu.com/image_search/src=http%3A%2F%2Ffile.adquan.com%2Fuploads_img%2F741xo1563345435.jpg&refer=http%3A%2F%2Ffile.adquan.com&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=jpeg?sec=1634448298&t=b65a8f309cae01911e55848f0544ac90', '乡村', '乡村', '1631856424', '1631856424', '0', '1');
INSERT INTO `fa_lm_category` VALUES ('11', 'reggae', '雷鬼', 'https://gimg2.baidu.com/image_search/src=http%3A%2F%2Ffile.adquan.com%2Fuploads_img%2F741xo1563345435.jpg&refer=http%3A%2F%2Ffile.adquan.com&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=jpeg?sec=1634448298&t=b65a8f309cae01911e55848f0544ac90', '雷鬼', '雷鬼', '1631856424', '1631856424', '0', '1');
INSERT INTO `fa_lm_category` VALUES ('12', 'Latin', '拉丁', 'https://gimg2.baidu.com/image_search/src=http%3A%2F%2Ffile.adquan.com%2Fuploads_img%2F741xo1563345435.jpg&refer=http%3A%2F%2Ffile.adquan.com&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=jpeg?sec=1634448298&t=b65a8f309cae01911e55848f0544ac90', '拉丁', '拉丁', '1631856424', '1631856424', '0', '1');
INSERT INTO `fa_lm_category` VALUES ('13', 'national', '民族', 'https://gimg2.baidu.com/image_search/src=http%3A%2F%2Ffile.adquan.com%2Fuploads_img%2F741xo1563345435.jpg&refer=http%3A%2F%2Ffile.adquan.com&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=jpeg?sec=1634448298&t=b65a8f309cae01911e55848f0544ac90', '民族', '民族', '1631856424', '1631856424', '0', '1');
INSERT INTO `fa_lm_category` VALUES ('14', 'The experiment', '实验', 'https://gimg2.baidu.com/image_search/src=http%3A%2F%2Ffile.adquan.com%2Fuploads_img%2F741xo1563345435.jpg&refer=http%3A%2F%2Ffile.adquan.com&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=jpeg?sec=1634448298&t=b65a8f309cae01911e55848f0544ac90', '实验', '实验', '1631856424', '1631856424', '0', '1');
INSERT INTO `fa_lm_category` VALUES ('15', 'Light music', '轻音乐', 'https://gimg2.baidu.com/image_search/src=http%3A%2F%2Ffile.adquan.com%2Fuploads_img%2F741xo1563345435.jpg&refer=http%3A%2F%2Ffile.adquan.com&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=jpeg?sec=1634448298&t=b65a8f309cae01911e55848f0544ac90', '轻音乐', '轻音乐', '1631856424', '1631856424', '0', '1');
INSERT INTO `fa_lm_category` VALUES ('16', 'children', '儿童', 'https://gimg2.baidu.com/image_search/src=http%3A%2F%2Ffile.adquan.com%2Fuploads_img%2F741xo1563345435.jpg&refer=http%3A%2F%2Ffile.adquan.com&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=jpeg?sec=1634448298&t=b65a8f309cae01911e55848f0544ac90', '儿童', '儿童', '1631856424', '1631856424', '0', '1');
-- ----------------------------
-- Table structure for fa_lm_label
-- ----------------------------
DROP TABLE IF EXISTS `fa_lm_label`;
CREATE TABLE `fa_lm_label` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`nickname` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`keywords` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`createtime` int(10) DEFAULT NULL COMMENT '创建时间',
`updatetime` int(10) DEFAULT NULL COMMENT '更新时间',
`weigh` int(10) NOT NULL DEFAULT '0' COMMENT '权重',
`status` tinyint(1) DEFAULT '1' COMMENT '状态:0=异常,1=正常',