From 1620eba6716b63d78542fb857011e53a79c8e2dc Mon Sep 17 00:00:00 2001 From: Jacob Casper Date: Mon, 13 Apr 2020 22:14:42 -0500 Subject: [PATCH] Add migrations --- migrations/001-create_artist.sql | 4 ++++ migrations/002-create_genre.sql | 4 ++++ 2 files changed, 8 insertions(+) create mode 100644 migrations/001-create_artist.sql create mode 100644 migrations/002-create_genre.sql diff --git a/migrations/001-create_artist.sql b/migrations/001-create_artist.sql new file mode 100644 index 0000000..7910b80 --- /dev/null +++ b/migrations/001-create_artist.sql @@ -0,0 +1,4 @@ +CREATE TABLE ARTIST ( + ID TEXT PRIMARY KEY, + NAME TEXT +); diff --git a/migrations/002-create_genre.sql b/migrations/002-create_genre.sql new file mode 100644 index 0000000..6224609 --- /dev/null +++ b/migrations/002-create_genre.sql @@ -0,0 +1,4 @@ +CREATE TABLE GENRE ( + ID INTEGER PRIMARY KEY AUTOINCREMENT, + NAME TEXT NOT NULL UNIQUE +); -- 2.20.1