im_entry_ctrl.sql 463 B

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