Files
kaffeekasse-saas/database/migrations/0030_contract_termination.sql

5 lines
224 B
SQL

ALTER TABLE tenants
ADD COLUMN termination_requested_at DATETIME NULL AFTER customer_type,
ADD COLUMN contract_ends_at DATETIME NULL AFTER termination_requested_at,
ADD KEY idx_tenants_contract_end (contract_ends_at);