text: DROP TABLE IF EXISTS `user`;
  
  CREATE TABLE user
  (
    id BIGINT AUTO_INCREMENT PRIMARY KEY NOT NULL,
    name VARCHAR(15) NOT NULL,
    password VARCHAR(12) NOT NULL,
    email VARCHAR(45) NOT NULL,
    gender VARCHAR(6) NOT NULL,
    country VARCHAR(20) NOT NULL,
    job VARCHAR(45) NOT NULL
  );
  
  insert into user ( name, email, password, gender, country, job) values ( 'mdefau0', 'limpett0@smugmug.com', 'pCHecmGBZ7', 'Female', 'China', 'Registered Nurse');
  insert into user ( name, email, password, gender, country, job) values ( 'jchadburn1', 'pknotton1@npr.org', '6TZtd6', 'Female', 'China', 'Account Executive');
  insert into user ( name, email, password, gender, country, job) values ( 'blundie2', 'swindless2@goodreads.com', 'QSaWhA0L8', 'Female', 'China', 'Office Assistant IV');
  insert into user ( name, email, password, gender, country, job) values ( 'qpawelski3', 'dmuddiman3@storify.com', 'c36A4g', 'Female', 'Philippines', 'Programmer I');
  insert into user ( name, email, password, gender, country, job) values ( 'atriggol4', 'kkyneton4@ebay.com', 'JApoui0j4', 'Male', 'Ukraine', 'Assistant Manager');
  insert into user ( name, email, password, gender, country, job) values ( 'dwayon5', 'fseabridge5@edublogs.org', 'wPAiCptqDgH', 'Male', 'United States', 'Analog Circuit Design manager');
  insert into user ( name, email, password, gender, country, job) values ( 'qhowtopreserve6', 'emcane6@theguardian.com', 'IGexWb0K', 'Female', 'Thailand', 'Legal Assistant');
  insert into user ( name, email, password, gender, country, job) values ( 'mjillard7', 'mkemmett7@altervista.org', 'flcsyh', 'Female', 'Ireland', 'Senior Financial Analyst');
  insert into user ( name, email, password, gender, country, job) values ( 'nportwaine8', 'hcannan8@opera.com', 'NTiK4xs4N3', 'Male', 'Philippines', 'Research Assistant I');
  insert into user ( name, email, password, gender, country, job) values ( 'tdebiasi9', 'sroomes9@tamu.edu', 'UCsmqBCBBNqK', 'Female', 'Philippines', 'Programmer Analyst IV');
  insert into user ( name, email, password, gender, country, job) values ( 'bchansonnea', 'couldreda@wired.com', 'ouocbrqM', 'Female', 'Iran', 'Assistant Media Planner');
  insert into user ( name, email, password, gender, country, job) values ( 'danyeneb', 'lcharkerb@state.gov', 'LCspjbknr', 'Female', 'Russia', 'Technical Writer');
  insert into user ( name, email, password, gender, country, job) values ( 'wsimonettc', 'paishfordc@goo.ne.jp', 'DA2Dytc4Uwm4', 'Male', 'Indonesia', 'Financial Advisor');
  insert into user ( name, email, password, gender, country, job) values ( 'lmalthusd', 'trotherhamd@wikispaces.com', 'ngwAdy', 'Male', 'China', 'Assistant Media Planner');
  insert into user ( name, email, password, gender, country, job) values ( 'bgreware', 'ldenise@irs.gov', 'NtfcSyFM7', 'Male', 'Indonesia', 'Paralegal');
  insert into user ( name, email, password, gender, country, job) values ( 'esabbinsf', 'abalintf@nationalgeographic.com', 'KHLygg', 'Male', 'Poland', 'Account Coordinator');
  insert into user ( name, email, password, gender, country, job) values ( 'pjemmettg', 'ekoberag@europa.eu', '8pN4NEbx3yan', 'Male', 'Portugal', 'Civil Engineer');
  insert into user ( name, email, password, gender, country, job) values ( 'dcolebrookh', 'ymcillroyh@sbwire.com', 'CkApYa5', 'Male', 'Russia', 'Chemical Engineer');
  insert into user ( name, email, password, gender, country, job) values ( 'tbolstridgei', 'cambrogioi@indiatimes.com', 'eB6TvrOcTq', 'Male', 'Dominican Republic', 'Biostatistician I');
  insert into user ( name, email, password, gender, country, job) values ( 'dfaucettj', 'jclaringboldj@paypal.com', 'rIpAJda2kP9', 'Female', 'United States', 'Product Engineer');
  insert into user ( name, email, password, gender, country, job) values ( 'fmeldonk', 'nscarrisbrickk@abc.net.au', 'SNf5uI', 'Female', 'Croatia', 'Account Representative IV');
  insert into user ( name, email, password, gender, country, job) values ( 'tmildenhalll', 'abartolomeol@seattletimes.com', 'uP40L0u1', 'Male', 'Russia', 'Office Assistant IV');
  insert into user ( name, email, password, gender, country, job) values ( 'llaprem', 'tbuesnelm@squidoo.com', '1YigEePvQK', 'Male', 'Azerbaijan', 'VP Sales');
  insert into user ( name, email, password, gender, country, job) values ( 'edamerelln', 'aaskien@bloglines.com', 'QFqCcPShuIv', 'Female', 'France', 'Project Manager');
  insert into user ( name, email, password, gender, country, job) values ( 'bquarryo', 'amatthewmano@biblegateway.com', 'dNl9vVM864h', 'Female', 'China', 'Health Coach I');
  insert into user ( name, email, password, gender, country, job) values ( 'ceastamp', 'lmcgivenap@issuu.com', '8mGX3fBLKE0', 'Female', 'Vietnam', 'Office Assistant IV');
  insert into user ( name, email, password, gender, country, job) values ( 'esertinq', 'jeverlyq@kickstarter.com', 'VT4c7KSQ', 'Male', 'Czech Republic', 'VP Sales');
  insert into user ( name, email, password, gender, country, job) values ( 'wsheratonr', 'kfortescuer@barnesandnoble.com', 'cG4MMqt0', 'Female', 'Venezuela', 'Systems Administrator I');
  insert into user ( name, email, password, gender, country, job) values ( 'rmacfarlands', 'ldrinkhills@wiley.com', '1sx2cqWtw4N', 'Female', 'China', 'Technical Writer');
  insert into user ( name, email, password, gender, country, job) values ( 'nalbertst', 'rbostockt@people.com.cn', 'Q9ESiXiKG', 'Female', 'China', 'Associate Professor');
  insert into user ( name, email, password, gender, country, job) values ( 'lcranshawu', 'cmcinnernyu@bravesites.com', '8GxKWeKLKn', 'Female', 'Sweden', 'Geological Engineer');
  insert into user ( name, email, password, gender, country, job) values ( 'eharraginv', 'opelmanv@intel.com', 'AJgIoadkjx0', 'Female', 'Indonesia', 'Senior Quality Engineer');
  insert into user ( name, email, password, gender, country, job) values ( 'fbiddyw', 'hfarndalew@cdbaby.com', 'EcJ4yhP', 'Male', 'China', 'Marketing Manager');
  insert into user ( name, email, password, gender, country, job) values ( 'lgamwellx', 'aparonix@nps.gov', 'BRncZJnLkc3', 'Male', 'Ecuador', 'Data Coordiator');
  insert into user ( name, email, password, gender, country, job) values ( 'hmclewdy', 'ashacklefordy@ucoz.ru', 'gIeudbUI3Xw', 'Male', 'Cape Verde', 'Computer Systems Analyst IV');
  insert into user ( name, email, password, gender, country, job) values ( 'bseagrovez', 'lmurchz@storify.com', 'Ok8zof', 'Male', 'Netherlands', 'Chief Design Engineer');
  insert into user ( name, email, password, gender, country, job) values ( 'ematussov10', 'hterren10@cpanel.net', 'MzTe9M', 'Female', 'Russia', 'Professor');
  insert into user ( name, email, password, gender, country, job) values ( 'kgoodere11', 'pburkman11@homestead.com', '951BcYa', 'Female', 'Thailand', 'Programmer III');
  insert into user ( name, email, password, gender, country, job) values ( 'gguillou12', 'apryer12@friendfeed.com', 'lPIau7gb', 'Female', 'Ukraine', 'Account Representative IV');
  insert into user ( name, email, password, gender, country, job) values ( 'mchenery13', 'idunkerton13@pbs.org', '4Wiozq4', 'Female', 'Indonesia', 'Food Chemist');
  insert into user ( name, email, password, gender, country, job) values ( 'alitt14', 'kthraves14@photobucket.com', 'Idh0Tn', 'Female', 'Kenya', 'Structural Analysis Engineer');
  insert into user ( name, email, password, gender, country, job) values ( 'dmalatalant15', 'rnolli15@fda.gov', 'UknWpYMXos6h', 'Male', 'United Arab Emirates', 'Web Designer II');
  insert into user ( name, email, password, gender, country, job) values ( 'lbelvin16', 'moganian16@jugem.jp', 'IEk5TNneh', 'Female', 'China', 'Human Resources Assistant II');
  insert into user ( name, email, password, gender, country, job) values ( 'schilds17', 'mpound17@nyu.edu', 'LIHnOxDi', 'Male', 'Philippines', 'Payment Adjustment Coordinator');
  insert into user ( name, email, password, gender, country, job) values ( 'dgrinaway18', 'kegentan18@163.com', 'wr7IFFaIWxve', 'Male', 'Argentina', 'Technical Writer');
  insert into user ( name, email, password, gender, country, job) values ( 'gridgwell19', 'stilsley19@gizmodo.com', 'yXhrr2qcN', 'Female', 'China', 'Health Coach IV');
  insert into user ( name, email, password, gender, country, job) values ( 'adykas1a', 'ndrepp1a@java.com', '7SKNuI', 'Female', 'Poland', 'Registered Nurse');
  insert into user ( name, email, password, gender, country, job) values ( 'bteaz1b', 'vtoland1b@nba.com', 'AP4n2ZGE', 'Male', 'Indonesia', 'Speech Pathologist');
  insert into user ( name, email, password, gender, country, job) values ( 'mbellerby1c', 'mchilcott1c@gov.uk', 'EKr8PWNCVSO', 'Male', 'Czech Republic', 'Web Designer I');
  insert into user ( name, email, password, gender, country, job) values ( 'cdoubleday1d', 'lbauduccio1d@drupal.org', 'x5RUf0m', 'Male', 'Tanzania', 'Data Coordiator');
  insert into user ( name, email, password, gender, country, job) values ( 'jboyson1e', 'vvreede1e@soup.io', 'xFv5JEpG', 'Female', 'Indonesia', 'Environmental Specialist');
  insert into user ( name, email, password, gender, country, job) values ( 'aroe1f', 'egieves1f@chronoengine.com', 'eKRJ6C', 'Male', 'Poland', 'Assistant Media Planner');
  insert into user ( name, email, password, gender, country, job) values ( 'arowell1g', 'gmumbray1g@altervista.org', '2jFgHu', 'Male', 'China', 'Marketing Assistant');
  insert into user ( name, email, password, gender, country, job) values ( 'lgaskoin1h', 'jfierro1h@zimbio.com', '9DdV9b', 'Male', 'Portugal', 'VP Marketing');
  insert into user ( name, email, password, gender, country, job) values ( 'ttwopenny1i', 'sgricewood1i@nih.gov', 'DyenJS3C', 'Male', 'Thailand', 'Internal Auditor');
  insert into user ( name, email, password, gender, country, job) values ( 'ebordman1j', 'dkliement1j@toplist.cz', '1m2RhbGNUywe', 'Female', 'Slovenia', 'VP Quality Control');
  insert into user ( name, email, password, gender, country, job) values ( 'mhutley1k', 'mgrono1k@nytimes.com', 'eTTQe7YvaF', 'Male', 'South Sudan', 'Librarian');
  insert into user ( name, email, password, gender, country, job) values ( 'hsuermeiers1l', 'adidello1l@tinyurl.com', 'yw8bJCnH', 'Female', 'Brazil', 'Director of Sales');
  insert into user ( name, email, password, gender, country, job) values ( 'larrowsmith1m', 'hsoutar1m@intel.com', 'kP4j8mh8yH', 'Male', 'Sweden', 'Information Systems Manager');
  insert into user ( name, email, password, gender, country, job) values ( 'smurcutt1n', 'scowthart1n@weibo.com', 'r26l9tNNEXHS', 'Female', 'China', 'Chief Design Engineer');
  insert into user ( name, email, password, gender, country, job) values ( 'zmcconachie1o', 'nhiseman1o@dyndns.org', 'wUtkJwsvM0X4', 'Male', 'Slovenia', 'Software Engineer I');
  insert into user ( name, email, password, gender, country, job) values ( 'hketley1p', 'eromi1p@arizona.edu', 'UDXijEWa0tPY', 'Male', 'Japan', 'Junior Executive');
  insert into user ( name, email, password, gender, country, job) values ( 'bpegrum1q', 'bpickersail1q@w3.org', 'qUhG3Regrs', 'Female', 'Brazil', 'Systems Administrator III');
  insert into user ( name, email, password, gender, country, job) values ( 'cgiraths1r', 'rbatisse1r@cnbc.com', 'xq2BTSQC', 'Female', 'China', 'Geologist I');
  insert into user ( name, email, password, gender, country, job) values ( 'chickisson1s', 'cassante1s@umich.edu', 'IFkVFLKPod', 'Female', 'South Korea', 'Help Desk Operator');
  insert into user ( name, email, password, gender, country, job) values ( 'cjackett1t', 'kkimmons1t@over-blog.com', 'DpIA0VtMtoc', 'Male', 'Indonesia', 'Programmer II');
  insert into user ( name, email, password, gender, country, job) values ( 'jkikke1u', 'rhollows1u@about.com', 'izzql0rYA', 'Male', 'Portugal', 'Administrative Assistant I');
  insert into user ( name, email, password, gender, country, job) values ( 'gdaine1v', 'hrive1v@amazon.co.jp', 'M7mZd8L4tvBV', 'Male', 'Sierra Leone', 'Environmental Specialist');
  insert into user ( name, email, password, gender, country, job) values ( 'agromley1w', 'dringrose1w@oaic.gov.au', 'p2sAv99zx', 'Female', 'United States', 'Assistant Media Planner');
  insert into user ( name, email, password, gender, country, job) values ( 'fcreggan1x', 'wgiamuzzo1x@newsvine.com', 'ZdQsoT', 'Male', 'China', 'Software Consultant');
  insert into user ( name, email, password, gender, country, job) values ( 'rketteman1y', 'fweaben1y@jimdo.com', '3LUWey8', 'Female', 'Greece', 'Sales Associate');
  insert into user ( name, email, password, gender, country, job) values ( 'fprebble1z', 'nnaper1z@ustream.tv', '2DTHmH', 'Female', 'Indonesia', 'Marketing Assistant');
  insert into user ( name, email, password, gender, country, job) values ( 'gsadler20', 'danderbrugge20@prlog.org', 'lGK8rj8V4', 'Female', 'Philippines', 'Recruiter');
  insert into user ( name, email, password, gender, country, job) values ( 'ggowrich21', 'mmckellar21@cdc.gov', 'RIaZCytmEI', 'Female', 'Russia', 'Internal Auditor');
  insert into user ( name, email, password, gender, country, job) values ( 'dinns22', 'jtunesi22@cdc.gov', 'kAho0i', 'Male', 'Argentina', 'Recruiter');
  insert into user ( name, email, password, gender, country, job) values ( 'bgrindell23', 'agascoyen23@about.me', 'jT8P3rzcAb', 'Male', 'Russia', 'Cost Accountant');
  insert into user ( name, email, password, gender, country, job) values ( 'awilhelmy24', 'jgulliford24@shutterfly.com', 'n86Mzkh3vu', 'Male', 'Aruba', 'Research Associate');
  insert into user ( name, email, password, gender, country, job) values ( 'bivanuschka25', 'rcostley25@moonfruit.com', 'uHptIMZYn', 'Male', 'China', 'Junior Executive');
  insert into user ( name, email, password, gender, country, job) values ( 'gtweedell26', 'wsymones26@tumblr.com', 'Hjp4IH', 'Male', 'Portugal', 'Sales Representative');
  insert into user ( name, email, password, gender, country, job) values ( 'tcathersides27', 'isicha27@meetup.com', 'xWdww9bCG', 'Male', 'China', 'Assistant Manager');
  insert into user ( name, email, password, gender, country, job) values ( 'tkirkman28', 'dverheyden28@furl.net', 'luxncLp', 'Female', 'Japan', 'Senior Quality Engineer');
  insert into user ( name, email, password, gender, country, job) values ( 'mcausey29', 'lstannion29@blogtalkradio.com', '7bn32mA', 'Female', 'Japan', 'VP Product Management');
  insert into user ( name, email, password, gender, country, job) values ( 'gjeppensen2a', 'bvenneur2a@sbwire.com', 'x20scszblhW', 'Male', 'Nigeria', 'Health Coach II');
  insert into user ( name, email, password, gender, country, job) values ( 'tmardee2b', 'mstreets2b@csmonitor.com', '0VztT0bk', 'Female', 'Zambia', 'Accounting Assistant I');
  insert into user ( name, email, password, gender, country, job) values ( 'sdeller2c', 'tcrowter2c@storify.com', 'K9KPv9', 'Female', 'Russia', 'Web Designer IV');
  insert into user ( name, email, password, gender, country, job) values ( 'mmoncreiff2d', 'cmacaskie2d@reddit.com', 'fqpon6', 'Female', 'Poland', 'Help Desk Operator');
  insert into user ( name, email, password, gender, country, job) values ( 'cmalloy2e', 'ebartalot2e@bing.com', '0hpYne4', 'Male', 'Nigeria', 'Business Systems Development Analyst');
  insert into user ( name, email, password, gender, country, job) values ( 'msuttling2f', 'bmapam2f@meetup.com', 'hmfNVjY5GWIF', 'Male', 'Russia', 'Administrative Officer');
  insert into user ( name, email, password, gender, country, job) values ( 'aedgehill2g', 'cfrantsev2g@twitter.com', 'LHeag7b', 'Male', 'Guatemala', 'Account Executive');
  insert into user ( name, email, password, gender, country, job) values ( 'sharbord2h', 'blawrenz2h@nbcnews.com', 'kD4dVqnkR', 'Female', 'Sweden', 'Assistant Media Planner');
  insert into user ( name, email, password, gender, country, job) values ( 'cwilmore2i', 'jbroomfield2i@usa.gov', 'nmEyU0MJjEw', 'Female', 'Cameroon', 'Structural Engineer');
  insert into user ( name, email, password, gender, country, job) values ( 'bluquet2j', 'epetrelli2j@surveymonkey.com', 'F6ECGywBZEME', 'Male', 'Poland', 'Software Engineer III');
  insert into user ( name, email, password, gender, country, job) values ( 'cheiss2k', 'stiebe2k@scribd.com', 'VPMj3Y', 'Female', 'Israel', 'Nuclear Power Engineer');
  insert into user ( name, email, password, gender, country, job) values ( 'fcauderlie2l', 'bpocknell2l@unicef.org', 'j5elz1434', 'Male', 'China', 'Database Administrator II');
  insert into user ( name, email, password, gender, country, job) values ( 'bcoundley2m', 'azmitrichenko2m@reference.com', 'jE6dqSC', 'Male', 'Sweden', 'Staff Accountant IV');
  insert into user ( name, email, password, gender, country, job) values ( 'ocartmell2n', 'hlaundon2n@state.gov', 'M4tA6IXLizih', 'Male', 'Mozambique', 'Internal Auditor');
  insert into user ( name, email, password, gender, country, job) values ( 'ijordin2o', 'bdmych2o@pbs.org', 'rGTnXp', 'Male', 'Colombia', 'GIS Technical Architect');
  insert into user ( name, email, password, gender, country, job) values ( 'hwilsee2p', 'ldey2p@google.com', 'uOX4tjC', 'Male', 'Indonesia', 'Tax Accountant');
  insert into user ( name, email, password, gender, country, job) values ( 'bmaymond2q', 'eveschi2q@ihg.com', 'oVS8jSHLWF4', 'Female', 'China', 'Software Engineer II');
  insert into user ( name, email, password, gender, country, job) values ( 'mbrychan2r', 'cmcdermottrow2r@e-recht24.de', '7K1tv9Lm', 'Female', 'Poland', 'Administrative Officer');