VvebOIDC/install/sql/mysqli/schema/cart/coupon_taxonomy.sql

8 lines
260 B
SQL

DROP TABLE IF EXISTS `coupon_taxonomy`;
CREATE TABLE `coupon_taxonomy` (
`coupon_id` INT UNSIGNED NOT NULL,
`taxonomy_item_id` INT UNSIGNED NOT NULL,
PRIMARY KEY (`coupon_id`,`taxonomy_item_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;