
CREATE TABLE `log_smslog` (
  `oid` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `createOn` datetime DEFAULT NULL COMMENT '创建时间',
  `updateOn` datetime DEFAULT NULL COMMENT '修改时间',
  `phone` varchar(20) DEFAULT NULL COMMENT '手机号',
  `content` varchar(255) DEFAULT NULL COMMENT '内容',
  `success` varchar(10) DEFAULT NULL COMMENT '发送状态',
  PRIMARY KEY (`oid`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;



delete from config_materialformattrtemplate where attrCode in (
'G2',
'G3',
'G4',
'G5',
'G16',
'G18',
'G21',
'G20',
'G42',
'G43',
'G44'
);

update config_materialformattrtemplate
set tips = '需要包含的预案内容有反恐防爆、火灾、临建倒塌、防踩踏等预案工作'
where attrCode = 'G45';

#陕西
INSERT INTO `config_systemconfig`(`createOn`, `updateOn`, `syskey`, `sysvalue`, `description`)
VALUES ( now(), now(), 'spjg_folder', 'shanxispjg', '审批结果文件夹');