WebSphere Commerce database table: STAGLOG

This table holds a log of changes made on the staging server so that the changes can be propagated to the production server using the stagepropagate command.


Column Description(s):
Column NameColumn TypeDescription
STGRFNBR BIGINT NOT NULL The reference number for the staging row.
STGSTMP TIMESTAMP NOT NULL The time stamp.
STGTABLE CHAR(18) NOT NULL The name of the table with staged changes.
STGOP CHAR(1) NOT NULL The change operator:
I
insert
U
update
D
delete
STGMENBRNAME CHAR(32) Reserved for IBM internal use.
STGMENBR INTEGER Indicates whether the table is a:
0 = site table or 1 = merchant table.
STGPKEYNAME CHAR(32) The name of the primary key.
STGPKEY BIGINT The value of the primary key.
STGKEY1NAME CHAR(32) Column name for the unique index.
STGKEY2NAME CHAR(32) Column name for the unique index.
STGKEY3NAME CHAR(32) Column name for the unique index.
STGKEY4NAME CHAR(32) Column name for the unique index.
STGKEY5NAME CHAR(32) Column name for the unique index.
STGOKEY1 BIGINT Old column value for the unique index.
STGOKEY2 BIGINT Old column value for the unique index.
STGOKEY3 VARCHAR(254) Old column value for the unique index.
STGOKEY4 BIGINT Old column value for the unique index.
STGOKEY5 VARCHAR(254) Old column value for the unique index.
STGNKEY1 BIGINT New column value for the unique index.
STGNKEY2 BIGINT New column value for the unique index.
STGNKEY3 VARCHAR(254) New column value for the unique index.
STGNKEY4 BIGINT New column value for the unique index.
STGNKEY5 VARCHAR(254) New column value for the unique index.
STGPROCESSED INTEGER DEFAULT 0 0 = not processed, 1 = processed.
STGRESERVED1 INTEGER DEFAULT 0 Reserved for IBM internal use.
STGLDPTH VARCHAR(254) Reserved for IBM internal use.
STGLDCOLS VARCHAR(4000) Reserved for IBM internal use.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031312440 STGRFNBR Primary Key

Feedback