GitLab

mysql变更格式

数据库：ucs

表名：tb_bill_for_user

sql：

CREATE TABLE `tb_bill_for_user` (
  `id` tinyint(11) NOT NULL AUTO_INCREMENT,
  `products_name` varchar(30) NOT NULL,
  `version_type` smallint(1) NOT NULL COMMENT '1代表普通，2代表专享，3代表权威',
  `certification_type` smallint(1) NOT NULL COMMENT '1代表新开，2代表续费，3代表升级',
  `year_number` int(5) NOT NULL,
  `web_domain` varchar(100) DEFAULT NULL COMMENT '权威版必填',
  `web_name` varchar(100) DEFAULT NULL COMMENT '权威版必填',
  `company_name` varchar(100) NOT NULL,
  `bank_name` varchar(100) DEFAULT NULL,
  `bank_no` varchar(20) DEFAULT NULL,
  `business_licence_path` varchar(225) NOT NULL,
  `idcard_path` varchar(225) DEFAULT NULL COMMENT '权威版必填',
  `service_book_path` varchar(225) DEFAULT NULL COMMENT '权威版必填',
  `other_path` varchar(225) DEFAULT NULL,
  `agent_name` varchar(20) NOT NULL,
  `agent_phone` varchar(11) NOT NULL,
  `agent_email` varchar(50) NOT NULL,
  `sales_people_name` varchar(20) NOT NULL,
  `operation` int(11) NOT NULL,
  `status` smallint(1) DEFAULT '1' COMMENT '1代表待审核，2代表审核通过，3代表审核失败',
  `user_note` varchar(1000) DEFAULT NULL,
  `add_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `lastupdatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=117 DEFAULT CHARSET=utf8