Reference > Database > WebSphere Commerce database tables > L
WebSphere Commerce database table: LMSERVER
This table holds the LikeMinds server information. This table is deprecated and is provided for backward compatibility only.
Column Name Column Type Description 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.
Indexes Index Name Indexed Column Names Index Type I0000147 HOSTNAME+PORT+LMENGINENAME Unique Index SQL100520030351470 LMSERVER_ID Primary Key I0000311 LMENGINETYPE+STOREENT_ID Non-Unique Index I0000606 STOREENT_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_421 STOREENT_ID STOREENT STOREENT_ID Cascade
Related reference
_vcc_freeselect_bottom_