+ album

1 files changed, 74 insertions, 0 deletions

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;