delete from sys_dict where type = 'usertype' and value = 12;

INSERT INTO `risk_systemconfig`(`createOn`, `updateOn`, `syskey`, `sysvalue`, `description`) VALUES ( now(), now(), 'einvoice_url', 'http://47.93.117.58:8012/', '电子发票url');



ALTER TABLE `risk_useroplog`
DROP COLUMN `macthineName`;

ALTER TABLE `risk_useroplog`
CHANGE COLUMN `content` `action` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作内容/动作' AFTER `updateOn`,
CHANGE COLUMN `module` `menu` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作菜单' AFTER `ipAddress`;


ALTER TABLE `risk_useroplog`
ADD COLUMN `targetObj` varchar(255) NULL COMMENT '执行对象' AFTER `expired`;

ALTER TABLE `risk_useroplog`
ADD COLUMN `param` text NULL COMMENT '请求参数' AFTER `targetObj`;

update risk_se_user set userType = 0 where userName = 'pss_super';

UPDATE `risk_materialformattrtemplate` SET `script` = 'function clickA88(value) {\r\n			if(value == \"1\") {\r\n				$(\"#A3-box\").addClass(\"hide\");\r\n				$(\"#A98-box\").addClass(\"hide\");\r\n				$(\"#A89-box\").addClass(\"hide\");\r\n				$(\"#A106-box\").addClass(\"hide\");\r\n				$(\"#A3-h\").val(\'default-value\');\r\n				$(\"#A98-h\").val(\'default-value\');\r\n				$(\"#A89-h\").val(\'default-value\');	\r\n				$(\"#A106-h\").val(\'default-value\');	\r\n			} else if(value == \"2\"){\r\n				$(\"#A3-box\").addClass(\"hide\");\r\n				$(\"#A98-box\").removeClass(\"hide\");\r\n				$(\"#A89-box\").addClass(\"hide\");\r\n				$(\"#A106-box\").addClass(\"hide\");\r\n				$(\"#A3-h\").val(\'default-value\');\r\n				$(\"#A89-h\").val(\'default-value\');\r\n				$(\"#A106-h\").val(\'default-value\');	\r\n				if ($(\"#A98-h\").val()==\'default-value\'){\r\n					$(\"#A98-h\").val(\'\');\r\n				}\r\n			} else if(value == \"3\") {\r\n				$(\"#A3-box\").addClass(\"hide\");\r\n				$(\"#A89-box\").removeClass(\"hide\");\r\n				$(\"#A98-box\").addClass(\"hide\");\r\n				$(\"#A106-box\").addClass(\"hide\");\r\n				$(\"#A3-h\").val(\'default-value\');\r\n				$(\"#A98-h\").val(\'default-value\');\r\n				$(\"#A106-h\").val(\'default-value\');	\r\n				if ($(\"#A89-h\").val()==\'default-value\'){\r\n					$(\"#A89-h\").val(\'\');\r\n				}\r\n			} else if(value == \"4\") {\r\n				$(\"#A3-box\").removeClass(\"hide\");\r\n				$(\"#A89-box\").addClass(\"hide\");\r\n				$(\"#A98-box\").addClass(\"hide\");\r\n				$(\"#A106-box\").addClass(\"hide\");\r\n				$(\"#A98-h\").val(\'default-value\');\r\n				$(\"#A89-h\").val(\'default-value\');\r\n				$(\"#A106-h\").val(\'default-value\');	\r\n				if ($(\"#A3-h\").val()==\'default-value\'){\r\n					$(\"#A3-h\").val(\'\');\r\n				}\r\n			} else if(value == \"5\") {\r\n				$(\"#A3-box\").addClass(\"hide\");\r\n				$(\"#A89-box\").addClass(\"hide\");\r\n				$(\"#A98-box\").addClass(\"hide\");\r\n				$(\"#A106-box\").removeClass(\"hide\");\r\n				$(\"#A98-h\").val(\'default-value\');\r\n				$(\"#A89-h\").val(\'default-value\');\r\n				$(\"#A3-h\").val(\'default-value\');\r\n				if ($(\"#A106-h\").val()==\'default-value\'){\r\n					$(\"#A106-h\").val(\'\');\r\n				}\r\n			} \r\n		}' WHERE `attrCode` = 'A88';
INSERT INTO `risk_materialformattrtemplate`(`createOn`, `updateOn`, `optionType`, `attrCode`, `attrName`, `events`, `isPageHidden`, `isRequired`, `script`, `seq`, `tips`, `type`, `mainEle`, `menuTemplate_id`, `activityType`, `supportProvince`, `maxFileSize`, `locked`) VALUES ('2016-12-22 21:26:48', '2016-12-22 21:26:48', NULL, 'A106', '组织单位的资质证明文件', '', '0', b'1', '', 13, '需加盖公章', 'pic', '0', 1, NULL, NULL, NULL, NULL);
