Discuz!X3.5优化 短信网关接口以及安全手机验证功能需要升级的数据库语句
Discuz!X3.5优化 短信网关接口以及安全手机验证功能需要升级的数据库语句：ALTER TABLE `pre_common_smslog` ADD `smstype` int(10) NOT NULL DEFAULT '0' AFTER `uid`;
ALTER TABLE `pre_common_smslog` ADD `svctype` int(10) NOT NULL DEFAULT '0' AFTER `smstype`;
ALTER TABLE `pre_common_smslog` ADD `smsgw` int(10) NOT NULL DEFAULT '0' AFTER `svctype`;
ALTER TABLE `pre_common_smslog` ADD `status` int(10) NOT NULL DEFAULT '0' AFTER `smsgw`;
ALTER TABLE `pre_common_smslog` ADD `verify` int(10) NOT NULL DEFAULT '0' AFTER `status`;
ALTER TABLE `pre_common_smslog` ADD `secmobicc` varchar(3) NOT NULL DEFAULT '' AFTER `verify`;
ALTER TABLE `pre_common_smslog` ADD `secmobile` varchar(12) NOT NULL DEFAULT '' AFTER `uid`;
ALTER TABLE `pre_common_smslog` ADD `ip` varchar(45) NOT NULL DEFAULT '' AFTER `secmobile`;
ALTER TABLE `pre_common_smslog` ADD `port` varchar(45) NOT NULL DEFAULT '' AFTER `ip`;
ALTER TABLE `pre_common_smslog` ADD `content` varchar(45) NOT NULL DEFAULT '' AFTER `port`;
ALTER TABLE `pre_common_smslog` ADD `dateline` varchar(45) NOT NULL DEFAULT '' AFTER `content`;
ALTER TABLE `pre_common_smslog` DROP INDEX `lastsent`, ADD KEY `dateline` (`secmobicc`, `secmobile`, `dateline`), ADD KEY `uid` (`uid`);
DROP TABLE IF EXISTS `pre_common_smslog_archive`;
CREATE TABLE `pre_common_smslog_archive` (
`smslogid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`uid` mediumint(8) unsigned NOT NULL,
`smstype` int(10) NOT NULL DEFAULT '0',
`svctype` int(10) NOT NULL DEFAULT '0',
`smsgw` int(10) NOT NULL DEFAULT '0',
`status` int(10) NOT NULL DEFAULT '0',
`verify` int(10) NOT NULL DEFAULT '0',
`secmobicc` varchar(3) NOT NULL DEFAULT '',
`secmobile` varchar(12) NOT NULL DEFAULT '',
`ip` varchar(45) NOT NULL DEFAULT '',
`port` smallint(6) unsigned NOT NULL DEFAULT '0',
`content` text NOT NULL,
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`smslogid`)
) ENGINE=InnoDB;
ALTER TABLE `pre_common_member` ADD KEY secmobile (`secmobile`, `secmobicc`);
INSERT INTO pre_common_cron VALUES ('21','1','system','每周短信日志归档','cron_smslog_daily.php','1269746639','1269792000','-1','-1','03','0');
INSERT INTO pre_common_setting VALUES ('smsdefaultlength','4');
页:
[1]
