-- Migration 013: Odoo bi-directional sync columns

-- Customer/Partner links
ALTER TABLE customers ADD COLUMN odoo_partner_id INT DEFAULT NULL AFTER customer_id;
CREATE INDEX idx_customers_odoo_partner ON customers(odoo_partner_id);

-- Invoice/Move links + Odoo amount tracking
ALTER TABLE invoices ADD COLUMN odoo_move_id INT DEFAULT NULL AFTER invoice_id;
ALTER TABLE invoices ADD COLUMN odoo_amount_total DECIMAL(12,2) DEFAULT NULL AFTER odoo_move_id;
ALTER TABLE invoices ADD COLUMN odoo_amount_residual DECIMAL(12,2) DEFAULT NULL AFTER odoo_amount_total;
CREATE INDEX idx_invoices_odoo_move ON invoices(odoo_move_id);

-- Parts/Product links
ALTER TABLE parts_catalog ADD COLUMN odoo_product_id INT DEFAULT NULL AFTER part_id;
CREATE INDEX idx_parts_odoo_product ON parts_catalog(odoo_product_id);

-- Appointment → Odoo task link
ALTER TABLE appointments ADD COLUMN odoo_task_id INT DEFAULT NULL AFTER appointment_id;
CREATE INDEX idx_appointments_odoo_task ON appointments(odoo_task_id);

-- Payment → Odoo payment link
ALTER TABLE payments ADD COLUMN odoo_payment_id INT DEFAULT NULL AFTER payment_id;
CREATE INDEX idx_payments_odoo_payment ON payments(odoo_payment_id);