projects
/
perfect-gift.git
/ blob
commit
grep
author
committer
pickaxe
?
search:
re
9826d5ab886086dd27eb5f3de24a52da65c22746
[perfect-gift.git]
/
backend
/
migrations
/
004-create_wishlist_entry.sql
1
CREATE TABLE
WISHLIST_ENTRY
(
2
WISHLIST_ID
TEXT
NOT NULL REFERENCES
WISHLIST
(
ID
),
3
ITEM_ID
INTEGER
NOT NULL REFERENCES
ITEM
(
ID
),
4
NAME
TEXT
NOT NULL
,
5
DESCRIPTION
TEXT
,
6
PRIMARY KEY
(
WISHLIST_ID
,
ITEM_ID
)
7
);