Calculation/sql/update.sql

ALTER TABLE `zh_project_account` ADD `company_id` INT NULL DEFAULT NULL COMMENT '所属参建单位id' AFTER `company`;

ALTER TABLE `zh_datacollect_audit` ADD `company_id` INT NULL DEFAULT NULL COMMENT '参建单位id' AFTER `pid`;

ALTER TABLE `zh_std_gcl_list`
ADD COLUMN `sub_type`  tinyint(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '二级分类' AFTER `create_time`;

ALTER TABLE `zh_rpt_tree_node`
ADD COLUMN `source_type`  int(11) UNSIGNED NOT NULL DEFAULT 1 COMMENT '数据源类型' AFTER `last_update_time`;

ALTER TABLE `zh_rpt_tpl`
ADD COLUMN `source_type`  int(11) UNSIGNED NOT NULL DEFAULT 1 COMMENT '数据源类型' AFTER `rpt_content`;

ALTER TABLE `zh_rpt_mapping_field`
ADD COLUMN `source_type`  int(11) UNSIGNED NOT NULL COMMENT '数据源类型' AFTER `items`;