| 155 |
- |
1 |
--
|
|
|
2 |
-- Seo Panel 3.17.0 changes
|
|
|
3 |
--
|
|
|
4 |
|
|
|
5 |
update `settings` set set_val='3.17.0' WHERE `set_name` LIKE 'SP_VERSION_NUMBER';
|
|
|
6 |
|
|
|
7 |
CREATE TABLE IF NOT EXISTS `webmaster_sitemaps` (
|
|
|
8 |
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
|
9 |
`website_id` int(11) NOT NULL,
|
|
|
10 |
`path` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
|
|
|
11 |
`last_submitted` datetime NOT NULL,
|
|
|
12 |
`last_downloaded` datetime NOT NULL,
|
|
|
13 |
`is_pending` tinyint(4) NOT NULL DEFAULT '0',
|
|
|
14 |
`warnings` int(11) NOT NULL DEFAULT '0',
|
|
|
15 |
`errors` int(11) NOT NULL DEFAULT '0',
|
|
|
16 |
`submitted` int(11) NOT NULL DEFAULT '0',
|
|
|
17 |
`indexed` int(11) NOT NULL DEFAULT '0',
|
|
|
18 |
`status` tinyint(4) NOT NULL DEFAULT '1',
|
|
|
19 |
PRIMARY KEY (`id`),
|
|
|
20 |
KEY `website_id` (`website_id`)
|
|
|
21 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
|
|
|
22 |
|
|
|
23 |
|
|
|
24 |
update `featured_directories` set status=0 WHERE `directory_name` LIKE 'beta-i.org';
|
|
|
25 |
INSERT INTO `featured_directories` (`directory_name`, `directory_link`, `google_pagerank`, `coupon_code`, `coupon_offer`, `status`)
|
|
|
26 |
VALUES ('directorymaximizer.com', 'http://www.directorymaximizer.com/af.php?af=207564&ad=5&p=1', '6', '', 0, '1');
|
|
|
27 |
|
|
|
28 |
INSERT INTO `user_specs` (`user_type_id`, `spec_column`, `spec_value`, `spec_category`) VALUES
|
|
|
29 |
(2, 'searchengine_count', '3', 'system'),
|
|
|
30 |
(2, 'directory_submit_limit', '150', 'system'),
|
|
|
31 |
(2, 'directory_submit_daily_limit', '100', 'system'),
|
|
|
32 |
(2, 'site_auditor_max_page_limit', '500', 'system'),
|
|
|
33 |
(2, 'plugin_1', '1', 'system'),
|
|
|
34 |
(2, 'plugin_2', '1', 'system'),
|
|
|
35 |
(2, 'plugin_3', '1', 'system'),
|
|
|
36 |
(2, 'seotool_1', '1', 'system'),
|
|
|
37 |
(2, 'seotool_2', '1', 'system'),
|
|
|
38 |
(2, 'seotool_3', '1', 'system'),
|
|
|
39 |
(2, 'seotool_4', '1', 'system'),
|
|
|
40 |
(2, 'seotool_5', '1', 'system'),
|
|
|
41 |
(2, 'seotool_6', '1', 'system'),
|
|
|
42 |
(2, 'seotool_7', '1', 'system'),
|
|
|
43 |
(2, 'seotool_8', '1', 'system') ON DUPLICATE KEY UPDATE spec_value=spec_value;
|
|
|
44 |
|