[perfect-gift.git] / backend / migrations / 005-create_user_wishlist.sql

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)
);
Commit	Line	Data
d52f08d6 DT	1	CREATE TABLE USER_WISHLIST(
	2	USER_ID INTEGER NOT NULL REFERENCES USER(ID),
	3	WISHLIST_ID TEXT NOT NULL REFERENCES WISHLIST(ID),
	4	PRIMARY KEY(USER_ID, WISHLIST_ID)
	5	);