| 155 |
- |
1 |
--
|
|
|
2 |
-- Seo Panel 4.3.0 changes
|
|
|
3 |
--
|
|
|
4 |
|
|
|
5 |
update `settings` set set_val='4.3.0' WHERE `set_name` LIKE 'SP_VERSION_NUMBER';
|
|
|
6 |
|
|
|
7 |
|
|
|
8 |
UPDATE `searchengines` SET `regex` = '<div.*?class="?g.*?>.*?<div.*?class="r"*?>.*?<a href="(.*?)".*?>.*?<h3.*?>(.*?)<\\/h3>' WHERE `url` LIKE '%google%';
|
|
|
9 |
|
|
|
10 |
CREATE TABLE `sync_searchengines` (
|
|
|
11 |
`id` int(11) NOT NULL,
|
|
|
12 |
`sync_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
|
13 |
`status` tinyint(1) NOT NULL DEFAULT '0',
|
|
|
14 |
`result` text COLLATE utf8_unicode_ci NOT NULL
|
|
|
15 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
|
|
16 |
|
|
|
17 |
ALTER TABLE `sync_searchengines` ADD PRIMARY KEY (`id`);
|
|
|
18 |
ALTER TABLE `sync_searchengines` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
|
|
|
19 |
|
|
|
20 |
|
|
|
21 |
INSERT INTO `settings` (`set_label`, `set_name`, `set_val`, `set_category`, `set_type`, `display`) VALUES
|
|
|
22 |
('Enable Sendgrid API', 'SP_SENDGRID_API', '0', 'mail', 'bool', 1);
|
|
|
23 |
|
|
|
24 |
update settings set set_category='mail' where
|
|
|
25 |
set_name in ('SP_SMTP_MAIL', 'SP_SMTP_HOST', 'SP_SMTP_USERNAME', 'SP_SMTP_PASSWORD', 'SP_SMTP_PORT', 'SP_MAIL_ENCRYPTION');
|