Table of Contents



pears.IQXNetSettings

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

Description

Contains some IQXHub settings that are required for IQXWeb to function - It also contains IQXWeb settings (EG: NonAuth Procedures)

Columns

Column Type Null Default Comment
IQXNetSettingsID char(20) NOT NULL
DefaultStaffID char(20) NULL
DefaultReportsFolder char(250) NULL
DefaultDatabaseUser char(50) NULL Database actions will be performed with permissions of this user
PortNumber integer NULL
SecurePortNumber integer NULL
SecurePassword char(50) NULL
AuthenticationRealm char(100) NULL Used for authentication challenge. Required.
LoggingOn tinyint NULL Requests will be logged in log.txt in the exe folder
CVUploadBehaviour tinyint NULL 0=any time 1=if not published 2=new only 3=never
PhotoUploadBehaviour tinyint NULL 0=any time 1=if not published 2=new only 3=never
NonAuthenticatedCalls long varchar NULL DB Procs that may be called without authenticating as a user

Primary Key

Foreign Keys

Constraint Columns References Delete/update action
Staff DefaultStaffID pears.staff (staffid) ON DELETE SET NULL

Referenced By

Indexes

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."IQXNetSettings"
-- Table comment: Contains some IQXHub settings that are required for IQXWeb to function - It also contains IQXWeb settings (EG: NonAuth Procedures)
-- Statement count: 9
 
CREATE TABLE "pears"."IQXNetSettings" (
    "IQXNetSettingsID"               CHAR(20) NOT NULL
   ,"DefaultStaffID"                 CHAR(20) NULL
   ,"DefaultReportsFolder"           CHAR(250) NULL
   ,"DefaultDatabaseUser"            CHAR(50) NULL
   ,"PortNumber"                     INTEGER NULL
   ,"SecurePortNumber"               INTEGER NULL
   ,"SecurePassword"                 CHAR(50) NULL
   ,"AuthenticationRealm"            CHAR(100) NULL
   ,"LoggingOn"                      tinyint NULL
   ,"CVUploadBehaviour"              tinyint NULL
   ,"PhotoUploadBehaviour"           tinyint NULL
   ,"NonAuthenticatedCalls"          long VARCHAR NULL
   ,PRIMARY KEY ("IQXNetSettingsID" ASC) 
)
GO
 
 
COMMENT ON COLUMN "pears"."IQXNetSettings"."DefaultDatabaseUser" IS 
	'Database actions will be performed with permissions of this user'
GO
 
 
COMMENT ON COLUMN "pears"."IQXNetSettings"."AuthenticationRealm" IS 
	'Used for authentication challenge. Required.'
GO
 
 
COMMENT ON COLUMN "pears"."IQXNetSettings"."LoggingOn" IS 
	'Requests will be logged in log.txt in the exe folder'
GO
 
 
COMMENT ON COLUMN "pears"."IQXNetSettings"."CVUploadBehaviour" IS 
	'0=any time 1=if not published 2=new only 3=never'
GO
 
 
COMMENT ON COLUMN "pears"."IQXNetSettings"."PhotoUploadBehaviour" IS 
	'0=any time 1=if not published 2=new only 3=never'
GO
 
 
COMMENT ON COLUMN "pears"."IQXNetSettings"."NonAuthenticatedCalls" IS 
	'DB Procs that may be called without authenticating as a user'
GO
 
 
COMMENT ON TABLE "pears"."IQXNetSettings" IS 
	'Contains some IQXHub settings that are required for IQXWeb to function - It also contains IQXWeb settings (EG: NonAuth Procedures)'
GO
 
 
ALTER TABLE "pears"."IQXNetSettings"
    ADD FOREIGN KEY "Staff" ("DefaultStaffID" ASC)
    REFERENCES "pears"."staff" ("staffid")
    ON DELETE SET NULL
GO