ALTER TABLE bazzar_pos.sales_orders
ADD COLUMN IF NOT EXISTS employee_id BIGINT NULL REFERENCES bazzar_pos.employees(id),
ADD COLUMN IF NOT EXISTS employee_name_snapshot VARCHAR(150);

CREATE INDEX IF NOT EXISTS idx_sales_orders_employee_id
    ON bazzar_pos.sales_orders(employee_id);
