-- Slice 8X-ContractHandoff · schema
-- 4 seat assignment columns on tender_contract_terms.
--   assigned_fm_user_id           → CRM assigns during handoff (Contract Signing tab)
--   assigned_accountant_user_id   → FM assigns during their prep
--   assigned_procurement_user_id  → FM assigns during their prep
--   assigned_pm_user_id           → Executive assigns during their approval
-- These seats are handed to Tenders::onContractApproved → convertToProject
-- so the new c_projects row is stamped with the right role owners on day 1.

ALTER TABLE tender_contract_terms
    ADD COLUMN assigned_fm_user_id           INT UNSIGNED NULL AFTER wht_pct,
    ADD COLUMN assigned_accountant_user_id   INT UNSIGNED NULL AFTER assigned_fm_user_id,
    ADD COLUMN assigned_procurement_user_id  INT UNSIGNED NULL AFTER assigned_accountant_user_id,
    ADD COLUMN assigned_pm_user_id           INT UNSIGNED NULL AFTER assigned_procurement_user_id;
