From f65e1a9b46f36f7784e9c239872979dd08f54953 Mon Sep 17 00:00:00 2001 From: chai Date: Fri, 25 Mar 2022 11:03:53 +0800 Subject: *sql --- sql/musik.sql | 11 ++++------- 1 file changed, 4 insertions(+), 7 deletions(-) (limited to 'sql') diff --git a/sql/musik.sql b/sql/musik.sql index 01e403b..f3c0e8f 100644 --- a/sql/musik.sql +++ b/sql/musik.sql @@ -10,12 +10,9 @@ Target Server Type : MYSQL Target Server Version : 50722 File Encoding : 65001 -Date: 2022-03-22 21:08:24 +Date: 2022-03-25 11:03:43 */ - - - SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- @@ -24,11 +21,11 @@ SET FOREIGN_KEY_CHECKS=0; DROP TABLE IF EXISTS `album`; CREATE TABLE `album` ( `id` int(32) unsigned NOT NULL AUTO_INCREMENT, - `name` text NOT NULL, + `title` text NOT NULL, `description` text, `cover` text, PRIMARY KEY (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for album_music @@ -39,7 +36,7 @@ CREATE TABLE `album_music` ( `music_id` int(32) NOT NULL, `album_id` int(32) NOT NULL, PRIMARY KEY (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for music -- cgit v1.1-26-g67d0