SITE

Reserved for IBM internal use. The data and schema in the WebSphere Commerce database may change depending on which WebSphere Commerce fix pack level is applied and which features are enabled. The SITE table is used to record version information related to the WebSphere Commerce schema and data. The information is used by various WebSphere Commerce utilities. Note: All records in the SITE table should not be modified.

Column Descriptions:

NameTypeDescription
DATABASEVENDORVARCHAR (32)Reserved for IBM internal use.
EDITIONVARCHAR (16)Reserved for IBM internal use.
VERSIONSMALLINTReserved for IBM internal use.
RELEASESMALLINTReserved for IBM internal use. The RELEASE column is not populated.
MODSMALLINTReserved for IBM internal use.
FIXPACKSMALLINTReserved for IBM internal use.
COMPNAMEVARCHAR (32) NOT NULL DEFAULT 'BASE'Reserved for IBM Internal Use. Name of components, e.g., GA, fixpack 1, etc. The base name is BASE.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
I0001102COMPNAMEUnique Index