CREATE TABLE im_entry_ctrl ( ECT_USERID varchar(16) NOT NULL COMMENT '登录ID', ECT_SESSIONID varchar(100) NOT NULL COMMENT 'SessionID', ECT_LOGONTIME char(14) NOT NULL COMMENT '登录时间,格式为YYYYMMDDHHMISS', ECT_SERVER varchar(30) NOT NULL COMMENT '登录的应用服务器IP地址,如123.22.55.177', PRIMARY KEY (ECT_USERID,ECT_SESSIONID) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='内管柜员单点登录控制表 ';