From 5898e5ab4359945ef52dc7460bb2937a85603fc2 Mon Sep 17 00:00:00 2001 From: niliara-edu Date: Sun, 26 Jan 2025 12:25:13 +0100 Subject: authentication done --- scripts/create_db.sql | 9 +++++++++ 1 file changed, 9 insertions(+) (limited to 'scripts') 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; + -- cgit v1.2.3