pears.AuditItems

Controls which items are included in auditing.

• AuditItemID

• No outgoing foreign keys found.

• No incoming foreign keys found.

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."AuditItems"
-- Table comment: Controls which items are included in auditing.
-- Statement count: 5
 
CREATE TABLE "pears"."AuditItems" (
    "AuditItemID"                    CHAR(20) NOT NULL
   ,"AreaName"                       CHAR(250) NOT NULL
   ,"ItemName"                       CHAR(250) NOT NULL
   ,"AuditFlag"                      SMALLINT NULL
   ,"SortOrder"                      SMALLINT NULL DEFAULT 0
   ,"Notes"                          CHAR(200) NULL
   ,PRIMARY KEY ("AuditItemID" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."AuditItems" IS 
	'Controls which items are included in auditing.'
GO
 
 
CREATE INDEX "AuditItemsName" ON "pears"."AuditItems"
    ( "AreaName","SortOrder","ItemName" )
GO
 
 
CREATE TRIGGER "AuditItemsAudit" BEFORE UPDATE OF "AuditFlag"
ORDER 1 ON
"pears"."AuditItems"
REFERENCING OLD AS "old_ai" NEW AS "new_ai"
FOR each ROW
BEGIN
  CALL "AuditLog"('AUDIT',"old_ai"."AuditItemID","string"('Audit Updated - ',"old_ai"."AreaName",' ',"old_ai"."ItemName"),"old_ai"."AuditFlag","new_ai"."AuditFlag")
END
GO
 
 
COMMENT TO PRESERVE FORMAT ON TRIGGER "pears"."AuditItems"."AuditItemsAudit" IS 
{CREATE TRIGGER AuditItemsAudit 
 BEFORE UPDATE OF AuditFlag,
 ORDER 1 ON pears.AuditItems
REFERENCING OLD AS old_ai NEW AS new_ai
FOR each ROW
BEGIN
  CALL AuditLog('AUDIT',old_ai.AuditItemID,string('Audit Updated - ',old_ai.AreaName,' ',old_ai.ItemName),old_ai.AuditFlag,new_ai.AuditFlag)
END
}
GO