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 IF NOT EXISTS `aft_dev`.`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