Calculation/sql/update.sql

ALTER TABLE `zh_tender_info` ADD `pay_account` VARCHAR(5000) NULL DEFAULT NULL COMMENT '付款账号' AFTER `chapter`;

ALTER TABLE `zh_stage_bonus`
ADD COLUMN `b_type`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '类型' AFTER `name`;

ALTER TABLE `zh_stage_other`
ADD COLUMN `o_type`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '类型' AFTER `name`;


UPDATE zh_rpt_customize_cfg
SET cfg_content = '{"fonts":[{"ID":"ReportTitle_Main","Name":"宋体","FontBold":"T","FontHeight":32,"FontItalic":"F","CfgDispName":"表标题","FontUnderline":"F"},{"ID":"Column","Name":"宋体","FontBold":"F","FontHeight":12,"FontItalic":"F","CfgDispName":"列标题","FontUnderline":"F"},{"ID":"Content","Name":"宋体","FontBold":"F","FontHeight":12,"FontItalic":"F","CfgDispName":"正文内容","FontUnderline":"F"},{"ID":"Total","Name":"宋体","FontBold":"F","FontHeight":12,"FontItalic":"F","CfgDispName":"合计","FontUnderline":"F"},{"ID":"Header","Name":"宋体","FontBold":"F","FontHeight":12,"FontItalic":"F","CfgDispName":"表眉/表脚","FontUnderline":"F"}],"margins":{"Top":12,"Left":15,"Right":15,"Bottom":15},"fillZero":false,"isNarrow":false,"borderThick":2,"showVerticalLine":true}'
WHERE id = 1
;

ALTER TABLE `zh_material_bills_history` ADD `expr` VARCHAR(1000) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT '表达式' AFTER `quantity`, ADD `msg_tp` DECIMAL(30,8) NULL COMMENT '本期信息价单价' AFTER `expr`, ADD `msg_times` VARCHAR(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT '本期信息价时间' AFTER `msg_tp`, ADD `msg_spread` DECIMAL(30,8) NULL COMMENT '本期信息价价差' AFTER `msg_times`, ADD `m_up_risk` TINYINT(3) NULL COMMENT '本期材料调差上涨风险幅度 ' AFTER `msg_spread`, ADD `m_down_risk` TINYINT(3) NULL COMMENT '本期材料调差下跌风险幅度' AFTER `m_up_risk`, ADD `m_spread` DECIMAL(30,8) NULL COMMENT '本期材料调差有效价差' AFTER `m_down_risk`;