WebSphere Commerce database table: LMSERVER

This table holds the LikeMinds server information. This table is deprecated and is provided for backward compatibility only.


Column Description(s):
Column NameColumn TypeDescription
LMSERVER_ID INTEGER NOT NULL The ID of the LikeMinds server.
STOREENT_ID INTEGER NOT NULL The ID of the store with which this server is associated.
HOSTNAME VARCHAR(128) NOT NULL The host name of the LikeMinds server.
PORT INTEGER NOT NULL DEFAULT 2620 The port number of the LikeMinds server.
LMENGINENAME VARCHAR(64) NOT NULL The name of the LikeMinds engine.
LMENGINETYPE VARCHAR(64) NOT NULL The type of LikeMinds engine, for example ClickstreamEngine.
LMSETNAME VARCHAR(64) NOT NULL The name of the transaction set used on the LikeMinds server.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000147 HOSTNAME+PORT+LMENGINENAME Unique Index
SQL050212031236980 LMSERVER_ID Primary Key
I0000311 LMENGINETYPE+STOREENT_ID Non-Unique Index
I0000606 STOREENT_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_421 STOREENT_ID STOREENT STOREENT_ID Cascade

Feedback