41-43

CREATE TABLE `jiangsi_log_services` (
  `logld` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `orderld` int(10) unsigned NOT NULL COMMENT '订单ID',
  `serciceld` int(10) unsigned NOT NULL COMMENT '售后单ID',
  `logContent` varchar(255) DEFAULT NULL COMMENT '日志内容',
  `logTargetld` int(10) unsigned NOT NULL COMMENT '日志操作对象ID',
  `logType` tinyint(4) unsigned NOT NULL COMMENT '操作者类型',
  `logTime` datetime DEFAULT NULL COMMENT '日志时间',
  PRIMARY KEY (`logld`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `jiangsi_log_sms` (
  `smsld` int(11) NOT NULL COMMENT '自增ID',
  `smsSrc` tinyint(4) NOT NULL COMMENT '消息类型',
  `smsUserld` int(11) NOT NULL COMMENT '发送者ID',
  `smsContent` varchar(255) NOT NULL COMMENT '短信内容',
  `smsPhoneNumber` varchar(11) NOT NULL COMMENT '短信号码',
  `smsReturnCode` varchar(255) NOT NULL COMMENT '短信返回值',
  `smsCode` varchar(50) NOT NULL COMMENT '调用短信的接口',
  `smslP` varchar(16) NOT NULL COMMENT 'IP地址',
  `createTime` datetime NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`smsld`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `jiangsi_log_staff_logins` (
  `loginld` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `staffld` int(11) NOT NULL COMMENT '职员ID',
  `loginTime` datetime NOT NULL COMMENT '登录时间',
  `loginlp` varchar(16) NOT NULL COMMENT '登录IP',
  PRIMARY KEY (`loginld`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;