migrations table structure

This table holds metadata about which upgrades have been applied to the data structures in this database. It is used by the polaris-studio migration manager to determine the current state of the database and the pathway to upgrading the database to align with POLARIS requirements.

Table Structure

Field	Type	NULL allowed	Default Value	Foreign key	Description
migration_id	TEXT	NO			unique identifier which corresponds to a python or sql migration file in polaris-studio
description	TEXT	YES			human readable description of the migration
applied_at	TEXT	NO			when this migration was applied to this database

(* - Primary key)

The SQL statement for table and index creation is below.

CREATE TABLE IF NOT EXISTS "Migrations" (
    "migration_id"  TEXT NOT NULL UNIQUE,
    "description"  TEXT,
    "applied_at"    TEXT NOT NULL
);


CREATE UNIQUE INDEX IF NOT EXISTS Migration_record ON "Migrations" ("migration_id");