pears.ConfigLog

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.

Manually recorded changes to configuration.

Column Type Null Default Comment
ConfigLogID char(20) NOT NULL
Userid char(25) NULL
Description long varchar NULL
WhenEntered timestamp NULL current timestamp
  • ConfigLogID
  • 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"."ConfigLog"
-- Table comment: Manually recorded changes to configuration.
-- Statement count: 2
 
CREATE TABLE "pears"."ConfigLog" (
    "ConfigLogID"                    CHAR(20) NOT NULL
   ,"Userid"                         CHAR(25) NULL
   ,"Description"                    long VARCHAR NULL
   ,"WhenEntered"                    TIMESTAMP NULL DEFAULT CURRENT TIMESTAMP
   ,PRIMARY KEY ("ConfigLogID" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."ConfigLog" IS 
	'Manually recorded changes to configuration.'
GO
  • database/tables/pears_configlog.txt
  • Last modified: 2026/08/07 19:24
  • by 127.0.0.1