pears.IQXNetSettings [iqx]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== pears.IQXNetSettings ======
<WRAP center round info>
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
</WRAP>

===== 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 =====
  * IQXNetSettingsID

===== Foreign Keys =====
^ Constraint ^ Columns ^ References ^ Delete/update action ^
| Staff | DefaultStaffID | [[database:tables:pears_staff|pears.staff (staffid)]] | ON DELETE SET NULL |

===== Referenced By =====
  * No incoming foreign keys found.

===== Indexes =====
  * No indexes found.

===== Triggers =====
  * No triggers found.

===== Original SQL =====
<code 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
</code>