dodil/erp-brick-expenses

DODIL ERP brick: expenses

src/brick_expenses/migrations/00011_migration/up.sql

-- 00011_migration - slice B item 5: the Odoo slice (EXP-24): a run (loaded -> reconciled -> signed | discarded) and the map of Odoo ids to our keys. Additive only.

CREATE TABLE IF NOT EXISTS exp_migration_run (
    run_id          VARCHAR NOT NULL,
    odoo_db         VARCHAR,
    cutover_date    DATE,
    company_code    VARCHAR,
    status          VARCHAR,
    doors_json      VARCHAR,
    checks_json     VARCHAR,
    summary_json    VARCHAR,
    loaded_by       VARCHAR,
    signed_by       VARCHAR,
    signed_sub      VARCHAR,
    signed_on       DATE,
    discarded_by    VARCHAR,
    discard_reason  VARCHAR,
    created_at      TIMESTAMP,
    updated_at      TIMESTAMP,
    PRIMARY KEY (run_id)
);

CREATE TABLE IF NOT EXISTS exp_migration_map (
    odoo_db     VARCHAR NOT NULL,
    odoo_model  VARCHAR NOT NULL,
    odoo_id     VARCHAR NOT NULL,
    ours        VARCHAR,
    run_id      VARCHAR,
    created_at  TIMESTAMP,
    updated_at  TIMESTAMP,
    PRIMARY KEY (odoo_db, odoo_model, odoo_id)
);