dodil/erp-brick-consolidation

DODIL ERP brick: consolidation

src/brick_consolidation/migrations/00002_slice_c/up.sql

-- 00002_slice_c — what slice C adds to the 00001 layout (apply after 00001_init; 00001 is not edited any more).
--   structure changes keep the figures they showed (divestiture, ownership change, step acquisition);
--   the migration run keeps its doors, checks, signer and checksums (CON-18);
--   settings become dated rows (CON-19).
ALTER TABLE cons_structure_change ADD COLUMN IF NOT EXISTS figures_json VARCHAR;

ALTER TABLE cons_cons_migration_runs ADD COLUMN IF NOT EXISTS doors_json VARCHAR;
ALTER TABLE cons_cons_migration_runs ADD COLUMN IF NOT EXISTS checks_json VARCHAR;
ALTER TABLE cons_cons_migration_runs ADD COLUMN IF NOT EXISTS signed_by VARCHAR;
ALTER TABLE cons_cons_migration_runs ADD COLUMN IF NOT EXISTS signed_sub VARCHAR;
ALTER TABLE cons_cons_migration_runs ADD COLUMN IF NOT EXISTS signed_at TIMESTAMP;
ALTER TABLE cons_cons_migration_runs ADD COLUMN IF NOT EXISTS checksums VARCHAR;

CREATE TABLE IF NOT EXISTS cons_setting_row (
    setting_key VARCHAR NOT NULL,
    scope       VARCHAR NOT NULL,
    valid_from  DATE NOT NULL,
    value       VARCHAR,
    set_by      VARCHAR,
    set_sub     VARCHAR,
    set_at      TIMESTAMP,
    created_at  TIMESTAMP,
    updated_at  TIMESTAMP,
    PRIMARY KEY (setting_key, scope, valid_from)
);

INSERT INTO cons_schema_migrations (migration, applied_at) VALUES ('00002_slice_c', CURRENT_TIMESTAMP);