max / makenotwork

260 B · 4 lines History Blame Raw

1	-- Track which promo code was used for a transaction so the scheduler can
2	-- release reserved use_count slots when stale pending transactions are cleaned up.
3	ALTER TABLE transactions ADD COLUMN promo_code_id UUID REFERENCES promo_codes(id) ON DELETE SET NULL;
4