DROP TABLE IF EXISTS `#__js_job_ages`;
CREATE TABLE `#__js_job_ages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(45) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `isdefault` tinyint(1) DEFAULT NULL,
  `ordering` int(11) DEFAULT NULL,
  `serverid` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=11;
INSERT INTO `#__js_job_ages` (`id`, `title`, `status`, `isdefault`, `ordering`, `serverid`) VALUES(1, '10 Years', 1, 0, 1, 0),(2, '15 Years', 1, 0, 2, 0),(3, '20 Years', 1, 0, 3, 0),(4, '25 Years', 1, 1, 4, 0),(5, '30 Years', 1, 0, 5, 0),(6, '35 Years', 1, 0, 6, 0),(7, '40 Years', 1, 0, 7, 0),(8, '45 Years', 1, 0, 8, 0),(9, '50 Years', 1, 0, 9, 0),(10, '55 Years', 1, 0, 10, 0);

DROP TABLE IF EXISTS `#__js_job_careerlevels`;
CREATE TABLE `#__js_job_careerlevels` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(150) NOT NULL,
  `status` tinyint(4) NOT NULL,
  `isdefault` tinyint(1) DEFAULT NULL,
  `ordering` int(11) DEFAULT NULL,
  `serverid` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8;
INSERT INTO `#__js_job_careerlevels` (`id`, `title`, `status`, `isdefault`, `ordering`, `serverid`) VALUES(1, 'Student (Undergraduate)', 1, 0, 1, 0),(2, 'Student (Graduate)', 1, 0, 2, 0),(3, 'Entry Level', 1, 1, 3, 0),(4, 'Experienced (Non-Manager)', 1, 0, 4, 0),(5, 'Manager', 1, 0, 5, 0),(6, 'Executive (Department Head, SVP, VP etc)', 1, 0, 6, 0),(7, 'Senior Executive (President, CEO, etc)', 1, 0, 7, 0);

DROP TABLE IF EXISTS `#__js_job_categories`;
CREATE TABLE `#__js_job_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cat_value` varchar(255) DEFAULT NULL,
  `cat_title` varchar(255) DEFAULT NULL,
  `alias` varchar(225) NOT NULL,
  `isactive` smallint(1) DEFAULT '1',
  `isdefault` tinyint(1) DEFAULT NULL,
  `ordering` int(11) DEFAULT NULL,
  `serverid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `cat_title_key` (`cat_title`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=59 ;
INSERT INTO `#__js_job_categories` (`id`, `cat_value`, `cat_title`, `alias`, `isactive`, `isdefault`, `ordering`, `serverid`) VALUES(1, NULL, 'Accounting/Finance', 'accounting-finance', 1, 0, 1, 0),(2, NULL, 'Administrative', 'administrative', 1, 0, 2, 0),(3, NULL, 'Advertising', 'advertising', 1, 0, 3, 0),(4, NULL, 'Airlines/Avionics/Aerospace', 'airlines-avionics-aerospace', 1, 0, 4, 0),(5, NULL, 'Architectural', 'architectural', 1, 0, 5, 0),(6, NULL, 'Automotive', 'automotive', 1, 0, 6, 0),(7, NULL, 'Banking/Finance', 'banking-finance', 1, 0, 7, 0),(8, NULL, 'Biotechnology', 'biotechnology', 1, 0, 8, 0),(9, NULL, 'Civil/Construction', 'civil-construction', 1, 0, 9, 0),(10, NULL, 'Engineering', 'engineering', 1, 0, 10, 0),(11, NULL, 'Cleared Jobs', 'cleared-jobs', 1, 0, 11, 0),(12, NULL, 'Communications', 'communications', 1, 0, 12, 0),(13, NULL, 'Computer/IT', 'computer-it', 1, 1, 13, 0),(14, NULL, 'Construction', 'construction', 1, 0, 14, 0),(15, NULL, 'Consultant/Contractual', 'consultant-contractual', 1, 0, 15, 0),(16, NULL, 'Customer Service', 'customer-service', 1, 0, 16, 0),(17, NULL, 'Defense', 'defense', 1, 0, 17, 0),(18, NULL, 'Design', 'design', 1, 0, 18, 0),(19, NULL, 'Education', 'education', 1, 0, 19, 0),(20, NULL, 'Electrical Engineering', 'electrical-engineering', 1, 0, 20, 0),(21, NULL, 'Electronics Engineering', 'electronics-engineering', 1, 0, 21, 0),(22, NULL, 'Energy', 'energy', 1, 0, 22, 0),(24, NULL, 'Environmental/Safety', 'environmental-safety', 1, 0, 24, 0),(25, NULL, 'Fundraising', 'fundraising', 1, 0, 25, 0),(26, NULL, 'Health/Medicine', 'health-medicine', 1, 0, 26, 0),(27, NULL, 'Homeland Security', 'homeland-security', 1, 0, 27, 0),(28, NULL, 'Human Resources', 'human-resources', 1, 0, 28, 0),(29, NULL, 'Insurance', 'insurance', 1, 0, 29, 0),(30, NULL, 'Intelligence Jobs', 'intelligence-jobs', 1, 0, 30, 0),(31, NULL, 'Internships/Trainees', 'internships-trainees', 1, 0, 31, 0),(32, NULL, 'Legal', 'legal', 1, 0, 32, 0),(33, NULL, 'Logistics/Transportation', 'logistics-transportation', 1, 0, 33, 0),(34, NULL, 'Maintenance', 'maintenance', 1, 0, 34, 0),(35, NULL, 'Management', 'management', 1, 0, 35, 0),(36, NULL, 'Manufacturing/Warehouse', 'manufacturing-warehouse', 1, 0, 36, 0),(37, NULL, 'Marketing', 'marketing', 1, 0, 37, 0),(38, NULL, 'Materials Management', 'materials-management', 1, 0, 38, 0),(39, NULL, 'Mechanical Engineering', 'mechanical-engineering', 1, 0, 39, 0),(40, NULL, 'Mortgage/Real Estate', 'mortgage-real estate', 1, 0, 40, 0),(41, NULL, 'National Security', 'national-security', 1, 0, 41, 0),(42, NULL, 'Part-time/Freelance', 'part-time-freelance', 1, 0, 42, 0),(43, NULL, 'Printing', 'printing', 1, 0, 43, 0),(44, NULL, 'Product Design', 'product-design', 1, 0, 44, 0),(45, NULL, 'Public Relations', 'public-relations', 1, 0, 45, 0),(46, NULL, 'Public Safety', 'public-safety', 1, 0, 46, 0),(47, NULL, 'Research', 'research', 1, 0, 47, 0),(48, NULL, 'Retail', 'retail', 1, 0, 48, 0),(49, NULL, 'Sales', 'sales', 1, 0, 49, 0),(50, NULL, 'Scientific', 'scientific', 1, 0, 50, 0),(51, NULL, 'Shipping/Distribution', 'shipping-distribution', 1, 0, 51, 0),(52, NULL, 'Technicians', 'technicians', 1, 0, 52, 0),(53, NULL, 'Trades', 'trades', 1, 0, 53, 0),(54, NULL, 'Transportation', 'transportation', 1, 0, 54, 0),(55, NULL, 'Transportation Engineering', 'transportation-engineering', 1, 0, 55, 0),(56, NULL, 'Web Site Development', 'web-site-development', 1, 0, 56, 0);

