BEGIN;

ALTER TABLE IF EXISTS sales.sales_customer_invoice_links
    ADD COLUMN IF NOT EXISTS journal_id bigint,
    ADD COLUMN IF NOT EXISTS journal_no varchar(80);

ALTER TABLE IF EXISTS sales.sales_receipts
    ADD COLUMN IF NOT EXISTS accounting_receipt_id bigint,
    ADD COLUMN IF NOT EXISTS journal_id bigint,
    ADD COLUMN IF NOT EXISTS journal_no varchar(80);

CREATE INDEX IF NOT EXISTS idx_sales_invoice_links_accounting
    ON sales.sales_customer_invoice_links (tenant_id, invoice_id, journal_id);

CREATE INDEX IF NOT EXISTS idx_sales_receipts_accounting
    ON sales.sales_receipts (tenant_id, accounting_receipt_id, journal_id);

COMMIT;