| 155 |
- |
1 |
--
|
|
|
2 |
-- Seo Panel 3.15.0 changes
|
|
|
3 |
--
|
|
|
4 |
|
|
|
5 |
update `settings` set set_val='3.15.0' WHERE `set_name` LIKE 'SP_VERSION_NUMBER';
|
|
|
6 |
|
|
|
7 |
|
|
|
8 |
CREATE TABLE IF NOT EXISTS `user_report_logs` (
|
|
|
9 |
`id` int(11) NOT NULL,
|
|
|
10 |
`user_id` int(11) NOT NULL,
|
|
|
11 |
`report_date` datetime NOT NULL
|
|
|
12 |
) ENGINE=MyISAM;
|
|
|
13 |
ALTER TABLE `user_report_logs` ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`);
|
|
|
14 |
ALTER TABLE `user_report_logs` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
|
|
|
15 |
|
|
|
16 |
|
|
|
17 |
CREATE TABLE IF NOT EXISTS `webmaster_keywords` (
|
|
|
18 |
`id` bigint(24) unsigned NOT NULL,
|
|
|
19 |
`name` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
|
|
|
20 |
`website_id` int(11) DEFAULT NULL,
|
|
|
21 |
`status` tinyint(1) DEFAULT '1'
|
|
|
22 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
|
|
23 |
ALTER TABLE `webmaster_keywords` ADD PRIMARY KEY (`id`), ADD KEY `website_id` (`website_id`);
|
|
|
24 |
ALTER TABLE `webmaster_keywords` MODIFY `id` bigint(24) unsigned NOT NULL AUTO_INCREMENT;
|
|
|
25 |
|
|
|
26 |
INSERT INTO `settings` (`set_label`, `set_name`, `set_val`, `set_category`, `set_type`, `display`) VALUES
|
|
|
27 |
('Enable Proxy for Google API', 'SP_ENABLE_PROXY_GOOGLE_API', '1', 'proxy', 'bool', 1);
|