DROP TABLE IF EXISTS `#__js_job_cities`;
CREATE TABLE `#__js_job_cities` (
  `id` mediumint(6) NOT NULL AUTO_INCREMENT,
  `cityName` varchar(70) DEFAULT NULL,
  `name` varchar(60) DEFAULT NULL,
  `stateid` smallint(8) DEFAULT NULL,
  `countryid` smallint(9) DEFAULT NULL,
  `isedit` tinyint(1) DEFAULT '0',
  `enabled` tinyint(1) NOT NULL DEFAULT '0',
  `serverid` int(11) DEFAULT NULL,
  `latitude` varchar(100) COLLATE 'utf8_general_ci' NULL,
  `longitude` varchar(100) COLLATE 'utf8_general_ci' NULL,
  
  PRIMARY KEY (`id`),
  KEY `countryid` (`countryid`),
  KEY `stateid` (`stateid`),
  FULLTEXT KEY `name` (`name`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=76869 ;
INSERT INTO `#__js_job_cities` (`id`, `cityName`, `name`, `stateid`, `countryid`, `isedit`, `enabled`, `serverid`, `latitude`, `longitude`) VALUES
(69785, 'Karachi',  'Karachi',  NULL, 126,  0,  1,  69788,  '24.8614622', '67.0099388'),
(70143, 'Adilpur',  'Adilpur',  0,  126,  1,  1,  70146,  '27.9383133', '69.3190425'),
(70015, 'Ahmadpur Sial',  'AhmadpurSial', NULL, 126,  0,  1,  70018,  '30.6844519', '71.7652137'),
(69836, 'AhmadpurEast', 'AhmadpurEast', 0,  126,  1,  1,  76866,  '29.1411551', '71.2577233'),
(70025, 'Akora',  'Akora',  0,  126,  1,  1,  70028,  '34', '72.1333329'),
(70147, 'Alik Ghund', 'AlikGhund',  NULL, 126,  0,  1,  70150,  '34.2203425', '72.2639358'),
(69963, 'Alipur', 'Alipur', NULL, 126,  0,  1,  69966,  '29.3881554', '70.9190132'),
(70159, 'Alizai', 'Alizai', NULL, 126,  0,  1,  70162,  '33.537239',  '70.3435088'),
(70009, 'Amangarh', 'Amangarh', NULL, 126,  0,  1,  70012,  '34.0057866', '71.9296662'),
(69855, 'Attock City',  'AttockCity', NULL, 126,  0,  1,  69858,  '33.7687344', '72.362147'),
(70054, 'Baddomalhi', 'Baddomalhi', 0,  126,  1,  1,  70057,  '31.9885417', '74.6605365'),
(69867, 'Badin',  'Badin',  NULL, 126,  0,  1,  69870,  '24.6557191', '68.837241'),
(70100, 'Baffa',  'Baffa',  NULL, 126,  0,  1,  70103,  '34.4406901', '73.2205065'),
(69831, 'Bahawalnagar', 'Bahawalnagar', NULL, 126,  0,  1,  69834,  '29.9991825', '73.2588441'),
(69796, 'Bahawalpur', 'Bahawalpur', NULL, 126,  0,  1,  69799,  '29.3957215', '71.6833331'),
(70169, 'Bakhri Ahmad Khan',  'BakhriAhmadKhan',  NULL, 126,  0,  1,  70172,  '30.7530953', '70.8655074'),
(69908, 'Bannu',  'Bannu',  NULL, 126,  0,  1,  69911,  '32.989724',  '70.6038334'),
(69926, 'Basirpur', 'Basirpur', NULL, 126,  0,  1,  69929,  '30.5779666', '73.8360251'),
(70176, 'Basti Aukharvand', 'BastiAukharvand',  NULL, 126,  0,  1,  70179,  '26.155163',  '68.3484602'),
(70167, 'Basti Dosa', 'BastiDosa',  NULL, 126,  0,  1,  70170,  '30.7877207', '70.8676441'),
(69914, 'Bat Khela',  'BatKhela', NULL, 126,  0,  1,  69917,  '34.6137694', '71.9282781'),
(70128, 'Begowala', 'Begowala', NULL, 126,  0,  1,  70131,  '32.4389602', '74.2692839'),
(70043, 'Bela', 'Bela', NULL, 126,  0,  1,  70046,  '26.2267942', '66.3110971'),
(70126, 'Berani', 'Berani', NULL, 126,  0,  1,  70129,  '25.7868964', '68.8064137'),
(70144, 'Bagarji',  'Bagarji',  NULL, 126,  0,  1,  70147,  '27.7559788', '68.7497777'),
(69857, 'Bhakkar',  'Bhakkar',  NULL, 126,  0,  1,  69860,  '31.6265504', '71.0616623'),
(69865, 'Bhalwal',  'Bhalwal',  NULL, 126,  0,  1,  69868,  '32.275141',  '72.9047136'),
(70074, 'Bhawana',  'Bhawana',  NULL, 126,  0,  1,  70077,  '31.5675547', '72.6565084'),
(69972, 'Bhera',  'Bhera',  NULL, 126,  0,  1,  69975,  '32.4816761', '72.9076669'),
(70095, 'Bhag', 'Bhag', NULL, 126,  0,  1,  70098,  '29.0444314', '67.8241911'),
(69854, 'Bhai Pheru', 'BhaiPheru',  NULL, 126,  0,  1,  69857,  '31.205974',  '73.9418603'),
(69802, 'Bhimbar',  'Bhimbar',  NULL, 126,  0,  1,  69805,  '32.9816247', '74.0711359'),
(70112, 'Bhiria', 'Bhiria', NULL, 126,  0,  1,  70115,  '26.910384',  '68.1863546'),
(70049, 'Bhit Shah',  'BhitShah', NULL, 126,  0,  1,  70052,  '25.8020588', '68.4919235'),
(70064, 'Bhan', 'Bhan', NULL, 126,  0,  1,  70067,  '26.5566671', '67.719871'),
(70062, 'Bhopalwala', 'Bhopalwala', NULL, 126,  0,  1,  70065,  '32.4293472', '74.3635275'),
(70140, 'Bandhi', 'Bandhi', NULL, 126,  0,  1,  70143,  '26.5862194', '68.3011359'),
(70130, 'Bozdar', 'Bozdar', NULL, 126,  0,  1,  70133,  '27.183333',  '68.6333329'),
(69816, 'Burewala', 'Burewala', NULL, 126,  0,  1,  69819,  '30.1577112', '72.6739675'),
(70139, 'Barkhan',  'Barkhan',  NULL, 126,  0,  1,  70142,  '29.8972421', '69.5276135'),
(70158, 'Bulri',  'Bulri',  NULL, 126,  0,  1,  70161,  '24.866667',  '68.333333'),
(70097, 'Chak', 'Chak', NULL, 126,  0,  1,  70100,  '32.8124916', '74.090226'),
(70056, 'Chak Two Hundred Forty-Nine TDA',  'ChakTwoHundredForty-NineTDA',  NULL, 126,  0,  1,  70059,  '33.3876953', '71.3408707'),
(69938, 'Chak Azam Saffo',  'ChakAzamSaffo',  NULL, 126,  0,  1,  69941,  '30.7513979', '73.0294589'),
(69843, 'Chakwal',  'Chakwal',  NULL, 126,  0,  1,  69846,  '32.9310991', '72.8550863'),
(69850, 'Chaman', 'Chaman', NULL, 126,  0,  1,  69853,  '30.907255',  '66.4509585'),
(70108, 'Chambar',  'Chambar',  NULL, 126,  0,  1,  70111,  '25.293292',  '68.8138658'),
(70022, 'Chawinda', 'Chawinda', NULL, 126,  0,  1,  70025,  '32.3445875', '74.7059059'),
(69856, 'Chichawatni',  'Chichawatni',  NULL, 126,  0,  1,  69859,  '30.5391319', '72.6919814'),
(76865, 'check synchronize 1',  'check synchronize 1',  0,  126,  1,  1,  76871,  '', ''),
(76866, 'check synchronize 2',  'check synchronize 2',  0,  126,  1,  1,  76872,  '', ''),
(76867, 'check synchronize 3',  'check synchronize 3',  0,  126,  1,  1,  76873,  '', ''),
(76868, 'check synchronize 4',  'check synchronize 4',  0,  126,  1,  1,  76874,  '', ''),
(70161, 'Cherat', 'Cherat', NULL, 126,  0,  1,  70164,  '33.8225317', '71.8904844'),
(69876, 'Chuhar Kana',  'ChuharKana', NULL, 126,  0,  1,  69879,  '31.7451915', '73.8330844'),
(69813, 'Chiniot',  'Chiniot',  NULL, 126,  0,  1,  69816,  '31.7285872', '72.9814877'),
(69834, 'Chishtian Mandi',  'ChishtianMandi', NULL, 126,  0,  1,  69837,  '29.9092481', '73.0529761'),
(76854, 'Chitral',  'Chitral',  86, 126,  0,  1,  76857,  '35.8522867', '71.7871069'),
(69895, 'Chunian',  'Chunian',  NULL, 126,  0,  1,  69898,  '30.9673834', '73.9741874'),
(70085, 'Choa Saidan Shah', 'ChoaSaidanShah', NULL, 126,  0,  1,  70088,  '32.7227733', '72.9844401'),
(70071, 'Chor', 'Chor', NULL, 126,  0,  1,  70074,  '25.5114274', '69.7823059'),
(70168, 'Chowki Jamali',  'ChowkiJamali', NULL, 126,  0,  1,  70171,  '28.0209905', '67.9210645'),
(69847, 'Charsadda',  'Charsadda',  NULL, 126,  0,  1,  69850,  '34.1494329', '71.7427812'),
(70082, 'Chuhar Jamali',  'ChuharJamali', NULL, 126,  0,  1,  70085,  '24.3967645', '67.9911139'),
(70174, 'Dajjal wala',  'Dajjalwala', NULL, 126,  0,  1,  70177,  '', ''),
(70087, 'Darya Khan', 'DaryaKhan',  NULL, 126,  0,  1,  70090,  '31.7812058', '71.1032591'),
(70133, 'Darya Khan Marri', 'DaryaKhanMarri', NULL, 126,  0,  1,  70136,  '26.6842052', '68.2832496'),
(69829, 'Daska',  'Daska',  NULL, 126,  0,  1,  69832,  '32.334984',  '74.3528822'),
(70094, 'Daulatpur',  'Daulatpur',  NULL, 126,  0,  1,  70097,  '26.4944244', '67.9732288'),
(70115, 'Daultala', 'Daultala', NULL, 126,  0,  1,  70118,  '33.1925909', '73.1379109'),
(70061, 'Daur', 'Daur', NULL, 126,  0,  1,  70064,  '26.4545363', '68.3190222'),
(70005, 'Daud Khel',  'DaudKhel', NULL, 126,  0,  1,  70008,  '32.8718898', '71.569428'),
(70086, 'Dadhar', 'Dadhar', NULL, 126,  0,  1,  70089,  '29.479429',  '67.6399'),
(69825, 'Dadu', 'Dadu', NULL, 126,  0,  1,  69828,  '26.7340581', '67.7794817'),
(70057, 'Dera Bugti', 'DeraBugti',  NULL, 126,  0,  1,  70060,  '29.0351582', '69.1596093'),
(69807, 'Dera Ghazi Khan',  'DeraGhaziKhan',  NULL, 126,  0,  1,  69810,  '30.0324857', '70.6402456'),
(69842, 'Dera Ismail Khan', 'DeraIsmailKhan', NULL, 126,  0,  1,  69845,  '31.8423621', '70.8952337'),
(70051, 'Dhanot', 'Dhanot', NULL, 126,  0,  1,  70054,  '27.6501099', '68.0393671'),
(70114, 'Dhaunkal', 'Dhaunkal', NULL, 126,  0,  1,  70117,  '32.4074383', '74.1416127'),
(70044, 'Dhoro Naro', 'DhoroNaro',  NULL, 126,  0,  1,  70047,  '25.5048266', '69.5693225'),
(69971, 'Digri',  'Digri',  NULL, 126,  0,  1,  69974,  '25.1511235', '69.1119247'),
(69999, 'Dijkot', 'Dijkot', NULL, 126,  0,  1,  70002,  '31.2179046', '72.9962491'),
(69931, 'Dinga',  'Dinga',  NULL, 126,  0,  1,  69934,  '32.6417589', '73.7213063'),
(70116, 'Diplo',  'Diplo',  NULL, 126,  0,  1,  70119,  '24.465469',  '69.5827286'),
(70088, 'Daira Din Panah',  'DairaDinPanah',  NULL, 126,  0,  1,  70091,  '30.5683543', '70.9365945'),
(70060, 'Dajal',  'Dajal',  NULL, 126,  0,  1,  70063,  '29.5599903', '70.3747545'),
(70093, 'Dalbandin',  'Dalbandin',  NULL, 126,  0,  1,  70096,  '28.8854045', '64.3963673'),
(70135, 'Doaba',  'Doaba',  NULL, 126,  0,  1,  70138,  '33.4248352', '70.7376623'),
(70091, 'Dokri',  'Dokri',  NULL, 126,  0,  1,  70094,  '27.371442',  '68.0999173'),
(69866, 'Dipalpur', 'Dipalpur', NULL, 126,  0,  1,  69869,  '30.6673293', '73.6595075'),
(69981, 'Dir',  'Dir',  NULL, 126,  0,  1,  69984,  '35.1976595', '71.8749209'),
(70120, 'Daro Mehar', 'DaroMehar',  NULL, 126,  0,  1,  70123,  '27.1129952', '67.9575794'),
(70154, 'Duki', 'Duki', NULL, 126,  0,  1,  70157,  '30.1522019', '68.5783733'),
(69909, 'Dullewala',  'Dullewala',  NULL, 126,  0,  1,  69912,  '31.8427075', '71.4358733'),
(70008, 'Dunga Bunga',  'DungaBunga', NULL, 126,  0,  1,  70011,  '29.7472966', '73.2440996'),
(69960, 'Dunyapur', 'Dunyapur', NULL, 126,  0,  1,  69963,  '29.8045422', '71.7405672'),
(70028, 'Eminabad', 'Eminabad', NULL, 126,  0,  1,  70031,  '32.0433183', '74.2560806'),
(69787, 'Faisalabad', 'Faisalabad', NULL, 126,  0,  1,  69790,  '31.4187142', '73.0791073'),
(70014, 'Faqirwali',  'Faqirwali',  NULL, 126,  0,  1,  70017,  '29.476868',  '73.0464309'),
(70036, 'Faruka', 'Faruka', NULL, 126,  0,  1,  70039,  '31.8248486', '72.5151944'),
(69992, 'Fazalpur', 'Fazalpur', NULL, 126,  0,  1,  69995,  '29.2931391', '70.452117'),
(69929, 'Fort Abbas', 'FortAbbas',  NULL, 126,  0,  1,  69932,  '29.193053',  '72.8574558'),
(70104, 'Gadani', 'Gadani', NULL, 126,  0,  1,  70107,  '25.1163445', '66.7278021'),
(69961, 'Gambat', 'Gambat', NULL, 126,  0,  1,  69964,  '27.352443',  '68.5206879'),
(69987, 'Garh Maharaja',  'GarhMaharaja', NULL, 126,  0,  1,  69990,  '30.8361718', '71.9030828'),
(70102, 'Garhi Khairo', 'GarhiKhairo',  NULL, 126,  0,  1,  70105,  '28.0592418', '67.9791769'),
(70089, 'Garhi Yasin',  'GarhiYasin', NULL, 126,  0,  1,  70092,  '27.9065243', '68.5157718'),
(69982, 'Ghauspur', 'Ghauspur', NULL, 126,  0,  1,  69985,  '28.1371171', '69.0821211'),
(69888, 'Ghotki', 'Ghotki', NULL, 126,  0,  1,  69891,  '28.0006901', '69.3189399'),
(70048, 'Gharo',  'Gharo',  NULL, 126,  0,  1,  70051,  '24.7403038', '67.5842645'),
(70127, 'Gilgit', 'Gilgit', NULL, 126,  0,  1,  70130,  '35.920154',  '74.3080126'),
(69874, 'Gujar Khan', 'GujarKhan',  NULL, 126,  0,  1,  69877,  '33.2512989', '73.3060197'),
(69826, 'Gojra',  'Gojra',  NULL, 126,  0,  1,  69829,  '31.1467905', '72.6852207'),
(70151, 'Goth Garelo',  'GothGarelo', NULL, 126,  0,  1,  70154,  '26.2955335', '68.6290501'),
(69791, 'Gujranwala', 'Gujranwala', NULL, 126,  0,  1,  69794,  '32.1543783', '74.1842254'),
(69804, 'Gujrat', 'Gujrat', NULL, 126,  0,  1,  69807,  '32.5711443', '74.075005'),
(70170, 'Gulishah Kach',  'GulishahKach', NULL, 126,  0,  1,  70173,  '30.7877207', '70.8676441'),
(69900, 'Gwadar', 'Gwadar', NULL, 126,  0,  1,  69903,  '25.1986951', '62.3213153'),
(69906, 'Hadali', 'Hadali', NULL, 126,  0,  1,  69909,  '32.2920892', '72.1919614'),
(69947, 'Hangu',  'Hangu',  NULL, 126,  0,  1,  69950,  '33.528665',  '71.067605'),
(70118, 'Harnai', 'Harnai', NULL, 126,  0,  1,  70121,  '30.0999687', '67.9434205'),
(70083, 'Harnoli',  'Harnoli',  NULL, 126,  0,  1,  70086,  '32.2773356', '71.5545911'),
(69897, 'Haripur',  'Haripur',  NULL, 126,  0,  1,  69900,  '33.9959837', '72.9367618'),
(69918, 'Hasan Abdal',  'HasanAbdal', NULL, 126,  0,  1,  69921,  '33.8194868', '72.6890255'),
(69884, 'Haveli', 'Haveli', NULL, 126,  0,  1,  69887,  '33.4687969', '72.1182872'),
(69930, 'Havelian', 'Havelian', NULL, 126,  0,  1,  69933,  '34.0465833', '73.1438116'),
(70007, 'Hazro',  'Hazro',  NULL, 126,  0,  1,  70010,  '33.9101872', '72.4938607'),
(69822, 'Hafizabad',  'Hafizabad',  NULL, 126,  0,  1,  69825,  '32.0716989', '73.6857291'),
(70032, 'Hingorja', 'Hingorja', NULL, 126,  0,  1,  70035,  '27.2105474', '68.4159067'),
(69910, 'Hala', 'Hala', NULL, 126,  0,  1,  69913,  '25.8167566', '68.4233593'),
(69871, 'Harunabad',  'Harunabad',  NULL, 126,  0,  1,  69874,  '29.612972',  '73.1408613'),
(69852, 'Hasilpur', 'Hasilpur', NULL, 126,  0,  1,  69855,  '29.690255',  '72.5382293'),
(69893, 'Hujra',  'Hujra',  NULL, 126,  0,  1,  69896,  '30.7355827', '73.8213213'),
(69790, 'Hyderabad',  'Hyderabad',  NULL, 126,  0,  1,  69793,  '25.3817509', '68.3693897'),
(76864, 'isedit city',  'isedit city',  0,  126,  1,  1,  76870,  '30.3829282', '67.7243417'),
(69795, 'Islamabad',  'Islamabad',  NULL, 126,  0,  1,  69798,  '33.7293882', '73.0931461'),
(70110, 'Islamkot', 'Islamkot', NULL, 126,  0,  1,  70113,  '24.7013799', '70.1783251'),
(69817, 'Jacobabad',  'Jacobabad',  NULL, 126,  0,  1,  69820,  '28.2829348', '68.4364877'),
(69988, 'Jahanian Shah',  'JahanianShah', NULL, 126,  0,  1,  69991,  '32.7340812', '73.9315733'),
(69848, 'Jalalpur', 'Jalalpur', NULL, 126,  0,  1,  69851,  '32.6494831', '74.0553484'),
(69940, 'Jalalpur Pirwala', 'JalalpurPirwala',  NULL, 126,  0,  1,  69943,  '29.5052835', '71.2220832'),
(70055, 'Jand', 'Jand', NULL, 126,  0,  1,  70058,  '33.4364645', '72.0171862'),
(69835, 'Jaranwala',  'Jaranwala',  0,  126,  0,  1,  69838,  '31.3328773', '73.4175824'),
(69912, 'Jatoi Shimali',  'JatoiShimali', NULL, 126,  0,  1,  69915,  '31.8427075', '71.4358733'),
(69913, 'Jauharabad', 'Jauharabad', NULL, 126,  0,  1,  69916,  '32.2899398', '72.271908'),
(69803, 'Jhang Sadr', 'JhangSadr',  NULL, 126,  0,  1,  69806,  '31.2654657', '72.3123725'),
(69995, 'Jhawarian',  'Jhawarian',  NULL, 126,  0,  1,  69998,  '32.3594749', '72.623987'),
(69820, 'Jhelum', 'Jhelum', NULL, 126,  0,  1,  69823,  '32.9405479', '73.7276293'),
(70076, 'Jhol', 'Jhol', NULL, 126,  0,  1,  70079,  '25.957297',  '68.8898751'),
(69942, 'Jhumra', 'Jhumra', NULL, 126,  0,  1,  69945,  '31.5673242', '73.1828061'),
(70148, 'Jam Sahib',  'JamSahib', NULL, 126,  0,  1,  70151,  '26.2955335', '68.6290501'),
(69890, 'Jampur', 'Jampur', NULL, 126,  0,  1,  69893,  '29.6459464', '70.5919357'),
(70119, 'Jandiala Sher Khan', 'JandialaSherKhan', NULL, 126,  0,  1,  70122,  '31.8176025', '73.9212858'),
(70070, 'Johi', 'Johi', NULL, 126,  0,  1,  70073,  '26.6930979', '67.6155573'),
(70131, 'Jati', 'Jati', NULL, 126,  0,  1,  70134,  '24.3552401', '68.2668538'),
(70069, 'Jiwani', 'Jiwani', NULL, 126,  0,  1,  70072,  '25.0472733', '61.7458759'),
(69894, 'Kabirwala',  'Kabirwala',  NULL, 126,  0,  1,  69897,  '30.4010623', '71.8630625'),
(70150, 'Kadhan', 'Kadhan', NULL, 126,  0,  1,  70153,  '24.4808475', '68.9852555'),
(70029, 'Kahuta', 'Kahuta', NULL, 126,  0,  1,  70032,  '33.5896138', '73.3885526'),
(70081, 'Kallar Kahar', 'KallarKahar',  NULL, 126,  0,  1,  70084,  '32.7760323', '72.7008489'),
(70012, 'Kalur Kot',  'KalurKot', NULL, 126,  0,  1,  70015,  '32.0974997', '71.5439451'),
(70109, 'Kalaswala',  'Kalaswala',  NULL, 126,  0,  1,  70112,  '32.199328',  '74.6502902'),
(70004, 'Kalat',  'Kalat',  NULL, 126,  0,  1,  70007,  '29.0303612', '66.5878767'),
(70080, 'Kamar Mushani',  'KamarMushani', NULL, 126,  0,  1,  70083,  '32.8432577', '71.359738'),
(69860, 'Kambar', 'Kambar', NULL, 126,  0,  1,  69863,  '27.5859189', '68.0060183'),
(69838, 'Kamalia',  'Kamalia',  NULL, 126,  0,  1,  69841,  '30.7221821', '72.6446829'),
(69814, 'Kamoke', 'Kamoke', NULL, 126,  0,  1,  69817,  '31.9755071', '74.223802'),
(70021, 'Kamir',  'Kamir',  NULL, 126,  0,  1,  70024,  '30.4273414', '73.0434794'),
(69851, 'Kandhkot', 'Kandhkot', NULL, 126,  0,  1,  69854,  '28.2425261', '69.183451'),
(70149, 'Kandiari', 'Kandiari', NULL, 126,  0,  1,  70152,  '25.7982864', '69.0687093'),
(70001, 'Kandiaro', 'Kandiaro', NULL, 126,  0,  1,  70004,  '27.0587825', '68.2117046'),
(70035, 'Kanganpur',  'Kanganpur',  NULL, 126,  0,  1,  70038,  '30.7678277', '74.1210597'),
(70101, 'Karak',  'Karak',  NULL, 126,  0,  1,  70104,  '33.1104787', '71.0913748'),
(70141, 'Karaundi', 'Karaundi', NULL, 126,  0,  1,  70144,  '26.1322972', '81.8572681'),
(70156, 'Kario',  'Kario',  NULL, 126,  0,  1,  70159,  '24.8050055', '68.6052022'),
(70010, 'Karor',  'Karor',  NULL, 126,  0,  1,  70013,  '31.22331', '70.95005'),
(69962, 'Kashmor',  'Kashmor',  NULL, 126,  0,  1,  69965,  '28.4323282', '69.5916659'),
(69806, 'Kasur',  'Kasur',  NULL, 126,  0,  1,  69809,  '31.1164769', '74.4493744'),
(70162, 'Keti Bandar',  'KetiBandar', NULL, 126,  0,  1,  70165,  '24.1299447', '67.453141'),
(70152, 'Khadan Khak',  'KhadanKhak', NULL, 126,  0,  1,  70155,  '25.4356826', '68.332437'),
(70125, 'Khadro', 'Khadro', NULL, 126,  0,  1,  70128,  '26.150341',  '68.7169879'),
(69833, 'Khairpur', 'Khairpur', NULL, 126,  0,  1,  69836,  '27.5299523', '68.7581419'),
(69980, 'Khairpur Nathan Shah', 'KhairpurNathanShah', NULL, 126,  0,  1,  69983,  '27.0922441', '67.7347735'),
(69933, 'Khalabat', 'Khalabat', NULL, 126,  0,  1,  69936,  '34.0194023', '72.9135734'),
(69968, 'Khewra', 'Khewra', NULL, 126,  0,  1,  69971,  '32.630728',  '73.0117665'),
(69990, 'Khipro', 'Khipro', NULL, 126,  0,  1,  69993,  '25.8241828', '69.3756586'),
(69916, 'Kahna',  'Kahna',  NULL, 126,  0,  1,  69919,  '31.373857',  '74.3675446'),
(70046, 'Khangarh', 'Khangarh', NULL, 126,  0,  1,  70049,  '29.9206348', '71.1626756'),
(69979, 'Khangah Dogran', 'KhangahDogran',  NULL, 126,  0,  1,  69982,  '31.8315',  '73.6241855'),
(69824, 'Khanpur',  'Khanpur',  NULL, 126,  0,  1,  69827,  '28.6491211', '70.6514213'),
(69858, 'Kharian',  'Kharian',  NULL, 126,  0,  1,  69861,  '32.8269819', '73.8459847'),
(69977, 'Kharan', 'Kharan', NULL, 126,  0,  1,  69980,  '28.5812029', '65.422281'),
(69951, 'Khurrianwala', 'Khurrianwala', NULL, 126,  0,  1,  69954,  '31.5215898', '73.2602441'),
(69840, 'Khushab',  'Khushab',  NULL, 126,  0,  1,  69843,  '32.3054193', '72.3482384'),
(70078, 'Kalabagh', 'Kalabagh', NULL, 126,  0,  1,  70081,  '32.9623645', '71.5471724'),
(70068, 'Kaleke Mandi', 'KalekeMandi',  NULL, 126,  0,  1,  70071,  '31.9750078', '73.6032755'),
(69924, 'Kamra',  'Kamra',  NULL, 126,  0,  1,  69927,  '33.8558023', '72.3944135'),
(70117, 'Kohlu',  'Kohlu',  NULL, 126,  0,  1,  70120,  '29.8975881', '69.2490136'),
(69873, 'Kohror Pakka', 'KohrorPakka',  NULL, 126,  0,  1,  69876,  '29.6437628', '71.9164217'),
(69823, 'Kohat',  'Kohat',  NULL, 126,  0,  1,  69826,  '33.5834014', '71.4332193'),
(69839, 'Kot Addu', 'KotAddu',  NULL, 126,  0,  1,  69842,  '30.4615356', '70.9695403'),
(70011, 'Kot Diji', 'KotDiji',  NULL, 126,  0,  1,  70014,  '27.3395429', '68.7065547'),
(70041, 'Kot Ghulam Muhammad',  'KotGhulamMuhammad',  NULL, 126,  0,  1,  70044,  '25.289933',  '69.2490136'),
(69875, 'Kot Malik',  'KotMalik', NULL, 126,  0,  1,  69878,  '28.4922222', '64.69'),
(69936, 'Kot Mumin',  'KotMumin', NULL, 126,  0,  1,  69939,  '32.1900283', '73.0257691'),
(69915, 'Kot Radha Kishan', 'KotRadhaKishan', NULL, 126,  0,  1,  69918,  '31.1687588', '74.1006772'),
(70027, 'Kot Samaba', 'KotSamaba',  NULL, 126,  0,  1,  70030,  '28.5521456', '70.4699683'),
(70124, 'Kot Sultan', 'KotSultan',  NULL, 126,  0,  1,  70127,  '30.7750133', '70.9368469'),
(69794, 'Kotli',  'Kotli',  NULL, 126,  0,  1,  69797,  '33.5145095', '73.8993095'),
(70037, 'Kotli Loharan',  'KotliLoharan', NULL, 126,  0,  1,  70040,  '32.5877557', '74.4965215'),
(69869, 'Kotri',  'Kotri',  NULL, 126,  0,  1,  69872,  '25.3540609', '68.2683443'),
(70031, 'Kulachi',  'Kulachi',  NULL, 126,  0,  1,  70034,  '31.9328279', '70.4610427'),
(69949, 'Kundian',  'Kundian',  NULL, 126,  0,  1,  69952,  '32.4525158', '71.4833652'),
(69994, 'Kunjah', 'Kunjah', NULL, 126,  0,  1,  69997,  '32.531894',  '73.9741874'),
(70003, 'Kunri',  'Kunri',  NULL, 126,  0,  1,  70006,  '25.1772515', '69.5648538'),
(69932, 'Ladhewala Waraich',  'LadhewalaWaraich', NULL, 126,  0,  1,  69935,  '32.1581941', '74.115187'),
(69786, 'Lahore', 'Lahore', NULL, 126,  0,  1,  69789,  '31.5546061', '74.3571581'),
(70103, 'Lakhi',  'Lakhi',  NULL, 126,  0,  1,  70106,  '27.848942',  '68.6998301'),
(69945, 'Lakki Marwat', 'LakkiMarwat',  NULL, 126,  0,  1,  69948,  '32.6044506', '70.9130684'),
(70164, 'Landi Kotal',  'LandiKotal', NULL, 126,  0,  1,  70167,  '34.0909899', '71.1457517'),
(70053, 'Lachi',  'Lachi',  NULL, 126,  0,  1,  70056,  '33.3876953', '71.3408707'),
(69859, 'Leiah',  'Leiah',  NULL, 126,  0,  1,  69862,  '30.9647503', '70.9399349'),
(70111, 'Liliani',  'Liliani',  NULL, 126,  0,  1,  70114,  '30.9909796', '70.5153376'),
(69885, 'Lala Musa',  'LalaMusa', NULL, 126,  0,  1,  69888,  '32.7037264', '73.9585169'),
(69976, 'Lalian', 'Lalian', NULL, 126,  0,  1,  69979,  '31.8233973', '72.8072342'),
(69845, 'Lodhran',  'Lodhran',  NULL, 126,  0,  1,  69848,  '29.5363422', '71.6317359'),
(69939, 'Loralai',  'Loralai',  NULL, 126,  0,  1,  69942,  '30.3740712', '68.5902973'),
(69800, 'Larkana',  'Larkana',  NULL, 126,  0,  1,  69803,  '27.563994',  '68.2151309'),
(70065, 'Mach', 'Mach', NULL, 126,  0,  1,  70068,  '29.8645414', '67.3294806'),
(70090, 'Madeji', 'Madeji', NULL, 126,  0,  1,  70093,  '27.753545',  '68.4516583'),
(69886, 'Mailsi', 'Mailsi', NULL, 126,  0,  1,  69889,  '29.8042254', '72.1740413'),
(69954, 'Malakwal City',  'MalakwalCity', NULL, 126,  0,  1,  69957,  '32.5498983', '73.20281'),
(69956, 'Malakwal', 'Malakwal', NULL, 126,  0,  1,  69959,  '32.5498983', '73.20281'),
(69827, 'Mandi Bahauddin',  'MandiBahauddin', NULL, 126,  0,  1,  69830,  '32.5881687', '73.4973431'),
(70073, 'Mangla', 'Mangla', NULL, 126,  0,  1,  70076,  '33.1007838', '73.6514134'),
(70121, 'Mankera',  'Mankera',  NULL, 126,  0,  1,  70124,  '31.3821495', '71.4477469'),
(69805, 'Mardan', 'Mardan', NULL, 126,  0,  1,  69808,  '34.2001138', '72.0508013'),
(69989, 'Mastung',  'Mastung',  NULL, 126,  0,  1,  69992,  '29.7984166', '66.8469103'),
(70050, 'Matiari',  'Matiari',  NULL, 126,  0,  1,  70053,  '25.597796',  '68.4442267'),
(69978, 'Mehar',  'Mehar',  NULL, 126,  0,  1,  69981,  '27.175294',  '67.8152491'),
(70157, 'Mehmand Chak', 'MehmandChak',  NULL, 126,  0,  1,  70160,  '32.7884623', '73.8227917'),
(69952, 'Mehrabpur',  'Mehrabpur',  NULL, 126,  0,  1,  69955,  '27.102101',  '68.4150795'),
(69862, 'Mian Channun', 'MianChannun',  NULL, 126,  0,  1,  69865,  '30.4361208', '72.3488721'),
(69986, 'Minchinabad',  'Minchinabad',  NULL, 126,  0,  1,  69989,  '30.1598144', '73.5682467'),
(69810, 'Mingaora', 'Mingaora', NULL, 126,  0,  1,  69813,  '34.7717466', '72.3601512'),
(69849, 'Mianwali', 'Mianwali', NULL, 126,  0,  1,  69852,  '32.5788912', '71.560526'),
(70006, 'Mitha Tiwana', 'MithaTiwana',  NULL, 126,  0,  1,  70009,  '32.2416242', '72.1090303'),
(70024, 'Mithi',  'Mithi',  NULL, 126,  0,  1,  70027,  '24.7400111', '69.7983444'),
(69969, 'Mamu Kanjan',  'MamuKanjan', NULL, 126,  0,  1,  69972,  '30.7287704', '72.661514'),
(69991, 'Mananwala',  'Mananwala',  NULL, 126,  0,  1,  69994,  '31.4729556', '74.4195864'),
(69882, 'Mansehra', 'Mansehra', NULL, 126,  0,  1,  69885,  '34.3338823', '73.2010622'),
(69861, 'Moro', 'Moro', NULL, 126,  0,  1,  69864,  '26.6591938', '68.0060183'),
(70171, 'Moza Shahwala',  'MozaShahwala', NULL, 126,  0,  1,  70174,  '28.0209905', '67.9210645'),
(70160, 'Miram Shah', 'MiramShah',  NULL, 126,  0,  1,  70163,  '33.0073',  '70.0652004'),
(70123, 'Miro Khan',  'MiroKhan', NULL, 126,  0,  1,  70126,  '27.7589814', '68.0924649'),
(70136, 'Mirpur Batoro',  'MirpurBatoro', NULL, 126,  0,  1,  70139,  '24.7304503', '68.2594012'),
(69812, 'Mirpur Khas',  'MirpurKhas', NULL, 126,  0,  1,  69815,  '25.5291051', '69.0135706'),
(69907, 'Mirpur Mathelo', 'MirpurMathelo',  NULL, 126,  0,  1,  69910,  '28.0208426', '69.552937'),
(70142, 'Mirpur Sakro', 'MirpurSakro',  NULL, 126,  0,  1,  70145,  '24.5473691', '67.6259883'),
(70113, 'Mirwah Gorchani',  'MirwahGorchani', NULL, 126,  0,  1,  70116,  '25.3097741', '69.0478462'),
(69904, 'Matli',  'Matli',  NULL, 126,  0,  1,  69907,  '25.0467638', '68.6558788'),
(69789, 'Multan', 'Multan', NULL, 126,  0,  1,  69792,  '30.1983807', '71.4687028'),
(69819, 'Muridke',  'Muridke',  NULL, 126,  0,  1,  69822,  '31.8024737', '74.2590148'),
(70013, 'Murree', 'Murree', NULL, 126,  0,  1,  70016,  '33.9077736', '73.3914997'),
(69917, 'Mustafabad', 'Mustafabad', NULL, 126,  0,  1,  69920,  '32.1913216', '74.2324224'),
(70045, 'Muzaffarabad', 'Muzaffarabad', NULL, 126,  0,  1,  70048,  '34.3596867', '73.471054'),
(69818, 'Muzaffargarh', 'Muzaffargarh', NULL, 126,  0,  1,  69821,  '30.0736087', '71.1804988'),
(70155, 'Nabisar',  'Nabisar',  NULL, 126,  0,  1,  70158,  '25.0681398', '69.6437982'),
(69898, 'Nankana Sahib',  'NankanaSahib', NULL, 126,  0,  1,  69901,  '31.4507815', '73.7036514'),
(69996, 'Nasirabad',  'Nasirabad',  NULL, 126,  0,  1,  69999,  '27.3799987', '67.915103'),
(69964, 'Naudero',  'Naudero',  NULL, 126,  0,  1,  69967,  '27.6670437', '68.3637381'),
(70033, 'Naukot', 'Naukot', NULL, 126,  0,  1,  70036,  '24.854836',  '69.4099249'),
(69928, 'Naushahra Virkan', 'NaushahraVirkan',  NULL, 126,  0,  1,  69931,  '31.9661054', '73.977126'),
(70059, 'Naushahro Firoz',  'NaushahroFiroz', NULL, 126,  0,  1,  70062,  '26.8462951', '68.1252555'),
(69809, 'Nawabshah',  'Nawabshah',  NULL, 126,  0,  1,  69812,  '26.2442211', '68.4100338'),
(69934, 'New Badah',  'NewBadah', NULL, 126,  0,  1,  69937,  '31.1141733', '74.4292967'),
(70173, 'Noorabad', 'Noorabad', NULL, 126,  0,  1,  70176,  '26.155163',  '68.3484602'),
(70175, 'Nooriabad',  'Nooriabad',  NULL, 126,  0,  1,  70178,  '25.2739885', '68.4869861'),
(69846, 'Nowshera Cantonment',  'NowsheraCantonment', NULL, 126,  0,  1,  69849,  '34.0055051', '72.0082966'),
(69955, 'Narang', 'Narang', NULL, 126,  0,  1,  69958,  '33.1796667', '72.7643901'),
(69878, 'Narowal',  'Narowal',  NULL, 126,  0,  1,  69881,  '32.0994756', '74.8747353'),
(69997, 'Nushki', 'Nushki', NULL, 126,  0,  1,  70000,  '29.5558052', '66.0195894'),
(69811, 'Okara',  'Okara',  NULL, 126,  0,  1,  69814,  '30.8090496', '73.4508207'),
(70107, 'Ormara', 'Ormara', NULL, 126,  0,  1,  70110,  '25.2665929', '64.6095785'),
(69941, 'Pabbi',  'Pabbi',  NULL, 126,  0,  1,  69944,  '34.0113944', '71.7941607'),
(70040, 'Pad Idan', 'PadIdan',  NULL, 126,  0,  1,  70043,  '26.7757114', '68.2951738'),
(70063, 'Paharpur', 'Paharpur', NULL, 126,  0,  1,  70066,  '32.1056403', '70.9722619'),
(76858, 'Panjpai',  'Panjpai',  88, 126,  0,  1,  76861,  '29.9132123', '66.4956023'),
(69965, 'Pasni',  'Pasni',  NULL, 126,  0,  1,  69968,  '25.281566',  '63.4036287'),
(69899, 'Pasrur', 'Pasrur', NULL, 126,  0,  1,  69902,  '32.2639737', '74.6693186'),
(69872, 'Pattoki',  'Pattoki',  NULL, 126,  0,  1,  69875,  '31.0249269', '73.8479317'),
(69792, 'Peshawar', 'Peshawar', NULL, 126,  0,  1,  69795,  '34.0149748', '71.5804899'),
(70016, 'Phalia', 'Phalia', NULL, 126,  0,  1,  70019,  '32.4217135', '73.5770801'),
(70145, 'Phulji', 'Phulji', NULL, 126,  0,  1,  70148,  '26.8813924', '67.6826153'),
(70034, 'Pind Dadan Khan',  'PindDadanKhan',  NULL, 126,  0,  1,  70037,  '32.5883708', '73.0434794'),
(69953, 'Pindi Bhattian', 'PindiBhattian',  NULL, 126,  0,  1,  69956,  '31.8950469', '73.2706389'),
(76856, 'Pindi Gheb', 'Pindi Gheb', 89, 126,  0,  1,  76859,  '33.2451991', '72.2659868'),
(69958, 'Pindi Gheb', 'PindiGheb',  NULL, 126,  0,  1,  69961,  '33.2451991', '72.2659868'),
(70020, 'Pishin', 'Pishin', NULL, 126,  0,  1,  70023,  '30.5842128', '66.9958226'),
(70153, 'Pithoro',  'Pithoro',  NULL, 126,  0,  1,  70156,  '25.5105787', '69.3756586'),
(69830, 'Pakpattan',  'Pakpattan',  NULL, 126,  0,  1,  69833,  '30.3524565', '73.3885526'),
(69868, 'Pano Aqil',  'PanoAqil', NULL, 126,  0,  1,  69871,  '27.8144456', '69.1089444'),
(69948, 'Pirjo Goth', 'PirjoGoth',  NULL, 126,  0,  1,  69951,  '27.6321715', '68.5962593'),
(69950, 'Pir Mahal',  'PirMahal', NULL, 126,  0,  1,  69953,  '30.7654756', '72.4343685'),
(70042, 'Qadirpur Ran', 'QadirpurRan',  NULL, 126,  0,  1,  70045,  '30.2911176', '71.6719869'),
(69793, 'Quetta', 'Quetta', NULL, 126,  0,  1,  69796,  '30.1829713', '66.998734'),
(70096, 'Rasulnagar', 'Rasulnagar', NULL, 126,  0,  1,  70099,  '32.3272407', '73.7794679'),
(69911, 'Ratodero', 'Ratodero', NULL, 126,  0,  1,  69914,  '27.8025876', '68.2892117'),
(70066, 'Radhan', 'Radhan', NULL, 126,  0,  1,  70069,  '27.1984727', '67.9534808'),
(69943, 'Renala Khurd', 'RenalaKhurd',  NULL, 126,  0,  1,  69946,  '30.8800345', '73.6003308'),
(69853, 'Arifwala', 'Arifwala', NULL, 126,  0,  1,  69856,  '30.2978601', '73.0582368'),
(69944, 'Risalpur', 'Risalpur', NULL, 126,  0,  1,  69947,  '34.0751141', '71.9875531'),
(69975, 'Raiwind',  'Raiwind',  NULL, 126,  0,  1,  69978,  '31.2456587', '74.2128875'),
(70018, 'Raja Jang',  'RajaJang', NULL, 126,  0,  1,  70021,  '31.2205548', '74.2560806'),
(69901, 'Rajanpur', 'Rajanpur', NULL, 126,  0,  1,  69904,  '29.1017686', '70.3244659'),
(70146, 'Rajo Khanani', 'RajoKhanani',  NULL, 126,  0,  1,  70149,  '24.9845653', '68.8541063'),
(70030, 'Ranipur',  'Ranipur',  NULL, 126,  0,  1,  70033,  '27.2847838', '68.5071364'),
(69902, 'Rohri',  'Rohri',  NULL, 126,  0,  1,  69905,  '27.675196',  '68.9003075'),
(70106, 'Rojhan', 'Rojhan', NULL, 126,  0,  1,  70109,  '28.6794257', '69.9609892'),
(70132, 'Rustam jo Goth', 'RustamjoGoth', NULL, 126,  0,  1,  70135,  '24.8810774', '67.0316723'),
(69905, 'Rawala Kot', 'RawalaKot',  NULL, 126,  0,  1,  69908,  '33.8567701', '73.7588945'),
(69788, 'Rawalpindi', 'Rawalpindi', NULL, 126,  0,  1,  69791,  '33.598394',  '73.0441352'),
(69973, 'Sakrand',  'Sakrand',  NULL, 126,  0,  1,  69976,  '26.1520262', '68.2683443'),
(70138, 'Samaro', 'Samaro', NULL, 126,  0,  1,  70141,  '25.2841367', '69.3935368'),
(69891, 'Sambrial', 'Sambrial', NULL, 126,  0,  1,  69894,  '32.4785685', '74.3528822'),
(70122, 'Sanjwal',  'Sanjwal',  NULL, 126,  0,  1,  70125,  '33.7601226', '72.4339514'),
(70137, 'Sann', 'Sann', NULL, 126,  0,  1,  70140,  '26.0382473', '68.1341985'),
(76859, 'Sararogha',  'Sararogha',  87, 126,  0,  1,  76862,  '33.2451991', '72.2659868'),
(69797, 'Sargodha', 'Sargodha', NULL, 126,  0,  1,  69800,  '32.0837411', '72.6718596'),
(69922, 'Sarai Alamgir',  'SaraiAlamgir', NULL, 126,  0,  1,  69925,  '32.9002189', '73.7590686'),
(70047, 'Sarai Naurang',  'SaraiNaurang', NULL, 126,  0,  1,  70050,  '32.8230028', '70.7822635'),
(70084, 'Sarai Sidhu',  'SaraiSidhu', NULL, 126,  0,  1,  70087,  '30.5975528', '71.9727354'),
(69815, 'Sadiqabad',  'Sadiqabad',  NULL, 126,  0,  1,  69818,  '28.3083941', '70.133673'),
(69927, 'Sehwan', 'Sehwan', NULL, 126,  0,  1,  69930,  '26.4234157', '67.8629399'),
(69967, 'Setharja Old', 'SetharjaOld',  NULL, 126,  0,  1,  69970,  '27.6670437', '68.3637381'),
(69881, 'Shabqadar',  'Shabqadar',  NULL, 126,  0,  1,  69884,  '34.2185757', '71.5545911'),
(70075, 'Shahr Sultan', 'ShahrSultan',  NULL, 126,  0,  1,  70078,  '29.5756193', '71.0209738'),
(69887, 'Shakargarr', 'Shakargarr', NULL, 126,  0,  1,  69890,  '32.2642802', '75.1598723'),
(69970, 'Sharqpur', 'Sharqpur', NULL, 126,  0,  1,  69973,  '31.4632106', '74.103441'),
(69801, 'Sheikhupura',  'Sheikhupura',  NULL, 126,  0,  1,  69804,  '31.7166617', '73.9850243'),
(76860, 'Shewa',  'Shewa',  87, 126,  0,  1,  76863,  '33.2536611', '70.4967441'),
(69864, 'Shahdadkot', 'Shahdadkot', NULL, 126,  0,  1,  69867,  '27.848312',  '67.9106318'),
(69880, 'Shahdadpur', 'Shahdadpur', NULL, 126,  0,  1,  69883,  '25.9268081', '68.6260691'),
(70098, 'Shahpur',  'Shahpur',  NULL, 126,  0,  1,  70101,  '32.2866118', '72.4302529'),
(70038, 'Shahpur Chakar', 'ShahpurChakar',  NULL, 126,  0,  1,  70041,  '26.1543553', '68.6505791'),
(69821, 'Shikarpur',  'Shikarpur',  NULL, 126,  0,  1,  69824,  '27.9570397', '68.637993'),
(70172, 'Shinpokh', 'Shinpokh', NULL, 126,  0,  1,  70175,  '34.8644422', '-89.860363'),
(69879, 'Shorko', 'Shorko', NULL, 126,  0,  1,  69882,  '30.8318336', '72.0764437'),
(69883, 'Shujaabad',  'Shujaabad',  NULL, 126,  0,  1,  69886,  '29.8764183', '71.3171162'),
(69808, 'Sahiwal',  'Sahiwal',  NULL, 126,  0,  1,  69811,  '30.6611813', '73.1085756'),
(69889, 'Sibi', 'Sibi', NULL, 126,  0,  1,  69892,  '29.5395519', '67.8759078'),
(69798, 'Sialkot',  'Sialkot',  NULL, 126,  0,  1,  69801,  '32.4924769', '74.5310403'),
(70000, 'Sillanwali', 'Sillanwali', NULL, 126,  0,  1,  70003,  '31.8248489', '72.5411869'),
(70079, 'Sinjhoro', 'Sinjhoro', NULL, 126,  0,  1,  70082,  '26.03067', '68.8079041'),
(70166, 'Skardu', 'Skardu', NULL, 126,  0,  1,  70169,  '35.2900896', '75.6453431'),
(69892, 'Sanghar',  'Sanghar',  NULL, 126,  0,  1,  69895,  '26.0444193', '68.9538789'),
(69896, 'Sangla', 'Sangla', NULL, 126,  0,  1,  69899,  '31.713381',  '73.373016'),
(70092, 'Sobhadero',  'Sobhadero',  NULL, 126,  0,  1,  70095,  '27.3076123', '68.4024919'),
(70077, 'Sodhra', 'Sodhra', NULL, 126,  0,  1,  70080,  '32.465509',  '74.1856472'),
(70134, 'Sohbatpur',  'Sohbatpur',  NULL, 126,  0,  1,  70137,  '28.5188198', '68.5411106'),
(76855, 'Spinwam',  'Spinwam',  87, 126,  0,  1,  76858,  '33.1737486', '70.401907'),
(70105, 'Surab',  'Surab',  NULL, 126,  0,  1,  70108,  '28.4901014', '66.2634928'),
(69998, 'Sita Road',  'SitaRoad', NULL, 126,  0,  1,  70001,  '27.042879',  '67.853367'),
(69966, 'Sukheke Mandi',  'SukhekeMandi', NULL, 126,  0,  1,  69969,  '31.8665471', '73.5019838'),
(69799, 'Sukkur', 'Sukkur', NULL, 126,  0,  1,  69802,  '27.7066038', '68.8481971'),
(76857, 'Swat', 'Swat', 86, 126,  0,  1,  76860,  '35.4920326', '72.5204827'),
(69844, 'Swabi',  'Swabi',  NULL, 126,  0,  1,  69847,  '34.1164164', '72.4642776'),
(69919, 'Talagang', 'Talagang', NULL, 126,  0,  1,  69922,  '32.9298214', '72.4198967'),
(69993, 'Talamba',  'Talamba',  NULL, 126,  0,  1,  69996,  '30.5239319', '72.2393399'),
(70039, 'Talhar', 'Talhar', NULL, 126,  0,  1,  70042,  '24.8883678', '68.8139269'),
(69828, 'Tando Allahyar', 'TandoAllahyar',  NULL, 126,  0,  1,  69831,  '25.4570396', '68.7214593'),
(70099, 'Tando Bago', 'TandoBago',  NULL, 126,  0,  1,  70102,  '24.7887164', '68.9655333'),
(69832, 'Tando Adam', 'TandoAdam',  NULL, 126,  0,  1,  69835,  '25.7685204', '68.6625448'),
(70072, 'Tando Ghulam Ali', 'TandoGhulamAli', NULL, 126,  0,  1,  70075,  '25.1242171', '68.8913654'),
(69974, 'Tando Jam',  'TandoJam', NULL, 126,  0,  1,  69977,  '25.4298913', '68.5426011'),
(69870, 'Tando Muhammad Khan',  'TandoMuhammadKhan',  NULL, 126,  0,  1,  69873,  '25.1228751', '68.5350842'),
(69983, 'Tangi',  'Tangi',  NULL, 126,  0,  1,  69986,  '34.3008142', '71.6525026'),
(70129, 'Tangwani', 'Tangwani', NULL, 126,  0,  1,  70132,  '28.242434',  '68.779462'),
(69920, 'Taunsa', 'Taunsa', NULL, 126,  0,  1,  69923,  '30.7059921', '70.6484471'),
(69921, 'Thatta', 'Thatta', NULL, 126,  0,  1,  69924,  '24.7469887', '67.9255357'),
(70058, 'Tharu Shah', 'TharuShah',  NULL, 126,  0,  1,  70061,  '26.9426981', '68.1163126'),
(69957, 'Thul', 'Thul', NULL, 126,  0,  1,  69960,  '28.2396296', '68.7755104'),
(69985, 'Tal',  'Tal',  NULL, 126,  0,  1,  69988,  '34.6855556', '73.2611111'),
(69937, 'Tandlianwala', 'Tandlianwala', NULL, 126,  0,  1,  69940,  '31.0368217', '73.1379109'),
(70163, 'Tando Mittha Khan',  'TandoMitthaKhan',  NULL, 126,  0,  1,  70166,  '25.995584',  '69.199842'),
(69935, 'Tank', 'Tank', NULL, 126,  0,  1,  69938,  '32.2142959', '70.3777302'),
(69877, 'Toba Tek Singh', 'TobaTekSingh', NULL, 126,  0,  1,  69880,  '30.9726705', '72.4849861'),
(69946, 'Topi', 'Topi', NULL, 126,  0,  1,  69949,  '34.065904',  '72.6358134'),
(69863, 'Turbat', 'Turbat', NULL, 126,  0,  1,  69866,  '26.0080546', '63.0383059'),
(70023, 'Ubauro', 'Ubauro', NULL, 126,  0,  1,  70026,  '28.1659641', '69.7316714'),
(69925, 'Umarkot',  'Umarkot',  NULL, 126,  0,  1,  69928,  '25.3614443', '69.7435857'),
(69923, 'Usta Muhammad',  'UstaMuhammad', NULL, 126,  0,  1,  69926,  '28.1792746', '68.04477'),
(70067, 'Uthal',  'Uthal',  NULL, 126,  0,  1,  70070,  '25.8014437', '66.6206225'),
(69984, 'Utmanzai', 'Utmanzai', NULL, 126,  0,  1,  69987,  '34.2204177', '71.4430876'),
(69837, 'Vihari', 'Vihari', NULL, 126,  0,  1,  69840,  '30.0452462', '72.3488721'),
(70019, 'Warburton',  'Warburton',  NULL, 126,  0,  1,  70022,  '31.5398053', '73.8330844'),
(69841, 'Wazirabad',  'Wazirabad',  NULL, 126,  0,  1,  69844,  '32.4386254', '74.1169906'),
(70165, 'Wana', 'Wana', NULL, 126,  0,  1,  70168,  '32.3006562', '69.5797495'),
(70052, 'Warah',  'Warah',  NULL, 126,  0,  1,  70055,  '27.4476667', '67.7943847'),
(70017, 'Yazman Mandi', 'YazmanMandi',  NULL, 126,  0,  1,  70020,  '29.1257774', '71.7513816'),
(70026, 'Zafarwal', 'Zafarwal', NULL, 126,  0,  1,  70029,  '32.3401285', '74.9062622'),
(70002, 'Zaida',  'Zaida',  NULL, 126,  0,  1,  70005,  '34.0548135', '72.467236'),
(69959, 'Zahir Pir',  'ZahirPir', NULL, 126,  0,  1,  69962,  '28.8136245', '70.5145939'),
(69903, 'Zhob', 'Zhob', NULL, 126,  0,  1,  69906,  '31.3412607', '69.4486593'),
(76861, 'Ziarat', 'Ziarat', 88, 126,  0,  1,  76864,  '30.3829282', '67.7243417');

DROP TABLE IF EXISTS `#__js_job_companies`;
CREATE TABLE `#__js_job_companies` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) DEFAULT NULL,
  `category` int(11) NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL DEFAULT '',
  `alias` varchar(225) NOT NULL,
  `url` varchar(255) DEFAULT NULL,
  `logofilename` varchar(100) DEFAULT NULL,
  `logoisfile` tinyint(1) DEFAULT '-1',
  `logo` blob DEFAULT NULL,
  `smalllogofilename` varchar(100) DEFAULT NULL,
  `smalllogoisfile` tinyint(1) DEFAULT '-1',
  `smalllogo` tinyblob DEFAULT NULL,
  `aboutcompanyfilename` varchar(100) DEFAULT NULL,
  `aboutcompanyisfile` tinyint(1) DEFAULT '-1',
  `aboutcompanyfilesize` varchar(100) DEFAULT NULL,
  `aboutcompany` mediumblob DEFAULT NULL,
  `contactname` varchar(255) NOT NULL DEFAULT '',
  `contactphone` varchar(255) DEFAULT NULL,
  `companyfax` varchar(250) DEFAULT NULL,
  `contactemail` varchar(255) NOT NULL DEFAULT '',
  `since` datetime DEFAULT NULL,
  `companysize` varchar(255) DEFAULT NULL,
  `income` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `country` varchar(255) NOT NULL DEFAULT '0',
  `state` varchar(255) DEFAULT NULL,
  `county` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `zipcode` varchar(25) DEFAULT NULL,
  `address1` varchar(255) DEFAULT NULL,
  `address2` varchar(255) DEFAULT NULL,
  `created` datetime NOT NULL DEFAULT current_timestamp(),
  `modified` datetime DEFAULT NULL,
  `hits` int(11) DEFAULT NULL,
  `metadescription` text DEFAULT NULL,
  `metakeywords` text DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `packageid` int(11) DEFAULT NULL,
  `paymenthistoryid` int(11) DEFAULT NULL,
  `isgoldcompany` tinyint(1) DEFAULT '0',
  `startgolddate` datetime DEFAULT NULL,
  `endgolddate` date DEFAULT NULL,
  `isfeaturedcompany` tinyint(1) DEFAULT '0',
  `startfeatureddate` datetime DEFAULT NULL,
  `endfeatureddate` date DEFAULT NULL,
  `notifications` tinyint(1) NOT NULL DEFAULT '0',
  `serverstatus` varchar(255) DEFAULT NULL,
  `serverid` int(11) DEFAULT '0',
  `params` longtext DEFAULT NULL, 
  PRIMARY KEY (`id`),
  KEY `companies_uid` (`uid`),
  KEY `companies_category` (`category`),
  KEY `companies_packageid` (`packageid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `#__js_job_companycities`;
CREATE TABLE `#__js_job_companycities` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `companyid` int(11) NOT NULL,
  `cityid` int(11) NOT NULL,
  `serverid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `companyid` (`companyid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `#__js_job_config`;
CREATE TABLE `#__js_job_config` (
  `configname` varchar(100) NOT NULL DEFAULT '',
  `configvalue` varchar(255) NOT NULL DEFAULT '',
  `configfor` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`configname`),
  FULLTEXT KEY `config_name` (`configname`),
  FULLTEXT KEY `config_for` (`configfor`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO `#__js_job_config` (`configname`, `configvalue`, `configfor`) VALUES
('companyautoapprove', '1', 'default'),
('comp_city', '1', 'default'),
('comp_editor', '1', 'default'),
('comp_zipcode', '1', 'default'),
('cur_location', '1', 'default'),
('empautoapprove', '1', 'default'),
('jobautoapprove', '1', 'default'),
('job_editor', '1', 'default'),
('mailfromaddress', 'sender@joomshark.com', 'email'),
('mailfromname', 'JS Jobs', 'email'),
('newdays', '7', 'default'),
('search_job_durration', '1', 'searchjob'),
('search_job_salaryrange', '1', 'searchjob'),
('search_job_shift', '1', 'searchjob'),
('search_job_showsave', '1', 'searchjob'),
('search_job_startpublishing', '1', 'searchjob'),
('search_job_stoppublishing', '1', 'searchjob'),
('search_job_companysite', '1', 'searchjob'),
('search_resume_available', '1', 'searchresume'),
('search_resume_experience', '1', 'searchresume'),
('actk', '0', 'default'),
('search_resume_gender', '1', 'searchresume'),
('search_resume_heighesteducation', '1', 'searchresume'),
('search_resume_name', '1', 'searchresume'),
('search_resume_nationality', '1', 'searchresume'),
('search_resume_salaryrange', '1', 'searchresume'),
('search_resume_showsave', '1', 'searchresume'),
('search_resume_title', '1', 'searchresume'),
('search_resume_keywords', '1', 'searchresume'),
('showemployerlink', '1', 'default'),
('theme', 'gray/css/jsjobsgray.css', 'default'),
('title', 'JS JOBS', 'default'),
('data_directory', 'jsjobsdata', 'default'),
('version', '1.3.7', 'default'),
('versioncode','137','default'),
('versiontype', 'free', NULL),
('refercode', '207e16fc9c4d2881fc', 'default'),
('filter', '1', 'default'),
('fr_cr_txa', '<img src="components/com_jsjobs/images/jsjobs_logo_small.png" width="65">&nbsp;&nbsp;&nbsp;Powered by <a href="http://www.joomsky.com" target="_blank">Joom Sky</a>', 'default'),
('fr_cr_txsh', '0', 'default'),
('fr_cr_txb', '<br>&copy;Copyright 2008 - 2011, <a href="http://www.burujsolutions.com" target="_blank">Buruj Solutions </a> ', 'default'),
('company_logofilezize', '50', 'default'),
('resume_photofilesize', '50', 'default'),
('offline', '0', 'default'),
('offline_text', 'JS Jobs is down for maintenance. Please check back again soon.', 'default'),
('payment_multicompanies', '0', 'payment'),
('lj_title', '1', 'listjob'),
('lj_category', '1', 'listjob'),
('lj_jobtype', '1', 'listjob'),
('lj_jobstatus', '1', 'listjob'),
('lj_company', '1', 'listjob'),
('lj_companysite', '1', 'listjob'),
('lj_country', '1', 'listjob'),
('lj_state', '1', 'listjob'),
('lj_city', '1', 'listjob'),
('lj_salary', '1', 'listjob'),
('lj_created', '1', 'listjob'),
('lj_noofjobs', '1', 'listjob'),
('visitor_lj_title', '1', 'listjob'),
('visitor_lj_category', '1', 'listjob'),
('visitor_lj_jobtype', '1', 'listjob'),
('visitor_lj_jobstatus', '1', 'listjob'),
('visitor_lj_company', '1', 'listjob'),
('visitor_lj_companysite', '0', 'listjob'),
('visitor_lj_country', '1', 'listjob'),
('visitor_lj_state', '1', 'listjob'),
('email_employer_new_job', '0', 'email'),
('visitor_lj_city', '1', 'listjob'),
('visitor_lj_salary', '1', 'listjob'),
('visitor_lj_created', '1', 'listjob'),
('visitor_lj_noofjobs', '1', 'listjob'),
('visitorview_js_controlpanel', '1', 'default'),
('visitorview_js_packages', '1', 'default'),
('visitorview_js_viewpackage', '1', 'default'),
('visitorview_js_jobcat', '1', 'default'),
('visitorview_js_listjob', '1', 'default'),
('visitorview_js_newestjobs', '1', 'default'),
('visitorview_js_jobsearch', '1', 'default'),
('visitorview_js_jobsearchresult', '1', 'default'),
('visitorview_emp_conrolpanel', '1', 'default'),
('visitorview_emp_packages', '1', 'default'),
('visitorview_emp_viewpackage', '1', 'default'),
('visitorview_emp_resumesearch', '1', 'default'),
('visitorview_emp_resumesearchresult', '1', 'default'),
('visitorview_emp_viewcompany', '1', 'default'),
('visitorview_emp_viewjob', '1', 'default'),
('search_job_title', '1', 'searchjob'),
('search_job_category', '1', 'searchjob'),
('search_job_type', '1', 'searchjob'),
('search_job_status', '1', 'searchjob'),
('search_job_company', '1', 'searchjob'),
('search_job_city', '1', 'searchjob'),
('search_job_zipcode', '0', 'searchjob'),
('search_resume_category', '1', 'searchresume'),
('search_resume_type', '1', 'searchresume'),
('featuredjob_autoapprove', '1', 'featuredjob'),
('goldjob_autoapprove', '1', 'goldjob'),
('featuredcompany_autoapprove', '1', 'featuredcompany'),
('goldcompany_autoapprove', '1', 'goldcompany'),
('featuredresume_autoapprove', '1', 'featuredresume'),
('goldresume_autoapprove', '1', 'goldresume'),
('payment_method', 'paypal', 'payment'),
('payment_shopingurl', '', 'payment'),
('payment_successefulurl', '', 'payment'),
('payment_cancelurl', '', 'payment'),
('payment_paypalaccount', '', 'payment'),
('payment_showdescription', '1', 'payment'),
('payment_description', 'Description', 'payment'),
('payment_showfooter', '1', 'payment'),
('payment_currency', 'USD', 'payment'),
('payment_authtoken', '', 'payment'),
('payment_test_mode', '0', 'payment'),
('employer_defaultpackage', '', 'package'),
('jobseeker_defaultpackage', '', 'package'),
('date_format', 'Y-m-d', 'default'),
('adminemailaddress', 'admin@yahoo.com', 'email'),
('email_admin_new_company', '1', 'email'),
('email_admin_new_job', '1', 'email'),
('email_admin_new_resume', '1', 'email'),
('email_admin_job_apply', '1', 'email'),
('email_admin_new_department', '1', 'email'),
('email_admin_employer_package_purchase', '1', 'email'),
('email_admin_jobseeker_package_purchase', '1', 'email'),
('onlyonce_employer_getfreepackage', '1', 'package'),
('onlyonce_jobseeker_getfreepackage', '1', 'package'),
('employer_freepackage_autoapprove', '1', 'package'),
('jobseeker_freepackage_autoapprove', '1', 'package'),
('subcategories', '1', 'listjob'),
('categories_colsperrow', '3', 'default'),
('message_auto_approve', '1', 'messages'),
('conflict_message_auto_approve', '0', 'messages'),
('overwrite_jobalert_settings', '1', 'default'),
('visitor_can_apply_to_job', '0', 'default'),
('visitor_show_login_message', '1', 'default'),
('folder_auto_approve', '1', 'folder'),
('department_auto_approve', '1', 'department'),
('formcompany', '1', 'emcontrolpanel'),
('mycompanies', '1', 'emcontrolpanel'),
('formjob', '1', 'emcontrolpanel'),
('myjobs', '1', 'emcontrolpanel'),
('formdepartment', '1', 'emcontrolpanel'),
('mydepartment', '1', 'emcontrolpanel'),
('empmessages', '1', 'emcontrolpanel'),
('alljobsappliedapplications', '1', 'emcontrolpanel'),
('resumesearch', '1', 'emcontrolpanel'),
('my_resumesearches', '1', 'emcontrolpanel'),
('packages', '1', 'emcontrolpanel'),
('purchasehistory', '1', 'emcontrolpanel'),
('my_stats', '1', 'emcontrolpanel'),
('myfolders', '1', 'emcontrolpanel'),
('formresume', '1', 'jscontrolpanel'),
('myresumes', '1', 'jscontrolpanel'),
('formcoverletter', '1', 'jscontrolpanel'),
('mycoverletters', '1', 'jscontrolpanel'),
('jspackages', '1', 'jscontrolpanel'),
('jspurchasehistory', '1', 'jscontrolpanel'),
('jobalertsetting', '1', 'jscontrolpanel'),
('jobcat', '1', 'jscontrolpanel'),
('listnewestjobs', '1', 'jscontrolpanel'),
('myappliedjobs', '1', 'jscontrolpanel'),
('jobsearch', '1', 'jscontrolpanel'),
('my_jobsearches', '1', 'jscontrolpanel'),
('jsmy_stats', '1', 'jscontrolpanel'),
('jsmessages', '1', 'jscontrolpanel'),
('tmenu_emcontrolpanel', '1', 'default'),
('tmenu_emnewcompany', '1', 'default'),
('tmenu_emnewjob', '1', 'default'),
('tmenu_emmyjobs', '1', 'default'),
('tmenu_emmycompanies', '1', 'default'),
('tmenu_emsearchresume', '1', 'default'),
('tmenu_emnewdepartment', '1', 'default'),
('tmenu_emnewfolder', '1', 'default'),
('tmenu_jscontrolpanel', '1', 'default'),
('tmenu_jsjobcategory', '1', 'default'),
('tmenu_jssearchjob', '1', 'default'),
('tmenu_jsnewestjob', '1', 'default'),
('tmenu_jsmyresume', '1', 'default'),
('show_applied_resume_status', '1', 'default'),
('jobalert_auto_approve', '1', 'jobalert'),
('pagseguro_email', '1', 'payment'),
('lj_description', '1', 'listjob'),
('visitor_lj_description', '1', 'listjob'),
('max_resume_employers', '5', 'default'),
('max_resume_addresses', '5', 'default'),
('testing_mode', '1', 'default'),
('api_primary', 'a2d09c7d76fced01f8be4b1f4cce8bec', 'api'),
('api_secondary', '', 'api'),
('search_job_subcategory', '1', 'searchjob'),
('search_resume_subcategory', '1', 'searchresume'),
('comp_show_url', '1', 'default'),
('employerview_js_controlpanel', '1', 'default'),
('search_job_keywords', '1', 'searchjob'),
('vis_emformjob', '1', 'default'),
('vis_emresumesearch', '1', 'default'),
('vis_emmycompanies', '1', 'default'),
('vis_emalljobsappliedapplications', '1', 'default'),
('vis_emformcompany', '1', 'default'),
('tmenu_vis_emsearchresume', '1', 'default'),
('tmenu_vis_emmycompanies', '1', 'default'),
('tmenu_vis_emmyjobs', '1', 'default'),
('tmenu_vis_emnewjob', '1', 'default'),
('tmenu_vis_emcontrolpanel', '1', 'default'),
('vis_emmy_resumesearches', '1', 'default'),
('vis_emmyjobs', '1', 'default'),
('vis_empackages', '1', 'default'),
('vis_emformdepartment', '1', 'default'),
('vis_empurchasehistory', '1', 'default'),
('vis_emmydepartment', '1', 'default'),
('vis_emmy_stats', '1', 'default'),
('vis_emmessages', '1', 'default'),
('vis_emmyfolders', '1', 'default'),
('tmenu_vis_jscontrolpanel', '1', 'default'),
('tmenu_vis_jsjobcategory', '1', 'default'),
('tmenu_vis_jsnewestjob', '1', 'default'),
('tmenu_vis_jsmyresume', '1', 'default'),
('vis_jsformresume', '1', 'default'),
('vis_jsjobcat', '1', 'default'),
('vis_jsmyresumes', '1', 'default'),
('vis_jslistnewestjobs', '1', 'default'),
('vis_jsformcoverletter', '1', 'default'),
('vis_jsmyappliedjobs', '1', 'default'),
('vis_jsmycoverletters', '1', 'default'),
('vis_jspackages', '1', 'default'),
('vis_jsmy_jobsearches', '1', 'default'),
('vis_jspurchasehistory', '1', 'default'),
('vis_jsjobsearch', '1', 'default'),
('vis_jsmy_stats', '1', 'default'),
('vis_jsjobalertsetting', '1', 'default'),
('vis_jsmessages', '1', 'default'),
('tmenu_vis_jssearchjob', '1', 'default'),
('rss_job_title', 'Jobs RSS', 'rss'),
('rss_job_description', 'Job RSS Show the Latest Jobs On Our Sites', 'rss'),
('rss_job_categories', '1', 'rss'),
('rss_job_image', '1', 'rss'),
('rss_resume_categories', '1', 'rss'),
('rss_resume_image', '1', 'rss'),
('rss_resume_title', 'Resume RSS', 'rss'),
('rss_resume_description', 'Resume RSS Show the Latest Resume On Our Sites', 'rss'),
('rss_job_ttl', '12', 'rss'),
('rss_job_copyright', 'Copyright 2009-2012', 'rss'),
('rss_job_webmaster', 'admin@domain.com', 'rss'),
('rss_job_editor', 'admin@domain.com', 'rss'),
('rss_resume_copyright', '', 'rss'),
('rss_resume_webmaster', '', 'rss'),
('rss_resume_editor', '', 'rss'),
('rss_resume_ttl', '', 'rss'),
('rss_resume_file', '1', 'rss'),
('visitor_can_post_job', '1', 'default'),
('visitor_can_edit_job', '1', 'default'),
('job_captcha', '1', 'default'),
('resume_captcha', '1', 'default'),
('job_rss', '1', 'default'),
('resume_rss', '1', 'default'),
('empresume_rss', '1', 'default'),
('jsjob_rss', '1', 'default'),
('vis_resume_rss', '1', 'default'),
('vis_job_rss', '1', 'default'),
('default_longitude', '74.3833333', 'default'),
('default_latitude', '31.5166667', 'default'),
('search_job_coordinates', '1', 'searchjob'),
('vis_emresumebycategory', '1', 'default'),
('noofgoldjobsinlisting', '3', 'default'),
('nooffeaturedjobsinlisting', '2', 'default'),
('showgoldjobsinnewestjobs', '1', 'default'),
('showfeaturedjobsinnewestjobs', '1', 'default'),
('searchjobtag', '4', 'default'),
('googleadsenseclient', 'ca-pub-8827762976015158', 'default'),
('googleadsenseslot', '9560237528', 'default'),
('googleadsensewidth', '717', 'default'),
('googleadsenseheight', '90', 'default'),
('googleadsensecustomcss', '', 'default'),
('googleadsenseshowafter', '4', 'default'),
('googleadsenseshowinlistjobs', '0', 'default'),
('cron_job_alert_key', 'f1877c1756a68271d12db39ddc87dad7', 'default'),
('empexpire_package_message', '1', 'emcontrolpanel'),
('jsexpire_package_message', '1', 'jscontrolpanel'),
('defaultradius', '2', 'default'),
('max_resume_references', '5', 'default'),
('mapwidth', '500', 'default'),
('mapheight', '200', 'default'),
('comp_name', '1', 'default'),
('comp_email_address', '1', 'default'),
('max_resume_institutes', '5', 'default'),
('max_resume_languages', '5', 'default'),
('labelinlisting', '1', 'default'),
('jsregister', '1', 'jscontrolpanel'),
('vis_jsregister', '1', 'default'),
('empregister', '1', 'emcontrolpanel'),
('vis_emempregister', '1', 'default'),
('authentication_client_key', '', 'jobsharing'),
('search_resume_zipcode', '1', 'searchresume'),
('newlisting_requiredpackage', '0', 'default'),
('user_registration_captcha', '1', 'default'),
('js_newlisting_requiredpackage', '0', 'default'),
('jobseeker_share_fb_like', '1', 'social'),
('jobseeker_share_fb_share', '1', 'social'),
('jobseeker_share_fb_comments', '1', 'social'),
('jobseeker_share_google_like', '1', 'social'),
('jobseeker_share_google_share', '1', 'social'),
('jobseeker_share_blog_share', '1', 'social'),
('jobseeker_share_friendfeed_share', '1', 'social'),
('jobseeker_share_linkedin_share', '1', 'social'),
('jobseeker_share_twiiter_share', '1', 'social'),
('jobseeker_share_myspace_share', '1', 'social'),
('jobseeker_share_yahoo_share', '1', 'social'),
('jobseeker_share_digg_share', '1', 'social'),
('newfolders', '1', 'emcontrolpanel'),
('vis_emnewfolders', '0', 'default'),
('employer_resume_alert_fields', '1', 'email'),
('defaultaddressdisplaytype', 'csc', 'default'),
('jobseeker_defaultgroup', '', 'default'),
('employer_defaultgroup', '', 'default'),
('default_sharing_city', '', 'jobsharing'),
('default_sharing_state', '', 'jobsharing'),
('default_sharing_country', '', 'jobsharing'),
('job_alert_captcha', '1', 'default'),
('jobseeker_resume_applied_status', '1', 'email'),
('server_serial_number', '', 'jobsharing'),
('jsjobupdatecount', '32', 'default'),
('serialnumber', '', 'hostdata'),
('hostdata', '', 'hostdata'),
('zvdk', '', 'hostdata'),
('showapplybutton', '1', 'default'),
('applybuttonredirecturl', '', 'default'),
('image_file_type', 'gif,jpg,jpeg,png', 'default'),
('document_file_type', 'txt,doc,docx,Pdf,opt,rtf', 'default'),
('captchause', '1', 'default'),
('jobsloginlogout', '1', 'jscontrolpanel'),
('emploginlogout', '1', 'emcontrolpanel'),
('number_of_cities_for_autocomplete', '15', 'default'),
('visitor_can_add_resume', '0', 'default'),
('document_file_size', '500', 'default'),
('document_max_files', '5', 'default'),
('show_only_section_that_have_value', '0', 'resume'),
('email_jobseeker_package_purchase', '1', 'email'),
('email_employer_package_purchase', '1', 'email'),
('listjobbytype', '1', 'jscontrolpanel'),
('listallcompanies', '1', 'jscontrolpanel'),
('vis_jslistjobbytype', '1', 'default'),
('vis_jslistallcompanies', '1', 'default'),
('vis_jslistjobshortlist', '1', 'default'),
('listjobshortlist', '1', 'jscontrolpanel'),
('currency_align', '1', 'default'),
('search_resume_location', '1', 'searchresume'),
('newtyped_cities', '1', 'default'),
('companygoldexpiryindays', '30', 'company'),
('companyfeaturedexpiryindays', '30', 'company'),
('resumegoldexpiryindays', '30', 'resume'),
('resumefeaturedexpiryindays', '30', 'resume'),
('subcategory_limit', '5', 'default'), 
('jobs_graph', '1', 'emcontrolpanel'), 
('resume_graph', '1', 'emcontrolpanel'), 
('box_newestresume', '1', 'emcontrolpanel'), 
('box_appliedresume', '1', 'emcontrolpanel'), 
('mystuff_area', '1', 'emcontrolpanel'), 
('mystats_area', '1', 'emcontrolpanel'), 
('vis_jobs_graph', '1', 'emcontrolpanel'), 
('vis_resume_graph', '1', 'emcontrolpanel'), 
('vis_box_newestresume', '1', 'emcontrolpanel'), 
('vis_box_appliedresume', '1', 'emcontrolpanel'), 
('vis_mystuff_area', '1', 'emcontrolpanel'), 
('vis_mystats_area', '1', 'emcontrolpanel'), 
('jsactivejobs_graph', '1', 'jscontrolpanel'), 
('jsmystuff_area', '1', 'jscontrolpanel'), 
('jsmystats_area', '1', 'jscontrolpanel'), 
('jsnewestjobs_box', '1', 'jscontrolpanel'), 
('jsappliedresume_box', '1', 'jscontrolpanel'), 
('vis_jsactivejobs_graph', '1', 'jscontrolpanel'), 
('vis_jsmystuff_area', '1', 'jscontrolpanel'), 
('vis_jsmystats_area', '1', 'jscontrolpanel'), 
('vis_jsnewestjobs_box', '1', 'jscontrolpanel'), 
('vis_jsappliedresume_box', '1', 'jscontrolpanel'),
('search_job_reqiuredtravel', '1', 'searchjob'),
('search_job_gender', '1', 'searchjob'),
('search_job_education', '1', 'searchjob'),
('search_job_experience', '1', 'searchjob'),
('search_job_careerlevel', '1', 'searchjob'),
('search_job_workpermit', '1', 'searchjob'),
('google_map_api_key', 'AIzaSyCZcnAK0DiGg8lAXej74e7PlrhkfCM86-M', 'default'),
('last_version', '115', 'default'), 
('last_step_updater', '1170', 'default'),
('show_fe_goldjob_button', '1', 'job'), 
('show_fe_featuredjob_button', '1', 'job'),
('show_fe_goldcompany_button', '1', 'company'), 
('show_fe_featuredcompany_button', '1', 'company'),
('show_fe_goldresume_button', '1', 'resume'), 
('show_fe_featuredresume_button', '1', 'resume'),
('companydefaultlogopath', '', 'job'),
('showtotalnjobs', '1', 'default'),
('show_fe_tellafriend_button', '1', 'job'),
('visitorview_emp_resume', '1', 'default'),
('isenabled_virtuemart', '0', 'virtuemart'),
('vmjsbasic', 'CiAgICAgICAgJHF1ZXJ5ID0gIlNFTEVDVCBjb25maWd2YWx1ZSBGUk9NIGAjX19qc19qb2JfY29uZmlnYCBXSEVSRSBgY29uZmlnbmFtZWA9J3ZtanNsYSciOwogICAgICAgIA==', NULL),
('isenabled_jomsocial', '0', 'jomsocial'),
('jomsocial_postjob', '0', 'jomsocial'),
('jomsocial_postresume', '0', 'jomsocial'),
('jomsocial_postcompany', '0', 'jomsocial'),
('jmjsbasic', 'JHF1ZXJ5ID0gIlNFTEVDVCBjb25maWd2YWx1ZSBGUk9NIGAjX19qc19qb2JfY29uZmlnYCBXSEVSRSBgY29uZmlnbmFtZWA9J2ptanNsYSciOw==', NULL),
('jomsocial_allowpostcompany', '0', 'jomsocial'),
('jomsocial_allowpostjob', '0', 'jomsocial'),
('jomsocial_allowpostresume', '0', 'jomsocial'),
('company_seo', '[name][location]', 'seo'), 
('resume_seo', '[title][location]', 'seo'), 
('job_seo', '[title][company][location]', 'seo'),
('register_employer_redirect_page', '', 'register'),
('register_jobseeker_redirect_page', '', 'register'),
('default_login_from', '1', 'default'),
('vis_emuserdata_employer', '0', 'default'),
('vis_jsuserdata_jobseeker', '0', 'default'),
('userdata_employer', '1', 'emcontrolpanel'),
('userdata_jobseeker', '1', 'jscontrolpanel');



DROP TABLE IF EXISTS `#__js_job_countries`;
CREATE TABLE `#__js_job_countries` (
  `id` smallint(9) NOT NULL AUTO_INCREMENT,
  `name` varchar(40) DEFAULT NULL,
  `shortCountry` varchar(30) DEFAULT NULL,
  `continentID` tinyint(11) DEFAULT NULL,
  `dialCode` smallint(8) DEFAULT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT '0',
  `serverid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `name` (`name`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=215 ;
INSERT INTO `#__js_job_countries` (`id`, `name`, `shortCountry`, `continentID`, `dialCode`, `enabled`, `serverid`) VALUES(1, 'United States', 'US', 1, 1, 1, 0),(2, 'Canada', 'Canada', 1, 1, 1, 0),(3, 'Bahamas', 'Bahamas', 1, 242, 1, 0),(4, 'Barbados', 'Barbados', 1, 246, 1, 0),(5, 'Belize', 'Belize', 1, 501, 1, 0),(6, 'Bermuda', 'Bermuda', 1, 441, 1, 0),(7, 'British Virgin Islands', 'BVI', 1, 284, 1, 0),(8, 'Cayman Islands', 'CaymanIsl', 1, 345, 1, 0),(9, 'Costa Rica', 'CostaRica', 1, 506, 1, 0),(10, 'Cuba', 'Cuba', 1, 53, 1, 0),(11, 'Dominica', 'Dominica', 1, 767, 1, 0),(12, 'Dominican Republic', 'DominicanRep', 1, 809, 1, 0),(13, 'El Salvador', 'ElSalvador', 1, 503, 1, 0),(14, 'Greenland', 'Greenland', 1, 299, 1, 0),(15, 'Grenada', 'Grenada', 1, 473, 1, 0),(16, 'Guadeloupe', 'Guadeloupe', 1, 590, 1, 0),(17, 'Guatemala', 'Guatemala', 1, 502, 1, 0),(18, 'Haiti', 'Haiti', 1, 509, 1, 0),(19, 'Honduras', 'Honduras', 1, 503, 1, 0),(20, 'Jamaica', 'Jamaica', 1, 876, 1, 0),(21, 'Martinique', 'Martinique', 1, 596, 1, 0),(22, 'Mexico', 'Mexico', 1, 52, 1, 0),(23, 'Montserrat', 'Montserrat', 1, 664, 1, 0),(24, 'Nicaragua', 'Nicaragua', 1, 505, 1, 0),(25, 'Panama', 'Panama', 1, 507, 1, 0),(26, 'Puerto Rico', 'PuertoRico', 1, 787, 1, 0),(27, 'Trinidad and Tobago', 'Trinidad-Tobago', 1, 868, 1, 0),(28, 'United States Virgin Islands', 'USVI', 1, 340, 1, 0),(29, 'Argentina', 'Argentina', 2, 54, 1, 0),(30, 'Bolivia', 'Bolivia', 2, 591, 1, 0),(31, 'Brazil', 'Brazil', 2, 55, 1, 0),(32, 'Chile', 'Chile', 2, 56, 1, 0),(33, 'Colombia', 'Colombia', 2, 57, 1, 0),(34, 'Ecuador', 'Ecuador', 2, 593, 1, 0),(35, 'Falkland Islands', 'FalklandIsl', 2, 500, 1, 0),(36, 'French Guiana', 'FrenchGuiana', 2, 594, 1, 0),(37, 'Guyana', 'Guyana', 2, 592, 1, 0),(38, 'Paraguay', 'Paraguay', 2, 595, 1, 0),(39, 'Peru', 'Peru', 2, 51, 1, 0),(40, 'Suriname', 'Suriname', 2, 597, 1, 0),(41, 'Uruguay', 'Uruguay', 2, 598, 1, 0),(42, 'Venezuela', 'Venezuela', 2, 58, 1, 0),(43, 'Albania', 'Albania', 3, 355, 1, 0),(44, 'Andorra', 'Andorra', 3, 376, 1, 0),(45, 'Armenia', 'Armenia', 3, 374, 1, 0),(46, 'Austria', 'Austria', 3, 43, 1, 0),(47, 'Azerbaijan', 'Azerbaijan', 3, 994, 1, 0),(48, 'Belarus', 'Belarus', 3, 375, 1, 0),(49, 'Belgium', 'Belgium', 3, 32, 1, 0),(50, 'Bosnia and Herzegovina', 'Bosnia-Herzegovina', 3, 387, 1, 0),(51, 'Bulgaria', 'Bulgaria', 3, 359, 1, 0),(52, 'Croatia', 'Croatia', 3, 385, 1, 0),(53, 'Cyprus', 'Cyprus', 3, 357, 1, 0),(54, 'Czech Republic', 'CzechRep', 3, 420, 1, 0),(55, 'Denmark', 'Denmark', 3, 45, 1, 0),(56, 'Estonia', 'Estonia', 3, 372, 1, 0),(57, 'Finland', 'Finland', 3, 358, 1, 0),(58, 'France', 'France', 3, 33, 1, 0),(59, 'Georgia', 'Georgia', 3, 995, 1, 0),(60, 'Germany', 'Germany', 3, 49, 1, 0),(61, 'Gibraltar', 'Gibraltar', 3, 350, 1, 0),(62, 'Greece', 'Greece', 3, 30, 1, 0),(63, 'Guernsey', 'Guernsey', 3, 44, 1, 0),(64, 'Hungary', 'Hungary', 3, 36, 1, 0),(65, 'Iceland', 'Iceland', 3, 354, 1, 0),(66, 'Ireland', 'Ireland', 3, 353, 1, 0),(67, 'Isle of Man', 'IsleofMan', 3, 44, 1, 0),(68, 'Italy', 'Italy', 3, 39, 1, 0),(69, 'Jersey', 'Jersey', 3, 44, 1, 0),(70, 'Kosovo', 'Kosovo', 3, 381, 1, 0),(71, 'Latvia', 'Latvia', 3, 371, 1, 0),(72, 'Liechtenstein', 'Liechtenstein', 3, 423, 1, 0),(73, 'Lithuania', 'Lithuania', 3, 370, 1, 0),(74, 'Luxembourg', 'Luxembourg', 3, 352, 1, 0),(75, 'Macedonia', 'Macedonia', 3, 389, 1, 0),(76, 'Malta', 'Malta', 3, 356, 1, 0),(77, 'Moldova', 'Moldova', 3, 373, 1, 0),(78, 'Monaco', 'Monaco', 3, 377, 1, 0),(79, 'Montenegro', 'Montenegro', 3, 381, 1, 0),(80, 'Netherlands', 'Netherlands', 3, 31, 1, 0),(81, 'Norway', 'Norway', 3, 47, 1, 0),(82, 'Poland', 'Poland', 3, 48, 1, 0),(83, 'Portugal', 'Portugal', 3, 351, 1, 0),(84, 'Romania', 'Romania', 3, 40, 1, 0),(85, 'Russia', 'Russia', 3, 7, 1, 0),(86, 'San Marino', 'SanMarino', 3, 378, 1, 0),(87, 'Serbia', 'Serbia', 3, 381, 1, 0),(88, 'Slovakia', 'Slovakia', 3, 421, 1, 0),(89, 'Slovenia', 'Slovenia', 3, 386, 1, 0),(90, 'Spain', 'Spain', 3, 34, 1, 0),(91, 'Sweden', 'Sweden', 3, 46, 1, 0),(92, 'Switzerland', 'Switzerland', 3, 41, 1, 0),(93, 'Turkey', 'Turkey', 3, 90, 1, 0),(94, 'Ukraine', 'Ukraine', 3, 380, 1, 0),(95, 'United Kingdom', 'UK', 3, 44, 1, 0),(96, 'Vatican City', 'Vatican', 3, 39, 1, 0),(97, 'Afghanistan', 'Afghanistan', 4, 93, 1, 0),(98, 'Bahrain', 'Bahrain', 4, 973, 1, 0),(99, 'Bangladesh', 'Bangladesh', 4, 880, 1, 0),(100, 'Bhutan', 'Bhutan', 4, 975, 1, 0),(101, 'Brunei', 'Brunei', 4, 673, 1, 0),(102, 'Cambodia', 'Cambodia', 4, 855, 1, 0),(103, 'China', 'China', 4, 86, 1, 0),(104, 'East Timor', 'EastTimor', 4, 670, 1, 0),(105, 'Hong Kong', 'HongKong', 4, 852, 1, 0),(106, 'India', 'India', 4, 91, 1, 0),(107, 'Indonesia', 'Indonesia', 4, 62, 1, 0),(108, 'Iran', 'Iran', 4, 98, 1, 0),(109, 'Iraq', 'Iraq', 4, 964, 1, 0),(110, 'Israel', 'Israel', 4, 972, 1, 0),(111, 'Japan', 'Japan', 4, 81, 1, 0),(112, 'Jordan', 'Jordan', 4, 962, 1, 0),(113, 'Kazakhstan', 'Kazakhstan', 4, 7, 1, 0),(114, 'Kuwait', 'Kuwait', 4, 965, 1, 0),(115, 'Kyrgyzstan', 'Kyrgyzstan', 4, 996, 1, 0),(116, 'Laos', 'Laos', 4, 856, 1, 0),(117, 'Lebanon', 'Lebanon', 4, 961, 1, 0),(118, 'Macau', 'Macau', 4, 853, 1, 0),(119, 'Malaysia', 'Malaysia', 4, 60, 1, 0),(120, 'Maldives', 'Maldives', 4, 960, 1, 0),(121, 'Mongolia', 'Mongolia', 4, 976, 1, 0),(122, 'Myanmar (Burma)', 'Myanmar(Burma)', 4, 95, 1, 0),(123, 'Nepal', 'Nepal', 4, 977, 1, 0),(124, 'North Korea', 'NorthKorea', 4, 850, 1, 0),(125, 'Oman', 'Oman', 4, 968, 1, 0),(126, 'Pakistan', 'Pakistan', 4, 92, 1, 0),(127, 'Philippines', 'Philippines', 4, 63, 1, 0),(128, 'Qatar', 'Qatar', 4, 974, 1, 0),(129, 'Saudi Arabia', 'SaudiArabia', 4, 966, 1, 0),(130, 'Singapore', 'Singapore', 4, 65, 1, 0),(131, 'South Korea', 'SouthKorea', 4, 82, 1, 0),(132, 'Sri Lanka', 'SriLanka', 4, 94, 1, 0),(133, 'Syria', 'Syria', 4, 963, 1, 0),(134, 'Taiwan', 'Taiwan', 4, 886, 1, 0),(135, 'Tajikistan', 'Tajikistan', 4, 992, 1, 0),(136, 'Thailand', 'Thailand', 4, 66, 1, 0),(137, 'Turkmenistan', 'Turkmenistan', 4, 993, 1, 0),(138, 'United Arab Emirates', 'UAE', 4, 971, 1, 0),(139, 'Uzbekistan', 'Uzbekistan', 4, 998, 1, 0),(140, 'Vietnam', 'Vietnam', 4, 84, 1, 0),(141, 'Yemen', 'Yemen', 4, 967, 1, 0),(142, 'Algeria', 'Algeria', 5, 213, 1, 0),(143, 'Angola', 'Angola', 5, 244, 1, 0),(144, 'Benin', 'Benin', 5, 229, 1, 0),(145, 'Botswana', 'Botswana', 5, 267, 1, 0),(146, 'Burkina Faso', 'BurkinaFaso', 5, 226, 1, 0),(147, 'Burundi', 'Burundi', 5, 257, 1, 0),(148, 'Cameroon', 'Cameroon', 5, 237, 1, 0),(149, 'Cape Verde', 'CapeVerde', 5, 238, 1, 0),(150, 'Central African Republic', 'CentralAfricanRep', 5, 236, 1, 0),(151, 'Chad', 'Chad', 5, 235, 1, 0),(152, 'Congo', 'Congo', 5, 242, 1, 0),(153, 'Democoratic Republic of Congo', 'D.R Congo', 5, 242, 1, 0),(154, 'Djibouti', 'Djibouti', 5, 253, 1, 0),(155, 'Egypt', 'Egypt', 5, 20, 1, 0),(156, 'Equatorial Guinea', 'EquatorialGuinea', 5, 240, 1, 0),(157, 'Eritrea', 'Eritrea', 5, 291, 1, 0),(158, 'Ethiopia', 'Ethiopia', 5, 251, 1, 0),(159, 'Gabon', 'Gabon', 5, 241, 1, 0),(160, 'Gambia', 'Gambia', 5, 220, 1, 0),(161, 'Ghana', 'Ghana', 5, 233, 1, 0),(162, 'Guinea', 'Guinea', 5, 224, 1, 0),(163, 'Guinea-Bissau', 'Guinea-Bissau', 5, 245, 1, 0),(164, 'Cote DIvory', 'IvoryCoast', 5, 225, 1, 0),(165, 'Kenya', 'Kenya', 5, 254, 1, 0),(166, 'Lesotho', 'Lesotho', 5, 266, 1, 0),(167, 'Liberia', 'Liberia', 5, 231, 1, 0),(168, 'Libya', 'Libya', 5, 218, 1, 0),(169, 'Madagascar', 'Madagascar', 5, 261, 1, 0),(170, 'Malawi', 'Malawi', 5, 265, 1, 0),(171, 'Mali', 'Mali', 5, 223, 1, 0),(172, 'Mauritania', 'Mauritania', 5, 222, 1, 0),(173, 'Mauritius', 'Mauritius', 5, 230, 1, 0),(174, 'Morocco', 'Morocco', 5, 212, 1, 0),(175, 'Mozambique', 'Mozambique', 5, 258, 1, 0),(176, 'Namibia', 'Namibia', 5, 264, 1, 0),(177, 'Niger', 'Niger', 5, 227, 1, 0),(178, 'Nigeria', 'Nigeria', 5, 234, 1, 0),(179, 'Reunion', 'Reunion', 5, 262, 1, 0),(180, 'Rwanda', 'Rwanda', 5, 250, 1, 0),(181, 'Sao Tome and Principe', 'SaoTome-Principe', 5, 239, 1, 0),(182, 'Senegal', 'Senegal', 5, 221, 1, 0),(183, 'Seychelles', 'Seychelles', 5, 248, 1, 0),(184, 'Sierra Leone', 'SierraLeone', 5, 232, 1, 0),(185, 'Somalia', 'Somalia', 5, 252, 1, 0),(186, 'South Africa', 'SouthAfrica', 5, 27, 1, 0),(187, 'Sudan', 'Sudan', 5, 249, 1, 0),(188, 'Swaziland', 'Swaziland', 5, 268, 1, 0),(189, 'Tanzania', 'Tanzania', 5, 255, 1, 0),(190, 'Togo', 'Togo', 5, 228, 1, 0),(191, 'Tunisia', 'Tunisia', 5, 216, 1, 0),(192, 'Uganda', 'Uganda', 5, 256, 1, 0),(193, 'Western Sahara', 'WesternSahara', 5, 212, 1, 0),(194, 'Zambia', 'Zambia', 5, 260, 1, 0),(195, 'Zimbabwe', 'Zimbabwe', 5, 263, 1, 0),(196, 'Australia', 'Australia', 6, 61, 1, 0),(197, 'New Zealand', 'NewZealand', 6, 64, 1, 0),(198, 'Fiji', 'Fiji', 6, 679, 1, 0),(199, 'French Polynesia', 'FrenchPolynesia', 6, 689, 1, 0),(200, 'Guam', 'Guam', 6, 671, 1, 0),(201, 'Kiribati', 'Kiribati', 6, 686, 1, 0),(202, 'Marshall Islands', 'MarshallIsl', 6, 692, 1, 0),(203, 'Micronesia', 'Micronesia', 6, 691, 1, 0),(204, 'Nauru', 'Nauru', 6, 674, 1, 0),(205, 'New Caledonia', 'NewCaledonia', 6, 687, 1, 0),(206, 'Papua New Guinea', 'PapuaNewGuinea', 6, 675, 1, 0),(207, 'Samoa', 'Samoa', 6, 684, 1, 0),(208, 'Solomon Islands', 'SolomonIsl', 6, 677, 1, 0),(209, 'Tonga', 'Tonga', 6, 676, 1, 0),(210, 'Tuvalu', 'Tuvalu', 6, 688, 1, 0),(211, 'Vanuatu', 'Vanuatu', 6, 678, 1, 0),(212, 'Wallis and Futuna', 'Wallis-Futuna', 6, 681, 1, 0),(213, 'Comoros', 'Comoros', 0, 0, 1, 0),(214, 'Cote DIvorie', 'Cote-DIvorie', NULL, NULL, 1, 0);

DROP TABLE IF EXISTS `#__js_job_coverletters`;
CREATE TABLE `#__js_job_coverletters` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL,
  `title` varchar(300) NOT NULL,
  `alias` varchar(225) NOT NULL,
  `description` text NOT NULL,
  `hits` int(11) DEFAULT NULL,
  `published` tinyint(1) DEFAULT NULL,
  `searchable` tinyint(1) DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `packageid` int(11) DEFAULT NULL,
  `paymenthistoryid` int(11) DEFAULT NULL,
  `serverstatus` varchar(255) DEFAULT NULL,
  `serverid` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `coverletter_uid` (`uid`),
  KEY `coverletter_packgeid` (`packageid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `#__js_job_currencies`;
CREATE TABLE `#__js_job_currencies` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(60) DEFAULT NULL,
  `symbol` varchar(60) DEFAULT NULL,
  `code` varchar(10) NOT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `default` tinyint(1) DEFAULT NULL,
  `ordering` int(11) DEFAULT NULL,
  `serverid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
INSERT INTO `#__js_job_currencies` (`id`, `title`, `symbol`, `code`, `status`, `default`, `ordering`, `serverid`) VALUES(1, 'US Doller', '$', 'USD', 1, 1, 1, 0),(2, 'Pakistani Rupee', 'Rs.', 'PKR', 1, 0, 2, 0),(3, 'Pound', '£', 'GBP', 1, 0, 3, 0),(4, 'Euro', ' €', 'EUR', 1, 0, 4, 0);

DROP TABLE IF EXISTS `#__js_job_departments`;
CREATE TABLE `#__js_job_departments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL,
  `companyid` int(11) NOT NULL,
  `name` varchar(70) NOT NULL,
  `alias` varchar(225) NOT NULL,
  `description` text DEFAULT NULL,
  `status` tinyint(4) NOT NULL,
  `created` datetime NOT NULL,
  `serverstatus` varchar(255) DEFAULT NULL,
  `serverid` int(11) DEFAULT '0',
  PRIMARY KEY (`id`,`companyid`),
  KEY `departments` (`companyid`),
  KEY `departments_uid` (`uid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `#__js_job_emailtemplates`;
CREATE TABLE `#__js_job_emailtemplates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) DEFAULT NULL,
  `templatefor` varchar(50) DEFAULT NULL,
  `title` varchar(50) DEFAULT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `body` text DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=20 ;
INSERT INTO `#__js_job_emailtemplates` (`id`, `uid`, `templatefor`, `title`, `subject`, `body`, `status`, `created`) VALUES(1, 0, 'company-approval', NULL, 'Company {COMPANY_NAME} has been approved', '<div style="background: #6DC6DD; height: 20px;">Â </div>\n<p style="color: #2191ad;">Dear {EMPLOYER_NAME} ,</p>\n<p style="color: #4f4f4f;">Your company <strong>{COMPANY_NAME}</strong> has been approved.</p>\n<p style="color: #4f4f4f;">Click here to view {COMPANY_LINK}.</p>\n<div style="margin-top: 10px; padding: 10px 20px; color: #000000; background: #FAF2F2; border: 1px solid #F7C1C1;">\n<p><span style="color: red;"><strong>*DO NOT REPLY TO THIS E-MAIL*</strong></span><br /> It is automatically generated and is for information purposes only.</p>\n</div>', 1, '2009-08-17 18:08:41'),(2, 0, 'company-rejecting', NULL, 'Your Company {COMPANY_NAME} has been rejected', '<div style="background: #6DC6DD; height: 20px;">Â </div>\r\n<p style="color: #2191ad;">Dear {EMPLOYER_NAME} ,</p>\r\n<p style="color: #4f4f4f;">Your company <strong>{COMPANY_NAME}</strong> has been rejected.</p>\r\n<p style="color: #4f4f4f;">Click here to view {COMPANY_LINK}.</p>\r\n<p style="color: #4f4f4f;">Login and view detail at</p>\r\n<div style="margin-top: 10px; padding: 10px 20px; color: #000000; background: #FAF2F2; border: 1px solid #F7C1C1;">\r\n<p><span style="color: red;"><strong>*DO NOT REPLY TO THIS E-MAIL*</strong></span><br /> It is automatically generated and is for information purposes only.</p>\r\n</div>', NULL, '2009-08-17 17:54:48'),(4, 0, 'job-approval', NULL, 'Your job {JOB_TITLE} has been approved.', '<div style="background: #6DC6DD; height: 20px;">Â </div>\r\n<p style="color: #2191ad;">Dear {EMPLOYER_NAME} ,</p>\r\n<p style="color: #4f4f4f;">Your job <strong>{JOB_TITLE}</strong> has been approved.</p>\r\n<p style="color: #4f4f4f;">Click here to view {JOB_LINK}.</p>\r\n<p style="color: #4f4f4f;">Login and view detail at</p>\r\n<div style="margin-top: 10px; padding: 10px 20px; color: #000000; background: #FAF2F2; border: 1px solid #F7C1C1;">\r\n<p><span style="color: red;"><strong>*DO NOT REPLY TO THIS E-MAIL*</strong></span><br /> It is automatically generated and is for information purposes only.</p>\r\n</div>', NULL, '2009-08-17 22:10:27'),(5, 0, 'job-rejecting', NULL, 'Your job {JOB_TITLE} has been rejected.', '<div style="background: #6DC6DD; height: 20px;">Â </div>\r\n<p style="color: #2191ad;">Dear {EMPLOYER_NAME} ,</p>\r\n<p style="color: #4f4f4f;">Your job <strong>{JOB_TITLE}</strong> has been rejected.</p>\r\n<p style="color: #4f4f4f;">Click here to view {JOB_LINK}.</p>\r\n<p style="color: #4f4f4f;">Login and view detail at</p>\r\n<div style="margin-top: 10px; padding: 10px 20px; color: #000000; background: #FAF2F2; border: 1px solid #F7C1C1;">\r\n<p><span style="color: red;"><strong>*DO NOT REPLY TO THIS E-MAIL*</strong></span><br /> It is automatically generated and is for information purposes only.</p>\r\n</div>', NULL, '2009-08-17 22:12:43'),(6, 0, 'resume-approval', NULL, 'Your resume {RESUME_TITLE} has been approval.', '<div style="background: #6DC6DD; height: 20px;">Â </div>\r\n<p style="color: #2191ad;">Dear {JOBSEEKER_NAME} ,</p>\r\n<p style="color: #4f4f4f;">Your resume <strong>{RESUME_TITLE}</strong> has been approval.</p>\r\n<p style="color: #4f4f4f;">Click here to view {RESUME_LINK}.</p>\r\n<p style="color: #4f4f4f;">Login and view detail at</p>\r\n<div style="margin-top: 10px; padding: 10px 20px; color: #000000; background: #FAF2F2; border: 1px solid #F7C1C1;">\r\n<p><span style="color: red;"><strong>*DO NOT REPLY TO THIS E-MAIL*</strong></span><br /> It is automatically generated and is for information purposes only.</p>\r\n</div>', NULL, '2009-08-17 22:15:12'),(7, 0, 'resume-rejecting', NULL, 'Your resume {RESUME_TITLE} has been rejected. ', '<div style="background: #6DC6DD; height: 20px;">Â </div>\r\n<p style="color: #2191ad;">Dear {JOBSEEKER_NAME} ,</p>\r\n<p style="color: #4f4f4f;">Your resume <strong>{RESUME_TITLE}</strong> has been rejected.</p>\r\n<p style="color: #4f4f4f;">Click here to view {RESUME_LINK}.</p>\r\n<p style="color: #4f4f4f;">Login and view detail at</p>\r\n<div style="margin-top: 10px; padding: 10px 20px; color: #000000; background: #FAF2F2; border: 1px solid #F7C1C1;">\r\n<p><span style="color: red;"><strong>*DO NOT REPLY TO THIS E-MAIL*</strong></span><br /> It is automatically generated and is for information purposes only.</p>\r\n</div>', NULL, '2009-08-17 22:14:52'),(8, 0, 'jobapply-jobapply', NULL, 'JS Jobs :  {JOBSEEKER_NAME} apply for {JOB_TITLE}', '<div style="background: #6DC6DD; height: 20px;">Â </div>\r\n<p style="color: #2191ad;">Hello {EMPLOYER_NAME} ,</p>\r\n<p style="color: #4f4f4f;">Mr/Mrs {JOBSEEKER_NAME} apply for {JOB_TITLE}.</p>\r\n<p style="color: #4f4f4f;">Click here to view {RESUME_LINK} .</p>\r\n<p>{RESUME_DATA}</p>\r\n<div style="margin-top: 10px; padding: 10px 20px; color: #000000; background: #FAF2F2; border: 1px solid #F7C1C1;">\r\n<p><span style="color: red;"><strong>*DO NOT REPLY TO THIS E-MAIL*</strong></span><br /> It is automatically generated and is for information purposes only.</p>\r\n</div>', NULL, '2009-08-18 16:46:16'),(9, 0, 'company-new', NULL, 'JS Jobs : New Company {COMPANY_NAME} has beed received', '<div style="background: #6DC6DD; height: 20px;">Â </div>\r\n<p style="color: #2191ad;">Hello Admin ,</p>\r\n<p style="color: #4f4f4f;">We receive new company.</p>\r\n<p style="color: #4f4f4f;">Click here to view {COMPANY_LINK}.</p>\r\n<div style="margin-top: 10px; padding: 10px 20px; color: #000000; background: #FAF2F2; border: 1px solid #F7C1C1;">\r\n<p><span style="color: red;"><strong>*DO NOT REPLY TO THIS E-MAIL*</strong></span><br />This is an automated e-mail message sent from our support system. Do not reply to this e-mail as we wonot receive your reply!</p>\r\n</div>', NULL, '2009-08-18 16:46:16'),(10, 0, 'job-new', NULL, 'JS Jobs : New Job {JOB_TITLE} has beed received', '<div style="background: #6DC6DD; height: 20px;">Â </div>\r\n<p style="color: #2191ad;">Hello Admin ,</p>\r\n<p style="color: #4f4f4f;">We receive new job.</p>\r\n<p style="color: #4f4f4f;">Click here to viewÂ  {JOB_LINK}.</p>\r\n<div style="margin-top: 10px; padding: 10px 20px; color: #000000; background: #FAF2F2; border: 1px solid #F7C1C1;">\r\n<p><span style="color: red;"><strong>*DO NOT REPLY TO THIS E-MAIL*</strong></span><br />This is an automated e-mail message sent from our support system. Do not reply to this e-mail as we wonot receive your reply!</p>\r\n</div>', NULL, '2009-08-18 16:46:16'),(11, 0, 'resume-new', NULL, 'JS Jobs :  New resume {RESUME_TITLE} has beed received', '<div style="background: #6DC6DD; height: 20px;">Â </div>\r\n<p style="color: #2191ad;">Hello Admin ,</p>\r\n<p style="color: #4f4f4f;">We receive new resume.</p>\r\n<p style="color: #4f4f4f;">Click here to view {RESUME_LINK}.</p>\r\n<div style="margin-top: 10px; padding: 10px 20px; color: #000000; background: #FAF2F2; border: 1px solid #F7C1C1;">\r\n<p><span style="color: red;"><strong>*DO NOT REPLY TO THIS E-MAIL*</strong></span><br />This is an automated e-mail message sent from our support system. Do not reply to this e-mail as we wonot receive your reply!</p>\r\n</div>', NULL, '2009-08-18 16:46:16'),(12, 0, 'department-new', NULL, 'JS Jobs : New Department {DEPARTMENT_NAME} {COMPANY_NAME} has beed received', '<div style="background: #6DC6DD; height: 20px;">Â </div>\r\n<p style="color: #2191ad;">Hello Admin ,</p>\r\n<p style="color: #4f4f4f;">We receive new department.</p>\r\n<p style="color: #4f4f4f;">Login and view detail at</p>\r\n<div style="margin-top: 10px; padding: 10px 20px; color: #000000; background: #FAF2F2; border: 1px solid #F7C1C1;">\r\n<p><span style="color: red;"><strong>*DO NOT REPLY TO THIS E-MAIL*</strong></span><br /> It is automatically generated and is for information purposes only.</p>\r\n</div>', NULL, '2009-08-18 16:46:16'),(13, 0, 'employer-buypackage', NULL, 'JS Jobs : Employer Buy Package {PACKAGE_NAME}', '<div style="background: #6DC6DD; height: 20px;">Â </div>\r\n<p style="color: #2191ad;">Hello Admin ,</p>\r\n<p style="color: #4f4f4f;">Employer buy a package.</p>\r\n<p style="color: #4f4f4f;">Click here to view {PACKAGE_LINK}.</p>\r\n<p style="color: #4f4f4f;">Login and view detail.</p>\r\n<div style="margin-top: 10px; padding: 10px 20px; color: #000000; background: #FAF2F2; border: 1px solid #F7C1C1;">\r\n<p><span style="color: red;"><strong>*DO NOT REPLY TO THIS E-MAIL*</strong></span><br /> It is automatically generated and is for information purposes only.</p>\r\n</div>', NULL, '2009-08-18 16:46:16'),(14, 0, 'jobseeker-buypackage', NULL, 'JS Jobs : Jobseeker Buy Package {PACKAGE_NAME}', '<div style="background: #6DC6DD; height: 20px;">Â </div>\r\n<p style="color: #2191ad;">Hello Admin ,</p>\r\n<p style="color: #4f4f4f;">Job Seeker buy package.</p>\r\n<p style="color: #4f4f4f;">Click here to view {PACKAGE_LINK}.</p>\r\n<p style="color: #4f4f4f;">Login and view detail at</p>\r\n<div style="margin-top: 10px; padding: 10px 20px; color: #000000; background: #FAF2F2; border: 1px solid #F7C1C1;">\r\n<p><span style="color: red;"><strong>*DO NOT REPLY TO THIS E-MAIL*</strong></span><br /> It is automatically generated and is for information purposes only.</p>\r\n</div>', NULL, '2009-08-18 16:46:16'),(15, 0, 'message-email', NULL, 'JS Jobs: New Message Alert', '<div style="background: #6DC6DD; height: 20px;">Â </div>\r\n<p style="color: #2191ad;">Dear {NAME},</p>\r\n<p style="color: #4f4f4f;">{SENDER_NAME}: send you new message.</p>\r\n<div style="display: block; padding: 20px; color: #4f4f4f; background: #F5FEFF; border: 1px solid #B7EAF7;">\r\n<p><strong><span style="text-decoration: underline;">Summary</span></strong></p>\r\n<p>Company Name: {COMPANY_NAME}</p>\r\n<p>Job Title: {JOB_TITLE}</p>\r\n<p>Resume Title: {RESUME_TITLE}</p>\r\n<p>Subject: {SUBJECT}</p>\r\n<p>Message: {MESSAGE}</p>\r\n</div>\r\n<div style="margin-top: 10px; padding: 10px 20px; color: #000000; background: #FAF2F2; border: 1px solid #F7C1C1;">\r\n<p><span style="color: red;"><strong>*DO NOT REPLY TO THIS E-MAIL*</strong></span><br />This is an automated e-mail message sent from our support system. Do not reply to this e-mail as we wonot receive your reply!</p>\r\n</div>', 1, '2009-08-18 16:46:16'),(16, 0, 'job-alert', NULL, 'JS Jobs: New Job', '<div style="background: #6DC6DD; height: 20px;">Â </div>\r\n<p style="color: #2191ad;">Dear {JOBSEEKER_NAME} ,</p>\r\n<p style="color: #4f4f4f;">We receive new job.</p>\r\n<p>{JOBS_INFO}</p>\r\n<p style="color: #4f4f4f;">Login and view detail at</p>\r\n<div style="margin-top: 10px; padding: 10px 20px; color: #000000; background: #FAF2F2; border: 1px solid #F7C1C1;">\r\n<p><span style="color: red;"><strong>*DO NOT REPLY TO THIS E-MAIL*</strong></span><br /> It is automatically generated and is for information purposes only.</p>\r\n</div>', NULL, '2011-03-31 16:46:16'),(17, 0, 'job-alert-visitor', NULL, 'JS Jobs: New Job By Visitor', '<div style="background: #6DC6DD; height: 20px;">Â </div>\r\n<p style="color: #2191ad;">Dear {CONTACT_NAME} ,</p>\r\n<p style="color: #4f4f4f;">We receive new job</p>\r\n<div style="display: block; padding: 20px; color: #4f4f4f; background: #F5FEFF; border: 1px solid #B7EAF7;">\r\n<p><strong><span style="text-decoration: underline;">Summary</span></strong></p>\r\n<p>Title: {JOB_TITLE}</p>\r\n<p>Job Category: {JOB_CATEGORY}</p>\r\n<p>Company Name: {COMPANY_NAME}</p>\r\n<p>Status: {JOB_STATUS}</p>\r\n</div>\r\n<div style="margin-top: 10px; padding: 10px 20px; color: #000000; background: #FAF2F2; border: 1px solid #F7C1C1;">\r\n<p><span style="color: red;"><strong>*DO NOT REPLY TO THIS E-MAIL*</strong></span><br />This is an automated e-mail message sent from our support system. Do not reply to this e-mail as we wonot receive your reply!</p>\r\n</div>', NULL, '2011-03-31 16:46:16'),(18, 0, 'job-to-friend', NULL, 'JS Jobs : Your friend find a job', '<div style="background: #6DC6DD; height: 20px;">Â </div>\r\n<p style="color: #2191ad;">Dear</p>\r\n<p style="color: #4f4f4f;">Your Friend {SENDER_NAME} will send you this mail through our site {SITE_NAME} to inform you for a job.</p>\r\n<div style="display: block; padding: 20px; color: #4f4f4f; background: #F5FEFF; border: 1px solid #B7EAF7;">\r\n<p><strong><span style="text-decoration: underline;">Summary</span></strong></p>\r\n<p>Title: {JOB_TITLE}</p>\r\n<p>Category {JOB_CATEGORY}</p>\r\n<p>Company : {COMPANY_NAME}</p>\r\n<p>{CLICK_HERE_TO_VISIT} the job detail.</p>\r\n<p>{SENDER_MESSAGE}</p>\r\n<p>Thank you.</p>\r\n</div>\r\n<div style="margin-top: 10px; padding: 10px 20px; color: #000000; background: #FAF2F2; border: 1px solid #F7C1C1;">\r\n<p><span style="color: red;"><strong>*DO NOT REPLY TO THIS E-MAIL*</strong></span><br />This is an automated e-mail message sent from our support system. Do not reply to this e-mail as we wonot receive your reply!</p>\r\n</div>', 1, '2011-03-31 16:46:16'),(19, 0, 'applied-resume_status', NULL, 'JS Jobs : Your applied resume status update', '<div style="background: #6DC6DD; height: 20px;">Â </div>\r\n<p style="color: #2191ad;">Dear{JOBSEEKER_NAME}</p>\r\n<p style="color: #4f4f4f;">You are applied for jobÂ  {JOB_TITLE}.</p>\r\n<p style="color: #4f4f4f;">Your resume has been mark as {RESUME_STATUS}.</p>\r\n<div>Click here to view {STATUS} .<br />\r\n<p>Thank you.</p>\r\n</div>\r\n<div style="margin-top: 10px; padding: 10px 20px; color: #000000; background: #FAF2F2; border: 1px solid #F7C1C1;">\r\n<p><span style="color: red;"><strong>*DO NOT REPLY TO THIS E-MAIL*</strong></span><br />This is an automated e-mail message sent from our support system. Do not reply to this e-mail as we can''"t receive your reply!</p>\r\n</div>', 1, '2011-03-31 16:46:16'),(20, 420, 'jobseeker-packagepurchase', NULL, 'JS Jobs : You have ordered {PACKAGE_TITLE}', '<div style="background: #6DC6DD; height: 20px;">Â </div>\r\n<p style="color: #2191ad;">Dear {JOBSEEKER_NAME}</p>\r\n<p style="color: #4f4f4f;">You have orderedÂ  {PACKAGE_TITLE}..</p>\r\n<p style="color: #4f4f4f;">Now you will be awarded all the facilities which we given in the above package, after the payment status verified.</p>\r\n<p style="color: #4f4f4f;">Payment Status {PAYMENT_STATUS}</p>\r\n<div>Click here to view {LINK} .<br />\r\n<p>Thank you.</p>\r\n</div>\r\n<div style="margin-top: 10px; padding: 10px 20px; color: #000000; background: #FAF2F2; border: 1px solid #F7C1C1;">\r\n<p><span style="color: red;"><strong>*DO NOT REPLY TO THIS E-MAIL*</strong></span><br />This is an automated e-mail message sent from our support system. Do not reply to this e-mail as we can''"t receive your reply!</p>\r\n</div>', 1, '2011-03-31 16:46:16'),(21, 420, 'employer-packagepurchase', NULL, 'JS Jobs : You have ordered {PACKAGE_TITLE}', '<div style="background: #6DC6DD; height: 20px;">Â </div>\r\n<p style="color: #2191ad;">Dear {EMPLOYER_NAME}</p>\r\n<p style="color: #4f4f4f;">You have orderedÂ  {PACKAGE_TITLE}..</p>\r\n<p style="color: #4f4f4f;">Now you will be awarded all the facilities which we given in the above package, after the payment status verified.</p>\r\n<p style="color: #4f4f4f;">Payment Status {PAYMENT_STATUS}</p>\r\n<div>Click here to view {LINK} .<br />\r\n<p>Thank you.</p>\r\n</div>\r\n<div style="margin-top: 10px; padding: 10px 20px; color: #000000; background: #FAF2F2; border: 1px solid #F7C1C1;">\r\n<p><span style="color: red;"><strong>*DO NOT REPLY TO THIS E-MAIL*</strong></span><br />This is an automated e-mail message sent from our support system. Do not reply to this e-mail as we can''"t receive your reply!</p>\r\n</div>', 1, '2011-03-31 16:46:16'),(22, 420, 'job-new-employer', NULL, 'JS Jobs : New Job {JOB_TITLE} has beed received.', '<div style="background: #6DC6DD; height: 20px;"> </div>\r\n<p style="color: #2191ad;">Dear {EMPLOYER_NAME} ,</p>\r\n<p style="color: #4f4f4f;">We receive new job from you detail as below.</p>\r\n<p style="color: #4f4f4f;">Job: {JOB_TITLE}.</p>\r\n<p style="color: #4f4f4f;">Company: {COMPANY_NAME}.</p>\r\n<p style="color: #4f4f4f;">Department: {DEPARTMENT_NAME}.</p>\r\n<p style="color: #4f4f4f;">Category: {CATEGORY_TITLE}.</p>\r\n<p style="color: #4f4f4f;">Job Type: {JOB_TYPE_TITLE}.</p>\r\n<p style="color: #4f4f4f;">Status: {JOB_STATUS}.</p>\r\n<p style="color: #4f4f4f;">Click here to view {JOB_LINK}.</p>\r\n<div style="margin-top: 10px; padding: 10px 20px; color: #000000; background: #FAF2F2; border: 1px solid #F7C1C1;">\r\n<p><span style="color: red;"><strong>*DO NOT REPLY TO THIS E-MAIL*</strong></span><br />This is an automated e-mail message sent from our support system. Do not reply to this e-mail as we wonot receive your reply!</p>\r\n</div>', NULL, '2009-08-18 16:46:16');

DROP TABLE IF EXISTS `#__js_job_employerpackages`;
CREATE TABLE `#__js_job_employerpackages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `currencyid` int(11) DEFAULT NULL,
  `price` float DEFAULT NULL,
  `discount` int(11) DEFAULT NULL,
  `discounttype` tinyint(4) DEFAULT NULL,
  `discountmessage` varchar(500) DEFAULT NULL,
  `discountstartdate` datetime DEFAULT NULL,
  `discountenddate` datetime DEFAULT NULL,
  `companiesallow` int(11) NOT NULL DEFAULT '0',
  `jobsallow` int(11) NOT NULL DEFAULT '0',
  `viewresumeindetails` int(11) NOT NULL DEFAULT '0',
  `resumesearch` int(11) NOT NULL DEFAULT '0',
  `saveresumesearch` int(11) NOT NULL DEFAULT '0',
  `featuredcompaines` int(11) NOT NULL DEFAULT '0',
  `goldcompanies` int(11) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `featuredjobs` int(11) NOT NULL DEFAULT '0',
  `goldjobs` int(11) NOT NULL DEFAULT '0',
  `jobseekershortlist` tinyint(4) DEFAULT NULL,
  `shortdetails` varchar(1000) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `status` tinyint(4) NOT NULL,
  `video` tinyint(4) DEFAULT NULL,
  `map` tinyint(4) DEFAULT NULL,
  `packageexpireindays` int(11) NOT NULL,
  `featuredcompaniesexpireindays` int(11) DEFAULT NULL,
  `goldcompaniesexpireindays` int(11) DEFAULT NULL,
  `featuredjobsexpireindays` int(11) DEFAULT NULL,
  `goldjobsexpireindays` int(11) DEFAULT NULL,
  `enforcestoppublishjob` tinyint(1) DEFAULT '0',
  `enforcestoppublishjobvalue` int(11) DEFAULT NULL,
  `enforcestoppublishjobtype` tinyint(4) DEFAULT NULL,
  `fastspringlink` varchar(1000) DEFAULT NULL,
  `otherpaymentlink` varchar(1000) DEFAULT NULL,
  `messageallow` tinyint(1) DEFAULT NULL,
  `folders` tinyint(4) DEFAULT NULL,
  `virtuemartproductid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
INSERT INTO `#__js_job_employerpackages` (`id`, `title`, `currencyid`, `price`, `discount`, `discounttype`, `discountmessage`, `discountstartdate`, `discountenddate`, `companiesallow`, `jobsallow`, `viewresumeindetails`, `resumesearch`, `saveresumesearch`, `featuredcompaines`, `goldcompanies`, `created`, `featuredjobs`, `goldjobs`, `jobseekershortlist`, `shortdetails`, `description`, `status`, `video`, `map`, `packageexpireindays`, `featuredcompaniesexpireindays`, `goldcompaniesexpireindays`, `featuredjobsexpireindays`, `goldjobsexpireindays`, `enforcestoppublishjob`, `enforcestoppublishjobvalue`, `enforcestoppublishjobtype`, `fastspringlink`, `otherpaymentlink`, `messageallow`, `folders`) 
VALUES(1, 'Free Package', 1, 0, 0, 1, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 5, 100, -1, 1, 1, 10, 10, '2012-11-08 00:00:00', 10, 10, 1, 'Free Package for five companies', 'Free Package for five companies', 1, 1, 1, 365, 30, 30, 30, 30, 1, 30, 1, '', '', 1, 10);

DROP TABLE IF EXISTS `#__js_job_experiences`;
CREATE TABLE `#__js_job_experiences` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL,
  `status` tinyint(4) NOT NULL,
  `isdefault` tinyint(1) DEFAULT NULL,
  `ordering` int(11) DEFAULT NULL,
  `serverid` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=30 ;
INSERT INTO `#__js_job_experiences` (`id`, `title`, `status`, `isdefault`, `ordering`, `serverid`) VALUES(1, 'Fresh', 1, 0, 1, 0),(2, 'Less then 1 Year', 1, 0, 2, 0),(3, '1 Year', 1, 0, 3, 0),(4, '2 Year', 1, 0, 4, 0),(5, '3 Year', 1, 1, 5, 0),(6, '4 Year', 1, 0, 6, 0),(7, '5 Year', 1, 0, 7, 0),(8, '6 Year', 1, 0, 8, 0),(9, '7 Year', 1, 0, 9, 0),(10, '8 Year', 1, 0, 10, 0),(11, '9 Year', 1, 0, 11, 0),(12, '10 Year', 1, 0, 12, 0),(13, '11 Year', 1, 0, 13, 0),(14, '12 Year', 1, 0, 14, 0),(15, '13 Year', 1, 0, 15, 0),(16, '14 Year', 1, 0, 16, 0),(17, '15 Year', 1, 0, 17, 0),(18, '16 Year', 1, 0, 18, 0),(19, '17 Year', 1, 0, 19, 0),(20, '18 Year', 1, 0, 20, 0),(21, '19 Year', 1, 0, 21, 0),(22, '20 Year', 1, 0, 22, 0),(23, '21 Year', 1, 0, 23, 0),(24, '22 Year', 1, 0, 24, 0),(25, '23 Year', 1, 0, 25, 0),(26, '24 Year', 1, 0, 26, 0),(27, '25 Year', 1, 0, 27, 0);

DROP TABLE IF EXISTS `#__js_job_fieldsordering`;
CREATE TABLE `#__js_job_fieldsordering` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `field` varchar(50) NOT NULL,
  `fieldtitle` varchar(50) DEFAULT NULL,
  `ordering` int(11) DEFAULT NULL,
  `section` varchar(20) DEFAULT NULL,
  `fieldfor` tinyint(2) DEFAULT NULL,
  `published` tinyint(1) DEFAULT NULL,
  `isvisitorpublished` tinyint(1) DEFAULT NULL,
  `sys` tinyint(1) NOT NULL DEFAULT '0',
  `cannotunpublish` TINYINT(1) NOT NULL DEFAULT '0',
  `issocialpublished` tinyint(1) NOT NULL DEFAULT '0',
  `required` tinyint(1) NOT NULL DEFAULT '0',
  `isuserfield` tinyint(1) NOT NULL,
  `userfieldtype` varchar(250) NOT NULL,
  `userfieldparams` text DEFAULT NULL,
  `search_user` tinyint(1) NOT NULL DEFAULT '0',
  `search_visitor` tinyint(1) NOT NULL DEFAULT '0',
  `cannotsearch` tinyint(1) DEFAULT NULL,
  `search_ordering` int(11) DEFAULT NULL,
  `showonlisting` tinyint(1) NOT NULL DEFAULT '0',
  `cannotshowonlisting` tinyint(1) NOT NULL,
  `depandant_field` varchar(250) DEFAULT NULL,
  `readonly` tinyint(4) DEFAULT NULL,
  `size` int(11) DEFAULT NULL,
  `maxlength` int(11) DEFAULT NULL,
  `cols` int(11) DEFAULT NULL,
  `rows` int(11) DEFAULT NULL,
  `j_script` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fieldordering_filedfor` (`fieldfor`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=925 ;

INSERT INTO `#__js_job_fieldsordering` (`id`, `field`, `fieldtitle`, `ordering`, `section`, `fieldfor`, `published`, `isvisitorpublished`, `sys`, `cannotunpublish`, `issocialpublished`, `required`, `isuserfield`, `userfieldtype`, `userfieldparams`, `search_user`, `search_visitor`, `cannotsearch`, `search_ordering`, `showonlisting`, `cannotshowonlisting`, `depandant_field`, `readonly`, `size`, `maxlength`, `cols`, `rows`, `j_script`) VALUES
(1, 'name', 'Name', 1, '', 1, 1, 1, 1, 1, 1, 1, 0, '', '', 0, 0, 1, NULL, 1, 0, '', 0, 0, 0, 0, 0, ''),
(2, 'contactname', 'Contact Name', 2, '', 1, 1, 1, 0, 1, 0, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(3, 'contactphone', 'Contact Phone', 3, '', 1, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(4, 'contactemail', 'Contact Email', 4, '', 1, 1, 1, 0, 1, 0, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(5, 'jobcategory', 'Category', 5, '', 1, 1, 1, 0, 0, 1, 1, 0, '', '', 0, 0, 1, NULL, 1, 0, '', 0, 0, 0, 0, 0, ''),
(6, 'url', 'URL', 6, '', 1, 1, 1, 0, 0, 1, 0, 0, '', '', 0, 0, 1, NULL, 1, 0, '', 0, 0, 0, 0, 0, ''),
(7, 'since', 'Since', 9, '', 1, 1, 1, 0, 0, 0, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(8, 'companysize', 'Company Size', 12, '', 1, 1, 1, 0, 0, 0, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(9, 'income', 'Income', 11, '', 1, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(10, 'description', 'Description', 10, '', 1, 1, 0, 0, 0, 1, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(11, 'address1', 'Address1', 18, '', 1, 1, 1, 0, 0, 1, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(12, 'logo', 'Logo', 20, '', 1, 1, 1, 0, 0, 1, 0, 0, '', '', 0, 0, 1, NULL, 1, 0, '', 0, 0, 0, 0, 0, ''),
(20, 'contactfax', 'Contact Fax', 8, '', 1, 1, 1, 0, 0, 0, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(23, 'city', 'City', 15, '', 1, 1, 1, 0, 0, 1, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(25, 'zipcode', 'Zipcode', 17, '', 1, 1, 1, 0, 0, 0, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(26, 'address2', 'Address2', 19, '', 1, 1, 1, 0, 0, 0, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(101, 'jobtitle', 'Job Title', 1, '', 2, 1, 1, 1, 1, 1, 1, 0, '', '', 1, 1, 0, 1, 1, 1, '', 0, 0, 0, 0, 0, ''),
(102, 'company', 'Company', 2, '', 2, 1, 1, 1, 1, 1, 1, 0, '', '', 1, 1, 0, 2, 1, 0, '', 0, 0, 0, 0, 0, ''),
(103, 'department', 'Department', 3, '', 2, 1, 1, 0, 0, 1, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(104, 'jobcategory', 'Job Category', 4, '', 2, 1, 1, 1, 1, 1, 1, 0, '', '', 1, 1, 0, 4, 1, 0, '', 0, 0, 0, 0, 0, ''),
(105, 'subcategory', 'Sub Category', 5, '', 2, 1, 1, 0, 0, 0, 0, 0, '', '', 1, 1, 0, 5, 0, 1, '', 0, 0, 0, 0, 0, ''),
(106, 'jobtype', 'Job Type', 6, '', 2, 1, 1, 1, 1, 1, 1, 0, '', '', 1, 1, 0, 6, 1, 0, '', 0, 0, 0, 0, 0, ''),
(107, 'jobstatus', 'Job Status', 7, '', 2, 1, 1, 0, 0, 1, 1, 0, '', '', 1, 1, 0, 7, 0, 1, '', 0, 0, 0, 0, 0, ''),
(108, 'gender', 'Gender', 8, '', 2, 1, 1, 0, 0, 1, 0, 0, '', '', 1, 1, 0, 8, 0, 1, '', 0, 0, 0, 0, 0, ''),
(109, 'age', 'Age', 9, '', 2, 1, 1, 0, 0, 1, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(110, 'jobsalaryrange', 'Job Salary Range', 10, '', 2, 1, 1, 0, 0, 0, 0, 0, '', '', 1, 1, 0, 10, 1, 0, '', 0, 0, 0, 0, 0, ''),
(111, 'jobshift', 'Job Shift', 11, '', 2, 1, 1, 0, 0, 0, 0, 0, '', '', 1, 1, 0, 11, 0, 1, '', 0, 0, 0, 0, 0, ''),
(112, 'heighesteducation', 'Highest Education', 12, '', 2, 1, 1, 0, 0, 1, 0, 0, '', '', 1, 1, 0, 12, 0, 1, '', 0, 0, 0, 0, 0, ''),
(113, 'experience', 'Experience', 13, '', 2, 1, 1, 0, 0, 1, 0, 0, '', '', 1, 1, 0, 13, 0, 1, '', 0, 0, 0, 0, 0, ''),
(114, 'noofjobs', 'No of Jobs', 14, '', 2, 1, 1, 0, 0, 1, 0, 0, '', '', 0, 0, 1, NULL, 1, 0, '', 0, 0, 0, 0, 0, ''),
(115, 'duration', 'Duration', 15, '', 2, 1, 1, 0, 0, 0, 0, 0, '', '', 1, 1, 0, 15, 0, 1, '', 0, 0, 0, 0, 0, ''),
(116, 'careerlevel', 'Career Level', 16, '', 2, 1, 1, 0, 0, 0, 0, 0, '', '', 1, 1, 0, 16, 0, 1, '', 0, 0, 0, 0, 0, ''),
(117, 'workpermit', 'Work Permit', 17, '', 2, 1, 1, 0, 0, 0, 0, 0, '', '', 1, 1, 0, 17, 0, 1, '', 0, 0, 0, 0, 0, ''),
(118, 'requiredtravel', 'Required Travel', 18, '', 2, 1, 1, 0, 0, 0, 0, 0, '', '', 1, 1, 0, 18, 0, 1, '', 0, 0, 0, 0, 0, ''),
(119, 'video', 'Video', 19, '', 2, 1, 1, 0, 0, 0, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(120, 'map', 'Map', 20, '', 2, 1, 1, 0, 0, 0, 0, 0, '', '', 1, 1, 0, 20, 0, 1, '', 0, 0, 0, 0, 0, ''),
(121, 'startpublishing', 'Start Publishing', 21, '', 2, 1, 1, 1, 1, 1, 1, 0, '', '', 1, 1, 0, 21, 0, 1, '', 0, 0, 0, 0, 0, ''),
(122, 'stoppublishing', 'Stop Publishing', 22, '', 2, 1, 1, 1, 1, 1, 1, 0, '', '', 1, 1, 0, 22, 0, 1, '', 0, 0, 0, 0, 0, ''),
(125, 'city', 'City', 25, '', 2, 1, 1, 0, 0, 1, 0, 0, '', '', 1, 1, 0, 25, 1, 1, '', 0, 0, 0, 0, 0, ''),
(127, 'zipcode', 'Zipcode', 26, '', 2, 1, 1, 0, 0, 0, 0, 0, '', '', 1, 1, 0, 26, 0, 1, '', 0, 0, 0, 0, 0, ''),
(130, 'sendemail', 'Send Email', 27, '', 2, 1, 1, 0, 0, 0, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(131, 'sendmeresume', 'Send me Resume', 28, '', 2, 1, 1, 0, 0, 0, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(132, 'description', 'Description', 29, '', 2, 1, 1, 1, 1, 1, 1, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(133, 'qualifications', 'Qualifications', 30, '', 2, 1, 1, 0, 0, 1, 0, 0, '', '', 0, 0, 0, 30, 0, 0, '', 0, 0, 0, 0, 0, ''),
(134, 'prefferdskills', 'Prefered Skills', 31, '', 2, 1, 1, 0, 0, 1, 0, 0, '', '', 0, 0, 0, 31, 0, 0, '', 0, 0, 0, 0, 0, ''),
(135, 'agreement', 'Agreement', 32, '', 2, 1, 1, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 32, 0, 0, '', 0, 0, 0, 0, 0, ''),
(136, 'metadescription', 'Meta Description', 35, '', 2, 1, 1, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 35, 0, 0, '', 0, 0, 0, 0, 0, ''),
(137, 'metakeywords', 'Meta Keywords', 36, '', 2, 1, 1, 0, 0, 0, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(301, 'section_personal', 'Personal Information', 0, '1', 3, 1, 1, 1, 1, 1, 1, 0, '', '', 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, ''),
(302, 'application_title', 'Application Title', 1, '1', 3, 1, 1, 1, 1, 1, 1, 0, '', '', 1, 1, 0, 1, 1, 1, '', 0, 0, 0, 0, 0, ''),
(303, 'first_name', 'First Name', 2, '1', 3, 1, 1, 1, 1, 1, 1, 0, '', '', 1, 1, 0, 2, 1, 1, '', 0, 0, 0, 0, 0, ''),
(304, 'middle_name', 'Middle Name', 3, '1', 3, 1, 1, 0, 0, 0, 0, 0, '', '', 0, 0, 1, NULL, 1, 1, '', 0, 0, 0, 0, 0, ''),
(305, 'last_name', 'Last Name', 4, '1', 3, 1, 1, 1, 1, 1, 1, 0, '', '', 0, 0, 1, NULL, 1, 1, '', 0, 0, 0, 0, 0, ''),
(306, 'email_address', 'Email Address', 5, '1', 3, 1, 1, 1, 1, 0, 1, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(307, 'cell', 'Cell', 6, '1', 3, 1, 1, 0, 0, 0, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(308, 'nationality', 'Nationality', 7, '1', 3, 1, 1, 0, 0, 0, 0, 0, '', '', 1, 1, 0, 7, 0, 1, '', 0, 0, 0, 0, 0, ''),
(309, 'gender', 'Gender', 8, '1', 3, 1, 1, 0, 0, 1, 0, 0, '', '', 1, 1, 0, 8, 1, 1, '', 0, 0, 0, 0, 0, ''),
(310, 'photo', 'Photo', 9, '1', 3, 1, 1, 0, 0, 1, 0, 0, '', '', 0, 0, 1, NULL, 1, 1, '', 0, 0, 0, 0, 0, ''),
(311, 'resumefiles', 'File Upload', 10, '1', 3, 1, 1, 0, 0, 0, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(312, 'job_category', 'Category', 11, '1', 3, 1, 1, 0, 1, 1, 0, 0, '', '', 1, 1, 0, 11, 1, 0, '', 0, 0, 0, 0, 0, ''),
(313, 'job_subcategory', 'Sub Category', 12, '1', 3, 1, 1, 0, 0, 0, 0, 0, '', '', 1, 1, 0, 12, 0, 1, '', 0, 0, 0, 0, 0, ''),
(314, 'jobtype', 'Job Type', 13, '1', 3, 1, 1, 0, 0, 1, 0, 0, '', '', 1, 1, 0, 13, 1, 1, '', 0, 0, 0, 0, 0, ''),
(315, 'heighestfinisheducation', 'Highest Education', 16, '1', 3, 1, 1, 0, 0, 1, 0, 0, '', '', 1, 1, 0, 16, 1, 0, '', 0, 0, 0, 0, 0, ''),
(316, 'total_experience', 'Total Experience', 17, '1', 3, 1, 1, 0, 0, 1, 0, 0, '', '', 1, 1, 0, 17, 1, 0, '', 0, 0, 0, 0, 0, ''),
(318, 'home_phone', 'Home Phone', 20, '1', 3, 1, 1, 0, 0, 0, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(319, 'work_phone', 'Work Phone', 19, '1', 3, 1, 1, 0, 0, 0, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(320, 'date_of_birth', 'Date of Birth', 18, '1', 3, 1, 1, 0, 0, 0, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(323, 'date_start', 'Date you can start', 21, '1', 3, 1, 1, 0, 0, 1, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(324, 'salary', 'Salary ', 14, '1', 3, 1, 1, 0, 0, 0, 0, 0, '', '', 1, 1, 0, 14, 1, 0, '', 0, 0, 0, 0, 0, ''),
(325, 'desired_salary', 'Desire Salary', 15, '1', 3, 1, 1, 0, 0, 0, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(326, 'video', 'Video', 24, '1', 3, 1, 1, 0, 0, 0, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(327, 'keywords', 'Keywords', 25, '1', 3, 1, 1, 0, 0, 0, 0, 0, '', '', 1, 1, 0, 25, 0, 1, '', 0, 0, 0, 0, 0, ''),
(521, 'searchable', 'Searchable', 26, '1', 3, 1, 1, 0, 0, 0, 0, 0, '', '', 1, 1, 0, 26, 0, 1, '', 0, 0, 0, 0, 0, ''),
(522, 'iamavailable', 'I am Available', 26, '1', 3, 1, 1, 0, 0, 0, 0, 0, '', '', 1, 1, 0, 26, 1, 1, '', 0, 0, 0, 0, 0, ''),
(523, 'jobcategory', 'Job Category', 1, '', 11, 1, 0, 0, 1, 0, 1, 0, '', '', 0, 0, 0, 1, 0, 0, '', 0, 0, 0, 0, 0, ''),
(524, 'name', 'Name', 2, '', 11, 1, 0, 0, 1, 0, 0, 0, '', '', 0, 0, 0, 2, 0, 0, '', 0, 0, 0, 0, 0, ''),
(525, 'url', 'URL', 3, '', 11, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 3, 0, 0, '', 0, 0, 0, 0, 0, ''),
(526, 'contactname', 'Contact Name', 4, '', 11, 1, 0, 0, 1, 0, 0, 0, '', '', 0, 0, 0, 4, 0, 0, '', 0, 0, 0, 0, 0, ''),
(527, 'contactphone', 'Contact Phone', 5, '', 11, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 5, 0, 0, '', 0, 0, 0, 0, 0, ''),
(528, 'contactemail', 'Contact Email', 6, '', 11, 1, 0, 0, 1, 0, 0, 0, '', '', 0, 0, 0, 6, 0, 0, '', 0, 0, 0, 0, 0, ''),
(529, 'since', 'Since', 8, '', 11, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 8, 0, 0, '', 0, 0, 0, 0, 0, ''),
(530, 'companysize', 'Company Size', 9, '', 11, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 9, 0, 0, '', 0, 0, 0, 0, 0, ''),
(531, 'income', 'Income', 10, '', 11, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 10, 0, 0, '', 0, 0, 0, 0, 0, ''),
(532, 'description', 'Description', 11, '', 11, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 11, 0, 0, '', 0, 0, 0, 0, 0, ''),
(533, 'address1', 'Address1', 17, '', 11, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 17, 0, 0, '', 0, 0, 0, 0, 0, ''),
(534, 'logo', 'Logo', 19, '', 11, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 19, 0, 0, '', 0, 0, 0, 0, 0, ''),
(535, 'contactfax', 'Contact Fax', 7, '', 11, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 7, 0, 0, '', 0, 0, 0, 0, 0, ''),
(538, 'city', 'City', 14, '', 11, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 14, 0, 0, '', 0, 0, 0, 0, 0, ''),
(540, 'zipcode', 'Zipcode', 16, '', 11, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 16, 0, 0, '', 0, 0, 0, 0, 0, ''),
(541, 'address2', 'Address2', 18, '', 11, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 18, 0, 0, '', 0, 0, 0, 0, 0, ''),
(542, 'jobtitle', 'Job Title', 1, '', 12, 1, 0, 0, 1, 0, 1, 0, '', '', 0, 0, 0, 1, 0, 0, '', 0, 0, 0, 0, 0, ''),
(543, 'company', 'Company', 2, '', 12, 1, 0, 0, 1, 0, 1, 0, '', '', 0, 0, 0, 2, 0, 0, '', 0, 0, 0, 0, 0, ''),
(544, 'department', 'Department', 3, '', 12, 1, 0, 0, 0, 0, 1, 0, '', '', 0, 0, 0, 3, 0, 0, '', 0, 0, 0, 0, 0, ''),
(545, 'jobcategory', 'Job Category', 4, '', 12, 1, 0, 0, 1, 0, 1, 0, '', '', 0, 0, 0, 4, 0, 0, '', 0, 0, 0, 0, 0, ''),
(546, 'subcategory', 'Sub Category', 5, '', 12, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 5, 0, 0, '', 0, 0, 0, 0, 0, ''),
(547, 'jobtype', 'Job Type', 6, '', 12, 1, 0, 0, 1, 0, 1, 0, '', '', 0, 0, 0, 6, 0, 0, '', 0, 0, 0, 0, 0, ''),
(548, 'jobstatus', 'Job Status', 7, '', 12, 1, 0, 0, 1, 0, 1, 0, '', '', 0, 0, 0, 7, 0, 0, '', 0, 0, 0, 0, 0, ''),
(549, 'gender', 'Gender', 8, '', 12, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 8, 0, 0, '', 0, 0, 0, 0, 0, ''),
(550, 'age', 'Age', 9, '', 12, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 9, 0, 0, '', 0, 0, 0, 0, 0, ''),
(551, 'jobsalaryrange', 'Job Salary Range', 10, '', 12, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 10, 0, 0, '', 0, 0, 0, 0, 0, ''),
(552, 'jobshift', 'Job Shift', 11, '', 12, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 11, 0, 0, '', 0, 0, 0, 0, 0, ''),
(553, 'heighesteducation', 'Highest Education', 12, '', 12, 1, 0, 0, 1, 0, 0, 0, '', '', 0, 0, 0, 12, 0, 0, '', 0, 0, 0, 0, 0, ''),
(554, 'experience', 'Experience', 13, '', 12, 1, 0, 0, 1, 0, 0, 0, '', '', 0, 0, 0, 13, 0, 0, '', 0, 0, 0, 0, 0, ''),
(555, 'noofjobs', 'No of Jobs', 14, '', 12, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 14, 0, 0, '', 0, 0, 0, 0, 0, ''),
(556, 'duration', 'Duration', 15, '', 12, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 15, 0, 0, '', 0, 0, 0, 0, 0, ''),
(557, 'careerlevel', 'Career Level', 16, '', 12, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 16, 0, 0, '', 0, 0, 0, 0, 0, ''),
(558, 'workpermit', 'Work Permit', 17, '', 12, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 17, 0, 0, '', 0, 0, 0, 0, 0, ''),
(559, 'requiredtravel', 'Required Travel', 18, '', 12, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 18, 0, 0, '', 0, 0, 0, 0, 0, ''),
(560, 'video', 'Video', 19, '', 12, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 19, 0, 0, '', 0, 0, 0, 0, 0, ''),
(561, 'map', 'Map', 20, '', 12, 1, 0, 0, 0, 0, 1, 0, '', '', 0, 0, 0, 20, 0, 0, '', 0, 0, 0, 0, 0, ''),
(562, 'startpublishing', 'Start Publishing', 21, '', 12, 1, 0, 0, 1, 0, 1, 0, '', '', 0, 0, 0, 21, 0, 0, '', 0, 0, 0, 0, 0, ''),
(563, 'stoppublishing', 'Stop Publishing', 22, '', 12, 1, 0, 0, 1, 0, 1, 0, '', '', 0, 0, 0, 22, 0, 0, '', 0, 0, 0, 0, 0, ''),
(566, 'city', 'City', 25, '', 12, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 25, 0, 0, '', 0, 0, 0, 0, 0, ''),
(568, 'sendemail', 'Send Email', 27, '', 12, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 27, 0, 0, '', 0, 0, 0, 0, 0, ''),
(569, 'sendmeresume', 'Send me Resume', 28, '', 12, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 28, 0, 0, '', 0, 0, 0, 0, 0, ''),
(570, 'description', 'Description', 29, '', 12, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 29, 0, 0, '', 0, 0, 0, 0, 0, ''),
(571, 'qualifications', 'Qualifications', 30, '', 12, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 30, 0, 0, '', 0, 0, 0, 0, 0, ''),
(572, 'prefferdskills', 'Prefered Skills', 31, '', 12, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 31, 0, 0, '', 0, 0, 0, 0, 0, ''),
(573, 'agreement', 'Agreement', 32, '', 12, 1, 0, 0, 0, 0, 1, 0, '', '', 0, 0, 0, 32, 0, 0, '', 0, 0, 0, 0, 0, ''),
(574, 'metadescription', 'Meta Description', 33, '', 12, 1, 0, 0, 0, 0, 1, 0, '', '', 0, 0, 0, 33, 0, 0, '', 0, 0, 0, 0, 0, ''),
(575, 'metakeywords', 'Meta Keywords', 34, '', 12, 1, 0, 0, 0, 0, 1, 0, '', '', 0, 0, 0, 34, 0, 0, '', 0, 0, 0, 0, 0, ''),
(576, 'zipcode', 'Zipcode', 26, '', 12, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 26, 0, 0, '', 0, 0, 0, 0, 0, ''),
(616, 'address2_city', 'City', 65, '33', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 65, 0, 0, '', 0, 0, 0, 0, 0, ''),
(617, 'address2_zipcode', 'Zip Code', 66, '33', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 66, 0, 0, '', 0, 0, 0, 0, 0, ''),
(618, 'address2_address', 'Address', 67, '33', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 67, 0, 0, '', 0, 0, 0, 0, 0, ''),
(619, 'section_education', 'Education', 71, '40', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 71, 0, 0, '', 0, 0, 0, 0, 0, ''),
(620, 'section_sub_institute', 'High School', 72, '41', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 72, 0, 0, '', 0, 0, 0, 0, 0, ''),
(621, 'institute_institute', 'Institute', 73, '41', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 73, 0, 0, '', 0, 0, 0, 0, 0, ''),
(625, 'institute_city', 'City', 77, '41', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 77, 0, 0, '', 0, 0, 0, 0, 0, ''),
(626, 'institute_address', 'Address', 78, '41', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 78, 0, 0, '', 0, 0, 0, 0, 0, ''),
(627, 'institute_certificate', 'Certificate Name', 79, '41', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 79, 0, 0, '', 0, 0, 0, 0, 0, ''),
(628, 'institute_study_area', 'Study Area', 80, '41', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 80, 0, 0, '', 0, 0, 0, 0, 0, ''),
(629, 'section_sub_institute1', 'University', 82, '42', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 82, 0, 0, '', 0, 0, 0, 0, 0, ''),
(630, 'institute1_institute', 'Institute', 83, '42', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 83, 0, 0, '', 0, 0, 0, 0, 0, ''),
(634, 'institute1_city', 'City', 87, '42', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 87, 0, 0, '', 0, 0, 0, 0, 0, ''),
(635, 'institute1_address', 'Address', 88, '42', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 88, 0, 0, '', 0, 0, 0, 0, 0, ''),
(636, 'institute1_certificate', 'Certificate Name', 89, '42', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 89, 0, 0, '', 0, 0, 0, 0, 0, ''),
(637, 'institute1_study_area', 'Study Area', 90, '42', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 90, 0, 0, '', 0, 0, 0, 0, 0, ''),
(638, 'section_sub_institute2', 'Grade School', 92, '43', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 92, 0, 0, '', 0, 0, 0, 0, 0, ''),
(639, 'institute2_institute', 'Institute', 93, '43', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 93, 0, 0, '', 0, 0, 0, 0, 0, ''),
(643, 'institute2_city', 'City', 97, '43', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 97, 0, 0, '', 0, 0, 0, 0, 0, ''),
(644, 'institute2_address', 'Address', 98, '43', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 98, 0, 0, '', 0, 0, 0, 0, 0, ''),
(645, 'institute2_certificate', 'Certificate Name', 99, '43', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 99, 0, 0, '', 0, 0, 0, 0, 0, ''),
(646, 'institute2_study_area', 'Study Area', 100, '43', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 100, 0, 0, '', 0, 0, 0, 0, 0, ''),
(647, 'section_sub_institute3', 'Other School', 102, '44', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 102, 0, 0, '', 0, 0, 0, 0, 0, ''),
(648, 'institute3_institute', 'Institute', 103, '44', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 103, 0, 0, '', 0, 0, 0, 0, 0, ''),
(652, 'institute3_city', 'City', 107, '44', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 107, 0, 0, '', 0, 0, 0, 0, 0, ''),
(653, 'institute3_address', 'Address', 108, '44', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 108, 0, 0, '', 0, 0, 0, 0, 0, ''),
(654, 'institute3_certificate', 'Certificate Name', 109, '44', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 109, 0, 0, '', 0, 0, 0, 0, 0, ''),
(655, 'institute3_study_area', 'Study Area', 110, '44', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 110, 0, 0, '', 0, 0, 0, 0, 0, ''),
(656, 'section_employer', 'Employer', 112, '50', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 112, 0, 0, '', 0, 0, 0, 0, 0, ''),
(657, 'section_sub_employer', 'Recent Employer', 113, '51', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 113, 0, 0, '', 0, 0, 0, 0, 0, ''),
(658, 'employer_employer', 'Employer', 114, '51', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 114, 0, 0, '', 0, 0, 0, 0, 0, ''),
(659, 'employer_position', 'Position', 114, '51', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 114, 0, 0, '', 0, 0, 0, 0, 0, ''),
(660, 'employer_resp', 'Responsibilities', 115, '51', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 115, 0, 0, '', 0, 0, 0, 0, 0, ''),
(661, 'employer_pay_upon_leaving', 'Pay Upon Leaving', 116, '51', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 116, 0, 0, '', 0, 0, 0, 0, 0, ''),
(662, 'employer_supervisor', 'Supervisor', 117, '51', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 117, 0, 0, '', 0, 0, 0, 0, 0, ''),
(663, 'employer_from_date', 'From Date', 118, '51', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 118, 0, 0, '', 0, 0, 0, 0, 0, ''),
(664, 'employer_to_date', 'To Date', 119, '51', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 119, 0, 0, '', 0, 0, 0, 0, 0, ''),
(665, 'employer_leave_reason', 'Leave Reason', 120, '51', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 120, 0, 0, '', 0, 0, 0, 0, 0, ''),
(669, 'employer_city', 'City', 124, '51', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 124, 0, 0, '', 0, 0, 0, 0, 0, ''),
(670, 'employer_zip', 'Zip Code', 125, '51', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 125, 0, 0, '', 0, 0, 0, 0, 0, ''),
(671, 'employer_phone', 'Phone', 126, '51', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 126, 0, 0, '', 0, 0, 0, 0, 0, ''),
(672, 'employer_address', 'Address', 127, '51', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 127, 0, 0, '', 0, 0, 0, 0, 0, ''),
(673, 'section_sub_employer1', 'Prior Employer 1', 128, '52', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 128, 0, 0, '', 0, 0, 0, 0, 0, ''),
(674, 'employer1_employer', 'Employer', 129, '52', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 129, 0, 0, '', 0, 0, 0, 0, 0, ''),
(675, 'employer1_position', 'Position', 130, '52', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 130, 0, 0, '', 0, 0, 0, 0, 0, ''),
(676, 'employer1_resp', 'Responsibilities', 131, '52', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 131, 0, 0, '', 0, 0, 0, 0, 0, ''),
(677, 'employer1_pay_upon_leaving', 'Pay Upon Leaving', 132, '52', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 132, 0, 0, '', 0, 0, 0, 0, 0, ''),
(678, 'employer1_supervisor', 'Supervisor', 133, '52', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 133, 0, 0, '', 0, 0, 0, 0, 0, ''),
(679, 'employer1_from_date', 'From Date', 134, '52', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 134, 0, 0, '', 0, 0, 0, 0, 0, ''),
(680, 'employer1_to_date', 'To Date', 135, '52', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 135, 0, 0, '', 0, 0, 0, 0, 0, ''),
(681, 'employer1_leave_reason', 'Leave Reason', 136, '52', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 136, 0, 0, '', 0, 0, 0, 0, 0, ''),
(685, 'employer1_city', 'City', 140, '52', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 140, 0, 0, '', 0, 0, 0, 0, 0, ''),
(686, 'employer1_zip', 'Zip Code', 141, '52', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 141, 0, 0, '', 0, 0, 0, 0, 0, ''),
(687, 'employer1_phone', 'Phone', 142, '52', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 142, 0, 0, '', 0, 0, 0, 0, 0, ''),
(688, 'employer1_address', 'Address', 143, '52', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 143, 0, 0, '', 0, 0, 0, 0, 0, ''),
(689, 'section_sub_employer2', 'Prior Employer 2', 146, '53', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 146, 0, 0, '', 0, 0, 0, 0, 0, ''),
(690, 'employer2_employer', 'Employer', 147, '53', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 147, 0, 0, '', 0, 0, 0, 0, 0, ''),
(691, 'employer2_position', 'Position', 148, '53', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 148, 0, 0, '', 0, 0, 0, 0, 0, ''),
(692, 'employer2_resp', 'Responsibilities', 149, '53', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 149, 0, 0, '', 0, 0, 0, 0, 0, ''),
(693, 'employer2_pay_upon_leaving', 'Pay Upon Leaving', 150, '53', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 150, 0, 0, '', 0, 0, 0, 0, 0, ''),
(694, 'employer2_supervisor', 'Supervisor', 151, '53', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 151, 0, 0, '', 0, 0, 0, 0, 0, ''),
(695, 'employer2_from_date', 'From Date', 152, '53', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 152, 0, 0, '', 0, 0, 0, 0, 0, ''),
(696, 'employer2_to_date', 'To Date', 153, '53', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 153, 0, 0, '', 0, 0, 0, 0, 0, ''),
(697, 'employer2_leave_reason', 'Leave Reason', 154, '53', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 154, 0, 0, '', 0, 0, 0, 0, 0, ''),
(701, 'employer2_city', 'City', 158, '53', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 158, 0, 0, '', 0, 0, 0, 0, 0, ''),
(702, 'employer2_zip', 'Zip Code', 159, '53', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 159, 0, 0, '', 0, 0, 0, 0, 0, ''),
(703, 'employer2_phone', 'Phone', 160, '53', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 160, 0, 0, '', 0, 0, 0, 0, 0, ''),
(704, 'employer2_address', 'Address', 161, '53', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 161, 0, 0, '', 0, 0, 0, 0, 0, ''),
(705, 'section_sub_employer3', 'Prior Employer 3', 166, '54', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 166, 0, 0, '', 0, 0, 0, 0, 0, ''),
(706, 'employer3_employer', 'Employer', 167, '54', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 167, 0, 0, '', 0, 0, 0, 0, 0, ''),
(707, 'employer3_position', 'Position', 168, '54', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 168, 0, 0, '', 0, 0, 0, 0, 0, ''),
(708, 'employer3_resp', 'Responsibilities', 169, '54', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 169, 0, 0, '', 0, 0, 0, 0, 0, ''),
(709, 'employer3_pay_upon_leaving', 'Pay Upon Leaving', 170, '54', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 170, 0, 0, '', 0, 0, 0, 0, 0, ''),
(710, 'employer3_supervisor', 'Supervisor', 171, '54', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 171, 0, 0, '', 0, 0, 0, 0, 0, ''),
(711, 'employer3_from_date', 'From Date', 172, '54', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 172, 0, 0, '', 0, 0, 0, 0, 0, ''),
(712, 'employer3_to_date', 'To Date', 173, '54', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 173, 0, 0, '', 0, 0, 0, 0, 0, ''),
(713, 'employer3_leave_reason', 'Leave Reason', 174, '54', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 174, 0, 0, '', 0, 0, 0, 0, 0, ''),
(717, 'employer3_city', 'City', 178, '54', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 178, 0, 0, '', 0, 0, 0, 0, 0, ''),
(718, 'employer3_zip', 'Zip Code', 179, '54', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 179, 0, 0, '', 0, 0, 0, 0, 0, ''),
(719, 'employer3_phone', 'Phone', 180, '54', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 180, 0, 0, '', 0, 0, 0, 0, 0, ''),
(720, 'employer3_address', 'Address', 181, '54', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 181, 0, 0, '', 0, 0, 0, 0, 0, ''),
(721, 'section_skills', 'Skills', 186, '60', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 186, 0, 0, '', 0, 0, 0, 0, 0, ''),
(722, 'driving_license', 'Driving License', 187, '60', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 187, 0, 0, '', 0, 0, 0, 0, 0, ''),
(723, 'license_no', 'License No', 188, '60', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 188, 0, 0, '', 0, 0, 0, 0, 0, ''),
(724, 'license_country', 'License Country', 189, '60', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 189, 0, 0, '', 0, 0, 0, 0, 0, ''),
(725, 'skills', 'Skills', 190, '60', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 190, 0, 0, '', 0, 0, 0, 0, 0, ''),
(726, 'section_resumeeditor', 'Resume Editor', 196, '70', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 196, 0, 0, '', 0, 0, 0, 0, 0, ''),
(727, 'editor', 'Editor', 197, '70', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 197, 0, 0, '', 0, 0, 0, 0, 0, ''),
(728, 'section_references', 'References', 206, '80', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 206, 0, 0, '', 0, 0, 0, 0, 0, ''),
(729, 'section_sub_reference', 'Reference 1', 207, '81', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 207, 0, 0, '', 0, 0, 0, 0, 0, ''),
(730, 'reference_reference', 'Reference', 208, '81', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 208, 0, 0, '', 0, 0, 0, 0, 0, ''),
(731, 'reference_name', 'Name', 209, '81', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 209, 0, 0, '', 0, 0, 0, 0, 0, ''),
(735, 'reference_city', 'City', 213, '81', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 213, 0, 0, '', 0, 0, 0, 0, 0, ''),
(736, 'reference_zipcode', 'Zip Code', 214, '81', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 214, 0, 0, '', 0, 0, 0, 0, 0, ''),
(737, 'reference_phone', 'Phone', 215, '81', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 215, 0, 0, '', 0, 0, 0, 0, 0, ''),
(738, 'reference_relation', 'Relation', 216, '81', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 216, 0, 0, '', 0, 0, 0, 0, 0, ''),
(739, 'reference_years', 'Years', 217, '81', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 217, 0, 0, '', 0, 0, 0, 0, 0, ''),
(740, 'section_sub_reference1', 'Reference 2', 221, '82', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 221, 0, 0, '', 0, 0, 0, 0, 0, ''),
(741, 'reference1_reference', 'Reference', 222, '82', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 222, 0, 0, '', 0, 0, 0, 0, 0, ''),
(742, 'reference1_name', 'Name', 223, '82', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 223, 0, 0, '', 0, 0, 0, 0, 0, ''),
(746, 'reference1_city', 'City', 227, '82', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 227, 0, 0, '', 0, 0, 0, 0, 0, ''),
(747, 'reference1_zipcode', 'Zip Code', 228, '82', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 228, 0, 0, '', 0, 0, 0, 0, 0, ''),
(748, 'reference1_phone', 'Phone', 229, '82', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 229, 0, 0, '', 0, 0, 0, 0, 0, ''),
(749, 'reference1_relation', 'Relation', 230, '82', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 230, 0, 0, '', 0, 0, 0, 0, 0, ''),
(750, 'reference1_years', 'Years', 231, '82', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 231, 0, 0, '', 0, 0, 0, 0, 0, ''),
(751, 'section_sub_reference2', 'Reference 3', 232, '83', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 232, 0, 0, '', 0, 0, 0, 0, 0, ''),
(752, 'reference2_reference', 'Reference', 233, '83', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 233, 0, 0, '', 0, 0, 0, 0, 0, ''),
(753, 'reference2_name', 'Name', 234, '83', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 234, 0, 0, '', 0, 0, 0, 0, 0, ''),
(757, 'reference2_city', 'City', 238, '83', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 238, 0, 0, '', 0, 0, 0, 0, 0, ''),
(758, 'reference2_zipcode', 'Zip Code', 239, '83', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 239, 0, 0, '', 0, 0, 0, 0, 0, ''),
(759, 'reference2_phone', 'Phone', 240, '83', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 240, 0, 0, '', 0, 0, 0, 0, 0, ''),
(760, 'reference2_relation', 'Relation', 241, '83', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 241, 0, 0, '', 0, 0, 0, 0, 0, ''),
(761, 'reference2_years', 'Years', 242, '83', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 242, 0, 0, '', 0, 0, 0, 0, 0, ''),
(762, 'section_sub_reference3', 'Reference 4', 243, '84', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 243, 0, 0, '', 0, 0, 0, 0, 0, ''),
(763, 'reference3_reference', 'Reference', 244, '84', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 244, 0, 0, '', 0, 0, 0, 0, 0, ''),
(764, 'reference3_name', 'Name', 245, '84', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 245, 0, 0, '', 0, 0, 0, 0, 0, ''),
(768, 'reference3_city', 'City', 249, '84', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 249, 0, 0, '', 0, 0, 0, 0, 0, ''),
(769, 'reference3_zipcode', 'Zip Code', 250, '84', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 250, 0, 0, '', 0, 0, 0, 0, 0, ''),
(770, 'reference3_phone', 'Phone', 251, '84', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 251, 0, 0, '', 0, 0, 0, 0, 0, ''),
(771, 'reference3_relation', 'Relation', 252, '84', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 252, 0, 0, '', 0, 0, 0, 0, 0, ''),
(772, 'reference3_years', 'Years', 253, '84', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 253, 0, 0, '', 0, 0, 0, 0, 0, ''),
(773, 'Iamavailable', 'I am Available', 11, '10', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 11, 0, 0, '', 0, 0, 0, 0, 0, ''),
(774, 'searchable', 'Searchable', 12, '10', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 12, 0, 0, '', 0, 0, 0, 0, 0, ''),
(775, 'section_userfields', 'Visitor User Fields', 21, '1000', 13, 0, 0, 0, 0, 0, 1, 0, '', '', 0, 0, 0, 21, 0, 0, '', 0, 0, 0, 0, 0, ''),
(776, 'userfield1', 'User Field 1', 22, '1000', 13, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 22, 0, 0, '', 0, 0, 0, 0, 0, ''),
(777, 'userfield2', 'User Field 2', 23, '1000', 13, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 23, 0, 0, '', 0, 0, 0, 0, 0, ''),
(778, 'userfield3', 'User Field 3', 24, '1000', 13, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 24, 0, 0, '', 0, 0, 0, 0, 0, ''),
(779, 'userfield4', 'User Field 4', 25, '1000', 13, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 25, 0, 0, '', 0, 0, 0, 0, 0, ''),
(780, 'userfield5', 'User Field 5', 26, '1000', 13, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 26, 0, 0, '', 0, 0, 0, 0, 0, ''),
(781, 'userfield6', 'User Field 6', 27, '1000', 13, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 27, 0, 0, '', 0, 0, 0, 0, 0, ''),
(782, 'userfield7', 'User Field 7', 28, '1000', 13, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 28, 0, 0, '', 0, 0, 0, 0, 0, ''),
(783, 'userfield8', 'User Field 8', 29, '1000', 13, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 29, 0, 0, '', 0, 0, 0, 0, 0, ''),
(784, 'userfield9', 'User Field 9', 30, '1000', 13, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 30, 0, 0, '', 0, 0, 0, 0, 0, ''),
(785, 'userfield10', 'User Field 10', 32, '1000', 13, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 32, 0, 0, '', 0, 0, 0, 0, 0, ''),
(787, 'date_of_birth', 'Date of Birth', 14, '10', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 14, 0, 0, '', 0, 0, 0, 0, 0, ''),
(789, 'video', 'Youtube Video Id', 22, '20', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 22, 0, 0, '', 0, 0, 0, 0, 0, ''),
(791, 'address_location', 'Longitude And Latitude', 50, '31', 13, 1, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 50, 0, 0, '', 0, 0, 0, 0, 0, ''),
(863, 'filter', 'Filter', 33, '', 2, 1, 1, 0, 0, 0, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(864, 'emailsetting', 'Email Setting', 34, '', 2, 1, 1, 0, 0, 0, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(865, 'section_address', 'Add Address', 26, '2', 3, 1, 1, 0, 0, 1, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(866, 'address_city', 'City', 30, '2', 3, 1, 1, 0, 0, 1, 0, 0, '', '', 1, 1, 0, 866, 0, 1, '', 0, 0, 0, 0, 0, ''),
(867, 'address_zipcode', 'Zip Code', 28, '2', 3, 1, 1, 0, 0, 0, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(868, 'address', 'Address', 27, '2', 3, 1, 1, 0, 0, 1, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(869, 'address_location', 'Location', 31, '2', 3, 1, 1, 0, 0, 0, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(872, 'section_institute', 'Education', 31, '3', 3, 1, 1, 0, 0, 1, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(873, 'institute', 'Institute', 32, '3', 3, 1, 1, 0, 0, 1, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(874, 'institute_city', 'Institute city', 33, '3', 3, 1, 1, 0, 0, 1, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(875, 'institute_address', 'Address', 34, '3', 3, 1, 1, 0, 0, 1, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(876, 'institute_certificate_name', 'Certificate Name', 35, '3', 3, 1, 1, 0, 0, 0, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(877, 'institute_study_area', 'Study Area', 36, '3', 3, 1, 1, 0, 0, 1, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(878, 'section_employer', 'Employer', 37, '4', 3, 1, 1, 0, 0, 1, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(879, 'employer', 'Employer', 38, '4', 3, 1, 1, 0, 0, 1, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(880, 'employer_position', 'Position', 39, '4', 3, 1, 1, 0, 0, 1, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(881, 'employer_resp', 'Responsibilities', 40, '4', 3, 1, 1, 0, 0, 0, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(882, 'employer_pay_upon_leaving', 'Pay Upon Leaving', 41, '4', 3, 1, 1, 0, 0, 0, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(883, 'employer_supervisor', 'Supervisor', 42, '4', 3, 1, 1, 0, 0, 0, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(884, 'employer_from_date', 'From Date', 43, '4', 3, 1, 1, 0, 0, 1, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(885, 'employer_to_date', 'To Date', 44, '4', 3, 1, 1, 0, 0, 1, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(886, 'employer_leave_reason', 'Leave Reason', 45, '4', 3, 1, 1, 0, 0, 0, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(887, 'employer_city', 'City', 46, '4', 3, 1, 1, 0, 0, 1, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(888, 'employer_zip', 'Zip Code', 47, '4', 3, 1, 1, 0, 0, 0, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(889, 'employer_phone', 'Phone', 48, '4', 3, 1, 1, 0, 0, 0, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(890, 'employer_address', 'Address', 49, '4', 3, 1, 1, 0, 0, 1, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(891, 'section_skills', 'Skills', 50, '5', 3, 1, 1, 0, 0, 1, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(892, 'skills', 'Skills', 51, '5', 3, 1, 1, 0, 0, 1, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(893, 'section_resume', 'Resume Editor', 52, '6', 3, 1, 1, 0, 0, 1, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(894, 'resume', 'Resume Editor', 53, '6', 3, 1, 1, 0, 0, 1, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(895, 'section_reference', 'Add References', 54, '7', 3, 1, 1, 0, 0, 1, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(896, 'reference', 'Reference', 55, '7', 3, 1, 1, 0, 0, 1, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(897, 'reference_name', 'Reference Name', 56, '7', 3, 1, 1, 0, 0, 1, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(898, 'reference_country', 'Reference Country', 57, '7', 3, 1, 1, 0, 0, 0, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(899, 'reference_state', 'Reference State', 58, '7', 3, 1, 1, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 58, 0, 0, '', 0, 0, 0, 0, 0, ''),
(900, 'reference_city', 'Reference City', 59, '7', 3, 1, 1, 0, 0, 1, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(901, 'reference_zipcode', 'Reference Zipcode', 60, '7', 3, 1, 1, 0, 0, 0, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(902, 'reference_address', 'Reference Address', 61, '7', 3, 1, 1, 0, 0, 0, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(903, 'reference_phone', 'Reference Phone', 62, '7', 3, 1, 1, 0, 0, 0, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(904, 'reference_relation', 'Reference Relation', 63, '7', 3, 1, 1, 0, 0, 1, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(905, 'reference_years', 'Reference Years', 64, '7', 3, 1, 1, 0, 0, 0, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(906, 'section_language', 'Add Language', 65, '8', 3, 1, 1, 0, 0, 1, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(908, 'language', 'Language', 66, '8', 3, 1, 1, 0, 0, 1, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(909, 'language_reading', 'Language Reading', 67, '8', 3, 1, 1, 0, 0, 0, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(910, 'language_writing', 'Language Writing', 68, '8', 3, 1, 1, 0, 0, 0, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(911, 'language_understanding', 'Language Understanding', 69, '8', 3, 1, 1, 0, 0, 0, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(912, 'language_where_learned', 'Language Where Learned', 70, '8', 3, 1, 1, 0, 0, 0, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(913, 'driving_license', 'Driving License', 21, '1', 3, 1, 1, 0, 0, 0, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(914, 'license_no', 'License No.', 22, '1', 3, 1, 1, 0, 0, 0, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(915, 'license_country', 'License Country', 23, '1', 3, 1, 1, 0, 0, 0, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, ''),
(916, 'jobapplylink', 'Job Apply Link', 43, '', 2, 0, 0, 0, 0, 1, 0, 0, '', '', 0, 0, 1, NULL, 0, 1, '', 0, 0, 0, 0, 0, '');

DROP TABLE IF EXISTS `#__js_job_filters`;
CREATE TABLE `#__js_job_filters` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL,
  `country_istext` tinyint(1) DEFAULT NULL,
  `country` varchar(50) DEFAULT NULL,
  `state_istext` tinyint(1) DEFAULT NULL,
  `state` varchar(50) DEFAULT NULL,
  `county_istext` tinyint(1) DEFAULT NULL,
  `county` varchar(50) DEFAULT NULL,
  `city_istext` tinyint(1) DEFAULT NULL,
  `city` varchar(50) DEFAULT NULL,
  `zipcode` varchar(25) DEFAULT NULL,
  `category` int(11) DEFAULT NULL,
  `jobtype` int(11) DEFAULT NULL,
  `jobstatus` int(11) DEFAULT NULL,
  `heighesteducation` int(11) DEFAULT NULL,
  `salaryrange` int(11) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `#__js_job_heighesteducation`;
CREATE TABLE `#__js_job_heighesteducation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL DEFAULT '',
  `isactive` tinyint(1) DEFAULT '1',
  `isdefault` tinyint(1) DEFAULT NULL,
  `ordering` int(11) DEFAULT NULL,
  `serverid` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
INSERT INTO `#__js_job_heighesteducation` (`id`, `title`, `isactive`, `isdefault`, `ordering`, `serverid`) VALUES(1, 'University', 1, 1, 1, 0),(2, 'College', 1, 0, 2, 0),(3, 'High School', 1, 0, 3, 0),(4, 'No School', 1, 0, 4, 0);

DROP TABLE IF EXISTS `#__js_job_jobapply`;
CREATE TABLE `#__js_job_jobapply` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `jobid` int(11) NOT NULL DEFAULT '0',
  `uid` int(11) NOT NULL DEFAULT '0',
  `cvid` int(11) DEFAULT NULL,
  `apply_date` datetime DEFAULT NULL,
  `resumeview` tinyint(1) NOT NULL DEFAULT '0',
  `comments` varchar(1000) DEFAULT NULL,
  `coverletterid` int(11) DEFAULT NULL,
  `action_status` int(11) DEFAULT NULL,
  `serverstatus` varchar(255) DEFAULT NULL,
  `serverid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `jobapply_uid` (`uid`),
  KEY `jobapply_jobid` (`jobid`),
  KEY `jobapply_cvid` (`cvid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `#__js_job_jobcities`;
CREATE TABLE `#__js_job_jobcities` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `jobid` int(11) NOT NULL,
  `cityid` int(11) NOT NULL,
  `serverid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `jobid` (`jobid`),
  KEY `cityid` (`cityid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `#__js_job_jobs`;
CREATE TABLE `#__js_job_jobs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL,
  `companyid` int(11) DEFAULT NULL,
  `title` varchar(255) NOT NULL DEFAULT '',
  `alias` varchar(225) NOT NULL,
  `jobcategory` varchar(255) NOT NULL DEFAULT '',
  `jobtype` tinyint(1) unsigned DEFAULT '0',
  `jobstatus` tinyint(3) NOT NULL DEFAULT '1',
  `jobsalaryrange` varchar(255) DEFAULT '',
  `salaryrangetype` varchar(20) DEFAULT NULL,
  `hidesalaryrange` tinyint(1) DEFAULT '1',
  `description` text DEFAULT NULL,
  `qualifications` text DEFAULT NULL,
  `prefferdskills` text DEFAULT NULL,
  `applyinfo` text DEFAULT NULL,
  `company` varchar(255) NOT NULL DEFAULT '',
  `country` varchar(255) DEFAULT '',
  `state` varchar(255) DEFAULT '',
  `county` varchar(255) DEFAULT '',
  `city` varchar(255) DEFAULT '',
  `zipcode` varchar(25) DEFAULT '',
  `address1` varchar(255) DEFAULT '',
  `address2` varchar(255) DEFAULT '',
  `companyurl` varchar(255) DEFAULT '',
  `contactname` varchar(255) DEFAULT '',
  `contactphone` varchar(255) DEFAULT '',
  `contactemail` varchar(255) DEFAULT '',
  `showcontact` tinyint(1) unsigned DEFAULT '0',
  `noofjobs` int(11) unsigned NOT NULL DEFAULT '1',
  `reference` varchar(255) NOT NULL DEFAULT '',
  `duration` varchar(255) NOT NULL DEFAULT '',
  `heighestfinisheducation` varchar(255) DEFAULT '',
  `created` datetime NOT NULL DEFAULT current_timestamp(),
  `created_by` int(11) unsigned NOT NULL DEFAULT '0',
  `modified` datetime NOT NULL DEFAULT current_timestamp(),
  `modified_by` int(11) unsigned NOT NULL DEFAULT '0',
  `hits` int(11) unsigned NOT NULL DEFAULT '0',
  `experience` int(11) DEFAULT '0',
  `startpublishing` datetime NOT NULL DEFAULT current_timestamp(),
  `stoppublishing` datetime NOT NULL DEFAULT current_timestamp(),
  `departmentid` varchar(255) DEFAULT NULL,
  `shift` varchar(255) DEFAULT NULL,
  `sendemail` tinyint(1) NOT NULL DEFAULT '0',
  `metadescription` text DEFAULT NULL,
  `metakeywords` text DEFAULT NULL,
  `agreement` text DEFAULT NULL,
  `ordering` tinyint(3) NOT NULL DEFAULT '0',
  `aboutjobfile` varchar(50) DEFAULT NULL,
  `status` int(11) DEFAULT '1',
  `educationminimax` tinyint(1) DEFAULT NULL,
  `educationid` int(11) DEFAULT NULL,
  `mineducationrange` int(11) DEFAULT NULL,
  `maxeducationrange` int(11) DEFAULT NULL,
  `iseducationminimax` tinyint(1) DEFAULT NULL,
  `degreetitle` varchar(255) DEFAULT NULL,
  `careerlevel` int(11) DEFAULT NULL,
  `experienceminimax` tinyint(1) DEFAULT NULL,
  `experienceid` int(11) DEFAULT NULL,
  `minexperiencerange` int(11) DEFAULT NULL,
  `maxexperiencerange` int(11) DEFAULT NULL,
  `isexperienceminimax` tinyint(1) DEFAULT NULL,
  `experiencetext` varchar(255) DEFAULT NULL,
  `workpermit` varchar(20) DEFAULT NULL,
  `requiredtravel` int(11) DEFAULT NULL,
  `agefrom` int(11) DEFAULT NULL,
  `ageto` int(11) DEFAULT NULL,
  `salaryrangefrom` int(11) DEFAULT NULL,
  `salaryrangeto` int(11) DEFAULT NULL,
  `gender` int(5) DEFAULT NULL,
  `video` varchar(150) DEFAULT NULL,
  `map` varchar(1000) DEFAULT NULL,
  `packageid` int(11) DEFAULT NULL,
  `paymenthistoryid` int(11) DEFAULT NULL,
  `subcategoryid` int(11) DEFAULT NULL,
  `currencyid` int(11) DEFAULT NULL,
  `jobid` varchar(25) DEFAULT '',
  `longitude` varchar(255) DEFAULT NULL,
  `latitude` varchar(255) DEFAULT NULL,
  `isgoldjob` tinyint(1) DEFAULT '0',
  `isfeaturedjob` tinyint(1) DEFAULT '0',
  `notifications` tinyint(1) NOT NULL DEFAULT '0',
  `raf_gender` tinyint(1) DEFAULT NULL,
  `raf_degreelevel` tinyint(1) DEFAULT NULL,
  `raf_experience` tinyint(1) DEFAULT NULL,
  `raf_age` tinyint(1) DEFAULT NULL,
  `raf_education` tinyint(1) DEFAULT NULL,
  `raf_category` tinyint(1) DEFAULT NULL,
  `raf_subcategory` tinyint(1) DEFAULT NULL,
  `raf_location` tinyint(1) DEFAULT NULL,
  `serverstatus` varchar(255) DEFAULT NULL,
  `serverid` int(11) DEFAULT '0',
  `joblink` varchar(400) DEFAULT NULL,
  `jobapplylink` tinyint(1) DEFAULT NULL,
  `params` longtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `jobcategory` (`jobcategory`),
  KEY `jobs_companyid` (`companyid`),
  KEY `jobsalaryrange` (`jobsalaryrange`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `#__js_job_jobsearches`;
CREATE TABLE `#__js_job_jobsearches` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `uid` int(11) DEFAULT NULL,
 `searchname` varchar(50) NOT NULL,
 `searchparams` longtext NOT NULL,
 `params` longtext NOT NULL,
 `created` datetime DEFAULT NULL,
 `status` tinyint(1) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `jobsearches_uid` (`uid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `#__js_job_jobseekerpackages`;
CREATE TABLE `#__js_job_jobseekerpackages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `currencyid` int(11) DEFAULT NULL,
  `price` float DEFAULT NULL,
  `discount` int(11) DEFAULT NULL,
  `discounttype` tinyint(4) DEFAULT NULL,
  `discountmessage` varchar(500) DEFAULT NULL,
  `discountstartdate` datetime DEFAULT NULL,
  `discountenddate` datetime DEFAULT NULL,
  `resumeallow` int(11) NOT NULL DEFAULT '0',
  `coverlettersallow` int(11) NOT NULL DEFAULT '0',
  `applyjobs` int(11) NOT NULL DEFAULT '0',
  `jobsearch` int(11) NOT NULL DEFAULT '0',
  `savejobsearch` int(11) NOT NULL DEFAULT '0',
  `featuredresume` int(11) NOT NULL DEFAULT '0',
  `goldresume` int(11) NOT NULL DEFAULT '0',
  `video` tinyint(4) DEFAULT NULL,
  `packageexpireindays` int(11) DEFAULT NULL,
  `shortdetails` varchar(1000) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `status` tinyint(4) NOT NULL,
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `freaturedresumeexpireindays` int(11) DEFAULT NULL,
  `goldresumeexpireindays` int(11) DEFAULT NULL,
  `fastspringlink` varchar(1000) DEFAULT NULL,
  `otherpaymentlink` varchar(1000) DEFAULT NULL,
  `jobalertsetting` tinyint(1) DEFAULT NULL,
  `virtuemartproductid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
INSERT INTO `#__js_job_jobseekerpackages` (`id`, `title`, `currencyid`, `price`, `discount`, `discounttype`, `discountmessage`, `discountstartdate`, `discountenddate`, `resumeallow`, `coverlettersallow`, `applyjobs`, `jobsearch`, `savejobsearch`, `featuredresume`, `goldresume`, `video`, `packageexpireindays`, `shortdetails`, `description`, `status`, `created`, `freaturedresumeexpireindays`, `goldresumeexpireindays`, `fastspringlink`, `otherpaymentlink`, `jobalertsetting`) VALUES(1, 'Free Package', 1, 0, 0, 1, '', '2010-06-01 00:00:00', '2010-08-24 00:00:00', 1, 3, -1, 1, 1, 1, 1, 0, 365, 'Free Package', 'Free Package', 1, '2012-11-08 00:00:00', 30, 30, '', '', 1);

DROP TABLE IF EXISTS `#__js_job_jobstatus`;
CREATE TABLE `#__js_job_jobstatus` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL DEFAULT '',
  `isactive` tinyint(1) DEFAULT '1',
  `isdefault` tinyint(1) DEFAULT NULL,
  `ordering` int(11) DEFAULT NULL,
  `serverid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;
INSERT INTO `#__js_job_jobstatus` (`id`, `title`, `isactive`, `isdefault`, `ordering`, `serverid`) VALUES(1, 'Sourcing', 1, 0, 2, 0),(2, 'Interviewing', 1, 1, 1, 0),(3, 'Closed to New Applicants', 1, 0, 3, 0),(4, 'Finalists Identified', 1, 0, 5, 0),(5, 'Pending Approval', 1, 0, 6, 0),(6, 'Hold', 1, 0, 4, 0);

DROP TABLE IF EXISTS `#__js_job_jobs_temp`;
CREATE TABLE `#__js_job_jobs_temp` (
  `localid` int(11) NOT NULL AUTO_INCREMENT,
  `id` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `aliasid` varchar(255) DEFAULT NULL,
  `companyaliasid` varchar(255) DEFAULT NULL,
  `companylogo` varchar(255) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `jobdays` int(11) DEFAULT NULL,
  `companyid` int(11) DEFAULT NULL,
  `companyname` varchar(255) DEFAULT NULL,
  `jobcategory` varchar(255) DEFAULT NULL,
  `cat_title` varchar(255) DEFAULT NULL,
  `symbol` varchar(60) DEFAULT NULL,
  `salaryfrom` varchar(255) DEFAULT NULL,
  `salaryto` varchar(255) DEFAULT NULL,
  `salaytype` varchar(255) DEFAULT NULL,
  `jobtype` varchar(100) DEFAULT NULL,
  `jobstatus` varchar(100) DEFAULT NULL,
  `cityname` varchar(100) DEFAULT NULL,
  `statename` varchar(100) DEFAULT NULL,
  `countryname` varchar(100) DEFAULT NULL,
  `noofjobs` int(11) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  PRIMARY KEY (`localid`),
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `#__js_job_jobs_temp_time`;
CREATE TABLE `#__js_job_jobs_temp_time` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lastcalltime` datetime DEFAULT NULL,
  `expiretime` datetime DEFAULT NULL,
  `is_request` int(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `#__js_job_jobtypes`;
CREATE TABLE `#__js_job_jobtypes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL DEFAULT '',
  `isactive` tinyint(1) DEFAULT '1',
  `isdefault` tinyint(1) DEFAULT NULL,
  `ordering` int(11) DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `serverid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
INSERT INTO `#__js_job_jobtypes` (`id`, `title`, `isactive`, `isdefault`, `ordering`, `status`, `serverid`) VALUES(1, 'Full-Time', 1, 1, 1, 1, 1),(2, 'Part-Time', 1, 0, 2, 0, 0),(3, 'Internship', 1, 0, 3, 0, 0);

DROP TABLE IF EXISTS `#__js_job_paymenthistory`;
CREATE TABLE `#__js_job_paymenthistory` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) DEFAULT NULL,
  `packageid` int(11) NOT NULL,
  `packagetitle` varchar(255) NOT NULL,
  `packageprice` float DEFAULT NULL,
  `discountamount` int(11) DEFAULT NULL,
  `paidamount` int(11) DEFAULT NULL,
  `discountmessage` varchar(500) DEFAULT NULL,
  `packagediscountstartdate` datetime DEFAULT NULL,
  `packagediscountenddate` datetime DEFAULT NULL,
  `packageexpireindays` int(11) DEFAULT NULL,
  `packageshortdetails` varchar(255) DEFAULT NULL,
  `packagedescription` text DEFAULT NULL,
  `status` tinyint(4) NOT NULL,
  `created` datetime NOT NULL,
  `transactionverified` tinyint(4) DEFAULT NULL,
  `transactionautoverified` tinyint(4) DEFAULT NULL,
  `verifieddate` datetime DEFAULT NULL,
  `referenceid` varchar(150) DEFAULT NULL,
  `payer_firstname` varchar(150) DEFAULT NULL,
  `payer_lastname` varchar(150) DEFAULT NULL,
  `payer_email` varchar(255) DEFAULT NULL,
  `payer_amount` float DEFAULT NULL,
  `payer_itemname` varchar(255) DEFAULT NULL,
  `payer_itemname2` varchar(255) DEFAULT NULL,
  `payer_status` varchar(255) DEFAULT NULL,
  `payer_tx_token` varchar(255) DEFAULT NULL,
  `packagefor` tinyint(1) DEFAULT NULL,
  `currencyid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `payment_uid` (`uid`),
  KEY `payment_packageid` (`packageid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


DROP TABLE IF EXISTS `#__js_job_resume`;
CREATE TABLE `#__js_job_resume` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) DEFAULT NULL,
  `created` datetime NOT NULL,
  `last_modified` datetime DEFAULT NULL,
  `published` tinyint(1) DEFAULT NULL,
  `hits` int(11) DEFAULT NULL,
  `application_title` varchar(150) NOT NULL,
  `keywords` varchar(255) DEFAULT NULL,
  `alias` varchar(255) NOT NULL,
  `first_name` varchar(150) NOT NULL,
  `last_name` varchar(150) NOT NULL,
  `middle_name` varchar(150) DEFAULT NULL,
  `gender` varchar(10) DEFAULT NULL,
  `email_address` varchar(200) DEFAULT NULL,
  `home_phone` varchar(60) NOT NULL,
  `work_phone` varchar(60) DEFAULT NULL,
  `cell` varchar(60) DEFAULT NULL,
  `nationality` varchar(50) DEFAULT NULL,
  `iamavailable` tinyint(1) DEFAULT NULL,
  `searchable` tinyint(1) DEFAULT '1',
  `photo` varchar(150) DEFAULT NULL,
  `job_category` int(11) DEFAULT NULL,
  `jobsalaryrange` int(11) DEFAULT NULL,
  `jobsalaryrangetype` int(11) DEFAULT NULL,
  `jobtype` int(11) DEFAULT NULL,
  `heighestfinisheducation` varchar(60) DEFAULT NULL,
  `status` int(11) NOT NULL,
  `resume` text DEFAULT NULL,
  `date_start` datetime DEFAULT NULL,
  `desired_salary` int(11) DEFAULT NULL,
  `djobsalaryrangetype` int(11) DEFAULT NULL,
  `dcurrencyid` int(11) DEFAULT NULL,
  `can_work` varchar(250) DEFAULT NULL,
  `available` varchar(250) DEFAULT NULL,
  `unavailable` varchar(250) DEFAULT NULL,
  `experienceid` int(11) DEFAULT NULL,
  `total_experience` varchar(50) DEFAULT NULL,
  `skills` text DEFAULT NULL,
  `driving_license` tinyint(1) DEFAULT NULL,
  `license_no` varchar(100) DEFAULT NULL,
  `license_country` varchar(50) DEFAULT NULL,
  `packageid` int(11) DEFAULT NULL,
  `paymenthistoryid` int(11) DEFAULT NULL,
  `currencyid` int(11) DEFAULT NULL,
  `job_subcategory` int(11) DEFAULT NULL,
  `date_of_birth` datetime DEFAULT NULL,
  `video` varchar(50) DEFAULT NULL,
  `isgoldresume` tinyint(1) DEFAULT NULL,
  `startgolddate` date DEFAULT NULL,
  `endgolddate` date DEFAULT NULL,
  `isfeaturedresume` tinyint(1) DEFAULT NULL,
  `startfeatureddate` date DEFAULT NULL,
  `endfeaturedate` date DEFAULT NULL,
  `notifications` tinyint(1) NOT NULL DEFAULT '0',
  `serverstatus` varchar(255) DEFAULT NULL,
  `serverid` int(11) DEFAULT NULL,
  `jobsalaryrangestart` int(11) DEFAULT NULL,
  `jobsalaryrangeend` int(11) DEFAULT NULL,
  `desiredsalarystart` int(11) DEFAULT NULL,
  `desiredsalaryend` int(11) DEFAULT NULL,
  `videotype` tinyint(1) DEFAULT NULL,
  `isnotify` int(11) DEFAULT NULL,
  `notify_type` int(11) DEFAULT NULL,
  `params` longtext DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `#__js_job_resumeaddresses`;
CREATE TABLE `#__js_job_resumeaddresses` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `resumeid` int(11) NOT NULL,
  `address` text DEFAULT NULL,
  `address_country` varchar(100) DEFAULT NULL,
  `address_state` varchar(60) DEFAULT NULL,
  `address_city` varchar(100) DEFAULT NULL,
  `address_zipcode` varchar(60) DEFAULT NULL,
  `longitude` varchar(50) NOT NULL,
  `latitude` varchar(50) NOT NULL,
  `created` datetime NOT NULL,
  `last_modified` datetime DEFAULT NULL,
  `serverstatus` varchar(255) DEFAULT NULL,
  `serverid` int(11) DEFAULT NULL,
  `params` longtext DEFAULT NULL, 
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `#__js_job_resumereferences`;
CREATE TABLE `#__js_job_resumereferences` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `resumeid` int(11) NOT NULL,
  `reference` varchar(50) DEFAULT NULL,
  `reference_name` varchar(50) DEFAULT NULL,
  `reference_country` varchar(50) DEFAULT NULL,
  `reference_state` varchar(50) DEFAULT NULL,
  `reference_city` varchar(50) DEFAULT NULL,
  `reference_zipcode` varchar(25) DEFAULT NULL,
  `reference_address` varchar(150) DEFAULT NULL,
  `reference_phone` varchar(50) DEFAULT NULL,
  `reference_relation` varchar(50) DEFAULT NULL,
  `reference_years` varchar(10) DEFAULT NULL,
  `created` datetime NOT NULL,
  `last_modified` datetime DEFAULT NULL,
  `serverstatus` varchar(255) DEFAULT NULL,
  `serverid` int(11) DEFAULT NULL,
  `params` longtext DEFAULT NULL, 
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `#__js_job_resumeemployers`;
CREATE TABLE `#__js_job_resumeemployers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `resumeid` int(11) NOT NULL,
  `employer` varchar(250) DEFAULT NULL,
  `employer_position` varchar(150) DEFAULT NULL,
  `employer_resp` text DEFAULT NULL,
  `employer_pay_upon_leaving` varchar(250) DEFAULT NULL,
  `employer_supervisor` varchar(100) DEFAULT NULL,
  `employer_from_date` varchar(60) DEFAULT NULL,
  `employer_to_date` varchar(60) DEFAULT NULL,
  `employer_leave_reason` text DEFAULT NULL,
  `employer_country` varchar(100) DEFAULT NULL,
  `employer_state` varchar(100) DEFAULT NULL,
  `employer_city` varchar(100) DEFAULT NULL,
  `employer_zip` varchar(60) DEFAULT NULL,
  `employer_phone` varchar(60) DEFAULT NULL,
  `employer_address` varchar(150) DEFAULT NULL,
  `created` datetime NOT NULL,
  `last_modified` datetime DEFAULT NULL,
  `serverstatus` varchar(255) DEFAULT NULL,
  `serverid` int(11) DEFAULT NULL,
  `params` longtext DEFAULT NULL, 
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `#__js_job_resumefiles`;
CREATE TABLE `#__js_job_resumefiles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `resumeid` int(11) NOT NULL,
  `filename` varchar(300) DEFAULT NULL,
  `filetype` varchar(255) DEFAULT NULL,
  `filesize` int(11) DEFAULT NULL,
  `created` datetime NOT NULL,
  `last_modified` datetime DEFAULT NULL,
  `serverstatus` varchar(255) DEFAULT NULL,
  `serverid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `#__js_job_resumeinstitutes`;
CREATE TABLE `#__js_job_resumeinstitutes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `resumeid` int(11) NOT NULL,
  `institute` varchar(100) DEFAULT NULL,
  `institute_country` varchar(100) DEFAULT NULL,
  `institute_state` varchar(100) DEFAULT NULL,
  `institute_city` varchar(100) DEFAULT NULL,
  `institute_address` varchar(150) DEFAULT NULL,
  `institute_certificate_name` varchar(100) DEFAULT NULL,
  `institute_study_area` text DEFAULT NULL,
  `created` datetime NOT NULL,
  `last_modified` datetime DEFAULT NULL,
  `serverstatus` varchar(255) DEFAULT NULL,
  `serverid` int(11) DEFAULT NULL,
  `fromdate` datetime DEFAULT NULL,
  `todate` datetime DEFAULT NULL,
  `iscontinue` tinyint(4) DEFAULT NULL,
  `params` longtext DEFAULT NULL, 
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `#__js_job_resumelanguages`;
CREATE TABLE `#__js_job_resumelanguages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `resumeid` int(11) NOT NULL,
  `language` varchar(50) DEFAULT NULL,
  `language_reading` varchar(20) DEFAULT NULL,
  `language_writing` varchar(20) DEFAULT NULL,
  `language_understanding` varchar(20) DEFAULT NULL,
  `language_where_learned` varchar(250) DEFAULT NULL,
  `created` datetime NOT NULL,
  `last_modified` datetime DEFAULT NULL,
  `serverstatus` varchar(255) DEFAULT NULL,
  `serverid` int(11) DEFAULT NULL,
  `params` longtext DEFAULT NULL, 
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `#__js_job_resumesearches`;
CREATE TABLE `#__js_job_resumesearches` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) DEFAULT NULL,
  `searchname` varchar(50) NOT NULL,
  `searchparams` longtext DEFAULT NULL,
  `params` longtext DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


DROP TABLE IF EXISTS `#__js_job_roles`;
CREATE TABLE `#__js_job_roles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(50) DEFAULT NULL,
  `rolefor` tinyint(4) DEFAULT NULL,
  `companies` int(11) DEFAULT NULL,
  `jobs` int(11) DEFAULT NULL,
  `resumes` int(11) DEFAULT NULL,
  `coverletters` int(11) DEFAULT NULL,
  `searchjob` int(11) DEFAULT NULL,
  `searchresume` int(11) DEFAULT NULL,
  `savesearchresume` int(11) DEFAULT NULL,
  `savesearchjob` int(11) DEFAULT NULL,
  `published` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
INSERT INTO `#__js_job_roles` (`id`, `title`, `rolefor`, `companies`, `jobs`, `resumes`, `coverletters`, `searchjob`, `searchresume`, `savesearchresume`, `savesearchjob`, `published`) VALUES(1, 'employer', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1),(2, 'jobseeker', 2, 1, 1, 1, 1, 1, 1, 1, 1, 1);

DROP TABLE IF EXISTS `#__js_job_salaryrange`;
CREATE TABLE `#__js_job_salaryrange` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rangevalue` varchar(255) DEFAULT NULL,
  `rangestart` varchar(255) DEFAULT NULL,
  `rangeend` varchar(255) DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `isdefault` tinyint(1) DEFAULT NULL,
  `ordering` int(11) DEFAULT NULL,
  `serverid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ;
INSERT INTO `#__js_job_salaryrange` (`id`, `rangevalue`, `rangestart`, `rangeend`, `status`, `isdefault`, `ordering`, `serverid`) VALUES(1, NULL, '1000', '1500', 1, 1, 1, 0),(2, NULL, '1500', '2000', 1, 0, 2, 0),(3, NULL, '2000', '2500', 1, 0, 3, 0),(4, NULL, '2500', '3000', 1, 0, 4, 0),(5, NULL, '3000', '3500', 1, 0, 5, 0),(6, NULL, '3500', '4000', 1, 0, 6, 0),(7, NULL, '4000', '4500', 1, 0, 7, 0),(8, NULL, '4500', '5000', 1, 0, 8, 0),(9, NULL, '5000', '5500', 1, 0, 9, 0),(10, NULL, '5500', '6000', 1, 0, 10, 0),(11, NULL, '6000', '7000', 1, 0, 11, 0),(12, NULL, '7000', '8000', 1, 0, 12, 0),(13, NULL, '8000', '9000', 1, 0, 13, 0),(14, NULL, '9000', '10000', 1, 0, 14, 0),(15, NULL, '10000', '10000', 1, 0, 15, 0);

DROP TABLE IF EXISTS `#__js_job_salaryrangetypes`;
CREATE TABLE `#__js_job_salaryrangetypes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(45) NOT NULL,
  `status` tinyint(4) NOT NULL,
  `isdefault` tinyint(1) DEFAULT NULL,
  `ordering` int(11) DEFAULT NULL,
  `serverid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
INSERT INTO `#__js_job_salaryrangetypes` (`id`, `title`, `status`, `isdefault`, `ordering`, `serverid`) VALUES(1, 'Per Year', 1, 0, 1, 0),(2, 'Per Month', 1, 1, 2, 0),(3, 'Per Week', 1, 0, 3, 0),(4, 'Per Day', 1, 0, 4, 0);

DROP TABLE IF EXISTS `#__js_job_sharing_service_log`;
CREATE TABLE `#__js_job_sharing_service_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) DEFAULT NULL,
  `referenceid` int(11) DEFAULT NULL,
  `event` varchar(255) DEFAULT NULL,
  `eventtype` varchar(255) DEFAULT NULL,
  `message` text,
  `messagetype` varchar(255) DEFAULT NULL,
  `datetime` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `#__js_job_shifts`;
CREATE TABLE `#__js_job_shifts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL DEFAULT '',
  `isactive` tinyint(1) DEFAULT '1',
  `isdefault` tinyint(1) DEFAULT NULL,
  `ordering` int(11) DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `serverid` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
INSERT INTO `#__js_job_shifts` (`id`, `title`, `isactive`, `isdefault`, `ordering`, `status`, `serverid`) VALUES(1, 'Morning', 1, 1, 1, 0, 0),(2, 'Evening', 1, 0, 2, 0, 0),(3, '8 PM to 4 AM', 1, 0, 3, 0, 0);

DROP TABLE IF EXISTS `#__js_job_states`;
CREATE TABLE `#__js_job_states` (
  `id` smallint(8) NOT NULL AUTO_INCREMENT,
  `name` varchar(35) DEFAULT NULL,
  `shortRegion` varchar(25) DEFAULT NULL,
  `countryid` smallint(9) DEFAULT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT '0',
  `serverid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `countryid` (`countryid`),
  FULLTEXT KEY `name` (`name`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=91 ;
INSERT INTO `#__js_job_states` (`id`, `name`, `shortRegion`, `countryid`, `enabled`, `serverid`) VALUES(1, 'Alabama', 'AL', 1, 1, 0),(2, 'Alaska', 'AK', 1, 1, 0),(3, 'Arizona', 'AZ', 1, 1, 0),(4, 'Arkansas', 'AR', 1, 1, 0),(5, 'California', 'CA', 1, 1, 0),(6, 'Colorado', 'CO', 1, 1, 0),(7, 'Connecticut', 'CT', 1, 1, 0),(8, 'Delaware', 'DE', 1, 1, 0),(9, 'District of Columbia', 'DC', 1, 1, 0),(10, 'Florida', 'FL', 1, 1, 0),(11, 'Georgia', 'GA', 1, 1, 0),(12, 'Hawaii', 'HI', 1, 1, 0),(13, 'Idaho', 'ID', 1, 1, 0),(14, 'Illinois', 'IL', 1, 1, 0),(15, 'Indiana', 'IN', 1, 1, 0),(16, 'Iowa', 'IA', 1, 1, 0),(17, 'Kansas', 'KS', 1, 1, 0),(18, 'Kentucky', 'KY', 1, 1, 0),(19, 'Louisiana', 'LA', 1, 1, 0),(20, 'Maine', 'ME', 1, 1, 0),(21, 'Maryland', 'MD', 1, 1, 0),(22, 'Massachusetts', 'MA', 1, 1, 0),(23, 'Michigan', 'MI', 1, 1, 0),(24, 'Minnesota', 'MN', 1, 1, 0),(25, 'Mississippi', 'MS', 1, 1, 0),(26, 'Missouri', 'MO', 1, 1, 0),(27, 'Montana', 'MT', 1, 1, 0),(28, 'Nebraska', 'NE', 1, 1, 0),(29, 'Nevada', 'NV', 1, 1, 0),(30, 'New Hampshire', 'NH', 1, 1, 0),(31, 'New Jersey', 'NJ', 1, 1, 0),(32, 'New Mexico', 'NM', 1, 1, 0),(33, 'New York', 'NY', 1, 1, 0),(34, 'North Carolina', 'NC', 1, 1, 0),(35, 'North Dakota', 'ND', 1, 1, 0),(36, 'Ohio', 'OH', 1, 1, 0),(37, 'Oklahoma', 'OK', 1, 1, 0),(38, 'Oregon', 'OR', 1, 1, 0),(39, 'Pennsylvania', 'PA', 1, 1, 0),(40, 'Rhode Island', 'RI', 1, 1, 0),(41, 'South Carolina', 'SC', 1, 1, 0),(42, 'South Dakota', 'SD', 1, 1, 0),(43, 'Tennessee', 'TN', 1, 1, 0),(44, 'Texas', 'TX', 1, 1, 0),(45, 'Utah', 'UT', 1, 1, 0),(46, 'Vermont', 'VT', 1, 1, 0),(47, 'Virginia', 'VA', 1, 1, 0),(48, 'Washington', 'WA', 1, 1, 0),(49, 'West Virginia', 'WV', 1, 1, 0),(50, 'Wisconsin', 'WI', 1, 1, 0),(51, 'Wyoming', 'WY', 1, 1, 0),(52, 'Alberta', 'AB', 2, 1, 0),(53, 'British Columbia', 'BC', 2, 1, 0),(54, 'Manitoba', 'MB', 2, 1, 0),(55, 'New Brunswick', 'NB', 2, 1, 0),(56, 'Newfoundland and Labrador', 'NL', 2, 1, 0),(57, 'Northwest Territories', 'NT', 2, 1, 0),(58, 'Nova Scotia', 'NS', 2, 1, 0),(59, 'Nunavut', 'NU', 2, 1, 0),(60, 'Ontario', 'ON', 2, 1, 0),(61, 'Prince Edward Island', 'PE', 2, 1, 0),(62, 'Quebec', 'QC', 2, 1, 0),(63, 'Saskatchewan', 'SK', 2, 1, 0),(64, 'Yukon', 'YT', 2, 1, 0),(65, 'England', 'England', 95, 1, 0),(66, 'Northern Ireland', 'NorthernIreland', 95, 1, 0),(67, 'Scotland', 'Scottland', 95, 1, 0),(68, 'Wales', 'Wales', 95, 1, 0),(86, 'NWFP', 'NWFP', 126, 1, 0),(87, 'FATA', 'FATA', 126, 1, 0),(88, 'Balochistan', 'Balochistan', 126, 1, 0),(89, 'Punjab', 'Punjab', 126, 1, 0),(90, 'Capital', 'Capital', 126, 1, 0);

DROP TABLE IF EXISTS `#__js_job_subcategories`;
CREATE TABLE `#__js_job_subcategories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `categoryid` int(11) NOT NULL,
  `title` varchar(50) NOT NULL,
  `alias` varchar(225) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `isdefault` tinyint(1) DEFAULT NULL,
  `ordering` int(11) DEFAULT NULL,
  `serverid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `index_category_id` (`categoryid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=189 ;
INSERT INTO `#__js_job_subcategories` (`id`, `categoryid`, `title`, `alias`, `status`, `isdefault`, `ordering`, `serverid`) VALUES(1, 1, 'Cast Accounting ', 'cast-accounting-', 1, 0, 1, 0),(2, 1, 'Controllership & Accounting Managment', 'controllership-and-accounting-managment', 1, 0, 2, 0),(3, 1, 'Payroll ', 'payroll-', 1, 0, 3, 0),(4, 1, 'Corporate Finance', 'corporate-finance', 1, 0, 3, 0),(5, 2, 'Administrative Division', 'administrative-division', 1, 0, 1, 0),(6, 2, 'Autonomous Territories', 'autonomous-territories', 1, 0, 2, 0),(7, 2, 'Administrative County', 'administrative-county', 1, 0, 3, 0),(8, 2, 'Administrative Communes', 'administrative-communes', 1, 0, 3, 0),(9, 3, 'Finance Advertising ', 'finance-advertising-', 1, 0, 1, 0),(10, 3, 'Advertising-Tourism', 'advertising-tourism', 1, 0, 2, 0),(11, 3, 'Advertising Social Net', 'advertising-social-net', 1, 0, 3, 0),(12, 3, 'Distributor Marketing', 'distributor-marketing', 1, 0, 3, 0),(13, 3, 'Facebook Advertising', 'facebook-advertising', 1, 0, 5, 0),(14, 4, 'Quality Engineer ', 'quality-engineer-', 1, 0, 1, 0),(15, 4, 'Office Assistant ', 'office-assistant-', 1, 0, 2, 0),(16, 4, 'Air Host/hostess', 'air host-hostess', 1, 0, 3, 0),(17, 4, 'Ticketing/reservation', 'ticketing-reservation', 1, 0, 3, 0),(18, 5, 'Architectural Drafting', 'architectural-drafting', 1, 0, 1, 0),(19, 5, 'Enterprize Architecture', 'enterprize-architecture', 1, 0, 2, 0),(20, 5, 'Architecture Frameworks', 'architecture-frameworks', 1, 0, 3, 0),(21, 6, 'Automotive Design', 'automotive-design', 1, 0, 1, 0),(22, 6, 'Autmotive Paints', 'autmotive-paints', 1, 0, 2, 0),(23, 6, 'Automotive Equipment/Parts', 'automotive equipment-parts', 1, 0, 3, 0),(24, 6, 'Automotive Search Engine', 'automotive-search-engine', 1, 0, 3, 0),(25, 7, 'Private Banking', 'private-banking', 1, 0, 1, 0),(26, 7, 'Stock Brocker', 'stock-brocker', 1, 0, 2, 0),(27, 7, 'Fractional-reserve Banking', 'fractional-reserve-banking', 1, 0, 3, 0),(28, 7, 'Mobile Banking', 'mobile-banking', 1, 0, 4, 0),(29, 8, 'Plant Biotechnology', 'plant-biotechnology', 1, 0, 29, 0),(30, 8, 'Animal Biotechnology', 'animal-biotechnology', 1, 0, 30, 0),(31, 8, 'Biotechnology & Medicine', 'biotechnology-and-medicine', 1, 0, 31, 0),(32, 8, 'Biotechnology & Society', 'biotechnology-and-society', 1, 0, 32, 0),(33, 8, 'Industrail & Microbial Biotechnonogy', 'industrail-and-microbial-biotechnonogy', 1, 0, 33, 0),(34, 9, 'Construction (Design & Managment)', 'construction-(design-and-managment)', 1, 0, 34, 0),(35, 9, 'Construction Engineering ', 'construction-engineering-', 1, 0, 35, 0),(36, 9, 'Composite Construction', 'composite-construction', 1, 0, 36, 0),(37, 10, 'Civil Engineering', 'civil-engineering', 1, 0, 37, 0),(38, 10, 'Software Engineering', 'software-engineering', 1, 0, 38, 0),(39, 10, 'Nuclear Engineering', 'nuclear-engineering', 1, 0, 39, 0),(40, 10, 'Ocean Engingeering', 'ocean-engingeering', 1, 0, 40, 0),(41, 10, 'Transpotation Engineering', 'transpotation-engineering', 1, 0, 41, 0),(42, 11, 'Security Cleared Jobs', 'security-cleared-jobs', 1, 0, 42, 0),(43, 11, 'Security Cleared IT Jobs', 'security-cleared-it-jobs', 1, 0, 43, 0),(44, 11, 'Confidential & Secret Security Clearance Job', 'confidential-and-secret-security-clearance-job', 1, 0, 44, 0),(45, 12, 'Verbal', 'verbal', 1, 0, 1, 0),(46, 12, 'E-mail', 'e-mail', 1, 0, 2, 0),(47, 12, 'Non-verbal', 'non-verbal', 1, 0, 3, 0),(48, 13, 'Computer Consulting Services ', 'computer-consulting-services-', 1, 0, 1, 0),(49, 13, 'Computer Installations Services', 'computer-installations-services', 1, 0, 2, 0),(50, 13, 'Software Vendors', 'software-vendors', 1, 1, 3, 0),(51, 14, 'Renovaiton', 'renovaiton', 1, 0, 51, 0),(52, 14, 'Addition', 'addition', 1, 0, 52, 0),(53, 14, 'New Construction', 'new-construction', 1, 0, 53, 0),(54, 15, 'Organization Development', 'organization-development', 1, 0, 54, 0),(55, 15, 'Construction Management', 'construction-management', 1, 0, 55, 0),(56, 15, 'Managment Consulting ', 'managment-consulting-', 1, 0, 56, 0),(57, 16, 'High Touch Customer Service ', 'high-touch-customer-service-', 1, 0, 57, 0),(58, 16, 'Low Touch Customer Service', 'low-touch-customer-service', 1, 0, 58, 0),(59, 16, 'Bad Touch Customer Service', 'bad-touch-customer-service', 1, 0, 59, 0),(60, 17, 'By Using legal services for the poor', 'by-using-legal-services-for-the-poor', 1, 0, 60, 0),(61, 17, 'By Using Retained Counsel', 'by-using-retained-counsel', 1, 0, 61, 0),(62, 17, 'By Self-representation', 'by-self-representation', 1, 0, 62, 0),(63, 18, 'Project Subtype Design', 'project-subtype-design', 1, 0, 63, 0),(64, 18, 'Graphic Design', 'graphic-design', 1, 0, 64, 0),(65, 18, 'Interior Desing', 'interior-desing', 1, 0, 65, 0),(66, 19, 'IT or Engineering Education', 'it-or-engineering-education', 1, 0, 66, 0),(67, 19, 'Commerce & Managment', 'commerce-and-managment', 1, 0, 67, 0),(68, 19, 'Medical Education', 'medical-education', 1, 0, 68, 0),(69, 20, 'Power Engineering', 'power-engineering', 1, 0, 1, 0),(70, 20, 'Instrumentation', 'instrumentation', 1, 0, 2, 0),(71, 20, 'Telecommunication', 'telecommunication', 1, 0, 3, 0),(72, 20, 'Signal Processing', 'signal-processing', 1, 0, 4, 0),(73, 21, 'Electromagnetics', 'electromagnetics', 1, 0, 73, 0),(74, 21, 'Network Analysis', 'network-analysis', 1, 0, 74, 0),(75, 21, 'Control Systems', 'control-systems', 1, 0, 75, 0),(76, 22, 'Thermal Energy', 'thermal-energy', 1, 0, 76, 0),(77, 22, 'Chemical Energy', 'chemical-energy', 1, 0, 77, 0),(78, 22, 'Electrical Energy', 'electrical-energy', 1, 0, 78, 0),(79, 22, 'Nuclear Energy', 'nuclear-energy', 1, 0, 79, 0),(80, 23, 'Software Engineering ', 'software-engineering-', 1, 0, 80, 0),(81, 23, 'Civil Engineering ', 'civil-engineering-', 1, 0, 81, 0),(82, 23, 'Nuclear Engineering', 'nuclear-engineering', 1, 0, 82, 0),(83, 24, 'Nuclear Safety', 'nuclear-safety', 1, 0, 83, 0),(84, 24, 'Agriculture Safety', 'agriculture-safety', 1, 0, 84, 0),(85, 24, 'Occupational Health Safety', 'occupational-health-safety', 1, 0, 85, 0),(86, 25, 'Unique Fundraisers', 'unique-fundraisers', 1, 0, 86, 0),(87, 25, 'Sports Fundraiserse', 'sports-fundraiserse', 1, 0, 87, 0),(88, 25, 'Fundraisers', 'fundraisers', 1, 0, 88, 0),(89, 26, 'Staying Informed', 'staying-informed', 1, 0, 89, 0),(90, 26, 'Medical Edcuation ', 'medical-edcuation-', 1, 0, 90, 0),(91, 26, 'Managing a partucular disease', 'managing-a-partucular-disease', 1, 0, 91, 0),(92, 27, 'Customs & Border Protection', 'customs-and-border-protection', 1, 0, 92, 0),(93, 27, 'Federal Law & Enforcement', 'federal-law-and-enforcement', 1, 0, 93, 0),(94, 27, 'Nation Protection', 'nation-protection', 1, 0, 94, 0),(95, 28, 'Benefits Administrators', 'benefits-administrators', 1, 0, 95, 0),(96, 28, 'Executive Compensation Analysts', 'executive-compensation-analysts', 1, 0, 96, 0),(97, 28, 'Managment Analysts', 'managment-analysts', 1, 0, 97, 0),(98, 29, 'Health Insurance ', 'health-insurance-', 1, 0, 98, 0),(99, 29, 'Life Insurance', 'life-insurance', 1, 0, 99, 0),(100, 29, 'Vehicle Insurance', 'vehicle-insurance', 1, 0, 100, 0),(101, 30, 'Artificial Intelligence ', 'artificial-intelligence-', 1, 0, 101, 0),(102, 30, 'Predictive Analytics ', 'predictive-analytics-', 1, 0, 102, 0),(103, 30, 'Science & Technology', 'science-and-technology', 1, 0, 103, 0),(104, 31, 'Work Experience internship', 'work-experience-internship', 1, 0, 104, 0),(105, 31, 'Research internship', 'research-internship', 1, 0, 105, 0),(106, 31, 'Sales & Marketing Intern', 'sales-and-marketing-intern', 1, 0, 106, 0),(107, 32, 'According To Law', 'according-to-law', 1, 0, 107, 0),(108, 32, 'Defined Rule', 'defined-rule', 1, 0, 108, 0),(109, 33, 'Shipping ', 'shipping-', 1, 0, 109, 0),(110, 33, 'Transpotation Managment', 'transpotation-managment', 1, 0, 110, 0),(111, 33, 'Third-party Logistics Provider', 'third-party-logistics-provider', 1, 0, 111, 0),(112, 34, 'General Maintenance', 'general-maintenance', 1, 0, 112, 0),(113, 34, 'Automobile Maintenance ', 'automobile-maintenance-', 1, 0, 113, 0),(114, 34, 'Equipment Manitenance', 'equipment-manitenance', 1, 0, 114, 0),(115, 35, 'Project Managment', 'project-managment', 1, 0, 115, 0),(116, 35, 'Planning ', 'planning-', 1, 0, 116, 0),(117, 35, 'Risk Managment', 'risk-managment', 1, 0, 117, 0),(118, 36, 'Quality Assurance ', 'quality-assurance-', 1, 0, 118, 0),(119, 36, 'Product Manager', 'product-manager', 1, 0, 119, 0),(120, 36, 'Planning Supervisor ', 'planning-supervisor-', 1, 0, 120, 0),(121, 37, 'Networking ', 'networking-', 1, 0, 121, 0),(122, 37, 'Direct Mail Marketing', 'direct-mail-marketing', 1, 0, 122, 0),(123, 37, 'Media Advertising ', 'media-advertising-', 1, 0, 123, 0),(124, 38, 'Supply Chain ', 'supply-chain-', 1, 0, 124, 0),(125, 38, 'Hazardous Materials Management', 'hazardous-materials-management', 1, 0, 125, 0),(126, 38, 'Materials Inventory Managment', 'materials-inventory-managment', 1, 0, 126, 0),(127, 39, 'Aerospace ', 'aerospace-', 1, 0, 127, 0),(128, 39, 'Automotive ', 'automotive-', 1, 0, 128, 0),(129, 39, 'Biomedical', 'biomedical', 1, 0, 129, 0),(130, 39, 'Mechanical', 'mechanical', 1, 0, 130, 0),(131, 39, 'Naval', 'naval', 1, 0, 131, 0),(132, 40, 'Conventional Mortgage', 'conventional-mortgage', 1, 0, 132, 0),(133, 40, 'Adjustable Rate Mortgage', 'adjustable-rate-mortgage', 1, 0, 133, 0),(134, 40, 'Commercial Mortgages', 'commercial-mortgages', 1, 0, 134, 0),(135, 41, 'Economic Security', 'economic-security', 1, 0, 135, 0),(136, 41, 'Environmental Security', 'environmental-security', 1, 0, 136, 0),(137, 41, 'Military Security', 'military-security', 1, 0, 137, 0),(138, 42, 'Freelance Portfolios', 'freelance-portfolios', 1, 0, 138, 0),(139, 42, 'Freelance Freedom ', 'freelance-freedom-', 1, 0, 139, 0),(140, 42, 'Freelance Jobs', 'freelance-jobs', 1, 0, 140, 0),(141, 43, 'Offset Lithographp ', 'offset-lithographp-', 1, 0, 141, 0),(142, 43, 'Themography Raised Printing', 'themography-raised-printing', 1, 0, 142, 0),(143, 43, 'Digital Printing ', 'digital-printing-', 1, 0, 143, 0),(144, 44, 'idea Generation', 'idea-generation', 1, 0, 144, 0),(145, 44, 'Need Based Generation', 'need-based-generation', 1, 0, 145, 0),(146, 44, 'Design Solution', 'design-solution', 1, 0, 146, 0),(147, 45, 'Media Relations', 'media-relations', 1, 0, 147, 0),(148, 45, 'Media Tours ', 'media-tours-', 1, 0, 148, 0),(149, 45, 'Newsletters ', 'newsletters-', 1, 0, 149, 0),(150, 46, 'Automised Security', 'automised-security', 1, 0, 150, 0),(151, 46, 'Environmental & Social Safety', 'environmental-and-social-safety', 1, 0, 151, 0),(152, 47, 'Basic Research', 'basic-research', 1, 0, 152, 0),(153, 47, 'Applied Research', 'applied-research', 1, 0, 153, 0),(154, 47, 'Methods & Appraches ', 'methods-and-appraches-', 1, 0, 154, 0),(155, 48, 'Department Stores', 'department-stores', 1, 0, 155, 0),(156, 48, 'Discount Stores', 'discount-stores', 1, 0, 156, 0),(157, 48, 'Supermarkets', 'supermarkets', 1, 0, 157, 0),(158, 49, 'Sales Contracts ', 'sales-contracts-', 1, 0, 158, 0),(159, 49, 'Sales Forecasts ', 'sales-forecasts-', 1, 0, 159, 0),(160, 49, 'Sales Managment', 'sales-managment', 1, 0, 160, 0),(161, 50, 'Scientific Managment', 'scientific-managment', 1, 0, 161, 0),(162, 50, 'Scientific Research', 'scientific-research', 1, 0, 162, 0),(163, 50, 'Scientific invenctions ', 'scientific-invenctions-', 1, 0, 163, 0),(164, 51, 'Shppping/Distrubution Companies', 'shppping-distrubution companies', 1, 0, 164, 0),(165, 51, 'Services ', 'services-', 1, 0, 165, 0),(166, 51, 'Channels & Softwares', 'channels-and-softwares', 1, 0, 166, 0),(167, 52, 'Medical Technicians ', 'medical-technicians-', 1, 0, 167, 0),(168, 52, 'Electrical Technicians', 'electrical-technicians', 1, 0, 168, 0),(169, 52, 'Accounting Technicians ', 'accounting-technicians-', 1, 0, 169, 0),(170, 53, 'Construction Trade ', 'construction-trade-', 1, 0, 170, 0),(171, 53, 'Stock Trade', 'stock-trade', 1, 0, 171, 0),(172, 53, 'skilled Trade ', 'skilled-trade-', 1, 0, 172, 0),(173, 53, 'Option Trade ', 'option-trade-', 1, 0, 173, 0),(174, 54, 'Transpotation System', 'transpotation-system', 1, 0, 174, 0),(175, 54, 'Human-Powered ', 'human-powered-', 1, 0, 175, 0),(176, 54, 'Airline,Train,bus,car', 'airline,train,bus,car', 1, 0, 176, 0),(177, 55, 'Subway & Civil', 'subway-and-civil', 1, 0, 177, 0),(178, 55, 'Traffic Highway Transpotation', 'traffic-highway-transpotation', 1, 0, 178, 0),(179, 56, 'Small Business ', 'small-business-', 1, 0, 179, 0),(180, 56, 'E-Commerce Sites ', 'e-commerce-sites-', 1, 0, 180, 0),(181, 56, 'Portals ', 'portals-', 1, 0, 181, 0),(182, 56, 'Search Engines ', 'search-engines-', 1, 0, 182, 0),(183, 56, 'Personal,Commercial,Govt', 'personal,commercial,govt', 1, 0, 183, 0);

DROP TABLE IF EXISTS `#__js_job_userroles`;
CREATE TABLE `#__js_job_userroles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL,
  `role` int(11) NOT NULL,
  `dated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `#__js_job_zips`;
CREATE TABLE `#__js_job_zips` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `code` varchar(30) DEFAULT NULL,
  `enabled` char(1) DEFAULT 'Y',
  `countrycode` varchar(5) NOT NULL DEFAULT 'US',
  `statecode` varchar(50) DEFAULT NULL,
  `countycode` varchar(50) DEFAULT NULL,
  `citycode` varchar(50) DEFAULT NULL,
  `latitude` float DEFAULT NULL,
  `longitude` float DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `code` (`code`),
  KEY `countrystatecountycity` (`countrycode`,`statecode`,`countycode`,`citycode`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


CREATE TABLE IF NOT EXISTS `#__js_job_erasedatarequests` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL,
  `subject` varchar(250) NOT NULL,
  `message` text DEFAULT NULL,
  `status` int(11) NOT NULL,
  `created` datetime NOT NULL,
  PRIMARY KEY (`id`) 
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `#__js_job_emailtemplates_config` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `emailfor` varchar(255) NOT NULL,
  `admin` tinyint(1) NOT NULL,
  `employer` tinyint(1) NOT NULL,
  `jobseeker` tinyint(1) NOT NULL,
  `jobseeker_visitor` tinyint(1) NOT NULL,
  `employer_visitor` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=23 ;



INSERT INTO `#__js_job_emailtemplates_config` (`id`, `emailfor`, `admin`, `employer`, `jobseeker`, `jobseeker_visitor`, `employer_visitor`) VALUES
(10, 'applied_resume_status', 1, 1, 1, 1, 1),
(9, 'jobapply_jobapply', 1, 1, 1, 1, 1),
(8, 'add_new_job_visitor', 1, 1, 1, 1, 1),
(7, 'add_new_resume_visitor', 1, 1, 1, 1, 1),
(6, 'resume_status', 1, 1, 1, 1, 1),
(5, 'add_new_resume', 1, 1, 1, 1, 1),
(4, 'job_status', 1, 1, 1, 1, 1),
(3, 'add_new_job', 1, 1, 0, 1, 1),
(2, 'company_status', 1, 1, 0, 1, 1),
(1, 'add_new_company', 1, 1, 1, 1, 1),
(11, 'employer_purchase_package', 1, 1, 1, 1, 1),
(12, 'jobseeker_purchase_package', 1, 1, 1, 1, 1),
(13, 'employer_purchase', 1, 1, 1, 1, 1),
(14, 'jobseeker_purchase', 1, 1, 1, 1, 0),
(16, 'resume_status_visitor', 1, 1, 1, 1, 1),
(17, 'job_status_visitor', 1, 1, 1, 1, 1),
(18, 'add_new_department', 1, 1, 1, 1, 1),
(19, 'company_delete', 1, 1, 1, 1, 1),
(20, 'company_delete', 1, 1, 1, 1, 1),
(21, 'job_delete', 1, 1, 1, 1, 1),
(22, 'resume_delete', 1, 1, 1, 1, 1),
(23, 'erase_data', 0, 1, 1, 0, 0),
(24, 'receive_erase_data_request', 1, 0, 0, 0, 0);


INSERT INTO `#__js_job_emailtemplates` ( `uid`, `templatefor`, `title`, `subject`, `body`, `status`, `created`) VALUES
( 0, 'company-delete', NULL, 'JS Jobs: Your Company {COMPANY_NAME} has been deleted', '<div style="background: #6DC6DD; height: 20px;"></div>\n<p style="color: #2191ad;">Dear {COMPANY_OWNER_NAME} ,</p>\n<p style="color: #4f4f4f;">Your company <strong>{COMPANY_NAME}</strong> has been deleted.</p>\n<div style="margin-top: 10px; padding: 10px 20px; color: #000000; background: #FAF2F2; border: 1px solid #F7C1C1;">\n<p><span style="color: red;"><strong>*DO NOT REPLY TO THIS E-MAIL*</strong></span><br />\nThis is an automated e-mail message sent from our support system. Do not reply to this e-mail as we will not receive your reply! </p>\n</div>\n', NULL, '2009-08-17 17:54:48'),
( 0, 'job-delete', NULL, 'JS Jobs: Your job {JOB_TITLE} has been deleted.', '<div style="background: #6DC6DD; height: 20px;"></div>\n<p style="color: #2191ad;">Dear {EMPLOYER_NAME} ,</p>\n<p style="color: #4f4f4f;">{COMPANY_NAME} job <strong>{JOB_TITLE}</strong> has been deleted.</p>\n<div style="margin-top: 10px; padding: 10px 20px; color: #000000; background: #FAF2F2; border: 1px solid #F7C1C1;">\n<p><span style="color: red;"><strong>*DO NOT REPLY TO THIS E-MAIL*</strong></span><br />\nThis is an automated e-mail message sent from our support system. Do not reply to this e-mail as we will not receive your reply!</p>\n</div>\n', NULL, '2009-08-17 22:12:43'),
( 0, 'resume-delete', '', 'JS Jobs: Your Resume {RESUME_TITLE} has been deleted', '<div style="background: #6DC6DD; height: 20px;"></div>\n\n<p style="color: #2191ad;">\nDear {JOBSEEKER_NAME} ,</p>\n<p style="color: #4f4f4f;">\nYour Resume <strong>{RESUME_TITLE}</strong> has been deleted.</p>\n\n<div style="margin-top: 10px; padding: 10px 20px; color: #000000; background: #FAF2F2; border: 1px solid #F7C1C1;">\n\n<p><span style="color: red;">\n<strong>*DO NOT REPLY TO THIS E-MAIL*</strong></span>\n<br />\nThis is an automated e-mail message sent from our support system. Do not reply to this e-mail as we will not receive your reply!\n</p>\n</div>\n', NULL, '2009-08-17 17:54:48'),
( 0, 'jobapply-jobseeker', NULL, 'JS Jobs: Applied for {JOB_TITLE} job', '<div style="background: #6DC6DD; height: 20px;"></div>\n<p style="color: #2191ad;">Hello {JOBSEEKER_NAME} ,</p>\n<p style="color: #4f4f4f;">you have to applied for <strong>{JOB_TITLE}</strong> job in <strong>{COMPANY_NAME}</strong> company by <strong>{RESUME_TITLE}</strong> resume</p>\n<p style="color: #4f4f4f;">your resume has been {RESUME_APPLIED_STATUS} .</p>\n<div style="margin-top: 10px; padding: 10px 20px; color: #000000; background: #FAF2F2; border: 1px solid #F7C1C1;">\n<p><span style="color: red;"><strong>*DO NOT REPLY TO THIS E-MAIL*</strong></span><br />\nThis is an automated e-mail message sent from our support system. Do not reply to this e-mail as we will not receive your reply!</p>\n</div>\n', NULL, '2009-08-18 16:46:16'),
( 0, 'resume-new-vis', NULL, 'JS Jobs:  New resume {RESUME_TITLE} has beed received', '<div style="background: #6DC6DD; height: 20px;"></div>\n<p style="color: #2191ad;">Hello {JOBSEEKER_NAME} ,</p>\n<p style="color: #4f4f4f;">We receive new resume.<strong>{RESUME_TITLE}</strong></p>\n<p style="color: #4f4f4f;">your resume has been <strong>{RESUME_STATUS}</strong></p>\n<p style="color: #4f4f4f;">Click here to view {RESUME_LINK}.</p>\n<div style="margin-top: 10px; padding: 10px 20px; color: #000000; background: #FAF2F2; border: 1px solid #F7C1C1;">\n<p><span style="color: red;"><strong>*DO NOT REPLY TO THIS E-MAIL*</strong></span><br />\nThis is an automated e-mail message sent from our support system. Do not reply to this e-mail as we will not receive your reply!</p>\n</div>\n', NULL, '0000-00-00 00:00:00'),
( 0, 'erase-user-data', NULL, '{SITE_TITLE}: User Erase Data Request', '<div style=\"background: #6DC6DD; height: 20px;\"> </div>\r\n<p style=\"color: #2191ad;\">Hello {USERNAME} ,</p>\r\n<p style=\"color: #4f4f4f;\">Your data has been erased successfully.</p>\r\n<p style=\"color: #4f4f4f;\"><span style=\"color: red;\"><strong>*DO NOT REPLY TO THIS E-MAIL*</strong></span><br /> This is an automated e-mail message sent from our support system. Do not reply to this e-mail as we will not receive your reply!</p>\r\n<div style=\"margin-top: 10px; padding: 10px 20px; color: #000000; background: #FAF2F2; border: 1px solid #F7C1C1;\"> </div>', NULL, '2020-04-02 07:28:47'),
( 0, 'erase-date-request-receive', NULL, '{SUBJECT}', '<div style=\"background: #6DC6DD; height: 20px;\"> </div>\r\n<p style=\"color: #2191ad;\">Hello admin,</p>\r\n<p style=\"color: #4f4f4f;\">{NAME} has been requested to erase data.</p>\r\n<p style=\"color: #4f4f4f;\"><span style=\"color: red;\"><strong>*DO NOT REPLY TO THIS E-MAIL*</strong></span><br /> This is an automated e-mail message sent from our support system. Do not reply to this e-mail as we will not receive your reply!</p>\r\n<div style=\"margin-top: 10px; padding: 10px 20px; color: #000000; background: #FAF2F2; border: 1px solid #F7C1C1;\"> </div>', NULL, '2020-04-02 07:28:47');

