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', '瀹℃壒缁撴灉鏂囦欢澶�');