diff options
| -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 |