The SYSTEMINFO table stores general information about how the Saleslogix Server communicates with the database and other system information. Items stored include database type, database version, primary Synchronization Server identification code, site code, connection server port, connection server name, Read/Write password identification, Read Only password identification, and other system information.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
SYSTEMINFOID (PK) |
STANDARDID(12) |
NOT NULL |
SYSTEMINFO_SYSTEMINFOID_PK (CA)
|
|
|
|
DBTYPE |
int(4) |
NULLS |
|
|
|
|
PRIMARYSERVER (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
DATA |
DATABLOB(16) |
NULLS |
|
|
|
|
DBVERSION |
varchar(5) |
NULLS |
|
|
|
|
SITECODE (FK) |
STANDARDID(12) |
NULLS |
|
(One) to (One) |
|
|
PINGPORT |
int(4) |
NULLS |
|
|
|
|
PINGSERVER |
varchar(64) |
NULLS |
|
|
|
|
RWPASS |
varchar(255) |
NULLS |
|
|
|
|
ROPASS |
varchar(255) |
NULLS |
|
|
|
|
USEWINDOWSAUTH |
char(1) |
NULLS |
|
|
|
|
COMPANYNAME |
varchar(128) |
NULLS |
|
|
|
|
GMT |
char(1) |
NULLS |
|
|
|
|
BASECURRENCY |
varchar(3) |
NULLS |
|
|
|
|
ISSUEMATCH |
char(1) |
NULLS |
|
|
|
|
OPTIMIZERMODE |
char(1) |
NULLS |
|
|
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
UNICODE |
char(1) |
NULLS |
|
|
|
|
SENDSLXSAVEMSGFILES |
char(1) |
NULLS |
|
|
|
|
APPID (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
LOGINATTEMPTTHRESHOLD |
smallint |
NULLS |
|
|
|
|
LOCKOUTTIMEOUT |
int |
NULLS |
|
|
|