Create database during setup

[mercuryms.git] / migrations / 001-create_media.sql

diff --git a/migrations/001-create_media.sql b/migrations/001-create_media.sql
new file mode 100644 (file)
index 0000000..bb9f029
--- /dev/null
+++ b/migrations/001-create_media.sql
@@ -0,0 +1,5 @@
+CREATE TABLE MEDIA (
+    ID INTEGER PRIMARY KEY AUTOINCREMENT,
+    PHONE_NUMBER TEXT NOT NULL,
+    URI TEXT NOT NULL
+);