/*
Navicat MySQL Data Transfer

Source Server         : wod
Source Server Version : 50722
Source Host           : localhost:3306
Source Database       : musik

Target Server Type    : MYSQL
Target Server Version : 50722
File Encoding         : 65001

Date: 2022-03-21 02:36:02
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for album
-- ----------------------------
DROP TABLE IF EXISTS `album`;
CREATE TABLE `album` (
  `id` int(32) unsigned NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `description` text,
  `cover` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for album_music
-- ----------------------------
DROP TABLE IF EXISTS `album_music`;
CREATE TABLE `album_music` (
  `id` int(32) unsigned NOT NULL AUTO_INCREMENT,
  `music_id` int(32) NOT NULL,
  `album_id` int(32) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for music
-- ----------------------------
DROP TABLE IF EXISTS `music`;
CREATE TABLE `music` (
  `id` int(32) unsigned NOT NULL AUTO_INCREMENT,
  `path` text NOT NULL,
  `title` text,
  `time` int(128) NOT NULL,
  `cover` text,
  `project` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for music_tag
-- ----------------------------
DROP TABLE IF EXISTS `music_tag`;
CREATE TABLE `music_tag` (
  `id` int(32) unsigned NOT NULL AUTO_INCREMENT,
  `music_id` int(32) DEFAULT NULL,
  `tag_id` int(32) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for tags
-- ----------------------------
DROP TABLE IF EXISTS `tags`;
CREATE TABLE `tags` (
  `id` int(32) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(128) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;
