Romber

Database tables

romber_meta.schema_versions

• Purpose
• Definition
• Constraints
• Load

Purpose

This table provides a list of schema versions. This information doesn't need a data entry page as it should only be populated by update scripts.

A schema version is a set of metadata and other changes delivered in a Romber relese. It is used to synchronise and manage changes as they become available.

Definition

Source romber_meta_schema_versions_tbl.sql

create table romber_meta.schema_versions (
  meta_schema_id                romber_meta.schema_id           not null,
  meta_schema_version_applied   timestamp                       not null,
  meta_schema_version_id        romber_meta.schema_version_id   not null
                                  default nextval ( 'romber_base.generic_id_seq' ),
  version_major                 smallint                        not null,
  version_minor                 smallint                        not null,
  version_update                smallint                        not null );

Constraints

Source romber_meta_schema_versions_pk.sql

alter table romber_meta.schema_versions
  add constraint romber_meta_schema_versions_pk
    primary key ( meta_schema_version_id );

Source romber_meta_schema_versions_uk1.sql

alter table romber_meta.schema_versions
  add constraint romber_meta_schema_versions_uk1
    unique (
      meta_schema_id,
      version_major,
      version_minor,
      version_update );

Source romber_meta_schema_versions_fk1.sql

alter table romber_meta.schema_versions
  add constraint romber_meta_schema_versions_fk1
    foreign key ( meta_schema_id )
    references romber_meta.schemas ( meta_schema_id );

Load

Source romber_meta_schema_versions_load.sql

insert into romber_meta.schema_versions (
    meta_schema_id,
    meta_schema_version_applied,
    version_major,
    version_minor,
    version_update )
  select
      meta_schema_id,
      current_timestamp at time zone 'UTC',
      0,
      8,
      6
    from romber_meta.schemas;