1 files changed, 9 insertions, 0 deletions
diff --git a/scripts/create_db.sql b/scripts/create_db.sql
index 405fa96..56423f5 100644
--- a/scripts/create_db.sql
+++ b/scripts/create_db.sql
@@ -34,9 +34,18 @@ CREATE TABLE song (
     FOREIGN KEY (album_id) REFERENCES album(id)
 );
 
+CREATE OR REPLACE TABLE user (
+    id int auto_increment,
+    name varchar(255) unique,
+    password varchar(510),
+    primary key(id)
+);
+
 ALTER TABLE song CONVERT TO CHARACTER SET utf8;
 ALTER TABLE album CONVERT TO CHARACTER SET utf8;
 ALTER TABLE artist CONVERT TO CHARACTER SET utf8;
+ALTER TABLE user CONVERT TO CHARACTER SET utf8;
 
 GRANT ALL PRIVILEGES ON balalaika.* TO 'balalaika_user'@'%' WITH GRANT OPTION;
 FLUSH PRIVILEGES;
+