From: Jacob Casper <dev@jacobcasper.com>
Date: Tue, 14 Apr 2020 03:14:42 +0000 (-0500)
Subject: Add migrations
X-Git-Url: https://git.jacobcasper.com/?p=brackets.git;a=commitdiff_plain;h=1620eba6716b63d78542fb857011e53a79c8e2dc

Add migrations
---

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
+);