From db58cb58b5d5612ec2aa347d0f8531b26ab2e7f3 Mon Sep 17 00:00:00 2001 From: niliara-edu Date: Fri, 27 Sep 2024 14:04:23 +0200 Subject: upload changes --- rust/scripts/create_db.sql | 41 +++++++++++++++++++++++++++++++++++++++++ 1 file changed, 41 insertions(+) create mode 100644 rust/scripts/create_db.sql (limited to 'rust/scripts/create_db.sql') diff --git a/rust/scripts/create_db.sql b/rust/scripts/create_db.sql new file mode 100644 index 0000000..f803714 --- /dev/null +++ b/rust/scripts/create_db.sql @@ -0,0 +1,41 @@ +CREATE DATABASE IF NOT EXISTS balalaika; +USE balalaika; + +DROP TABLE IF EXISTS song; +DROP TABLE IF EXISTS album; +DROP TABLE IF EXISTS artist; + +CREATE TABLE artist ( + id int NOT NULL AUTO_INCREMENT, + name varchar(255), + + PRIMARY KEY (id) +); + +CREATE TABLE album ( + id int NOT NULL AUTO_INCREMENT, + name varchar(255), + cover varchar(510), + artist_id int, + + PRIMARY KEY (id), + FOREIGN KEY (artist_id) REFERENCES artist(id) +); + +CREATE TABLE song ( + id int NOT NULL AUTO_INCREMENT, + name varchar(255), + lyrics TEXT, + + album_id int, + + PRIMARY KEY (id), + FOREIGN KEY (album_id) REFERENCES album(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; + +GRANT ALL PRIVILEGES ON balalaika.* TO 'balalaika_user'@'%' WITH GRANT OPTION; +FLUSH PRIVILEGES; -- cgit v1.2.3