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 */;