text: /*
  SQLyog Ultimate v13.1.1 (64 bit)
  MySQL - 8.0.17 : Database - hrgulf_recruitment
  *********************************************************************
  */
  
  /*!40101 SET NAMES utf8 */;
  
  /*!40101 SET SQL_MODE=''*/;
  
  /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  CREATE DATABASE /*!32312 IF NOT EXISTS*/`hrgulf_recruitment` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;
  
  USE `hrgulf_recruitment`;
  
  /*Table structure for table `core_avatars` */
  
  DROP TABLE IF EXISTS `core_avatars`;
  
  CREATE TABLE `core_avatars` (
    `id` int(11) unsigned NOT NULL,
    `url` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    `originUrl` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    `scale` double NOT NULL DEFAULT '1',
    `borderRadius` int(6) NOT NULL DEFAULT '0',
    `xPosition` double NOT NULL DEFAULT '0.5',
    `yPosition` double NOT NULL DEFAULT '0.5',
    `rotate` int(3) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  
  /*Data for the table `core_avatars` */
  
  /*Table structure for table `core_career_levels` */
  
  DROP TABLE IF EXISTS `core_career_levels`;
  
  CREATE TABLE `core_career_levels` (
    `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
    `level` int(2) NOT NULL DEFAULT '0',
    `careerLevel_en` varchar(100) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    `careerLevel_ar` varchar(100) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    `deletedDate` varchar(12) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  
  /*Data for the table `core_career_levels` */
  
  insert  into `core_career_levels`(`id`,`level`,`careerLevel_en`,`careerLevel_ar`,`deletedDate`) values 
  (1,1,'Student/Internship','Student/Internship',''),
  (2,2,'Fresh Graduate','Fresh Graduate',''),
  (3,3,'Entry Level','Entry Level',''),
  (4,4,'Mid Level','Mid Level',''),
  (5,5,'Management','Management',''),
  (6,6,'Director/Head','Director/Head',''),
  (7,7,'Senior Executive','Senior Executive','');
  
  /*Table structure for table `core_cities` */
  
  DROP TABLE IF EXISTS `core_cities`;
  
  CREATE TABLE `core_cities` (
    `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
    `countryId` int(11) NOT NULL DEFAULT '0',
    `city_en` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    `city_ar` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    `deletedDate` varchar(12) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=280 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  
  /*Data for the table `core_cities` */
  
  insert  into `core_cities`(`id`,`countryId`,`city_en`,`city_ar`,`deletedDate`) values 
  (1,1,'Manama','المنامة',''),
  (2,1,'Riffa','الرفاع',''),
  (3,1,'Muharraq','المحرق',''),
  (4,1,'Hamad Town','مدينة حمد',''),
  (5,1,'A\'ali','عالي',''),
  (6,1,'Isa Town','مدينة عيسى',''),
  (7,1,'Sitra','سترة',''),
  (8,1,'Budaiya','البديع',''),
  (9,1,'Jidhafs','جدحفص',''),
  (10,1,'Al-Malikiyah','المالكية',''),
  (11,1,'Jid Ali','جد علي',''),
  (12,1,'Adliya','العدلية',''),
  (13,1,'Sanabis','السنابس',''),
  (14,1,'Tubli','توبلي',''),
  (15,1,'AlSeef','السيف',''),
  (16,1,'Saar','سار',''),
  (17,1,'Mahooz','الماحوز',''),
  (18,1,'Al Dur','الدار',''),
  (19,1,'Hoora','الحورة',''),
  (20,1,'Qudaibiya','القضيبية',''),
  (21,1,'Salmabad','سلماباد',''),
  (22,1,'Jurdab','جرداب',''),
  (23,1,'Amwaj Island','امواج',''),
  (24,1,'Hidd','الحد',''),
  (25,1,'Arad','عراد',''),
  (26,1,'Busaiteen','البسيتين',''),
  (27,2,'Al Ahmadi','الاحمدي',''),
  (28,2,'Hawalli','حولي',''),
  (29,2,'Al Salimiyah','السالمية',''),
  (30,2,'Sabah Al Salim','صباح السالم',''),
  (31,2,'Al Farwaniyah','الفروانية',''),
  (32,2,'Al Fahahil','الفحيحيل',''),
  (33,2,'Kuwait City','الكويت',''),
  (34,2,'Al Rumaythiyah','الرميثية',''),
  (35,2,'Al Riqqah','الرقة',''),
  (36,2,'Salwa','سلوى',''),
  (37,2,'Al Manqaf','المنقف',''),
  (38,2,'Al Rabiyah','الرابية',''),
  (39,2,'Bayan','بيان',''),
  (40,2,'Al Jahra\'','الجهراء',''),
  (41,2,'Al Fintas','الفنطاس',''),
  (42,2,'Janub as Surrah','جنوب السرة',''),
  (43,2,'Al Mahbulah','المهبولة',''),
  (44,2,'Al Dasmah','الدسمة',''),
  (45,2,'Al Shamiyah','الشامية',''),
  (46,2,'Al Wafrah','الوفرة',''),
  (47,2,'Al Zawr','الزور',''),
  (48,2,'Mubarak al Kabir','مبارك الكبير',''),
  (49,3,'Adam','آدم',''),
  (50,3,'Al Sib','السيب',''),
  (51,3,'Al Ashkharah','الاشخرة',''),
  (52,3,'Al Buraimi','البريمي',''),
  (53,3,'Al Hamra','الحمراء',''),
  (54,3,'Al Jazer','الجزيرة',''),
  (55,3,'Al Madina A\'Zarqa','المدينة الزرقاء',''),
  (56,3,'Al Suwaiq','الشويق',''),
  (57,3,'Bahla','بهلاء',''),
  (58,3,'Barka','بركاء',''),
  (59,3,'Bidbid','بدبد',''),
  (60,3,'Bidiya','بدية',''),
  (61,3,'Duqm','الدقم',''),
  (62,3,'Haima','هيماء',''),
  (63,3,'Ibra','ابراء',''),
  (64,3,'Ibri','عبري',''),
  (65,3,'Izki','إزكي',''),
  (66,3,'Jabrin','جبرين',''),
  (67,3,'Jalan Bani Bu Hassan','جعلان بني بو حسن',''),
  (68,3,'Khasab','خصب',''),
  (69,3,'Mahooth','محوت',''),
  (70,3,'Manah','منح',''),
  (71,3,'Matrah','مطرح',''),
  (72,3,'Mudhaybi','المضيبي',''),
  (73,3,'Mudhaireb','المضيرب',''),
  (74,3,'Muscat','مسقط',''),
  (75,3,'Nizwa','نزوى',''),
  (76,3,'Quriyat','قريات',''),
  (77,3,'Raysut','ريسوت',''),
  (78,3,'Rustaq','الرستاق',''),
  (79,3,'Ruwi','روي',''),
  (80,3,'Saham','صحم',''),
  (81,3,'Shinas','شناص',''),
  (82,3,'Saiq','سايك',''),
  (83,3,'Salalah','صلالة',''),
  (84,3,'Samail','سمائل',''),
  (85,3,'Sohar','صحار',''),
  (86,3,'Sur','صور',''),
  (87,3,'Tan`am','تنعم',''),
  (88,3,'Thumrait','ثمريت',''),
  (89,4,'Doha','الدوحة',''),
  (90,4,'Alrayyan','الريان',''),
  (91,4,'Alwakra','الوكرة',''),
  (92,4,'Umm Said','امسيعيد',''),
  (93,4,'Khor Al Udaid','خور العديد',''),
  (94,4,'Alkhor','الخور',''),
  (95,4,'Ras Laffan','راس لفان',''),
  (96,4,'Mesaieed','مسيعيد',''),
  (97,4,'Madinat Al Shamal','مدينة الشمال',''),
  (98,4,'Al Ruwais','الرويس',''),
  (99,4,'Al Zubara','الزبارة',''),
  (100,4,'Dukhan','دخان',''),
  (101,5,'Uyayna','العيينة',''),
  (102,5,'Abha','أبها',''),
  (103,5,'Ad-Dilam','الدلم',''),
  (104,5,'Al Artaweeiyah','الأرطاوية',''),
  (105,5,'Al Bahah','الباحة',''),
  (106,5,'Al Bukayriyah','البكيرية',''),
  (107,5,'Al Jafr','الجفر',''),
  (108,5,'Al Jawf','الجوف',''),
  (109,5,'Al Lith','الليث',''),
  (110,5,'Al Majma\'ah','المجمعة',''),
  (111,5,'Al Mawain','الماوين',''),
  (112,5,'Al Mikhwah','الخواة',''),
  (113,5,'Al Qunfudhah','القنفذة',''),
  (114,5,'Al Wajh','الوجة',''),
  (115,5,'Al-`Ula','العلا',''),
  (116,5,'Al-Abwa','الأبواء',''),
  (117,5,'Al-Gwei\'iyyah','القويعية',''),
  (118,5,'Al-Hareeq','الحريق',''),
  (119,5,'Al-Khutt','الخط',''),
  (120,5,'Al-Mubarraz','المبرز',''),
  (121,5,'Al-Namas','النماص',''),
  (122,5,'Al-Omran','العمران',''),
  (123,5,'Al-Saih','السيح',''),
  (124,5,'Ar Rass','الرس',''),
  (125,5,'Al Sulayyil','السليل',''),
  (126,5,'Al Zaimah','الزيمة',''),
  (127,5,'Badr','بدر',''),
  (128,5,'Baljurashi','بلجرشي',''),
  (129,5,'Bareg','رابغ',''),
  (130,5,'Bisha','بيشة',''),
  (131,5,'Buq a','',''),
  (132,5,'Buraydah','بريدة',''),
  (133,5,'Dahaban','ذهبان',''),
  (134,5,'Dammam','دمام',''),
  (135,5,'Dawadmi','الدوادمي',''),
  (136,5,'Dhahran','ظهران',''),
  (137,5,'Dhurma','ضرما',''),
  (138,5,'Diriyah','الدرعية',''),
  (139,5,'Duba','ضبا',''),
  (140,5,'Dumat Al-Jandal','دومة الجندل',''),
  (141,5,'Farasan city','فرسان',''),
  (142,5,'Gatgat','الجتجات',''),
  (143,5,'Gerrha','جرهاء',''),
  (144,5,'Gurayat','القريات',''),
  (145,5,'Ha\'il','حائل',''),
  (146,5,'Habaala','الحلبة',''),
  (147,5,'Hafr Al-Batin','حفر الباطن',''),
  (148,5,'Hajrah','الحجره',''),
  (149,5,'Haql','حقل',''),
  (150,5,'Harmah','حرمة',''),
  (151,5,'Hautat Sudair','حوطة سدير',''),
  (152,5,'Hofuf','الهفوف',''),
  (153,5,'Hotat Bani Tamim','حوطة بني تميم',''),
  (154,5,'Huraymila','حريملاء',''),
  (155,5,'Jabal Umm al Ru\'us','جبل أم الرؤوس',''),
  (156,5,'Jalajil','جلاجل',''),
  (157,5,'Jeddah','جدة',''),
  (158,5,'Jizan','جيزان',''),
  (159,5,'Jizan Economic City','مدينة جيزان الأقتصاديه',''),
  (160,5,'Jubail','الجبيل',''),
  (161,5,'Khafji','الخفجي',''),
  (162,5,'Khamis Mushayt','خميس مشيط',''),
  (163,5,'Khaybar','خيبر',''),
  (164,5,'Khobar','الخبر',''),
  (165,5,'King Abdullah Economic City','مدينة الملك عبدالله الأقتصاديه',''),
  (166,5,'Knowledge Economic City','مدينة المعرفة الاقتصادية',''),
  (167,5,'Layla','ليلى',''),
  (168,5,'Lhiyan','لحيان',''),
  (169,5,'Mastoorah','مستورة',''),
  (170,5,'Mecca','مكة',''),
  (171,5,'Medina','المدينة المنورة',''),
  (172,5,'Muzahmiyya','المزاحمية',''),
  (173,5,'Najran','نجران',''),
  (174,5,'Omloj','املج',''),
  (175,5,'Qadeimah','القضيمة',''),
  (176,5,'Qaisumah','القيصومة',''),
  (177,5,'Qatif','القطيف',''),
  (178,5,'Rabigh','رابغ',''),
  (179,5,'Rafha','رفحاء',''),
  (180,5,'Ras Tanura','راس تنوره',''),
  (181,5,'Riyadh','الرياض',''),
  (182,5,'Riyadh Al-Khabra','رياض الخبراء',''),
  (183,5,'Rumailah','الرميلة',''),
  (184,5,'Sabt Al Alaya','سبت العلايه',''),
  (185,5,'Safwa city','صفوى',''),
  (186,5,'Saihat','سيهات',''),
  (187,5,'Sakakah','سكاكا',''),
  (188,5,'Sarat Abidah','سراة عبيدة',''),
  (189,5,'Shaqraa','شقراء',''),
  (190,5,'Sharurah','شرورة',''),
  (191,5,'Shaybah','الشيبة',''),
  (192,5,'Tabarjal','طبرجل',''),
  (193,5,'Tabuk','تبوك',''),
  (194,5,'Taif','الطايف',''),
  (195,5,'Tanomah','تنومة',''),
  (196,5,'Tarout','تاروت',''),
  (197,5,'Tayma','تيماء',''),
  (198,5,'Thadiq','ثادق',''),
  (199,5,'Thuqbah','الثقبة',''),
  (200,5,'Thuwal','ثول',''),
  (201,5,'Turaif','طريف',''),
  (202,5,'Udhailiyah','العضيلية',''),
  (203,5,'Um Al-Sahek','ام الساهك',''),
  (204,5,'Unaizah','عنيزة',''),
  (205,5,'Uqair','العقير',''),
  (206,5,'Uyun AlJiwa','عيون الجواء',''),
  (207,5,'Wadi Al-Dawasir','وادي الدواسر',''),
  (208,5,'Yanbu','ينبع',''),
  (209,5,'Zulfi','الزلفي',''),
  (210,6,'Dubai','دبي',''),
  (211,6,'Abu Dhabi City','ابوظبي',''),
  (212,6,'Sharjah City','الشارقة',''),
  (213,6,'Al Ain','العين',''),
  (214,6,'Ajman City','عجمان',''),
  (215,6,'Ras Al Khaimah','راس الخيمة',''),
  (216,6,'Fujairah City','الفجيرة',''),
  (217,6,'Umm al-Quwain','ام القيوين',''),
  (218,6,'Khor Fakkan','خور فكان',''),
  (219,6,'Kalba','كلباء',''),
  (220,6,'Jebel Ali','جبال علي',''),
  (221,6,'Dibba Al-Fujairah','دبا الفجيرة',''),
  (222,6,'Madinat Zayed','مدينة زايد',''),
  (223,6,'Liwa Oasis','واحة ليوا',''),
  (224,6,'Dhaid','الذيد',''),
  (225,6,'Al Quoz','القوز',''),
  (226,6,'Ruwais','الرويس',''),
  (227,6,'Ghayathi','غياثي',''),
  (228,6,'Al-Rams','الرمس',''),
  (229,6,'Dibba Al-Hisn','دبا الحصن',''),
  (230,6,'Hatta','حتا',''),
  (231,6,'Al Madam','المدام',''),
  (232,6,'Abu al Abyad','ابو الابيض',''),
  (233,6,'Adhen','اذن',''),
  (234,6,'Al Ajban','العجبان',''),
  (235,6,'Al Aryam','الاريام',''),
  (236,6,'Al Awir','العوير',''),
  (237,6,'Al Badiyah','البادية',''),
  (238,6,'Al Bataeh','البطائح',''),
  (239,6,'Al Bithnah','البثنة',''),
  (240,6,'Al Faqa','الفقع',''),
  (241,6,'Al Halah','الحالة',''),
  (242,6,'Al Hamraniyah','الحمرانية',''),
  (243,6,'Al Hamriyah','الحمرية',''),
  (244,6,'Al Jazirah Al Hamra','الجزيرة الحمراء',''),
  (245,6,'Al Jeer','الجير',''),
  (246,6,'Al Khawaneej','الخوانيج',''),
  (247,6,'Al Lisaili','الليسيلي',''),
  (248,6,'Al Manama','المنامة',''),
  (249,6,'Al Mirfa','المرفأ',''),
  (250,6,'Al Qor','الخور',''),
  (251,6,'Al Qusaidat','القسيدات',''),
  (252,6,'Al Rafaah','الرفاعة',''),
  (253,6,'Al Rashidya','الراشدية',''),
  (254,6,'Al Shuwaib','الشويب',''),
  (255,6,'Al Yahar','اليحر',''),
  (256,6,'Asimah','اعسمه',''),
  (257,6,'Dadna','ضدنا',''),
  (258,6,'Dalma','دلما',''),
  (259,6,'Digdaga','ديغاغا',''),
  (260,6,'Falaj Al Mualla','فلج المعلا',''),
  (261,6,'Ghalilah','غليلة',''),
  (262,6,'Ghub','',''),
  (263,6,'Habshan','حبشان',''),
  (264,6,'Huwaylat','الحويلات',''),
  (265,6,'Khatt','خت',''),
  (266,6,'Khor Khwair','خور خوير',''),
  (267,6,'Lahbab','لهباب',''),
  (268,6,'Marawah','المروة',''),
  (269,6,'Masafi','مسافي',''),
  (270,6,'Masfut','مصفوت',''),
  (271,6,'Mirbah','مربح',''),
  (272,6,'Mleiha','مليحة',''),
  (273,6,'Nahil','ناهل',''),
  (274,6,'Sha\'am','شعم',''),
  (275,6,'Sila','السلع',''),
  (276,6,'Sir Bani Yas','صير بني ياس',''),
  (277,6,'Sweihan','سويحان',''),
  (278,6,'Wadi Shah','وادي شاه',''),
  (279,6,'Zubarah','الزبارة','');
  
  /*Table structure for table `core_countries` */
  
  DROP TABLE IF EXISTS `core_countries`;
  
  CREATE TABLE `core_countries` (
    `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
    `countryCode` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    `dialCode` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    `country_en` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    `country_ar` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    `deletedDate` varchar(12) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  
  /*Data for the table `core_countries` */
  
  insert  into `core_countries`(`id`,`countryCode`,`dialCode`,`country_en`,`country_ar`,`deletedDate`) values 
  (1,'BH','+973','Bahrain','البحرين',''),
  (2,'KW','+965','Kuwait','الكويت',''),
  (3,'OM','+968','Oman','سلطنة عمان',''),
  (4,'QA','+974','Qatar','دولة قطر',''),
  (5,'SA','+966','Saudi Arabia','المملكة العربية السعودية',''),
  (6,'AE','+971','UAE','الإمارات العربية المتحدة','');
  
  /*Table structure for table `core_degrees` */
  
  DROP TABLE IF EXISTS `core_degrees`;
  
  CREATE TABLE `core_degrees` (
    `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
    `level` int(2) NOT NULL DEFAULT '0',
    `degree_en` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    `degree_ar` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    `deletedDate` varchar(12) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  
  /*Data for the table `core_degrees` */
  
  insert  into `core_degrees`(`id`,`level`,`degree_en`,`degree_ar`,`deletedDate`) values 
  (1,1,'High school or equivalent','High school or equivalent',''),
  (2,2,'Certification / diploma','Certification / diploma',''),
  (3,3,'Bachelor\'s degree / higher diploma','Bachelor\'s degree / higher diploma',''),
  (4,4,'Master\'s degree','Master\'s degree',''),
  (5,5,'Doctorate','Doctorate','');
  
  /*Table structure for table `core_employment_types` */
  
  DROP TABLE IF EXISTS `core_employment_types`;
  
  CREATE TABLE `core_employment_types` (
    `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
    `employmentType_en` varchar(100) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    `employmentType_ar` varchar(100) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    `deletedDate` varchar(12) COLLATE utf8mb4_general_ci DEFAULT '',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  
  /*Data for the table `core_employment_types` */
  
  insert  into `core_employment_types`(`id`,`employmentType_en`,`employmentType_ar`,`deletedDate`) values 
  (1,'Commission','Commission',''),
  (2,'Contractor','Contractor',''),
  (3,'Freelancer','Freelancer',''),
  (4,'Full Time Employee','Full Time Employee',''),
  (5,'Internship','Internship',''),
  (6,'Part Time Employee','Part Time Employee',''),
  (7,'Temporary Employee','Temporary Employee',''),
  (8,'Volunteer','Volunteer','');
  
  /*Table structure for table `core_industries` */
  
  DROP TABLE IF EXISTS `core_industries`;
  
  CREATE TABLE `core_industries` (
    `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
    `sectorId` int(11) NOT NULL DEFAULT '0',
    `industry_en` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    `industry_ar` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    `deletedDate` varbinary(12) NOT NULL DEFAULT '',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=163 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  
  /*Data for the table `core_industries` */
  
  insert  into `core_industries`(`id`,`sectorId`,`industry_en`,`industry_ar`,`deletedDate`) values 
  (1,1,'Animal Production','Animal Production',''),
  (2,1,'Fishing','Fishing',''),
  (3,1,'Forestry & Logging','Forestry & Logging',''),
  (4,1,'Livestock','Livestock',''),
  (5,1,'Agriculture & Crop Production','Agriculture & Crop Production',''),
  (6,2,'Broadcast Media Production','Broadcast Media Production',''),
  (7,2,'Music Production','Music Production',''),
  (8,2,'Performing Arts','Performing Arts',''),
  (9,2,'Video & Film Production','Video & Film Production',''),
  (10,2,'Entertainment','Entertainment',''),
  (11,2,'Fashion Design','Fashion Design',''),
  (12,2,'Graphic Design','Graphic Design',''),
  (13,2,'Journalism','Journalism',''),
  (14,2,'Media Production','Media Production',''),
  (15,2,'Modeling & Talent Agency','Modeling & Talent Agency',''),
  (16,2,'Photography','Photography',''),
  (17,2,'Publishing','Publishing',''),
  (18,3,'Administration Support Services','Administration Support Services',''),
  (19,3,'Advertising','Advertising',''),
  (20,3,'Business Consultancy Services','Business Consultancy Services',''),
  (21,3,'Business Process Outsourcing (BPO)','Business Process Outsourcing (BPO)',''),
  (22,3,'Business Support Services','Business Support Services',''),
  (23,3,'Call Centers & Customer Care Outsourcing','Call Centers & Customer Care Outsourcing',''),
  (24,3,'Events Management','Events Management',''),
  (25,3,'Human Resources Outsourcing','Human Resources Outsourcing',''),
  (26,3,'Knowledge Process Outsourcing (KPO)','Knowledge Process Outsourcing (KPO)',''),
  (27,3,'Legal Process Outsourcing (LPO)','Legal Process Outsourcing (LPO)',''),
  (28,3,'Management Consulting','Management Consulting',''),
  (29,3,'Market Research','Market Research',''),
  (30,3,'Marketing','Marketing',''),
  (31,3,'Merchandising','Merchandising',''),
  (32,3,'Other Business Support Services','Other Business Support Services',''),
  (33,3,'Public Relations (PR)','Public Relations (PR)',''),
  (34,3,'Recruitment & Employee Placement Agency','Recruitment & Employee Placement Agency',''),
  (35,3,'Sales Outsourcing','Sales Outsourcing',''),
  (36,3,'Telemarketing','Telemarketing',''),
  (37,3,'Translation & Document Processing','Translation & Document Processing',''),
  (38,3,'Virtual Assistant Services','Virtual Assistant Services',''),
  (39,4,'Corporate Management Office','Corporate Management Office',''),
  (40,5,'Architecture','Architecture',''),
  (41,5,'Civil Engineering','Civil Engineering',''),
  (42,5,'Construction & Building','Construction & Building',''),
  (43,5,'Facilities & Property Management','Facilities & Property Management',''),
  (44,5,'Fit-Out & Joinery','Fit-Out & Joinery',''),
  (45,5,'Interior design','Interior design',''),
  (46,5,'Real Estate','Real Estate',''),
  (47,6,'Laboratory & Quality Control','Laboratory & Quality Control',''),
  (48,6,'Primary, Prep, & Secondary School','Primary, Prep, & Secondary School',''),
  (49,6,'Scientific Research & Development','Scientific Research & Development',''),
  (50,6,'Higher Education','Higher Education',''),
  (51,6,'Library','Library',''),
  (52,6,'Preschool, Nursery, & Daycare','Preschool, Nursery, & Daycare',''),
  (53,6,'Training & Education Center','Training & Education Center',''),
  (54,6,'Vocational Education','Vocational Education',''),
  (55,7,'Automotive Repair, Spare Parts, & Support Services','Automotive Repair, Spare Parts, & Support Services',''),
  (56,7,'Electrical Engineering','Electrical Engineering',''),
  (57,7,'General Engineering Consultancy','General Engineering Consultancy',''),
  (58,7,'Ground Fleet, Aviation, & Marine Refuelling','Ground Fleet, Aviation, & Marine Refuelling',''),
  (59,7,'Industrial Engineering & Automation','Industrial Engineering & Automation',''),
  (60,7,'Installation & Technical Services','Installation & Technical Services',''),
  (61,7,'Maritime & Marine Engineering','Maritime & Marine Engineering',''),
  (62,7,'Mechanical Engineering','Mechanical Engineering',''),
  (63,7,'Project & Construction Planning','Project & Construction Planning',''),
  (64,7,'Quantity Survey','Quantity Survey',''),
  (65,7,'Safety & Environment','Safety & Environment',''),
  (66,7,'Technical Maintenance & Repair','Technical Maintenance & Repair',''),
  (67,8,'Accounting','Accounting',''),
  (68,8,'Banking','Banking',''),
  (69,8,'Economics & Financial Consulting','Economics & Financial Consulting',''),
  (70,8,'Financial Auditing','Financial Auditing',''),
  (71,8,'Financial Services','Financial Services',''),
  (72,8,'Insurance & TPA','Insurance & TPA',''),
  (73,8,'Investment, Securities & Funds','Investment, Securities & Funds',''),
  (74,8,'Islamic Banking','Islamic Banking',''),
  (75,8,'Law Firm','Law Firm',''),
  (76,8,'Venture Capital & Private Equity','Venture Capital & Private Equity',''),
  (77,9,'Non-profit Organization','Non-profit Organization',''),
  (78,9,'Public Administration','Public Administration',''),
  (79,9,'Religious Institution & Place of Worship','Religious Institution & Place of Worship',''),
  (80,9,'Social Services','Social Services',''),
  (81,10,'Dental Center & Clinic','Dental Center & Clinic',''),
  (82,10,'Medical & Healthcare Equipment','Medical & Healthcare Equipment',''),
  (83,10,'Medical Clinic','Medical Clinic',''),
  (84,10,'Medical Hospital','Medical Hospital',''),
  (85,10,'Other Healthcare Services','Other Healthcare Services',''),
  (86,10,'Pharmaceutical','Pharmaceutical',''),
  (87,10,'Residential & Nursing Care Services','Residential & Nursing Care Services',''),
  (88,10,'Veterinary Hospital & Clinic','Veterinary Hospital & Clinic',''),
  (89,11,'Data Hosting & Storage','Data Hosting & Storage',''),
  (90,11,'Internet & E-commerce','Internet & E-commerce',''),
  (91,11,'IT Services','IT Services',''),
  (92,11,'Software Development','Software Development',''),
  (93,11,'Telecommunications','Telecommunications',''),
  (94,11,'Video Gaming','Video Gaming',''),
  (95,12,'Amusement & Recreation Facility','Amusement & Recreation Facility',''),
  (96,12,'Catering, Food Service, & Restaurant','Catering, Food Service, & Restaurant',''),
  (97,12,'Hospitality & Accomodation','Hospitality & Accomodation',''),
  (98,12,'Sports & Outdoor Activities','Sports & Outdoor Activities',''),
  (99,12,'Tourism, Museum, & Cultural','Tourism, Museum, & Cultural',''),
  (100,12,'Travel Agency','Travel Agency',''),
  (101,13,'Automotive Manufacture','Automotive Manufacture',''),
  (102,13,'Chemicals Manufacture','Chemicals Manufacture',''),
  (103,13,'Consumer Packaged Goods Manufacture','Consumer Packaged Goods Manufacture',''),
  (104,13,'Paper & Paper Product Manufacture','Paper & Paper Product Manufacture',''),
  (105,13,'Semiconductors','Semiconductors',''),
  (106,13,'Tobacco Products Manufacture','Tobacco Products Manufacture',''),
  (107,13,'Biotechnology','Biotechnology',''),
  (108,13,'Computer Hardware & High-Tech Manufacture','Computer Hardware & High-Tech Manufacture',''),
  (109,13,'FMCG','FMCG',''),
  (110,13,'Food & Beverage Production','Food & Beverage Production',''),
  (111,13,'Heavy Industry & Metallurgy','Heavy Industry & Metallurgy',''),
  (112,13,'Industrial Production','Industrial Production',''),
  (113,13,'Lubricants & Greases Blending','Lubricants & Greases Blending',''),
  (114,13,'Manufacturing','Manufacturing',''),
  (115,13,'Petrochemicals & Refined Petroleum Products Manufacture','Petrochemicals & Refined Petroleum Products Manufacture',''),
  (116,13,'Textile & Apparel Production','Textile & Apparel Production',''),
  (117,14,'AerospaceMilitary & Defense','AerospaceMilitary & Defense',''),
  (118,15,'Airconditioning Plant','Airconditioning Plant',''),
  (119,15,'Crude Petroleum & Gas Extraction','Crude Petroleum & Gas Extraction',''),
  (120,15,'Electric Power Production & Transmission','Electric Power Production & Transmission',''),
  (121,15,'LPG Bottling','LPG Bottling',''),
  (122,15,'Mining & Quarrying','Mining & Quarrying',''),
  (123,15,'Natural Gas Distribution','Natural Gas Distribution',''),
  (124,15,'Oil & Gas','Oil & Gas',''),
  (125,15,'Utilities','Utilities',''),
  (126,15,'Waste Disposal & Recycling','Waste Disposal & Recycling',''),
  (127,15,'Water & Waste Water Treatment','Water & Waste Water Treatment',''),
  (128,16,'Personal Care Centers','Personal Care Centers',''),
  (129,16,'Personal Services','Personal Services',''),
  (130,17,'Automotive Dealership & Distributor','Automotive Dealership & Distributor',''),
  (131,17,'Arts & Crafts Supplies','Arts & Crafts Supplies',''),
  (132,17,'Bookshop & Consumer Media','Bookshop & Consumer Media',''),
  (133,17,'Consumer Electronics','Consumer Electronics',''),
  (134,17,'Trading & Commodity Trading','Trading & Commodity Trading',''),
  (135,17,'Fashion & Apparel','Fashion & Apparel',''),
  (136,17,'Hardware & Building Materials','Hardware & Building Materials',''),
  (137,17,'Home & Office Furniture','Home & Office Furniture',''),
  (138,17,'Home Accessories & Decor','Home Accessories & Decor',''),
  (139,17,'Household Appliances','Household Appliances',''),
  (140,17,'Jewelry & Gold','Jewelry & Gold',''),
  (141,17,'Office Supplies','Office Supplies',''),
  (142,17,'Perfume & Cosmetics','Perfume & Cosmetics',''),
  (143,17,'Pet Supplies','Pet Supplies',''),
  (144,17,'Plants & Gardening Equipment','Plants & Gardening Equipment',''),
  (145,17,'Sporting Goods','Sporting Goods',''),
  (146,17,'Supermarket','Supermarket',''),
  (147,17,'Tobacco & Smoking Goods','Tobacco & Smoking Goods',''),
  (148,17,'Toys & Leisure','Toys & Leisure',''),
  (149,17,'Watches & Luxury Goods','Watches & Luxury Goods',''),
  (150,17,'Wholesale & Import/Export Trade','Wholesale & Import/Export Trade',''),
  (151,18,'Law Enforcement & Civil Defence','Law Enforcement & Civil Defence',''),
  (152,18,'Private Security Services','Private Security Services',''),
  (153,18,'Security & Fire Systems','Security & Fire Systems',''),
  (154,19,'Airlines','Airlines',''),
  (155,19,'Aviation Support Services','Aviation Support Services',''),
  (156,19,'Distribution & Logistics','Distribution & Logistics',''),
  (157,19,'Marine Transport Services','Marine Transport Services',''),
  (158,19,'Metro & Rail Passenger Transport','Metro & Rail Passenger Transport',''),
  (159,19,'Motor Vehicle Passenger Transport','Motor Vehicle Passenger Transport',''),
  (160,19,'Purchasing & Procurement','Purchasing & Procurement',''),
  (161,19,'Shipping','Shipping',''),
  (162,19,'Warehousing','Warehousing','');
  
  /*Table structure for table `core_job_roles` */
  
  DROP TABLE IF EXISTS `core_job_roles`;
  
  CREATE TABLE `core_job_roles` (
    `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
    `jobRole_en` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    `jobRole_ar` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    `deletedDate` varchar(12) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  
  /*Data for the table `core_job_roles` */
  
  insert  into `core_job_roles`(`id`,`jobRole_en`,`jobRole_ar`,`deletedDate`) values 
  (1,'Accounting and Auditing','Accounting and Auditing',''),
  (2,'Administration','Administration',''),
  (3,'Architecture','Architecture',''),
  (4,'Banking','Banking',''),
  (5,'Beauty and Fashion','Beauty and Fashion',''),
  (6,'Cleaning Services','Cleaning Services',''),
  (7,'Community Services','Community Services',''),
  (8,'Construction and Building','Construction and Building',''),
  (9,'Consulting','Consulting',''),
  (10,'Customer Service and Call Center','Customer Service and Call Center',''),
  (11,'Design, Creative, and Arts','Design, Creative, and Arts',''),
  (12,'Engineering','Engineering',''),
  (13,'Chemical Engineering','Chemical Engineering',''),
  (14,'Civil Engineering','Civil Engineering',''),
  (15,'Electrical Engineering','Electrical Engineering',''),
  (16,'Mechanical Engineering','Mechanical Engineering',''),
  (17,'Farming and Agriculture','Farming and Agriculture',''),
  (18,'Finance and Investment','Finance and Investment',''),
  (19,'Hospitality and Tourism','Hospitality and Tourism',''),
  (20,'Human Resources and Recruitment','Human Resources and Recruitment',''),
  (21,'Information Technology','Information Technology',''),
  (22,'Legal','Legal',''),
  (23,'Logistics and Transportation','Logistics and Transportation',''),
  (24,'Maintenance, Repair, and Technician','Maintenance, Repair, and Technician',''),
  (25,'Management','Management',''),
  (26,'Manufacturing','Manufacturing',''),
  (27,'Marketing and PR','Marketing and PR',''),
  (28,'Medical, Healthcare, and Nursing','Medical, Healthcare, and Nursing',''),
  (29,'Oil and Gas','Oil and Gas',''),
  (30,'Purchasing and Procurement','Purchasing and Procurement',''),
  (31,'Quality Control','Quality Control',''),
  (32,'Research and Development','Research and Development',''),
  (33,'Safety','Safety',''),
  (34,'Sales','Sales',''),
  (35,'Secretarial','Secretarial',''),
  (36,'Security','Security',''),
  (37,'Support Services','Support Services',''),
  (38,'Teaching and Academics','Teaching and Academics',''),
  (39,'Training and Development','Training and Development',''),
  (40,'Translation','Translation',''),
  (41,'Writing and Journalism','Writing and Journalism','');
  
  /*Table structure for table `core_job_subroles` */
  
  DROP TABLE IF EXISTS `core_job_subroles`;
  
  CREATE TABLE `core_job_subroles` (
    `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
    `jobRoleId` int(11) NOT NULL DEFAULT '0',
    `jobSubrole_en` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    `jobSubrole_ar` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    `deletedDate` varchar(12) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=464 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  
  /*Data for the table `core_job_subroles` */
  
  insert  into `core_job_subroles`(`id`,`jobRoleId`,`jobSubrole_en`,`jobSubrole_ar`,`deletedDate`) values 
  (1,1,'Accountant Ohers','Accountant Ohers',''),
  (2,1,'Accountant Assistant Ohers','Accountant Assistant Ohers',''),
  (3,1,'Accountant General Ohers','Accountant General Ohers',''),
  (4,1,'Accounting Manager Ohers','Accounting Manager Ohers',''),
  (5,1,'Accounts Payable Manager Ohers','Accounts Payable Manager Ohers',''),
  (6,1,'Audit Manager Ohers','Audit Manager Ohers',''),
  (7,1,'Auditor Ohers','Auditor Ohers',''),
  (8,1,'CFO Ohers','CFO Ohers',''),
  (9,1,'Cash Management Officer Ohers','Cash Management Officer Ohers',''),
  (10,1,'Cashier Ohers','Cashier Ohers',''),
  (11,1,'Central Cashier Officer Ohers','Central Cashier Officer Ohers',''),
  (12,1,'Chief Accountant Ohers','Chief Accountant Ohers',''),
  (13,1,'Chief Financial Officer Ohers','Chief Financial Officer Ohers',''),
  (14,1,'Collections Officer Ohers','Collections Officer Ohers',''),
  (15,1,'Cost Accountant Ohers','Cost Accountant Ohers',''),
  (16,1,'Cost Controller Ohers','Cost Controller Ohers',''),
  (17,1,'Credit Controller Ohers','Credit Controller Ohers',''),
  (18,1,'External Audit Ohers','External Audit Ohers',''),
  (19,1,'Financial Accountant Ohers','Financial Accountant Ohers',''),
  (20,1,'Financial Controller Ohers','Financial Controller Ohers',''),
  (21,1,'Financial Manager Ohers','Financial Manager Ohers',''),
  (22,1,'General Cashier Ohers','General Cashier Ohers',''),
  (23,1,'Internal Audit Ohers','Internal Audit Ohers',''),
  (24,1,'Inventory Controller Ohers','Inventory Controller Ohers',''),
  (25,1,'Inventory Manager Ohers','Inventory Manager Ohers',''),
  (26,1,'Management Accountant Ohers','Management Accountant Ohers',''),
  (27,1,'Payroll Officer Ohers','Payroll Officer Ohers',''),
  (28,1,'Receivable Accountant Ohers','Receivable Accountant Ohers',''),
  (29,1,'Senior Accountant Ohers','Senior Accountant Ohers',''),
  (30,1,'Senior Financial Analyst Ohers','Senior Financial Analyst Ohers',''),
  (31,1,'Senior Group Accountant Ohers','Senior Group Accountant Ohers',''),
  (32,1,'Stock Keeper Ohers','Stock Keeper Ohers',''),
  (33,1,'Store Keeper Ohers','Store Keeper Ohers',''),
  (34,1,'Tax Auditing Ohers','Tax Auditing Ohers',''),
  (35,1,'Trade Finance Manager Ohers','Trade Finance Manager Ohers',''),
  (36,2,'Admin Assistant Ohers','Admin Assistant Ohers',''),
  (37,2,'Admin Manager Ohers','Admin Manager Ohers',''),
  (38,2,'Admin Officer Ohers','Admin Officer Ohers',''),
  (39,2,'Administration Manager Ohers','Administration Manager Ohers',''),
  (40,2,'Administrative Assistant Ohers','Administrative Assistant Ohers',''),
  (41,2,'Contract Administrator Ohers','Contract Administrator Ohers',''),
  (42,2,'Reservations Agent Ohers','Reservations Agent Ohers',''),
  (43,2,'Shift Supervisor Ohers','Shift Supervisor Ohers',''),
  (44,3,'Architect Ohers','Architect Ohers',''),
  (45,3,'Architectural Engineer Ohers','Architectural Engineer Ohers',''),
  (46,3,'Architectural Revit Ohers','Architectural Revit Ohers',''),
  (47,3,'Draftsman Designer Ohers','Draftsman Designer Ohers',''),
  (48,3,'Interior Architect Ohers','Interior Architect Ohers',''),
  (49,3,'Senior Architect Ohers','Senior Architect Ohers',''),
  (50,3,'Senior Project Architect Ohers','Senior Project Architect Ohers',''),
  (51,3,'Site Architect Ohers','Site Architect Ohers',''),
  (52,3,'Structural Draftsman Ohers','Structural Draftsman Ohers',''),
  (53,4,'Account Manager Ohers','Account Manager Ohers',''),
  (54,4,'Bankers Insurance Ohers','Bankers Insurance Ohers',''),
  (55,4,'Corporate Banker Ohers','Corporate Banker Ohers',''),
  (56,4,'Insurance Ohers','Insurance Ohers',''),
  (57,4,'Investment Banking Analyst Ohers','Investment Banking Analyst Ohers',''),
  (58,4,'Retail Banking Ohers','Retail Banking Ohers',''),
  (59,4,'Teller Ohers','Teller Ohers',''),
  (60,5,'Beauty Advisor Ohers','Beauty Advisor Ohers',''),
  (61,5,'Hair Stylist Ohers','Hair Stylist Ohers',''),
  (62,5,'Hairdresser Ohers','Hairdresser Ohers',''),
  (63,5,'Makeup Artist Ohers','Makeup Artist Ohers',''),
  (64,5,'Manicurist Ohers','Manicurist Ohers',''),
  (65,5,'Model Casting Ohers','Model Casting Ohers',''),
  (66,5,'Spa Manager Ohers','Spa Manager Ohers',''),
  (67,5,'Spa Therapist Ohers','Spa Therapist Ohers',''),
  (68,6,'Cleaner Ohers','Cleaner Ohers',''),
  (69,6,'Cleaning Lady Ohers','Cleaning Lady Ohers',''),
  (70,6,'House Maid Ohers','House Maid Ohers',''),
  (71,6,'Housekeeping Ohers','Housekeeping Ohers',''),
  (72,6,'Housekeeping Attendant Ohers','Housekeeping Attendant Ohers',''),
  (73,6,'Laundry Worker Ohers','Laundry Worker Ohers',''),
  (74,6,'Office Cleaner Ohers','Office Cleaner Ohers',''),
  (75,7,'Case Manager Ohers','Case Manager Ohers',''),
  (76,7,'NGO Ohers','NGO Ohers',''),
  (77,7,'Program Manager Ohers','Program Manager Ohers',''),
  (78,7,'Project Coordinator Ohers','Project Coordinator Ohers',''),
  (79,7,'Service Coordinator Ohers','Service Coordinator Ohers',''),
  (80,7,'Social Worker Ohers','Social Worker Ohers',''),
  (81,8,'Construction Manager Ohers','Construction Manager Ohers',''),
  (82,8,'Construction Supervisor Ohers','Construction Supervisor Ohers',''),
  (83,8,'General labor Ohers','General labor Ohers',''),
  (84,8,'Laborer Ohers','Laborer Ohers',''),
  (85,8,'Land Surveyor Ohers','Land Surveyor Ohers',''),
  (86,8,'Surveyor Ohers','Surveyor Ohers',''),
  (87,8,'Welder Ohers','Welder Ohers',''),
  (88,9,'Business Consultant Ohers','Business Consultant Ohers',''),
  (89,9,'Consultant Ohers','Consultant Ohers',''),
  (90,9,'Management Consultant Ohers','Management Consultant Ohers',''),
  (91,9,'Senior Consultant Ohers','Senior Consultant Ohers',''),
  (92,9,'Strategy Consultant Ohers','Strategy Consultant Ohers',''),
  (93,10,'Call Center Agent Ohers','Call Center Agent Ohers',''),
  (94,10,'Call Center Trainer Ohers','Call Center Trainer Ohers',''),
  (95,10,'Customer Care Representative Ohers','Customer Care Representative Ohers',''),
  (96,10,'Customer Service Representative Ohers','Customer Service Representative Ohers',''),
  (97,11,'Animation Designer Ohers','Animation Designer Ohers',''),
  (98,11,'Audiologist Ohers','Audiologist Ohers',''),
  (99,11,'Design Coordinator Ohers','Design Coordinator Ohers',''),
  (100,11,'Design Manager Ohers','Design Manager Ohers',''),
  (101,11,'Designer Ohers','Designer Ohers',''),
  (102,11,'Fashion Designer Ohers','Fashion Designer Ohers',''),
  (103,11,'Florist Ohers','Florist Ohers',''),
  (104,11,'Graphic Designer Ohers','Graphic Designer Ohers',''),
  (105,11,'Interior Design Ohers','Interior Design Ohers',''),
  (106,11,'Interior Designer Ohers','Interior Designer Ohers',''),
  (107,11,'Jewellery Designer Ohers','Jewellery Designer Ohers',''),
  (108,11,'Painter Ohers','Painter Ohers',''),
  (109,11,'Photographer Ohers','Photographer Ohers',''),
  (110,11,'Web Designer Ohers','Web Designer Ohers',''),
  (111,12,'Biologist Ohers','Biologist Ohers',''),
  (112,12,'Cost Control Engineer Ohers','Cost Control Engineer Ohers',''),
  (113,12,'Engineering Manager Ohers','Engineering Manager Ohers',''),
  (114,12,'Engineering Supervisor Ohers','Engineering Supervisor Ohers',''),
  (115,12,'Estimation Engineer Ohers','Estimation Engineer Ohers',''),
  (116,12,'Food Technology Engineer Ohers','Food Technology Engineer Ohers',''),
  (117,12,'Industrial Engineer Ohers','Industrial Engineer Ohers',''),
  (118,12,'Interior Site Engineer Ohers','Interior Site Engineer Ohers',''),
  (119,12,'Lab Manager Ohers','Lab Manager Ohers',''),
  (120,12,'Laboratory Technician Ohers','Laboratory Technician Ohers',''),
  (121,12,'Landscape Engineer Ohers','Landscape Engineer Ohers',''),
  (122,12,'Network Engineer Ohers','Network Engineer Ohers',''),
  (123,12,'Power Generation Supervision Engineer Ohers','Power Generation Supervision Engineer Ohers',''),
  (124,12,'Process Engineer Ohers','Process Engineer Ohers',''),
  (125,12,'Production Engineer Ohers','Production Engineer Ohers',''),
  (126,12,'Production Supervisor Ohers','Production Supervisor Ohers',''),
  (127,12,'Project Engineer Ohers','Project Engineer Ohers',''),
  (128,13,'Analytical Chemist Ohers','Analytical Chemist Ohers',''),
  (129,13,'Chemical Engineer Ohers','Chemical Engineer Ohers',''),
  (130,13,'Chemical Sales Engineer Ohers','Chemical Sales Engineer Ohers',''),
  (131,13,'Chemist Ohers','Chemist Ohers',''),
  (132,13,'Materials Engineer Ohers','Materials Engineer Ohers',''),
  (133,13,'Mining Engineer Ohers','Mining Engineer Ohers',''),
  (134,14,'Civil Engineer Ohers','Civil Engineer Ohers',''),
  (135,14,'Environmental Engineer Ohers','Environmental Engineer Ohers',''),
  (136,14,'Finishing Engineer Ohers','Finishing Engineer Ohers',''),
  (137,14,'Pavement Engineer Ohers','Pavement Engineer Ohers',''),
  (138,14,'Quantity Surveyor Ohers','Quantity Surveyor Ohers',''),
  (139,14,'Resident Engineer Ohers','Resident Engineer Ohers',''),
  (140,14,'Road Construction Ohers','Road Construction Ohers',''),
  (141,14,'Road Highway Ohers','Road Highway Ohers',''),
  (142,14,'Senior Quantity Surveyor Ohers','Senior Quantity Surveyor Ohers',''),
  (143,14,'Service Engineer Ohers','Service Engineer Ohers',''),
  (144,14,'Site Engineer Ohers','Site Engineer Ohers',''),
  (145,14,'Site Supervisor Ohers','Site Supervisor Ohers',''),
  (146,14,'Structural Engineer Ohers','Structural Engineer Ohers',''),
  (147,14,'Traffic Engineer Ohers','Traffic Engineer Ohers',''),
  (148,14,'Water Treatment Engineer Ohers','Water Treatment Engineer Ohers',''),
  (149,14,'Welding Inspector Ohers','Welding Inspector Ohers',''),
  (150,14,'Workshop Controller Ohers','Workshop Controller Ohers',''),
  (151,14,'Workshop Manager Ohers','Workshop Manager Ohers',''),
  (152,15,'Electrical Automation Engineer Ohers','Electrical Automation Engineer Ohers',''),
  (153,15,'Electrical Engineer Ohers','Electrical Engineer Ohers',''),
  (154,15,'Electrical Manager Ohers','Electrical Manager Ohers',''),
  (155,15,'Electrical Sales Engineer Ohers','Electrical Sales Engineer Ohers',''),
  (156,15,'Electrician Ohers','Electrician Ohers',''),
  (157,15,'Electricity Power Distribution Engineer Ohers','Electricity Power Distribution Engineer Ohers',''),
  (158,15,'Lighting Engineer Ohers','Lighting Engineer Ohers',''),
  (159,16,'HVAC Project Manager Ohers','HVAC Project Manager Ohers',''),
  (160,16,'Mechanic Engineer Ohers','Mechanic Engineer Ohers',''),
  (161,16,'Mechanical Inspector Ohers','Mechanical Inspector Ohers',''),
  (162,17,'Agriculture Engineer Ohers','Agriculture Engineer Ohers',''),
  (163,17,'Farm Manager Ohers','Farm Manager Ohers',''),
  (164,17,'Farm workers Ohers','Farm workers Ohers',''),
  (165,17,'Irrigation Engineer Ohers','Irrigation Engineer Ohers',''),
  (166,17,'Irrigation Worker Ohers','Irrigation Worker Ohers',''),
  (167,18,'Chief Investment Officer Ohers','Chief Investment Officer Ohers',''),
  (168,18,'Credit Analyst Ohers','Credit Analyst Ohers',''),
  (169,18,'Finance Manager Ohers','Finance Manager Ohers',''),
  (170,18,'Financial Advisor Ohers','Financial Advisor Ohers',''),
  (171,18,'Financial Analyst Ohers','Financial Analyst Ohers',''),
  (172,18,'Investment Consultant Ohers','Investment Consultant Ohers',''),
  (173,18,'Investment Officer Ohers','Investment Officer Ohers',''),
  (174,18,'Investor Relations Ohers','Investor Relations Ohers',''),
  (175,18,'Real Estate Broker Ohers','Real Estate Broker Ohers',''),
  (176,18,'Real Estate Manager Ohers','Real Estate Manager Ohers',''),
  (177,18,'Risk Analyst Ohers','Risk Analyst Ohers',''),
  (178,18,'Risk Manager Ohers','Risk Manager Ohers',''),
  (179,19,'Bartender Ohers','Bartender Ohers',''),
  (180,19,'Butcher Ohers','Butcher Ohers',''),
  (181,19,'Cake Decorator Ohers','Cake Decorator Ohers',''),
  (182,19,'Catering Ohers','Catering Ohers',''),
  (183,19,'Chef Ohers','Chef Ohers',''),
  (184,19,'Head Chef Ohers','Head Chef Ohers',''),
  (185,19,'Hostess Ohers','Hostess Ohers',''),
  (186,19,'Hotel Manager Ohers','Hotel Manager Ohers',''),
  (187,19,'Pastry Chef Ohers','Pastry Chef Ohers',''),
  (188,19,'Restaurant Manager Ohers','Restaurant Manager Ohers',''),
  (189,19,'Travel Agent Ohers','Travel Agent Ohers',''),
  (190,19,'Travel Consultant Ohers','Travel Consultant Ohers',''),
  (191,19,'Waiter Ohers','Waiter Ohers',''),
  (192,19,'Waitress Ohers','Waitress Ohers',''),
  (193,20,'Compensation Manager Ohers','Compensation Manager Ohers',''),
  (194,20,'Employee Relations Manager Ohers','Employee Relations Manager Ohers',''),
  (195,20,'HR Assistant Ohers','HR Assistant Ohers',''),
  (196,20,'HR Coordinator Ohers','HR Coordinator Ohers',''),
  (197,20,'HR Director Ohers','HR Director Ohers',''),
  (198,20,'HR Executive Ohers','HR Executive Ohers',''),
  (199,20,'HR Manager Ohers','HR Manager Ohers',''),
  (200,20,'HR Officer Ohers','HR Officer Ohers',''),
  (201,20,'HR Specialist Ohers','HR Specialist Ohers',''),
  (202,20,'HR Supervisor Ohers','HR Supervisor Ohers',''),
  (203,20,'Headhunter Ohers','Headhunter Ohers',''),
  (204,20,'Recruiter Ohers','Recruiter Ohers',''),
  (205,20,'Recruitment Consultant Ohers','Recruitment Consultant Ohers',''),
  (206,20,'Recruitment Manager Ohers','Recruitment Manager Ohers',''),
  (207,20,'Recruitment Officer Ohers','Recruitment Officer Ohers',''),
  (208,20,'Recruitment Specialist Ohers','Recruitment Specialist Ohers',''),
  (209,20,'Talent acquisition manager Ohers','Talent acquisition manager Ohers',''),
  (210,21,'Net Developer Ohers','Net Developer Ohers',''),
  (211,21,'Analyst Ohers','Analyst Ohers',''),
  (212,21,'Android Developer Ohers','Android Developer Ohers',''),
  (213,21,'Application Software Developer Ohers','Application Software Developer Ohers',''),
  (214,21,'Asp.Net Developer Ohers','Asp.Net Developer Ohers',''),
  (215,21,'BI Developer Ohers','BI Developer Ohers',''),
  (216,21,'Computer Engineer Ohers','Computer Engineer Ohers',''),
  (217,21,'Computer Programmer Ohers','Computer Programmer Ohers',''),
  (218,21,'DBA Ohers','DBA Ohers',''),
  (219,21,'Database Developer Ohers','Database Developer Ohers',''),
  (220,21,'Enterprise Information Technology Manager Ohers','Enterprise Information Technology Manager Ohers',''),
  (221,21,'Front-End Developer Ohers','Front-End Developer Ohers',''),
  (222,21,'GIS Developer Ohers','GIS Developer Ohers',''),
  (223,21,'IT Administrator Ohers','IT Administrator Ohers',''),
  (224,21,'IT Coordinator Ohers','IT Coordinator Ohers',''),
  (225,21,'IT Manager Ohers','IT Manager Ohers',''),
  (226,21,'IT Support Analyst Ohers','IT Support Analyst Ohers',''),
  (227,21,'Information Security Analyst Ohers','Information Security Analyst Ohers',''),
  (228,21,'Information Systems Instructor Ohers','Information Systems Instructor Ohers',''),
  (229,21,'Java Developer Ohers','Java Developer Ohers',''),
  (230,21,'Javascript Developer Ohers','Javascript Developer Ohers',''),
  (231,21,'Network Administrator Ohers','Network Administrator Ohers',''),
  (232,21,'Oracle DBA Ohers','Oracle DBA Ohers',''),
  (233,21,'Oracle Developer Ohers','Oracle Developer Ohers',''),
  (234,21,'Php Developer Ohers','Php Developer Ohers',''),
  (235,21,'Programmer Ohers','Programmer Ohers',''),
  (236,21,'Python Developer Ohers','Python Developer Ohers',''),
  (237,21,'Quality Assurance Ohers','Quality Assurance Ohers',''),
  (238,21,'SAP Consultant Ohers','SAP Consultant Ohers',''),
  (239,21,'SAP HCM Consultant Ohers','SAP HCM Consultant Ohers',''),
  (240,21,'SAP Manager Ohers','SAP Manager Ohers',''),
  (241,21,'SQL Developer Ohers','SQL Developer Ohers',''),
  (242,21,'Sharepoint Developer Ohers','Sharepoint Developer Ohers',''),
  (243,21,'Software Developer Ohers','Software Developer Ohers',''),
  (244,21,'Software Engineer Ohers','Software Engineer Ohers',''),
  (245,21,'Software Tester Ohers','Software Tester Ohers',''),
  (246,21,'System Administrator Ohers','System Administrator Ohers',''),
  (247,21,'System Analyst Ohers','System Analyst Ohers',''),
  (248,21,'System Integrator Ohers','System Integrator Ohers',''),
  (249,21,'Systems Engineer Ohers','Systems Engineer Ohers',''),
  (250,21,'Web Developer Ohers','Web Developer Ohers',''),
  (251,21,'iOS Developer Ohers','iOS Developer Ohers',''),
  (252,22,'Compliance Manager Ohers','Compliance Manager Ohers',''),
  (253,22,'Compliance Officer Ohers','Compliance Officer Ohers',''),
  (254,22,'Lawyer Ohers','Lawyer Ohers',''),
  (255,22,'Legal Advisor Ohers','Legal Advisor Ohers',''),
  (256,22,'Legal Consultant Ohers','Legal Consultant Ohers',''),
  (257,22,'Legal Manager Ohers','Legal Manager Ohers',''),
  (258,23,'Customs Clearance Officer Ohers','Customs Clearance Officer Ohers',''),
  (259,23,'Driver Ohers','Driver Ohers',''),
  (260,23,'Leasing Coordinator Ohers','Leasing Coordinator Ohers',''),
  (261,23,'Logistic Coordinator Ohers','Logistic Coordinator Ohers',''),
  (262,23,'Logistic Manager Ohers','Logistic Manager Ohers',''),
  (263,23,'Material Controller Ohers','Material Controller Ohers',''),
  (264,23,'Property Consultant Ohers','Property Consultant Ohers',''),
  (265,23,'Shipping Coordinator Ohers','Shipping Coordinator Ohers',''),
  (266,23,'Supply Chain Manager Ohers','Supply Chain Manager Ohers',''),
  (267,23,'Transport Coordinator Ohers','Transport Coordinator Ohers',''),
  (268,23,'Transport Dispatcher Ohers','Transport Dispatcher Ohers',''),
  (269,23,'Transportation Coordinator Ohers','Transportation Coordinator Ohers',''),
  (270,23,'Warehouse Manager Ohers','Warehouse Manager Ohers',''),
  (271,24,'Auto Mechanic Ohers','Auto Mechanic Ohers',''),
  (272,24,'Electrical Technician Ohers','Electrical Technician Ohers',''),
  (273,24,'Electronics Technician Ohers','Electronics Technician Ohers',''),
  (274,24,'HVAC Technician Ohers','HVAC Technician Ohers',''),
  (275,24,'Instrument Technician Ohers','Instrument Technician Ohers',''),
  (276,24,'Maintenance Manager Ohers','Maintenance Manager Ohers',''),
  (277,24,'Maintenance Technician Ohers','Maintenance Technician Ohers',''),
  (278,24,'Technical Manager Ohers','Technical Manager Ohers',''),
  (279,24,'Technical Support Specialist Ohers','Technical Support Specialist Ohers',''),
  (280,24,'Technician Ohers','Technician Ohers',''),
  (281,25,'Branch Manager Ohers','Branch Manager Ohers',''),
  (282,25,'Business Support Manager Ohers','Business Support Manager Ohers',''),
  (283,25,'CEO Ohers','CEO Ohers',''),
  (284,25,'Channel Manager Ohers','Channel Manager Ohers',''),
  (285,25,'Chief Executive Officer Ohers','Chief Executive Officer Ohers',''),
  (286,25,'Chief Operations Officer Ohers','Chief Operations Officer Ohers',''),
  (287,25,'Commercial Manager Ohers','Commercial Manager Ohers',''),
  (288,25,'Country Manager Ohers','Country Manager Ohers',''),
  (289,25,'Deputy General Manager Ohers','Deputy General Manager Ohers',''),
  (290,25,'Event Manager Ohers','Event Manager Ohers',''),
  (291,25,'Executive Level Ohers','Executive Level Ohers',''),
  (292,25,'Facility Manager Ohers','Facility Manager Ohers',''),
  (293,25,'General Manager Ohers','General Manager Ohers',''),
  (294,25,'Office Manager Ohers','Office Manager Ohers',''),
  (295,25,'Operations Manager Ohers','Operations Manager Ohers',''),
  (296,25,'PMP Project Manager Ohers','PMP Project Manager Ohers',''),
  (297,25,'Planning Manager Ohers','Planning Manager Ohers',''),
  (298,25,'Product Manager Ohers','Product Manager Ohers',''),
  (299,25,'Production Manager Ohers','Production Manager Ohers',''),
  (300,25,'Project Director Ohers','Project Director Ohers',''),
  (301,25,'Project Manager Ohers','Project Manager Ohers',''),
  (302,25,'Regional Manager Ohers','Regional Manager Ohers',''),
  (303,25,'Store Manager Ohers','Store Manager Ohers',''),
  (304,26,'Factory manager Ohers','Factory manager Ohers',''),
  (305,26,'Machine Operator Ohers','Machine Operator Ohers',''),
  (306,26,'Manufacturing Technician Ohers','Manufacturing Technician Ohers',''),
  (307,26,'Production Technician Ohers','Production Technician Ohers',''),
  (308,26,'Production Worker Ohers','Production Worker Ohers',''),
  (309,27,'Advertising Manager Ohers','Advertising Manager Ohers',''),
  (310,27,'Assistant Brand Manager Ohers','Assistant Brand Manager Ohers',''),
  (311,27,'Brand Manager Ohers','Brand Manager Ohers',''),
  (312,27,'Brand Promoter Ohers','Brand Promoter Ohers',''),
  (313,27,'Communication Manager Ohers','Communication Manager Ohers',''),
  (314,27,'Digital Manager Ohers','Digital Manager Ohers',''),
  (315,27,'Digital Marketing Manager Ohers','Digital Marketing Manager Ohers',''),
  (316,27,'Digital Project Manager Ohers','Digital Project Manager Ohers',''),
  (317,27,'Marketing Associate Ohers','Marketing Associate Ohers',''),
  (318,27,'Marketing Coordinator Ohers','Marketing Coordinator Ohers',''),
  (319,27,'Marketing Executive Ohers','Marketing Executive Ohers',''),
  (320,27,'Marketing Manager Ohers','Marketing Manager Ohers',''),
  (321,27,'Marketing Officer Ohers','Marketing Officer Ohers',''),
  (322,27,'Marketing Sales Executive Ohers','Marketing Sales Executive Ohers',''),
  (323,27,'Marketing Specialist Ohers','Marketing Specialist Ohers',''),
  (324,27,'PR Executive Ohers','PR Executive Ohers',''),
  (325,27,'Public Relations Officer Ohers','Public Relations Officer Ohers',''),
  (326,27,'Relationship Officer Ohers','Relationship Officer Ohers',''),
  (327,27,'SEO Ohers','SEO Ohers',''),
  (328,27,'Social Media Analyst Ohers','Social Media Analyst Ohers',''),
  (329,27,'Social Media Manager Ohers','Social Media Manager Ohers',''),
  (330,28,'Biomedical Engineer Ohers','Biomedical Engineer Ohers',''),
  (331,28,'Cardiologist Ohers','Cardiologist Ohers',''),
  (332,28,'Critical Care Medicine Specialist Ohers','Critical Care Medicine Specialist Ohers',''),
  (333,28,'Dental Technician Ohers','Dental Technician Ohers',''),
  (334,28,'Dentist Ohers','Dentist Ohers',''),
  (335,28,'Dermatologist Ohers','Dermatologist Ohers',''),
  (336,28,'Dietitian Ohers','Dietitian Ohers',''),
  (337,28,'Doctor Ohers','Doctor Ohers',''),
  (338,28,'Fitness Instructor Ohers','Fitness Instructor Ohers',''),
  (339,28,'Fitness Trainer Ohers','Fitness Trainer Ohers',''),
  (340,28,'General Practitioner Ohers','General Practitioner Ohers',''),
  (341,28,'Gym Instructor Ohers','Gym Instructor Ohers',''),
  (342,28,'Gynecologist Ohers','Gynecologist Ohers',''),
  (343,28,'Hospital Jobs Ohers','Hospital Jobs Ohers',''),
  (344,28,'Medical Devices Manager Ohers','Medical Devices Manager Ohers',''),
  (345,28,'Medical Representative Ohers','Medical Representative Ohers',''),
  (346,28,'Nurse Ohers','Nurse Ohers',''),
  (347,28,'Nurse Educator Ohers','Nurse Educator Ohers',''),
  (348,28,'Nursing Ohers','Nursing Ohers',''),
  (349,28,'Nutritionist Ohers','Nutritionist Ohers',''),
  (350,28,'Occupational Therapist Ohers','Occupational Therapist Ohers',''),
  (351,28,'Optometrist Ohers','Optometrist Ohers',''),
  (352,28,'Pediatrician Ohers','Pediatrician Ohers',''),
  (353,28,'Pharmacist Ohers','Pharmacist Ohers',''),
  (354,28,'Physician Ohers','Physician Ohers',''),
  (355,28,'Physiotherapist Ohers','Physiotherapist Ohers',''),
  (356,28,'Psychiatrist Ohers','Psychiatrist Ohers',''),
  (357,28,'Radiologist Ohers','Radiologist Ohers',''),
  (358,28,'Respiratory Therapist Ohers','Respiratory Therapist Ohers',''),
  (359,29,'Driller Ohers','Driller Ohers',''),
  (360,29,'Drilling Engineer Ohers','Drilling Engineer Ohers',''),
  (361,29,'Gas Plant Operator Ohers','Gas Plant Operator Ohers',''),
  (362,29,'Geophysicist Ohers','Geophysicist Ohers',''),
  (363,29,'Piping Engineer Ohers','Piping Engineer Ohers',''),
  (364,30,'Contracts Manager Ohers','Contracts Manager Ohers',''),
  (365,30,'Contracts Specialist Ohers','Contracts Specialist Ohers',''),
  (366,30,'Demand Planner Ohers','Demand Planner Ohers',''),
  (367,30,'Document Controller Ohers','Document Controller Ohers',''),
  (368,30,'Fashion Merchandiser Ohers','Fashion Merchandiser Ohers',''),
  (369,30,'Merchandiser Ohers','Merchandiser Ohers',''),
  (370,30,'Procurement Engineer Ohers','Procurement Engineer Ohers',''),
  (371,30,'Procurement Manager Ohers','Procurement Manager Ohers',''),
  (372,30,'Procurement Officer Ohers','Procurement Officer Ohers',''),
  (373,30,'Purchaser Ohers','Purchaser Ohers',''),
  (374,30,'Purchasing Manager Ohers','Purchasing Manager Ohers',''),
  (375,30,'Senior Document Controller Ohers','Senior Document Controller Ohers',''),
  (376,30,'Visual Merchandiser Ohers','Visual Merchandiser Ohers',''),
  (377,31,'QA Engineer Ohers','QA Engineer Ohers',''),
  (378,31,'QC Engineer Ohers','QC Engineer Ohers',''),
  (379,31,'Quality Analyst Ohers','Quality Analyst Ohers',''),
  (380,31,'Quality Assurance Engineer Ohers','Quality Assurance Engineer Ohers',''),
  (381,31,'Quality Control Engineer Ohers','Quality Control Engineer Ohers',''),
  (382,31,'Quality Controller Ohers','Quality Controller Ohers',''),
  (383,31,'Quality Inspector Ohers','Quality Inspector Ohers',''),
  (384,32,'Research Analyst Ohers','Research Analyst Ohers',''),
  (385,32,'Research Assistant Ohers','Research Assistant Ohers',''),
  (386,32,'Research Associate Ohers','Research Associate Ohers',''),
  (387,32,'Researcher Ohers','Researcher Ohers',''),
  (388,32,'Scientist Ohers','Scientist Ohers',''),
  (389,33,'HSE Manager Ohers','HSE Manager Ohers',''),
  (390,33,'Safety Engineer Ohers','Safety Engineer Ohers',''),
  (391,33,'Safety Manager Ohers','Safety Manager Ohers',''),
  (392,33,'Safety Officer Ohers','Safety Officer Ohers',''),
  (393,34,'Account Executive Ohers','Account Executive Ohers',''),
  (394,34,'Business Development Manager Ohers','Business Development Manager Ohers',''),
  (395,34,'Corporate Sales Manager Ohers','Corporate Sales Manager Ohers',''),
  (396,34,'Export Sales Manager Ohers','Export Sales Manager Ohers',''),
  (397,34,'Export Specialist Ohers','Export Specialist Ohers',''),
  (398,34,'Furniture Sales Ohers','Furniture Sales Ohers',''),
  (399,34,'Medical Sales Representative Ohers','Medical Sales Representative Ohers',''),
  (400,34,'Outdoor Sales Person Ohers','Outdoor Sales Person Ohers',''),
  (401,34,'Pharmaceutical Sales Ohers','Pharmaceutical Sales Ohers',''),
  (402,34,'Pre-Sales Engineer Ohers','Pre-Sales Engineer Ohers',''),
  (403,34,'Relationship Manager Ohers','Relationship Manager Ohers',''),
  (404,34,'Retail Manager Ohers','Retail Manager Ohers',''),
  (405,34,'Retail Supervisor Ohers','Retail Supervisor Ohers',''),
  (406,34,'Sales Agent Ohers','Sales Agent Ohers',''),
  (407,34,'Sales Area Manager Ohers','Sales Area Manager Ohers',''),
  (408,34,'Sales Associate Ohers','Sales Associate Ohers',''),
  (409,34,'Sales Consultant Ohers','Sales Consultant Ohers',''),
  (410,34,'Sales Coordinator Ohers','Sales Coordinator Ohers',''),
  (411,34,'Sales Engineer Ohers','Sales Engineer Ohers',''),
  (412,34,'Sales Executive Ohers','Sales Executive Ohers',''),
  (413,34,'Sales Executive Shipping Ohers','Sales Executive Shipping Ohers',''),
  (414,34,'Sales Manager Ohers','Sales Manager Ohers',''),
  (415,34,'Sales Promoter Ohers','Sales Promoter Ohers',''),
  (416,34,'Sales Representative Ohers','Sales Representative Ohers',''),
  (417,34,'Sales Trainer Ohers','Sales Trainer Ohers',''),
  (418,34,'Salesman Ohers','Salesman Ohers',''),
  (419,34,'Telesales Representative Ohers','Telesales Representative Ohers',''),
  (420,35,'Assistant Ohers','Assistant Ohers',''),
  (421,35,'Data Entry Ohers','Data Entry Ohers',''),
  (422,35,'Executive Assistant Ohers','Executive Assistant Ohers',''),
  (423,35,'Executive Secretary Ohers','Executive Secretary Ohers',''),
  (424,35,'Helpdesk Operator Ohers','Helpdesk Operator Ohers',''),
  (425,35,'Librarian Ohers','Librarian Ohers',''),
  (426,35,'Office Assistant Ohers','Office Assistant Ohers',''),
  (427,35,'Office Clerk Ohers','Office Clerk Ohers',''),
  (428,35,'Operator Ohers','Operator Ohers',''),
  (429,35,'Personal Assistant Ohers','Personal Assistant Ohers',''),
  (430,35,'Personal Secretary Ohers','Personal Secretary Ohers',''),
  (431,35,'Receptionist Ohers','Receptionist Ohers',''),
  (432,35,'Secretary Ohers','Secretary Ohers',''),
  (433,35,'Secretary Personal Assistant Ohers','Secretary Personal Assistant Ohers',''),
  (434,36,'Security Officer Ohers','Security Officer Ohers',''),
  (435,36,'Security Supervisor Ohers','Security Supervisor Ohers',''),
  (436,37,'Carpenter Ohers','Carpenter Ohers',''),
  (437,37,'Crane Operator Ohers','Crane Operator Ohers',''),
  (438,37,'Forklift Driver Ohers','Forklift Driver Ohers',''),
  (439,37,'Plumber Ohers','Plumber Ohers',''),
  (440,38,'Applied Linguistics Ohers','Applied Linguistics Ohers',''),
  (441,38,'Chemistry Teacher Ohers','Chemistry Teacher Ohers',''),
  (442,38,'Education Coordinator Ohers','Education Coordinator Ohers',''),
  (443,38,'English Instructor Ohers','English Instructor Ohers',''),
  (444,38,'English Teacher Ohers','English Teacher Ohers',''),
  (445,38,'Instructor Ohers','Instructor Ohers',''),
  (446,38,'Math Teacher Ohers','Math Teacher Ohers',''),
  (447,38,'Professor Ohers','Professor Ohers',''),
  (448,38,'Teacher Ohers','Teacher Ohers',''),
  (449,38,'Tutor Ohers','Tutor Ohers',''),
  (450,39,'Learning Manager Ohers','Learning Manager Ohers',''),
  (451,39,'Learning and Development Manager Ohers','Learning and Development Manager Ohers',''),
  (452,39,'Technical Trainer Ohers','Technical Trainer Ohers',''),
  (453,39,'Trainer Ohers','Trainer Ohers',''),
  (454,39,'Training Manager Ohers','Training Manager Ohers',''),
  (455,39,'Training Specialist Ohers','Training Specialist Ohers',''),
  (456,40,'Arabic Translator Ohers','Arabic Translator Ohers',''),
  (457,40,'German Translator Ohers','German Translator Ohers',''),
  (458,40,'Translator Ohers','Translator Ohers',''),
  (459,41,'Arabic Proofreader Ohers','Arabic Proofreader Ohers',''),
  (460,41,'Copywriter Ohers','Copywriter Ohers',''),
  (461,41,'Editor Ohers','Editor Ohers',''),
  (462,41,'Journalist Ohers','Journalist Ohers',''),
  (463,41,'Journalist Editor Ohers','Journalist Editor Ohers','');
  
  /*Table structure for table `core_majors` */
  
  DROP TABLE IF EXISTS `core_majors`;
  
  CREATE TABLE `core_majors` (
    `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
    `major_en` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    `major_ar` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    `deletedDate` varchar(12) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=416 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  
  /*Data for the table `core_majors` */
  
  insert  into `core_majors`(`id`,`major_en`,`major_ar`,`deletedDate`) values 
  (1,'Agricultural Economics','Agricultural Economics',''),
  (2,'Agricultural Mechanics','Agricultural Mechanics',''),
  (3,'Agronomy','Agronomy',''),
  (4,'Animal Sciences','Animal Sciences',''),
  (5,'Farm and Ranch Management','Farm and Ranch Management',''),
  (6,'Fish, Game, Wildlife Management','Fish, Game, Wildlife Management',''),
  (7,'Forestry','Forestry',''),
  (8,'Horticulture','Horticulture',''),
  (9,'Natural Resources Management','Natural Resources Management',''),
  (10,'Other Agriculture Majors','Other Agriculture Majors',''),
  (11,'Architecture','Architecture',''),
  (12,'Architectural Drafting','Architectural Drafting',''),
  (13,'City & Regional Planning','City & Regional Planning',''),
  (14,'Environmental Design','Environmental Design',''),
  (15,'Interior Design','Interior Design',''),
  (16,'Landscape Architecture','Landscape Architecture',''),
  (17,'Other Architecture Majors','Other Architecture Majors',''),
  (18,'Biological Sciences','Biological Sciences',''),
  (19,'Biochemistry/Biophysics','Biochemistry/Biophysics',''),
  (20,'Biology','Biology',''),
  (21,'Botany','Botany',''),
  (22,'Ecology','Ecology',''),
  (23,'Microbiology','Microbiology',''),
  (24,'Zoology','Zoology',''),
  (25,'Other Biological Sciences','Other Biological Sciences',''),
  (26,'Business','Business',''),
  (27,'Business Management','Business Management',''),
  (28,'Accounting','Accounting',''),
  (29,'Banking & Finance','Banking & Finance',''),
  (30,'Contract Management','Contract Management',''),
  (31,'Hotel/Restaurant Management','Hotel/Restaurant Management',''),
  (32,'Human Res. Development/Training','Human Res. Development/Training',''),
  (33,'Insurance & Risk Management','Insurance & Risk Management',''),
  (34,'Labor/Industrial Relations','Labor/Industrial Relations',''),
  (35,'Management Information Systems','Management Information Systems',''),
  (36,'Organizational Behavior','Organizational Behavior',''),
  (37,'Personnel Management','Personnel Management',''),
  (38,'Real Estate Management','Real Estate Management',''),
  (39,'Trade & Industrial Management','Trade & Industrial Management',''),
  (40,'Transportation Management','Transportation Management',''),
  (41,'Other Business Majors','Other Business Majors',''),
  (42,'Office Management','Office Management',''),
  (43,'Bookkeeping','Bookkeeping',''),
  (44,'Business/Computer Operations','Business/Computer Operations',''),
  (45,'Court Reporting','Court Reporting',''),
  (46,'Secretarial Studies','Secretarial Studies',''),
  (47,'Word Processing','Word Processing',''),
  (48,'Other Office Management','Other Office Management',''),
  (49,'Marketing & Purchasing','Marketing & Purchasing',''),
  (50,'Fashion Merchandising','Fashion Merchandising',''),
  (51,'Retailing & Sales','Retailing & Sales',''),
  (52,'Travel Services & Tourism','Travel Services & Tourism',''),
  (53,'Other Marketing & Purchasing','Other Marketing & Purchasing',''),
  (54,'Communications','Communications',''),
  (55,'Advertising','Advertising',''),
  (56,'Commercial Art','Commercial Art',''),
  (57,'Journalism','Journalism',''),
  (58,'Public Relations','Public Relations',''),
  (59,'Radio/TV Broadcasting','Radio/TV Broadcasting',''),
  (60,'Other Communications','Other Communications',''),
  (61,'Community Services','Community Services',''),
  (62,'Corrections','Corrections',''),
  (63,'Cosmetology/Barbering','Cosmetology/Barbering',''),
  (64,'Criminal Justice','Criminal Justice',''),
  (65,'Fire Protection','Fire Protection',''),
  (66,'Mortuary Science','Mortuary Science',''),
  (67,'Law Enforcement','Law Enforcement',''),
  (68,'Library Science','Library Science',''),
  (69,'Military Science','Military Science',''),
  (70,'Parks & Recreation','Parks & Recreation',''),
  (71,'Public Administration','Public Administration',''),
  (72,'Social Work','Social Work',''),
  (73,'Other Community Services','Other Community Services',''),
  (74,'Computer & Information Sciences','Computer & Information Sciences',''),
  (75,'Computer Programming','Computer Programming',''),
  (76,'Computer Science','Computer Science',''),
  (77,'Data Processing','Data Processing',''),
  (78,'Information Systems','Information Systems',''),
  (79,'Other Computer & Information Sciences','Other Computer & Information Sciences',''),
  (80,'Applied Sciences And Food Science','Applied Sciences And Food Science',''),
  (81,'Aquaculture And Food Technology','Aquaculture And Food Technology',''),
  (82,'Architecture And Fine Arts','Architecture And Fine Arts',''),
  (83,'Audiovisual And Film Studies','Audiovisual And Film Studies',''),
  (84,'Banking And Finance','Banking And Finance',''),
  (85,'Base And Foundation Mechanics','Base And Foundation Mechanics',''),
  (86,'Accounting And Corporate Governance','Accounting And Corporate Governance',''),
  (87,'Biology And Geography','Biology And Geography',''),
  (88,'Biophysics And General Pathology','Biophysics And General Pathology',''),
  (89,'Ceramics And Glass Technology','Ceramics And Glass Technology',''),
  (90,'Chemistry And Geography','Chemistry And Geography',''),
  (91,'Civil Engineering And Geomatics','Civil Engineering And Geomatics',''),
  (92,'Computer Graphics','Computer Graphics',''),
  (93,'Computing And Government','Computing And Government',''),
  (94,'Economics And Governance','Economics And Governance',''),
  (95,'Economics And Government','Economics And Government',''),
  (96,'Agricultural Business','Agricultural Business',''),
  (97,'Agriculture And Biotechnology','Agriculture And Biotechnology',''),
  (98,'Ancient Books','Ancient Books',''),
  (99,'Architecture And Building','Architecture And Building',''),
  (100,'Arts And Business','Arts And Business',''),
  (101,'Active Living And Nutrition','Active Living And Nutrition',''),
  (102,'Agricultural And Natural Resource Sciences','Agricultural And Natural Resource Sciences',''),
  (103,'Arts And Natural Sciences','Arts And Natural Sciences',''),
  (104,'Behaviour And Neuropsychiatry','Behaviour And Neuropsychiatry',''),
  (105,'Biotechnology And Natural Resources','Biotechnology And Natural Resources',''),
  (106,'Care And Nursing','Care And Nursing',''),
  (107,'Area & Ethnic Studies','Area & Ethnic Studies',''),
  (108,'Multi/Interdisciplinary Studies','Multi/Interdisciplinary Studies',''),
  (109,'Liberal Arts/Other General Studies','Liberal Arts/Other General Studies',''),
  (110,'Adult & Continuing Education','Adult & Continuing Education',''),
  (111,'Education Administration','Education Administration',''),
  (112,'Elementary Education','Elementary Education',''),
  (113,'Secondary Education','Secondary Education',''),
  (114,'Student Counseling','Student Counseling',''),
  (115,'Physical Education','Physical Education',''),
  (116,'Special Education','Special Education',''),
  (117,'Other Education Majors','Other Education Majors',''),
  (118,'Engineering','Engineering',''),
  (119,'Aerospace Engineering','Aerospace Engineering',''),
  (120,'Bioengin. & Biomed. Engineering','Bioengin. & Biomed. Engineering',''),
  (121,'Chemical Engineering','Chemical Engineering',''),
  (122,'Civil Engineering','Civil Engineering',''),
  (123,'Electrical & Electronic Engineering','Electrical & Electronic Engineering',''),
  (124,'Environmental Health Engineering','Environmental Health Engineering',''),
  (125,'Industrial Engineering','Industrial Engineering',''),
  (126,'Materials Engineering','Materials Engineering',''),
  (127,'Mechanical Engineering','Mechanical Engineering',''),
  (128,'Mining/Mineral Engineering','Mining/Mineral Engineering',''),
  (129,'Nuclear Engineering','Nuclear Engineering',''),
  (130,'Ocean Engineering','Ocean Engineering',''),
  (131,'Petroleum Engineering','Petroleum Engineering',''),
  (132,'Other Engineering Majors','Other Engineering Majors',''),
  (133,'Fine & Applied Arts','Fine & Applied Arts',''),
  (134,'Applied Design/Crafts','Applied Design/Crafts',''),
  (135,'Art','Art',''),
  (136,'Art History','Art History',''),
  (137,'Cinematography','Cinematography',''),
  (138,'Dance','Dance',''),
  (139,'Dramatic Arts','Dramatic Arts',''),
  (140,'Graphic Design','Graphic Design',''),
  (141,'Music','Music',''),
  (142,'Photography','Photography',''),
  (143,'Other Fine & Applied Arts','Other Fine & Applied Arts',''),
  (144,'Foreign Languages','Foreign Languages',''),
  (145,'Health Professions','Health Professions',''),
  (146,'Chiropractic','Chiropractic',''),
  (147,'Dental Assisting','Dental Assisting',''),
  (148,'Dental Hygiene','Dental Hygiene',''),
  (149,'Dental Lab Technology','Dental Lab Technology',''),
  (150,'Dentistry','Dentistry',''),
  (151,'Emergency Medical Tech.','Emergency Medical Tech.',''),
  (152,'Medical/Surgical Assistant','Medical/Surgical Assistant',''),
  (153,'Medical Lab/Tech.','Medical Lab/Tech.',''),
  (154,'Medicine','Medicine',''),
  (155,'Nuclear Medical Tech.','Nuclear Medical Tech.',''),
  (156,'Nursing','Nursing',''),
  (157,'Occupational Therapy','Occupational Therapy',''),
  (158,'Optometry','Optometry',''),
  (159,'Pharmacy','Pharmacy',''),
  (160,'Physician Assisting','Physician Assisting',''),
  (161,'Physical Therapy','Physical Therapy',''),
  (162,'Radiology','Radiology',''),
  (163,'Respiratory Therapy','Respiratory Therapy',''),
  (164,'Speech Path./Audiology','Speech Path./Audiology',''),
  (165,'Veterinarian Assisting','Veterinarian Assisting',''),
  (166,'Veterinary Medicine','Veterinary Medicine',''),
  (167,'Other Health Professions','Other Health Professions',''),
  (168,'Home Economics','Home Economics',''),
  (169,'Child Development','Child Development',''),
  (170,'Culinary Arts','Culinary Arts',''),
  (171,'Family Resource Management','Family Resource Management',''),
  (172,'Fashion Design','Fashion Design',''),
  (173,'Food/Nutrition/Dietetics','Food/Nutrition/Dietetics',''),
  (174,'Human Environment & Housing','Human Environment & Housing',''),
  (175,'Individual & Family Development','Individual & Family Development',''),
  (176,'Textiles & Clothing','Textiles & Clothing',''),
  (177,'Other Home Economics Majors','Other Home Economics Majors',''),
  (178,'Letters','Letters',''),
  (179,'Classics','Classics',''),
  (180,'Comparative Literature','Comparative Literature',''),
  (181,'Creative Writing','Creative Writing',''),
  (182,'English','English',''),
  (183,'Linguistics','Linguistics',''),
  (184,'Literature, English','Literature, English',''),
  (185,'Speech/Debate, Forensics','Speech/Debate, Forensics',''),
  (186,'Agricultural And Human Sciences','Agricultural And Human Sciences',''),
  (187,'Agriculture And Health Studies','Agriculture And Health Studies',''),
  (188,'Allied Health And Social Work','Allied Health And Social Work',''),
  (189,'Animal Husbandry','Animal Husbandry',''),
  (190,'Animal Husbandry And Development','Animal Husbandry And Development',''),
  (191,'Animal Husbandry And Environment','Animal Husbandry And Environment',''),
  (192,'Animal Husbandry And Forestry','Animal Husbandry And Forestry',''),
  (193,'Applied And Health Sciences','Applied And Health Sciences',''),
  (194,'Art And Historic Preservation','Art And Historic Preservation',''),
  (195,'Art History','Art History',''),
  (196,'Communication And Journalism','Communication And Journalism',''),
  (197,'Community And Social Justice','Community And Social Justice',''),
  (198,'Japanese','Japanese',''),
  (199,'Criminal Justice And Human Services','Criminal Justice And Human Services',''),
  (200,'Criminal Justice And Public Administration','Criminal Justice And Public Administration',''),
  (201,'Education And Jazz','Education And Jazz',''),
  (202,'Accounting And Public Policy Management','Accounting And Public Policy Management',''),
  (203,'Administration And Management','Administration And Management',''),
  (204,'African And Mediterranean Studies','African And Mediterranean Studies',''),
  (205,'Agricultural Management','Agricultural Management',''),
  (206,'Alternative Medicine','Alternative Medicine',''),
  (207,'Animal Sciences And Veterinary Medicine','Animal Sciences And Veterinary Medicine',''),
  (208,'Applied And Mathematical Sciences','Applied And Mathematical Sciences',''),
  (209,'Applied Mathematics','Applied Mathematics',''),
  (210,'Art And Media','Art And Media',''),
  (211,'Arctic And Climate Research','Arctic And Climate Research',''),
  (212,'Mathematics','Mathematics',''),
  (213,'Actuarial Sciences','Actuarial Sciences',''),
  (214,'Applied Mathematics','Applied Mathematics',''),
  (215,'Statistics','Statistics',''),
  (216,'Other Mathematics','Other Mathematics',''),
  (217,'Philosophy/Religion','Philosophy/Religion',''),
  (218,'Physical Sciences','Physical Sciences',''),
  (219,'Astronomy','Astronomy',''),
  (220,'Meteorology','Meteorology',''),
  (221,'Chemistry','Chemistry',''),
  (222,'Earth Science','Earth Science',''),
  (223,'Geology','Geology',''),
  (224,'Oceanography','Oceanography',''),
  (225,'Physics','Physics',''),
  (226,'Other Physical Sciences','Other Physical Sciences',''),
  (227,'Anthropology','Anthropology',''),
  (228,'Economics','Economics',''),
  (229,'Geography','Geography',''),
  (230,'History','History',''),
  (231,'International Relations','International Relations',''),
  (232,'Law','Law',''),
  (233,'Political Science','Political Science',''),
  (234,'Psychology','Psychology',''),
  (235,'Sociology','Sociology',''),
  (236,'Other Social Sciences','Other Social Sciences',''),
  (237,'Aircraft Mechanics','Aircraft Mechanics',''),
  (238,'Automotive Repair','Automotive Repair',''),
  (239,'Construction/Carpentry','Construction/Carpentry',''),
  (240,'Diesel Mechanics','Diesel Mechanics',''),
  (241,'Drafting','Drafting',''),
  (242,'Electronic Equipment/Repair','Electronic Equipment/Repair',''),
  (243,'Heating, Air Conditioning &','Heating, Air Conditioning &',''),
  (244,'Refrigeration Technology','Refrigeration Technology',''),
  (245,'Instrument Maintenance & Repair','Instrument Maintenance & Repair',''),
  (246,'Machinework','Machinework',''),
  (247,'Masonry','Masonry',''),
  (248,'Radio/TV Repair','Radio/TV Repair',''),
  (249,'Welding','Welding',''),
  (250,'Woodworking','Woodworking',''),
  (251,'Other Trade & Industrial Majors','Other Trade & Industrial Majors',''),
  (252,'Environment And Quality','Environment And Quality',''),
  (253,'Finance And Quantitative Studies','Finance And Quantitative Studies',''),
  (254,'Quality Control','Quality Control',''),
  (255,'Securities And Quantitative Finance','Securities And Quantitative Finance',''),
  (256,'Anthropology And Social Work','Anthropology And Social Work',''),
  (257,'Care And Social Welfare','Care And Social Welfare',''),
  (258,'Creative Writing','Creative Writing',''),
  (259,'Cultures And World Affairs','Cultures And World Affairs',''),
  (260,'Education And Social Work','Education And Social Work',''),
  (261,'Educational Sciences And Social Work','Educational Sciences And Social Work',''),
  (262,'Health And Social Work','Health And Social Work',''),
  (263,'Health And Welfare','Health And Welfare',''),
  (264,'Health And Wellbeing','Health And Wellbeing',''),
  (265,'Accounting And Economics','Accounting And Economics',''),
  (266,'Administration And Economics','Administration And Economics',''),
  (267,'Administration And Economy','Administration And Economy',''),
  (268,'Adult Education','Adult Education',''),
  (269,'Adult Special Education (ase)','Adult Special Education (ase)',''),
  (270,'Aeronautical And Aerospace Engineering','Aeronautical And Aerospace Engineering',''),
  (271,'Agricultural And Environmental Engineering','Agricultural And Environmental Engineering',''),
  (272,'Agricultural And Environmental Sciences','Agricultural And Environmental Sciences',''),
  (273,'Agricultural And Food Engineering Operation','Agricultural And Food Engineering Operation',''),
  (274,'Agricultural Chemistry And Ecology','Agricultural Chemistry And Ecology',''),
  (275,'Administration And International Relations','Administration And International Relations',''),
  (276,'Advertising And Public Relations','Advertising And Public Relations',''),
  (277,'Agricultural And Natural Resource Sciences','Agricultural And Natural Resource Sciences',''),
  (278,'Air Conditioning And Refrigeration','Air Conditioning And Refrigeration',''),
  (279,'Ancient Religions','Ancient Religions',''),
  (280,'Architectural Restoration','Architectural Restoration',''),
  (281,'Arctic And Climate Research','Arctic And Climate Research',''),
  (282,'Argumentation And Rhetoric','Argumentation And Rhetoric',''),
  (283,'Asian Religious Studies','Asian Religious Studies',''),
  (284,'Balneology And Medical Rehabilitation','Balneology And Medical Rehabilitation',''),
  (285,'Turkish','Turkish',''),
  (286,'Accounting And Taxation','Accounting And Taxation',''),
  (287,'Accounting And Tourism','Accounting And Tourism',''),
  (288,'Administration And Tourism','Administration And Tourism',''),
  (289,'Agrosystem And Territories','Agrosystem And Territories',''),
  (290,'Air Transport','Air Transport',''),
  (291,'Health And Criminal Justice','Health And Criminal Justice',''),
  (292,'History And Criminal Justice','History And Criminal Justice',''),
  (293,'History And Journalism','History And Journalism',''),
  (294,'Jazz And Popular Music','Jazz And Popular Music',''),
  (295,'Development And Transfer Of Management Knowledge','Development And Transfer Of Management Knowledge',''),
  (296,'Kinesiology And Social Work','Kinesiology And Social Work',''),
  (297,'Zoology','Zoology',''),
  (298,'Accounting And Control','Accounting And Control',''),
  (299,'Accounting And Corporate Governance','Accounting And Corporate Governance',''),
  (300,'Accounting And Cost Controlling','Accounting And Cost Controlling',''),
  (301,'Administration And Commerce','Administration And Commerce',''),
  (302,'Administration And Communication Studies','Administration And Communication Studies',''),
  (303,'Administrative And Communication Sciences','Administrative And Communication Sciences',''),
  (304,'Ageing And Cancer','Ageing And Cancer',''),
  (305,'Agricultural Chemistry And Ecology','Agricultural Chemistry And Ecology',''),
  (306,'Agricultural Chemistry And Plant Protection','Agricultural Chemistry And Plant Protection',''),
  (307,'Computer And Natural Sciences','Computer And Natural Sciences',''),
  (308,'Computer Networks','Computer Networks',''),
  (309,'Computer Science And Computer Networks','Computer Science And Computer Networks',''),
  (310,'Computer Science And Natural Sciences','Computer Science And Natural Sciences',''),
  (311,'Accounting And Management','Accounting And Management',''),
  (312,'Communication And Information Systems Research','Communication And Information Systems Research',''),
  (313,'Education And Research','Education And Research',''),
  (314,'Aquaculture And Food Technology','Aquaculture And Food Technology',''),
  (315,'Architecture And Information Technology','Architecture And Information Technology',''),
  (316,'Architecture And Technology','Architecture And Technology',''),
  (317,'Yoga','Yoga',''),
  (318,'Yoga Education And Research','Yoga Education And Research',''),
  (319,'Youth And Family Studies','Youth And Family Studies',''),
  (320,'Architectural Engineering And Urban Planning','Architectural Engineering And Urban Planning',''),
  (321,'Civil Engineering And Urban Planning','Civil Engineering And Urban Planning',''),
  (322,'Design And Urban Studies','Design And Urban Studies',''),
  (323,'Earth And Universe Sciences','Earth And Universe Sciences',''),
  (324,'European Union Law','European Union Law',''),
  (325,'Matter And The Universe','Matter And The Universe',''),
  (326,'Regional And Urban Planning','Regional And Urban Planning',''),
  (327,'Ukrainian','Ukrainian',''),
  (328,'Universe And Earth Sciences','Universe And Earth Sciences',''),
  (329,'University And Government Cooperation','University And Government Cooperation',''),
  (330,'Administration And Information Systems','Administration And Information Systems',''),
  (331,'Administration And International Relations','Administration And International Relations',''),
  (332,'Architecture And Information Technology','Architecture And Information Technology',''),
  (333,'Archiving And Information Science','Archiving And Information Science',''),
  (334,'Artificial Intelligence','Artificial Intelligence',''),
  (335,'Arts And Information Technology','Arts And Information Technology',''),
  (336,'Astronomy And Informatics','Astronomy And Informatics',''),
  (337,'Automation And Information Technology','Automation And Information Technology',''),
  (338,'Business Administration And Information Technology','Business Administration And Information Technology',''),
  (339,'Business And Information Technologies','Business And Information Technologies',''),
  (340,'Agricultural And Food Engineering Operation','Agricultural And Food Engineering Operation',''),
  (341,'Art And Oriental Studies','Art And Oriental Studies',''),
  (342,'Austronesian And Oceanic Languages','Austronesian And Oceanic Languages',''),
  (343,'Coastal And Offshore Engineering','Coastal And Offshore Engineering',''),
  (344,'Composition And Theory Of Music','Composition And Theory Of Music',''),
  (345,'Conducting And Theory Of Music','Conducting And Theory Of Music',''),
  (346,'Construction And Operation Of Pipeline Systems','Construction And Operation Of Pipeline Systems',''),
  (347,'Culture And Organisation','Culture And Organisation',''),
  (348,'Development And Marketing Of Tourist Services In The Euro-mediterranean Areas','Development And Marketing Of Tourist Services In The Euro-mediterranean Areas',''),
  (349,'Development And Transfer Of Management Knowledge','Development And Transfer Of Management Knowledge',''),
  (350,'Accounting And Public Policy Management','Accounting And Public Policy Management',''),
  (351,'Administration And Political Science','Administration And Political Science',''),
  (352,'Administration And Public Sector Studies','Administration And Public Sector Studies',''),
  (353,'Advertising And Public Relations','Advertising And Public Relations',''),
  (354,'Advertising And Publicity','Advertising And Publicity',''),
  (355,'Agricultural Chemistry And Plant Protection','Agricultural Chemistry And Plant Protection',''),
  (356,'Analytical And Physical Chemistry','Analytical And Physical Chemistry',''),
  (357,'Applied And Performing Arts','Applied And Performing Arts',''),
  (358,'Applied Physics','Applied Physics',''),
  (359,'Archaeology And Paleontology','Archaeology And Paleontology',''),
  (360,'Accounting','Accounting',''),
  (361,'Accounting And Acturial Studies','Accounting And Acturial Studies',''),
  (362,'Accounting And Administration','Accounting And Administration',''),
  (363,'Accounting And Affiliated Disciplines','Accounting And Affiliated Disciplines',''),
  (364,'Accounting And Audit','Accounting And Audit',''),
  (365,'Accounting And Business Sciences','Accounting And Business Sciences',''),
  (366,'Accounting And Control','Accounting And Control',''),
  (367,'Accounting And Corporate Governance','Accounting And Corporate Governance',''),
  (368,'Accounting And Cost Controlling','Accounting And Cost Controlling',''),
  (369,'Accounting And Acturial Studies','Accounting And Acturial Studies',''),
  (370,'Accounting And Business Sciences','Accounting And Business Sciences',''),
  (371,'Accounting And Statistics','Accounting And Statistics',''),
  (372,'Actuarial Science','Actuarial Science',''),
  (373,'Administration And Basic Sciences','Administration And Basic Sciences',''),
  (374,'Administration And Communication Studies','Administration And Communication Studies',''),
  (375,'Administration And Information Systems','Administration And Information Systems',''),
  (376,'Administration And Political Science','Administration And Political Science',''),
  (377,'Administration And Public Sector Studies','Administration And Public Sector Studies',''),
  (378,'Administration And Social Sciences','Administration And Social Sciences',''),
  (379,'Accounting And Affiliated Disciplines','Accounting And Affiliated Disciplines',''),
  (380,'Acting And Directing','Acting And Directing',''),
  (381,'Administrative And Diplomatic Sciences','Administrative And Diplomatic Sciences',''),
  (382,'Animal Husbandry And Development','Animal Husbandry And Development',''),
  (383,'Architectural And Environmental Design','Architectural And Environmental Design',''),
  (384,'Architecture And Design','Architecture And Design',''),
  (385,'Art And Design','Art And Design',''),
  (386,'Arts And Design','Arts And Design',''),
  (387,'Building And Design','Building And Design',''),
  (388,'Catering And Domestic Services','Catering And Domestic Services',''),
  (389,'Administration And Finance','Administration And Finance',''),
  (390,'Advertising And Film Art','Advertising And Film Art',''),
  (391,'Agricultural And Food Engineering Operation','Agricultural And Food Engineering Operation',''),
  (392,'Animal Husbandry And Forestry','Animal Husbandry And Forestry',''),
  (393,'Air Conditioning And Refrigeration','Air Conditioning And Refrigeration',''),
  (394,'Animal Sciences And Veterinary Medicine','Animal Sciences And Veterinary Medicine',''),
  (395,'Architecture And Visual Arts','Architecture And Visual Arts',''),
  (396,'Biomedical And Veterinary Sciences','Biomedical And Veterinary Sciences',''),
  (397,'Design And Visual Arts','Design And Visual Arts',''),
  (398,'Food Science And Veterinary Science','Food Science And Veterinary Science',''),
  (399,'Forestry And Veterinary Science','Forestry And Veterinary Science',''),
  (400,'Heating Supply And Ventilation','Heating Supply And Ventilation',''),
  (401,'Landscape And Visual Arts','Landscape And Visual Arts',''),
  (402,'Nanotechnology And Vacuum Technique','Nanotechnology And Vacuum Technique',''),
  (403,'Nutrition And Veterinary Science','Nutrition And Veterinary Science',''),
  (404,'Banking','Banking',''),
  (405,'Accounting And Business Sciences','Accounting And Business Sciences',''),
  (406,'Administration And Basic Sciences','Administration And Basic Sciences',''),
  (407,'Administration And Business Administration','Administration And Business Administration',''),
  (408,'Advertising And Show Business','Advertising And Show Business',''),
  (409,'Education Research','Education Research',''),
  (410,'Educational Research','Educational Research',''),
  (411,'Energy And Environment Research','Energy And Environment Research',''),
  (412,'Operations Research','Operations Research',''),
  (413,'Organ Research And Church Music','Organ Research And Church Music',''),
  (414,'Political And Anthropological Research','Political And Anthropological Research',''),
  (415,'Political And Social Structures Research','Political And Social Structures Research','');
  
  /*Table structure for table `core_salary_ranges` */
  
  DROP TABLE IF EXISTS `core_salary_ranges`;
  
  CREATE TABLE `core_salary_ranges` (
    `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
    `minSalary` int(11) NOT NULL DEFAULT '0',
    `maxSalary` int(11) NOT NULL DEFAULT '0',
    `deletedDate` varchar(12) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  
  /*Data for the table `core_salary_ranges` */
  
  insert  into `core_salary_ranges`(`id`,`minSalary`,`maxSalary`,`deletedDate`) values 
  (1,0,500,''),
  (2,500,1000,''),
  (3,1000,1500,''),
  (4,1500,2000,''),
  (5,2000,3000,''),
  (6,3000,4000,''),
  (7,4000,5000,''),
  (8,5000,6000,''),
  (9,6000,7000,''),
  (10,7000,8000,''),
  (11,8000,9000,''),
  (12,9000,10000,''),
  (13,10000,15000,''),
  (14,15000,30000,''),
  (15,30000,50000,'');
  
  /*Table structure for table `core_sectors` */
  
  DROP TABLE IF EXISTS `core_sectors`;
  
  CREATE TABLE `core_sectors` (
    `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
    `sector_en` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    `sector_ar` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    `deletedDate` varchar(12) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  
  /*Data for the table `core_sectors` */
  
  insert  into `core_sectors`(`id`,`sector_en`,`sector_ar`,`deletedDate`) values 
  (1,'Agriculture, Fishery & Livestock','Agriculture, Fishery & Livestock',''),
  (2,'Arts, Entertainment & Media','Arts, Entertainment & Media',''),
  (3,'Business Support & Marketing','Business Support & Marketing',''),
  (4,'Conglomerate & Holding Group','Conglomerate & Holding Group',''),
  (5,'Construction & Property','Construction & Property',''),
  (6,'Education, Science, & Research','Education, Science, & Research',''),
  (7,'Engineering & Technical Services','Engineering & Technical Services',''),
  (8,'Finance, Insurance, & Legal','Finance, Insurance, & Legal',''),
  (9,'Government, Community, & NGO','Government, Community, & NGO',''),
  (10,'Healthcare & Pharma','Healthcare & Pharma',''),
  (11,'IT & Telecom','IT & Telecom',''),
  (12,'Leisure, Hospitality & Tourism','Leisure, Hospitality & Tourism',''),
  (13,'Manufacturing, Consumer Goods & Industrial','Manufacturing, Consumer Goods & Industrial',''),
  (14,'Military & Aerospace','Military & Aerospace',''),
  (15,'Oil, Energy, & Utilities','Oil, Energy, & Utilities',''),
  (16,'Personal Services & Wellness','Personal Services & Wellness',''),
  (17,'Retail & Wholesale','Retail & Wholesale',''),
  (18,'Security','Security',''),
  (19,'Transport, Logistics, & Aviation','Transport, Logistics, & Aviation','');
  
  /*Table structure for table `core_sign_in_history` */
  
  DROP TABLE IF EXISTS `core_sign_in_history`;
  
  CREATE TABLE `core_sign_in_history` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `userId` int(11) NOT NULL,
    `timestamp` bigint(20) NOT NULL,
    `date` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `time` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `remoteAddress` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  
  /*Data for the table `core_sign_in_history` */
  
  insert  into `core_sign_in_history`(`id`,`userId`,`timestamp`,`date`,`time`,`remoteAddress`) values 
  (1,1,1582873600123,'2020-02-27','11:06 PM','::1');
  
  /*Table structure for table `core_users` */
  
  DROP TABLE IF EXISTS `core_users`;
  
  CREATE TABLE `core_users` (
    `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
    `workId` int(11) NOT NULL DEFAULT '0',
    `workRole` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    `hireId` int(11) NOT NULL DEFAULT '0',
    `hireRole` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    `username` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    `hash` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    `firstName` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    `fatherName` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    `lastName` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    `countryCode` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    `phone` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    `website` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    `nationality` enum('BH','KW','OM','QA','SA','AE') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'SA',
    `country` enum('BH','KW','OM','QA','SA','AE') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'SA',
    `cityId` int(11) NOT NULL DEFAULT '0',
    `birthday` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    `gender` enum('M','F','U') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'M',
    `createdDate` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    `modifiedDate` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    `deletedDate` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    `emailVerified` tinyint(1) NOT NULL DEFAULT '0',
    `phoneVerified` tinyint(1) NOT NULL DEFAULT '0',
    `allowedDate` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  
  /*Data for the table `core_users` */
  
  insert  into `core_users`(`id`,`workId`,`workRole`,`hireId`,`hireRole`,`email`,`username`,`hash`,`firstName`,`fatherName`,`lastName`,`countryCode`,`phone`,`website`,`nationality`,`country`,`cityId`,`birthday`,`gender`,`createdDate`,`modifiedDate`,`deletedDate`,`emailVerified`,`phoneVerified`,`allowedDate`) values 
  (1,0,'',1,'ADMIN','honey96dev@gmail.com','honey96dev@gmail.com','d23a920d288c583cba26b97b3e1a0269ae5d1ea39f21b01c07ed06860e355655','Zhenlong','Xuanming','Jin','+966','571623415','','SA','SA',0,'','U','2020-02-27','2020-02-27','',0,0,'2020-02-27');
  
  /*Table structure for table `hire_accounts` */
  
  DROP TABLE IF EXISTS `hire_accounts`;
  
  CREATE TABLE `hire_accounts` (
    `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    `hideLocation` tinyint(1) NOT NULL DEFAULT '0',
    `location` enum('BH','KW','OM','QA','SA','AE') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'SA',
    `size` int(4) NOT NULL DEFAULT '10',
    `sectorId` int(11) NOT NULL DEFAULT '0',
    `industryId` int(11) NOT NULL DEFAULT '0',
    `type` enum('PUBLIC','PRIVATE','NON_PROFIT','AGENCY') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'PUBLIC',
    `website` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    `taxRegNumber` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    `createdDate` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    `modifiedDate` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    `deletedDate` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  
  /*Data for the table `hire_accounts` */
  
  insert  into `hire_accounts`(`id`,`name`,`hideLocation`,`location`,`size`,`sectorId`,`industryId`,`type`,`website`,`taxRegNumber`,`createdDate`,`modifiedDate`,`deletedDate`) values 
  (1,'ERC',0,'SA',10,0,0,'PUBLIC','','','2020-02-27','2020-02-27','');
  
  /*Table structure for table `hire_job_candidate_requirements` */
  
  DROP TABLE IF EXISTS `hire_job_candidate_requirements`;
  
  CREATE TABLE `hire_job_candidate_requirements` (
    `id` int(11) unsigned NOT NULL,
    `careerLevel` int(3) NOT NULL DEFAULT '0',
    `xpYear1` int(3) NOT NULL DEFAULT '0',
    `xpYear2` int(3) NOT NULL DEFAULT '0',
    `majorId` int(11) NOT NULL DEFAULT '0',
    `degree` int(2) NOT NULL DEFAULT '0',
    `countryId` int(11) NOT NULL DEFAULT '0',
    `cityId` int(11) NOT NULL DEFAULT '0',
    `nationalityId` int(11) NOT NULL DEFAULT '0',
    `gender` enum('U','M','F') COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'U',
    `age1` int(3) NOT NULL DEFAULT '0',
    `age2` int(3) NOT NULL DEFAULT '0',
    `deletedDate` varchar(12) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  
  /*Data for the table `hire_job_candidate_requirements` */
  
  insert  into `hire_job_candidate_requirements`(`id`,`careerLevel`,`xpYear1`,`xpYear2`,`majorId`,`degree`,`countryId`,`cityId`,`nationalityId`,`gender`,`age1`,`age2`,`deletedDate`) values 
  (0,3,0,0,0,0,0,0,0,'U',0,0,''),
  (1,3,1,2,15,3,5,133,5,'U',0,0,''),
  (4,3,2,11,0,4,0,0,0,'U',0,0,''),
  (5,6,0,0,0,0,0,0,0,'U',0,0,''),
  (6,5,2,4,0,0,0,0,0,'U',0,0,'');
  
  /*Table structure for table `hire_job_email_setting` */
  
  DROP TABLE IF EXISTS `hire_job_email_setting`;
  
  CREATE TABLE `hire_job_email_setting` (
    `id` int(11) unsigned NOT NULL,
    `notification` enum('NONE','DAILY','CV') COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'DAILY',
    `autoreply` tinyint(1) NOT NULL DEFAULT '1',
    `autoreplyContent` text COLLATE utf8mb4_general_ci,
    `deletedDate` varchar(12) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  
  /*Data for the table `hire_job_email_setting` */
  
  /*Table structure for table `hire_jobs` */
  
  DROP TABLE IF EXISTS `hire_jobs`;
  
  CREATE TABLE `hire_jobs` (
    `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
    `hireId` int(11) NOT NULL DEFAULT '0',
    `candidateType` enum('PROFESSIONAL','SKILLED') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'PROFESSIONAL',
    `title` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    `jobRoleId` int(11) NOT NULL DEFAULT '0',
    `jobSubroleId` int(11) NOT NULL DEFAULT '0',
    `sectorId` int(11) NOT NULL DEFAULT '0',
    `industryId` int(11) NOT NULL DEFAULT '0',
    `countryId` int(11) NOT NULL DEFAULT '0',
    `cityId` int(11) NOT NULL DEFAULT '0',
    `employmentTypeId` int(11) NOT NULL DEFAULT '0',
    `salaryRangeId` int(11) NOT NULL DEFAULT '0',
    `vacanciesCount` int(11) NOT NULL DEFAULT '0',
    `description` text COLLATE utf8mb4_general_ci,
    `skills` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
    `specialties` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    `questionnaireId` int(11) NOT NULL DEFAULT '0',
    `isActive` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0-inactive, 1-active, 2-draft',
    `deletedDate` varchar(12) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  
  /*Data for the table `hire_jobs` */
  
  insert  into `hire_jobs`(`id`,`hireId`,`candidateType`,`title`,`jobRoleId`,`jobSubroleId`,`sectorId`,`industryId`,`countryId`,`cityId`,`employmentTypeId`,`salaryRangeId`,`vacanciesCount`,`description`,`skills`,`specialties`,`questionnaireId`,`isActive`,`deletedDate`) values 
  (1,1,'SKILLED','I want to hire an artist',25,289,2,12,5,181,2,4,2,'<p>Hello</p>\n','<p>painting</p>\n','painting',3,0,''),
  (4,1,'SKILLED','qqq',9,91,6,54,4,89,2,0,0,'<p>afafsdqqqq</p>\n','<p>wwww</p>\n','asdf,aaa',1,0,''),
  (5,1,'SKILLED','Portfolio',11,108,2,13,5,106,0,0,0,'<p>hehehe</p>\n','<p>aaa</p>\n','hihihi',2,0,''),
  (6,1,'PROFESSIONAL','jedzidvunujo',12,120,9,78,3,55,0,0,0,'<p>safasdf</p>\n','<p>gggff</p>\n','sdfg',0,0,'');
  
  /*Table structure for table `hire_letters` */
  
  DROP TABLE IF EXISTS `hire_letters`;
  
  CREATE TABLE `hire_letters` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `userId` int(11) NOT NULL DEFAULT '0',
    `type` enum('GENERIC','INTERVIEW','FOLLOWUP','ACCEPTANCE','REJECTION','ON_BOARDING') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'GENERIC',
    `name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    `subject` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    `message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
    `attached` tinyint(1) NOT NULL DEFAULT '0',
    `attachment` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    `attachmentName` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    `deletedDate` varchar(12) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  
  /*Data for the table `hire_letters` */
  
  insert  into `hire_letters`(`id`,`userId`,`type`,`name`,`subject`,`message`,`attached`,`attachment`,`attachmentName`,`deletedDate`) values 
  (1,1,'GENERIC','asf','sdf','<p>sfffsdfaf</p>\n',0,'','','2020-03-05'),
  (2,1,'ON_BOARDING','Research Service','taddeoprivej','<p>aaaaa</p>\n<p>dddd</p>\n',0,'','','');
  
  /*Table structure for table `hire_my_company_profiles` */
  
  DROP TABLE IF EXISTS `hire_my_company_profiles`;
  
  CREATE TABLE `hire_my_company_profiles` (
    `id` int(11) unsigned NOT NULL,
    `salaryUnit` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    `salaryMin` double NOT NULL DEFAULT '0',
    `salaryMax` double NOT NULL DEFAULT '0',
    `about` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
    `vision` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
    `mission` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
    `coverPhoto` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  
  /*Data for the table `hire_my_company_profiles` */
  
  /*Table structure for table `hire_questionnaire` */
  
  DROP TABLE IF EXISTS `hire_questionnaire`;
  
  CREATE TABLE `hire_questionnaire` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `userId` int(11) NOT NULL DEFAULT '0',
    `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
    `filterByScore` tinyint(1) NOT NULL DEFAULT '0',
    `minScore` int(6) NOT NULL DEFAULT '0',
    `deletedDate` varchar(12) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  
  /*Data for the table `hire_questionnaire` */
  
  insert  into `hire_questionnaire`(`id`,`userId`,`name`,`description`,`filterByScore`,`minScore`,`deletedDate`) values 
  (1,1,'My Questionnaire','<p style=\"text-align:right;\">This is test <span style=\"font-size: 30px;\"><strong>questionnaire</strong></span></p>\n<p>ADasdfsdf   <em>ASFDSADFASF </em></p>\n<p><span style=\"background-color: rgb(243,121,52);\"><em>ASDGASDFASDF</em></span></p>\n<p><span style=\"color: rgb(26,188,156);\"><em>ASDFASDF</em>ASDFSDFSFSDGASDFS  </span>ADFSFSF</p>\n',1,5,''),
  (2,1,'Research Service','<p>ASFD</p>\n<p style=\"text-align:right;\"><span style=\"color: rgb(26,188,156);background-color: rgb(209,72,65);font-size: 30px;font-family: Impact;\">SFDSD</span></p>\n<p></p>\n<p>??</p>\n',0,0,'2020-03-05'),
  (3,1,'New','<p><strong>This is new questionnaire</strong></p>\n<p style=\"text-align:right;\"><span style=\"color: rgb(97,189,109);\"><strong>asfsfsdf</strong></span></p>\n',1,4,'');
  
  /*Table structure for table `hire_questionnaire_answers` */
  
  DROP TABLE IF EXISTS `hire_questionnaire_answers`;
  
  CREATE TABLE `hire_questionnaire_answers` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `answerId` bigint(20) NOT NULL DEFAULT '0',
    `answer` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    `score` int(4) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  
  /*Data for the table `hire_questionnaire_answers` */
  
  /*Table structure for table `hire_questionnaire_questions` */
  
  DROP TABLE IF EXISTS `hire_questionnaire_questions`;
  
  CREATE TABLE `hire_questionnaire_questions` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `questionnaireId` bigint(20) NOT NULL DEFAULT '0',
    `question` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    `type` enum('YES_NO','SELECT','TEXT') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'YES_NO',
    `required` tinyint(1) NOT NULL DEFAULT '0',
    `answers` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    `hasCorrectAnswer` tinyint(1) NOT NULL DEFAULT '0',
    `correctAnswer` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    `deletedDate` varchar(12) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  
  /*Data for the table `hire_questionnaire_questions` */
  
  insert  into `hire_questionnaire_questions`(`id`,`questionnaireId`,`question`,`type`,`required`,`answers`,`hasCorrectAnswer`,`correctAnswer`,`deletedDate`) values 
  (1,1,'Are you married?','YES_NO',1,'',0,'',''),
  (2,1,'How old are you?','TEXT',0,'',0,'',''),
  (9,1,'How much do you earn a month?','YES_NO',1,'<100,100-500,500-1000,1000+',0,'',''),
  (12,1,'What do you major in?','SELECT',1,'apple,pear',0,'apple',''),
  (41,1,'How many years do you have experience?','TEXT',1,'',0,'',''),
  (46,2,'Are you married?','YES_NO',0,'',0,'',''),
  (47,2,'How old are you?','YES_NO',0,'',0,'',''),
  (48,3,'aaaa','YES_NO',0,'',0,'','');
  
  /*Table structure for table `work_accounts` */
  
  DROP TABLE IF EXISTS `work_accounts`;
  
  CREATE TABLE `work_accounts` (
    `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  
  /*Data for the table `work_accounts` */
  
  /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  