2017-03-08.sql 507 B

123456789
  1. ALTER TABLE `organization_identity`
  2. add `listed` int(1) NOT NULL default 0 COMMENT '是否上市',
  3. add `listed_date` DATETIME NULL COMMENT '上市时间',
  4. add `listed_type` int(1) NOT NULL COMMENT '上市类型',
  5. add `stock_code` VARCHAR(32) NULL COMMENT '股票代码'
  6. ALTER TABLE `org_human_resource`
  7. add `new_employment` int(6) NULL COMMENT '新增就业人数' AFTER `year`,
  8. add `graduate_number` int(6) NULL COMMENT '高校应届毕业生人数' AFTER `new_employment`