From 0972fa6eab8c9111311f082ba8abfdc6b4a40945 Mon Sep 17 00:00:00 2001
From: nil <nil@tfwhyno.gf>
Date: Wed, 2 Oct 2024 17:48:56 +0200
Subject: commit changes

---
 rust/scripts/populate/create_db.sql | 39 -------------------------------------
 1 file changed, 39 deletions(-)
 delete mode 100644 rust/scripts/populate/create_db.sql

(limited to 'rust/scripts/populate/create_db.sql')

diff --git a/rust/scripts/populate/create_db.sql b/rust/scripts/populate/create_db.sql
deleted file mode 100644
index cfde7b0..0000000
--- a/rust/scripts/populate/create_db.sql
+++ /dev/null
@@ -1,39 +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(255),
-    artist_id int,
-    release DATE,
-
-    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

