| 155 |
- |
1 |
--
|
|
|
2 |
-- Seo Panel 4.2.0 changes
|
|
|
3 |
--
|
|
|
4 |
|
|
|
5 |
update `settings` set set_val='4.2.0' WHERE `set_name` LIKE 'SP_VERSION_NUMBER';
|
|
|
6 |
|
|
|
7 |
CREATE TABLE `review_links` (
|
|
|
8 |
`id` int(11) NOT NULL,
|
|
|
9 |
`website_id` int(11) NOT NULL,
|
|
|
10 |
`name` varchar(120) COLLATE utf8_unicode_ci NOT NULL,
|
|
|
11 |
`url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
|
|
|
12 |
`type` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'google_my_business',
|
|
|
13 |
`status` tinyint(1) NOT NULL DEFAULT '1'
|
|
|
14 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
|
|
15 |
|
|
|
16 |
ALTER TABLE `review_links` ADD PRIMARY KEY (`id`), ADD KEY `review_links_web_rel` (`website_id`);
|
|
|
17 |
ALTER TABLE `review_links` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
|
|
|
18 |
ALTER TABLE `review_links` ADD CONSTRAINT `review_links_web_rel` FOREIGN KEY (`website_id`) REFERENCES `websites` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;
|
|
|
19 |
ALTER TABLE `review_links` ADD UNIQUE( `website_id`, `url`);
|
|
|
20 |
|
|
|
21 |
CREATE TABLE `review_link_results` (
|
|
|
22 |
`id` bigint(20) NOT NULL,
|
|
|
23 |
`review_link_id` int(11) NOT NULL,
|
|
|
24 |
`reviews` int(11) NOT NULL DEFAULT '0',
|
|
|
25 |
`rating` float NOT NULL DEFAULT '0',
|
|
|
26 |
`report_date` date NOT NULL
|
|
|
27 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
|
|
28 |
|
|
|
29 |
|
|
|
30 |
ALTER TABLE `review_link_results` ADD PRIMARY KEY (`id`), ADD KEY `review_link_rel` (`review_link_id`);
|
|
|
31 |
ALTER TABLE `review_link_results` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;
|
|
|
32 |
ALTER TABLE `review_link_results` ADD CONSTRAINT `review_link_rel` FOREIGN KEY (`review_link_id`) REFERENCES `review_links` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;
|
|
|
33 |
|
|
|
34 |
INSERT INTO `seotools` (`name`, `url_section`, `user_access`, `reportgen`, `cron`, `priority`, `status`)
|
|
|
35 |
VALUES ('Review Manager', 'review-manager', '1', '1', '1', '100', '1');
|
|
|
36 |
|
|
|
37 |
UPDATE `searchengines` SET `regex` = '<div.*?class=\"?g.*?>.*?<div.*?class=\"r\"*?>.*?<a href=\"(.*?)\".*?>.*?<span.*?>(.*?)<\\/span><\\/h3>' WHERE `url` LIKE '%google%';
|