text: -- phpMyAdmin SQL Dump
  -- version 4.5.4.1deb2ubuntu2
  -- http://www.phpmyadmin.net
  --
  -- Host: localhost:3306
  -- Generation Time: May 15, 2018 at 01:55 PM
  -- Server version: 5.7.22-0ubuntu0.16.04.1
  -- PHP Version: 7.0.30-0ubuntu0.16.04.1
  
  SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  SET time_zone = "+00:00";
  
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  /*!40101 SET NAMES utf8mb4 */;
  
  --
  -- Database: `ehunter`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `companies`
  --
  
  CREATE TABLE `companies` (
    `id` int(11) NOT NULL,
    `name` varchar(255) NOT NULL,
    `email` varchar(255) NOT NULL,
    `password` varchar(255) NOT NULL,
    `logo` varchar(255) NOT NULL DEFAULT 'company_logo.png',
    `description` text
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `companies`
  --
  
  INSERT INTO `companies` (`id`, `name`, `email`, `password`, `logo`, `description`) VALUES
  (1, 'PT Toyota', 'coba@gmail.com', 'testing', 'company_logo.png', 'test'),
  (2, 'BNCC', 'kumpeni@binus', 'kumpeni', 'BNCC_T.png', NULL),
  (3, 'PT Bina Nusa Kembangan', 'test@a', '$2b$10$sHR8UevNVZKO9ubSLdySQeD38Pk2eW3EDVNO0bjwBJp3rqC0O21Xy', 'NusaKembangan.png', NULL),
  (4, 'Bukalapak', 'kumpeni@gmail.com', '$2b$10$z62DE4AM1YDY91MSGZ8Avect9KPc5CR4fndHh1vTt421DzXMbhAPu', 'bukalapak.png', NULL),
  (5, 'Tokopedia', 'tokopedia@gmail.com', '$2b$10$N.AwuyKrLbs3pjbzgG4CieewGPlhS0JPg9JNcxoKjK4h4aiDTUsBS', 'tokopedia.png', 'test 2 34'),
  (6, 'Bina Nusantara', 'example@binus.edu', 'example', 'binus.png', 'Ini Kumpeni Binus'),
  (7, 'Kudos', 'example@kudos.id', 'example', 'kudo.png', 'ini kumpeni kudos'),
  (8, 'Grab', 'example@grab.com', 'example', 'grab.png', 'ini kumpeni Grab'),
  (9, 'Alibaba', 'example@alibaba.com', 'example', 'alibaba.png', 'Ini Perusahaan Alibaba'),
  (10, 'Rakuten JP', 'example@rakuten.jp', 'example', 'rakuten.png', NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `hunters`
  --
  
  CREATE TABLE `hunters` (
    `id` int(11) NOT NULL,
    `name` varchar(255) NOT NULL,
    `email` varchar(255) NOT NULL,
    `password` varchar(255) NOT NULL,
    `bio` varchar(255) DEFAULT NULL,
    `cv` varchar(255) DEFAULT NULL,
    `ktp` varchar(255) DEFAULT NULL,
    `cv_raw` text,
    `ktp_raw` text
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `hunters`
  --
  
  INSERT INTO `hunters` (`id`, `name`, `email`, `password`, `bio`, `cv`, `ktp`, `cv_raw`, `ktp_raw`) VALUES
  (1, 'Anthony Smith', 'test', 'test', '', '1526066751627.doc', NULL, 'A British Curriculum Vitae CURRICULUM VITAE Name	Johanneke Marie VAN DALE Janneke\nAddress	Breestraat 21 2311 AB LEIDEN the Netherlands\nTelephone	31 71 5126511\nEmail GOTOBUTTON BM_1_ jannekehotmailcom\nDate of birth	7 March 1988\nNationality	Dutch\nSex	Female\nMarital status	Single EducationQualifications\n20062010	Leiden University MA in English Language and Literature obtained in 2009\n20002006	Stedelijk Lyceum Arnhem Diploma GymnasiumA gives entry to university in the subjects Dutch Latin French German English History Social Studies and Music Employment to DateWork Experience\n2007present	Employment Agency Randfiguur Leiden the Netherlands Post Translator\n2006present	Freelance translator\n2009	Translation Agency Snoep en Honnepon Amsterdam the Netherlands Post Trainee Other ExperienceActivities\n20062009	Member of the International Students Association AISLE\n2009	Member of the Exchange Committee of AISLE Leiden Post Assessor Activities Responsibilities Liaisoning with European associate clubs organising social events Languages	Dutch native speaker English near native speaker French good German fair Italian good passive skills Russian basic Other Skills	Computer literate Windows applications Clean Driving Licence Interests	Travelling international affairs European history meeting friends Publications\n2008	As Long as he Catches Rats a Life of Deng Xiao Ping in International Student Weekly 22 81423 References	Professor G Philby Professor of Translation Studies Department of English Leiden University LEIDEN\nMs J Tweehuizen Head of the English Section of Translation Agency Snoep en Honnepon AMSTERDAM ', NULL),
  (2, 'Pribadi Ridwan Mulyono', 'test', 'test', '', '1526028079808.pdf', NULL, 'Pribadi Ridwan Mulyono Teaching Assistant  Software Engineer Contact  87  88  516  7008 P ribadiridwan1 stgmailcom Social Media Facebook  godfal len Linkedin   inpribadi1st Skills PHP Web Service Development  Web Client Development  Researching new technology  Designing Database  English  German  Indonesian  Working in Group Profile I am a s oftware engineer with thorough hands  n experience in all levels of testing and a teac hing a ssistant with 2 yea r s experiences  Seeking a full  time position where I can apply my knowledge an d skills for con ti nues imp rovement Experience TEACHING ASSISTANT  BINUS UNIVERSITY  FEB 2016  FEB 2018  Teaching a programming practicum class  Programming case making  correcting student case result  Teaching new assistant JUNIOR RESEARCHER  RESEARCH TECHNOLOGIC AL TRANSFER OF FICE  MAR 2017  FEB 2018  Preparing research proposal  Collecting model data  Analyzing model data  Developing research model Education BACHELOR  BINUS UNI VERSITY  2014  2018  Current GPA 346  Best RIG research interest group  Studied in Artificial Intelligence Major  Dewa W eb UI competition  Participate  Volu nteer Experience or Leadership Volunteer Experience  Teaching Kindergarten  2014  Jakarta Marathon  2014  Autism is not a joke Campaign  2015  Volunteer in BIMBEL  2015  Activist in MS Word Com puter Training  2017  Activist in MS Excel computer Training  2017  Entrevolution AIESEC  2016 Seminar or leadership training  HTTP Binus Seminar  2014  Me Featuring Social Media with Shopee Talkshow  2015  iDaysGerman Language BinusWorkshop  2015  Campus Life Orientation Binus  2014  Training Assistant Binus  2015  Mentor Comitter  2015  Buddy Coordinator Binus  2015  Open Source Software Development  Engineering Seminar  2016  Big Data Seminar Stanford University  2016  Research Workshop with IIAI International Institute of applied informatics japan  2017 AWSOME DAYS WITH AWS EDUCATE AMAZON WEB SERVICE  2017 ', NULL),
  (3, 'Vasso Kondou Watson', 'test', 'test', '', '1525962935837.doc', NULL, 'CURRICULUM VITAE PERSONAL DETAILS Name Vasso Kondou Watson Nationality Greek UK address 209 Queen Alexandra Road	Marital Status Married Sunderland SR3 1YF Date of Birth 10041978 GPA Univeristy 300 Telephone 0044 0 7786266730 Age 31 Email EDUCATION AND QUALIFICATIONS UNIVERSITY OF SUNDERLAND\nMA TESOL 2006 BEDE COLLEGE SUNDERLAND NCFE Certificate in Equality and Diversity\nExplore Equality and Diversity Prejudice and Discrimination Peoples Rights and Responsibilities\n2003 BEDE COLLEGE SUNDERLAND NCFE Certificate in Child Psychology  Early Experience The Developing Child The Child in Society\nUNIVERSITY OF SUNDERLAND\nBA Hons English Education  QTS English Language Literature Linguistics Media Drama\nUNIVERSITY OF SUNDERLAND\nHND  Business IT\n19971998	BEDE COLLEGE SUNDERLAND\nA Level  English\n1997 ALIARTOS ENGLISH PRIVATE SCHOOL GREECE National Proficiency Certificate in English WORK EXPERIENCE 20082009 English Teacher Castle View School Sunderland\nTeaching English in KS3 and KS4 teaching Literacy as well as teaching guided and group reading as part of the Literacy Strategy in KS3 design implement and assess KS3 Literacy targets devising operational KS34 schemes of work for the English department teaching Greek as an extra curricular activity to pupils and teachers\nClassroom supervision of student teachers and voluntary classroom assistants attending departmental management and school meetings invigilating internal exams marking advising staff on lesson planning Class registration OFSTED February 2009 preparation and observation Oct 20062007 Supply Teacher Castle View School Sunderland\nDuties Teaching English in KS3 and KS4 team teaching Literacy as well as teaching guided and group reading as part of the Literacy Strategy in KS3 design implement and assess KS3 Literacy targets devising operational KS34 schemes of work for the English department teaching Greek as an extra curricula activity to pupils and teachers\nClassroom supervision of student teachers and voluntary classroom assistants attending departmental management and school meetings invigilating internal exams marking advising staff on lesson planning Class registration OFSTED March 2007 Preparation and observation Sept 2005May 2006	English Teacher Kassaris School of English Athens Duties Teaching English in KS3KS5 Personal tutoring of low ability students Liaising with parents report writing invigilation of internal exams designing and implementing schemes of work exam preparation and provision TOEFL MICHIGANLower CAMBRIDGELower MICHIGANProficiency CAMBRIDGEProficiency IELTS Sept 20042006 Assistant Head of the English Department Euromathisi English School Athens\nDuties Teaching of English in Key Stages 35 involved liaising with parents report writing finance management of the English Department dealing with school issues regarding discipline and class management invigilation of internal exams designing and implementing schemes of work exam preparation and provision TOEFL MICHIGANLower CAMBRIDGELower MICHIGANProficiency CAMBRIDGEProficiency IELTS\n Sept 20042005	English Teacher PagoulatouVlachou English School Athens Duties Teaching English to international mature students and professionals I have attended seminars in which I took part as a senior member regarding class management book evaluation exam preparation lesson planning and the production of schemes of work Sept 20042005	EditorProofreader Express Publishing Athens\nDuties Proofreading English teaching materials prior to their publishing Editing and translating governmental texts regarding teaching Producing CDROM teaching materials in English for the puspose of teaching at Key Stage 3 Sept20022004	English and Drama Teacher West Gate Community College Newcastle\nDuties Teaching English at KS3 and KS4\nI held extra curricula activities took part in moderating exams and invigilated internal exams prepared KS3 and KS4 students for their exams and coursework held a key role in students personal and social education attended seminars led the Literacy Strategy targeting year 9 pupils designed and implemented schemes of work attended and held departmental meetings 2001	Trainee English Teacher Thornaby School Stockton\nDuties Teaching English at KS3KS4 This teaching practice enabled me to use a plethora of teaching and learning techniques in order to support the teaching and learning of pupils from the full range of abilities Part of my time I used to enhance my own learning outside the classroom by devising and implementing schemes of work In addition to this I attended departmental and school meetings took part in the moderation of students coursework taught Drama and assisted in students preparation of drama coursework class registration 2001 Trainee English teacher SandhillView School\nDuties Teaching English at KS3KS4 This teaching practice enabled me to utilise differing teaching strategies to support the learning of students from the full range of abilities Part of my time I undertook pastoral and other professional duties In addition to these responsibilities I was able to contribute to extra curricula activities by helping with the school drama group and assisting on drama productions I participated on parents evenings and contributed in report writing attended departmental and school meetings modelled and implemented the Basic Skills unit in KS3 designed and implemented schemes of work prepared KS3 and KS4 classes for their exams taught Gifted and talented classes taught Special Needs classes and kept records of IEPs Summer 1998	Social Activities Organiser Warden St Clares International College Oxford Duties My duties as an SAO involved organising activities for the students trips sports and participating in them As a warden my duties involved taking care of the students under the colleges premises informing and applying the Health and Fire regulations Voluntary Teacher Felstead School Sunderland\nDuties I was assisting pupils with Special Needs to learn English on a voluntary basis Assistant Teacher Alexandra Sarri School Thebes Greece\nDuties Teaching and mentoring students with learning difficulties in English INSET 2006 Child Protection Sunderland City Council 20052006	Athens Greece Held seminars in EFL books and their evaluation provision of activities to aid learning 20022004	West Gate Community College Newcastle Literacy Planning and Provision at KS3 KS3 Literacy Training Moderation of Exams Behavioural Management Curriculum Overview Accellerated Learning 2001	St Anthonys Catholic School Sunderland KS23 Transfer Setting TargetsObjectives 2001	University of Sunderland I successfully delivered the National Literacy Framework to a group of trainee teachers at the University of Sunderland SKILLS IT Skills	Windows MS Office Access Excel Word Power Point Internet Foreign Languages French Intermediate Spanish Intermediate Greek Proficient Italian Fluent Sporting Interests Outdoor Activities including mountain walking and skiing\nHobbies Reading drawing playing chess swimming REFERENCES 1 Mr D Litchfield 2 Mrs H Horton\nHeadteacher Director of MA Studies\nCastle View School University of Sunderland\nCartwright Road School of Education and Lifelong Learning\nHylton Castle David Goldman Informatics Centre\nSunderland St Peters Sunderland\nSR5 3DX SR6 0DD Tel 0191 553 5533 Tel 0191 515 2369\nFax 0191 553 5537 Email helenhortonsunderlandacuk\n', NULL),
  (4, 'Potzner Andreas Marcus', 'test', 'test', '', '1525893542050.jpg', NULL, 'Curriculum Vitae\nPersonal Data\nSurname first name\nAddress\nTelephone\nMobil\nDate of birth\nPlace of birth\nMartial status\nEmail\nPotzner Andreas Marcus\nKastellstrae 1 65183 Wiesbaden Germany\n 49 0 611532 42 57\n 49 0 175 590 55 40\n08091978\nHanau Germany\nsingle\napotznerebssupplyinstituteor\nEducation\nsince 1004\nEuropean Business School ebs International University Schlo Reichartshausen\nOestrichWinkel Germany\nPostgraduate Assistant to the SVIEndowed Chair of Purchasing Logistics and Supply Chain\nManagement Supply Management Institute SMI\nStrive for the degree Dr rer pol April 2007\n1099 0504\nJohann Wolfgang GoetheUniversity Frankfurt Germany\nDegree in Business Administration DiplomKaufmann\nMajors Supply Chain Management  Marketing Business Informatics\nGrade 18 passed with distinction\nGrade of diploma theses 10\n0889  0698 Kopernikusschule Freigericht Germany\nAlevels high school graduation\nGrade 22\nResearch Focuses  Title of Dissertation\nFocuses\nInnovation management Supply chain management Aviation industry\nTitle\nTeaching\nsince 0306 Innovations along the Supply Chain\n0305 0605 Logistics  Supply Chain Management\n0305 0605 Innovation management\nInnovation Management along the Supply Chain of the European Aviation Industry\nLecture\nCase Studies\nSeminar papers\nPublications\n1005\nJahns Ch and Potzner A Innovationskooperationen in der Supply Chain\nIn Blickpunkt Einkauf  Logistik Forum Gelb GmbH October 2005\n0905\nJahns Ch and Potzner A Woher kommt eigentlich der Begriff Supply Chain Event\nManagement\nIn News und Trendletter Logistik Forum Gelb GmbH Vol 3 2005\n0705\nPotzner A Woher kommt eigentlich der Begriff BullwhipEffekt\nIn News und Trendletter Logistik Forum Gelb GmbH Vol 2 2005\n', NULL),
  (6, 'test', 'test', 'test', '', '1525959044513.jpg', NULL, 'Curriculum Vitae\nPersonal Data\nSurname first name\nAddress\nTelephone\nMobil\nDate of birth\nPlace of birth\nMartial status\nEmail\nPotzner Andreas Marcus\nKastellstrae 1 65183 Wiesbaden Germany\n 49 0 611532 42 57\n 49 0 175 590 55 40\n08091978\nHanau Germany\nsingle\napotznerebssupplyinstituteor\nEducation\nsince 1004\nEuropean Business School ebs International University Schlo Reichartshausen\nOestrichWinkel Germany\nPostgraduate Assistant to the SVIEndowed Chair of Purchasing Logistics and Supply Chain\nManagement Supply Management Institute SMI\nStrive for the degree Dr rer pol April 2007\n1099 0504\nJohann Wolfgang GoetheUniversity Frankfurt Germany\nDegree in Business Administration DiplomKaufmann\nMajors Supply Chain Management  Marketing Business Informatics\nGrade 18 passed with distinction\nGrade of diploma theses 10\n0889  0698 Kopernikusschule Freigericht Germany\nAlevels high school graduation\nGrade 22\nResearch Focuses  Title of Dissertation\nFocuses\nInnovation management Supply chain management Aviation industry\nTitle\nTeaching\nsince 0306 Innovations along the Supply Chain\n0305 0605 Logistics  Supply Chain Management\n0305 0605 Innovation management\nInnovation Management along the Supply Chain of the European Aviation Industry\nLecture\nCase Studies\nSeminar papers\nPublications\n1005\nJahns Ch and Potzner A Innovationskooperationen in der Supply Chain\nIn Blickpunkt Einkauf  Logistik Forum Gelb GmbH October 2005\n0905\nJahns Ch and Potzner A Woher kommt eigentlich der Begriff Supply Chain Event\nManagement\nIn News und Trendletter Logistik Forum Gelb GmbH Vol 3 2005\n0705\nPotzner A Woher kommt eigentlich der Begriff BullwhipEffekt\nIn News und Trendletter Logistik Forum Gelb GmbH Vol 2 2005\n', NULL),
  (8, 'Testing', 'tes@ddd', 'test', '', '1526063800675.jpg', NULL, 'yan\nGreguri Ortolan\nvia Palazzon 7 Riese Pio X\n31039 Treviso Italy\n39 340 5997839\n385 92 2201317\nivangortolan Ogmailcom\nCurriculum Vitae\nSuccess is the ability to go from failure to failure without\nlosing your enthusiasm  Winston Churchill\nInfo\nCitizenship Croatian\nBorn March 30th 1985 at Zagreb Croatia\nAddress Kutina Croatia\nLinkedIn httpitlinkedincomin\nAdditional JSalvadora 14 Ciglenica 44320\nDriving B\nLicense\nElance httpntrpelancecom\ngolvan\nBlog httpntrpivanblogspotcom\nSkype ivanntrp\nDesidered Employment and Current Skills\nSystem Administrator DBA Programmer Consultant\nOver the years thanks to my thirst for knowledge I have gained extensive experience in\ncomputer science ranging from operating systems to programming languages and platforms\nupon which the latter are based Along this path I have continued to improve my approach\nto problems always trying to implement optimal generalized and reusable solutions OOP\nDesign Patterns In some academic work opportunities Ive been able to demonstrate excellent\nteamwork skills and capability to collaborate with external groups Another virtue I possess is\nthe ability to solve almost any computer problem thanks to the excellent information gathering\nskills and the many years of experience in the compter science fheld\nComputer Skills\nLanguages JAVA JavaScript C C C SQL TSQL PHP ASPNET Jade HTML5 CSS3 LESS\nPYTHON LUA PERL BASH ATEX GLSL HLSL\nPlatforms Unix Linux Windows Windows Ser\nDB MySQL MSSQL MongoDB SSIS\nver IIS Apache Lighttpd Nginx\nNodejs Arduino\nTools VS2010 Eclipse IDE Netbeans IDE CMAKE Build system ANT Build system Git\nSVN Bzr Mercurial All NIX shell tools Direct3D 11 OpenGL 42 AJAX jQuery\nJSON Expressjs Socketio il8n Matlab Office Suite Photoshop Gimp AutoCad\nGoogle SketchUp Autodesk Maya\nExperience\nWorkin\n20092010 DBA System Admin Programmer Consultant GUS sr1 Venezia Italy\nWindows Server20082010 and MSSQL Server 20082010 administration creation and modi\nfication of TSQL stored procedures and SQL queries development of ASPNETC based\nwebsites development of C applications and general computer consultancy\n', NULL),
  (9, 'test', 'test@d', 'test', '', '1526065427880.jpg', NULL, 'CURRICULUM VITAE\nPROFILE\nLorem ipsum dolor sit amet consectetur adipisicing elit sed do eiusmod tem\nporincididunt utum labore eter dolore magna aliqua Ut enimad minimveniam\nquis nostrud exercitation ullconumlaborisnisiut aliquipexeacommodoconse\nEDUCATION\nMaster of Science in Electronics\nPolytechnic University of Moscow\nSep 2014Actually\nBachelor in Software Engineering\nPolytechnic University of Alabama\nNov 2010 Jun 2014\nWORK EXPERIENCE\nMARTIN SOLE\nGraphic Designer\nMay 2009Actually\nApr 2007  Mar 2009\nMay 2005 Aug 2007\nGraphic Designer\nConcept Design Studios LTD\nMedia Specialist\nMediaset Italia Rai Media\nBASIC INFORMATION\nChief Executive Officer\nEnvato Marketplaces Themeforest\nNationality\nBirthplace\nLiving in\nBirth Date\nGender\nCivil Status\nSWEDISH\nMALMO\nMUNICH\n150287\nMALE\nSINGLE\nCOMPUTER SKILLS\n1 Microsoft Office\nWORD\nEXCEL\nPOWERPOINT\nCONTACT INFORMATION\n2 Programming\nHTML5\nMob 015 69 5531 689\nFax 24 678 112 36725\nCSS3\nFOREIGN LANGUAGES\nfabiocimogmailcom\nmartinsolegmailcom\nCAE Certificate in Advanced English\nGrade A Points 92100\nLevel UpperIntermediate\n1 English\nVia Halit Kacanolli 342\nCopenhagen Denmark\nZMP Zentrale Mittelstufenprfung\nEuropian Framework Level C\nLevel Intermediate\n2 German\nSOCIAL NETWORKS\nfacebookcommartisole\nNo Diploma\nEveryday speaking and listening\nLevel Beginner\n3 Spanish\ntwittercommartinsoles\nSCAN QR CODE\nSKILLS  INTERESTS\nMusic\nMovies\nThe Internet\nMedia Productions\nTraveling Experiences\n Creative Thinking\n High selfesteem\n Good communication skills\n Able to respect deadlines\n Good at teamworking\nMY PORTFOLIO\nBEHANCE\nfabiocimo\nDRIBBLE\nfabiocimo\nLINKED IN\nfabiocimo\n', NULL),
  (10, 'coba', 'coba@dd', 'coba', '', '1526065276403.jpg', NULL, 'SR\nSara Reynolds\n940 7466350 sarareynoldsgmailcom Chicago IL\nProfile\nConsectetur adipisicing elit sed do eiusmod tempor incididunt ut labore et dolore\nmagna aliq ua Ut enim ad minim veniam quis nostrud exercitation ullamco\nlaboris nisi ut aliquip ex ea commodo consequat Duis aute irure dolor in\nreprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur\nProfessional Skills\nProject Management O\nSEO Marketing\nContent Development O\nProject Management O\nProject Management\nSEO Marketing\nExperience\nContent Developer Acme Corporation\nMarch 2013 Present  Virtual Position\nTechnical Skills\nConsectetur adipisicing elit sed do eiusmod tempor incididunt ut labore et\ndolore magna aliq ua\nConsectetur adipisicing elit sed do eiusmod tempor incididunt ut labore et\ndolore magna aliq ua\nConsectetur adipisicing elit sed do eiusmod tempor incididunt ut labore et\ndolore magna aliq ua\nProject Management o\nSEO Marketing\nContent Development O\nSEO Marketing\nContent Development \nProject Management O\nContent Developer Acme Corporation\nMarch 2013  Present Virtual Position\nAdvertising\nProject Management O\nSEO Marketing\nContent Development eO\nProject Management O\nSEO Marketing\nContent Development \nProject Management O\nConsectetur adipisicing elit sed do eiusmod tempor incididunt ut labore et\ndolore magna aliq ua\nConsectetur adipisicing elit sed do eiusmod tempor incididunt ut labore et\ndolore magna aliq ua\nConsectetur adipisicing elit sed do eiusmod tempor incididunt ut labore et\ndolore magna aliq ua\nContent Developer Acme Corporation\nMarch 2013 Present Virtual Position\nSocial Media\nProject Management O\nSEO Marketing\nContent Development \nProject Management O\nConsectetur adipisicing elit sed do eiusmod tempor incididunt ut labore et\ndolore magna aliq ua\nConsectetur adipisicing elit sed do eiusmod tempor incididunt ut labore et\ndolore magna aliq ua\nConsectetur adipisicing elit sed do eiusmod tempor incididunt ut labore et\ndolore magna aliq ua\nContent Developer Acme Corporation\nMarch 2013 Present Virtual Position\nEducation\nUniversity of llinois Chicago\nEnglish\nConsectetur adipisicing elit sed do eiusmod tempor incididunt ut labore et\ndolore magna aliq ua\n806509\n', NULL),
  (11, 'arief Wijaya Putra', 'petrik@gmail.com', '$2b$10$1VpWpK6.e5x..B2wFFURTuaC68DCwAolkmIImSR0tjmkZe5Dc.Oq2', 'test', '1526139994350.png', '1526137436612.jpg', 'IMAGINATION\n', 'PROVINSI JAWA BARAT\nKOTA CIMAHI\nNIK\n3217061804870007\nARIEF WIJAYA PUTRA\nNama\nTempat Igl Lahir BANDUNG 1804 1987\nJenis kelamin\nAlamat   JE AMIR MAHMUD GG\nLAKLEAKI\nGol Darah\nSIRNAGALIH NO 62\n005006\nRTIRW\nKelDesa\nKecamatan\nGBABAT\nISLAM\nPELAJARMAHASISWA\nCIMAHI UTARA\nAgama\nStatus Perkawinan BELUM KAWIN\nPekerjaan\nKewarganegaraanWN\nBerlaku Hingga SEUMUR HIDUP\n\nKOTA CIMAHI\n17112015\n'),
  (15, 'tang', 'tang@611', '$2b$10$54VDwh0GOFEloIyiohU.UOoBTYBq387B0SC5yBA361McU4OMO049i', NULL, '1526067197983.pdf', NULL, 'Florida State University Master of Science in Finance Current GPA400 May 2015 Bachelor of Science in Finance and Real Estate May 2014 Bachelor of Science in Applied Economics May 2014  Minor in English  Minor in Free Enterprise  Ethics State Board of Administration of Florida Tallahassee FL Private Equity Intern May 2014  Present  Assist in due diligence analysis of new investments including buyouts venture capital growth equity secondary sales and coinvestments  Gather data and update Microsoft Excel models based on performance of private equity funds  Maintain organization of connections presentations and valuations of firms in portfolio  Publish FSBA Private Equity weekly update booklet tracking investment process calendar meeting notes fund overviews and deal log FSU New Student  Family Programs Tallahassee FL Administrative Assitant January 2013  May 2014  Implemented efficient checkin process for 16000 family members and students  Managed and processed incoming payments of high volume  Coordinated across all executive departments of FSU for successful orientation presentations  Interacted with incoming students and their family members regarding transitions FSU New Student  Family Programs Tallahassee FL Orientation Leader November 2011  January 2013  Directed welcome presentations in order to acclimate 150 new students  Provided extensive knowledge and resources to generate a comfortable transitional environment for new students and their families  Collaborated with 36 other Orientation Leaders in order to meet the goals of the professional staff Urban Land Institute May 2014  Present  Attend summits and meetings regarding how Real Estate can better communities The International Council of Shopping Centers October 2013  Present  Student exposure to deal making events for commercial Real Estate industry FSU Real Estate Society Director of Women in Real Estate January 2013  Present  Create a peer to peer mentorship program for professional students  Develop professional goals through presentations  Former Tresurer organized dues and made payments for success of society Alpha Chi Omega Alumnae Member October 2011  Present  Beta Eta Chapter Florida State University Memberships Experience Tallahassee FL Education Sydney Krier 3260 Hidden Lake Dr E Jacksonville FL 32216 skk10cmyfsuedu 904 4513844 Perspectives on Free Enterprise Relevant Coursework Bloomberg Certification In Process LicensingImportant Skills Advanced Microsoft Excel Econometrics Modeling Applied Econometrics in Finance Problems in Financial Management ARGUS Valuation Certification Real Estate Finance and Investments ', NULL),
  (16, 'Demo Member', 'demo@gmail.com', '$2b$10$Kz1wwsMKnWK.OnR1hkxtNeyZ/RkKynJSdo0CixPAwnvjZxXW3Ric6', NULL, '1526101774599.jpg', NULL, 'PROVINSI JAWA BARAT\nKOTA CIMAHI\nNIK\n3217061804870007\nARIEF WIJAYA PUTRA\nNama\nTempat Igl Lahir BANDUNG 1804 1987\nJenis kelamin\nAlamat   JE AMIR MAHMUD GG\nLAKLEAKI\nGol Darah\nSIRNAGALIH NO 62\n005006\nRTIRW\nKelDesa\nKecamatan\nGBABAT\nISLAM\nPELAJARMAHASISWA\nCIMAHI UTARA\nAgama\nStatus Perkawinan BELUM KAWIN\nPekerjaan\nKewarganegaraanWN\nBerlaku Hingga SEUMUR HIDUP\n\nKOTA CIMAHI\n17112015\n', NULL),
  (17, 'Budi', 'budi@gmail.com', '$2b$10$Kz1wwsMKnWK.OnR1hkxtNeyZ/RkKynJSdo0CixPAwnvjZxXW3Ric6', NULL, '1526111952152.png', NULL, 'yan\nGreguri Ortolan\nvia Palazzon 7 Riese Pio X\n31039 Treviso Italy\n39 340 5997839\n385 92 2201317\nivangortolan Ogmailcom\nCurriculum Vitae\nSuccess is the ability to go from failure to failure without\nlosing your enthusiasmWinston Churchill\nInfo\nCitizenship Croatian\nBorn March 30th 1985 at Zagreb Croatia\nAddress Kutina Croatia\nLinkedIn httpitlinkedincomin\nAdditional JSalvadora 14 Ciglenica 44320\nDriving B\nLicense\nElance httpntrpelancecom\ngolvan\nBlog httpntrpivanblogspotcom\nSkype ivanntrp\nDesidered Employment and Current Skills\nSystem Administrator DBA Programmer Consultant\nOver the years thanks to my thirst for knowledge I have gained extensive experience in\ncomputer science ranging from operating systems to programming languages and platforms\nupon which the latter are based Along this path I have continued to improve my approach\nto problems always trying to implement optimal generalized and reusable solutions OOP\nDesign Patterns In some academic work opportunities Ive been able to demonstrate excellent\nteamwork skills and capability to collaborate with external groups Another virtue I possess is\nthe ability to solve almost any computer problem thanks to the excellent information gathering\nskills and the many years of experience in the compter science fheld\nComputer Skills\nLanguages JAVA JavaScript C C C SQL TSQL PHP ASPNET Jade HTML5 CSS3 LESS\nPYTHON LUA PERL BASH ATEX GLSL HLSL\nPlatforms Unix Linux Windows Windows Ser\nDB MySQL MSSQL MongoDB SSIS\nver IIS Apache Lighttpd Nginx\nNodejs Arduino\nTools VS2010 Eclipse IDE Netbeans IDE CMAKE Build system ANT Build system Git\nSVN Bzr Mercurial All NIX shell tools Direct3D 11 OpenGL 42 AJAX jQuery\nJSON Expressjs Socketio il8n Matlab Office Suite Photoshop Gimp AutoCad\nGoogle SketchUp Autodesk Maya\nExperience\nWorkin\n20092010 DBA System Admin Programmer Consultant GUS sr1 Venezia Italy\nWindows Server20082010 and MSSQL Server 20082010 administration creation and modi\nfication of TSQL stored procedures and SQL queries development of ASPNETC based\nwebsites development of C applications and general computer consultancy\n', NULL),
  (18, 'andi', 'andi@gmail.com', '$2b$10$Kz1wwsMKnWK.OnR1hkxtNeyZ/RkKynJSdo0CixPAwnvjZxXW3Ric6', NULL, '1526111965232.jpg', NULL, 'CURRICULUM VITAE\nPERSONAL INFORMATION Palmina Mancino\n19 Monle Circeo rd Rome RM Italy Postoode 00141\n39 0560863147 39 3289456979\nSkype paminamancino\nSex Female Date of brth 12 April 1981  Natonality Italian\nPharmaceubical chemist ipharmacist\nJOB APPLIED FOR\nWORK EXPERIENCE\nSeptember 2006 March 2007 Stage\nRonchi Pharmacy Snc Dr Cantarella e Dr Marteli\n2 Ronchi Square 00177 Rome Italy\nSixmonth intenship done at University\nEDUCATION AND TRAINING\nMember of the Order of Pharmacists in Rome\n15 Alessandro Torlonia rd 00161  Rome Italy\nJanuary 2013\nNovember 2000 October 2012 Bachelor of Pharmaceutcal Chemistry and\nTechnology\nFacuity of Pharmacy and Medicine\nLa Sapienza University Rome Italy\naddress analytical chemistry\nthesis of Bachelor in Dnamic HPLC dromatograph\no ganic chemistry Prlessor Claudio Vilan\nSeplember 1995July 2000 Diploma in Accounting and Commercial Expert Programmen\nState Techical Institute Leopoldo Pila 21V Veneto rd 86100 Campobasso Italy\nItalian language\nForeign language English and French\nDecember 2007\nEuropean Computer Driving Licence ECDL\nLa Sapienza University Rome Italy\nPage 1 12\n', NULL),
  (19, 'yeni', 'yeni@gmail.com', '$2b$10$Kz1wwsMKnWK.OnR1hkxtNeyZ/RkKynJSdo0CixPAwnvjZxXW3Ric6', NULL, '1526111977173.jpg', NULL, 'JeanMarc IMELE\n37 rue de lOrme Saint Edme\n95130 FRANCONVILLE\nPhone 330134140691\nMobile 330644278821\nEmail imelejmgmailcom\nBlog wwwjim3dblogspotcom\nBom 03051989 23 years at PlessisBouchard\nDriving license\nFRANCOITALIAN NATIONALITY\nFORMATION\nraduate in 3D Animation\nLISAA LInstitut Suprieur des Arts Appliqus\n20092012\n1st year of TUD Technical University Degree Marketing Techniques\nUniversit de CergyPontoise\n20082009\nHighschool Diploma emphasing on Economic and Spanish\nwith Honors\nLyce Gnral et Technologique dErmont\n20072008\nPROFESSIONAL EXPERIENCES\nJuly 2012\nMarch 2012\nDecember 2011\nJanuaryMay 2011Rigger Animator on the student short 3D animation film\nRigging  Setup quadrupedes and props SupamonkS Studio\nRigging  Setup on  Lherbier  a 3D animation film LISAA\nRigger on the student short 3D animation film  Pingouins3 \n CourtCircuit  screened at the  Cairefour de lAnimation 2011 \nSKILLS\nEnglish  college level\nSpanish  college level\nItalian  read and write especially the Neapolitan dialect\nLanguages\nSoftwares\nAutodesk Maya Adobe After Effects  Photoshop  Premiere\nHoBBIES\nSports\nSwimming 5 years football 13 years FFF mountain bike\nVarious\nCinema music sport reading\n', NULL),
  (20, 'pabou', 'pabou@gmail.com', '$2b$10$Kz1wwsMKnWK.OnR1hkxtNeyZ/RkKynJSdo0CixPAwnvjZxXW3Ric6', NULL, '1526111986461.png', NULL, 'PERSONAL DETAILS\nName\nPlace and Date of Birth\nSex\nAddress\nMarital Status\nTelephone Number\nEmail\nAnnisa Khairani Haningsih\nSurakarta 19th December 1989\nFemale\nJalan Srinarendro No 18 Solo\nSingle\n0271713130085647183000\nmillykhahotmailcom\nEDUCATION\nJanuary 2012\nBachelor Degree of Economic at Universitas Sebelas Maret\nMajor\nGPA\nFinished Senior Highschool SMAN 7 Surakarta\nFinished Junior Highschool SLTP N 9 Surakarta\nFinished Primary School SD Tamirul Islam Surakarta\nManagement\n319\n 2007\n 2004\n 2001\nOTHER SKILLS\nMicrosoft Office\n Internet literacy\n Active English with TOEFL ITP Score\n553\nWORKING EXPERIENCE\nEnglish Teacher at Aisyiyah ABA Baron Kindergarten\nInternship at PT Danar Hadi Export Division as Marketing Staff\nAcer Redemption Staff at APKOMINDO Expo Solo\nFreelance at Rp7 Communication and Advertising\n2011 Present\nFebruari 2011\n2010 Present\n 20102011\nORGANISATIONAL EXPERIENCE\nDesember 2010\n 20092010\n 20082009\n2007 2010\nProducer of PENTAS PANAS Teater Gadhang FE UNS\nSecretary of Teater Gadhang FE UNS\nProduction staff of Teater Gadhang FE UNS\nTutor of Nusa Indah illiteracy learning group\n', NULL),
  (21, 'testing', 'testing@gmail.com', '$2b$10$sD9yUAZ6FJE7GqywEmDZ/u6TLwFP9gBV5DS3a8p/aNHcQV27VOxDi', NULL, '1526115431607.jpg', NULL, 'PROFILE\nI am an experienced social media manager seeking a fulltime\nposition in the field of social media and marketing communications\nwhere l can apply my knowledge and skills for continuous\nimprovement\nEXPERIENCE\nSOCIAL MEDIA PRODUCER\nNEW MEDIA COMPANY  FEB 2013DEC 2014\n Managed social media accounts and created social media for\ndaily postings\n Increased social media following and clicks by 200\nMAXENE\nWOOLFOLK\nCOMMUNICATIONS INTERN\nRICH MEDIA INTERACTIVE 1 APR 2012  JAN 2013\n Developed a social media strategy to increase the following of\nthe company website\nSpearheaded a viral campaign for one of the companys new\nproducts\nSOCIAL MEDIA MANAGER\nEDUCATION\nBACHELOR OF ARTS MAJOR IN COMMUNICATION\nUNIVERSITY OF DUNDEE 2009 2013\nGPA 39\nCONTACT\n44 7700 9530\nHELLOMAXENEWOOLFOLKCOM\nW WW MAXENEWOOLFOLKCOM\nSKILLS\n SEO and Google Analytics\n Social media strategy\n Marketing\n Corporate blogging\n Project management\n Layout design\n Photo editing\n Market research\nWeb content development\nSOCIAL MEDIA\n Copywriting\nTWITTER MAXENEWOOLFOLK\nFACEBOOK MAXENEWOOLFOLK\nINSTAGRAMMAXENEWOOLFOLK\nAWARDS\nNEW MEDIA COMPANY\nMOST OUTSTANDING SOCIAL MEDIA PRODUCER\nDEC 2015\nRICH MEDIA INTERACTIVE\nBEST INTERN\nJAN 2014\n', NULL),
  (22, 'dani', 'dani@gmail.com', '$2b$10$Kz1wwsMKnWK.OnR1hkxtNeyZ/RkKynJSdo0CixPAwnvjZxXW3Ric6', NULL, '1526116698476.png', NULL, 'Summary\nAbout Im a hardworking and dedicated person love to explore always have\nbig hunger for naw knowledgeI lowa to inspire other paople around me and get\nnspired by themOptimist for lite\nZodiac Sign Aquarius\nTUNG LAM\nInterestsi Gultar Street photography Carting RowingRending Blogging\nObjectivest Applying for Androld Nobile Developer\nNGUYEN\nWebMobile Developer\nSofia Buigaria\n5 github comtinguyencom\nin inkedincomintunglamnguyen\nWork History\nMay 2015 Android Develaper\nPresent MentorMate Bulgaria\nMar 2014 Web Developer\nJun 2014 Barely5th Design Studio\nIve been morking on a col startup about fnancial education\nSkills\nIts now on prhate beta stage and was featured at several\nAndroid Development\nhttpilbetallstcomstertupslgrowbscon\nhttplstartupdopecomgrowbacoiew\nhttpwwwsuparbcrewcomgrowbaconbeachyourkidsabour\n2 weeks study experience at\ninvestmentssavingsandloan\nDevelopmant study at MenberMabe\nAcademy\nHybrid Mobile Development\nAug 2013 Sftware Developer\nFeb 2014430 PM Ltd\n4 months mbxed professional and\nstudy experience on Hybrid Mobile\nDevelopmant using\nIve been working with IBM WebSphere Message Broker It works\nas an Intsgration Engine betwsen different hospitals in UKmy\njob was to develop the interfaces eeded for manipulating the\neschanged messages between ell the applications from the\nhospitals\nAnguiarjs\nlonic\nOct 2012\nJul 2013\nJunior Java Developer\nBouygues Construction IT Center in Vietnam\nIve been working on two projects during this time\nObjectiveC and ios\nDevelopment\nESAW During this project Ihed to upgrade Its old version It w\nwritten with java Serviet and JSP with no framework support at\nal I was the project owneranalyzer working with 2 of my\ncolesgues on the team my job mas to integrate the new desigr\nfusion of al the databases to work in one sppication and\nimplementing new features by the costumers desires\n2 weeks study experience t\nTelerikAcademy\nWindows Universal\nDevelopment\nGroupieThis project is one of our company tools the working\ncode was too old so we decided to rewrite the whole project\nfrom the scratch We used Struts 2 framework for this purpose\nOur team was consisted of 3 people I was working at the lower\nlevel of tha project providing the API to othar devalepers 5\nthey can handle the GUL and use my AP to load the data to the\napplication\n2 weeks study experience ot\nJavaJavaEE Technologies\n1 year professional skil working on\nvarious technology frameworks and\nprogramming concepts ske\nEducation\nOOP Princ ples\nDesign Pettems\nSOLID\nDataStructures and Algorithms\nStruts 2\nSpring MWC\nHibemte\nNov 2014 Academic\nFeb 2015 MentorMate Academy\nOct 2013 Academic\nNov 2014 TelerikAcademy\nAug 2008\nAug 2012\nBachelor of Engineering BEng\nTechnical University Sofia\n', NULL),
  (23, 'beni', 'beni@gmail.com', '$2b$10$Kz1wwsMKnWK.OnR1hkxtNeyZ/RkKynJSdo0CixPAwnvjZxXW3Ric6', NULL, '1526116707389.jpg', NULL, 'lin work Experience\nUVUX Designer Academy\nAN 2013 DEC 2013\nLorem ipsum dolor sit amet consectetur adipiscing elt sed do eusmod tempo\nncididunt ut labore st dolore magna aliqua\nar\nCreative Director deviserweb\nLerem ipsurn dolor st net consecteur\nergeltsed de eurod tempor\nLorem psum dolor st amet\nconsectetur adioiscing elt sed do\neusmod tempor incieidunt ut\nlabore et dolore magna aliqua Ld\ndo eusmod tempor incididunt ut\nlabore et doiore magna aliqua\nncididunt ut labore et dolore magna alqua\nGraphics Designer creative Wold\nLonem ipsum dolor sit amet conpectetur adipiscing elt sed do elusmod tempor\nncididunt ut labore et dolore magna alqua\n 1113334444\nmobile\n1213233494\nwork\nEducation\nArtMultimedia goxford University\nAN 2013DEC 2013\nLonem psum dolor st amet consectetur adipiscing eit sed do elusmod tempor\nnoididunt ut labore et dolore magna alqua\nmailalrayhancom\nwork\nPost Graduation gorem\nJAN 2013DEC 2013\nLorem Ipsum dolor sit amet consectetur adpiscing elt sed do elusmad tempor\nncididunt ut labore et dolore magna alqua\n\n24 Golden Tower and foor\n24 Colden Tower Cied tool\nAmborkhana Sylhet\nSYL 3RFS7W\nTTMP Degree creative School\nJAN 2013DEC 2013\nLorem ipsum dolor sit amet consectetur adipscing elit sed do elusmod tempor\nhoididunt ut labore et dolare magna alqua\nProfessional Sklls\nAdobe Photoshop\nHTML\ncss\nInterestes\nPHP\nAVA\nSQL\nwwwdribblecomrtralrayhan\n', NULL),
  (24, 'sandy', 'sandy@gmail.com', '$2b$10$Kz1wwsMKnWK.OnR1hkxtNeyZ/RkKynJSdo0CixPAwnvjZxXW3Ric6', NULL, '1526116715888.jpg', NULL, 'JOHNNY\nALEX SMITH\nSenior Website\nDesigner\nHome 555 5555555\nCell 555 1234321\nEmail kukookcomgmailcom\nWebsite wwwkukookcom\nAddress Street 2 Hawaii\nTwitter KukookResumes\nWORK EXPERIENCE\nLEAD WEB DESIGNER Kukook International 2013  CURRENT\nPrimary responsibilities include User Interface Designs utilizing Photoshop lllustrator Dreamweaver HTML CSS and JQuery\nSignificant amount of Browser Compatibility Testing and debugging Mobile website development including responsive web\ndesign techniques for compatibility on both mobile phones and tablets Extensive use of Content Management Systems\nincluding Wordpress and Drupal Ecommerce configurations setups and designs utilizing enterprisesized software and\ncontent management systems\nFREELANCE DESIGN CONSULTANT Kukook LLC 2011 CURRENT\nDesigned developed and maintain an ecommerce website for a local retailer This project started with an initial completion\ndate but ended up staying hired part time for maintenance and product listings in my spare time\nEDUCATION\nMASTERS IN GRAPHIC ARTS Kukook State University May 2013\nFocus on typography and color theory web and media design in the modern age\nBACHELOR OF ARTS IN GRAPHIC DESIGN Kukook State University May 2013\nFocus on graphic design software photo manipulation and web development practices\nPROFESSIONAL SKILLS\nAdobe Photoshop\nAdobe llustrator\nDreamweaver\nHTML  CSS\nBranding\nContent Management\nJavascript\njQuery\nABOUT ME\nMy name is Johnny a Web Developer and\nGraphic Designer I am looking to obtain a\nposition within a challenging and dynamic\nenvironment that will enable me to use my\nstrong organizational skills\neducational background\nand technical expertise\nThank you for your\nconsideration in this\nopportunity and I look\nforward to hearing from you\n', NULL),
  (25, 'sherni', 'sherni@gmail.com', '$2b$10$Kz1wwsMKnWK.OnR1hkxtNeyZ/RkKynJSdo0CixPAwnvjZxXW3Ric6', NULL, '1526116730527.png', NULL, 'Summary\nHey there My names Chris Im your local linux\nenthusiast web developer cyclist travel bug anime fan\nand serial entrepreneur addicted to making cool stuff with\nawesome people\nCHRIS BOLTON\nSenior Software Engineer\nLos Angeles CA\nogchrisboltonme\n157873660\nSkills\nIve been working with various companies and startups\nover the past four years and am an experienced fullstack\nweb developer Ive ta ken on roles that include quality\nassurance engineering frontend web development mobile\ndevelopment backend database work and linux server\nedministration\nEmberjS\nIm always on the lookout for awesome workplaces with\nstrong engneeringdriven culture to connect with and\npossibly be a part of and help grow I leam very quickly\nand am always excited for whatever comes my way\nAngularj5\nHTMLSCSS3\nWork History\nLinux Server Administration\nDec 2013Lead Developer\npresentEatt\nLaunching my own side project while freelancing in an industry\nIm passianste about with awesome teammates\nhappen\nJavascript\nMaking it\nRuby on Rails\nec 2012\nSoftware Engineer\nRuby\nHelped add some engineering power to the team during the\ncompanys push for their new GraphEfect 30 platform\nun 2012Frontend Engineer\nec 2012\nSurf Air\nBrought aboard as the second engineering hire and responsible\nfor all frontend development of Surf Airs website and mobile\napps\nct 2011 Quality Engineer\nMay 2012 mFoundry\nWas brought on board to help lead automation and load\nbalancing efforts on mFoundrys mobile platform Also handled\nlot of the server management work and some of the lowenleve\ndebugging issues required in the Q4 department\nPortfolio\nat Heping people lead healthier Ives with complete personalized meal\nplans lusheven herpluappcomA highend real estate marketplace\n', NULL),
  (26, 'kevin', 'kevin@gmail.com', '$2b$10$Kz1wwsMKnWK.OnR1hkxtNeyZ/RkKynJSdo0CixPAwnvjZxXW3Ric6', NULL, '1526116739168.png', NULL, 'BRYCE HAMMOND\nIOS DEVELOPERSOFTWARE WIZARD\nDenver cO\nIntent\nSkills\nAn Apple Design Averd winning developer  wart to create exceptional\napps balancing innovative interaction and visual design I have\nextraordinary attertion to detail and create scalable and elegant\nObjectiveC  Swift \nCocoa\nWork History\n0s and OS X Development\nwith ObjectiveC Swift and\nCocoaCocoaTouch\nFeb 2011Lead Programmer Magician\npresent s\nMobile Development lead and head developer for the CIC\nolowing apps\neDiscovery Assistant app and Rals APO\nWis a Voy app and Rails AP\nOpto created framework so client could create\nnew exercises via configuration files\nFeedback Sports app and Rails API\nePantry ePantry now maintains it previously 5\nstar rated\nSnowaoom and 5SCW app and Rals AP\nCOPD\nEnterprise apps for Stanford University and\nLarge scale and high\navailability system\nexperience in C and C\nMagic\nPocket Consultant Guide\nspecialicing in card and coin\nmagi with eriginal effects\ncrested that integrate\ntechnology\nOthers yet to b released\n Built and maintained backend in C for\nJscobsen and MAI Network\nParfomed the occasional and somstimes original\nmagi trick for coleagues and clients\nRuby Rails\ncontrol system to Mercurial and then to Git\nul 2007Software Engineer\nFeb 2011 Wall Street on Demand Markit on Demand\nRuby and Rulby on Rails\napplication development\nTeam lead architect and lead developer for the team\nresponsible for creating the following iPhonePad\nVersion Contro\nRnancial Times\nFinancial Times iPad Edition won Apple Design\nExperience with Git\nSubversion CVS Mercurial\nv sual SourceSafe lyep\nsaid t and Rational\nward in 2010\nTD UK NatwestRBS\nOther apps that have gone way downhill since I left\nl need a beer\nC  NET\nDaily use of Objective C C Perl Ruby and SOL\nWork on high avslablity highly scalable Windows\nbased backend serwer systems that service most\nevery major financial website CNBC Scottrade\nAmeritrade Schwab etc\nDesigned and coded a tool to streamline XML feed\nIntegration drastically reducing the time needed to\nExperience with NET MVC\nWebforms Console\nWPF applicationsand\nCreated a tool to automatically transition the Viual\nSourceSafe version control system to Subversion\nwhile maintaining version istory\nDevelop and maintain systems handing thousands of\nantainn Control syst eransition the Vsdsclications anaoplictians\n', NULL),
  (27, 'martin', 'martin@gmail.com', '$2b$10$Kz1wwsMKnWK.OnR1hkxtNeyZ/RkKynJSdo0CixPAwnvjZxXW3Ric6', NULL, '1526116747015.jpg', NULL, 'Qiesto Eliano\nPHP WORDPRESS PROGRAMMER\nNapoli revenue Elsadore str 23 Mob 946 31586973wwwelianowebsitecom elianomailcom\nLorem ipsum dolor sit amet consectetuer adipiscing elit Maecenas\nporttitor congue massa Fusce est Vivamus a tellus\nFusce posuere magna sed pulvinar ultricies purus lectus malesuada libero\nsit amet commodo magna eros quis urna Nunc viverra imperdiet enim\nCareer Objective\nDynamic Data Manager\nBig wordpress Project\nExperience\n2003 2005\nLorem ipsum dolor sit amet consectetuer adipiscing elit\nMaecenas porttitor congue massa Fusce posuere magna\npulvinar ultricies purus lectus malesuada libero sit amet\ncommodo magna eros quis urna\nSenior Hjax Programmer\nProject For very Big company\n2005 Present\nLorem ipsum dolor sit amet consectetuer adipiscing eliMaecenas\nFusce posuere magna sed pulvinar ultricies purus libero\namet commodo magna eros quis urna Nunc viverra imperdiet\n\ne Fusce est Vivamus a tellus\nPHP Language\nLorem ipsum dolor sit amet consectetuer adipiscing elit Maecenas\nporttitor congue massa Fusce posuere magna sed pulvinar ultricies purus\nlectus malesuada libero sit amet commodo magna eros quis urna\nTechnical Skills\nAjax Language\nLorem ipsum dolor sit amet consectetuer adipiscing elit Maecenas\nporttitor congue massa Fusce posuere magna sed pulvinar ultricies purus\nlectus malesuada libero sit amet commodo magna eros quis urna\nNunc viverra imperdiet enim Fusce est Vivamus a tellus\nHTML5\nLorem ipsum dolor sit amet consectetuer adipiscing elit Maecenas\nporttitor congue massa Fusce posuere magna sed pulvinar ultricies purus\nlectus malesuada libero sit amet commodo magna eros quis urna\nNunc viverra imperdiet enim Fusce est Vivamus a tellus\nEducation Very Big University\nDiplomats Web Programing  SEO Optimization\nLorem ipsum dolor sit amet consectetuer adipiscing elit Maecenas\nporttitor congue massa Fusce posuere magna sed pulvinar ultricies\npurus lectus malesuada libero sit amet\nFor Cl\nCom\n', NULL),
  (28, 'surya', 'surya@gmail.com', '$2b$10$Kz1wwsMKnWK.OnR1hkxtNeyZ/RkKynJSdo0CixPAwnvjZxXW3Ric6', NULL, '1526116755260.png', NULL, 'SHEEHAN ALAM\nWork History\nAcademic Papers\nProgrammer Analyst\nAmerican Express\nDeveloping corporate payment biling systems\nAgile Software Methods\nApplied To The Deployment\naf a Content Management\nSep 2005\nTechnical Marketing Engineer\nJan 2008 httpwwwintelcom\nproduct famly\nPDF\nPentium\nCore 2 Quad\nJan 2005 Software Engineer\nSep 2007 htwwwintercom\nThesis documenting the\nsage of agile software\n3D mechanical modeling tool\nChip design repository\nPower delivery and analysis tools\nBlogs\nThe Fratboy\nInvestorPersonal finance\nand investing tips for folks in\nMay 2003\nSoftware Engineer\nttpwwwwhoneyweWcom\nDeveloped charting component for vibration analysis\ntheir twenties\nPerfomed business analysis on standardiaing\nTechnology and linux tips\nSummary\nam currently availsble for\ncorporate level inventory system\nEducation\nBachelor of Science\n2007\nGo Sun Devils\nCharitable\nEvents\nBeards fer Bangladesh\nOne of the original members\nSkills\nraising money for orphans\nMarch of\nAndersen Junior High School\nMFC GCC STL\nWeb Design\nAAX JavaScript CSS HTML Dreamweaver Frontpage Drupal WordPress\nDatabase\nA concept from 2007 to\non me\nitem price and proximity\nConsulting\nASU Polytechnic\nSQL Server BM DB2 MySQL PostgreSOL\n', NULL),
  (29, 'Louis', 'louis@gmail.com', '$2b$10$Kz1wwsMKnWK.OnR1hkxtNeyZ/RkKynJSdo0CixPAwnvjZxXW3Ric6', NULL, '1526116762554.png', NULL, 'Summary\nHello World\nOMAR RAMOS\nESPINOSA\nI am a passionate programmer who loves to be in the\name industryI been involved in multiple production in\nthis awesome industry with amazing teams\nGuadalajara Area Mexico Mx 14\nomer vodevgmailcom\n3338159456\nin inkedin comupubromar ramos\naspinosa3657b868\nSkills\nWork History\nul 2013Programmer\n2014 Larva Game Studios\nMay 2012 Videogame Developer\nul 2013Fraktalia Studios\nGamer\nGame Development on smartphones and tablets doing\ngameplay and social integration\nSelftaught person\nSep 2011 Junior Programmer Mobile Games Area\nMay 2012 Kaxan Media Group  Kaxan Games\nGame Development on smartphones and tablets\nLeader\nJan 201Junior Quality Assurance Testing\nMay 2012Kaxan Media GroupKaxan Games\nGame Programming\nGama is tesbed to chack that doeant contain bugs gameplay\nemorsvisual errors etc\nGame Development\nEducation\nan 2010 Student\nan 2012 Universidad de Artes Digitales\nMath\nA Game Devalopment Engineer is a specialist to assist in the\nprocess of developing entertainment technology it makes useof\nmathematicel know edge for the application of artificial\nIntelligence and graphics processing on consoles computers\nGameplay\nmobile devices\nUnity3D\nSpirits Of Spring IOs Unity3D\nUnreal Engine 3\nChiwatin a young Native boy stranded in the northern landscapes of Permanent\nWinter is haunted by oant crows To owercome their cruelty Chiwatin goes onan\nnspiring quest to restore Springtime and fied the courage to move on\nGameplay\nSPRING\nLaunch Traler\n', NULL);
  INSERT INTO `hunters` (`id`, `name`, `email`, `password`, `bio`, `cv`, `ktp`, `cv_raw`, `ktp_raw`) VALUES
  (30, 'kamal', 'kamal@gmail.com', '$2b$10$Kz1wwsMKnWK.OnR1hkxtNeyZ/RkKynJSdo0CixPAwnvjZxXW3Ric6', NULL, '1526116770941.jpg', NULL, 'ANTREAS ANTONIOU\nCOMPUTER ENGINEERDATA SCIENTIST\nSummary\nSkills\nMy nae i Antreas Antoniau1 ams very passicnate about research in\nData Wsulisation Skills\nuch have always been top of my tlas and then chose to becem an\nungineer Eventuaty i graduated as a computer systems engineer which\n degree that composed of half electronand hat computer science\nmodules which enabled me to tackle probiems iisolving both scences\nAfter ar excallert third year in which  Q\nmanaged to tnish with 16 4 trong 2 1 which was 0224 off from Embedded Systems\nbeing a first Ater being expased to research at my fial yea projectEngineering and\nmatplotib R and\nugpkx2pkt 3D\nt 86 in my final dissertation\nbedded systems course and summer rosearch Iemship in\nProgramming\nhe eg Becase ed my love far robots afid the facz that they\nan extremey mutti disciplined subject wrech rworves all the subjects\nove I decided to become an expert inubtics and artificial neligenc\nRobets hve thu potential to trasfore our world and lves Dy eplering\nEmbedded Systems\nEngiveerig Experierce s\noceans improving our cities and lives or even toking us up to the\nstars I nant to be part of thaeffert lo help advance wierce hurmanity\nand generaily our world through research in robotics\nprogr 5mming drectly on\nhardware and experience in\nprogramming low level\npistformms such as Arguing\nasplberry PP\nmicrocontroilersand Am\nhosed microcontrolle\nElectronics\nEngineering\nWork History\nSaftware Programmer\nLANCASTER UNIVERSITY\nt was selected by s large amount of students to be\nsotmane engineering Ptons through a Lancaster\nUnlversity Summer inkemship progrom in which I had to\ndesign implemert lest and finsize a system The\nSystem had to be able of letting mobile devices\ncommunicate with server in order to rreste s muttie\nntegrated Circus\nEngrNerina Haawae\nDesign Look st Employment\namount of users and aiso support a chat engina betwaen Section Snial Processirg\nusers and server The end product hed met ond\nAdvarced Electronics Thoory\nKnowiedge Digtal\nElectronics Engineeing\nxceaded iritial targets set by the supervises\noct 20145oftware Developer\nDec 2014 NFOLAG21GRADUATE ACADEMY\nManagement Skil\nI worked in the Strotegit Innovation Support Program n\npplication\nThe aop when completed was able to\nTesm Management Skill\nnabled by a predetermi ned phone share\nand ther it woud sond\nor wudig and transmit the GPS coordinstes ys email to\npreselcted contacts in case of dangerin a\nthe optlon to be preset to onsble it\nalter a speciied timeframe had the user not disotbied the\nS M5 messages recand dSoftware Engineering\nSkills\naddition it hadn\nvice Ths was done in 1 5 morith reaching and\nceeding the supervisors intisl objectives The\nNcwfks Programming\nKnowledge and Experience\nprovided troughout the next 3 months to alow the\ncompeny bomanage the opp and its statiszics\nAndroid Development\nDistributed Systems\nDevelopment ava RMI\nGroups P2P ReST Lost\nChordNodes\nul 2014 Embedded Systems Research inten\nSep 2014 MFOLAB21COMPUTNG AVD COMMUNICATIONS\nDEPARTMENT\nt was handpicked by one of my professors to design\nData MiningMachine\n', NULL),
  (31, 'arief Wijaya Putra', 'vandorohery99@gmail.com', '$2b$10$VioKAC7fDRywoTfadz/0V.BkYCRaQSbe1ZoKR4fo95nyZZUOonbUm', NULL, '1526195710761.jpg', '1526195680506.jpg', 'PROFILE\nI am an experienced social media manager seeking a fulltime\nposition in the field of social media and marketing communications\nwhere l can apply my knowledge and skills for continuous\nimprovement\nEXPERIENCE\nSOCIAL MEDIA PRODUCER\nNEW MEDIA COMPANY  FEB 2013DEC 2014\n Managed social media accounts and created social media for\ndaily postings\n Increased social media following and clicks by 200\nMAXENE\nWOOLFOLK\nCOMMUNICATIONS INTERN\nRICH MEDIA INTERACTIVE 1 APR 2012  JAN 2013\n Developed a social media strategy to increase the following of\nthe company website\nSpearheaded a viral campaign for one of the companys new\nproducts\nSOCIAL MEDIA MANAGER\nEDUCATION\nBACHELOR OF ARTS MAJOR IN COMMUNICATION\nUNIVERSITY OF DUNDEE 2009 2013\nGPA 39\nCONTACT\n44 7700 9530\nHELLOMAXENEWOOLFOLKCOM\nW WW MAXENEWOOLFOLKCOM\nSKILLS\n SEO and Google Analytics\n Social media strategy\n Marketing\n Corporate blogging\n Project management\n Layout design\n Photo editing\n Market research\nWeb content development\nSOCIAL MEDIA\n Copywriting\nTWITTER MAXENEWOOLFOLK\nFACEBOOK MAXENEWOOLFOLK\nINSTAGRAMMAXENEWOOLFOLK\nAWARDS\nNEW MEDIA COMPANY\nMOST OUTSTANDING SOCIAL MEDIA PRODUCER\nDEC 2015\nRICH MEDIA INTERACTIVE\nBEST INTERN\nJAN 2014\n', 'PROVINSI JAWA BARAT\nKOTA CIMAHI\nNIK\n3217061804870007\nARIEF WIJAYA PUTRA\nNama\nTempat Igl Lahir BANDUNG 1804 1987\nJenis kelamin\nAlamat   JE AMIR MAHMUD GG\nLAKLEAKI\nGol Darah\nSIRNAGALIH NO 62\n005006\nRTIRW\nKelDesa\nKecamatan\nGBABAT\nISLAM\nPELAJARMAHASISWA\nCIMAHI UTARA\nAgama\nStatus Perkawinan BELUM KAWIN\nPekerjaan\nKewarganegaraanWN\nBerlaku Hingga SEUMUR HIDUP\n\nKOTA CIMAHI\n17112015\n');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `hunter_vacancy`
  --
  
  CREATE TABLE `hunter_vacancy` (
    `hunter_id` int(11) NOT NULL,
    `vacancy_id` int(11) NOT NULL,
    `result` text,
    `score` double DEFAULT NULL,
    `reason` text COMMENT 'Buat kasih Feedback',
    `feedback` text
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `hunter_vacancy`
  --
  
  INSERT INTO `hunter_vacancy` (`hunter_id`, `vacancy_id`, `result`, `score`, `reason`, `feedback`) VALUES
  (1, 7, '{"gender":1,"gpa":0,"skill":[0,0,0],"id":"1"}', 20, 'We are sorry, you are not meet the GPA requirement, the php skill, the html skill, and the css skill.', 'Your skill does not meet the requirement. Please find other job with your current skill.'),
  (2, 7, '{"gender":1,"gpa":1,"skill":[1,0,0],"id":"2"}', 60, 'We are sorry, you are not meet the html skill, and the css skill.', 'Your skill barely meet the requirement. Please study more than the others'),
  (11, 7, '{"gender":1,"gpa":0,"skill":[0,0,0],"id":"11"}', 20, 'We are sorry, you are not meet the GPA requirement, the php skill, the html skill, and the css skill.', 'Your skill does not meet the requirement. Please find other job with your current skill.'),
  (16, 7, '{"gender":1,"gpa":0,"skill":[0,0,0],"id":"16"}', 20, 'We are sorry, you are not meet the GPA requirement, the php skill, the html skill, and the css skill.', 'Your skill does not meet the requirement. Please find other job with your current skill.'),
  (17, 7, '{"gender":1,"gpa":0,"skill":[1,0,0],"id":"17"}', 40, 'We are sorry, you are not meet the GPA requirement, the html skill, and the css skill.', 'Your skill barely meet the requirement. Please study more than the others'),
  (18, 7, '{"gender":1,"gpa":0,"skill":[0,0,0],"id":"18"}', 20, 'We are sorry, you are not meet the GPA requirement, the php skill, the html skill, and the css skill.', 'Your skill does not meet the requirement. Please find other job with your current skill.'),
  (19, 7, '{"gender":0,"gpa":0,"skill":[0,0,0],"id":"19"}', 0, 'We are sorry, you are not meet the gender requirement, the GPA requirement, the php skill, the html skill, and the css skill.', 'Your skill does not meet the requirement. Please find other job with your current skill.'),
  (20, 7, '{"gender":0,"gpa":0,"skill":[0,0,0],"id":"20"}', 0, 'We are sorry, you are not meet the gender requirement, the GPA requirement, the php skill, the html skill, and the css skill.', 'Your skill does not meet the requirement. Please find other job with your current skill.'),
  (21, 7, '{"gender":0,"gpa":0,"skill":[0,0,0],"id":"21"}', 0, 'We are sorry, you are not meet the gender requirement, the GPA requirement, the php skill, the html skill, and the css skill.', 'Your skill does not meet the requirement. Please find other job with your current skill.'),
  (22, 7, '{"gender":0,"gpa":0,"skill":[0,0,0],"id":"22"}', 0, 'We are sorry, you are not meet the gender requirement, the GPA requirement, the php skill, the html skill, and the css skill.', 'Your skill does not meet the requirement. Please find other job with your current skill.'),
  (23, 7, '{"gender":1,"gpa":0,"skill":[1,1,1],"id":"23"}', 80, 'We are sorry, you are not meet the GPA requirement.', 'I think you need to maximize your skill with your current GPA'),
  (24, 7, '{"gender":0,"gpa":0,"skill":[0,1,1],"id":"24"}', 40, 'We are sorry, you are not meet the gender requirement, the GPA requirement, and the php skill.', 'I think you need to maximize your skill with your current GPA'),
  (25, 7, '{"gender":0,"gpa":0,"skill":[0,0,0],"id":"25"}', 0, 'We are sorry, you are not meet the gender requirement, the GPA requirement, the php skill, the html skill, and the css skill.', 'Your skill does not meet the requirement. Please find other job with your current skill.'),
  (26, 7, '{"gender":1,"gpa":0,"skill":[0,0,0],"id":"26"}', 20, 'We are sorry, you are not meet the GPA requirement, the php skill, the html skill, and the css skill.', 'Your skill does not meet the requirement. Please find other job with your current skill.'),
  (27, 7, '{"gender":1,"gpa":0,"skill":[1,0,0],"id":"27"}', 40, 'We are sorry, you are not meet the GPA requirement, the html skill, and the css skill.', 'Your skill barely meet the requirement. Please study more than the others'),
  (28, 7, '{"gender":1,"gpa":0,"skill":[0,1,1],"id":"28"}', 60, 'We are sorry, you are not meet the GPA requirement, and the php skill.', 'I think you need to maximize your skill with your current GPA'),
  (29, 7, '{"gender":1,"gpa":0,"skill":[0,0,0],"id":"29"}', 20, 'We are sorry, you are not meet the GPA requirement, the php skill, the html skill, and the css skill.', 'Your skill does not meet the requirement. Please find other job with your current skill.'),
  (30, 7, '{"gender":1,"gpa":0,"skill":[0,0,0],"id":"30"}', 20, 'We are sorry, you are not meet the GPA requirement, the php skill, the html skill, and the css skill.', 'Your skill does not meet the requirement. Please find other job with your current skill.'),
  (31, 2, NULL, NULL, NULL, NULL),
  (31, 7, '{"gender":1,"gpa":0,"skill":[0,0,0],"id":"31"}', 20, 'We are sorry, you are not meet the GPA requirement, the php skill, the html skill, and the css skill.', 'Your skill does not meet the requirement. Please find other job with your current skill.');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `requirements`
  --
  
  CREATE TABLE `requirements` (
    `id` int(11) NOT NULL,
    `vacancy_id` int(11) NOT NULL,
    `text` text NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `requirements`
  --
  
  INSERT INTO `requirements` (`id`, `vacancy_id`, `text`) VALUES
  (1, 1, 'PHP'),
  (2, 1, 'Excel'),
  (3, 3, 'bisa mandi'),
  (4, 3, 'bisa belajar'),
  (5, 4, 'bisa mandi'),
  (6, 4, 'bisa belajar'),
  (15, 7, 'Hands on with code in either of GoLang, C, C++, Node.js, Ruby, Python. Multi-programming-lingual. The more the merrier.'),
  (16, 7, 'Prior experience with e-commerce or web application development (REST).'),
  (20, 7, 'Experience with HTML5, CSS, JQuery, Bootstrap etc.');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `tasks`
  --
  
  CREATE TABLE `tasks` (
    `id` int(11) NOT NULL,
    `vacancy_id` int(11) NOT NULL,
    `criteria` text NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `tasks`
  --
  
  INSERT INTO `tasks` (`id`, `vacancy_id`, `criteria`) VALUES
  (1, 2, '{ \n   "gender" : "male", \n   "gpa" : "3.00",\n   "bachelor" : "true",\n   "skill" : ["PHP", "Excel"]\n}'),
  (4, 7, '{"gender":"male","gpa":"3.00","skill":["php","html","css"]}');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `vacancies`
  --
  
  CREATE TABLE `vacancies` (
    `id` int(11) NOT NULL,
    `company_id` int(11) NOT NULL,
    `position_name` varchar(255) NOT NULL,
    `salary_start` int(11) NOT NULL,
    `salary_end` int(11) NOT NULL,
    `description` text NOT NULL,
    `status` int(11) DEFAULT '0' COMMENT 'ini buat menandakan, lowongan masih dibuka apa nggak. 0 masih dibuka, 1 sedang otw di proses oleh sistem, 2 closed'
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `vacancies`
  --
  
  INSERT INTO `vacancies` (`id`, `company_id`, `position_name`, `salary_start`, `salary_end`, `description`, `status`) VALUES
  (1, 1, 'Web Developer', 100000, 200000, 'looking for back end developer', 1),
  (2, 5, 'DB Admin', 1000, 5000, 'looking for DB Admin', 0),
  (3, 1, 'Mobile Developer', 1000, 5000, 'looking for React Native Codinger', 1),
  (4, 5, 'Teacher', 1000, 5000, 'Looking for English Teacher', 2),
  (5, 1, 'Writer', 1000, 5000, 'looking game script writer', 0),
  (7, 5, 'Software Engineer', 9000000, 12000000, 'looking for Software Engineer', 2),
  (9, 6, 'Software Engineer', 8000000, 10000000, 'Need Software Engineer', 0);
  
  --
  -- Indexes for dumped tables
  --
  
  --
  -- Indexes for table `companies`
  --
  ALTER TABLE `companies`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `hunters`
  --
  ALTER TABLE `hunters`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `hunter_vacancy`
  --
  ALTER TABLE `hunter_vacancy`
    ADD PRIMARY KEY (`hunter_id`,`vacancy_id`),
    ADD KEY `hunter_id` (`hunter_id`),
    ADD KEY `vacancy_id` (`vacancy_id`);
  
  --
  -- Indexes for table `requirements`
  --
  ALTER TABLE `requirements`
    ADD PRIMARY KEY (`id`),
    ADD KEY `vacancy_id` (`vacancy_id`);
  
  --
  -- Indexes for table `tasks`
  --
  ALTER TABLE `tasks`
    ADD PRIMARY KEY (`id`),
    ADD KEY `vacancy_id` (`vacancy_id`);
  
  --
  -- Indexes for table `vacancies`
  --
  ALTER TABLE `vacancies`
    ADD PRIMARY KEY (`id`),
    ADD KEY `company_id` (`company_id`);
  
  --
  -- AUTO_INCREMENT for dumped tables
  --
  
  --
  -- AUTO_INCREMENT for table `companies`
  --
  ALTER TABLE `companies`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
  --
  -- AUTO_INCREMENT for table `hunters`
  --
  ALTER TABLE `hunters`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32;
  --
  -- AUTO_INCREMENT for table `requirements`
  --
  ALTER TABLE `requirements`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;
  --
  -- AUTO_INCREMENT for table `tasks`
  --
  ALTER TABLE `tasks`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
  --
  -- AUTO_INCREMENT for table `vacancies`
  --
  ALTER TABLE `vacancies`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
  --
  -- Constraints for dumped tables
  --
  
  --
  -- Constraints for table `hunter_vacancy`
  --
  ALTER TABLE `hunter_vacancy`
    ADD CONSTRAINT `hunter_vacancy_ibfk_1` FOREIGN KEY (`vacancy_id`) REFERENCES `vacancies` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
    ADD CONSTRAINT `hunter_vacancy_ibfk_2` FOREIGN KEY (`hunter_id`) REFERENCES `hunters` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  
  --
  -- Constraints for table `requirements`
  --
  ALTER TABLE `requirements`
    ADD CONSTRAINT `requirements_ibfk_1` FOREIGN KEY (`vacancy_id`) REFERENCES `vacancies` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  
  --
  -- Constraints for table `tasks`
  --
  ALTER TABLE `tasks`
    ADD CONSTRAINT `tasks_ibfk_1` FOREIGN KEY (`vacancy_id`) REFERENCES `vacancies` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  
  --
  -- Constraints for table `vacancies`
  --
  ALTER TABLE `vacancies`
    ADD CONSTRAINT `vacancies_ibfk_1` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  
  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  