Versions table

To record executed migration scripts, DB Version Control and Migration runner uses dbup.Versions table.

This table consists of the following fields:

  • ID (identity field)
  • ScriptName - migration script file name
  • AppliedUTC - date and time (UTC) the script executed
  • Checksum - migration script file contents checksum (SHA1)
  • ExecutedBy - the user that executed script
  • Output - the output of executed migration script (PRINT statements, "Row(s) affected, etc.)
  • Status - migration execution status:
    • EXECUTED - the script was executed
    • MARKED - the script was not executed but marked as executed (for development database)
    • DELETED - the migration may be marked as deleted when changes in the database are reverted