GitLab

数据库：ucs

表名：tb_admin_for_user

sql：

CREATE TABLE `tb_admin_for_user` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `company_name` varchar(225) NOT NULL,
  `company_name_digest` varchar(32) NOT NULL,
  `server_level` int(1) NOT NULL DEFAULT '0' COMMENT '0-无效,1-高级,2-深度',
  `year_number` int(5) NOT NULL,
  `phone` varchar(14) NOT NULL,
  `business_licence` varchar(225) NOT NULL,
  `operation` varchar(60) NOT NULL,
  `status` int(1) NOT NULL DEFAULT '1' COMMENT '1代表待审核，2代表审核通过，3代表审核失败',
  `add_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `lastupdatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `ix_tb_admin_for_user_digest` (`company_name_digest`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8