-- Интеграция с новой CRM (dana-medccrm).
-- Фиксация сделок по онлайн-записям и заявкам с сайта.

ALTER TABLE onec_appointments
    ADD COLUMN crm_deal_id       text NOT NULL DEFAULT '',
    ADD COLUMN crm_confirm_state text NOT NULL DEFAULT '',
    ADD COLUMN crm_error         text NOT NULL DEFAULT '',
    ADD COLUMN crm_sent_at       timestamptz;

CREATE INDEX onec_appointments_crm_idx ON onec_appointments (id) WHERE crm_deal_id = '' AND status = 'booked';

ALTER TABLE leads
    ADD COLUMN crm_deal_id text NOT NULL DEFAULT '',
    ADD COLUMN crm_error   text NOT NULL DEFAULT '',
    ADD COLUMN crm_sent_at timestamptz;

CREATE INDEX leads_crm_idx ON leads (id) WHERE crm_deal_id = '';