X-Git-Url: https://git.jacobcasper.com/?p=perfect-gift.git;a=blobdiff_plain;f=backend%2Fmigrations%2F004-create_wishlist_entry.sql;fp=backend%2Fmigrations%2F004-create_wishlist_entry.sql;h=9826d5ab886086dd27eb5f3de24a52da65c22746;hp=0000000000000000000000000000000000000000;hb=d52f08d6553f3c61ee71067c791b94f1f1e041da;hpb=7f640a6b59bdce4326d1427689c00cb71600cb7d

diff --git a/backend/migrations/004-create_wishlist_entry.sql b/backend/migrations/004-create_wishlist_entry.sql
new file mode 100644
index 0000000..9826d5a
--- /dev/null
+++ b/backend/migrations/004-create_wishlist_entry.sql
@@ -0,0 +1,7 @@
+CREATE TABLE WISHLIST_ENTRY(
+    WISHLIST_ID TEXT NOT NULL REFERENCES WISHLIST(ID),
+    ITEM_ID INTEGER NOT NULL REFERENCES ITEM(ID),
+    NAME TEXT NOT NULL,
+    DESCRIPTION TEXT,
+    PRIMARY KEY(WISHLIST_ID, ITEM_ID)
+);