Create database during setup

[mercuryms.git] / migrations / 002-create_sent_media.sql

diff --git a/migrations/002-create_sent_media.sql b/migrations/002-create_sent_media.sql
new file mode 100644 (file)
index 0000000..85f81cf
--- /dev/null
+++ b/migrations/002-create_sent_media.sql
@@ -0,0 +1,5 @@
+CREATE TABLE SENT_MEDIA (
+    ID INTEGER PRIMARY KEY AUTOINCREMENT,
+    MEDIA_ID INTEGER NOT NULL,
+    FOREIGN KEY(MEDIA_ID) REFERENCES MEDIA(ID)
+);