Footprints Data Model

Table
Name deployment_update
Comment
A log of updates to the database structure performed by the installation
deployment.  This log ensures that the correct scripts are run in order, and
prevents the re-rerunning of scripts.

Column
Name Datatype Comment Is PK Is FK
update_pack_id varchar(64) The value of a Deployment Update, stored as a string. Yes No
from_ver varchar(64) From FP version No No
to_ver varchar(64) To FP version No No
prod_ver varchar(64) Product Version No No
build_number varchar(64) Build number No No
start_datetime datetime Start of deployment No No
finish_datetime datetime End of deployment No No
success bit Indicates if Success. No No
error varchar(4000) Error Messages No No