| 155 |
- |
1 |
--
|
|
|
2 |
-- Seo Panel 3.11.0 changes
|
|
|
3 |
--
|
|
|
4 |
|
|
|
5 |
update `settings` set set_val='3.11.0' WHERE `set_name` LIKE 'SP_VERSION_NUMBER';
|
|
|
6 |
|
|
|
7 |
ALTER TABLE `keywords` ADD `crawled` TINYINT( 1 ) NOT NULL DEFAULT '0';
|
|
|
8 |
|
|
|
9 |
ALTER TABLE `websites` ADD `crawled` TINYINT( 1 ) NOT NULL DEFAULT '0';
|
|
|
10 |
|
|
|
11 |
|
|
|
12 |
ALTER TABLE `rankresults` ADD `result_date` DATE NULL , ADD INDEX ( `result_date` );
|
|
|
13 |
UPDATE `rankresults` SET `result_date` = FROM_UNIXTIME(result_time, '%Y-%m-%d');
|
|
|
14 |
|
|
|
15 |
|
|
|
16 |
ALTER TABLE `backlinkresults` ADD `result_date` DATE NULL , ADD INDEX ( `result_date` );
|
|
|
17 |
UPDATE `backlinkresults` SET `result_date` = FROM_UNIXTIME(result_time, '%Y-%m-%d');
|
|
|
18 |
|
|
|
19 |
ALTER TABLE `saturationresults` ADD `result_date` DATE NULL , ADD INDEX ( `result_date` );
|
|
|
20 |
UPDATE `saturationresults` SET `result_date` = FROM_UNIXTIME(result_time, '%Y-%m-%d');
|
|
|
21 |
|
|
|
22 |
INSERT INTO `settings` (`set_label`, `set_name`, `set_val`, `set_category`, `set_type`, `display`)
|
|
|
23 |
VALUES ('Google API Key', 'SP_GOOGLE_API_KEY', '', 'google', 'large', '1');
|
|
|
24 |
|
|
|
25 |
INSERT INTO `seotools` (`name`, `url_section`, `user_access`, `reportgen`, `cron`, `status`)
|
|
|
26 |
VALUES ('PageSpeed Insights', 'pagespeed', '1', '1', '1', '1');
|
|
|
27 |
|
|
|
28 |
|
|
|
29 |
CREATE TABLE IF NOT EXISTS `pagespeedresults` (
|
|
|
30 |
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
|
|
|
31 |
`website_id` int(11) NOT NULL,
|
|
|
32 |
`desktop_speed_score` smallint(6) NOT NULL,
|
|
|
33 |
`mobile_speed_score` smallint(6) NOT NULL,
|
|
|
34 |
`mobile_usability_score` smallint(6) NOT NULL,
|
|
|
35 |
`result_date` date NOT NULL,
|
|
|
36 |
PRIMARY KEY (`id`),
|
|
|
37 |
KEY `result_date` (`result_date`)
|
|
|
38 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
|
|
|
39 |
|
|
|
40 |
CREATE TABLE IF NOT EXISTS `pagespeeddetails` (
|
|
|
41 |
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
|
|
|
42 |
`website_id` int(11) NOT NULL,
|
|
|
43 |
`desktop_score_details` text NOT NULL,
|
|
|
44 |
`mobile_score_details` text NOT NULL,
|
|
|
45 |
`result_date` date NOT NULL,
|
|
|
46 |
PRIMARY KEY (`id`),
|
|
|
47 |
KEY `result_date` (`result_date`)
|
|
|
48 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;
|
|
|
49 |
|
|
|
50 |
INSERT INTO `settings` (`set_label`, `set_name`, `set_val`, `set_category`, `set_type`, `display`) VALUES
|
|
|
51 |
('Number of websites needs to be checked in each cron execution', 'SP_NUMBER_WEBSITES_CRON', '1', 'report', 'small', 0);
|
|
|
52 |
|
|
|
53 |
update `settings` set set_val='1',display=0 WHERE `set_name` LIKE 'SP_NUMBER_KEYWORDS_CRON';
|
|
|
54 |
|