VvebOIDC/install/sql/sqlite/schema/user/user_wishlist.sql

8 lines
218 B
SQL

DROP TABLE IF EXISTS `user_wishlist`;
CREATE TABLE `user_wishlist` (
`user_id` INT NOT NULL,
`product_id` INT NOT NULL,
`created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`user_id`,`product_id`)
);