ALTER TABLE `organization_tech` MODIFY COLUMN `specialty` VARCHAR (255) NULL COMMENT '擅长领域'; ALTER TABLE `achievement` MODIFY COLUMN `owner_mobile` VARCHAR(36) NULL COMMENT '所有人联系电话'; ALTER TABLE `demand` MODIFY COLUMN `employer_contacts_mobile` VARCHAR(36) COMMENT '雇主联系人电话'; ALTER TABLE `demand` MODIFY COLUMN `employer_name` VARCHAR(45) COMMENT'雇主名称'; CREATE TABLE `coganizance_record` ( `id` BIGINT(18) NOT NULL AUTO_INCREMENT, `district` INT(4) NOT NULL COMMENT '地区(省份/市)', `unit_name` VARCHAR(45) NOT NULL COMMENT '公司名称', `year` INT(4) NOT NULL COMMENT '高企认定年份', PRIMARY KEY (`id`))AUTO_INCREMENT = 1 ENGINE = InnoDB COMMENT = '高企认定数据';