Added database migration files

[perfect-gift.git] / backend / migrations / 004-create_wishlist_entry.sql

diff --git a/backend/migrations/004-create_wishlist_entry.sql b/backend/migrations/004-create_wishlist_entry.sql
new file mode 100644 (file)
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)
+);