From 4328dd17bfcd4c33a77c4405d52c3660a6c62bf5 Mon Sep 17 00:00:00 2001 From: nil0j Date: Fri, 27 Sep 2024 17:27:02 +0200 Subject: update --- scrap/create_db.sql | 38 -------------------------------------- 1 file changed, 38 deletions(-) delete mode 100644 scrap/create_db.sql (limited to 'scrap/create_db.sql') diff --git a/scrap/create_db.sql b/scrap/create_db.sql deleted file mode 100644 index bb5dbeb..0000000 --- a/scrap/create_db.sql +++ /dev/null @@ -1,38 +0,0 @@ -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; -- cgit v1.2.3