数据库加表
数据库:ucs
表名:tb_admin_for_super_user
sql:
CREATE TABLE `tb_admin_for_super_user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`company_name_digest` varchar(32) NOT NULL,
`year_number` tinyint(1) NOT NULL,
`phone` varchar(11) NOT NULL,
`add_operation` varchar(50) NOT NULL,
`audit_operation` varchar(50) DEFAULT NULL,
`status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0代表待审核,1代表审核通过,2代表审核不通过',
`add_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`lastupdatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `ix_company_name_digest` (`company_name_digest`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8