Subversion Repositories cheapmusic

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
155 - 1 
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
2 
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
3 
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
4 
/*!40101 SET NAMES utf8 */;
5 
 
6 
CREATE TABLE IF NOT EXISTS `alerts` (
7 
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
8 
  `user_id` int(11) NOT NULL,
9 
  `alert_subject` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
10 
  `alert_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
11 
  `alert_category` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'general',
12 
  `alert_message` text COLLATE utf8_unicode_ci NOT NULL,
13 
  `alert_type` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'success',
14 
  `visited` tinyint(1) NOT NULL DEFAULT '0',
15 
  `alert_time` datetime NOT NULL,
16 
  PRIMARY KEY (`id`),
17 
  KEY `alert_user_delete` (`user_id`)
18 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
19 
 
20 
CREATE TABLE IF NOT EXISTS `analytic_sources` (
21 
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
22 
  `source_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
23 
  PRIMARY KEY (`id`),
24 
  UNIQUE KEY `source_name` (`source_name`)
25 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
26 
 
27 
CREATE TABLE IF NOT EXISTS `auditorpagelinks` (
28 
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
29 
  `report_id` bigint(20) NOT NULL,
30 
  `link_url` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
31 
  `link_anchor` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
32 
  `link_title` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
33 
  `nofollow` tinyint(1) NOT NULL DEFAULT '0',
34 
  `extrenal` tinyint(1) NOT NULL DEFAULT '0',
35 
  `brocken` tinyint(1) NOT NULL DEFAULT '0',
36 
  PRIMARY KEY (`id`),
37 
  KEY `report_id` (`report_id`)
38 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
39 
 
40 
CREATE TABLE IF NOT EXISTS `auditorprojects` (
41 
  `id` int(11) NOT NULL AUTO_INCREMENT,
42 
  `website_id` int(11) NOT NULL,
43 
  `max_links` int(11) NOT NULL DEFAULT '500',
44 
  `exclude_links` text COLLATE utf8_unicode_ci NOT NULL,
45 
  `check_pr` tinyint(1) NOT NULL DEFAULT '0',
46 
  `check_backlinks` tinyint(1) NOT NULL DEFAULT '0',
47 
  `check_indexed` tinyint(1) NOT NULL DEFAULT '0',
48 
  `store_links_in_page` tinyint(1) NOT NULL DEFAULT '0',
49 
  `check_brocken` tinyint(1) NOT NULL DEFAULT '0',
50 
  `score` float NOT NULL DEFAULT '0',
51 
  `cron` tinyint(1) NOT NULL DEFAULT '1',
52 
  `status` tinyint(1) NOT NULL DEFAULT '1',
53 
  PRIMARY KEY (`id`),
54 
  KEY `website_id` (`website_id`)
55 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
56 
 
57 
CREATE TABLE IF NOT EXISTS `auditorreports` (
58 
  `id` bigint(24) NOT NULL AUTO_INCREMENT,
59 
  `project_id` int(11) NOT NULL,
60 
  `page_url` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
61 
  `page_title` varchar(180) COLLATE utf8_unicode_ci DEFAULT NULL,
62 
  `page_description` text COLLATE utf8_unicode_ci,
63 
  `page_keywords` text COLLATE utf8_unicode_ci,
64 
  `pagerank` float NOT NULL DEFAULT '0',
65 
  `google_backlinks` int(11) NOT NULL DEFAULT '0',
66 
  `bing_backlinks` int(11) NOT NULL DEFAULT '0',
67 
  `google_indexed` int(11) NOT NULL DEFAULT '0',
68 
  `bing_indexed` int(11) NOT NULL DEFAULT '0',
69 
  `total_links` int(11) NOT NULL DEFAULT '0',
70 
  `external_links` int(11) NOT NULL DEFAULT '0',
71 
  `brocken` tinyint(1) NOT NULL DEFAULT '0',
72 
  `crawled` tinyint(1) NOT NULL DEFAULT '0',
73 
  `score` smallint(6) NOT NULL DEFAULT '0',
74 
  `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
75 
  `page_authority` float NOT NULL DEFAULT '0',
76 
  PRIMARY KEY (`id`),
77 
  UNIQUE KEY `project_id_2` (`project_id`,`page_url`),
78 
  KEY `project_id` (`project_id`)
79 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
80 
 
81 
CREATE TABLE IF NOT EXISTS `backlinkresults` (
82 
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
83 
  `website_id` int(11) NOT NULL,
84 
  `google` int(11) NOT NULL,
85 
  `msn` int(11) NOT NULL,
86 
  `alexa` int(11) NOT NULL,
87 
  `result_time` int(11) NOT NULL DEFAULT '0',
88 
  `result_date` date DEFAULT NULL,
89 
  PRIMARY KEY (`id`),
90 
  KEY `result_date` (`result_date`)
91 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
92 
 
93 
CREATE TABLE IF NOT EXISTS `country` (
94 
  `country_code` char(2) COLLATE utf8_unicode_ci NOT NULL,
95 
  `country_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
96 
  PRIMARY KEY (`country_code`)
97 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
98 
 
99 
INSERT INTO `country` (`country_code`, `country_name`) VALUES
100 
('AD', 'Andorra'),
101 
('AE', 'United Arab Emirates'),
102 
('AF', 'Afghanistan'),
103 
('AG', 'Antigua and Barbuda'),
104 
('AI', 'Anguilla'),
105 
('AL', 'Albania'),
106 
('AM', 'Armenia'),
107 
('AN', 'Netherlands Antilles'),
108 
('AO', 'Angola'),
109 
('AP', 'Asia/Pacific Region'),
110 
('AQ', 'Antarctica'),
111 
('AR', 'Argentina'),
112 
('AS', 'American Samoa'),
113 
('AT', 'Austria'),
114 
('AU', 'Australia'),
115 
('AW', 'Aruba'),
116 
('AX', 'Aland Islands'),
117 
('AZ', 'Azerbaijan'),
118 
('BA', 'Bosnia and Herzegovina'),
119 
('BB', 'Barbados'),
120 
('BD', 'Bangladesh'),
121 
('BE', 'Belgium'),
122 
('BF', 'Burkina Faso'),
123 
('BG', 'Bulgaria'),
124 
('BH', 'Bahrain'),
125 
('BI', 'Burundi'),
126 
('BJ', 'Benin'),
127 
('BM', 'Bermuda'),
128 
('BN', 'Brunei Darussalam'),
129 
('BO', 'Bolivia'),
130 
('BR', 'Brazil'),
131 
('BS', 'Bahamas'),
132 
('BT', 'Bhutan'),
133 
('BV', 'Bouvet Island'),
134 
('BW', 'Botswana'),
135 
('BY', 'Belarus'),
136 
('BZ', 'Belize'),
137 
('CA', 'Canada'),
138 
('CC', 'Cocos (Keeling) Islands'),
139 
('CD', 'Congo'),
140 
('CF', 'Central African Republic'),
141 
('CG', 'Congo'),
142 
('CH', 'Switzerland'),
143 
('CI', 'Cote d''Ivoire'),
144 
('CK', 'Cook Islands'),
145 
('CL', 'Chile'),
146 
('CM', 'Cameroon'),
147 
('CN', 'China'),
148 
('CO', 'Colombia'),
149 
('CR', 'Costa Rica'),
150 
('CU', 'Cuba'),
151 
('CV', 'Cape Verde'),
152 
('CX', 'Christmas Island'),
153 
('CY', 'Cyprus'),
154 
('CZ', 'Czech Republic'),
155 
('DE', 'Germany'),
156 
('DJ', 'Djibouti'),
157 
('DK', 'Denmark'),
158 
('DM', 'Dominica'),
159 
('DO', 'Dominican Republic'),
160 
('DZ', 'Algeria'),
161 
('EC', 'Ecuador'),
162 
('EE', 'Estonia'),
163 
('EG', 'Egypt'),
164 
('EH', 'Western Sahara'),
165 
('ER', 'Eritrea'),
166 
('ES', 'Spain'),
167 
('ET', 'Ethiopia'),
168 
('EU', 'Europe'),
169 
('FI', 'Finland'),
170 
('FJ', 'Fiji'),
171 
('FK', 'Falkland Islands (Malvinas)'),
172 
('FM', 'Micronesia Federated States of'),
173 
('FO', 'Faroe Islands'),
174 
('FR', 'France'),
175 
('GA', 'Gabon'),
176 
('GB', 'United Kingdom'),
177 
('GD', 'Grenada'),
178 
('GE', 'Georgia'),
179 
('GF', 'French Guiana'),
180 
('GG', 'Guernsey'),
181 
('GH', 'Ghana'),
182 
('GI', 'Gibraltar'),
183 
('GL', 'Greenland'),
184 
('GM', 'Gambia'),
185 
('GN', 'Guinea'),
186 
('GP', 'Guadeloupe'),
187 
('GQ', 'Equatorial Guinea'),
188 
('GR', 'Greece'),
189 
('GS', 'South Georgia and the South Sandwich Islands'),
190 
('GT', 'Guatemala'),
191 
('GU', 'Guam'),
192 
('GW', 'Guinea-Bissau'),
193 
('GY', 'Guyana'),
194 
('HK', 'Hong Kong'),
195 
('HM', 'Heard Island and McDonald Islands'),
196 
('HN', 'Honduras'),
197 
('HR', 'Croatia'),
198 
('HT', 'Haiti'),
199 
('HU', 'Hungary'),
200 
('ID', 'Indonesia'),
201 
('IE', 'Ireland'),
202 
('IL', 'Israel'),
203 
('IM', 'Isle of Man'),
204 
('IN', 'India'),
205 
('IO', 'British Indian Ocean Territory'),
206 
('IQ', 'Iraq'),
207 
('IR', 'Iran Islamic Republic of'),
208 
('IS', 'Iceland'),
209 
('IT', 'Italy'),
210 
('JE', 'Jersey'),
211 
('JM', 'Jamaica'),
212 
('JO', 'Jordan'),
213 
('JP', 'Japan'),
214 
('KE', 'Kenya'),
215 
('KG', 'Kyrgyzstan'),
216 
('KH', 'Cambodia'),
217 
('KI', 'Kiribati'),
218 
('KM', 'Comoros'),
219 
('KN', 'Saint Kitts and Nevis'),
220 
('KP', 'Korea Democratic People''s Republic of'),
221 
('KR', 'Korea Republic of'),
222 
('KW', 'Kuwait'),
223 
('KY', 'Cayman Islands'),
224 
('KZ', 'Kazakhstan'),
225 
('LA', 'Lao People''s Democratic Republic'),
226 
('LB', 'Lebanon'),
227 
('LC', 'Saint Lucia'),
228 
('LI', 'Liechtenstein'),
229 
('LK', 'Sri Lanka'),
230 
('LR', 'Liberia'),
231 
('LS', 'Lesotho'),
232 
('LT', 'Lithuania'),
233 
('LU', 'Luxembourg'),
234 
('LV', 'Latvia'),
235 
('LY', 'Libyan Arab Jamahiriya'),
236 
('MA', 'Morocco'),
237 
('MC', 'Monaco'),
238 
('MD', 'Moldova Republic of'),
239 
('ME', 'Montenegro'),
240 
('MG', 'Madagascar'),
241 
('MH', 'Marshall Islands'),
242 
('MK', 'Macedonia'),
243 
('ML', 'Mali'),
244 
('MM', 'Myanmar'),
245 
('MN', 'Mongolia'),
246 
('MO', 'Macao'),
247 
('MP', 'Northern Mariana Islands'),
248 
('MQ', 'Martinique'),
249 
('MR', 'Mauritania'),
250 
('MS', 'Montserrat'),
251 
('MT', 'Malta'),
252 
('MU', 'Mauritius'),
253 
('MV', 'Maldives'),
254 
('MW', 'Malawi'),
255 
('MX', 'Mexico'),
256 
('MY', 'Malaysia'),
257 
('MZ', 'Mozambique'),
258 
('NA', 'Namibia'),
259 
('NC', 'New Caledonia'),
260 
('NE', 'Niger'),
261 
('NF', 'Norfolk Island'),
262 
('NG', 'Nigeria'),
263 
('NI', 'Nicaragua'),
264 
('NL', 'Netherlands'),
265 
('NO', 'Norway'),
266 
('NP', 'Nepal'),
267 
('NR', 'Nauru'),
268 
('NU', 'Niue'),
269 
('NZ', 'New Zealand'),
270 
('OM', 'Oman'),
271 
('PA', 'Panama'),
272 
('PE', 'Peru'),
273 
('PF', 'French Polynesia'),
274 
('PG', 'Papua New Guinea'),
275 
('PH', 'Philippines'),
276 
('PK', 'Pakistan'),
277 
('PL', 'Poland'),
278 
('PM', 'Saint Pierre and Miquelon'),
279 
('PN', 'Pitcairn'),
280 
('PR', 'Puerto Rico'),
281 
('PS', 'Palestinian Territory'),
282 
('PT', 'Portugal'),
283 
('PW', 'Palau'),
284 
('PY', 'Paraguay'),
285 
('QA', 'Qatar'),
286 
('RE', 'Reunion'),
287 
('RO', 'Romania'),
288 
('RS', 'Serbia'),
289 
('RU', 'Russian Federation'),
290 
('RW', 'Rwanda'),
291 
('SA', 'Saudi Arabia'),
292 
('SB', 'Solomon Islands'),
293 
('SC', 'Seychelles'),
294 
('SD', 'Sudan'),
295 
('SE', 'Sweden'),
296 
('SG', 'Singapore'),
297 
('SH', 'Saint Helena'),
298 
('SI', 'Slovenia'),
299 
('SJ', 'Svalbard and Jan Mayen'),
300 
('SK', 'Slovakia'),
301 
('SL', 'Sierra Leone'),
302 
('SM', 'San Marino'),
303 
('SN', 'Senegal'),
304 
('SO', 'Somalia'),
305 
('SR', 'Suriname'),
306 
('ST', 'Sao Tome and Principe'),
307 
('SV', 'El Salvador'),
308 
('SY', 'Syrian Arab Republic'),
309 
('SZ', 'Swaziland'),
310 
('TC', 'Turks and Caicos Islands'),
311 
('TD', 'Chad'),
312 
('TF', 'French Southern Territories'),
313 
('TG', 'Togo'),
314 
('TH', 'Thailand'),
315 
('TJ', 'Tajikistan'),
316 
('TK', 'Tokelau'),
317 
('TL', 'Timor-Leste'),
318 
('TM', 'Turkmenistan'),
319 
('TN', 'Tunisia'),
320 
('TO', 'Tonga'),
321 
('TR', 'Turkey'),
322 
('TT', 'Trinidad and Tobago'),
323 
('TV', 'Tuvalu'),
324 
('TW', 'Taiwan'),
325 
('TZ', 'Tanzania United Republic of'),
326 
('UA', 'Ukraine'),
327 
('UG', 'Uganda'),
328 
('UM', 'United States Minor Outlying Islands'),
329 
('US', 'United States'),
330 
('UY', 'Uruguay'),
331 
('UZ', 'Uzbekistan'),
332 
('VA', 'Holy See (Vatican City State)'),
333 
('VC', 'Saint Vincent and the Grenadines'),
334 
('VE', 'Venezuela'),
335 
('VG', 'Virgin Islands British'),
336 
('VI', 'Virgin Islands U.S.'),
337 
('VN', 'Vietnam'),
338 
('VU', 'Vanuatu'),
339 
('WF', 'Wallis and Futuna'),
340 
('WS', 'Samoa'),
341 
('YE', 'Yemen'),
342 
('YT', 'Mayotte'),
343 
('ZA', 'South Africa'),
344 
('ZM', 'Zambia'),
345 
('ZW', 'Zimbabwe');
346 
 
347 
CREATE TABLE IF NOT EXISTS `crawl_log` (
348 
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
349 
  `crawl_type` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'other',
350 
  `ref_id` text COLLATE utf8_unicode_ci,
351 
  `subject` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL,
352 
  `crawl_link` text COLLATE utf8_unicode_ci NOT NULL,
353 
  `crawl_referer` text COLLATE utf8_unicode_ci,
354 
  `crawl_cookie` text COLLATE utf8_unicode_ci,
355 
  `crawl_post_fields` text COLLATE utf8_unicode_ci,
356 
  `crawl_useragent` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
357 
  `crawl_status` tinyint(4) NOT NULL DEFAULT '1',
358 
  `proxy_id` int(11) unsigned NOT NULL DEFAULT '0',
359 
  `log_message` text COLLATE utf8_unicode_ci,
360 
  `crawl_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
361 
  PRIMARY KEY (`id`),
362 
  KEY `crawl_status` (`crawl_status`),
363 
  KEY `crawl_type` (`crawl_type`),
364 
  KEY `proxy_id` (`proxy_id`)
365 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
366 
 
367 
CREATE TABLE IF NOT EXISTS `currency` (
368 
  `id` int(11) NOT NULL AUTO_INCREMENT,
369 
  `name` varchar(160) COLLATE utf8_unicode_ci NOT NULL,
370 
  `iso_code` varchar(3) COLLATE utf8_unicode_ci NOT NULL,
371 
  `symbol` varchar(3) COLLATE utf8_unicode_ci NOT NULL,
372 
  `unicode` varchar(8) COLLATE utf8_unicode_ci NOT NULL,
373 
  `position` varchar(6) COLLATE utf8_unicode_ci NOT NULL,
374 
  `paypal` tinyint(1) NOT NULL DEFAULT '0',
375 
  `status` tinyint(1) NOT NULL DEFAULT '1',
376 
  PRIMARY KEY (`id`),
377 
  UNIQUE KEY `iso_code` (`iso_code`)
378 
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=68 ;
379 
 
380 
INSERT INTO `currency` (`id`, `name`, `iso_code`, `symbol`, `unicode`, `position`, `paypal`, `status`) VALUES
381 
(1, 'United Arab Emirates Dirham', 'AED', 'د.', '', 'after', 0, 1),
382 
(2, 'Netherlands Antillian Guilder', 'ANG', 'Æ’', 'ƒ', 'before', 0, 1),
383 
(3, '', 'AOA', 'AOA', 'AOA', 'before', 0, 1),
384 
(4, 'Argentine Peso', 'ARS', '$', '$', 'before', 0, 1),
385 
(5, 'Australian Dollar', 'AUD', '$', '$', 'before', 1, 1),
386 
(6, '', 'BAM', 'KM', 'KM', 'before', 0, 1),
387 
(7, 'Barbados Dollar', 'BBD', '$', '$', 'before', 0, 1),
388 
(8, '', 'BGL', 'лÐ', 'л&', 'before', 0, 1),
389 
(9, 'Bahraini Dinar', 'BHD', 'BD', 'BD', 'after', 0, 1),
390 
(10, 'Brunei Dollar', 'BND', '$', '$', 'before', 0, 1),
391 
(11, 'Brazilian Real', 'BRL', 'R$', 'R$', 'before', 1, 1),
392 
(12, 'Canadian Dollar', 'CAD', '$', '$', 'before', 1, 1),
393 
(13, 'Swiss Franc', 'CHF', 'Fr', 'Fr', 'before', 1, 1),
394 
(14, 'Chilean Unidades de Fomento', 'CLF', 'UF', 'UF', 'after', 0, 1),
395 
(15, 'Chilean Peso', 'CLP', '$', '$', 'before', 0, 1),
396 
(16, 'Yuan (Chinese) Renminbi', 'CNY', 'Â¥', '¥', 'before', 0, 1),
397 
(17, 'Colombian Peso', 'COP', '$', '$', 'before', 0, 1),
398 
(18, 'Costa Rican Colon', 'CRC', 'â‚¡', '₡', 'before', 0, 1),
399 
(19, 'Czech Republic Koruna', 'CZK', 'Kč', 'Kč', 'after', 1, 1),
400 
(20, 'Danish Krone', 'DKK', 'kr', 'kr', 'before', 1, 1),
401 
(21, 'Estonian Kroon (EEK)', 'EEK', 'KR', 'KR', 'before', 0, 1),
402 
(22, 'Egyptian Pound', 'EGP', 'E£', 'E£', 'before', 0, 1),
403 
(23, 'Euro', 'EUR', '€', '€', 'before', 1, 1),
404 
(24, 'Fiji Dollar', 'FJD', 'FJ$', 'FJ$', 'before', 0, 1),
405 
(25, 'British Pound', 'GBP', '£', '£', 'before', 1, 1),
406 
(26, 'Guatemalan Quetzal', 'GTQ', 'Q', 'Q', 'before', 0, 1),
407 
(27, 'Hong Kong Dollar', 'HKD', '$', '$', 'before', 1, 1),
408 
(28, '', 'HRK', 'kn', 'kn', 'before', 0, 1),
409 
(29, 'Hungarian Forint', 'HUF', 'Ft', 'Ft', 'before', 1, 1),
410 
(30, 'Indonesian Rupiah', 'IDR', 'Rp', 'Rp', 'before', 0, 1),
411 
(31, 'Israeli Shekel', 'ILS', '₪', '₪', 'before', 1, 1),
412 
(32, 'Indian Rupee', 'INR', 'Rs', 'Rs', 'before', 0, 1),
413 
(33, 'Jordanian Dinar', 'JOD', 'د.', '', '', 0, 1),
414 
(34, 'Japanese Yen', 'JPY', 'Â¥', '¥', 'before', 1, 1),
415 
(35, 'Kenyan Schilling', 'KES', 'KSh', 'Ksh', 'before', 0, 1),
416 
(36, '(South) Korean Won', 'KRW', 'â‚©', '₩', 'before', 0, 1),
417 
(37, 'Kuwaiti Dinar', 'KWD', 'KD', 'KD', 'after', 0, 1),
418 
(38, 'Cayman Islands Dollar', 'KYD', '$', '$', 'before', 0, 1),
419 
(39, '', 'LTL', 'Lt', 'Lt', 'before', 0, 1),
420 
(40, '', 'LVL', 'Ls', 'Ls', 'before', 0, 1),
421 
(41, 'Moroccan Dirham', 'MAD', 'د.', '', '', 0, 1),
422 
(42, 'Maldive Rufiyaa', 'MVR', 'Rf', 'Rf', 'before', 0, 1),
423 
(43, '', 'MXN', '$', '$', 'before', 1, 1),
424 
(44, 'Malaysian Ringgit', 'MYR', 'RM', 'RM', 'before', 1, 1),
425 
(45, 'Nigerian Naira', 'NGN', '₦', '₦', 'before', 0, 1),
426 
(46, 'Norwegian Kroner', 'NOK', 'kr', 'kr', 'before', 1, 1),
427 
(47, 'New Zealand Dollar', 'NZD', '$', '$', 'before', 1, 1),
428 
(48, 'Omani Rial', 'OMR', 'OMR', '﷼', 'after', 0, 1),
429 
(49, 'Peruvian Nuevo Sol', 'PEN', 'S/.', 'S/.', 'before', 0, 1),
430 
(50, 'Philippine Peso', 'PHP', '₱', '₱', 'before', 1, 1),
431 
(51, 'Polish Zloty', 'PLN', 'zÅ‚', 'Zł', 'before', 1, 1),
432 
(52, 'Qatari Rial', 'QAR', 'QAR', '﷼', 'after', 0, 1),
433 
(53, 'Romanian Leu', 'RON', 'lei', 'lei', 'before', 0, 1),
434 
(54, 'Russian Ruble', 'RUB', 'Ñ€Ñ', 'р&', 'before', 1, 1),
435 
(55, 'Saudi Arabian Riyal', 'SAR', 'SAR', '﷼', 'after', 0, 1),
436 
(56, 'Swedish Krona', 'SEK', 'kr', 'kr', 'before', 1, 1),
437 
(57, 'Singapore Dollar', 'SGD', '$', '$', 'before', 1, 1),
438 
(58, 'Thai Baht', 'THB', '฿', 'ł', 'before', 1, 1),
439 
(59, 'Turkish Lira', 'TRY', 'TL', 'TL', 'before', 1, 1),
440 
(60, 'Trinidad and Tobago Dollar', 'TTD', '$', '$', 'before', 0, 1),
441 
(61, 'Taiwan Dollar', 'TWD', '$', '$', 'before', 0, 1),
442 
(62, '', 'UAH', 'â‚´', '₴', 'before', 0, 1),
443 
(63, 'US Dollar', 'USD', '$', '$', 'before', 1, 1),
444 
(64, 'Venezualan Bolivar', 'VEF', 'Bs ', 'Bs.', 'before', 0, 1),
445 
(65, 'Vietnamese Dong', 'VND', 'â‚«', '₫', 'before', 0, 1),
446 
(66, 'East Caribbean Dollar', 'XCD', '$', '$', 'before', 0, 1),
447 
(67, 'South African Rand', 'ZAR', 'R', 'R', 'before', 0, 1);
448 
 
449 
CREATE TABLE IF NOT EXISTS `directories` (
450 
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
451 
  `domain` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
452 
  `submit_url` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
453 
  `captcha_script` varchar(100) CHARACTER SET latin1 NOT NULL DEFAULT 'captcha.php',
454 
  `search_script` varchar(100) CHARACTER SET latin1 NOT NULL DEFAULT 'index.php?q=[--keyword--]',
455 
  `title_col` varchar(16) CHARACTER SET latin1 NOT NULL DEFAULT 'TITLE',
456 
  `url_col` varchar(16) CHARACTER SET latin1 NOT NULL DEFAULT 'URL',
457 
  `description_col` varchar(16) CHARACTER SET latin1 NOT NULL DEFAULT 'DESCRIPTION',
458 
  `name_col` varchar(16) CHARACTER SET latin1 NOT NULL DEFAULT 'OWNER_NAME',
459 
  `email_col` varchar(16) CHARACTER SET latin1 NOT NULL DEFAULT 'OWNER_EMAIL',
460 
  `category_col` varchar(16) CHARACTER SET latin1 NOT NULL DEFAULT 'CATEGORY_ID',
461 
  `cptcha_col` varchar(16) CHARACTER SET latin1 NOT NULL DEFAULT 'CAPTCHA',
462 
  `imagehash_col` varchar(16) CHARACTER SET latin1 NOT NULL DEFAULT 'IMAGEHASH',
463 
  `imagehashurl_col` varchar(16) CHARACTER SET latin1 NOT NULL DEFAULT 'imagehash',
464 
  `reciprocal_col` varchar(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'RECPR_URL',
465 
  `extra_val` varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT 'LINK_TYPE=normal&submit=Continue&AGREERULES=on',
466 
  `is_captcha` tinyint(1) NOT NULL DEFAULT '0',
467 
  `working` tinyint(1) NOT NULL DEFAULT '1',
468 
  `google_pagerank` smallint(6) NOT NULL DEFAULT '0',
469 
  `alexa_rank` int(11) NOT NULL DEFAULT '-1',
470 
  `lang_code` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'en',
471 
  `checked` tinyint(1) NOT NULL DEFAULT '0',
472 
  `script_type_id` int(11) NOT NULL DEFAULT '1',
473 
  `rank` int(11) NOT NULL DEFAULT '0',
474 
  `is_reciprocal` tinyint(1) NOT NULL DEFAULT '0',
475 
  `pagerank` float NOT NULL DEFAULT '0',
476 
  `domain_authority` float NOT NULL,
477 
  `page_authority` float NOT NULL,
478 
  PRIMARY KEY (`id`),
479 
  UNIQUE KEY `submit_url` (`submit_url`)
480 
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=160 ;
481 
 
482 
INSERT INTO `directories` (`id`, `domain`, `submit_url`, `captcha_script`, `search_script`, `title_col`, `url_col`, `description_col`, `name_col`, `email_col`, `category_col`, `cptcha_col`, `imagehash_col`, `imagehashurl_col`, `reciprocal_col`, `extra_val`, `is_captcha`, `working`, `google_pagerank`, `alexa_rank`, `lang_code`, `checked`, `script_type_id`, `rank`, `is_reciprocal`, `pagerank`, `domain_authority`, `page_authority`) VALUES
483 
(145, 'http://www.listasweb.info', 'http://www.listasweb.info/submit.php', 'captcha.php', 'index.php?search=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 2, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
484 
(144, 'http://www.oroop.com', 'http://www.oroop.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 0, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
485 
(143, 'http://www.webdirectorybook.com', 'http://www.webdirectorybook.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=reciprocal&submit=Continue&AGREERULES=on', 0, 0, 2, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
486 
(142, 'http://www.westcelt.org', 'http://www.westcelt.org/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 1, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
487 
(141, 'http://www.wishdc.org', 'http://www.wishdc.org/submit.php', 'captcha.php', 'index.php?search=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 1, 1, 0, -1, 'en', 1, 1, 0, 0, 5.26, 31.92, 43.14),
488 
(140, 'http://www.w3c-software.com', 'http://www.w3c-software.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 1, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
489 
(139, 'http://www.interactive-directory.com', 'http://www.interactive-directory.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 0, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
490 
(138, 'http://www.go2directory.info', 'http://www.go2directory.info/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 1, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
491 
(137, 'http://www.firstfindengine.com', 'http://www.firstfindengine.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=reciprocal&submit=Continue&AGREERULES=on&RECPR_URL=http://www.firstfindengine.com', 0, 0, 1, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
492 
(136, 'http://www.faceahead.com', 'http://www.faceahead.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 1, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
493 
(135, 'http://www.extreme-directory.net', 'http://www.extreme-directory.net/submit.php', 'captcha.php', 'index.php?search=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 2, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
494 
(134, 'http://www.minidirectory.info', 'http://www.minidirectory.info/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 1, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
495 
(133, 'http://www.lexormedia.com', 'http://www.lexormedia.com/submit.php', 'captcha.php', 'index.php?search=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 0, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
496 
(132, 'http://www.easyadsworld.com', 'http://www.easyadsworld.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 0, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
497 
(131, 'http://www.corporategoof.com', 'http://www.corporategoof.com/submit.php', 'captcha.php', 'index.php?search=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 0, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
498 
(130, 'http://www.seodir.eu', 'http://www.seodir.eu/submit.php', 'captcha.php', 'index.php?search=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 0, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
499 
(129, 'http://www.directorydr.com', 'http://www.directorydr.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 0, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
500 
(128, 'http://directorywind.com', 'http://directorywind.com/submit.php?LINK_TYPE=2', 'captcha.php', 'index.php?search=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=2&submit=Continue&AGREERULES=on', 0, 0, 3, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
501 
(127, 'http://www.visuallinkdirectory.com', 'http://www.visuallinkdirectory.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 2, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
502 
(126, 'http://www.thecommercialdirectory.com', 'http://www.thecommercialdirectory.com/submit.php', 'captcha.php', 'index.php?search=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 1, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
503 
(125, 'http://www.freeonlineregister.com', 'http://www.freeonlineregister.com/submit.php', 'captcha.php', 'index.php?search=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=reciprocal&submit=Continue&AGREERULES=on&RECPR_URL=http://www.freeonlineregister.com', 0, 0, 1, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
504 
(124, 'http://www.vccllc.com', 'http://www.vccllc.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 1, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
505 
(123, 'http://www.findinfo.ws', 'http://www.findinfo.ws/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 3, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
506 
(122, 'http://www.devdir.biz', 'http://www.devdir.biz/submit.php', 'captcha.php', 'index.php?search=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=reciprocal&submit=Continue&AGREERULES=on&RECPR_URL=http://www.devdir.biz', 0, 0, 0, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
507 
(121, 'http://www.stepmind.com', 'http://www.stepmind.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 1, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
508 
(120, 'http://www.edirectori.com', 'http://www.edirectori.com/submit.php', 'captcha.php', 'index.php?search=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 0, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
509 
(119, 'http://www.netnamesindex.com', 'http://www.netnamesindex.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=reciprocal&submit=Continue&AGREERULES=on&RECPR_URL=http://www.netnamesindex.com', 0, 0, 0, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
510 
(117, 'http://www.worldurllink.com', 'http://www.worldurllink.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=reciprocal&submit=Continue&AGREERULES=on&RECPR_URL=http://www.worldurllink.com', 0, 0, 2, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
511 
(116, 'http://www.websitelists.info', 'http://www.websitelists.info/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 2, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
512 
(115, 'http://www.urlvault.info', 'http://www.urlvault.info/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=reciprocal&submit=Continue&AGREERULES=on&RECPR_URL=http://www.urlvault.info', 0, 0, 2, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
513 
(114, 'http://www.seolistsite.com', 'http://www.seolistsite.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=reciprocal&submit=Continue&AGREERULES=on&RECPR_URL=http://www.seolistsite.com', 0, 0, 1, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
514 
(113, 'http://www.searchpowertour.com', 'http://www.searchpowertour.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=reciprocal&submit=Continue&AGREERULES=on&RECPR_URL=http://www.searchpowertour.com', 0, 0, 0, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
515 
(112, 'http://www.netdirectorylink.com', 'http://www.netdirectorylink.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=reciprocal&submit=Continue&AGREERULES=on', 0, 0, 1, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
516 
(111, 'http://www.monsterlinkdirectory.com', 'http://www.monsterlinkdirectory.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=reciprocal&submit=Continue&AGREERULES=on&RECPR_URL=http://www.monsterlinkdirectory.com', 0, 0, 0, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
517 
(110, 'http://www.inlinkdirectory.com', 'http://www.inlinkdirectory.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=reciprocal&submit=Continue&AGREERULES=on&RECPR_URL=http://www.inlinkdirectory.com', 0, 0, 0, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
518 
(109, 'http://www.heydirectory.com', 'http://www.heydirectory.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 3, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
519 
(108, 'http://www.generalnetdirectory.com', 'http://www.generalnetdirectory.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=reciprocal&submit=Continue&AGREERULES=on', 0, 0, 1, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
520 
(107, 'http://www.freeweblist.info', 'http://www.freeweblist.info/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 0, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
521 
(106, 'http://www.freeonlineindex.com', 'http://www.freeonlineindex.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=reciprocal&submit=Continue&AGREERULES=on&RECPR_URL=http://www.freeonlineindex.com', 0, 0, 0, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
522 
(104, 'http://www.directoryfreelink.com', 'http://www.directoryfreelink.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=reciprocal&submit=Continue&AGREERULES=on&RECPR_URL=http://www.directoryfreelink.com', 0, 0, 0, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
523 
(103, 'http://www.cheapwebdir.com', 'http://www.cheapwebdir.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 1, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
524 
(102, 'http://www.anyweblist.com', 'http://www.anyweblist.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=reciprocal&submit=Continue&AGREERULES=on&RECPR_URL=http://www.anyweblist.com', 0, 0, 2, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
525 
(101, 'http://www.zerotres.com', 'http://www.zerotres.com/submit.php', 'captcha.php', 'index.php?search=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 0, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
526 
(100, 'http://www.thehdb.com', 'http://www.thehdb.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 0, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
527 
(99, 'http://www.linkfly.info', 'http://www.linkfly.info/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=free&submit=Continue&AGREERULES=on', 0, 0, 2, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
528 
(98, 'http://www.jordangreen.info', 'http://www.jordangreen.info/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=free&submit=Continue&AGREERULES=on', 0, 0, 1, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
529 
(97, 'http://www.ggfb.org', 'http://www.ggfb.org/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 0, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
530 
(96, 'http://www.etup.org', 'http://www.etup.org/submit.php', 'captcha.php', 'index.php?search=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 0, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
531 
(94, 'http://z0p.com', 'http://z0p.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 1, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
532 
(93, 'http://www.yournetdirectory.com', 'http://www.yournetdirectory.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 2, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
533 
(92, 'http://www.teacherslounge.info', 'http://www.teacherslounge.info/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 0, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
534 
(91, 'http://www.homessearchengine.com', 'http://www.homessearchengine.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 1, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
535 
(90, 'http://www.zzdirectory.com', 'http://www.zzdirectory.com/submit.php', 'captcha.php', 'index.php?search=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 1, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
536 
(89, 'http://www.liveurls.net', 'http://www.liveurls.net/submit.php', 'captcha.php', 'index.php?search=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 0, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
537 
(88, 'http://www.agrieducation.org', 'http://www.agrieducation.org/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 1, 3, -1, 'en', 1, 1, 0, 0, 5.65, 39.77, 49.86),
538 
(87, 'http://www.freewd.org', 'http://www.freewd.org/submit.php?LINK_TYPE=2', 'captcha.php', 'index.php?search=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=2&submit=Continue&AGREERULES=on', 0, 0, 0, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
539 
(86, 'http://www.coolwebsitelistings.com', 'http://www.coolwebsitelistings.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 0, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
540 
(85, 'http://www.ns8.biz', 'http://www.ns8.biz/submit.php', 'captcha.php', 'index.php?search=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 1, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
541 
(84, 'http://www.gfxmedia.us', 'http://www.gfxmedia.us/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 1, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
542 
(83, 'http://www.biowatchmed.net', 'http://www.biowatchmed.net/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 2, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
543 
(82, 'http://www.lemurgene.com', 'http://www.lemurgene.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 2, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
544 
(80, 'http://www.tuenschel.com', 'http://www.tuenschel.com/submit.php', 'captcha.php', 'index.php?search=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=reciprocal&submit=Continue&AGREERULES=on&RECPR_URL=http://www.tuenschel.com', 0, 0, 0, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
545 
(79, 'http://www.migliana.com', 'http://www.migliana.com/submit.php', 'captcha.php', 'index.php?search=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=reciprocal&submit=Continue&AGREERULES=on&RECPR_URL=http://www.migliana.com', 0, 0, 2, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
546 
(78, 'http://www.prolificpi.com', 'http://www.prolificpi.com/submit.php', 'captcha.php', 'index.php?search=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=reciprocal&submit=Continue&AGREERULES=on&RECPR_URL=http://www.prolificpi.com', 0, 0, 0, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
547 
(77, 'http://www.mymaxlinks.info', 'http://www.mymaxlinks.info/submit.php', 'captcha.php', 'index.php?search=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 2, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
548 
(76, 'http://www.counterdeal.com', 'http://www.counterdeal.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=reciprocal&submit=Continue&AGREERULES=on', 0, 0, 3, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
549 
(73, 'http://www.mytopdirectory.info', 'http://www.mytopdirectory.info/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 0, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
550 
(72, 'http://www.thelivinglink.net', 'http://www.thelivinglink.net/submit.php', 'captcha.php', 'index.php?search=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 4, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
551 
(70, 'http://www.towerpromote.com', 'http://www.towerpromote.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 2, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
552 
(68, 'http://www.picna.com', 'http://www.picna.com/submit.php', 'captcha.php', 'index.php?search=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=reciprocal&submit=Continue&AGREERULES=on&RECPR_URL=http://www.picna.com', 0, 0, 0, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
553 
(67, 'http://www.owdirectory.com', 'http://www.owdirectory.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 1, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
554 
(66, 'http://www.haqj.com', 'http://www.haqj.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 0, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
555 
(65, 'http://www.gkiv.com', 'http://www.gkiv.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 0, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
556 
(64, 'http://www.insectuniverse.com', 'http://www.insectuniverse.com/submit.php', 'captcha.php', 'index.php?search=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=reciprocal&submit=Continue&AGREERULES=on&RECPR_URL=http://www.insectuniverse.com', 0, 0, 0, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
557 
(63, 'http://www.greatdir.net', 'http://www.greatdir.net/submit.php', 'captcha.php', 'index.php?search=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 0, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
558 
(62, 'http://www.jambezi.com', 'http://www.jambezi.com/submit.php', 'captcha.php', 'index.php?search=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=reciprocal&submit=Continue&AGREERULES=on&RECPR_URL=http://www.jambezi.com', 0, 0, 0, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
559 
(61, 'http://www.tkdirectory.com', 'http://www.tkdirectory.com/submit.php?LINK_TYPE=1', 'captcha.php', 'index.php?search=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'reciprocal=1&LINK_TYPE=1&submit=Continue&AGREERULES=on', 0, 0, 1, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
560 
(58, 'http://www.directoryrank.net', 'http://www.directoryrank.net/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 0, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
561 
(57, 'http://www.submitsitenow.info', 'http://www.submitsitenow.info/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 2, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
562 
(56, 'http://www.addyourlnksnow.com', 'http://www.addyourlnksnow.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=free&submit=Continue&AGREERULES=on', 0, 0, 2, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
563 
(54, 'http://www.holidaydig.com', 'http://www.holidaydig.com/submit.php', 'captcha.php', 'index.php?search=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=free&submit=Continue&AGREERULES=on', 0, 0, 2, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
564 
(55, 'http://www.yrkdirectory.com', 'http://www.yrkdirectory.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 0, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
565 
(53, 'http://www.mymaxlinks.org', 'http://www.mymaxlinks.org/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 0, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
566 
(52, 'http://www.sblinks.org', 'http://www.sblinks.org/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 0, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
567 
(51, 'http://www.lutonengineering.com', 'http://www.lutonengineering.com/submit.php?LINK_TYPE=2', 'captcha.php', 'index.php?search=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=2&submit=Continue&AGREERULES=on', 0, 0, 3, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
568 
(50, 'http://www.doubledirectory.com', 'http://www.doubledirectory.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 2, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
569 
(49, 'http://www.boomdirectory.com', 'http://www.boomdirectory.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 1, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
570 
(47, 'http://www.deblinley.com', 'http://www.deblinley.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 1, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
571 
(48, 'http://www.jhucr.org', 'http://www.jhucr.org/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 0, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
572 
(46, 'http://www.directorybin.com', 'http://www.directorybin.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 1, 3, -1, 'en', 1, 1, 0, 0, 5.79, 41.16, 50.57),
573 
(45, 'http://www.magdalyns.com', 'http://www.magdalyns.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 0, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
574 
(44, 'http://www.goobz.biz', 'http://www.goobz.biz/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 2, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
575 
(43, 'http://www.gainweb.org', 'http://www.gainweb.org/submit.php?LINK_TYPE=2', 'captcha.php', 'index.php?search=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=2&submit=Continue&AGREERULES=on', 0, 1, 4, -1, 'en', 1, 1, 1, 0, 6.09, 41.58, 51),
576 
(42, 'http://www.indiabusinessdirectory.info', 'http://www.indiabusinessdirectory.info/submit.php', 'captcha.php', 'index.php?search=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 0, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
577 
(41, 'http://www.omega-link.co.uk', 'http://www.omega-link.co.uk/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 1, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
578 
(40, 'http://www.webslink.info', 'http://www.webslink.info/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 1, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
579 
(39, 'http://www.nuclearland.com', 'http://www.nuclearland.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 2, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
580 
(37, 'http://www.freelistingdirectory.info', 'http://www.freelistingdirectory.info/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=reciprocal&submit=Continue&AGREERULES=on&RECPR_URL=http://www.freelistingdirectory.info', 0, 0, 1, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
581 
(35, 'http://www.crazyleafdesign.com/webdirectory', 'http://www.crazyleafdesign.com/webdirectory/submit?LINK_TYPE=1', 'captcha.php', 'index.php?search=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=1&submit=Continue&AGREERULES=on', 1, 0, 0, -1, 'en', 1, 1, 2, 0, 6.12, 51.88, 52.77),
582 
(34, 'http://www.linkspremium.com', 'http://www.linkspremium.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 2, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
583 
(33, 'http://www.hitalyzer.com', 'http://www.hitalyzer.com/submit.php', 'captcha.php', 'index.php?search=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 1, 3, -1, 'en', 1, 1, 0, 0, 5.48, 38.03, 47.35),
584 
(32, 'http://directory.seoexecutive.com', 'http://directory.seoexecutive.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=free&submit=Continue&AGREERULES=on', 0, 0, 0, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
585 
(31, 'http://directory.allaboutadtips.com', 'http://directory.allaboutadtips.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 2, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
586 
(30, 'http://www.clickmybrick.com', 'http://www.clickmybrick.com/submit.php', 'captcha.php', 'index.php?search=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 0, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
587 
(29, 'http://www.placeyourlinks.com', 'http://www.placeyourlinks.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 3, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
588 
(28, 'http://www.seocourt.com', 'http://www.seocourt.com/submit.php', 'captcha.php', 'index.php?search=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 1, 1, 0, -1, 'en', 1, 1, 0, 0, 5.8, 46.71, 53.19),
589 
(27, 'http://www.linkedout.info', 'http://www.linkedout.info/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 2, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
590 
(26, 'http://www.triplewdirectory.com', 'http://www.triplewdirectory.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 1, 0, -1, 'en', 1, 1, 0, 0, 5.56, 40.12, 50.1),
591 
(25, 'http://www.yvir.com', 'http://www.yvir.com/submit.php?LINK_TYPE=2', 'captcha.php', 'index.php?search=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'z=1&LINK_TYPE=2&submit=Continue&AGREERULES=on', 0, 0, 1, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
592 
(23, 'http://www.1abc.org', 'http://www.1abc.org/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=free&submit=Continue&AGREERULES=on', 0, 1, 0, -1, 'en', 1, 1, 0, 0, 6.17, 54.24, 62.04),
593 
(22, 'http://www.pblake.com', 'http://www.pblake.com/submit.php', 'captcha.php', 'index.php?search=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 4, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
594 
(21, 'http://www.aaawebdirectory.com', 'http://www.aaawebdirectory.com/submit.php', 'captcha.php', 'index.php?search=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=free&submit=Continue&AGREERULES=on', 0, 0, 0, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
595 
(20, 'http://www.sanory.com', 'http://www.sanory.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 3, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
596 
(19, 'http://www.domaining.in', 'http://www.domaining.in/submit.php', 'captcha.php', 'index.php?search=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=free&submit=Continue&AGREERULES=on', 0, 0, 4, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
597 
(18, 'http://www.miriblack.com', 'http://www.miriblack.com/submit.php', 'captcha.php', 'index.php?search=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 1, 1, 0, -1, 'en', 1, 1, 0, 0, 5.67, 47.02, 54.01),
598 
(17, 'http://www.alistsites.com', 'http://www.alistsites.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 1, 0, -1, 'en', 1, 1, 0, 0, 5.88, 41.57, 51.35),
599 
(16, 'http://www.cheapdirectory.net', 'http://www.cheapdirectory.net/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=reciprocal&submit=Continue&AGREERULES=on', 0, 0, 3, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
600 
(15, 'http://www.ewebdir.com', 'http://www.ewebdir.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=free&submit=Continue&AGREERULES=on', 1, 1, 0, -1, 'en', 1, 1, 0, 0, 4.9, 27.28, 38.47),
601 
(14, 'http://www.tfwd.org', 'http://www.tfwd.org/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=free&submit=Continue&AGREERULES=on', 0, 1, 1, -1, 'en', 1, 1, 0, 0, 4.8, 28.47, 39.2),
602 
(13, 'http://www.pr3plus.com', 'http://www.pr3plus.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 1, 1, 0, -1, 'en', 1, 1, 0, 0, 5.49, 34.8, 45.67),
603 
(12, 'http://www.123hitlinks.info', 'http://www.123hitlinks.info/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=free&submit=Continue&AGREERULES=on', 1, 1, 0, -1, 'en', 1, 1, 0, 0, 5.8, 44.27, 53.65),
604 
(10, 'http://www.directoryvault.com', 'http://www.directoryvault.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 1, 0, -1, 'en', 1, 1, 0, 0, 6.11, 44.64, 53.95),
605 
(9, 'http://www.skypemedia.com', 'http://www.skypemedia.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 2, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
606 
(8, 'http://www.webhotlink.com', 'http://www.webhotlink.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=free&submit=Continue&AGREERULES=on', 0, 1, 0, -1, 'en', 1, 1, 0, 0, 5.3, 34.91, 45.7),
607 
(6, 'http://www.freewebsitedirectory.com', 'http://www.freewebsitedirectory.com/submit.php', 'captcha.php', 'index.php?search=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 0, -1, 'en', 1, 1, 0, 0, 6.34, 53.58, 61.49),
608 
(5, 'http://www.777media.com', 'http://www.777media.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 0, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
609 
(3, 'http://www.onpaco.com', 'http://www.onpaco.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 1, 0, -1, 'en', 1, 1, 0, 0, 5.58, 33.32, 44.39),
610 
(2, 'http://www.fat64.net', 'http://www.fat64.net/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 1, 1, 0, -1, 'en', 1, 1, 0, 0, 5.79, 43.47, 52.97),
611 
(1, 'http://directory.seofreetools.net', 'http://directory.seofreetools.net/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=reciprocal&submit=Continue&AGREERULES=on', 1, 1, 0, -1, 'en', 1, 1, 1, 0, 6.65, 47.24, 51.26),
612 
(146, 'http://www.sblinks.info', 'http://www.sblinks.info/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 0, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
613 
(147, 'http://www.thehopedirectory.com', 'http://www.thehopedirectory.com/submit.php', 'captcha.php', 'index.php?search=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 0, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
614 
(148, 'http://www.clocktowerstudio.com', 'http://www.clocktowerstudio.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 2, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
615 
(149, 'http://www.infotechwv.com', 'http://www.infotechwv.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 0, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
616 
(150, 'http://www.dawsoneng.com', 'http://www.dawsoneng.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 2, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
617 
(151, 'http://www.cafrid.com', 'http://www.cafrid.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 1, 1, 0, -1, 'en', 1, 1, 0, 0, 4.64, 29.42, 41.05),
618 
(152, 'http://www.fusionsalcedo.com', 'http://www.fusionsalcedo.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 1, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
619 
(153, 'http://www.justaskluke.com', 'http://www.justaskluke.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 0, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
620 
(154, 'http://www.logha.com', 'http://www.logha.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 0, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
621 
(155, 'http://www.pacdec.org', 'http://www.pacdec.org/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 0, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
622 
(156, 'http://www.sitechakra.com', 'http://www.sitechakra.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 2, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
623 
(157, 'http://www.webbacklinks.com', 'http://www.webbacklinks.com/submit.php', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 0, 0, -1, 'en', 1, 1, 0, 0, 0, 0, 0),
624 
(158, 'http://www.searchnsearch.com', 'http://www.searchnsearch.com/submit.php', 'captcha.php', 'index.php?search=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', 0, 1, 1, -1, 'en', 1, 1, 0, 0, 5.38, 29.48, 38.96);
625 
 
626 
CREATE TABLE IF NOT EXISTS `dirsubmitinfo` (
627 
  `id` bigint(24) unsigned NOT NULL AUTO_INCREMENT,
628 
  `website_id` int(11) unsigned NOT NULL,
629 
  `directory_id` int(11) unsigned NOT NULL,
630 
  `status` tinyint(1) NOT NULL DEFAULT '0',
631 
  `active` tinyint(1) NOT NULL DEFAULT '0',
632 
  `submit_time` int(11) NOT NULL,
633 
  PRIMARY KEY (`id`)
634 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
635 
 
636 
CREATE TABLE IF NOT EXISTS `di_directory_meta` (
637 
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
638 
  `name` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
639 
  `captcha_script` varchar(100) CHARACTER SET latin1 NOT NULL DEFAULT 'captcha.php',
640 
  `search_script` varchar(100) CHARACTER SET latin1 NOT NULL DEFAULT 'index.php?q=[--keyword--]',
641 
  `title_col` varchar(16) CHARACTER SET latin1 NOT NULL DEFAULT 'TITLE',
642 
  `url_col` varchar(16) CHARACTER SET latin1 NOT NULL DEFAULT 'URL',
643 
  `description_col` varchar(16) CHARACTER SET latin1 NOT NULL DEFAULT 'DESCRIPTION',
644 
  `name_col` varchar(16) CHARACTER SET latin1 NOT NULL DEFAULT 'OWNER_NAME',
645 
  `email_col` varchar(16) CHARACTER SET latin1 NOT NULL DEFAULT 'OWNER_EMAIL',
646 
  `category_col` varchar(16) CHARACTER SET latin1 NOT NULL DEFAULT 'CATEGORY_ID',
647 
  `cptcha_col` varchar(16) CHARACTER SET latin1 NOT NULL DEFAULT 'CAPTCHA',
648 
  `imagehash_col` varchar(16) CHARACTER SET latin1 NOT NULL DEFAULT 'IMAGEHASH',
649 
  `imagehashurl_col` varchar(16) CHARACTER SET latin1 NOT NULL DEFAULT 'imagehash',
650 
  `reciprocal_col` varchar(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'RECPR_URL',
651 
  `extra_val` varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT 'LINK_TYPE=normal&submit=Continue&AGREERULES=on',
652 
  `link_type_col` varchar(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'LINK_TYPE',
653 
  `normal` varchar(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'normal',
654 
  `free` varchar(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'free',
655 
  `reciprocal` varchar(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'reciprocal',
656 
  `status` tinyint(1) NOT NULL DEFAULT '0',
657 
  PRIMARY KEY (`id`)
658 
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;
659 
 
660 
INSERT INTO `di_directory_meta` (`id`, `name`, `captcha_script`, `search_script`, `title_col`, `url_col`, `description_col`, `name_col`, `email_col`, `category_col`, `cptcha_col`, `imagehash_col`, `imagehashurl_col`, `reciprocal_col`, `extra_val`, `link_type_col`, `normal`, `free`, `reciprocal`, `status`) VALUES
661 
(1, 'phpLD', 'captcha.php', 'index.php?q=[--keyword--]', 'TITLE', 'URL', 'DESCRIPTION', 'OWNER_NAME', 'OWNER_EMAIL', 'CATEGORY_ID', 'CAPTCHA', 'IMAGEHASH', 'imagehash', 'RECPR_URL', 'LINK_TYPE=[--type--]&submit=Continue&AGREERULES=on', 'LINK_TYPE', 'normal', 'free', 'reciprocal', 1);
662 
 
663 
CREATE TABLE IF NOT EXISTS `featured_directories` (
664 
  `id` int(11) NOT NULL AUTO_INCREMENT,
665 
  `directory_name` varchar(120) COLLATE utf8_unicode_ci NOT NULL,
666 
  `directory_link` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
667 
  `google_pagerank` smallint(6) NOT NULL DEFAULT '0',
668 
  `coupon_code` varchar(120) COLLATE utf8_unicode_ci NOT NULL,
669 
  `coupon_offer` float NOT NULL,
670 
  `status` tinyint(1) NOT NULL DEFAULT '0',
671 
  PRIMARY KEY (`id`)
672 
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=6 ;
673 
 
674 
INSERT INTO `featured_directories` (`id`, `directory_name`, `directory_link`, `google_pagerank`, `coupon_code`, `coupon_offer`, `status`) VALUES
675 
(1, 'directory.seopanel.in', 'http://directory.seofreetools.net/submit.php?LINK_TYPE=featured', 4, '', 0, 1),
676 
(4, 'beta-i.org', 'http://beta-i.org/submit.php?LINK_TYPE=4', 6, '', 0, 0),
677 
(5, 'directorymaximizer.com', 'http://www.directorymaximizer.com/af.php?af=207564&ad=5&p=1', 6, '', 0, 1);
678 
 
679 
CREATE TABLE IF NOT EXISTS `information_list` (
680 
  `id` int(11) NOT NULL AUTO_INCREMENT,
681 
  `info_type` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'news',
682 
  `content` text COLLATE utf8_unicode_ci NOT NULL,
683 
  `update_date` date NOT NULL,
684 
  PRIMARY KEY (`id`)
685 
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;
686 
 
687 
INSERT INTO `information_list` (`id`, `info_type`, `content`, `update_date`) VALUES
688 
(1, 'news', '	<a style="text-decoration: none" href="http://www.seopanel.in/aboutus/sponsors/" target="_blank" id=''news_info''>\n		<b style="color:red;">New*</b> <b>Donate</b> <b style="color: green">$500</b> \n		and become a <b>premium sponsor of Seo Panel</b>. Also get <b>all plugins</b> we develop for Free!\n	</a>\n	', '2016-12-16');
689 
 
690 
CREATE TABLE IF NOT EXISTS `keywordcrontracker` (
691 
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
692 
  `keyword_id` int(16) DEFAULT NULL,
693 
  `searchengine_id` int(11) DEFAULT NULL,
694 
  `time` int(11) DEFAULT NULL,
695 
  PRIMARY KEY (`id`),
696 
  KEY `keyword_id` (`keyword_id`),
697 
  KEY `searchengine_id` (`searchengine_id`),
698 
  KEY `time` (`time`)
699 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
700 
 
701 
CREATE TABLE IF NOT EXISTS `keywords` (
702 
  `id` bigint(24) unsigned NOT NULL AUTO_INCREMENT,
703 
  `name` varchar(120) COLLATE utf8_unicode_ci DEFAULT NULL,
704 
  `lang_code` varchar(8) COLLATE utf8_unicode_ci DEFAULT NULL,
705 
  `country_code` varchar(8) COLLATE utf8_unicode_ci DEFAULT NULL,
706 
  `website_id` int(11) DEFAULT NULL,
707 
  `searchengines` varchar(120) CHARACTER SET latin1 DEFAULT NULL,
708 
  `status` tinyint(1) DEFAULT '0',
709 
  `crawled` tinyint(1) NOT NULL DEFAULT '0',
710 
  PRIMARY KEY (`id`)
711 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
712 
 
713 
CREATE TABLE IF NOT EXISTS `keyword_analytics` (
714 
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
715 
  `keyword_id` int(11) NOT NULL,
716 
  `clicks` int(11) NOT NULL,
717 
  `impressions` int(11) NOT NULL,
718 
  `ctr` float NOT NULL,
719 
  `average_position` float NOT NULL,
720 
  `report_date` date NOT NULL,
721 
  `source` enum('google','yahoo','bing','baidu','yandex') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'google',
722 
  PRIMARY KEY (`id`),
723 
  KEY `keyword_id` (`keyword_id`)
724 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
725 
 
726 
CREATE TABLE IF NOT EXISTS `pagespeeddetails` (
727 
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
728 
  `website_id` int(11) NOT NULL,
729 
  `desktop_score_details` text COLLATE utf8_unicode_ci NOT NULL,
730 
  `mobile_score_details` text COLLATE utf8_unicode_ci NOT NULL,
731 
  `result_date` date NOT NULL,
732 
  PRIMARY KEY (`id`),
733 
  KEY `result_date` (`result_date`)
734 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
735 
 
736 
CREATE TABLE IF NOT EXISTS `pagespeedresults` (
737 
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
738 
  `website_id` int(11) NOT NULL,
739 
  `desktop_speed_score` smallint(6) NOT NULL,
740 
  `mobile_speed_score` smallint(6) NOT NULL,
741 
  `mobile_usability_score` smallint(6) NOT NULL,
742 
  `result_date` date NOT NULL,
743 
  PRIMARY KEY (`id`),
744 
  KEY `result_date` (`result_date`)
745 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
746 
 
747 
CREATE TABLE IF NOT EXISTS `proxylist` (
748 
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
749 
  `proxy` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
750 
  `port` int(8) DEFAULT NULL,
751 
  `proxy_auth` tinyint(1) NOT NULL DEFAULT '0',
752 
  `proxy_username` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
753 
  `proxy_password` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
754 
  `status` tinyint(1) NOT NULL DEFAULT '0',
755 
  `checked` tinyint(1) NOT NULL DEFAULT '0',
756 
  PRIMARY KEY (`id`)
757 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
758 
 
759 
CREATE TABLE IF NOT EXISTS `qwp_settings` (
760 
  `id` int(11) NOT NULL AUTO_INCREMENT,
761 
  `set_label` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
762 
  `set_name` varchar(64) CHARACTER SET latin1 NOT NULL,
763 
  `set_val` text COLLATE utf8_unicode_ci NOT NULL,
764 
  `set_type` enum('small','bool','medium','large','text') CHARACTER SET latin1 DEFAULT 'small',
765 
  PRIMARY KEY (`id`),
766 
  UNIQUE KEY `set_name` (`set_name`)
767 
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ;
768 
 
769 
INSERT INTO `qwp_settings` (`id`, `set_label`, `set_name`, `set_val`, `set_type`) VALUES
770 
(2, 'Allow user to access the web proxy', 'QWP_ALLOW_USER_WEB_PROXY', '0', 'bool'),
771 
(3, 'Allow web server to act as a proxy', 'QWP_ALLOW_WEB_SERVER_ACT_AS_PROXY', '1', 'bool');
772 
 
773 
CREATE TABLE IF NOT EXISTS `rankresults` (
774 
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
775 
  `website_id` int(11) NOT NULL,
776 
  `google_pagerank` int(8) NOT NULL DEFAULT '0',
777 
  `alexa_rank` int(11) NOT NULL,
778 
  `moz_rank` float NOT NULL,
779 
  `result_time` int(11) NOT NULL DEFAULT '0',
780 
  `domain_authority` float NOT NULL,
781 
  `page_authority` float NOT NULL,
782 
  `result_date` date DEFAULT NULL,
783 
  PRIMARY KEY (`id`),
784 
  KEY `result_date` (`result_date`)
785 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
786 
 
787 
CREATE TABLE IF NOT EXISTS `reports_settings` (
788 
  `id` int(11) NOT NULL AUTO_INCREMENT,
789 
  `user_id` int(11) NOT NULL,
790 
  `report_interval` int(11) NOT NULL DEFAULT '1',
791 
  `email_notification` tinyint(1) NOT NULL DEFAULT '0',
792 
  `last_generated` int(11) NOT NULL,
793 
  PRIMARY KEY (`id`),
794 
  UNIQUE KEY `user_id` (`user_id`)
795 
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;
796 
 
797 
INSERT INTO `reports_settings` (`id`, `user_id`, `report_interval`, `email_notification`, `last_generated`) VALUES
798 
(1, 1, 1, 1, 1481760000);
799 
 
800 
CREATE TABLE IF NOT EXISTS `review_links` (
801 
  `id` int(11) NOT NULL AUTO_INCREMENT,
802 
  `website_id` int(11) NOT NULL,
803 
  `name` varchar(120) COLLATE utf8_unicode_ci NOT NULL,
804 
  `url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
805 
  `type` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'google_my_business',
806 
  `status` tinyint(1) NOT NULL DEFAULT '1',
807 
  PRIMARY KEY (`id`),
808 
  UNIQUE KEY `website_id` (`website_id`,`url`),
809 
  KEY `review_links_web_rel` (`website_id`)
810 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
811 
 
812 
CREATE TABLE IF NOT EXISTS `review_link_results` (
813 
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
814 
  `review_link_id` int(11) NOT NULL,
815 
  `reviews` int(11) NOT NULL DEFAULT '0',
816 
  `rating` float NOT NULL DEFAULT '0',
817 
  `report_date` date NOT NULL,
818 
  PRIMARY KEY (`id`),
819 
  KEY `review_link_rel` (`review_link_id`)
820 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
821 
 
822 
CREATE TABLE IF NOT EXISTS `saturationresults` (
823 
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
824 
  `website_id` int(11) NOT NULL,
825 
  `google` int(11) NOT NULL,
826 
  `msn` int(11) NOT NULL,
827 
  `result_time` int(11) NOT NULL DEFAULT '0',
828 
  `result_date` date DEFAULT NULL,
829 
  PRIMARY KEY (`id`),
830 
  KEY `result_date` (`result_date`)
831 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
832 
 
833 
CREATE TABLE IF NOT EXISTS `searchengines` (
834 
  `id` int(11) NOT NULL AUTO_INCREMENT,
835 
  `domain` varchar(120) COLLATE utf8_unicode_ci DEFAULT NULL,
836 
  `url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
837 
  `cookie_send` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
838 
  `no_of_results_page` int(8) DEFAULT NULL,
839 
  `start` int(11) NOT NULL DEFAULT '0',
840 
  `start_offset` int(8) NOT NULL DEFAULT '0',
841 
  `max_results` int(11) NOT NULL DEFAULT '100',
842 
  `regex` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
843 
  `from_pattern` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
844 
  `to_pattern` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
845 
  `url_index` int(11) NOT NULL DEFAULT '1',
846 
  `title_index` int(11) NOT NULL DEFAULT '2',
847 
  `description_index` int(11) NOT NULL DEFAULT '3',
848 
  `encoding` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
849 
  `status` tinyint(1) DEFAULT '0',
850 
  PRIMARY KEY (`id`)
851 
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ;
852 
 
853 
INSERT INTO `searchengines` (`id`, `domain`, `url`, `cookie_send`, `no_of_results_page`, `start`, `start_offset`, `max_results`, `regex`, `from_pattern`, `to_pattern`, `url_index`, `title_index`, `description_index`, `encoding`, `status`) VALUES
854 
(1, 'www.google.com', 'http://www.google.com/search?hl=[--lang--]&num=[--num--]&q=[--keyword--]&start=[--start--]&cr=country[--country--]&as_qdr=all&gws_rd=cr&nfpr=1', '', 100, 0, 100, 100, '<div.*?class="?g.*?>.*?<div.*?class="r"*?>.*?<a href="(.*?)".*?>.*?<span.*?>(.*?)<\\/span><\\/h3>', '<div id="?ires"?>', '<\\/ol>', 1, 2, 3, NULL, 1),
855 
(2, 'www.yahoo.com', 'http://search.yahoo.com/search?p=[--keyword--]&n=[--num--]&b=[--start--]&vl=lang_[--lang--]&fl=1&v=1&vc=[--country--]', 'sB=v=1&n=100&sh=1&rw=new', 100, 1, 100, 100, '<li.*?<h3.*?><a.*?RU=(.*?)\\/.*?>(.*?)<\\/a><\\/h3>.*?<p.*?>(.*?)<\\/p>', NULL, NULL, 1, 2, 3, NULL, 1),
856 
(3, 'www.bing.com', 'http://www.bing.com/search?q=[--keyword--]&scope=web&first=[--start--]&setmkt=[--lang--]-[--country--]', 'SRCHHPGUSR=NEWWND=0&NRSLT=50&SRCHLANG=[--lang--]', 50, 1, 50, 50, '<li.*?<h2><a.*?href="(.*?)".*?>(.*?)<\\/a><\\/h2>.*?<p.*?>(.*?)<\\/p>', NULL, NULL, 1, 2, 3, NULL, 1);
857 
 
858 
CREATE TABLE IF NOT EXISTS `searchresultdetails` (
859 
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
860 
  `searchresult_id` bigint(24) unsigned DEFAULT NULL,
861 
  `url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
862 
  `title` varchar(160) COLLATE utf8_unicode_ci DEFAULT NULL,
863 
  `description` text COLLATE utf8_unicode_ci,
864 
  PRIMARY KEY (`id`)
865 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
866 
 
867 
CREATE TABLE IF NOT EXISTS `searchresults` (
868 
  `id` bigint(24) unsigned NOT NULL AUTO_INCREMENT,
869 
  `keyword_id` int(16) DEFAULT NULL,
870 
  `searchengine_id` int(11) DEFAULT NULL,
871 
  `rank` int(8) DEFAULT NULL,
872 
  `time` int(11) DEFAULT NULL,
873 
  `result_date` date DEFAULT NULL,
874 
  PRIMARY KEY (`id`),
875 
  KEY `result_date` (`result_date`)
876 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
877 
 
878 
CREATE TABLE IF NOT EXISTS `seoplugins` (
879 
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
880 
  `label` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
881 
  `name` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
882 
  `author` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
883 
  `description` text COLLATE utf8_unicode_ci,
884 
  `version` varchar(8) COLLATE utf8_unicode_ci DEFAULT NULL,
885 
  `website` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
886 
  `status` tinyint(1) NOT NULL DEFAULT '0',
887 
  `installed` tinyint(1) NOT NULL DEFAULT '0',
888 
  `priority` int(11) NOT NULL DEFAULT '100',
889 
  PRIMARY KEY (`id`)
890 
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ;
891 
 
892 
INSERT INTO `seoplugins` (`id`, `label`, `name`, `author`, `description`, `version`, `website`, `status`, `installed`, `priority`) VALUES
893 
(1, 'Meta Tag Generator', 'MetaTagGenerator', 'Geo Varghese', 'Meta Tag Generator', '1.0.0', 'http://www.seopanel.in/plugins/', 1, 1, 100),
894 
(2, 'Test Plugin', 'TestPlugin', 'Geo Varghese', 'Seo Panel Test Plugin: Check the structure of test plugin and it will help you to create new Seo Panel Plugins.', '1.0.0', 'http://www.seopanel.in/plugins/', 0, 1, 100),
895 
(3, 'Quick Web Proxy', 'QuickWebProxy', 'Seo Panel', 'It will help you to create a web proxy server using your hosting server or external proxy servers', '1.0.0', 'https://www.seopanel.in/plugin/l/94/quick-web-proxy/', 1, 1, 100);
896 
 
897 
CREATE TABLE IF NOT EXISTS `seotools` (
898 
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
899 
  `name` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
900 
  `url_section` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
901 
  `user_access` tinyint(1) NOT NULL DEFAULT '1',
902 
  `reportgen` tinyint(1) NOT NULL DEFAULT '1',
903 
  `cron` tinyint(1) NOT NULL DEFAULT '0',
904 
  `priority` int(11) NOT NULL DEFAULT '100',
905 
  `status` tinyint(1) NOT NULL DEFAULT '0',
906 
  PRIMARY KEY (`id`)
907 
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=12 ;
908 
 
909 
INSERT INTO `seotools` (`id`, `name`, `url_section`, `user_access`, `reportgen`, `cron`, `priority`, `status`) VALUES
910 
(1, 'Keyword Position Checker', 'keyword-position-checker', 1, 1, 1, 10, 1),
911 
(2, 'Site Auditor', 'site-auditor', 1, 1, 0, 100, 1),
912 
(3, 'Rank Checker', 'rank-checker', 1, 1, 1, 100, 1),
913 
(4, 'Backlinks Checker', 'backlink-checker', 1, 1, 1, 100, 1),
914 
(5, 'Directory Submission', 'directory-submission', 1, 1, 0, 100, 1),
915 
(6, 'Search Engine Saturation', 'saturation-checker', 1, 1, 1, 100, 1),
916 
(7, 'PageSpeed Insights', 'pagespeed', 1, 1, 1, 100, 1),
917 
(8, 'Webmaster Tools', 'webmaster-tools', 1, 1, 1, 20, 1),
918 
(9, 'Social Media Checker', 'sm-checker', 1, 1, 1, 100, 1),
919 
(10, 'Website Analytics', 'web-analytics', 1, 1, 1, 100, 1),
920 
(11, 'Review Manager', 'review-manager', 1, 1, 1, 100, 1);
921 
 
922 
CREATE TABLE IF NOT EXISTS `settings` (
923 
  `id` int(11) NOT NULL AUTO_INCREMENT,
924 
  `set_label` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
925 
  `set_name` varchar(64) CHARACTER SET latin1 NOT NULL,
926 
  `set_val` text COLLATE utf8_unicode_ci NOT NULL,
927 
  `set_category` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'system',
928 
  `set_type` enum('small','bool','medium','large','text') CHARACTER SET latin1 DEFAULT 'small',
929 
  `display` tinyint(1) NOT NULL DEFAULT '1',
930 
  PRIMARY KEY (`id`),
931 
  UNIQUE KEY `set_name` (`set_name`)
932 
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=57 ;
933 
 
934 
INSERT INTO `settings` (`id`, `set_label`, `set_name`, `set_val`, `set_category`, `set_type`, `display`) VALUES
935 
(1, 'Seo Panel Title', 'SP_TITLE', 'Seo Panel: World''s first open source seo control panel for managing multiple web sites', 'system', 'large', 1),
936 
(2, 'Seo Panel Description', 'SP_DESCRIPTION', 'A complete free control panel for managing search engine optimization of your websites. It\ncontaining lots of hot seo tools to increase and track the performance your websites. Its an open\nsource software and also you can develop your own seo plugins for seo panel.', 'system', 'text', 1),
937 
(3, 'Seo Panel Keywords', 'SP_KEYWORDS', 'Seo Panel,seo control panel,search engine optimization panel,seo tools kit,keyword rank checker,google pagerank checker,alexa rank checker,sitemap generator,meta tag generator,back link checker,Website Submission tool', 'system', 'text', 1),
938 
(4, 'Number of entries per page', 'SP_PAGINGNO', '10', 'system', 'small', 1),
939 
(5, 'Delay between each spider crawl(seconds)', 'SP_CRAWL_DELAY', '5', 'report', 'small', 1),
940 
(6, 'Allow user to generate reports', 'SP_USER_GEN_REPORT', '0', 'report', 'bool', 1),
941 
(7, 'Image hotlink protection enabled', 'SP_HOTLINKING', '1', 'system', 'bool', 0),
942 
(8, 'User registration interface', 'SP_USER_REGISTRATION', '0', 'system', 'bool', 1),
943 
(9, 'Enable Proxy', 'SP_ENABLE_PROXY', '0', 'proxy', 'bool', 1),
944 
(10, 'Default Language', 'SP_DEFAULTLANG', 'en', 'system', 'small', 1),
945 
(11, 'User agent', 'SP_USER_AGENT', 'Mozilla/5.0 (Windows; U; MSIE 9.0; WIndows NT 9.0; en-US))', 'report', 'large', 1),
946 
(12, 'Seo Panel API Key', 'SP_API_KEY', '11a9b9070c7d7633831f603f0454ef5b', 'api', 'large', 1),
947 
(13, 'Maximum number of pages allowed per website', 'SA_MAX_NO_PAGES', '500', 'siteauditor', 'small', 1),
948 
(14, 'Site auditor crawl delay', 'SA_CRAWL_DELAY_TIME', '20', 'siteauditor', 'small', 1),
949 
(15, 'Maximum length of page title', 'SA_TITLE_MAX_LENGTH', '80', 'siteauditor', 'small', 0),
950 
(16, 'Minimum length of page title', 'SA_TITLE_MIN_LENGTH', '50', 'siteauditor', 'small', 0),
951 
(17, 'Maximum length of meta description', 'SA_DES_MAX_LENGTH', '200', 'siteauditor', 'small', 0),
952 
(18, 'Minimumlength of meta description', 'SA_DES_MIN_LENGTH', '120', 'siteauditor', 'small', 0),
953 
(19, 'Maximum length of meta keywords', 'SA_KEY_MAX_LENGTH', '200', 'siteauditor', 'small', 0),
954 
(20, 'Minimumlength of meta keyword', 'SA_KEY_MIN_LENGTH', '80', 'siteauditor', 'small', 0),
955 
(21, 'Google pagerank check level first', 'SA_PR_CHECK_LEVEL_FIRST', '3', 'siteauditor', 'small', 0),
956 
(22, 'Backlinks check level', 'SA_BL_CHECK_LEVEL', '25', 'siteauditor', 'small', 0),
957 
(23, 'Google pagerank check level second', 'SA_PR_CHECK_LEVEL_SECOND', '6', 'siteauditor', 'small', 0),
958 
(24, 'Maximum links in a page', 'SA_TOTAL_LINKS_MAX', '50', 'siteauditor', 'small', 0),
959 
(25, 'Enable SMTP', 'SP_SMTP_MAIL', '0', 'system', 'bool', 1),
960 
(26, 'SMTP Host', 'SP_SMTP_HOST', '', 'system', 'medium', 1),
961 
(27, 'SMTP Username', 'SP_SMTP_USERNAME', '', 'system', 'medium', 1),
962 
(28, 'SMTP Password', 'SP_SMTP_PASSWORD', '', 'system', 'medium', 1),
963 
(29, 'Allow users to schedule reports', 'SP_ALLOW_USER_SCHEDULE_REPORT', '1', 'report', 'bool', 1),
964 
(30, 'System report generation interval', 'SP_SYSTEM_REPORT_INTERVAL', '1', 'report', 'small', 1),
965 
(31, 'Enable report email notification', 'SP_REPORT_EMAIL_NOTIFICATION', '1', 'report', 'bool', 1),
966 
(32, 'Number of keywords needs to be checked in each cron execution', 'SP_NUMBER_KEYWORDS_CRON', '1', 'report', 'small', 0),
967 
(33, 'Crawl relative links in a page', 'SP_RELATIVE_LINK_CRAWL', '1', 'siteauditor', 'bool', 1),
968 
(34, 'Enable HTTP Proxy Tunnel', 'CURLOPT_HTTPPROXYTUNNEL_VAL', '1', 'proxy', 'bool', 1),
969 
(35, 'Deactivate Proxy When Crawling Failed', 'PROXY_DEACTIVATE_CRAWL', '0', 'proxy', 'bool', 1),
970 
(36, 'Check With Another Proxy When Crawling Failed', 'CHECK_WITH_ANOTHER_PROXY_IF_FAILED', '0', 'proxy', 'bool', 1),
971 
(37, 'SMTP Mail Port', 'SP_SMTP_PORT', '25', 'system', 'small', 1),
972 
(38, 'Time Zone', 'SP_TIME_ZONE', 'Europe/London', 'system', 'medium', 1),
973 
(39, 'Maximum number of proxies used in single execution', 'CHECK_MAX_PROXY_COUNT_IF_FAILED', '3', 'proxy', 'small', 1),
974 
(40, 'API Secret', 'API_SECRET', '', 'api', 'medium', 1),
975 
(41, 'Company Name', 'SP_COMPANY_NAME', 'Seo Panel', 'system', 'medium', 1),
976 
(42, 'Currency', 'SP_PAYMENT_CURRENCY', 'USD', 'system', 'medium', 1),
977 
(43, 'Seo Panel version', 'SP_VERSION_NUMBER', '4.5.0', 'system', 'medium', 0),
978 
(44, 'Moz API Link', 'SP_MOZ_API_LINK', 'http://lsapi.seomoz.com/linkscape', 'moz', 'medium', 0),
979 
(45, 'Moz API Link', 'SP_MOZ_API_ACCESS_ID', '', 'moz', 'large', 1),
980 
(46, 'Moz API Link', 'SP_MOZ_API_SECRET', '', 'moz', 'large', 1),
981 
(47, 'Page authority check level first', 'SA_PA_CHECK_LEVEL_FIRST', '40', 'siteauditor', 'small', 0),
982 
(48, 'Page authority check level second', 'SA_PA_CHECK_LEVEL_SECOND', '75', 'siteauditor', 'small', 0),
983 
(49, 'Google API Key', 'SP_GOOGLE_API_KEY', '', 'google', 'large', 1),
984 
(50, 'Number of websites needs to be checked in each cron execution', 'SP_NUMBER_WEBSITES_CRON', '1', 'report', 'small', 0),
985 
(51, 'Send custom header with curl request', 'SP_SEND_CUSTOM_HEADER_IN_CURL', '1', 'report', 'bool', 1),
986 
(52, 'Google API Client Id', 'SP_GOOGLE_API_CLIENT_ID', '', 'google', 'large', 1),
987 
(53, 'Google API Client Secret', 'SP_GOOGLE_API_CLIENT_SECRET', '', 'google', 'large', 1),
988 
(54, 'Google Analytics Tracking Code', 'SP_GOOGLE_ANALYTICS_TRACK_CODE', '', 'google', 'text', 1),
989 
(55, 'Enable Proxy for Google API', 'SP_ENABLE_PROXY_GOOGLE_API', '1', 'proxy', 'bool', 1),
990 
(56, 'Mail Encryption', 'SP_MAIL_ENCRYPTION', '', 'system', 'medium', 1);
991 
 
992 
CREATE TABLE IF NOT EXISTS `skipdirectories` (
993 
  `id` int(11) NOT NULL AUTO_INCREMENT,
994 
  `website_id` int(11) NOT NULL,
995 
  `directory_id` int(11) NOT NULL,
996 
  PRIMARY KEY (`id`),
997 
  UNIQUE KEY `website_id` (`website_id`,`directory_id`)
998 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
999 
 
1000 
CREATE TABLE IF NOT EXISTS `social_media_links` (
1001 
  `id` int(11) NOT NULL AUTO_INCREMENT,
1002 
  `website_id` int(11) NOT NULL,
1003 
  `name` varchar(120) COLLATE utf8_unicode_ci NOT NULL,
1004 
  `url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
1005 
  `type` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'facebook',
1006 
  `status` tinyint(1) NOT NULL DEFAULT '1',
1007 
  PRIMARY KEY (`id`),
1008 
  UNIQUE KEY `website_id` (`website_id`,`url`),
1009 
  KEY `social_media_links_web_rel` (`website_id`)
1010 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
1011 
 
1012 
CREATE TABLE IF NOT EXISTS `social_media_link_results` (
1013 
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
1014 
  `sm_link_id` int(11) NOT NULL,
1015 
  `likes` int(11) NOT NULL DEFAULT '0',
1016 
  `followers` int(11) NOT NULL DEFAULT '0',
1017 
  `report_date` date NOT NULL,
1018 
  PRIMARY KEY (`id`),
1019 
  KEY `social_media_link_rel` (`sm_link_id`)
1020 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
1021 
 
1022 
CREATE TABLE IF NOT EXISTS `testplugin` (
1023 
  `id` int(11) NOT NULL AUTO_INCREMENT,
1024 
  `title` varchar(64) CHARACTER SET latin1 NOT NULL,
1025 
  `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
1026 
  `status` tinyint(1) NOT NULL DEFAULT '0',
1027 
  PRIMARY KEY (`id`)
1028 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
1029 
 
1030 
CREATE TABLE IF NOT EXISTS `themes` (
1031 
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
1032 
  `name` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
1033 
  `folder` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
1034 
  `author` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
1035 
  `description` text COLLATE utf8_unicode_ci,
1036 
  `version` varchar(8) COLLATE utf8_unicode_ci DEFAULT NULL,
1037 
  `website` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
1038 
  `status` tinyint(1) NOT NULL DEFAULT '0',
1039 
  `installed` tinyint(1) NOT NULL DEFAULT '0',
1040 
  PRIMARY KEY (`id`)
1041 
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;
1042 
 
1043 
INSERT INTO `themes` (`id`, `name`, `folder`, `author`, `description`, `version`, `website`, `status`, `installed`) VALUES
1044 
(1, 'Classic', 'classic', 'Geo Varghese', 'Classic theme of Seo Panel', '1.0.0', 'http://www.seopanel.in/theme/l/1/classic/', 1, 1),
1045 
(2, 'Simple', 'simple', 'Geo Varghese', 'Simple theme of Seo Panel', '1.0.0', 'http://www.seopanel.in/theme/l/2/simple/', 0, 1);
1046 
 
1047 
CREATE TABLE IF NOT EXISTS `timezone` (
1048 
  `id` int(11) NOT NULL AUTO_INCREMENT,
1049 
  `timezone_name` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
1050 
  `timezone_label` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
1051 
  `gmt_diff` varchar(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT '+00.00',
1052 
  PRIMARY KEY (`id`)
1053 
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=91 ;
1054 
 
1055 
INSERT INTO `timezone` (`id`, `timezone_name`, `timezone_label`, `gmt_diff`) VALUES
1056 
(1, 'Pacific/Midway', '(GMT-11:00) Midway Island, Samoa', '-11:00'),
1057 
(2, 'America/Adak', '(GMT-10:00) Hawaii-Aleutian', '-10:00'),
1058 
(3, 'Etc/GMT+10', '(GMT-10:00) Hawaii', '-10:00'),
1059 
(4, 'Pacific/Marquesas', '(GMT-09:30) Marquesas Islands', '-09:30'),
1060 
(5, 'Pacific/Gambier', '(GMT-09:00) Gambier Islands', '-09:00'),
1061 
(6, 'America/Anchorage', '(GMT-09:00) Alaska', '-09:00'),
1062 
(7, 'America/Ensenada', '(GMT-08:00) Tijuana, Baja California', '-08:00'),
1063 
(8, 'Etc/GMT+8', '(GMT-08:00) Pitcairn Islands', '-08:00'),
1064 
(9, 'America/Los_Angeles', '(GMT-08:00) Pacific Time (US & Canada)', '-08:00'),
1065 
(10, 'America/Denver', '(GMT-07:00) Mountain Time (US & Canada)', '-07:00'),
1066 
(11, 'America/Chihuahua', '(GMT-07:00) Chihuahua, La Paz, Mazatlan', '-07:00'),
1067 
(12, 'America/Dawson_Creek', '(GMT-07:00) Arizona', '-07:00'),
1068 
(13, 'America/Belize', '(GMT-06:00) Saskatchewan, Central America', '-06:00'),
1069 
(14, 'America/Cancun', '(GMT-06:00) Guadalajara, Mexico City, Monterrey', '-06:00'),
1070 
(15, 'Chile/EasterIsland', '(GMT-06:00) Easter Island', '-06:00'),
1071 
(16, 'America/Chicago', '(GMT-06:00) Central Time (US & Canada)', '-06:00'),
1072 
(17, 'America/New_York', '(GMT-05:00) Eastern Time (US & Canada)', '-05:00'),
1073 
(18, 'America/Havana', '(GMT-05:00) Cuba', '-05:00'),
1074 
(19, 'America/Bogota', '(GMT-05:00) Bogota, Lima, Quito, Rio Branco', '-05:00'),
1075 
(20, 'America/Caracas', '(GMT-04:30) Caracas', '-04:30'),
1076 
(21, 'America/Santiago', '(GMT-04:00) Santiago', '-04:00'),
1077 
(22, 'America/La_Paz', '(GMT-04:00) La Paz', '-04:00'),
1078 
(23, 'Atlantic/Stanley', '(GMT-04:00) Faukland Islands', '-04:00'),
1079 
(24, 'America/Campo_Grande', '(GMT-04:00) Brazil', '-04:00'),
1080 
(25, 'America/Goose_Bay', '(GMT-04:00) Atlantic Time (Goose Bay)', '-04:00'),
1081 
(26, 'America/Glace_Bay', '(GMT-04:00) Atlantic Time (Canada)', '-04:00'),
1082 
(27, 'America/St_Johns', '(GMT-03:30) Newfoundland', '-03:30'),
1083 
(28, 'America/Araguaina', '(GMT-03:00) UTC-3', '-03:00'),
1084 
(29, 'America/Montevideo', '(GMT-03:00) Montevideo', '-03:00'),
1085 
(30, 'America/Miquelon', '(GMT-03:00) Miquelon, St. Pierre', '-03:00'),
1086 
(31, 'America/Godthab', '(GMT-03:00) Greenland', '-03:00'),
1087 
(32, 'America/Argentina/Buenos_Aires', '(GMT-03:00) Buenos Aires', '-03:00'),
1088 
(33, 'America/Sao_Paulo', '(GMT-03:00) Brasilia', '-03:00'),
1089 
(34, 'America/Noronha', '(GMT-02:00) Mid-Atlantic', '-02:00'),
1090 
(35, 'Atlantic/Cape_Verde', '(GMT-01:00) Cape Verde Is.', '-01:00'),
1091 
(36, 'Atlantic/Azores', '(GMT-01:00) Azores', '-01:00'),
1092 
(37, 'Europe/Belfast', '(GMT) Greenwich Mean Time : Belfast', '+00:00'),
1093 
(38, 'Europe/Dublin', '(GMT) Greenwich Mean Time : Dublin', '+00:00'),
1094 
(39, 'Europe/Lisbon', '(GMT) Greenwich Mean Time : Lisbon', '+00:00'),
1095 
(40, 'Europe/London', '(GMT) Greenwich Mean Time : London', '+00:00'),
1096 
(41, 'Africa/Abidjan', '(GMT) Monrovia, Reykjavik', '+00:00'),
1097 
(42, 'Europe/Berlin', '(GMT+01:00) Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna', '+01:00'),
1098 
(43, 'Europe/Belgrade', '(GMT+01:00) Belgrade, Bratislava, Budapest, Ljubljana, Prague', '+01:00'),
1099 
(44, 'Europe/Brussels', '(GMT+01:00) Brussels, Copenhagen, Madrid, Paris', '+01:00'),
1100 
(45, 'Africa/Algiers', '(GMT+01:00) West Central Africa', '+01:00'),
1101 
(46, 'Africa/Windhoek', '(GMT+01:00) Windhoek', '+01:00'),
1102 
(47, 'Asia/Beirut', '(GMT+02:00) Beirut', '+02:00'),
1103 
(48, 'Africa/Cairo', '(GMT+02:00) Cairo', '+02:00'),
1104 
(49, 'Asia/Gaza', '(GMT+02:00) Gaza', '+02:00'),
1105 
(50, 'Africa/Blantyre', '(GMT+02:00) Harare, Pretoria', '+02:00'),
1106 
(51, 'Asia/Jerusalem', '(GMT+02:00) Jerusalem', '+02:00'),
1107 
(52, 'Europe/Minsk', '(GMT+02:00) Minsk', '+02:00'),
1108 
(53, 'Asia/Damascus', '(GMT+02:00) Syria', '+02:00'),
1109 
(54, 'Europe/Moscow', '(GMT+03:00) Moscow, St. Petersburg, Volgograd', '+03:00'),
1110 
(55, 'Africa/Addis_Ababa', '(GMT+03:00) Nairobi', '+03:00'),
1111 
(56, 'Asia/Tehran', '(GMT+03:30) Tehran', '+03:30'),
1112 
(57, 'Asia/Dubai', '(GMT+04:00) Abu Dhabi, Muscat', '+04:00'),
1113 
(58, 'Asia/Yerevan', '(GMT+04:00) Yerevan', '+04:00'),
1114 
(59, 'Asia/Kabul', '(GMT+04:30) Kabul', '+04:30'),
1115 
(60, 'Asia/Yekaterinburg', '(GMT+05:00) Ekaterinburg', '+05:00'),
1116 
(61, 'Asia/Tashkent', '(GMT+05:00) Tashkent', '+05:00'),
1117 
(62, 'Asia/Kolkata', '(GMT+05:30) Chennai, Kolkata, Mumbai, New Delhi', '+05:30'),
1118 
(63, 'Asia/Katmandu', '(GMT+05:45) Kathmandu', '+05:45'),
1119 
(64, 'Asia/Dhaka', '(GMT+06:00) Astana, Dhaka', '+06:00'),
1120 
(65, 'Asia/Novosibirsk', '(GMT+06:00) Novosibirsk', '+06:00'),
1121 
(66, 'Asia/Rangoon', '(GMT+06:30) Yangon (Rangoon)', '+06:30'),
1122 
(67, 'Asia/Bangkok', '(GMT+07:00) Bangkok, Hanoi, Jakarta', '+07:00'),
1123 
(68, 'Asia/Krasnoyarsk', '(GMT+07:00) Krasnoyarsk', '+07:00'),
1124 
(69, 'Asia/Hong_Kong', '(GMT+08:00) Beijing, Chongqing, Hong Kong, Urumqi', '+08:00'),
1125 
(70, 'Asia/Irkutsk', '(GMT+08:00) Irkutsk, Ulaan Bataar', '+08:00'),
1126 
(71, 'Australia/Perth', '(GMT+08:00) Perth', '+08:00'),
1127 
(72, 'Australia/Eucla', '(GMT+08:45) Eucla', '+08:45'),
1128 
(73, 'Asia/Tokyo', '(GMT+09:00) Osaka, Sapporo, Tokyo', '+09:00'),
1129 
(74, 'Asia/Seoul', '(GMT+09:00) Seoul', '+09:00'),
1130 
(75, 'Asia/Yakutsk', '(GMT+09:00) Yakutsk', '+09:00'),
1131 
(76, 'Australia/Adelaide', '(GMT+09:30) Adelaide', '+09:30'),
1132 
(77, 'Australia/Darwin', '(GMT+09:30) Darwin', '+09:30'),
1133 
(78, 'Australia/Brisbane', '(GMT+10:00) Brisbane', '+10:00'),
1134 
(79, 'Australia/Hobart', '(GMT+10:00) Hobart', '+10:00'),
1135 
(80, 'Asia/Vladivostok', '(GMT+10:00) Vladivostok', '+10:00'),
1136 
(81, 'Australia/Lord_Howe', '(GMT+10:30) Lord Howe Island', '+10:30'),
1137 
(82, 'Etc/GMT-11', '(GMT+11:00) Solomon Is., New Caledonia', '+11:00'),
1138 
(83, 'Asia/Magadan', '(GMT+11:00) Magadan', '+11:00'),
1139 
(84, 'Pacific/Norfolk', '(GMT+11:30) Norfolk Island', '+11:30'),
1140 
(85, 'Asia/Anadyr', '(GMT+12:00) Anadyr, Kamchatka', '+12:00'),
1141 
(86, 'Pacific/Auckland', '(GMT+12:00) Auckland, Wellington', '+12:00'),
1142 
(87, 'Etc/GMT-12', '(GMT+12:00) Fiji, Kamchatka, Marshall Is.', '+12:00'),
1143 
(88, 'Pacific/Chatham', '(GMT+12:45) Chatham Islands', '+12:45'),
1144 
(89, 'Pacific/Tongatapu', '(GMT+13:00) Nuku''alofa', '+13:00'),
1145 
(90, 'Pacific/Kiritimati', '(GMT+14:00) Kiritimati', '+14:00');
1146 
 
1147 
CREATE TABLE IF NOT EXISTS `users` (
1148 
  `id` int(11) NOT NULL AUTO_INCREMENT,
1149 
  `utype_id` int(11) DEFAULT NULL,
1150 
  `username` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
1151 
  `password` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
1152 
  `first_name` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
1153 
  `last_name` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
1154 
  `email` varchar(120) COLLATE utf8_unicode_ci DEFAULT NULL,
1155 
  `lang_code` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'en',
1156 
  `created` int(11) NOT NULL,
1157 
  `status` tinyint(4) DEFAULT '1',
1158 
  `expiry_date` date DEFAULT NULL,
1159 
  `confirm_code` varchar(120) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
1160 
  `confirm` tinyint(1) NOT NULL DEFAULT '0',
1161 
  PRIMARY KEY (`id`)
1162 
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;
1163 
 
1164 
INSERT INTO `users` (`id`, `utype_id`, `username`, `password`, `first_name`, `last_name`, `email`, `lang_code`, `created`, `status`, `expiry_date`, `confirm_code`, `confirm`) VALUES
1165 
(1, 1, 'spadmin', 'a4d312c461703c46a56b1bdcda9b5cdc', 'Seo Panel', 'Admin', '', 'en', 0, 1, NULL, '', 0);
1166 
 
1167 
CREATE TABLE IF NOT EXISTS `usertypes` (
1168 
  `id` int(8) NOT NULL AUTO_INCREMENT,
1169 
  `user_type` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL,
1170 
  `description` text COLLATE utf8_unicode_ci,
1171 
  `status` tinyint(4) DEFAULT '1',
1172 
  PRIMARY KEY (`id`)
1173 
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;
1174 
 
1175 
INSERT INTO `usertypes` (`id`, `user_type`, `description`, `status`) VALUES
1176 
(1, 'admin', 'Super User', 1),
1177 
(2, 'user', 'Normal User', 1);
1178 
 
1179 
CREATE TABLE IF NOT EXISTS `user_report_logs` (
1180 
  `id` int(11) NOT NULL AUTO_INCREMENT,
1181 
  `user_id` int(11) NOT NULL,
1182 
  `report_date` datetime NOT NULL,
1183 
  PRIMARY KEY (`id`),
1184 
  KEY `user_id` (`user_id`)
1185 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
1186 
 
1187 
CREATE TABLE IF NOT EXISTS `user_specs` (
1188 
  `id` int(11) NOT NULL AUTO_INCREMENT,
1189 
  `user_type_id` int(11) NOT NULL,
1190 
  `spec_column` varchar(120) COLLATE utf8_unicode_ci NOT NULL,
1191 
  `spec_value` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
1192 
  `spec_category` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'system',
1193 
  PRIMARY KEY (`id`),
1194 
  UNIQUE KEY `user_type_id` (`user_type_id`,`spec_column`)
1195 
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=19 ;
1196 
 
1197 
INSERT INTO `user_specs` (`id`, `user_type_id`, `spec_column`, `spec_value`, `spec_category`) VALUES
1198 
(1, 2, 'keywordcount', '50', 'system'),
1199 
(2, 2, 'websitecount', '10', 'system'),
1200 
(3, 2, 'price', '0', 'system'),
1201 
(4, 2, 'searchengine_count', '3', 'system'),
1202 
(5, 2, 'directory_submit_limit', '150', 'system'),
1203 
(6, 2, 'directory_submit_daily_limit', '100', 'system'),
1204 
(7, 2, 'site_auditor_max_page_limit', '500', 'system'),
1205 
(8, 2, 'plugin_1', '1', 'system'),
1206 
(9, 2, 'plugin_2', '1', 'system'),
1207 
(10, 2, 'plugin_3', '1', 'system'),
1208 
(11, 2, 'seotool_1', '1', 'system'),
1209 
(12, 2, 'seotool_2', '1', 'system'),
1210 
(13, 2, 'seotool_3', '1', 'system'),
1211 
(14, 2, 'seotool_4', '1', 'system'),
1212 
(15, 2, 'seotool_5', '1', 'system'),
1213 
(16, 2, 'seotool_6', '1', 'system'),
1214 
(17, 2, 'seotool_7', '1', 'system'),
1215 
(18, 2, 'seotool_8', '1', 'system');
1216 
 
1217 
CREATE TABLE IF NOT EXISTS `user_tokens` (
1218 
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
1219 
  `user_id` int(11) NOT NULL,
1220 
  `access_token` text COLLATE utf8_unicode_ci NOT NULL,
1221 
  `refresh_token` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
1222 
  `token_type` varchar(120) COLLATE utf8_unicode_ci NOT NULL,
1223 
  `expires_in` int(11) NOT NULL DEFAULT '3600' COMMENT 'seconds',
1224 
  `created` datetime NOT NULL,
1225 
  `token_category` enum('google','twitter','facebook','linkedin') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'google',
1226 
  PRIMARY KEY (`id`)
1227 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
1228 
 
1229 
CREATE TABLE IF NOT EXISTS `user_website_access` (
1230 
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
1231 
  `user_id` int(11) NOT NULL,
1232 
  `website_id` int(11) NOT NULL,
1233 
  `access` enum('read','write') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'read',
1234 
  PRIMARY KEY (`id`),
1235 
  UNIQUE KEY `user_id` (`user_id`,`website_id`),
1236 
  KEY `website_id_user_access_delete` (`website_id`)
1237 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
1238 
 
1239 
CREATE TABLE IF NOT EXISTS `webmaster_keywords` (
1240 
  `id` bigint(24) unsigned NOT NULL AUTO_INCREMENT,
1241 
  `name` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
1242 
  `website_id` int(11) DEFAULT NULL,
1243 
  `status` tinyint(1) DEFAULT '1',
1244 
  PRIMARY KEY (`id`),
1245 
  KEY `website_id` (`website_id`)
1246 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
1247 
 
1248 
CREATE TABLE IF NOT EXISTS `webmaster_sitemaps` (
1249 
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1250 
  `website_id` int(11) NOT NULL,
1251 
  `path` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
1252 
  `last_submitted` datetime NOT NULL,
1253 
  `last_downloaded` datetime NOT NULL,
1254 
  `is_pending` tinyint(4) NOT NULL DEFAULT '0',
1255 
  `warnings` int(11) NOT NULL DEFAULT '0',
1256 
  `errors` int(11) NOT NULL DEFAULT '0',
1257 
  `submitted` int(11) NOT NULL DEFAULT '0',
1258 
  `indexed` int(11) NOT NULL DEFAULT '0',
1259 
  `status` tinyint(4) NOT NULL DEFAULT '1',
1260 
  PRIMARY KEY (`id`),
1261 
  KEY `website_id` (`website_id`)
1262 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
1263 
 
1264 
CREATE TABLE IF NOT EXISTS `websites` (
1265 
  `id` int(11) NOT NULL AUTO_INCREMENT,
1266 
  `name` varchar(120) COLLATE utf8_unicode_ci DEFAULT NULL,
1267 
  `url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
1268 
  `owner_name` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
1269 
  `owner_email` varchar(120) COLLATE utf8_unicode_ci DEFAULT NULL,
1270 
  `category` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
1271 
  `title` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
1272 
  `description` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
1273 
  `keywords` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
1274 
  `title2` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
1275 
  `title3` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
1276 
  `title4` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
1277 
  `title5` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
1278 
  `description2` text COLLATE utf8_unicode_ci,
1279 
  `description3` text COLLATE utf8_unicode_ci,
1280 
  `description4` text COLLATE utf8_unicode_ci,
1281 
  `description5` text COLLATE utf8_unicode_ci,
1282 
  `reciprocal_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
1283 
  `user_id` int(11) DEFAULT NULL,
1284 
  `status` tinyint(1) NOT NULL,
1285 
  `crawled` tinyint(1) NOT NULL DEFAULT '0',
1286 
  `analytics_view_id` varchar(120) COLLATE utf8_unicode_ci DEFAULT NULL,
1287 
  PRIMARY KEY (`id`)
1288 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
1289 
 
1290 
CREATE TABLE IF NOT EXISTS `website_analytics` (
1291 
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1292 
  `website_id` int(11) NOT NULL,
1293 
  `source_id` bigint(20) NOT NULL,
1294 
  `users` int(11) NOT NULL,
1295 
  `newUsers` int(11) NOT NULL,
1296 
  `sessions` int(11) NOT NULL,
1297 
  `bounceRate` float NOT NULL,
1298 
  `avgSessionDuration` float NOT NULL,
1299 
  `goalCompletionsAll` int(11) NOT NULL,
1300 
  `report_date` date NOT NULL,
1301 
  PRIMARY KEY (`id`),
1302 
  KEY `website_analytics_delete` (`website_id`),
1303 
  KEY `source_analytics_delete` (`source_id`)
1304 
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;
1305 
 
1306 
CREATE TABLE IF NOT EXISTS `website_search_analytics` (
1307 
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
1308 
  `website_id` int(11) NOT NULL,
1309 
  `clicks` int(11) NOT NULL,
1310 
  `impressions` int(11) NOT NULL,
1311 
  `ctr` float NOT NULL,
1312 
  `average_position` float NOT NULL,
1313 
  `report_date` date NOT NULL,
1314 
  `source` enum('google','yahoo','bing','baidu','yandex') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'google',
1315 
  PRIMARY KEY (`id`),
1316 
  KEY `website_id` (`website_id`)
1317 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
1318 
 
1319 
 
1320 
ALTER TABLE `alerts`
1321 
  ADD CONSTRAINT `alert_user_delete` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;
1322 
 
1323 
ALTER TABLE `review_links`
1324 
  ADD CONSTRAINT `review_links_web_rel` FOREIGN KEY (`website_id`) REFERENCES `websites` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;
1325 
 
1326 
ALTER TABLE `review_link_results`
1327 
  ADD CONSTRAINT `review_link_rel` FOREIGN KEY (`review_link_id`) REFERENCES `review_links` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;
1328 
 
1329 
ALTER TABLE `social_media_links`
1330 
  ADD CONSTRAINT `social_media_links_web_rel` FOREIGN KEY (`website_id`) REFERENCES `websites` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;
1331 
 
1332 
ALTER TABLE `social_media_link_results`
1333 
  ADD CONSTRAINT `social_media_link_rel` FOREIGN KEY (`sm_link_id`) REFERENCES `social_media_links` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;
1334 
 
1335 
ALTER TABLE `user_website_access`
1336 
  ADD CONSTRAINT `website_id_user_access_delete` FOREIGN KEY (`website_id`) REFERENCES `websites` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
1337 
  ADD CONSTRAINT `user_id_website_access_delete` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;
1338 
 
1339 
ALTER TABLE `website_analytics`
1340 
  ADD CONSTRAINT `source_analytics_delete` FOREIGN KEY (`source_id`) REFERENCES `analytic_sources` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
1341 
  ADD CONSTRAINT `website_analytics_delete` FOREIGN KEY (`website_id`) REFERENCES `websites` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;
1342 
 
1343 
--
1344 
-- Seo Panel 4.3.0 changes
1345 
--
1346 
 
1347 
UPDATE `searchengines` SET `regex` = '<div.*?class="?g.*?>.*?<div.*?class="r"*?>.*?<a href="(.*?)".*?>.*?<h3.*?>(.*?)<\\/h3>' WHERE `url` LIKE '%google%';
1348 
 
1349 
CREATE TABLE `sync_searchengines` (
1350 
  `id` int(11) NOT NULL,
1351 
  `sync_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
1352 
  `status` tinyint(1) NOT NULL DEFAULT '0',
1353 
  `result` text COLLATE utf8_unicode_ci NOT NULL
1354 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1355 
 
1356 
ALTER TABLE `sync_searchengines` ADD PRIMARY KEY (`id`);
1357 
ALTER TABLE `sync_searchengines` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
1358 
 
1359 
 
1360 
INSERT INTO `settings` (`set_label`, `set_name`, `set_val`, `set_category`, `set_type`, `display`) VALUES
1361 
('Enable Sendgrid API', 'SP_SENDGRID_API', '0', 'mail', 'bool', 1);
1362 
 
1363 
update settings set set_category='mail' where
1364 
set_name in ('SP_SMTP_MAIL', 'SP_SMTP_HOST', 'SP_SMTP_USERNAME', 'SP_SMTP_PASSWORD', 'SP_SMTP_PORT', 'SP_MAIL_ENCRYPTION');
1365 
 
1366 
 
1367 
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1368 
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1369 
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;