Cassandra Migration Version

sunbird.cassandra_migration_version (PRIMARY KEY: version)

Table used to capture cassandra CQL script version status during LERN release deployment

Column NameData TypeDescriptionSample Data

version

text

Current CQL script version deployed

1.113

checksum

int

-1988945306

description

text

Not Used

cassandra

execution_time

int

Time taken in milliseconds to execute the cql script

2323

installed_by

text

Not Used

installed_on

timestamp

Timestamp on which the cql script was executed

2020-12-18 11:04:46.095000+0000

installed_rank

int

The order in which this migration was applied amongst all others. (For out of order detection)

226

script

text

CQL script name

V1.113_cassandra.cql

success

boolean

Indicator to mention whether CQL script was run successfully or not

True

type

text

The type of migration (CQL, JAVA_DRIVER, ...)

CQL

version_rank

int

The position of this version amongst all others. (For easy order by sorting)

112

sunbird.cassandra_migration_version_counts (PRIMARY KEY: name)

Table used to store information about the last run CQL migration script data

Column NameData TypeDescriptionSample Data

name

text

Field Name

installed_rank

count

counter

Field Value

257

Last updated