ALTER TABLE `coupon_redemptions` MODIFY COLUMN `order_id` varchar(36);--> statement-breakpoint
ALTER TABLE `coupon_redemptions` ADD `merch_order_id` varchar(36);--> statement-breakpoint
ALTER TABLE `coupons` ADD `applies_to` enum('tickets','merch','both') DEFAULT 'tickets' NOT NULL;--> statement-breakpoint
ALTER TABLE `merch_orders` ADD `coupon_id` varchar(36);--> statement-breakpoint
ALTER TABLE `merch_orders` ADD `coupon_code` varchar(64);--> statement-breakpoint
ALTER TABLE `merch_orders` ADD `discount_cents` int DEFAULT 0 NOT NULL;--> statement-breakpoint
ALTER TABLE `merch_orders` ADD `ticket_order_id` varchar(36);--> statement-breakpoint
ALTER TABLE `merch_products` ADD `image_urls` json;--> statement-breakpoint
ALTER TABLE `merch_products` ADD `compare_at_cents` int;--> statement-breakpoint
ALTER TABLE `orders` ADD `merch_order_id` varchar(36);--> statement-breakpoint
ALTER TABLE `coupon_redemptions` ADD CONSTRAINT `coupon_redemptions_merch_order_id_unique` UNIQUE(`merch_order_id`);