Storing version in the database

Each repository will have a table tig_schema_versions with the information about all installed components and it’s versions in that particular repository. There will be an associated stored procedure to obtain and set version:

  • table:

    tig_schema_versions (
  component varchar(100) NOT NULL,
  version varchar(100) NOT NULL,
  last_update timestamp NOT NULL,
  primary key (component)
);
  • stored procedures get/setVersion(‘component’,'version');

It will be stored and maintained in the file named <RDBMS_name>-common-schema-<version>.sql

Prev  Up  Next
  Home