Table of Contents



pears.WPKGlobalSwitchSetting

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

Description

Individual values set for Woodpecker Switches.

Columns

Column Type Null Default Comment
Location char(20) NOT NULL 'Global' Allows localisation of switch settings
WPKGlobalSwitchID char(20) NOT NULL
Value long varchar NULL

Primary Key

Foreign Keys

Referenced By

Indexes

Triggers

Name Timing Event
WPKTrackSwitchSettingChange after insert,delete,update order 1

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."WPKGlobalSwitchSetting"
-- Table comment: Individual values set for Woodpecker Switches.
-- Statement count: 5
 
CREATE TABLE "pears"."WPKGlobalSwitchSetting" (
    "Location"                       CHAR(20) NOT NULL DEFAULT 'Global'
   ,"WPKGlobalSwitchID"              CHAR(20) NOT NULL
   ,"Value"                          long VARCHAR NULL
   ,PRIMARY KEY ("Location" ASC,"WPKGlobalSwitchID" ASC) 
)
GO
 
 
COMMENT ON COLUMN "pears"."WPKGlobalSwitchSetting"."Location" IS 
	'Allows localisation of switch settings'
GO
 
 
COMMENT ON TABLE "pears"."WPKGlobalSwitchSetting" IS 
	'Individual values set for Woodpecker Switches.'
GO
 
 
CREATE TRIGGER "WPKTrackSwitchSettingChange" after INSERT,DELETE,UPDATE ORDER 1 ON
"pears"."WPKGlobalSwitchSetting"
FOR each statement
BEGIN
  CALL "WPKTrackChange"('S','*')
END
GO
 
 
COMMENT TO PRESERVE FORMAT ON TRIGGER "pears"."WPKGlobalSwitchSetting"."WPKTrackSwitchSettingChange" IS 
{CREATE TRIGGER WPKTrackSwitchSettingChange 
 after INSERT,DELETE,UPDATE ORDER 1 ON
WPKGlobalSwitchSetting
FOR each statement
BEGIN
  CALL WPKTrackChange('S','*')
END
}
GO