去评论
dz插件网

Discuz!X3.5优化 短信网关接口以及安全手机验证功能需要升级的数据库语句

admin
2022/01/01 16:12:33
Discuz!X3.5优化 短信网关接口以及安全手机验证功能需要升级的数据库语句：

  1. ALTER TABLE `pre_common_smslog` ADD `smstype` int(10) NOT NULL DEFAULT '0' AFTER `uid`;
  2. ALTER TABLE `pre_common_smslog` ADD `svctype` int(10) NOT NULL DEFAULT '0' AFTER `smstype`;
  3. ALTER TABLE `pre_common_smslog` ADD `smsgw` int(10) NOT NULL DEFAULT '0' AFTER `svctype`;
  4. ALTER TABLE `pre_common_smslog` ADD `status` int(10) NOT NULL DEFAULT '0' AFTER `smsgw`;
  5. ALTER TABLE `pre_common_smslog` ADD `verify` int(10) NOT NULL DEFAULT '0' AFTER `status`;
  6. ALTER TABLE `pre_common_smslog` ADD `secmobicc` varchar(3) NOT NULL DEFAULT '' AFTER `verify`;
  7. ALTER TABLE `pre_common_smslog` ADD `secmobile` varchar(12) NOT NULL DEFAULT '' AFTER `uid`;
  8. ALTER TABLE `pre_common_smslog` ADD `ip` varchar(45) NOT NULL DEFAULT '' AFTER `secmobile`;
  9. ALTER TABLE `pre_common_smslog` ADD `port` varchar(45) NOT NULL DEFAULT '' AFTER `ip`;
  10. ALTER TABLE `pre_common_smslog` ADD `content` varchar(45) NOT NULL DEFAULT '' AFTER `port`;
  11. ALTER TABLE `pre_common_smslog` ADD `dateline` varchar(45) NOT NULL DEFAULT '' AFTER `content`;


  14. ALTER TABLE `pre_common_smslog` DROP INDEX `lastsent`, ADD KEY `dateline` (`secmobicc`, `secmobile`, `dateline`), ADD KEY `uid` (`uid`);


  17. DROP TABLE IF EXISTS `pre_common_smslog_archive`;
  18. CREATE TABLE `pre_common_smslog_archive` (
  19.   `smslogid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  20.   `uid` mediumint(8) unsigned NOT NULL,
  21.   `smstype` int(10) NOT NULL DEFAULT '0',
  22.   `svctype` int(10) NOT NULL DEFAULT '0',
  23.   `smsgw` int(10) NOT NULL DEFAULT '0',
  24.   `status` int(10) NOT NULL DEFAULT '0',
  25.   `verify` int(10) NOT NULL DEFAULT '0',
  26.   `secmobicc` varchar(3) NOT NULL DEFAULT '',
  27.   `secmobile` varchar(12) NOT NULL DEFAULT '',
  28.   `ip` varchar(45) NOT NULL DEFAULT '',
  29.   `port` smallint(6) unsigned NOT NULL DEFAULT '0',
  30.   `content` text NOT NULL,
  31.   `dateline` int(10) unsigned NOT NULL DEFAULT '0',
  32.   PRIMARY KEY (`smslogid`)
  33. ) ENGINE=InnoDB;


  36. ALTER TABLE `pre_common_member` ADD KEY secmobile (`secmobile`, `secmobicc`);

  38. INSERT INTO pre_common_cron VALUES ('21','1','system','每周短信日志归档','cron_smslog_daily.php','1269746639','1269792000','-1','-1','03','0');

  40. INSERT INTO pre_common_setting VALUES ('smsdefaultlength','4');


进入原文参与互动