dodil/erp-brick-product

src/brick_product/migrations/00002_migration_map/up.sql

-- 00002_migration_map — additive only. The Odoo id map later bricks read (shared.yaml conventions.odoo_migration.id_map).

CREATE TABLE IF NOT EXISTS prod_migration_map (
    odoo_db     VARCHAR NOT NULL,
    odoo_model  VARCHAR NOT NULL,
    odoo_id     VARCHAR NOT NULL,
    natural_key VARCHAR,
    created_at  TIMESTAMP,
    PRIMARY KEY (odoo_db, odoo_model, odoo_id)
);