Calculation/sql/update.sql

update zh_rpt_cfg
set defined_content='{"ctrls":[{"ID":"Default","Wrap":"T","Shrink":"F","Horizon":"left","ShowZero":"T","Vertical":"bottom","CfgDispName":"默认","CloseOutput":"F","ShrinkFirst":"F"},{"ID":"Title","Wrap":"T","Shrink":"F","Horizon":"center","ShowZero":"T","Vertical":"center","CfgDispName":"标题","CloseOutput":"F","ShrinkFirst":"F"},{"ID":"Header","Wrap":"F","Shrink":"F","Horizon":"left","ShowZero":"T","Vertical":"center","CfgDispName":"表头","CloseOutput":"F","ShrinkFirst":"F"},{"ID":"Header_Right","Wrap":"F","Shrink":"F","Horizon":"right","ShowZero":"T","Vertical":"center","CfgDispName":"表头_右","CloseOutput":"F","ShrinkFirst":"F"},{"ID":"Footer","Wrap":"F","Shrink":"F","Horizon":"left","ShowZero":"T","Vertical":"center","CfgDispName":"表尾","CloseOutput":"F","ShrinkFirst":"F"},{"ID":"Footer_Right","Wrap":"F","Shrink":"F","Horizon":"right","ShowZero":"T","Vertical":"center","CfgDispName":"表尾_右","CloseOutput":"F","ShrinkFirst":"F"},{"ID":"Column","Wrap":"T","Shrink":"F","Horizon":"center","ShowZero":"F","Vertical":"center","CfgDispName":"表栏","CloseOutput":"F","ShrinkFirst":"F","FillAfterWrap":"T"},{"ID":"Column_Left","Wrap":"T","Shrink":"F","Horizon":"left","ShowZero":"F","Vertical":"center","CfgDispName":"表栏_左","CloseOutput":"F","ShrinkFirst":"F"},{"ID":"Column_Right","Wrap":"T","Shrink":"F","Horizon":"right","ShowZero":"F","Vertical":"center","CfgDispName":"表栏_右","CloseOutput":"F","ShrinkFirst":"F"},{"ID":"Content_Left","Wrap":"F","Shrink":"T","Horizon":"left","ShowZero":"F","Vertical":"bottom","CfgDispName":"正文内容","CloseOutput":"T","ShrinkFirst":"F"},{"ID":"Content_Right","Wrap":"F","Shrink":"T","Horizon":"right","ShowZero":"F","Vertical":"bottom","CfgDispName":"正文内容_右","CloseOutput":"T","ShrinkFirst":"F"},{"ID":"Content_Center","Wrap":"F","Shrink":"T","Horizon":"center","ShowZero":"F","Vertical":"bottom","CfgDispName":"正文内容_中","CloseOutput":"T","ShrinkFirst":"F"},{"ID":"NewContent_Left","Wrap":"F","Shrink":"T","Horizon":"left","ShowZero":"F","Vertical":"center","CfgDispName":"正文内容(新)","CloseOutput":"T","ShrinkFirst":"F"},{"ID":"NewContent_Right","Wrap":"F","Shrink":"T","Horizon":"right","ShowZero":"F","Vertical":"center","CfgDispName":"正文内容(新)_右","CloseOutput":"T","ShrinkFirst":"F"},{"ID":"NewContent_Center","Wrap":"F","Shrink":"T","Horizon":"center","ShowZero":"F","Vertical":"center","CfgDispName":"正文内容(新)_中","CloseOutput":"T","ShrinkFirst":"F"},{"ID":"Currency","Wrap":"F","Shrink":"T","Horizon":"right","ShowZero":"F","Vertical":"center","CfgDispName":"金额型","CloseOutput":"F","ShrinkFirst":"T"},{"ID":"Left_Top","Wrap":"T","Shrink":"F","Horizon":"left","ShowZero":"T","Vertical":"top","CfgDispName":"上靠_左","CloseOutput":"T","ShrinkFirst":"F"},{"ID":"Center_Top","Wrap":"T","Shrink":"F","Horizon":"center","ShowZero":"T","Vertical":"top","CfgDispName":"上靠_中","CloseOutput":"T","ShrinkFirst":"F"},{"ID":"Right_Top","Wrap":"T","Shrink":"F","Horizon":"right","ShowZero":"T","Vertical":"top","CfgDispName":"上靠_右","CloseOutput":"T","ShrinkFirst":"F"},{"ID":"Left_Center","Wrap":"T","Shrink":"F","Horizon":"left","ShowZero":"T","Vertical":"center","CfgDispName":"中靠_左","CloseOutput":"T","ShrinkFirst":"F"},{"ID":"Center_Center","Wrap":"T","Shrink":"F","Horizon":"center","ShowZero":"T","Vertical":"center","CfgDispName":"中靠_中","CloseOutput":"T","ShrinkFirst":"F"},{"ID":"Right_Center","Wrap":"T","Shrink":"F","Horizon":"right","ShowZero":"T","Vertical":"center","CfgDispName":"中靠_右","CloseOutput":"T","ShrinkFirst":"F"}],"fonts":[{"ID":"ReportTitle_Main","Name":"宋体","FontBold":"T","FontAngle":"0","FontColor":"BLACK","FontHeight":"32","FontItalic":"F","CfgDispName":"主标题","FontStrikeOut":"F","FontUnderline":"F"},{"ID":"ReportTitle_Vice_1","Name":"宋体","FontBold":"T","FontAngle":"0","FontColor":"BLACK","FontHeight":"22","FontItalic":"F","CfgDispName":"副标题","FontStrikeOut":"F","FontUnderline":"F"},{"ID":"ReportTitle_Vice_2","Name":"宋体","FontBold":"T","FontAngle":"0","FontColor":"BLACK","FontHeight":"18","FontItalic":"F","CfgDispName":"副标题2","FontStrikeOut":"F","FontUnderline":"F"},{"ID":"HeaderColumn","Name":"宋体","FontBold":"F","FontAngle":"0","FontColor":"BLACK","FontHeight":"12","FontItalic":"F","CfgDispName":"栏头","FontStrikeOut":"F","FontUnderline":"F"},{"ID":"Header","Name":"宋体","FontBold":"F","FontAngle":"0","FontColor":"BLACK","FontHeight":"12","FontItalic":"F","CfgDispName":"表头","FontStrikeOut":"F","FontUnderline":"F"},{"ID":"FooterColumn","Name":"宋体","FontBold":"F","FontAngle":"0","FontColor":"BLACK","FontHeight":"12","FontItalic":"F","CfgDispName":"栏尾","FontStrikeOut":"F","FontUnderline":"F"},{"ID":"Footer","Name":"宋体","FontBold":"F","FontAngle":"0","FontColor":"BLACK","FontHeight":"12","FontItalic":"F","CfgDispName":"表尾","FontStrikeOut":"F","FontUnderline":"F"},{"ID":"GrandTotal","Name":"宋体","FontBold":"F","FontAngle":"0","FontColor":"BLACK","FontHeight":"12","FontItalic":"F","CfgDispName":"总合计","FontStrikeOut":"F","FontUnderline":"F"},{"ID":"SectionTotal","Name":"宋体","FontBold":"F","FontAngle":"0","FontColor":"BLACK","FontHeight":"12","FontItalic":"F","CfgDispName":"章合计","FontStrikeOut":"F","FontUnderline":"F"},{"ID":"Content","Name":"宋体","FontBold":"F","FontAngle":"0","FontColor":"BLACK","FontHeight":"12","FontItalic":"F","CfgDispName":"正文内容","FontStrikeOut":"F","FontUnderline":"F"},{"ID":"Content_Narrow","Name":"Arial Narrow","FontBold":"F","FontAngle":"0","FontColor":"BLACK","FontHeight":"12","FontItalic":"F","CfgDispName":"正文内容-窄体","FontStrikeOut":"F","FontUnderline":"F"},{"ID":"Header_V1","Name":"宋体","FontBold":"F","FontAngle":"90","FontColor":"BLACK","FontHeight":"12","FontItalic":"F","FontStrikeOut":"F","FontUnderline":"F"},{"ID":"Header_V2","Name":"宋体","FontBold":"F","FontAngle":"-90","FontColor":"BLACK","FontHeight":"12","FontItalic":"F","FontStrikeOut":"F","FontUnderline":"F"}],"styles":[{"ID":"Default_None","CfgDispName":"空白","border_style":[{"Color":"BLACK","Position":"Left","DashStyle":"SOLID","LineWeight":"0"},{"Color":"BLACK","Position":"Right","DashStyle":"SOLID","LineWeight":"0"},{"Color":"BLACK","Position":"Top","DashStyle":"SOLID","LineWeight":"0"},{"Color":"BLACK","Position":"Bottom","DashStyle":"SOLID","LineWeight":"0"}]},{"ID":"Default","CfgDispName":"默认","border_style":[{"Color":"BLACK","Position":"Left","DashStyle":"SOLID","LineWeight":"1"},{"Color":"BLACK","Position":"Right","DashStyle":"SOLID","LineWeight":"1"},{"Color":"BLACK","Position":"Top","DashStyle":"SOLID","LineWeight":"0"},{"Color":"BLACK","Position":"Bottom","DashStyle":"SOLID","LineWeight":"0"}]},{"ID":"Default_Normal","CfgDispName":"正常","border_style":[{"Color":"BLACK","Position":"Left","DashStyle":"SOLID","LineWeight":"1"},{"Color":"BLACK","Position":"Right","DashStyle":"SOLID","LineWeight":"1"},{"Color":"BLACK","Position":"Top","DashStyle":"SOLID","LineWeight":"1"},{"Color":"BLACK","Position":"Bottom","DashStyle":"SOLID","LineWeight":"1"}]},{"ID":"Label_Underline","CfgDispName":"字符底线","border_style":[{"Color":"BLACK","Position":"Left","DashStyle":"SOLID","LineWeight":"0"},{"Color":"BLACK","Position":"Right","DashStyle":"SOLID","LineWeight":"0"},{"Color":"BLACK","Position":"Top","DashStyle":"SOLID","LineWeight":"0"},{"Color":"BLACK","Position":"Bottom","DashStyle":"SOLID","LineWeight":"1"}]},{"ID":"Label_Left","CfgDispName":"左边线","border_style":[{"Color":"BLACK","Position":"Left","DashStyle":"SOLID","LineWeight":"1"},{"Color":"BLACK","Position":"Right","DashStyle":"SOLID","LineWeight":"0"},{"Color":"BLACK","Position":"Top","DashStyle":"SOLID","LineWeight":"0"},{"Color":"BLACK","Position":"Bottom","DashStyle":"SOLID","LineWeight":"0"}]},{"ID":"Label_Right","CfgDispName":"右边线","border_style":[{"Color":"BLACK","Position":"Left","DashStyle":"SOLID","LineWeight":"0"},{"Color":"BLACK","Position":"Right","DashStyle":"SOLID","LineWeight":"1"},{"Color":"BLACK","Position":"Top","DashStyle":"SOLID","LineWeight":"0"},{"Color":"BLACK","Position":"Bottom","DashStyle":"SOLID","LineWeight":"0"}]},{"ID":"Label_Top","CfgDispName":"上边线","border_style":[{"Color":"BLACK","Position":"Left","DashStyle":"SOLID","LineWeight":"0"},{"Color":"BLACK","Position":"Right","DashStyle":"SOLID","LineWeight":"0"},{"Color":"BLACK","Position":"Top","DashStyle":"SOLID","LineWeight":"1"},{"Color":"BLACK","Position":"Bottom","DashStyle":"SOLID","LineWeight":"0"}]},{"ID":"Label_LeftTop","CfgDispName":"左上边线","border_style":[{"Color":"BLACK","Position":"Left","DashStyle":"SOLID","LineWeight":"1"},{"Color":"BLACK","Position":"Right","DashStyle":"SOLID","LineWeight":"0"},{"Color":"BLACK","Position":"Top","DashStyle":"SOLID","LineWeight":"1"},{"Color":"BLACK","Position":"Bottom","DashStyle":"SOLID","LineWeight":"0"}]},{"ID":"Label_LeftBottom","CfgDispName":"左下边线","border_style":[{"Color":"BLACK","Position":"Left","DashStyle":"SOLID","LineWeight":"1"},{"Color":"BLACK","Position":"Right","DashStyle":"SOLID","LineWeight":"0"},{"Color":"BLACK","Position":"Top","DashStyle":"SOLID","LineWeight":"0"},{"Color":"BLACK","Position":"Bottom","DashStyle":"SOLID","LineWeight":"1"}]},{"ID":"Label_RightTop","CfgDispName":"右上边线","border_style":[{"Color":"BLACK","Position":"Left","DashStyle":"SOLID","LineWeight":"0"},{"Color":"BLACK","Position":"Right","DashStyle":"SOLID","LineWeight":"1"},{"Color":"BLACK","Position":"Top","DashStyle":"SOLID","LineWeight":"1"},{"Color":"BLACK","Position":"Bottom","DashStyle":"SOLID","LineWeight":"0"}]},{"ID":"Label_RightBottom","CfgDispName":"右下边线","border_style":[{"Color":"BLACK","Position":"Left","DashStyle":"SOLID","LineWeight":"0"},{"Color":"BLACK","Position":"Right","DashStyle":"SOLID","LineWeight":"1"},{"Color":"BLACK","Position":"Top","DashStyle":"SOLID","LineWeight":"0"},{"Color":"BLACK","Position":"Bottom","DashStyle":"SOLID","LineWeight":"1"}]},{"ID":"Label_TopBottom","CfgDispName":"上下边线","border_style":[{"Color":"BLACK","Position":"Left","DashStyle":"SOLID","LineWeight":"0"},{"Color":"BLACK","Position":"Right","DashStyle":"SOLID","LineWeight":"0"},{"Color":"BLACK","Position":"Top","DashStyle":"SOLID","LineWeight":"1"},{"Color":"BLACK","Position":"Bottom","DashStyle":"SOLID","LineWeight":"1"}]},{"ID":"Label_TopCover","CfgDispName":"上包围","border_style":[{"Color":"BLACK","Position":"Left","DashStyle":"SOLID","LineWeight":"1"},{"Color":"BLACK","Position":"Right","DashStyle":"SOLID","LineWeight":"1"},{"Color":"BLACK","Position":"Top","DashStyle":"SOLID","LineWeight":"1"},{"Color":"BLACK","Position":"Bottom","DashStyle":"SOLID","LineWeight":"0"}]},{"ID":"Label_BottomCover","CfgDispName":"下包围","border_style":[{"Color":"BLACK","Position":"Left","DashStyle":"SOLID","LineWeight":"1"},{"Color":"BLACK","Position":"Right","DashStyle":"SOLID","LineWeight":"1"},{"Color":"BLACK","Position":"Top","DashStyle":"SOLID","LineWeight":"0"},{"Color":"BLACK","Position":"Bottom","DashStyle":"SOLID","LineWeight":"1"}]},{"ID":"Label_LeftCover","CfgDispName":"左包围","border_style":[{"Color":"BLACK","Position":"Left","DashStyle":"SOLID","LineWeight":"1"},{"Color":"BLACK","Position":"Right","DashStyle":"SOLID","LineWeight":"0"},{"Color":"BLACK","Position":"Top","DashStyle":"SOLID","LineWeight":"1"},{"Color":"BLACK","Position":"Bottom","DashStyle":"SOLID","LineWeight":"1"}]},{"ID":"Label_RightCover","CfgDispName":"右包围","border_style":[{"Color":"BLACK","Position":"Left","DashStyle":"SOLID","LineWeight":"0"},{"Color":"BLACK","Position":"Right","DashStyle":"SOLID","LineWeight":"1"},{"Color":"BLACK","Position":"Top","DashStyle":"SOLID","LineWeight":"1"},{"Color":"BLACK","Position":"Bottom","DashStyle":"SOLID","LineWeight":"1"}]},{"ID":"BORDER_ALL_AROUND","CfgDispName":"报表边框","border_style":[{"Color":"BLACK","Position":"Left","DashStyle":"SOLID","LineWeight":"2.0"},{"Color":"BLACK","Position":"Right","DashStyle":"SOLID","LineWeight":"2.0"},{"Color":"BLACK","Position":"Top","DashStyle":"SOLID","LineWeight":"2.0"},{"Color":"BLACK","Position":"Bottom","DashStyle":"SOLID","LineWeight":"2.0"}]}]}'
where userId='Administrator';

ALTER TABLE `zh_project_account`
ADD COLUMN `self_category_level`  varchar(255) NOT NULL DEFAULT '' AFTER `invalid_time`;

ALTER TABLE `zh_project_account`
ADD COLUMN `show_revise_invalid`  tinyint(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否显示，台账修订作废' AFTER `self_category_level`;


-- 很重要！！！！
-- 请在该sql语句上方添加下一版本升级所需sql
UPDATE `zh_sub_project` p LEFT JOIN `zh_budget` b ON p.budget_id = b.id SET p.std_id = IFNULL(b.std_id, 0);
UPDATE `zh_sub_project` p LEFT JOIN `zh_budget_std` bs ON p.std_id = bs.id SET p.std_name = IFNULL(bs.name, '');

-- index
ALTER TABLE `zh_material_bills_history` ADD INDEX `idx_mbid_mid_mspread` (`mb_id`, `mid`, `m_spread`);