SITE

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

Column Descriptions:

NameTypeDescription
DATABASEVENDORVARCHAR (32)Reserved for HCL internal use.
EDITIONVARCHAR (16)Reserved for HCL internal use.
VERSIONSMALLINTReserved for HCL internal use.
RELEASESMALLINTReserved for HCL internal use. The RELEASE column is not populated.
MODSMALLINTReserved for HCL internal use.
FIXPACKSMALLINTReserved for HCL internal use.
COMPNAMEVARCHAR (32) NOT NULL DEFAULT 'BASE'Reserved for HCL internal use. The base name is BASE.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The 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