pears.DatabaseUpdateLog

Log of when an automated database update has been run & by whom.

• No primary key found in generated SQL.

• No outgoing foreign keys found.

• No incoming foreign keys found.

• No indexes found.

• No triggers found.

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."DatabaseUpdateLog"
-- Table comment: Log of when an automated database update has been run & by whom.
-- Statement count: 2
 
CREATE TABLE "pears"."DatabaseUpdateLog" (
    "StaffID"                        CHAR(20) NULL
   ,"WhenEntered"                    TIMESTAMP NULL DEFAULT CURRENT TIMESTAMP
   ,"Version"                        CHAR(12) NULL
   ,"DatabaseUpdateLogID"            INTEGER NOT NULL DEFAULT autoincrement
)
GO
 
 
COMMENT ON TABLE "pears"."DatabaseUpdateLog" IS 
	'Log of when an automated database update has been run & by whom.'
GO