# Sequel Pro dump
# Version 1630
# http://code.google.com/p/sequel-pro
#
# Host: localhost (MySQL 5.1.30)
# Database: chewyslist_development
# Generation Time: 2010-04-19 12:38:15 -0700
# ************************************************************

/*!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 utf8 */;
/*!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 */;


# Dump of table occupations
# ------------------------------------------------------------

DROP TABLE IF EXISTS `occupations`;

CREATE TABLE `occupations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `label` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=755 DEFAULT CHARSET=latin1;

LOCK TABLES `occupations` WRITE;
/*!40000 ALTER TABLE `occupations` DISABLE KEYS */;
INSERT INTO `occupations` (`id`,`label`,`name`)
VALUES
	(1,'3-D Artist','3-d_artist'),
	(2,'Account Executive','account_executive'),
	(3,'Account Supervisor','account_supervisor'),
	(4,'Accountant','accountant'),
	(5,'Accounting','accounting'),
	(6,'Acquisitions Executive','acquisitions_executive'),
	(7,'Acting Instructor','acting_instructor'),
	(8,'Activist','activist'),
	(9,'Actor','actor'),
	(10,'Administrative Assistant','administrative_assistant'),
	(11,'Advertising Agency Assistant','advertising_agency_assistant'),
	(12,'Advertising Agency Director','advertising_agency_director'),
	(13,'Advertising Account Executive','advertising_account_executive'),
	(14,'Advertising Account Director','advertising_account_director'),
	(15,'Advertising Art Director','advertising_art_director'),
	(16,'Advertising Commercial','advertising_commercial'),
	(17,'Advertising Copy Writer','advertising_copy_writer'),
	(18,'Advertising Creative Director','advertising_creative_director'),
	(19,'Advertising Illustrator','advertising_illustrator'),
	(20,'Advertising Photographer','advertising_photographer'),
	(21,'Advertising Art Director','advertising_art_director'),
	(22,'Advertising','advertising'),
	(23,'Advertising CFO','advertising_cfo'),
	(24,'Advertising COO','advertising_coo'),
	(25,'Advertising CTO','advertising_cto'),
	(26,'Advertising Copywriter','advertising_copywriter'),
	(27,'Advertising Creative Director','advertising_creative_director'),
	(28,'Advertising Digital Media Strategist','advertising_digital_media_strategist'),
	(29,'Advertising Marketing Director','advertising_marketing_director'),
	(30,'Advertising Media Planner','advertising_media_planner'),
	(31,'Advertising President','advertising_president'),
	(32,'Adverting Production Designer','adverting_production_designer'),
	(33,'Advertising Illustrator','advertising_illustrator'),
	(34,'Advertising Photographer','advertising_photographer'),
	(35,'Advertising Principal','advertising_principal'),
	(36,'Advertising Research Project Director','advertising_research_project_director'),
	(37,'Advertising Traffic Manager','advertising_traffic_manager'),
	(38,'Advertising Vice President','advertising_vice_president'),
	(39,'Aerial Photographer','aerial_photographer'),
	(40,'Agent','agent'),
	(41,'Amusement Park Designer','amusement_park_designer'),
	(42,'Amusement Park Entertainment','amusement_park_entertainment'),
	(43,'Amusement Park Performer','amusement_park_performer'),
	(44,'Amusement Park Producer','amusement_park_producer'),
	(45,'Anchor/Reporter','anchor_reporter'),
	(46,'Animal Trainer','animal_trainer'),
	(47,'Animator','animator'),
	(48,'Animation Coordinator','animation_coordinator'),
	(49,'Animation Director','animation_director'),
	(50,'Animation Supervisor','animation_supervisor'),
	(51,'Antique Restorer','antique_restorer'),
	(52,'Apple Stores Sales Representative','apple_stores_sales_representative'),
	(53,'Apprentice Coach','apprentice_coach'),
	(54,'Architect','architect'),
	(55,'Architectural Illustrator','architectural_illustrator'),
	(56,'Architectural Technologist','architectural_technologist'),
	(57,'Archivist','archivist'),
	(58,'Artist','artist'),
	(59,'Artist Services Coordinator','artist_services_coordinator'),
	(60,'Artist Services Manager','artist_services_manager'),
	(61,'Artist Services Director','artist_services_director'),
	(62,'Art Auctioneer','art_auctioneer'),
	(63,'Art Consultant','art_consultant'),
	(64,'Art Critic','art_critic'),
	(65,'Art Dealer','art_dealer'),
	(66,'Art Director','art_director'),
	(67,'Art Director-Film/Video/Print','art_director-film_video_print'),
	(68,'Art Editor','art_editor'),
	(69,'Art Historian','art_historian'),
	(70,'Art Instructor','art_instructor'),
	(71,'Art Lecturer','art_lecturer'),
	(72,'Art Librarian','art_librarian'),
	(73,'Art Publisher','art_publisher'),
	(74,'Art Therapist','art_therapist'),
	(75,'Art Historian','art_historian'),
	(76,'Artistic Director','artistic_director'),
	(77,'Arts Administrator','arts_administrator'),
	(78,'Artist-In-Residence','artist-in-residence'),
	(79,'Artists\\ Agent','artists_agent'),
	(80,'Assistant Director','assistant_director'),
	(81,'Assistant Editor ','assistant_editor'),
	(82,'Associate Director','associate_director'),
	(83,'Associate Managing Director','associate_managing_director'),
	(84,'Associate Producer','associate_producer'),
	(85,'Attorney/Lawyer','attorney_lawyer'),
	(86,'Auctioneer','auctioneer'),
	(87,'Audience Development Manager','audience_development_manager'),
	(88,'Automobile Specialty Painter','automobile_specialty_painter'),
	(89,'Back-End Developer','back-end_developer'),
	(90,'Background Artist','background_artist'),
	(91,'Band Manager','band_manager'),
	(92,'Barista','barista'),
	(93,'Bartender','bartender'),
	(94,'Basketry Artisan','basketry_artisan'),
	(95,'Best Boy Grip','best_boy_grip'),
	(96,'Billboard Designer','billboard_designer'),
	(97,'Blogger','blogger'),
	(98,'Book Jacket Designer','book_jacket_designer'),
	(99,'Book Illustrator','book_illustrator'),
	(100,'Bookkeeper','bookkeeper'),
	(101,'Booking Agent','booking_agent'),
	(102,'Box Office Assistant','box_office_assistant'),
	(103,'Box Office Associate','box_office_associate'),
	(104,'Box Office Manager','box_office_manager'),
	(105,'Business Affairs Executive','business_affairs_executive'),
	(106,'Buyer','buyer'),
	(107,'Cabaret Artist','cabaret_artist'),
	(108,'Camera Assistant','camera_assistant'),
	(109,'Camera Operator','camera_operator'),
	(110,'Camera Supervisor','camera_supervisor'),
	(111,'Carpenter','carpenter'),
	(112,'Casting Agency CEO','casting_agency_ceo'),
	(113,'Casting Agency CFO','casting_agency_cfo'),
	(114,'Casting Agency COO','casting_agency_coo'),
	(115,'Casting Agency CTO','casting_agency_cto'),
	(116,'Casting Agency Manager','casting_agency_manager'),
	(117,'Casting Agency President','casting_agency_president'),
	(118,'Casting Agency Principal','casting_agency_principal'),
	(119,'Casting Agency Vice-President','casting_agency_vice-president'),
	(120,'Casting Assistant','casting_assistant'),
	(121,'Casting Associate','casting_associate'),
	(122,'Casting Director','casting_director'),
	(123,'Caterer','caterer'),
	(124,'CG Artist','cg_artist'),
	(125,'Character Animator','character_animator'),
	(126,'Character Designer','character_designer'),
	(127,'Chef','chef'),
	(128,'Chief Technical Officer','chief_technical_officer'),
	(129,'Child/Day Care Worker','child_day_care_worker'),
	(130,'Choreographer','choreographer'),
	(131,'Chorus','chorus'),
	(132,'Cinematographer','cinematographer'),
	(133,'Circus Arts Performer','circus_arts_performer'),
	(134,'Comedian','comedian'),
	(135,'Comic Book Artist','comic_book_artist'),
	(136,'Commissioner: Film/Television','commissioner_film_television'),
	(137,'Communications Assistant','communications_assistant'),
	(138,'Communications Associate','communications_associate'),
	(139,'Communications Director','communications_director'),
	(140,'Communications Manager','communications_manager'),
	(141,'Community Outreach Manager','community_outreach_manager'),
	(142,'Company Manager','company_manager'),
	(143,'Composer','composer'),
	(144,'Compositor','compositor'),
	(145,'Computer Animator','computer_animator'),
	(146,'Concept Artist/Illustrator','concept_artist_illustrator'),
	(147,'Conceptual Artist','conceptual_artist'),
	(148,'Concierge','concierge'),
	(149,'Conductor','conductor'),
	(150,'Construction Supervisor','construction_supervisor'),
	(151,'Consultant','consultant'),
	(152,'Continuity','continuity'),
	(153,'Cook','cook'),
	(154,'Coordinating Producer','coordinating_producer'),
	(155,'Co-Producer','co-producer'),
	(156,'Concert Producer','concert_producer'),
	(157,'Concert Venue Manager','concert_venue_manager'),
	(158,'Corporate Executive','corporate_executive'),
	(159,'Costume Designer','costume_designer'),
	(160,'Costume Researcher','costume_researcher'),
	(161,'Craft Services','craft_services'),
	(162,'Creative Director','creative_director'),
	(163,'Creatures Supervisor','creatures_supervisor'),
	(164,'Critic','critic'),
	(165,'Cruise Director','cruise_director'),
	(166,'Cruise Ship Performer','cruise_ship_performer'),
	(167,'Cultural Attache','cultural_attache'),
	(168,'Curator','curator'),
	(169,'Customer Service Representative','customer_service_representative'),
	(170,'Dentist','dentist'),
	(171,'Dermatologist','dermatologist'),
	(172,'Development Executive','development_executive'),
	(173,'Dancer','dancer'),
	(174,'Dance Captain','dance_captain'),
	(175,'Dance Instructor','dance_instructor'),
	(176,'Dark Room Technician','dark_room_technician'),
	(177,'Designer','designer'),
	(178,'Design Consultant','design_consultant'),
	(179,'Design Engineer','design_engineer'),
	(180,'Developer','developer'),
	(181,'Development Assistant','development_assistant'),
	(182,'Development Associate','development_associate'),
	(183,'Development Director','development_director'),
	(184,'Development Executive','development_executive'),
	(185,'DGA Trainee','dga_trainee'),
	(186,'Dialect Coach','dialect_coach'),
	(187,'Digital Animator','digital_animator'),
	(188,'Digital Artist','digital_artist'),
	(189,'Digital Colorist','digital_colorist'),
	(190,'Digital Compositor','digital_compositor'),
	(191,'Digital Effects Artist','digital_effects_artist'),
	(192,'Digital Filmmaker','digital_filmmaker'),
	(193,'Digital Media Specialist','digital_media_specialist'),
	(194,'Digital Media Strategist','digital_media_strategist'),
	(195,'Digital Modeler','digital_modeler'),
	(196,'Digital Paint and Roto Supervisor','digital_paint_and_roto_supervisor'),
	(197,'Diorama Artist','diorama_artist'),
	(198,'Director','director'),
	(199,'Director: Film/Video','director_film_video'),
	(200,'Director: Opera','director_opera'),
	(201,'Director: Stage','director_stage'),
	(202,'Director: Television','director_television'),
	(203,'Director\\S Assistant','directors_assistant'),
	(204,'Director\\S Rep','directors_rep'),
	(205,'Dishwasher','dishwasher'),
	(206,'Display Artist','display_artist'),
	(207,'Display Designer','display_designer'),
	(208,'Distribution Executive','distribution_executive'),
	(209,'Doctor/Physician','doctor_physician'),
	(210,'Documentary Photographer','documentary_photographer'),
	(211,'Draftsperson','draftsperson'),
	(212,'Dressmaker','dressmaker'),
	(213,'Docent','docent'),
	(214,'Documentarian','documentarian'),
	(215,'Dolly Grip','dolly_grip'),
	(216,'Drama Instructor','drama_instructor'),
	(217,'Dramaturg','dramaturg'),
	(218,'Editor: Film/Video','editor_film_video'),
	(219,'Editor: Sound Editorial Art Director','editor_sound_editorial_art_director'),
	(220,'Editorial Illustrator','editorial_illustrator'),
	(221,'Editorial Photographer','editorial_photographer'),
	(222,'Educator','educator'),
	(223,'Education Manager','education_manager'),
	(224,'Entertainment Attorney/Lawyer','entertainment_attorney_lawyer'),
	(225,'Event Coordinator','event_coordinator'),
	(226,'Event Producer ','event_producer_'),
	(227,'Executive Director','executive_director'),
	(228,'Executive Producer','executive_producer'),
	(229,'Exhibitor','exhibitor'),
	(230,'Exhibition Designer','exhibition_designer'),
	(231,'Exhibition Organizer','exhibition_organizer'),
	(232,'Extra','extra'),
	(233,'Fabric Designer','fabric_designer'),
	(234,'Facial Capture Technician','facial_capture_technician'),
	(235,'Facilities Coordinator','facilities_coordinator'),
	(236,'Facilities Director','facilities_director'),
	(237,'Facilities Manager','facilities_manager'),
	(238,'Fashion Buyer','fashion_buyer'),
	(239,'Fashion Designer','fashion_designer'),
	(240,'Fashion Editor','fashion_editor'),
	(241,'Fashion Illustrator','fashion_illustrator'),
	(242,'Fashion Photographer','fashion_photographer'),
	(243,'Festival Administrator','festival_administrator'),
	(244,'Festival Director','festival_director'),
	(245,'Fiber Artist','fiber_artist'),
	(246,'Field-Expedition Artist','field-expedition_artist'),
	(247,'Fight Captain','fight_captain'),
	(248,'Fight Director','fight_director'),
	(249,'Filmmaker','filmmaker'),
	(250,'Film Instructor','film_instructor'),
	(251,'Film Color Timer','film_color_timer'),
	(252,'Film Critic','film_critic'),
	(253,'Finance/Financial Services','finance_financial_services'),
	(254,'Fine Arts Instructor','fine_arts_instructor'),
	(255,'First Assistant Director','first_assistant_director'),
	(256,'First Assistant Camera','first_assistant_camera'),
	(257,'Floor Covering Designer','floor_covering_designer'),
	(258,'Florist','florist'),
	(259,'Foreign Service','foreign_service'),
	(260,'Foundry Artist','foundry_artist'),
	(261,'Functional Designer','functional_designer'),
	(262,'Furniture Designer','furniture_designer'),
	(263,'Fundraising/Development Assistant','fundraising_development_assistant'),
	(264,'Fundraising/Development Associate','fundraising_development_associate'),
	(265,'Fundraising/Development Manager','fundraising_development_manager'),
	(266,'Fundraising/Development Director','fundraising_development_director'),
	(267,'Gaffer/Electrician','gaffer_electrician'),
	(268,'Gallery Director','gallery_director'),
	(269,'Gallery Owner','gallery_owner'),
	(270,'Game Developer','game_developer'),
	(271,'Game Designer','game_designer'),
	(272,'Game Programmer','game_programmer'),
	(273,'Game Tester','game_tester'),
	(274,'Gaming Engineer','gaming_engineer'),
	(275,'Gardener','gardener'),
	(276,'General Manager','general_manager'),
	(277,'Glass Blower','glass_blower'),
	(278,'Glass Designer','glass_designer'),
	(279,'Government Employee','government_employee'),
	(280,'Graffiti Artist','graffiti_artist'),
	(281,'Graphic Artist','graphic_artist'),
	(282,'Graphic Designer','graphic_designer'),
	(283,'Graphic Novelist','graphic_novelist'),
	(284,'Graphic Novel Designer','graphic_novel_designer'),
	(285,'Greeting Card Designer','greeting_card_designer'),
	(286,'Grip','grip'),
	(287,'Hacker','hacker'),
	(288,'Hair Stylist','hair_stylist'),
	(289,'Haute Couturier','haute_couturier'),
	(290,'Hotel Industry Manager','hotel_industry_manager'),
	(291,'Hotel Industry Worker','hotel_industry_worker'),
	(292,'House Manager','house_manager'),
	(293,'Illustration Agent','illustration_agent'),
	(294,'Illustrator','illustrator'),
	(295,'Illustrator-Freelance','illustrator-freelance'),
	(296,'IMAX Postproduction Coordination','imax_postproduction_coordination'),
	(297,'Improv Comedy Performer','improv_comedy_performer'),
	(298,'Industrial Designer','industrial_designer'),
	(299,'Industrial Photographer','industrial_photographer'),
	(300,'Interior Decorator','interior_decorator'),
	(301,'Interior Designer','interior_designer'),
	(302,'Information Architect','information_architect'),
	(303,'Interactive Media','interactive_media'),
	(304,'Interactive Producer','interactive_producer'),
	(305,'Intern','intern'),
	(306,'Interpreter','interpreter'),
	(307,'Investor','investor'),
	(308,'IT Director','it_director'),
	(309,'IT Manager','it_manager'),
	(310,'Jeweler','jeweler'),
	(311,'Jeweler Designer','jeweler_designer'),
	(312,'Journalist','journalist'),
	(313,'Key Grip','key_grip'),
	(314,'Landscape Architect','landscape_architect'),
	(315,'Layout Artist','layout_artist'),
	(316,'Layout Designer','layout_designer'),
	(317,'Lead Animator','lead_animator'),
	(318,'Lecturer','lecturer'),
	(319,'Letterer','letterer'),
	(320,'Lighting Consultant','lighting_consultant'),
	(321,'Lighting Designer','lighting_designer'),
	(322,'Lighting Designer: Film/Video/Television','lighting_designer_film_video_television'),
	(323,'Lighting Designer: Stage','lighting_designer_stage'),
	(324,'Lithographer','lithographer'),
	(325,'Logo Designer','logo_designer'),
	(326,'Lighting Technician','lighting_technician'),
	(327,'Line Producer','line_producer'),
	(328,'Literary Manager','literary_manager'),
	(329,'Live Action Supervisor','live_action_supervisor'),
	(330,'Location Manager','location_manager'),
	(331,'Location Scout','location_scout'),
	(332,'Machine Designer','machine_designer'),
	(333,'Magazine Designer','magazine_designer'),
	(334,'Make up Artist','make_up_artist'),
	(335,'Managing Director','managing_director'),
	(336,'Marine Illustrator','marine_illustrator'),
	(337,'Marketing and Distribution Consultant','marketing_and_distribution_consultant'),
	(338,'Marketing and Distribution Executive','marketing_and_distribution_executive'),
	(339,'Marketing and Distribution Manager','marketing_and_distribution_manager'),
	(340,'Marketing Associate','marketing_associate'),
	(341,'Marketing Executive','marketing_executive'),
	(342,'Marketing Manager','marketing_manager'),
	(343,'Market Researcher','market_researcher'),
	(344,'Master Electrician','master_electrician'),
	(345,'Master Model Maker','master_model_maker'),
	(346,'Medical Illustrator','medical_illustrator'),
	(347,'Membership Assistant','membership_assistant'),
	(348,'Membership Associate','membership_associate'),
	(349,'Membership Director','membership_director'),
	(350,'Membership Manager','membership_manager'),
	(351,'Metalworker','metalworker'),
	(352,'Mid-Wife','mid-wife'),
	(353,'Milliner','milliner'),
	(354,'Mime','mime'),
	(355,'Mobile Apps Developer','mobile_apps_developer'),
	(356,'Mobile Developer','mobile_developer'),
	(357,'Mobile Interface Designer','mobile_interface_designer'),
	(358,'Mock-Up Artist','mock-up_artist'),
	(359,'Model Maker','model_maker'),
	(360,'Mosaicist','mosaicist'),
	(361,'Motion Editor','motion_editor'),
	(362,'Motion Capture Model','motion_capture_model'),
	(363,'Motion Capture Performer','motion_capture_performer'),
	(364,'Motion Graphics Artist','motion_graphics_artist'),
	(365,'Motion Graphics Designer','motion_graphics_designer'),
	(366,'Multi Media Designer','multi_media_designer'),
	(367,'Muralist','muralist'),
	(368,'Museum Guide','museum_guide'),
	(369,'Movement Coach','movement_coach'),
	(370,'Multimedia Artist','multimedia_artist'),
	(371,'Multimedia Instructor','multimedia_instructor'),
	(372,'Museum Director','museum_director'),
	(373,'Musician','musician'),
	(374,'Music Director','music_director'),
	(375,'Music Editor','music_editor'),
	(376,'Music Scoring Coordinator','music_scoring_coordinator'),
	(377,'Music Score Programmer','music_score_programmer'),
	(378,'Music Supervisor','music_supervisor'),
	(379,'Musical Arranger','musical_arranger'),
	(380,'Narrator','narrator'),
	(381,'New Media Professional','new_media_professional'),
	(382,'Nonprofit Administrator','nonprofit_administrator'),
	(383,'Nonprofit Worker','nonprofit_worker'),
	(384,'Office Manager','office_manager'),
	(385,'On-Set Carpenter','on-set_carpenter'),
	(386,'On-Set Photographer','on-set_photographer'),
	(387,'On-Set Tutor','on-set_tutor'),
	(388,'Opera Singer','opera_singer'),
	(389,'Operations Manager','operations_manager'),
	(390,'Operations Supervisor','operations_supervisor'),
	(391,'Orchestrator','orchestrator'),
	(392,'Package Designer','package_designer'),
	(393,'Painter','painter'),
	(394,'Parade Float Designer/Builder','parade_float_designer_builder'),
	(395,'Paste-Up Artist','paste-up_artist'),
	(396,'Patron Services Director','patron_services_director'),
	(397,'Patron Services Manager','patron_services_manager'),
	(398,'Payroll Services','payroll_services'),
	(399,'Performance Artist','performance_artist'),
	(400,'Personal Manager','personal_manager'),
	(401,'Philanthropist','philanthropist'),
	(402,'Photo Journalist','photo_journalist'),
	(403,'Photo-Retoucher','photo-retoucher'),
	(404,'Photographer','photographer'),
	(405,'Photography Editor','photography_editor'),
	(406,'Pirate','pirate'),
	(407,'Plastic Surgeon','plastic_surgeon'),
	(408,'Playwright','playwright'),
	(409,'Police & Legal Photographer','police_legal_photographer'),
	(410,'Police Sketch Artist','police_sketch_artist'),
	(411,'Production Assistant (P.A.)','production_assistant_pa'),
	(412,'Post-Production Assistant','post-production_assistant'),
	(413,'Post-Production Services','post-production_services'),
	(414,'Post-Production Supervisor','post-production_supervisor'),
	(415,'Producer','producer'),
	(416,'Producer\\S Assistant','producers_assistant'),
	(417,'Producer\\S Rep','producers_rep'),
	(418,'Producer Trans-Media','producer_trans-media'),
	(419,'Production Assistant','production_assistant'),
	(420,'Production Coordinator','production_coordinator'),
	(421,'Production Designer','production_designer'),
	(422,'Production Accountant','production_accountant'),
	(423,'Production Controller','production_controller'),
	(424,'Production Executive','production_executive'),
	(425,'Production Finance','production_finance'),
	(426,'Production Manager','production_manager'),
	(427,'Production Secretary','production_secretary'),
	(428,'Production Services','production_services'),
	(429,'Production Supervisor','production_supervisor'),
	(430,'Program Director','program_director'),
	(431,'Program Manager','program_manager'),
	(432,'Programming Assistant','programming_assistant'),
	(433,'Programming Associate','programming_associate'),
	(434,'Programming Director','programming_director'),
	(435,'Programmer','programmer'),
	(436,'Properties Manager','properties_manager'),
	(437,'Props','props'),
	(438,'Prop Maker','prop_maker'),
	(439,'Publicist','publicist'),
	(440,'Publicity Manager','publicity_manager'),
	(441,'Public Relations','public_relations'),
	(442,'Realtor','realtor'),
	(443,'Researcher','researcher'),
	(444,'Retail Sales','retail_sales'),
	(445,'Retail Store Owner','retail_store_owner'),
	(446,'Retail Store Sales Representative','retail_store_sales_representative'),
	(447,'Retail Store Sales Manager','retail_store_sales_manager'),
	(448,'Restaurant Host/Hostess','restaurant_host_hostess'),
	(449,'Restaurant Manager','restaurant_manager'),
	(450,'Restaurant Server','restaurant_server'),
	(451,'Reviewer','reviewer'),
	(452,'Roto/Paint Artist','roto_paint_artist'),
	(453,'Royalties Supervisor','royalties_supervisor'),
	(454,'Runner','runner'),
	(455,'Sales Agent','sales_agent'),
	(456,'Sales Manager','sales_manager'),
	(457,'Sales Representative','sales_representative'),
	(458,'Scenic Artist','scenic_artist'),
	(459,'School Administrator','school_administrator'),
	(460,'Scoring Engineer','scoring_engineer'),
	(461,'Scoring Stage Manager','scoring_stage_manager'),
	(462,'Screens Supervisor','screens_supervisor'),
	(463,'Screenwriter','screenwriter'),
	(464,'Script Doctor','script_doctor'),
	(465,'Script Supervisor','script_supervisor'),
	(466,'Second Assistant Director','second_assistant_director'),
	(467,'Second Unit Director','second_unit_director'),
	(468,'Security Guard','security_guard'),
	(469,'Senior Animator','senior_animator'),
	(470,'Service Industry Worker','service_industry_worker'),
	(471,'Set Costumer','set_costumer'),
	(472,'Set Decorator','set_decorator'),
	(473,'Set Designer','set_designer'),
	(474,'Set Dresser','set_dresser'),
	(475,'Set Medic','set_medic'),
	(476,'Set Production Assistant','set_production_assistant'),
	(477,'Show Runner','show_runner'),
	(478,'Singer','singer'),
	(479,'Sketch Artist','sketch_artist'),
	(480,'Social Media Concept Designer','social_media_concept_designer'),
	(481,'Social Media Consultant','social_media_consultant'),
	(482,'Social Media Specialist','social_media_specialist'),
	(483,'Social Media Strategist','social_media_strategist'),
	(484,'Software Developer','software_developer'),
	(485,'Software Engineer','software_engineer'),
	(486,'Sound Mixer','sound_mixer'),
	(487,'Sound Engineer','sound_engineer'),
	(488,'Sound Recordist','sound_recordist'),
	(489,'Sous Chef','sous_chef'),
	(490,'Special Effects Designer','special_effects_designer'),
	(491,'Special Effects Technician','special_effects_technician'),
	(492,'Subscription Manager','subscription_manager'),
	(493,'Stage Manager','stage_manager'),
	(494,'Stained-Glass Designer','stained-glass_designer'),
	(495,'Stand-In','stand-in'),
	(496,'Stand up Comedian','stand_up_comedian'),
	(497,'Steadi-Cam Operator','steadi-cam_operator'),
	(498,'Still Photographer','still_photographer'),
	(499,'Stonemason','stonemason'),
	(500,'Story Artist','story_artist'),
	(501,'Storyboard Artist','storyboard_artist'),
	(502,'Story Editor: Television','story_editor_television'),
	(503,'Structural Design Engineer','structural_design_engineer'),
	(504,'Student: High School Level','student_high_school_level'),
	(505,'Student: University Level','student_university_level'),
	(506,'Student: Graduate School Level','student_graduate_school_level'),
	(507,'Student: Doctoral Level','student_doctoral_level'),
	(508,'Studio Executive','studio_executive'),
	(509,'Stunt Coordinator','stunt_coordinator'),
	(510,'Stunt Director','stunt_director'),
	(511,'Stunt Person','stunt_person'),
	(512,'Stunt Performer','stunt_performer'),
	(513,'Stunt Double','stunt_double'),
	(514,'Stunt Supervisor','stunt_supervisor'),
	(515,'Stunt Rigger','stunt_rigger'),
	(516,'Stylist','stylist'),
	(517,'Systems Engineer','systems_engineer'),
	(518,'Tailor','tailor'),
	(519,'Talent Agency Account Executive','talent_agency_account_executive'),
	(520,'Talent Agency Assistant','talent_agency_assistant'),
	(521,'Talent Agency Associate','talent_agency_associate'),
	(522,'Talent Agency CEO','talent_agency_ceo'),
	(523,'Talent Agency CFO','talent_agency_cfo'),
	(524,'Talent Agency COO','talent_agency_coo'),
	(525,'Talent Agency CTO','talent_agency_cto'),
	(526,'Talent Agency Director','talent_agency_director'),
	(527,'Talent Agency Executive','talent_agency_executive'),
	(528,'Talent Agency Manager','talent_agency_manager'),
	(529,'Talent Agency President','talent_agency_president'),
	(530,'Talent Agency Principal','talent_agency_principal'),
	(531,'Talent Agency Vice-President','talent_agency_vice-president'),
	(532,'Talent Agent','talent_agent'),
	(533,'Talent Booking Agent','talent_booking_agent'),
	(534,'Talent Coordinator','talent_coordinator'),
	(535,'Talent Manager','talent_manager'),
	(536,'Talent Wrangler','talent_wrangler'),
	(537,'Talk Show Host','talk_show_host'),
	(538,'Tattoo Artist','tattoo_artist'),
	(539,'Taxidermist','taxidermist'),
	(540,'Technical Director','technical_director'),
	(541,'Technical Illustrator','technical_illustrator'),
	(542,'Technical Writer','technical_writer'),
	(543,'Textbook Author','textbook_author'),
	(544,'Textile Designer','textile_designer'),
	(545,'Theater Educator','theater_educator'),
	(546,'Theatrical Photographer','theatrical_photographer'),
	(547,'Third Assistant Director','third_assistant_director'),
	(548,'Ticket Services Director','ticket_services_director'),
	(549,'Titles/Graphics','titles_graphics'),
	(550,'Tool Designer','tool_designer'),
	(551,'Tour Guide','tour_guide'),
	(552,'Tour Manager','tour_manager'),
	(553,'Toy Designer','toy_designer'),
	(554,'Tracking Artist','tracking_artist'),
	(555,'Traditional Animator','traditional_animator'),
	(556,'Transportation Captain','transportation_captain'),
	(557,'Transportation Coordinator','transportation_coordinator'),
	(558,'Transportation Manager','transportation_manager'),
	(559,'Travel Agent','travel_agent'),
	(560,'Travel Industry Manager','travel_industry_manager'),
	(561,'Travel Industry Director','travel_industry_director'),
	(562,'Travel Photographer','travel_photographer'),
	(563,'TV Animator','tv_animator'),
	(564,'TV Background Artist','tv_background_artist'),
	(565,'TV Commercial Director','tv_commercial_director'),
	(566,'TV Executive','tv_executive'),
	(567,'TV Producer','tv_producer'),
	(568,'TV Series Director','tv_series_director'),
	(569,'TV Sitcom Director','tv_sitcom_director'),
	(570,'Type Designer','type_designer'),
	(571,'Typography Designer','typography_designer'),
	(572,'Union/Guild Rep','union_guild_rep'),
	(573,'Upholsterer','upholsterer'),
	(574,'Urban Planner','urban_planner'),
	(575,'User Experience Architect','user_experience_architect'),
	(576,'User Experience Designer','user_experience_designer'),
	(577,'VC Funding Partner/Principal','vc_funding_partner_principal'),
	(578,'Video Artist','video_artist'),
	(579,'Video Engineer','video_engineer'),
	(580,'Video Graphic Artist','video_graphic_artist'),
	(581,'Videographer','videographer'),
	(582,'Virtual Art Department Lead','virtual_art_department_lead'),
	(583,'Virtual Art Department Supervisor','virtual_art_department_supervisor'),
	(584,'Visual Aids Artist','visual_aids_artist'),
	(585,'Visual Effects Artist','visual_effects_artist'),
	(586,'Visual Effects Coordinator','visual_effects_coordinator'),
	(587,'Visual Effects Producer','visual_effects_producer'),
	(588,'Voice-Over Artist','voice-over_artist'),
	(589,'Wallpaper Designer','wallpaper_designer'),
	(590,'Wardrobe','wardrobe'),
	(591,'Weaver','weaver'),
	(592,'Web Analytics Analyst','web_analytics_analyst'),
	(593,'Web Application Designer','web_application_designer'),
	(594,'Web Content Publisher','web_content_publisher'),
	(595,'Web Developer','web_developer'),
	(596,'Web Designer','web_designer'),
	(597,'Web Developer/Architect','web_developer_architect'),
	(598,'Web/Flash Online Producer','web_flash_online_producer'),
	(599,'Web Page Designer','web_page_designer'),
	(600,'Window Decorator','window_decorator'),
	(601,'Woodcarver','woodcarver'),
	(602,'Writer','writer'),
	(603,'Art Therapist','art_therapist'),
	(604,'Dance Instructor','dance_instructor'),
	(605,'Diplomat','diplomat'),
	(606,'Government Employee','government_employee'),
	(607,'Librarian','librarian'),
	(608,'Librettist','librettist'),
	(609,'Lyricist','lyricist'),
	(610,'Music Instructor','music_instructor'),
	(611,'NGO Employee','ngo_employee'),
	(612,'Orchestra','orchestra'),
	(613,'Outreach Director','outreach_director'),
	(614,'Outreach Manager','outreach_manager'),
	(615,'Social Worker','social_worker'),
	(616,'Songwriter','songwriter'),
	(617,'Therapist','therapist'),
	(618,'Accounting Clerk','accounting_clerk'),
	(619,'Animal Handler','animal_handler'),
	(620,'Art Department Assistant','art_department_assistant'),
	(621,'Art Department Coordinator','art_department_coordinator'),
	(622,'Art Therapist','art_therapist'),
	(623,'Assistant','assistant'),
	(624,'Assistant Accountant','assistant_accountant'),
	(625,'Boom Operator','boom_operator'),
	(626,'Business Manager','business_manager'),
	(627,'Camera Loader','camera_loader'),
	(628,'Concept Artist','concept_artist'),
	(629,'Construction Coordinator','construction_coordinator'),
	(630,'Construction Electrician','construction_electrician'),
	(631,'Construction First Aid','construction_first_aid'),
	(632,'Construction Foreman','construction_foreman'),
	(633,'Construction Grip','construction_grip'),
	(634,'Construction Worker','construction_worker'),
	(635,'Dance Instructor','dance_instructor'),
	(636,'Dialogue Coach','dialogue_coach'),
	(637,'Diplomat','diplomat'),
	(638,'Driver','driver'),
	(639,'Dubbing Editor','dubbing_editor'),
	(640,'Editing Room Assistant','editing_room_assistant'),
	(641,'Extras Casting','extras_casting'),
	(642,'Festival Administrator','festival_administrator'),
	(643,'Festival Director','festival_director'),
	(644,'Festival Programmer','festival_programmer'),
	(645,'Festival Worker','festival_worker'),
	(646,'Financial Executive','financial_executive'),
	(647,'Financial Manager','financial_manager'),
	(648,'First Aid Worker','first_aid_worker'),
	(649,'Government Employee','government_employee'),
	(650,'Lab Technician','lab_technician'),
	(651,'Librarian','librarian'),
	(652,'Librettist','librettist'),
	(653,'Licensing Executive','licensing_executive'),
	(654,'Instructor','instructor'),
	(655,'NGO Employee','ngo_employee'),
	(656,'Office Coordinator','office_coordinator'),
	(657,'On-Set Dresser','on-set_dresser'),
	(658,'Orchestra','orchestra'),
	(659,'Outreach Director','outreach_director'),
	(660,'Outreach Manager','outreach_manager'),
	(661,'Partnership Developer','partnership_developer'),
	(662,'Payroll Accountant','payroll_accountant'),
	(663,'Personal Assistant','personal_assistant'),
	(664,'Picture Car Coordinator','picture_car_coordinator'),
	(665,'Picture Car Driver','picture_car_driver'),
	(666,'Picture Editor','picture_editor'),
	(667,'Production Accountant','production_accountant'),
	(668,'Projectionist','projectionist'),
	(669,'Property Master','property_master'),
	(670,'Props Builder','props_builder'),
	(671,'Sales Staff','sales_staff'),
	(672,'Set Staff Assistants','set_staff_assistants'),
	(673,'Set Strike Worker','set_strike_worker'),
	(674,'Social Worker','social_worker'),
	(675,'Songwriter','songwriter'),
	(676,'Standby Worker','standby_worker'),
	(677,'Stills Photographer','stills_photographer'),
	(678,'Studio Executive','studio_executive'),
	(679,'Swing Gang Worker','swing_gang_worker'),
	(680,'Tailor/Seamstress','tailor_seamstress'),
	(681,'Technical Advisor','technical_advisor'),
	(682,'Therapist','therapist'),
	(683,'Welfare Worker','welfare_worker'),
	(684,'Accounting Clerk','accounting_clerk'),
	(685,'Animal Handler','animal_handler'),
	(686,'Art Department Assistant','art_department_assistant'),
	(687,'Art Department Coordinator','art_department_coordinator'),
	(688,'Art Therapist','art_therapist'),
	(689,'Assistant','assistant'),
	(690,'Assistant Accountant','assistant_accountant'),
	(691,'Boom Operator','boom_operator'),
	(692,'Business Manager','business_manager'),
	(693,'Camera Loader','camera_loader'),
	(694,'Concept Artist','concept_artist'),
	(695,'Construction Coordinator','construction_coordinator'),
	(696,'Construction Electrician','construction_electrician'),
	(697,'Construction First Aid','construction_first_aid'),
	(698,'Construction Foreman','construction_foreman'),
	(699,'Construction Grip','construction_grip'),
	(700,'Construction Worker','construction_worker'),
	(701,'Dance Instructor','dance_instructor'),
	(702,'Dialogue Coach','dialogue_coach'),
	(703,'Diplomat','diplomat'),
	(704,'Driver','driver'),
	(705,'Dubbing Editor','dubbing_editor'),
	(706,'Editing Room Assistant','editing_room_assistant'),
	(707,'Extras Casting','extras_casting'),
	(708,'Financial Executive','financial_executive'),
	(709,'Financial Manager','financial_manager'),
	(710,'First Aid Worker','first_aid_worker'),
	(711,'Government Employee','government_employee'),
	(712,'Lab Technician','lab_technician'),
	(713,'Librarian','librarian'),
	(714,'Librettist','librettist'),
	(715,'Licensing Executive','licensing_executive'),
	(716,'Music Instructor','music_instructor'),
	(717,'NGO Employee','ngo_employee'),
	(718,'Office Coordinator','office_coordinator'),
	(719,'On-Set Dresser','on-set_dresser'),
	(720,'Orchestra','orchestra'),
	(721,'Outreach Director','outreach_director'),
	(722,'Outreach Manager','outreach_manager'),
	(723,'Partnership Developer','partnership_developer'),
	(724,'Payroll Accountant','payroll_accountant'),
	(725,'Personal Assistant','personal_assistant'),
	(726,'Picture Car Coordinator','picture_car_coordinator'),
	(727,'Picture Car Driver','picture_car_driver'),
	(728,'Picture Editor','picture_editor'),
	(729,'Production Accountant','production_accountant'),
	(730,'Projectionist','projectionist'),
	(731,'Property Master','property_master'),
	(732,'Props Builder','props_builder'),
	(733,'Sales Staff','sales_staff'),
	(734,'Set Staff Assistants','set_staff_assistants'),
	(735,'Set Strike Worker','set_strike_worker'),
	(736,'Social Worker','social_worker'),
	(737,'Songwriter','songwriter'),
	(738,'Standby Worker','standby_worker'),
	(739,'Stills Photographer','stills_photographer'),
	(740,'Studio Executive','studio_executive'),
	(741,'Swing Gang Worker','swing_gang_worker'),
	(742,'Tailor/Seamstress','tailor_seamstress'),
	(743,'Technical Advisor','technical_advisor'),
	(744,'Temp','temp'),
	(745,'Therapist','therapist'),
	(746,'Veterinarian','veterinarian'),
	(747,'Waiter','waiter'),
	(748,'Welfare Worker','welfare_worker'),
	(749,'Entrepreneur','entrepreneur'),
	(750,'Inventor','inventor'),
	(751,'Publisher','publisher'),
	(752,'Publishing','publishing'),
	(753,'Detective/Private-Eye','detective_private-eye'),
	(754,'Police Officer','police_officer');

/*!40000 ALTER TABLE `occupations` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table users_occupations
# ------------------------------------------------------------

DROP TABLE IF EXISTS `users_occupations`;

CREATE TABLE `users_occupations` (
  `user_id` int(11) DEFAULT NULL,
  `occupation_id` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;






/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
