| 155 |
- |
1 |
--
|
|
|
2 |
-- This section includes the database changes of Seo Panel version from 2.0.0 to 2.1.0
|
|
|
3 |
--
|
|
|
4 |
|
|
|
5 |
--
|
|
|
6 |
-- To add proxy settings to settings table
|
|
|
7 |
--
|
|
|
8 |
|
|
|
9 |
INSERT INTO `settings` (`id`, `set_label`, `set_name`, `set_val`, `set_type`) VALUES
|
|
|
10 |
(9, 'Enable Proxy', 'SP_ENABLE_PROXY', '0', 'bool');
|
|
|
11 |
|
|
|
12 |
INSERT INTO `settings` (`id`, `set_label`, `set_name`, `set_val`, `set_type`) VALUES (NULL, 'Default Language', 'SP_DEFAULTLANG', 'en', 'small');
|
|
|
13 |
|
|
|
14 |
--
|
|
|
15 |
-- Table structure for table `proxylist`
|
|
|
16 |
--
|
|
|
17 |
|
|
|
18 |
CREATE TABLE IF NOT EXISTS `proxylist` (
|
|
|
19 |
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
|
|
|
20 |
`proxy` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
|
|
|
21 |
`port` int(8) DEFAULT NULL,
|
|
|
22 |
`proxy_auth` tinyint(1) NOT NULL DEFAULT '0',
|
|
|
23 |
`proxy_username` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
|
|
|
24 |
`proxy_password` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
|
|
|
25 |
`status` tinyint(1) NOT NULL DEFAULT '0',
|
|
|
26 |
PRIMARY KEY (`id`)
|
|
|
27 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;
|
|
|
28 |
|
|
|
29 |
--
|
|
|
30 |
-- alter search engine table for storing non utf8 search engines
|
|
|
31 |
--
|
|
|
32 |
|
|
|
33 |
ALTER TABLE `searchengines` ADD `encoding` VARCHAR( 32 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL AFTER `description_index`;
|
|
|
34 |
|
|
|
35 |
--
|
|
|
36 |
-- Alter user table to add lang_code
|
|
|
37 |
--
|
|
|
38 |
ALTER TABLE `users` ADD `lang_code` VARCHAR( 8 ) NOT NULL DEFAULT 'en' AFTER `email`;
|
|
|
39 |
|
|
|
40 |
--
|
|
|
41 |
-- Alter directroy table
|
|
|
42 |
--
|
|
|
43 |
ALTER TABLE `directories` ADD `google_pagerank` SMALLINT NOT NULL DEFAULT '0',
|
|
|
44 |
ADD `alexa_rank` INT( 11 ) NOT NULL DEFAULT '-1',
|
|
|
45 |
ADD `lang_code` VARCHAR( 8 ) NOT NULL DEFAULT 'en',
|
|
|
46 |
ADD `checked` BOOL NOT NULL DEFAULT '0';
|
|
|
47 |
|
|
|
48 |
ALTER TABLE `directories` ADD UNIQUE (
|
|
|
49 |
`submit_url`
|
|
|
50 |
);
|
|
|
51 |
|
|
|
52 |
--
|
|
|
53 |
-- to enable image saving for captcha
|
|
|
54 |
--
|
|
|
55 |
UPDATE `settings` SET `set_val` = '1' WHERE `settings`.`id` =7;
|