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

diff --git a/backend/migrations/005-create_user_wishlist.sql b/backend/migrations/005-create_user_wishlist.sql
new file mode 100644
index 0000000..9480c30
--- /dev/null
+++ b/backend/migrations/005-create_user_wishlist.sql
@@ -0,0 +1,5 @@
+CREATE TABLE USER_WISHLIST(
+    USER_ID INTEGER NOT NULL REFERENCES USER(ID),
+    WISHLIST_ID TEXT NOT NULL REFERENCES WISHLIST(ID),
+    PRIMARY KEY(USER_ID, WISHLIST_ID)
+);