piccgrad/build/classes/java/main/install/initTab.sql

 #DROP TABLE md_piccGrabAccount;
CREATE TABLE `md_piccGrabAccount` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
   account  VARCHAR(100) DEFAULT 0 COMMENT '登录账号',
  `password` VARCHAR(100) DEFAULT NULL  COMMENT '密码',
  `cookie` VARCHAR(200) DEFAULT NULL  COMMENT 'cookie',
  `token` VARCHAR(800) DEFAULT NULL  COMMENT 'token',
  `fgsId` VARCHAR(60) DEFAULT NULL  COMMENT '分公司id',
  `yzm` VARCHAR(10) DEFAULT NULL  COMMENT '验证码',
   logIn  int DEFAULT 0 COMMENT '是否登录  1已登录',
   Isdel  int DEFAULT 0 COMMENT '是否删除  1已删除',
   salesman varchar(60)  DEFAULT NULL  COMMENT '所属业务员',
  `createtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
)ENGINE=InnoDB AUTO_INCREMENT=125 DEFAULT CHARSET=utf8;


 #DROP TABLE md_piccGrabParam;
CREATE TABLE `md_piccGrabParam` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `bbpCode`  VARCHAR(100) DEFAULT 0 COMMENT '报价编号',
  `mainId` VARCHAR(100) DEFAULT NULL  COMMENT 'mainId',
  `relationId` VARCHAR(200) DEFAULT NULL  COMMENT 'relationId',
  PRIMARY KEY (`id`)
)ENGINE=InnoDB AUTO_INCREMENT=125 DEFAULT CHARSET=utf8;