ALTER TABLE `organization_identity` add `listed` int(1) NOT NULL default 0 COMMENT '是否上市', add `listed_date` DATETIME NULL COMMENT '上市时间', add `listed_type` int(1) NOT NULL COMMENT '上市类型', add `stock_code` VARCHAR(32) NULL COMMENT '股票代码'; ALTER TABLE `org_human_resource` add `new_employment` int(6) NULL COMMENT '新增就业人数' AFTER `year`, add `graduate_number` int(6) NULL COMMENT '高校应届毕业生人数' AFTER `new_employment`; CREATE TABLE `org_annual_report` ( `id` VARCHAR(36) NOT NULL, `uid` VARCHAR(36) NULL, `create_time` DATETIME NULL COMMENT '创建时间', `last_update_time` DATETIME NULL COMMENT '最近跟新时间', `total_tax` DECIMAL(8,2) NULL COMMENT '纳税总额(万元)', `income_tax_relief` DECIMAL(8,2) NULL COMMENT '所得税减免(万元)', `total_export_volume` DECIMAL(8,2) NULL COMMENT '出口创汇总额(万元)', `year` INT(4) NULL COMMENT '年份', `state` INT(1) NULL DEFAULT 0 COMMENT '年报状态', `deleted_sign` INT(1) NOT NULL DEFAULT 0 COMMENT '删除标记', PRIMARY KEY (`id`)) ENGINE = InnoDB;