| 155 |
- |
1 |
--
|
|
|
2 |
-- Seo Panel 3.14.0 changes
|
|
|
3 |
--
|
|
|
4 |
|
|
|
5 |
update `settings` set set_val='3.14.0' WHERE `set_name` LIKE 'SP_VERSION_NUMBER';
|
|
|
6 |
|
|
|
7 |
CREATE TABLE IF NOT EXISTS `user_tokens` (
|
|
|
8 |
`id` bigint(20) NOT NULL,
|
|
|
9 |
`user_id` int(11) NOT NULL,
|
|
|
10 |
`access_token` text COLLATE utf8_unicode_ci NOT NULL,
|
|
|
11 |
`refresh_token` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
|
|
|
12 |
`token_type` varchar(120) COLLATE utf8_unicode_ci NOT NULL,
|
|
|
13 |
`expires_in` int(11) NOT NULL DEFAULT '3600' COMMENT 'seconds',
|
|
|
14 |
`created` datetime NOT NULL,
|
|
|
15 |
`token_category` enum('google','twitter','facebook','linkedin') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'google'
|
|
|
16 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
|
|
17 |
|
|
|
18 |
ALTER TABLE `user_tokens` ADD PRIMARY KEY (`id`);
|
|
|
19 |
ALTER TABLE `user_tokens` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;
|
|
|
20 |
|
|
|
21 |
|
|
|
22 |
INSERT INTO `settings` (`set_label`, `set_name`, `set_val`, `set_category`, `set_type`, `display`) VALUES
|
|
|
23 |
('Google API Client Id', 'SP_GOOGLE_API_CLIENT_ID', '', 'google', 'large', '1'),
|
|
|
24 |
('Google API Client Secret', 'SP_GOOGLE_API_CLIENT_SECRET', '', 'google', 'large', '1'),
|
|
|
25 |
('Google Analytics Tracking Code', 'SP_GOOGLE_ANALYTICS_TRACK_CODE', '', 'google', 'text', '1');
|
|
|
26 |
|
|
|
27 |
ALTER TABLE `users` ADD column `confirm_code` varchar(120) NOT NULL DEFAULT '';
|
|
|
28 |
ALTER TABLE `users` ADD column `confirm` tinyint(1) NOT NULL DEFAULT '0';
|
|
|
29 |
|
|
|
30 |
CREATE TABLE IF NOT EXISTS `website_search_analytics` (
|
|
|
31 |
`id` bigint(20) NOT NULL,
|
|
|
32 |
`website_id` int(11) NOT NULL,
|
|
|
33 |
`clicks` int(11) NOT NULL,
|
|
|
34 |
`impressions` int(11) NOT NULL,
|
|
|
35 |
`ctr` float NOT NULL,
|
|
|
36 |
`average_position` float NOT NULL,
|
|
|
37 |
`report_date` date NOT NULL
|
|
|
38 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
|
|
39 |
|
|
|
40 |
ALTER TABLE `website_search_analytics` ADD `source` ENUM( 'google', 'yahoo', 'bing', 'baidu', 'yandex' ) NOT NULL DEFAULT 'google';
|
|
|
41 |
ALTER TABLE `website_search_analytics` ADD PRIMARY KEY (`id`), ADD KEY `website_id` (`website_id`);
|
|
|
42 |
ALTER TABLE `website_search_analytics` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;
|
|
|
43 |
|
|
|
44 |
CREATE TABLE IF NOT EXISTS `keyword_analytics` (
|
|
|
45 |
`id` bigint(20) NOT NULL,
|
|
|
46 |
`keyword_id` int(11) NOT NULL,
|
|
|
47 |
`clicks` int(11) NOT NULL,
|
|
|
48 |
`impressions` int(11) NOT NULL,
|
|
|
49 |
`ctr` float NOT NULL,
|
|
|
50 |
`average_position` float NOT NULL,
|
|
|
51 |
`report_date` date NOT NULL
|
|
|
52 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
|
|
53 |
|
|
|
54 |
ALTER TABLE `keyword_analytics` ADD `source` ENUM( 'google', 'yahoo', 'bing', 'baidu', 'yandex' ) NOT NULL DEFAULT 'google';
|
|
|
55 |
ALTER TABLE `keyword_analytics` ADD PRIMARY KEY (`id`), ADD KEY `keyword_id` (`keyword_id`);
|
|
|
56 |
ALTER TABLE `keyword_analytics` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;
|
|
|
57 |
|
|
|
58 |
ALTER TABLE `usertypes` CHANGE `description` `description` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL;
|
|
|
59 |
|
|
|
60 |
ALTER TABLE `seotools` ADD `priority` INT NOT NULL DEFAULT '100' AFTER `cron` ;
|
|
|
61 |
|
|
|
62 |
UPDATE `seotools` SET `priority` = '10' WHERE url_section='keyword-position-checker';
|
|
|
63 |
|
|
|
64 |
INSERT `seotools` (`name`, `url_section` ,`user_access` ,`reportgen` ,`cron` ,`status`, `priority`)
|
|
|
65 |
VALUES ('Webmaster Tools', 'webmaster-tools', '1', '1', '1', '1', '20');
|
|
|
66 |
|
|
|
67 |
ALTER TABLE `seoplugins` ADD `priority` INT NOT NULL DEFAULT '100';
|