14.1 sp550_script_audit

This table holds the information on which scripts have been applied to the schema by dbinstall.

Table Definition

Field	Type	Default	Nullable
id	integer
revision	integer
type	varchar2(4)
cr_dr	varchar2(8)
db_version	varchar2(32)
description	varchar2(255)
timestamp	date
os_user	varchar2(32)
username	varchar2(30)

None.

Field	Description
id	The ID of this script (the same as the ID component of its filename) e.g. 140.
revision	The Revision number of this script (the same as the Revision component of its filename) e.g. 04.
type	The type of this script (the same as the Category component of its filename) e.g. dbcr.
cr_dr	The CR or DR to which this script applies e.g. DR7706.
db_version	The schema version which this script will bring the schema up to e.g. 4.4.0.1.
description	A short description of the change, as contained in the DESCRIPTION tag of the script.
timestamp	Date and time at which these details were saved. Uses the time zone of the DBMS server machine.
os_user	Operating system user.
username	DBMS user.