diff options
author | chai <chaifix@163.com> | 2022-03-25 11:03:53 +0800 |
---|---|---|
committer | chai <chaifix@163.com> | 2022-03-25 11:03:53 +0800 |
commit | f65e1a9b46f36f7784e9c239872979dd08f54953 (patch) | |
tree | b6b72687d4c4d2c142d1ed79d4b817b7ce763a81 | |
parent | 4e92033683d250c06d3e9f39caf675adc4b339f2 (diff) |
*sql
-rw-r--r-- | sql/musik.sql | 11 |
1 files changed, 4 insertions, 7 deletions
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 |