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.
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");