关于webjit帐号

syant

GRANT USAGE ON *.* TO 'webjit'@'%' IDENTIFIED BY PASSWORD '*027F5F2D27DB0D987FBDF768A2A851BA6EB27988';
GRANT SELECT, INSERT, UPDATE, DELETE, EXECUTE ON `jit`.* TO 'webjit'@'%';
GRANT SELECT, INSERT, UPDATE, DELETE ON `sfc`.`c_group_keypart_t` TO 'webjit'@'%';
GRANT SELECT ON `smt`.`c_cust_kp_config` TO 'webjit'@'%';
GRANT SELECT ON `smt`.`r_station_kp_request` TO 'webjit'@'%';
GRANT SELECT ON `sfc`.`c_emp_desc_t` TO 'webjit'@'%';
GRANT SELECT, INSERT, UPDATE, DELETE ON `sfc`.`r_group_kp_request` TO 'webjit'@'%';

CREATE TABLE `c_group_keypart_t` (
  `MODEL_NAME` varchar(25) NOT NULL,
  `KP_NO` varchar(40) NOT NULL,
  `KP_COUNT` int(2) DEFAULT NULL,
  `GROUP_NAME` varchar(16) DEFAULT NULL,
  `GROUP_SEQ` int(11) DEFAULT '0',
  `TYPE` varchar(16) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8

CREATE TABLE `r_group_kp_request` (
  `TASKID` int(11) NOT NULL AUTO_INCREMENT,
  `BATCHNO` varchar(100) DEFAULT NULL,
  `CUST_TYPE` int(11) DEFAULT '0',
  `TASKTYPE` int(11) DEFAULT '0',
  `LINE_NAME` varchar(10) DEFAULT NULL,
  `GROUP_NAME` varchar(20) DEFAULT NULL,
  `SITE_NAME` varchar(20) DEFAULT NULL,
  `WO` varchar(25) DEFAULT NULL,
  `MODEL` varchar(20) DEFAULT NULL,
  `KP_NO` varchar(50) DEFAULT NULL,
  `STANDARD_QTY` int(4) DEFAULT NULL,
  `NEED_QTY` int(11) DEFAULT '0',
  `WORK_FLAG` int(11) DEFAULT '0',
  `WORK_TIME` datetime DEFAULT NULL,
  `EMP_NO` varchar(10) DEFAULT NULL,
  `KIT_QTY` int(11) DEFAULT '0',
  `KIT_TIME` datetime DEFAULT NULL,
  `KIT_EMP` varchar(10) DEFAULT NULL,
  `KIT_DESC` varchar(200) DEFAULT NULL,
  `KIT_FLAG` int(4) DEFAULT '0',
  `AGV_CALL` datetime DEFAULT NULL,
  `AGV_GET` datetime DEFAULT NULL,
  `AGV_START` datetime DEFAULT NULL,
  `AGV_END` datetime DEFAULT NULL,
  `ERP_BILL_CODE` varchar(50) DEFAULT NULL COMMENT '\\ERP领料单号',
  `MSG` varchar(200) DEFAULT NULL COMMENT '\\ERP返回信息',
  PRIMARY KEY (`TASKID`),
  KEY `RSKR_S_S` (`GROUP_NAME`,`LINE_NAME`),
  KEY `RSKR_WO` (`WO`),
  KEY `NewIndex1` (`WORK_TIME`),
  KEY `ERP_NO` (`ERP_BILL_CODE`),
  KEY `WO_KP_NO` (`WO`,`KP_NO`)
) ENGINE=InnoDB AUTO_INCREMENT=23598 DEFAULT CHARSET=utf8