From f980b021f1f1df132c4599cb4c1fb127a1ae289a Mon Sep 17 00:00:00 2001
From: chai <chaifix@163.com>
Date: Tue, 22 Mar 2022 20:42:48 +0800
Subject: + album

---
 sql/musik.sql | 74 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 74 insertions(+)
 create mode 100644 sql/musik.sql

(limited to 'sql/musik.sql')

diff --git a/sql/musik.sql b/sql/musik.sql
new file mode 100644
index 0000000..8d4233b
--- /dev/null
+++ b/sql/musik.sql
@@ -0,0 +1,74 @@
+/*
+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;
-- 
cgit v1.1-26-g67d0

