| 155 |
- |
1 |
--
|
|
|
2 |
-- Seo Panel 3.12.0 changes
|
|
|
3 |
--
|
|
|
4 |
|
|
|
5 |
update `settings` set set_val='3.12.0' WHERE `set_name` LIKE 'SP_VERSION_NUMBER';
|
|
|
6 |
|
|
|
7 |
|
|
|
8 |
ALTER TABLE `crawl_log` CHANGE `subject` `subject` VARCHAR(60) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL;
|
|
|
9 |
|
|
|
10 |
ALTER TABLE `crawl_log` CHANGE `crawl_cookie` `crawl_cookie` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL ;
|
|
|
11 |
|
|
|
12 |
ALTER TABLE `crawl_log` CHANGE `crawl_referer` `crawl_referer` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL ;
|
|
|
13 |
|
|
|
14 |
ALTER TABLE `crawl_log` CHANGE `crawl_post_fields` `crawl_post_fields` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL ;
|
|
|
15 |
|
|
|
16 |
ALTER TABLE `crawl_log` CHANGE `crawl_useragent` `crawl_useragent` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ;
|
|
|
17 |
|
|
|
18 |
ALTER TABLE `crawl_log` CHANGE `log_message` `log_message` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ;
|
|
|
19 |
|
|
|
20 |
ALTER TABLE `crawl_log` CHANGE `proxy_id` `proxy_id` INT( 11 ) UNSIGNED NOT NULL DEFAULT '0';
|
|
|
21 |
|
|
|
22 |
ALTER TABLE `crawl_log` CHANGE `ref_id` `ref_id` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ;
|
|
|
23 |
|
|
|
24 |
|
|
|
25 |
ALTER TABLE `auditorreports` CHANGE `page_title` `page_title` VARCHAR(180) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL;
|
|
|
26 |
|
|
|
27 |
ALTER TABLE `auditorreports` CHANGE `page_description` `page_description` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL;
|
|
|
28 |
|
|
|
29 |
ALTER TABLE `auditorreports` CHANGE `page_keywords` `page_keywords` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL;
|
|
|
30 |
|
|
|
31 |
ALTER TABLE `auditorreports` CHANGE `page_authority` `page_authority` FLOAT NOT NULL DEFAULT '0';
|
|
|
32 |
|
|
|
33 |
|
|
|
34 |
ALTER TABLE `saturationresults` CHANGE `result_time` `result_time` INT( 11 ) NOT NULL DEFAULT '0';
|
|
|
35 |
ALTER TABLE `backlinkresults` CHANGE `result_time` `result_time` INT( 11 ) NOT NULL DEFAULT '0';
|
|
|
36 |
ALTER TABLE `rankresults` CHANGE `result_time` `result_time` INT( 11 ) NOT NULL DEFAULT '0';
|
|
|
37 |
ALTER TABLE `rankresults` CHANGE `google_pagerank` `google_pagerank` INT( 8 ) NOT NULL DEFAULT '0';
|
|
|
38 |
|
|
|
39 |
ALTER TABLE `user_specs` ADD `spec_category` VARCHAR(32) NOT NULL DEFAULT 'system';
|
|
|
40 |
ALTER TABLE `user_specs` ADD UNIQUE( `user_type_id`, `spec_column`);
|