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
;