[0] Fix | Delete

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

[1] Fix | Delete

SET time_zone = "+00:00";

[2] Fix | Delete

[3] Fix | Delete

[4] Fix | Delete

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

[5] Fix | Delete

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

[6] Fix | Delete

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

[7] Fix | Delete

/*!40101 SET NAMES utf8 */;

[8] Fix | Delete

[9] Fix | Delete

--

[10] Fix | Delete

-- Database: `seo4100`

[11] Fix | Delete

--

[12] Fix | Delete

[13] Fix | Delete

-- --------------------------------------------------------

[14] Fix | Delete

[15] Fix | Delete

--

[16] Fix | Delete

-- Table structure for table `alerts`

[17] Fix | Delete

--

[18] Fix | Delete

[19] Fix | Delete

CREATE TABLE `alerts` (

[20] Fix | Delete

`id` bigint(20) NOT NULL AUTO_INCREMENT,

[21] Fix | Delete

`user_id` int(11) NOT NULL,

[22] Fix | Delete

`alert_subject` varchar(200) COLLATE utf8_unicode_ci NOT NULL,

[23] Fix | Delete

`alert_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,

[24] Fix | Delete

`alert_category` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'general',

[25] Fix | Delete

`alert_message` text COLLATE utf8_unicode_ci NOT NULL,

[26] Fix | Delete

`alert_type` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'success',

[27] Fix | Delete

`visited` tinyint(1) NOT NULL DEFAULT '0',

[28] Fix | Delete

`alert_time` datetime NOT NULL,

[29] Fix | Delete

PRIMARY KEY (`id`),

[30] Fix | Delete

KEY `alert_user_delete` (`user_id`)

[31] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

[32] Fix | Delete

[33] Fix | Delete

-- --------------------------------------------------------

[34] Fix | Delete

[35] Fix | Delete

--

[36] Fix | Delete

-- Table structure for table `analytic_sources`

[37] Fix | Delete

--

[38] Fix | Delete

[39] Fix | Delete

CREATE TABLE `analytic_sources` (

[40] Fix | Delete

`id` bigint(20) NOT NULL AUTO_INCREMENT,

[41] Fix | Delete

`source_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,

[42] Fix | Delete

PRIMARY KEY (`id`),

[43] Fix | Delete

UNIQUE KEY `source_name` (`source_name`)

[44] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

[45] Fix | Delete

[46] Fix | Delete

-- --------------------------------------------------------

[47] Fix | Delete

[48] Fix | Delete

--

[49] Fix | Delete

-- Table structure for table `auditorpagelinks`

[50] Fix | Delete

--

[51] Fix | Delete

[52] Fix | Delete

CREATE TABLE `auditorpagelinks` (

[53] Fix | Delete

`id` bigint(20) NOT NULL AUTO_INCREMENT,

[54] Fix | Delete

`report_id` bigint(20) NOT NULL,

[55] Fix | Delete

`link_url` varchar(200) COLLATE utf8_unicode_ci NOT NULL,

[56] Fix | Delete

`link_anchor` varchar(200) COLLATE utf8_unicode_ci NOT NULL,

[57] Fix | Delete

`link_title` varchar(200) COLLATE utf8_unicode_ci NOT NULL,

[58] Fix | Delete

`nofollow` tinyint(1) NOT NULL DEFAULT '0',

[59] Fix | Delete

`extrenal` tinyint(1) NOT NULL DEFAULT '0',

[60] Fix | Delete

`brocken` tinyint(1) NOT NULL DEFAULT '0',

[61] Fix | Delete

PRIMARY KEY (`id`),

[62] Fix | Delete

KEY `report_id` (`report_id`)

[63] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

[64] Fix | Delete

[65] Fix | Delete

-- --------------------------------------------------------

[66] Fix | Delete

[67] Fix | Delete

--

[68] Fix | Delete

-- Table structure for table `auditorprojects`

[69] Fix | Delete

--

[70] Fix | Delete

[71] Fix | Delete

CREATE TABLE `auditorprojects` (

[72] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[73] Fix | Delete

`website_id` int(11) NOT NULL,

[74] Fix | Delete

`max_links` int(11) NOT NULL DEFAULT '500',

[75] Fix | Delete

`exclude_links` text COLLATE utf8_unicode_ci NOT NULL,

[76] Fix | Delete

`check_pr` tinyint(1) NOT NULL DEFAULT '0',

[77] Fix | Delete

`check_backlinks` tinyint(1) NOT NULL DEFAULT '0',

[78] Fix | Delete

`check_indexed` tinyint(1) NOT NULL DEFAULT '0',

[79] Fix | Delete

`store_links_in_page` tinyint(1) NOT NULL DEFAULT '0',

[80] Fix | Delete

`check_brocken` tinyint(1) NOT NULL DEFAULT '0',

[81] Fix | Delete

`score` float NOT NULL DEFAULT '0',

[82] Fix | Delete

`cron` tinyint(1) NOT NULL DEFAULT '1',

[83] Fix | Delete

`status` tinyint(1) NOT NULL DEFAULT '1',

[84] Fix | Delete

PRIMARY KEY (`id`),

[85] Fix | Delete

KEY `website_id` (`website_id`)

[86] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

[87] Fix | Delete

[88] Fix | Delete

-- --------------------------------------------------------

[89] Fix | Delete

[90] Fix | Delete

--

[91] Fix | Delete

-- Table structure for table `auditorreports`

[92] Fix | Delete

--

[93] Fix | Delete

[94] Fix | Delete

CREATE TABLE `auditorreports` (

[95] Fix | Delete

`id` bigint(24) NOT NULL AUTO_INCREMENT,

[96] Fix | Delete

`project_id` int(11) NOT NULL,

[97] Fix | Delete

`page_url` varchar(200) COLLATE utf8_unicode_ci NOT NULL,

[98] Fix | Delete

`page_title` varchar(180) COLLATE utf8_unicode_ci DEFAULT NULL,

[99] Fix | Delete

`page_description` text COLLATE utf8_unicode_ci,

[100] Fix | Delete

`page_keywords` text COLLATE utf8_unicode_ci,

[101] Fix | Delete

`pagerank` float NOT NULL DEFAULT '0',

[102] Fix | Delete

`google_backlinks` int(11) NOT NULL DEFAULT '0',

[103] Fix | Delete

`bing_backlinks` int(11) NOT NULL DEFAULT '0',

[104] Fix | Delete

`google_indexed` int(11) NOT NULL DEFAULT '0',

[105] Fix | Delete

`bing_indexed` int(11) NOT NULL DEFAULT '0',

[106] Fix | Delete

`total_links` int(11) NOT NULL DEFAULT '0',

[107] Fix | Delete

`external_links` int(11) NOT NULL DEFAULT '0',

[108] Fix | Delete

`brocken` tinyint(1) NOT NULL DEFAULT '0',

[109] Fix | Delete

`crawled` tinyint(1) NOT NULL DEFAULT '0',

[110] Fix | Delete

`score` smallint(6) NOT NULL DEFAULT '0',

[111] Fix | Delete

`updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

[112] Fix | Delete

`page_authority` float NOT NULL DEFAULT '0',

[113] Fix | Delete

PRIMARY KEY (`id`),

[114] Fix | Delete

UNIQUE KEY `project_id_2` (`project_id`,`page_url`),

[115] Fix | Delete

KEY `project_id` (`project_id`)

[116] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

[117] Fix | Delete

[118] Fix | Delete

-- --------------------------------------------------------

[119] Fix | Delete

[120] Fix | Delete

--

[121] Fix | Delete

-- Table structure for table `backlinkresults`

[122] Fix | Delete

--

[123] Fix | Delete

[124] Fix | Delete

CREATE TABLE `backlinkresults` (

[125] Fix | Delete

`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,

[126] Fix | Delete

`website_id` int(11) NOT NULL,

[127] Fix | Delete

`google` int(11) NOT NULL,

[128] Fix | Delete

`msn` int(11) NOT NULL,

[129] Fix | Delete

`alexa` int(11) NOT NULL,

[130] Fix | Delete

`result_time` int(11) NOT NULL DEFAULT '0',

[131] Fix | Delete

`result_date` date DEFAULT NULL,

[132] Fix | Delete

PRIMARY KEY (`id`),

[133] Fix | Delete

KEY `result_date` (`result_date`)

[134] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

[135] Fix | Delete

[136] Fix | Delete

-- --------------------------------------------------------

[137] Fix | Delete

[138] Fix | Delete

--

[139] Fix | Delete

-- Table structure for table `country`

[140] Fix | Delete

--

[141] Fix | Delete

[142] Fix | Delete

CREATE TABLE `country` (

[143] Fix | Delete

`country_code` char(2) COLLATE utf8_unicode_ci NOT NULL,

[144] Fix | Delete

`country_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,

[145] Fix | Delete

PRIMARY KEY (`country_code`)

[146] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

[147] Fix | Delete

[148] Fix | Delete

--

[149] Fix | Delete

-- Dumping data for table `country`

[150] Fix | Delete

--

[151] Fix | Delete

[152] Fix | Delete

INSERT INTO `country` VALUES

[153] Fix | Delete

('AD', 'Andorra'),

[154] Fix | Delete

('AE', 'United Arab Emirates'),

[155] Fix | Delete

('AF', 'Afghanistan'),

[156] Fix | Delete

('AG', 'Antigua and Barbuda'),

[157] Fix | Delete

('AI', 'Anguilla'),

[158] Fix | Delete

('AL', 'Albania'),

[159] Fix | Delete

('AM', 'Armenia'),

[160] Fix | Delete

('AN', 'Netherlands Antilles'),

[161] Fix | Delete

('AO', 'Angola'),

[162] Fix | Delete

('AP', 'Asia/Pacific Region'),

[163] Fix | Delete

('AQ', 'Antarctica'),

[164] Fix | Delete

('AR', 'Argentina'),

[165] Fix | Delete

('AS', 'American Samoa'),

[166] Fix | Delete

('AT', 'Austria'),

[167] Fix | Delete

('AU', 'Australia'),

[168] Fix | Delete

('AW', 'Aruba'),

[169] Fix | Delete

('AX', 'Aland Islands'),

[170] Fix | Delete

('AZ', 'Azerbaijan'),

[171] Fix | Delete

('BA', 'Bosnia and Herzegovina'),

[172] Fix | Delete

('BB', 'Barbados'),

[173] Fix | Delete

('BD', 'Bangladesh'),

[174] Fix | Delete

('BE', 'Belgium'),

[175] Fix | Delete

('BF', 'Burkina Faso'),

[176] Fix | Delete

('BG', 'Bulgaria'),

[177] Fix | Delete

('BH', 'Bahrain'),

[178] Fix | Delete

('BI', 'Burundi'),

[179] Fix | Delete

('BJ', 'Benin'),

[180] Fix | Delete

('BM', 'Bermuda'),

[181] Fix | Delete

('BN', 'Brunei Darussalam'),

[182] Fix | Delete

('BO', 'Bolivia'),

[183] Fix | Delete

('BR', 'Brazil'),

[184] Fix | Delete

('BS', 'Bahamas'),

[185] Fix | Delete

('BT', 'Bhutan'),

[186] Fix | Delete

('BV', 'Bouvet Island'),

[187] Fix | Delete

('BW', 'Botswana'),

[188] Fix | Delete

('BY', 'Belarus'),

[189] Fix | Delete

('BZ', 'Belize'),

[190] Fix | Delete

('CA', 'Canada'),

[191] Fix | Delete

('CC', 'Cocos (Keeling) Islands'),

[192] Fix | Delete

('CD', 'Congo'),

[193] Fix | Delete

('CF', 'Central African Republic'),

[194] Fix | Delete

('CG', 'Congo'),

[195] Fix | Delete

('CH', 'Switzerland'),

[196] Fix | Delete

('CI', 'Cote d''Ivoire'),

[197] Fix | Delete

('CK', 'Cook Islands'),

[198] Fix | Delete

('CL', 'Chile'),

[199] Fix | Delete

('CM', 'Cameroon'),

[200] Fix | Delete

('CN', 'China'),

[201] Fix | Delete

('CO', 'Colombia'),

[202] Fix | Delete

('CR', 'Costa Rica'),

[203] Fix | Delete

('CU', 'Cuba'),

[204] Fix | Delete

('CV', 'Cape Verde'),

[205] Fix | Delete

('CX', 'Christmas Island'),

[206] Fix | Delete

('CY', 'Cyprus'),

[207] Fix | Delete

('CZ', 'Czech Republic'),

[208] Fix | Delete

('DE', 'Germany'),

[209] Fix | Delete

('DJ', 'Djibouti'),

[210] Fix | Delete

('DK', 'Denmark'),

[211] Fix | Delete

('DM', 'Dominica'),

[212] Fix | Delete

('DO', 'Dominican Republic'),

[213] Fix | Delete

('DZ', 'Algeria'),

[214] Fix | Delete

('EC', 'Ecuador'),

[215] Fix | Delete

('EE', 'Estonia'),

[216] Fix | Delete

('EG', 'Egypt'),

[217] Fix | Delete

('EH', 'Western Sahara'),

[218] Fix | Delete

('ER', 'Eritrea'),

[219] Fix | Delete

('ES', 'Spain'),

[220] Fix | Delete

('ET', 'Ethiopia'),

[221] Fix | Delete

('EU', 'Europe'),

[222] Fix | Delete

('FI', 'Finland'),

[223] Fix | Delete

('FJ', 'Fiji'),

[224] Fix | Delete

('FK', 'Falkland Islands (Malvinas)'),

[225] Fix | Delete

('FM', 'Micronesia Federated States of'),

[226] Fix | Delete

('FO', 'Faroe Islands'),

[227] Fix | Delete

('FR', 'France'),

[228] Fix | Delete

('GA', 'Gabon'),

[229] Fix | Delete

('GB', 'United Kingdom'),

[230] Fix | Delete

('GD', 'Grenada'),

[231] Fix | Delete

('GE', 'Georgia'),

[232] Fix | Delete

('GF', 'French Guiana'),

[233] Fix | Delete

('GG', 'Guernsey'),

[234] Fix | Delete

('GH', 'Ghana'),

[235] Fix | Delete

('GI', 'Gibraltar'),

[236] Fix | Delete

('GL', 'Greenland'),

[237] Fix | Delete

('GM', 'Gambia'),

[238] Fix | Delete

('GN', 'Guinea'),

[239] Fix | Delete

('GP', 'Guadeloupe'),

[240] Fix | Delete

('GQ', 'Equatorial Guinea'),

[241] Fix | Delete

('GR', 'Greece'),

[242] Fix | Delete

('GS', 'South Georgia and the South Sandwich Islands'),

[243] Fix | Delete

('GT', 'Guatemala'),

[244] Fix | Delete

('GU', 'Guam'),

[245] Fix | Delete

('GW', 'Guinea-Bissau'),

[246] Fix | Delete

('GY', 'Guyana'),

[247] Fix | Delete

('HK', 'Hong Kong'),

[248] Fix | Delete

('HM', 'Heard Island and McDonald Islands'),

[249] Fix | Delete

('HN', 'Honduras'),

[250] Fix | Delete

('HR', 'Croatia'),

[251] Fix | Delete

('HT', 'Haiti'),

[252] Fix | Delete

('HU', 'Hungary'),

[253] Fix | Delete

('ID', 'Indonesia'),

[254] Fix | Delete

('IE', 'Ireland'),

[255] Fix | Delete

('IL', 'Israel'),

[256] Fix | Delete

('IM', 'Isle of Man'),

[257] Fix | Delete

('IN', 'India'),

[258] Fix | Delete

('IO', 'British Indian Ocean Territory'),

[259] Fix | Delete

('IQ', 'Iraq'),

[260] Fix | Delete

('IR', 'Iran Islamic Republic of'),

[261] Fix | Delete

('IS', 'Iceland'),

[262] Fix | Delete

('IT', 'Italy'),

[263] Fix | Delete

('JE', 'Jersey'),

[264] Fix | Delete

('JM', 'Jamaica'),

[265] Fix | Delete

('JO', 'Jordan'),

[266] Fix | Delete

('JP', 'Japan'),

[267] Fix | Delete

('KE', 'Kenya'),

[268] Fix | Delete

('KG', 'Kyrgyzstan'),

[269] Fix | Delete

('KH', 'Cambodia'),

[270] Fix | Delete

('KI', 'Kiribati'),

[271] Fix | Delete

('KM', 'Comoros'),

[272] Fix | Delete

('KN', 'Saint Kitts and Nevis'),

[273] Fix | Delete

('KP', 'Korea Democratic People''s Republic of'),

[274] Fix | Delete

('KR', 'Korea Republic of'),

[275] Fix | Delete

('KW', 'Kuwait'),

[276] Fix | Delete

('KY', 'Cayman Islands'),

[277] Fix | Delete

('KZ', 'Kazakhstan'),

[278] Fix | Delete

('LA', 'Lao People''s Democratic Republic'),

[279] Fix | Delete

('LB', 'Lebanon'),

[280] Fix | Delete

('LC', 'Saint Lucia'),

[281] Fix | Delete

('LI', 'Liechtenstein'),

[282] Fix | Delete

('LK', 'Sri Lanka'),

[283] Fix | Delete

('LR', 'Liberia'),

[284] Fix | Delete

('LS', 'Lesotho'),

[285] Fix | Delete

('LT', 'Lithuania'),

[286] Fix | Delete

('LU', 'Luxembourg'),

[287] Fix | Delete

('LV', 'Latvia'),

[288] Fix | Delete

('LY', 'Libyan Arab Jamahiriya'),

[289] Fix | Delete

('MA', 'Morocco'),

[290] Fix | Delete

('MC', 'Monaco'),

[291] Fix | Delete

('MD', 'Moldova Republic of'),

[292] Fix | Delete

('ME', 'Montenegro'),

[293] Fix | Delete

('MG', 'Madagascar'),

[294] Fix | Delete

('MH', 'Marshall Islands'),

[295] Fix | Delete

('MK', 'Macedonia'),

[296] Fix | Delete

('ML', 'Mali'),

[297] Fix | Delete

('MM', 'Myanmar'),

[298] Fix | Delete

('MN', 'Mongolia'),

[299] Fix | Delete

('MO', 'Macao'),

[300] Fix | Delete

('MP', 'Northern Mariana Islands'),

[301] Fix | Delete

('MQ', 'Martinique'),

[302] Fix | Delete

('MR', 'Mauritania'),

[303] Fix | Delete

('MS', 'Montserrat'),

[304] Fix | Delete

('MT', 'Malta'),

[305] Fix | Delete

('MU', 'Mauritius'),

[306] Fix | Delete

('MV', 'Maldives'),

[307] Fix | Delete

('MW', 'Malawi'),

[308] Fix | Delete

('MX', 'Mexico'),

[309] Fix | Delete

('MY', 'Malaysia'),

[310] Fix | Delete

('MZ', 'Mozambique'),

[311] Fix | Delete

('NA', 'Namibia'),

[312] Fix | Delete

('NC', 'New Caledonia'),

[313] Fix | Delete

('NE', 'Niger'),

[314] Fix | Delete

('NF', 'Norfolk Island'),

[315] Fix | Delete

('NG', 'Nigeria'),

[316] Fix | Delete

('NI', 'Nicaragua'),

[317] Fix | Delete

('NL', 'Netherlands'),

[318] Fix | Delete

('NO', 'Norway'),

[319] Fix | Delete

('NP', 'Nepal'),

[320] Fix | Delete

('NR', 'Nauru'),

[321] Fix | Delete

('NU', 'Niue'),

[322] Fix | Delete

('NZ', 'New Zealand'),

[323] Fix | Delete

('OM', 'Oman'),

[324] Fix | Delete

('PA', 'Panama'),

[325] Fix | Delete

('PE', 'Peru'),

[326] Fix | Delete

('PF', 'French Polynesia'),

[327] Fix | Delete

('PG', 'Papua New Guinea'),

[328] Fix | Delete

('PH', 'Philippines'),

[329] Fix | Delete

('PK', 'Pakistan'),

[330] Fix | Delete

('PL', 'Poland'),

[331] Fix | Delete

('PM', 'Saint Pierre and Miquelon'),

[332] Fix | Delete

('PN', 'Pitcairn'),

[333] Fix | Delete

('PR', 'Puerto Rico'),

[334] Fix | Delete

('PS', 'Palestinian Territory'),

[335] Fix | Delete

('PT', 'Portugal'),

[336] Fix | Delete

('PW', 'Palau'),

[337] Fix | Delete

('PY', 'Paraguay'),

[338] Fix | Delete

('QA', 'Qatar'),

[339] Fix | Delete

('RE', 'Reunion'),

[340] Fix | Delete

('RO', 'Romania'),

[341] Fix | Delete

('RS', 'Serbia'),

[342] Fix | Delete

('RU', 'Russian Federation'),

[343] Fix | Delete

('RW', 'Rwanda'),

[344] Fix | Delete

('SA', 'Saudi Arabia'),

[345] Fix | Delete

('SB', 'Solomon Islands'),

[346] Fix | Delete

('SC', 'Seychelles'),

[347] Fix | Delete

('SD', 'Sudan'),

[348] Fix | Delete

('SE', 'Sweden'),

[349] Fix | Delete

('SG', 'Singapore'),

[350] Fix | Delete

('SH', 'Saint Helena'),

[351] Fix | Delete

('SI', 'Slovenia'),

[352] Fix | Delete

('SJ', 'Svalbard and Jan Mayen'),

[353] Fix | Delete

('SK', 'Slovakia'),

[354] Fix | Delete

('SL', 'Sierra Leone'),

[355] Fix | Delete

('SM', 'San Marino'),

[356] Fix | Delete

('SN', 'Senegal'),

[357] Fix | Delete

('SO', 'Somalia'),

[358] Fix | Delete

('SR', 'Suriname'),

[359] Fix | Delete

('ST', 'Sao Tome and Principe'),

[360] Fix | Delete

('SV', 'El Salvador'),

[361] Fix | Delete

('SY', 'Syrian Arab Republic'),

[362] Fix | Delete

('SZ', 'Swaziland'),

[363] Fix | Delete

('TC', 'Turks and Caicos Islands'),

[364] Fix | Delete

('TD', 'Chad'),

[365] Fix | Delete

('TF', 'French Southern Territories'),

[366] Fix | Delete

('TG', 'Togo'),

[367] Fix | Delete

('TH', 'Thailand'),

[368] Fix | Delete

('TJ', 'Tajikistan'),

[369] Fix | Delete

('TK', 'Tokelau'),

[370] Fix | Delete

('TL', 'Timor-Leste'),

[371] Fix | Delete

('TM', 'Turkmenistan'),

[372] Fix | Delete

('TN', 'Tunisia'),

[373] Fix | Delete

('TO', 'Tonga'),

[374] Fix | Delete

('TR', 'Turkey'),

[375] Fix | Delete

('TT', 'Trinidad and Tobago'),

[376] Fix | Delete

('TV', 'Tuvalu'),

[377] Fix | Delete

('TW', 'Taiwan'),

[378] Fix | Delete

('TZ', 'Tanzania United Republic of'),

[379] Fix | Delete

('UA', 'Ukraine'),

[380] Fix | Delete

('UG', 'Uganda'),

[381] Fix | Delete

('UM', 'United States Minor Outlying Islands'),

[382] Fix | Delete

('US', 'United States'),

[383] Fix | Delete

('UY', 'Uruguay'),

[384] Fix | Delete

('UZ', 'Uzbekistan'),

[385] Fix | Delete

('VA', 'Holy See (Vatican City State)'),

[386] Fix | Delete

('VC', 'Saint Vincent and the Grenadines'),

[387] Fix | Delete

('VE', 'Venezuela'),

[388] Fix | Delete

('VG', 'Virgin Islands British'),

[389] Fix | Delete

('VI', 'Virgin Islands U.S.'),

[390] Fix | Delete

('VN', 'Vietnam'),

[391] Fix | Delete

('VU', 'Vanuatu'),

[392] Fix | Delete

('WF', 'Wallis and Futuna'),

[393] Fix | Delete

('WS', 'Samoa'),

[394] Fix | Delete

('YE', 'Yemen'),

[395] Fix | Delete

('YT', 'Mayotte'),

[396] Fix | Delete

('ZA', 'South Africa'),

[397] Fix | Delete

('ZM', 'Zambia'),

[398] Fix | Delete

('ZW', 'Zimbabwe');

[399] Fix | Delete

[400] Fix | Delete

-- --------------------------------------------------------

[401] Fix | Delete

[402] Fix | Delete

--

[403] Fix | Delete

-- Table structure for table `crawl_engines`

[404] Fix | Delete

--

[405] Fix | Delete

[406] Fix | Delete

CREATE TABLE `crawl_engines` (

[407] Fix | Delete

`id` int(10) unsigned NOT NULL AUTO_INCREMENT,

[408] Fix | Delete

`engine_name` varchar(60) COLLATE utf8_unicode_ci NOT NULL,

[409] Fix | Delete

`engine_category` varchar(60) COLLATE utf8_unicode_ci NOT NULL,

[410] Fix | Delete

`regex1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

[411] Fix | Delete

`regex2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

[412] Fix | Delete

`regex3` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

[413] Fix | Delete

`regex4` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

[414] Fix | Delete

`url` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

[415] Fix | Delete

`url_part` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

[416] Fix | Delete

`status` tinyint(1) NOT NULL DEFAULT '1',

[417] Fix | Delete

PRIMARY KEY (`id`),

[418] Fix | Delete

UNIQUE KEY `engine_name` (`engine_name`,`engine_category`)

[419] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=15 ;

[420] Fix | Delete

[421] Fix | Delete

--

[422] Fix | Delete

-- Dumping data for table `crawl_engines`

[423] Fix | Delete

--

[424] Fix | Delete

[425] Fix | Delete

INSERT INTO `crawl_engines` VALUES

[426] Fix | Delete

(1, 'alexa', 'rank', '/\\<popularity url\\="(.*?)" TEXT\\="([0-9]+)"/si', NULL, NULL, NULL, '', NULL, 1),

[427] Fix | Delete

(2, 'bing', 'backlink', '/([0-9\\,]+) results/si', '/id="count".*?>.*?\\(([0-9\\,]+).*?\\)/si', '/id="count".*?>.*?([0-9\\,]+).*?/si', '/class="sb_count".*?>.*?([0-9\\,]+).*?<\\/span>/si', '', NULL, 1),

[428] Fix | Delete

(3, 'alexa', 'backlink', '/linksin".*?big.*?>(.*?)</si', NULL, NULL, NULL, '', NULL, 1),

[429] Fix | Delete

(4, 'google', 'backlink', '/about ([0-9\\,]+) result/si', '/<div id=resultStats>([0-9\\,]+) result/si', '/([0-9\\,]+) result/si', '/about <b>([0-9\\,]+)<\\/b> linking/si', '', NULL, 1),

[430] Fix | Delete

(5, 'google', 'saturation', '/about ([0-9\\,]+) result/si', '/<div id=resultStats>([0-9\\,]+) result/si', '/([0-9\\,]+) result/si', '/about <b>([0-9\\,]+)<\\/b> linking/si', '', NULL, 1),

[431] Fix | Delete

(6, 'bing', 'saturation', '/([0-9\\,]+) results/si', '/id="count".*?>.*?\\(([0-9\\,]+).*?\\)/si', '/id="count".*?>.*?([0-9\\,]+).*?/si', '/class="sb_count".*?>.*?([0-9\\,]+).*?<\\/span>/si', '', NULL, 1),

[432] Fix | Delete

(7, 'facebook', 'social_media', '/description".*?content=".*?([\\d,]+) likes/is', '/Total Likes.*?>([\\d,]+).*?Total Follows/is', NULL, NULL, '', '?locale=en_US', 1),

[433] Fix | Delete

(8, 'twitter', 'social_media', '/followers_count".*?(\\d+)/is', NULL, NULL, NULL, 'https://cdn.syndication.twimg.com/widgets/followbutton/info.json?screen_names={ACC_NAME}', NULL, 1),

[434] Fix | Delete

(9, 'instagram', 'social_media', '/edge_followed_by.*?"count":(.*?)\\}/is', NULL, NULL, NULL, '', '/?__a=1', 1),

[435] Fix | Delete

(10, 'linkedin', 'social_media', '/<div.*?follower-count.*?>(.*?)<\\/div>/is', NULL, NULL, NULL, 'https://www.linkedin.com/pages-extensions/FollowCompany?id={CID}&counter=bottom', NULL, 1),

[436] Fix | Delete

(11, 'pinterest', 'social_media', '/pinterestapp:followers.*?content="(.*?)"/is', NULL, NULL, NULL, '', NULL, 1),

[437] Fix | Delete

(12, 'youtube', 'social_media', '/subscriberCountText".*?"(\\d.*?) subscribers"/is', NULL, NULL, NULL, '', '/about', 1),

[438] Fix | Delete

(13, 'google', 'review', '/<span>([0-9.,]+) Google reviews<\\/span>/is', '/<\\/g-popup>.*?aria-label="Rated (\\d+\\.\\d+) out/is', NULL, NULL, '', NULL, 1),

[439] Fix | Delete

(14, 'glassdoor', 'review', '/"reviewCount":([0-9.,]+)/is', '/"overallRating":(\\d+\\.\\d+)/is', NULL, NULL, '', NULL, 1);

[440] Fix | Delete

[441] Fix | Delete

-- --------------------------------------------------------

[442] Fix | Delete

[443] Fix | Delete

--

[444] Fix | Delete

-- Table structure for table `crawl_log`

[445] Fix | Delete

--

[446] Fix | Delete

[447] Fix | Delete

CREATE TABLE `crawl_log` (

[448] Fix | Delete

`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,

[449] Fix | Delete

`crawl_type` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'other',

[450] Fix | Delete

`ref_id` text COLLATE utf8_unicode_ci,

[451] Fix | Delete

`subject` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL,

[452] Fix | Delete

`crawl_link` text COLLATE utf8_unicode_ci NOT NULL,

[453] Fix | Delete

`crawl_referer` text COLLATE utf8_unicode_ci,

[454] Fix | Delete

`crawl_cookie` text COLLATE utf8_unicode_ci,

[455] Fix | Delete

`crawl_post_fields` text COLLATE utf8_unicode_ci,

[456] Fix | Delete

`crawl_useragent` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

[457] Fix | Delete

`crawl_status` tinyint(4) NOT NULL DEFAULT '1',

[458] Fix | Delete

`proxy_id` int(11) unsigned NOT NULL DEFAULT '0',

[459] Fix | Delete

`log_message` text COLLATE utf8_unicode_ci,

[460] Fix | Delete

`crawl_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

[461] Fix | Delete

PRIMARY KEY (`id`),

[462] Fix | Delete

KEY `crawl_status` (`crawl_status`),

[463] Fix | Delete

KEY `crawl_type` (`crawl_type`),

[464] Fix | Delete

KEY `proxy_id` (`proxy_id`)

[465] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

[466] Fix | Delete

[467] Fix | Delete

-- --------------------------------------------------------

[468] Fix | Delete

[469] Fix | Delete

--

[470] Fix | Delete

-- Table structure for table `currency`

[471] Fix | Delete

--

[472] Fix | Delete

[473] Fix | Delete

CREATE TABLE `currency` (

[474] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[475] Fix | Delete

`name` varchar(160) COLLATE utf8_unicode_ci NOT NULL,

[476] Fix | Delete

`iso_code` varchar(3) COLLATE utf8_unicode_ci NOT NULL,

[477] Fix | Delete

`symbol` varchar(3) COLLATE utf8_unicode_ci NOT NULL,

[478] Fix | Delete

`unicode` varchar(8) COLLATE utf8_unicode_ci NOT NULL,

[479] Fix | Delete

`position` varchar(6) COLLATE utf8_unicode_ci NOT NULL,

[480] Fix | Delete

`paypal` tinyint(1) NOT NULL DEFAULT '0',

[481] Fix | Delete

`status` tinyint(1) NOT NULL DEFAULT '1',

[482] Fix | Delete

PRIMARY KEY (`id`),

[483] Fix | Delete

UNIQUE KEY `iso_code` (`iso_code`)

[484] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=68 ;

[485] Fix | Delete

[486] Fix | Delete

--

[487] Fix | Delete

-- Dumping data for table `currency`

[488] Fix | Delete

--

[489] Fix | Delete

[490] Fix | Delete

INSERT INTO `currency` VALUES

[491] Fix | Delete

(1, 'United Arab Emirates Dirham', 'AED', 'د.', '', 'after', 0, 1),

[492] Fix | Delete

(2, 'Netherlands Antillian Guilder', 'ANG', 'Æ’', '&#x0192;', 'before', 0, 1),

[493] Fix | Delete

(3, '', 'AOA', 'AOA', 'AOA', 'before', 0, 1),

[494] Fix | Delete

(4, 'Argentine Peso', 'ARS', '$', '&#36;', 'before', 0, 1),

[495] Fix | Delete

(5, 'Australian Dollar', 'AUD', '$', '&#36;', 'before', 1, 1),

[496] Fix | Delete

(6, '', 'BAM', 'KM', 'KM', 'before', 0, 1),

[497] Fix | Delete

(7, 'Barbados Dollar', 'BBD', '$', '&#36;', 'before', 0, 1),

[498] Fix | Delete

(8, '', 'BGL', 'лÐ', '&#1083;&', 'before', 0, 1),

[499] Fix | Delete