Add migrations

diff --git a/migrations/001-create_artist.sql b/migrations/001-create_artist.sql
new file mode 100644 (file)
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 (file)
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
+);