X-Git-Url: https://git.jacobcasper.com/?p=mercuryms.git;a=blobdiff_plain;f=migrations%2F002-create_sent_media.sql;fp=migrations%2F002-create_sent_media.sql;h=85f81cf252b45b3ecceea996d74345895afd30e9;hp=0000000000000000000000000000000000000000;hb=de99d6c28b6cdb8c72f79df91669598ded432a6d;hpb=c53cc8d52b7d19cd0e9bcba4576b6be72672d717 diff --git a/migrations/002-create_sent_media.sql b/migrations/002-create_sent_media.sql new file mode 100644 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) +);