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:
Name | Type | Description |
DATABASEVENDOR | VARCHAR (32) | Reserved for IBM internal use. |
EDITION | VARCHAR (16) | Reserved for IBM internal use. |
VERSION | SMALLINT | Reserved for IBM internal use. |
RELEASE | SMALLINT | Reserved for IBM internal use. The RELEASE column
is not populated. |
MOD | SMALLINT | Reserved for IBM internal use. |
FIXPACK | SMALLINT | Reserved for IBM internal use. |
COMPNAME | VARCHAR (32) NOT NULL DEFAULT 'BASE' | Reserved for IBM Internal Use. Name of
components, e.g., GA, fixpack 1, etc. The base name is BASE. |
OPTCOUNTER | SMALLINT | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
Name | Column Names | Type |
I0001102 | COMPNAME | Unique Index |