summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorchai <chaifix@163.com>2022-03-25 11:03:53 +0800
committerchai <chaifix@163.com>2022-03-25 11:03:53 +0800
commitf65e1a9b46f36f7784e9c239872979dd08f54953 (patch)
treeb6b72687d4c4d2c142d1ed79d4b817b7ce763a81
parent4e92033683d250c06d3e9f39caf675adc4b339f2 (diff)
*sql
-rw-r--r--sql/musik.sql11
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