# 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-21 09:07:12 -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 access_codes
# ------------------------------------------------------------

DROP TABLE IF EXISTS `access_codes`;

CREATE TABLE `access_codes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` int(5) DEFAULT NULL,
  `usage_limit` int(10) DEFAULT NULL,
  `created_at` date DEFAULT NULL,
  `expires_at` date DEFAULT NULL,
  `usage_count` int(10) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=94 DEFAULT CHARSET=latin1;

LOCK TABLES `access_codes` WRITE;
/*!40000 ALTER TABLE `access_codes` DISABLE KEYS */;
INSERT INTO `access_codes` (`id`,`code`,`usage_limit`,`created_at`,`expires_at`,`usage_count`)
VALUES
	(87,65591,1000,'2010-04-17','2010-05-17',1000),
	(88,88302,1000,'2010-04-17','2010-05-17',38),
	(89,57915,1000,'2010-04-13','2010-04-15',0),
	(90,64933,1000,'2010-04-17','2010-05-17',0),
	(91,12078,1000,'2010-04-17','2010-05-17',0),
	(92,24850,1000,'2010-04-17','2010-05-17',0),
	(93,58730,1000,'2010-04-17','2010-05-17',0);

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


# Dump of table descriptors
# ------------------------------------------------------------

DROP TABLE IF EXISTS `descriptors`;

CREATE TABLE `descriptors` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `label` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `approved` int(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=689 DEFAULT CHARSET=latin1;

LOCK TABLES `descriptors` WRITE;
/*!40000 ALTER TABLE `descriptors` DISABLE KEYS */;
INSERT INTO `descriptors` (`id`,`label`,`name`,`approved`)
VALUES
	(1,'202','202',1),
	(2,'206','206',1),
	(3,'212','212',1),
	(4,'303','303',1),
	(5,'305','305',1),
	(6,'310','310',1),
	(7,'312','312',1),
	(8,'323','323',1),
	(9,'415','415',1),
	(10,'504','504',1),
	(11,'512','512',1),
	(12,'520','520',1),
	(13,'612','612',1),
	(14,'615','615',1),
	(15,'718','718',1),
	(16,'617','617',1),
	(17,'818','818',1),
	(18,'917','917',1),
	(19,'Apolitical','apolitical',1),
	(20,'A Type','a_type',1),
	(21,'Above Average ','above_average',1),
	(22,'Academy Voter','academy_voter',1),
	(23,'Activist ','activist',1),
	(24,'Adaptable','adaptable',1),
	(25,'Adventurer','adventurer',1),
	(26,'Adventurous','adventurous',1),
	(27,'Aged','aged',1),
	(28,'Ageless','ageless',1),
	(29,'Agnostic','agnostic',1),
	(30,'Alternative','alternative',1),
	(31,'AMD Award Winner','amd_award_winner',1),
	(32,'Ambitious','ambitious',1),
	(33,'Amusing','amusing',1),
	(34,'Anal Retentive','anal_retentive',1),
	(35,'Analytical','analytical',1),
	(36,'Anglophile','anglophile',1),
	(37,'Animal Lover','animal_lover',1),
	(38,'Anti-Establishment','anti-establishment',1),
	(39,'Aquarius','aquarius',1),
	(40,'Argumentative','argumentative',1),
	(41,'Aries','aries',1),
	(42,'Arrogant','arrogant',1),
	(43,'Artist','artist',1),
	(44,'Art School Alum','art_school_alum',1),
	(45,'Asatru','asatru',1),
	(46,'Assertive','assertive',1),
	(47,'Atheist','atheist',1),
	(48,'Athlete','athlete',1),
	(49,'Average','average',1),
	(50,'Award Winner','award_winner',1),
	(51,'B Type','b_type',1),
	(52,'Baby Boomer','baby_boomer',1),
	(53,'Bahai','bahai',1),
	(54,'Beige','beige',1),
	(55,'Believer','believer',1),
	(56,'Below Average','below_average',1),
	(57,'Bible Belt','bible_belt',1),
	(58,'Bibliophile','bibliophile',1),
	(59,'Big Cheese','big_cheese',1),
	(60,'Big City','big_city',1),
	(61,'Big Time','big_time',1),
	(62,'Biker','biker',1),
	(63,'Bicoastal','bicoastal',1),
	(64,'Bisexual','bisexual',1),
	(65,'Black','black',1),
	(66,'Bleeding Heart Liberal','bleeding_heart_liberal',1),
	(67,'Blogger','blogger',1),
	(68,'Blue','blue',1),
	(69,'Blue Collar','blue_collar',1),
	(70,'Board Member','board_member',1),
	(71,'Bodacious','bodacious',1),
	(72,'Bohemian Club','bohemian_club',1),
	(73,'Book Worm','book_worm',1),
	(74,'Booker Prize Nominee','booker_prize_nominee',1),
	(75,'Booker Prize Winner','booker_prize_winner',1),
	(76,'Bored','bored',1),
	(77,'Bourgeoisie','bourgeoisie',1),
	(78,'Bossy','bossy',1),
	(79,'Brainstormer','brainstormer',1),
	(80,'Bridge and Tunnel','bridge_and_tunnel',1),
	(81,'Brown','brown',1),
	(82,'Buddhist','buddhist',1),
	(83,'Burning Man/Burner','burning_man_burner',1),
	(84,'Camper','camper',1),
	(85,'Cancer','cancer',1),
	(86,'Capricorn','capricorn',1),
	(87,'Car Enthusiast','car_enthusiast',1),
	(88,'Carnivore','carnivore',1),
	(89,'Cat Person','cat_person',1),
	(90,'Celebrity','celebrity',1),
	(91,'Conscious','conscious',1),
	(92,'Centered','centered',1),
	(93,'Centrist','centrist',1),
	(94,'Challenged','challenged',1),
	(95,'Change Agent','change_agent',1),
	(96,'Cheap','cheap',1),
	(97,'Cheap Date','cheap_date',1),
	(98,'Christian','christian',1),
	(99,'Christian Right','christian_right',1),
	(100,'Christian Scientist','christian_scientist',1),
	(101,'Cinephile','cinephile',1),
	(102,'City','city',1),
	(103,'Classless','classless',1),
	(104,'Classy','classy',1),
	(105,'Clio Award Nominee','clio_award_nominee',1),
	(106,'Clio Award Winner','clio_award_winner',1),
	(107,'Clueless','clueless',1),
	(108,'Coffee Lover','coffee_lover',1),
	(109,'Collaborator','collaborator',1),
	(110,'Collectivist','collectivist',1),
	(111,'College Educated','college_educated',1),
	(112,'Community Organizer','community_organizer',1),
	(113,'Communist','communist',1),
	(114,'Confucian','confucian',1),
	(115,'Concerned Citizen','concerned_citizen',1),
	(116,'Connector','connector',1),
	(117,'Conservative','conservative',1),
	(118,'Consistent','consistent',1),
	(119,'Contradictory','contradictory',1),
	(120,'Corporate','corporate',1),
	(121,'Coupled','coupled',1),
	(122,'Country','country',1),
	(123,'Crazy','crazy',1),
	(124,'Creative','creative',1),
	(125,'Critic\'s Choice Award Nominee','critics_choice_award_nominee',1),
	(126,'Critic\'s Choice Award Winner','critics_choice_award_winner',1),
	(127,'Cultured','cultured',1),
	(128,'Cyclist','cyclist',1),
	(129,'Cynical','cynical',1),
	(130,'Daddys Girl','daddys_girl',1),
	(131,'Dark Horse','dark_horse',1),
	(132,'DAR','dar',1),
	(133,'Dead Head','dead_head',1),
	(134,'Democrat','democrat',1),
	(135,'Dem X Award Winner','dem_x_award_winner',1),
	(136,'Dependent','dependent',1),
	(137,'Detail Oriented','detail_oriented',1),
	(138,'Direct','direct',1),
	(139,'Disabled','disabled',1),
	(140,'Discreet','discreet',1),
	(141,'Disorganized','disorganized',1),
	(142,'Disturbance','disturbance',1),
	(143,'Disturbed','disturbed',1),
	(144,'Divine Spirit','divine_spirit',1),
	(145,'Divorced','divorced',1),
	(146,'Do-Er','do-er',1),
	(147,'Dog Person','dog_person',1),
	(148,'Dolphin','dolphin',1),
	(149,'Dominatrix','dominatrix',1),
	(150,'Downtown','downtown',1),
	(151,'Drag Queen','drag_queen',1),
	(152,'Dreamer','dreamer',1),
	(153,'Drinker','drinker',1),
	(154,'Driven','driven',1),
	(155,'Dutiful','dutiful',1),
	(156,'East Coast','east_coast',1),
	(157,'East Side','east_side',1),
	(158,'Egoist','egoist',1),
	(159,'Emmy Award Nominee','emmy_award_nominee',1),
	(160,'Emmy Award Winner','emmy_award_winner',1),
	(161,'Enabler','enabler',1),
	(162,'Energetic','energetic',1),
	(163,'Engaged','engaged',1),
	(164,'Enlightened','enlightened',1),
	(165,'Enterprising','enterprising',1),
	(166,'Enthusiast','enthusiast',1),
	(167,'Epicurean','epicurean',1),
	(168,'Epigenist','epigenist',1),
	(169,'Episcopalian','episcopalian',1),
	(170,'Establishment','establishment',1),
	(171,'Eternal Student','eternal_student',1),
	(172,'Ethnic','ethnic',1),
	(173,'European','european',1),
	(174,'Euro Trash','euro_trash',1),
	(175,'Escapist','escapist',1),
	(176,'Evangelist','evangelist',1),
	(177,'Ex-Husband','ex-husband',1),
	(178,'Exceptional','exceptional',1),
	(179,'Ex-Pat','ex-pat',1),
	(180,'Experienced','experienced',1),
	(181,'Experimental','experimental',1),
	(182,'Extremist','extremist',1),
	(183,'Extreme Sports','extreme_sports',1),
	(184,'Ex-Wife','ex-wife',1),
	(185,'Executive','executive',1),
	(186,'Exuberant','exuberant',1),
	(187,'Facist','facist',1),
	(188,'Faithful','faithful',1),
	(189,'Fake','fake',1),
	(190,'Family Man','family_man',1),
	(191,'Family Person','family_person',1),
	(192,'Family Woman','family_woman',1),
	(193,'Feminist','feminist',1),
	(194,'Fan','fan',1),
	(195,'Fanatic','fanatic',1),
	(196,'Fancy','fancy',1),
	(197,'Fiery','fiery',1),
	(198,'Fighter','fighter',1),
	(199,'Film Festival Award Winner','film_festival_award_winner',1),
	(200,'First Born','first_born',1),
	(201,'Fisher','fisher',1),
	(202,'Flaky','flaky',1),
	(203,'Flexible','flexible',1),
	(204,'FOB','fob',1),
	(205,'Focused','focused',1),
	(206,'Foodie','foodie',1),
	(207,'Follower','follower',1),
	(208,'Foolish','foolish',1),
	(209,'Foreigner','foreigner',1),
	(210,'Forgetful','forgetful',1),
	(211,'Found','found',1),
	(212,'Forward Thinker','forward_thinker',1),
	(213,'Francophile','francophile',1),
	(214,'Fraternity','fraternity',1),
	(215,'Free Spirit','free_spirit',1),
	(216,'Friend','friend',1),
	(217,'Friendly','friendly',1),
	(218,'Futurist','futurist',1),
	(219,'Funny','funny',1),
	(220,'Gangsta','gangsta',1),
	(221,'Gardener','gardener',1),
	(222,'Gay','gay',1),
	(223,'Geek','geek',1),
	(224,'Gemini','gemini',1),
	(225,'Generous','generous',1),
	(226,'Genius','genius',1),
	(227,'Gentle','gentle',1),
	(228,'Genuine','genuine',1),
	(229,'Gen X-Er','gen_x-er',1),
	(230,'Gen Y-Er','gen_y-er',1),
	(231,'Giver','giver',1),
	(232,'Global Soul','global_soul',1),
	(233,'Golden Globe Award Nominee','golden_globe_award_nominee',1),
	(234,'Golden Globe Award Winner','golden_globe_award_winner',1),
	(235,'Golfer','golfer',1),
	(236,'Gracious','gracious',1),
	(237,'Gray','gray',1),
	(238,'Greco-Roman','greco-roman',1),
	(239,'Greek Orthodox','greek_orthodox',1),
	(240,'Green','green',1),
	(241,'Gregarious','gregarious',1),
	(242,'Groupie','groupie',1),
	(243,'Grunge','grunge',1),
	(244,'Guru','guru',1),
	(245,'Happy','happy',1),
	(246,'Hard Rock','hard_rock',1),
	(247,'Hard Worker','hard_worker',1),
	(248,'Hare Krishnan','hare_krishnan',1),
	(249,'Heavy Metal','heavy_metal',1),
	(250,'Hedonistic','hedonistic',1),
	(251,'Heterosexual','heterosexual',1),
	(252,'Hick','hick',1),
	(253,'High Energy','high_energy',1),
	(254,'High Maintenance','high_maintenance',1),
	(255,'High Profile','high_profile',1),
	(256,'Hiker','hiker',1),
	(257,'Hindu ','hindu_',1),
	(258,'Hip Hop','hip_hop',1),
	(259,'Hippie','hippie',1),
	(260,'Hipster','hipster',1),
	(261,'Hoarder','hoarder',1),
	(262,'Hobbyist','hobbyist',1),
	(263,'Hollywood','hollywood',1),
	(264,'Homebody','homebody',1),
	(265,'Homeboy','homeboy',1),
	(266,'Homegirl','homegirl',1),
	(267,'Home Wrecker','home_wrecker',1),
	(268,'Homosexual','homosexual',1),
	(269,'Honest','honest',1),
	(270,'Hopeful','hopeful',1),
	(271,'Hopeless','hopeless',1),
	(272,'Host','host',1),
	(273,'Hostess','hostess',1),
	(274,'Humanist','humanist',1),
	(275,'Humanitarian','humanitarian',1),
	(276,'Humble','humble',1),
	(277,'Husband','husband',1),
	(278,'Idea Generator','idea_generator',1),
	(279,'Idealist','idealist',1),
	(280,'Idiot Savant','idiot_savant',1),
	(281,'Immigrant','immigrant',1),
	(282,'Impatient','impatient',1),
	(283,'Inappropriate','inappropriate',1),
	(284,'Independent','independent',1),
	(285,'Indiscrete','indiscrete',1),
	(286,'Insider','insider',1),
	(287,'In Development','in_development',1),
	(288,'In Flight','in_flight',1),
	(289,'In Like','in_like',1),
	(290,'In Love','in_love',1),
	(291,'In Lust','in_lust',1),
	(292,'In Recovery','in_recovery',1),
	(293,'In the Box','in_the_box',1),
	(294,'Independent','independent',1),
	(295,'Intrusive','intrusive',1),
	(296,'Intuitive','intuitive',1),
	(297,'Inventive','inventive',1),
	(298,'Ivy Leaguer','ivy_leaguer',1),
	(299,'Jack-Of-All-Trades','jack-of-all-trades',1),
	(300,'Jainism','jainism',1),
	(301,'Jewish','jewish',1),
	(302,'Jew-Bu','jew-bu',1),
	(303,'Jewish American Princess','jewish_american_princess',1),
	(304,'Jewish American Prince','jewish_american_prince',1),
	(305,'Jill-Of-All-Trades','jill-of-all-trades',1),
	(306,'Job Seeker','job_seeker',1),
	(307,'Joiner','joiner',1),
	(308,'Joker','joker',1),
	(309,'Junkie','junkie',1),
	(310,'Junk Foodie','junk_foodie',1),
	(311,'King','king',1),
	(312,'Kosher','kosher',1),
	(313,'Leader','leader',1),
	(314,'Left Brained','left_brained',1),
	(315,'Leftist','leftist',1),
	(316,'Leo','leo',1),
	(317,'Lesbian','lesbian',1),
	(318,'Liberal','liberal',1),
	(319,'Libertarian','libertarian',1),
	(320,'Libra','libra',1),
	(321,'Life Mentor','life_mentor',1),
	(322,'Light Being','light_being',1),
	(323,'Living in Grace','living_in_grace',1),
	(324,'Living in Sin','living_in_sin',1),
	(325,'Loquacious','loquacious',1),
	(326,'Lost','lost',1),
	(327,'Lover','lover',1),
	(328,'Loyal','loyal',1),
	(329,'Lower Class','lower_class',1),
	(330,'Lustful','lustful',1),
	(331,'Lusty','lusty',1),
	(332,'Lutheran','lutheran',1),
	(333,'MacArthur Grant Award Winner','macarthur_grant_award_winner',1),
	(334,'Mad','mad',1),
	(335,'Magenta','magenta',1),
	(336,'Mainstream','mainstream',1),
	(337,'Majority','majority',1),
	(338,'Man Booker Prize Nominee','man_booker_prize_nominee',1),
	(339,'Man Booker Prize Winner','man_booker_prize_winner',1),
	(340,'Man Eater','man_eater',1),
	(341,'Monogamist','monogamist',1),
	(342,'Married','married',1),
	(343,'Martial Artist','martial_artist',1),
	(344,'Martyr','martyr',1),
	(345,'Mason/Masonic','mason_masonic',1),
	(346,'Maverick','maverick',1),
	(347,'Mayan','mayan',1),
	(348,'Mensa','mensa',1),
	(349,'Metropolitan','metropolitan',1),
	(350,'Middle America','middle_america',1),
	(351,'Middle Child','middle_child',1),
	(352,'Middle Class','middle_class',1),
	(353,'Midwestern','midwestern',1),
	(354,'Millennial','millennial',1),
	(355,'Minority','minority',1),
	(356,'Misandrist','misandrist',1),
	(357,'Misanthrope','misanthrope',1),
	(358,'Misogynist','misogynist',1),
	(359,'Momma\'s Boy','mommas_boy',1),
	(360,'Mormon','mormon',1),
	(361,'Multi Cultural','multi_cultural',1),
	(362,'Multi Tasker','multi_tasker',1),
	(363,'Musical','musical',1),
	(364,'Mystic','mystic',1),
	(365,'Naive','naive',1),
	(366,'Native','native',1),
	(367,'Narrow Minded','narrow_minded',1),
	(368,'Naturalist','naturalist',1),
	(369,'Nay Sayer','nay_sayer',1),
	(370,'Negative','negative',1),
	(371,'Neo-Conservative','neo-conservative',1),
	(372,'Neo-Paginist','neo-paginist',1),
	(373,'Neo-Phyte','neo-phyte',1),
	(374,'Nerd','nerd',1),
	(375,'Networker','networker',1),
	(376,'Next Big Thing','next_big_thing',1),
	(377,'New Age','new_age',1),
	(378,'Newlywed','newlywed',1),
	(379,'New York Driver','new_york_driver',1),
	(380,'Nobel Prize Nominee','nobel_prize_nominee',1),
	(381,'Nobel Prize Winner','nobel_prize_winner',1),
	(382,'Non-Believer','non-believer',1),
	(383,'Non-Conformist','non-conformist',1),
	(384,'Non-Denominational','non-denominational',1),
	(385,'Nouveau Riche','nouveau_riche',1),
	(386,'Nubile','nubile',1),
	(387,'Nudist','nudist',1),
	(388,'Objectivist','objectivist',1),
	(389,'Occupational School Alum','occupational_school_alum',1),
	(390,'OCD','ocd',1),
	(391,'Off the Grid','off_the_grid',1),
	(392,'Old School','old_school',1),
	(393,'Old Soul','old_soul',1),
	(394,'Olympic Medalist','olympic_medalist',1),
	(395,'Only Child','only_child',1),
	(396,'Open Armed','open_armed',1),
	(397,'Open Minded','open_minded',1),
	(398,'Open Sourced','open_sourced',1),
	(399,'Opinionated','opinionated',1),
	(400,'Optimist','optimist',1),
	(401,'Orange','orange',1),
	(402,'Orange Prize Nominee','orange_prize_nominee',1),
	(403,'Orange Prize Winner','orange_prize_winner',1),
	(404,'Organized','organized',1),
	(405,'Orthodox ','orthodox_',1),
	(406,'Oscar Nominated','oscar_nominated',1),
	(407,'Oscar Winner','oscar_winner',1),
	(408,'Over Achiever','over_achiever',1),
	(409,'Over Developed','over_developed',1),
	(410,'Over Educated','over_educated',1),
	(411,'Over Stimulated','over_stimulated',1),
	(412,'Overwhelmed','overwhelmed',1),
	(413,'Out of Love','out_of_love',1),
	(414,'Out of the Box','out_of_the_box',1),
	(415,'Out of Your Mind','out_of_your_mind',1),
	(416,'Outsider','outsider',1),
	(417,'Pacific Northwestern','pacific_northwestern',1),
	(418,'Pagan','pagan',1),
	(419,'Paint','paint',1),
	(420,'Painter','painter',1),
	(421,'Paranoid','paranoid',1),
	(422,'Parent','parent',1),
	(423,'Party Girl','party_girl',1),
	(424,'Party Boy','party_boy',1),
	(425,'Partier','partier',1),
	(426,'Partner','partner',1),
	(427,'Partnered','partnered',1),
	(428,'Passionate','passionate',1),
	(429,'Passive','passive',1),
	(430,'Passive Aggressive','passive_aggressive',1),
	(431,'Patient','patient',1),
	(432,'Patron of the Arts','patron_of_the_arts',1),
	(433,'Patronizing','patronizing',1),
	(434,'Peabody Award Nominee','peabody_award_nominee',1),
	(435,'Peabody Award Winner','peabody_award_winner',1),
	(436,'People Person','people_person',1),
	(437,'People\'s Choice Award Nominee','peoples_choice_award_nominee',1),
	(438,'People\'s Choice Award Winner','peoples_choice_award_winner',1),
	(439,'Persistant','persistant',1),
	(440,'Philanthropic','philanthropic',1),
	(441,'Philanthropist','philanthropist',1),
	(442,'Pilgrim','pilgrim',1),
	(443,'Pink','pink',1),
	(444,'Pioneer','pioneer',1),
	(445,'Pisces','pisces',1),
	(446,'Plain Spoken','plain_spoken',1),
	(447,'Plastic','plastic',1),
	(448,'Player','player',1),
	(449,'Poetic','poetic',1),
	(450,'Polite','polite',1),
	(451,'Political','political',1),
	(452,'Poor','poor',1),
	(453,'Poor but Happy','poor_but_happy',1),
	(454,'Pop Culture','pop_culture',1),
	(455,'Positive','positive',1),
	(456,'Posse','posse',1),
	(457,'Potential Employer','potential_employer',1),
	(458,'Power Broker','power_broker',1),
	(459,'Preppie','preppie',1),
	(460,'Private','private',1),
	(461,'Problem Solver','problem_solver',1),
	(462,'Procrastinator','procrastinator',1),
	(463,'Professional','professional',1),
	(464,'Prude','prude',1),
	(465,'Public','public',1),
	(466,'Psychic','psychic',1),
	(467,'Pulitzer Prize Nominee','pulitzer_prize_nominee',1),
	(468,'Pulitzer Prize Winner','pulitzer_prize_winner',1),
	(469,'Punk','punk',1),
	(470,'Punster','punster',1),
	(471,'Purist','purist',1),
	(472,'Puritan','puritan',1),
	(473,'Purple','purple',1),
	(474,'Pushy','pushy',1),
	(475,'Queen','queen',1),
	(476,'Queer','queer',1),
	(477,'Quiet','quiet',1),
	(478,'Random','random',1),
	(479,'Rap','rap',1),
	(480,'Rastafarian','rastafarian',1),
	(481,'Real','real',1),
	(482,'Realist','realist',1),
	(483,'Re-Constructionist','re-constructionist',1),
	(484,'Raconteur','raconteur',1),
	(485,'Real Simple','real_simple',1),
	(486,'Resourceful','resourceful',1),
	(487,'Red','red',1),
	(488,'Red Neck','red_neck',1),
	(489,'Reform','reform',1),
	(490,'Religious','religious',1),
	(491,'Republican','republican',1),
	(492,'Retired','retired',1),
	(493,'Revolutionary','revolutionary',1),
	(494,'Rich','rich',1),
	(495,'Rich but Miserable','rich_but_miserable',1),
	(496,'Right Brained','right_brained',1),
	(497,'Romantic','romantic',1),
	(498,'Rural','rural',1),
	(499,'Sadist','sadist',1),
	(500,'Sagittarius','sagittarius',1),
	(501,'Sarcastic','sarcastic',1),
	(502,'Scientologist','scientologist',1),
	(503,'Scorpio','scorpio',1),
	(504,'Seasoned','seasoned',1),
	(505,'Secret Society','secret_society',1),
	(506,'Seeker','seeker',1),
	(507,'Self-Absorbed','self-absorbed',1),
	(508,'Self-Aware','self-aware',1),
	(509,'Self-Deprecating','self-deprecating',1),
	(510,'Self-Sacrificing','self-sacrificing',1),
	(511,'Selfish','selfish',1),
	(512,'Sensitive','sensitive',1),
	(513,'Sensual','sensual',1),
	(514,'Separated','separated',1),
	(515,'Serial Jobber','serial_jobber',1),
	(516,'Sex-Ter','sex-ter',1),
	(517,'Sexual','sexual',1),
	(518,'Shark','shark',1),
	(519,'Shinto','shinto',1),
	(520,'Sikh','sikh',1),
	(521,'Silly','silly',1),
	(522,'Single','single',1),
	(523,'Single Dad','single_dad',1),
	(524,'Single Mom','single_mom',1),
	(525,'Single Parent','single_parent',1),
	(526,'Skater','skater',1),
	(527,'Skier','skier',1),
	(528,'Slacker','slacker',1),
	(529,'Slow Food Activist','slow_food_activist',1),
	(530,'Small Potatoes','small_potatoes',1),
	(531,'Small Town','small_town',1),
	(532,'Snob','snob',1),
	(533,'Snow Boarder','snow_boarder',1),
	(534,'Soft Rock','soft_rock',1),
	(535,'Sophisticate','sophisticate',1),
	(536,'Sorority','sorority',1),
	(537,'Spiritual','spiritual',1),
	(538,'Spouse ','spouse_',1),
	(539,'Social','social',1),
	(540,'Sociable','sociable',1),
	(541,'Socialite','socialite',1),
	(542,'Socialist','socialist',1),
	(543,'Socially Conscious','socially_conscious',1),
	(544,'Southern','southern',1),
	(545,'State School Alum','state_school_alum',1),
	(546,'Stiff Upper Lip','stiff_upper_lip',1),
	(547,'Stingy','stingy',1),
	(548,'Stoic','stoic',1),
	(549,'Stoner','stoner',1),
	(550,'Storyteller','storyteller',1),
	(551,'Straight','straight',1),
	(552,'Straight Arrow','straight_arrow',1),
	(553,'Straight Laced','straight_laced',1),
	(554,'Street','street',1),
	(555,'Submissive','submissive',1),
	(556,'Suburban','suburban',1),
	(557,'Sugar Daddy','sugar_daddy',1),
	(558,'Sugar Momma','sugar_momma',1),
	(559,'Sugar Person','sugar_person',1),
	(560,'Super Hero','super_hero',1),
	(561,'Super Man','super_man',1),
	(562,'Super Woman','super_woman',1),
	(563,'Superstitious','superstitious',1),
	(564,'Survivor','survivor',1),
	(565,'Sweet','sweet',1),
	(566,'Sweet Tooth','sweet_tooth',1),
	(567,'Swimmer','swimmer',1),
	(568,'Swinger','swinger',1),
	(569,'Taker','taker',1),
	(570,'Talented','talented',1),
	(571,'Tan','tan',1),
	(572,'Tantric','tantric',1),
	(573,'Taoist','taoist',1),
	(574,'Tattooed','tattooed',1),
	(575,'Taurus','taurus',1),
	(576,'Tea Lover','tea_lover',1),
	(577,'Techie','techie',1),
	(578,'Techignorati','techignorati',1),
	(579,'Ted','ted',1),
	(580,'Ted Groupie','ted_groupie',1),
	(581,'Ted Member','ted_member',1),
	(582,'Ted Prize Winner','ted_prize_winner',1),
	(583,'Tee Totaler','tee_totaler',1),
	(584,'Text-Er','text-er',1),
	(585,'Thriving','thriving',1),
	(586,'Tone','tone',1),
	(587,'Tony Award Nominee','tony_award_nominee',1),
	(588,'Tony Award Winner','tony_award_winner',1),
	(589,'Traditionalist','traditionalist',1),
	(590,'Transgender','transgender',1),
	(591,'Transparent','transparent',1),
	(592,'Transplant','transplant',1),
	(593,'Trend Setter','trend_setter',1),
	(594,'Tribal','tribal',1),
	(595,'Triplet','triplet',1),
	(596,'Truth Seeker','truth_seeker',1),
	(597,'Tweeter','tweeter',1),
	(598,'Twin','twin',1),
	(599,'The Greatest Generation','the_greatest_generation',1),
	(600,'Under Achiever','under_achiever',1),
	(601,'Under Aged','under_aged',1),
	(602,'Under Educated','under_educated',1),
	(603,'Under Employed','under_employed',1),
	(604,'Underground','underground',1),
	(605,'Underground Artist','underground_artist',1),
	(606,'Unemployed','unemployed',1),
	(607,'Unfocused','unfocused',1),
	(608,'Unpopular','unpopular',1),
	(609,'Unitarian','unitarian',1),
	(610,'Uptown','uptown',1),
	(611,'Urban','urban',1),
	(612,'Urban Farmer','urban_farmer',1),
	(613,'Used','used',1),
	(614,'User','user',1),
	(615,'Valley Girl','valley_girl',1),
	(616,'Valley Guy','valley_guy',1),
	(617,'Vegan','vegan',1),
	(618,'Vegetarian','vegetarian',1),
	(619,'Virgo','virgo',1),
	(620,'Volunteer','volunteer',1),
	(621,'Voyeuristic','voyeuristic',1),
	(622,'Web Guru','web_guru',1),
	(623,'Wanderer','wanderer',1),
	(624,'Wacky','wacky',1),
	(625,'Warrior','warrior',1),
	(626,'Webby Award Nominee','webby_award_nominee',1),
	(627,'Webby Award Winner','webby_award_winner',1),
	(628,'Weird','weird',1),
	(629,'Well Adjusted','well_adjusted',1),
	(630,'Well Endowed','well_endowed',1),
	(631,'Well Meaning','well_meaning',1),
	(632,'Well Maintained','well_maintained',1),
	(633,'Well Read','well_read',1),
	(634,'Well Rounded','well_rounded',1),
	(635,'Well Traveled','well_traveled',1),
	(636,'West Coast','west_coast',1),
	(637,'West Side','west_side',1),
	(638,'White','white',1),
	(639,'White Collar','white_collar',1),
	(640,'White Trash','white_trash',1),
	(641,'Widower','widower',1),
	(642,'Wiccan','wiccan',1),
	(643,'Wife','wife',1),
	(644,'Wild','wild',1),
	(645,'Wise','wise',1),
	(646,'Womanizer','womanizer',1),
	(647,'Wonder Woman','wonder_woman',1),
	(648,'Worker Bee','worker_bee',1),
	(649,'Working Class','working_class',1),
	(650,'Worldly','worldly',1),
	(651,'World Citizen','world_citizen',1),
	(652,'World Traveler','world_traveler',1),
	(653,'Yellow','yellow',1),
	(654,'Year of the Rat','year_of_the_rat',1),
	(655,'Year of the Dog ','year_of_the_dog',1),
	(656,'Year of the Rooster','year_of_the_rooster',1),
	(657,'Year of the Monkey','year_of_the_monkey',1),
	(658,'Year of the Goat ','year_of_the_goat',1),
	(659,'Year of the Horse ','year_of_the_horse',1),
	(660,'Year of the Snake ','year_of_the_snake',1),
	(661,'Year of the Dragon','year_of_the_dragon',1),
	(662,'Year of the Rabbit ','year_of_the_rabbit',1),
	(663,'Year of the Tiger ','year_of_the_tiger',1),
	(664,'Year of the Ox ','year_of_the_ox',1),
	(665,'Year of the Pig','year_of_the_pig',1),
	(666,'Youngest Child','youngest_child',1),
	(667,'Youthful','youthful',1),
	(668,'Yuppie','yuppie',1),
	(669,'Xenophile','xenophile',1),
	(670,'Zen Master','zen_master',1),
	(671,'Zoroastrian','zoroastrian',1),
	(685,'Murder','murder',0),
	(686,'Being Creepy','being_creepy',0),
	(684,'Killing','killing',0),
	(687,'','',0),
	(688,'','',0);

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


# Dump of table ethnicities
# ------------------------------------------------------------

DROP TABLE IF EXISTS `ethnicities`;

CREATE TABLE `ethnicities` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `label` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `approved` int(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=144 DEFAULT CHARSET=latin1;

LOCK TABLES `ethnicities` WRITE;
/*!40000 ALTER TABLE `ethnicities` DISABLE KEYS */;
INSERT INTO `ethnicities` (`id`,`label`,`name`,`approved`)
VALUES
	(1,'Aborigine','aborigine',1),
	(2,'Afghani','afghani',1),
	(3,'African ','african',1),
	(4,'Alaska Native','alaska_native',1),
	(5,'Albanian','albanian',1),
	(6,'Algerian','algerian',1),
	(7,'American','american',1),
	(8,'Anglo','anglo',1),
	(9,'Argentinean','argentinean',1),
	(10,'Armenian','armenian',1),
	(11,'Asian','asian',1),
	(12,'Arab','arab',1),
	(13,'Australian','australian',1),
	(14,'Austrian','austrian',1),
	(15,'Bahamian','bahamian',1),
	(16,'Balinese','balinese',1),
	(17,'Balkan','balkan',1),
	(18,'Baltic','baltic',1),
	(19,'Basque','basque',1),
	(20,'Black','black',1),
	(21,'Brazilian','brazilian',1),
	(22,'Bolivian','bolivian',1),
	(23,'Bosnian','bosnian',1),
	(24,'British','british',1),
	(25,'Burmese','burmese',1),
	(26,'Cambodian','cambodian',1),
	(27,'Canadian','canadian',1),
	(28,'Cape Verdian','cape_verdian',1),
	(29,'Caribbean','caribbean',1),
	(30,'Caucasian','caucasian',1),
	(31,'Central American','central_american',1),
	(32,'Chicano','chicano',1),
	(33,'Chicana','chicana',1),
	(34,'Chilean','chilean',1),
	(35,'Chinese','chinese',1),
	(36,'Colombian','colombian',1),
	(37,'Congo','congo',1),
	(38,'Costa Rican','costa_rican',1),
	(39,'Cuban','cuban',1),
	(40,'Croatian','croatian',1),
	(41,'Czech','czech',1),
	(42,'Dominican','dominican',1),
	(43,'Dutch','dutch',1),
	(44,'East African','east_african',1),
	(45,'Eastern European','eastern_european',1),
	(46,'English','english',1),
	(47,'Ecuadorian','ecuadorian',1),
	(48,'Ethnic','ethnic',1),
	(49,'Fijian','fijian',1),
	(50,'Finnish','finnish',1),
	(51,'French','french',1),
	(52,'Georgian','georgian',1),
	(53,'German','german',1),
	(54,'Greek','greek',1),
	(55,'Guamanian','guamanian',1),
	(56,'Guatemalan','guatemalan',1),
	(57,'Hispanic','hispanic',1),
	(58,'Hmong','hmong',1),
	(59,'Hungarian','hungarian',1),
	(60,'Indian','indian',1),
	(61,'Indonesian','indonesian',1),
	(62,'Iranian','iranian',1),
	(63,'Iraqi','iraqi',1),
	(64,'Irish','irish',1),
	(65,'Israeli','israeli',1),
	(66,'Italian','italian',1),
	(67,'Japanese','japanese',1),
	(68,'Jewish','jewish',1),
	(69,'Korean','korean',1),
	(70,'Kurdish','kurdish',1),
	(71,'Laotian','laotian',1),
	(72,'Latino','latino',1),
	(73,'Latina','latina',1),
	(74,'Latin American','latin_american',1),
	(75,'Liberian','liberian',1),
	(76,'Columbian','columbian',1),
	(77,'Libyan','libyan',1),
	(78,'Filipino','filipino',1),
	(79,'Macedonian','macedonian',1),
	(80,'Malay','malay',1),
	(81,'Maori','maori',1),
	(82,'Mauritian','mauritian',1),
	(83,'Mexican','mexican',1),
	(84,'Middle Eastern','middle_eastern',1),
	(85,'Mixed Race','mixed_race',1),
	(86,'Mongolian','mongolian',1),
	(87,'Moroccan','moroccan',1),
	(88,'Mutt','mutt',1),
	(89,'Nepalese','nepalese',1),
	(90,'Nicaraguan','nicaraguan',1),
	(91,'North African','north_african',1),
	(92,'Native American','native_american',1),
	(93,'Native Hawaiian','native_hawaiian',1),
	(94,'New Zealander/Kiwi','new_zealander_kiwi',1),
	(95,'North American','north_american',1),
	(96,'Pacific Islander','pacific_islander',1),
	(97,'Pakistani','pakistani',1),
	(98,'Palestinian','palestinian',1),
	(99,'Persian','persian',1),
	(100,'Peruvian','peruvian',1),
	(101,'Polish','polish',1),
	(102,'Puerto Rican','puerto_rican',1),
	(103,'Russian','russian',1),
	(104,'Rwandan','rwandan',1),
	(105,'Salvadoran','salvadoran',1),
	(106,'Saudi','saudi',1),
	(107,'Scotts Irish','scotts_irish',1),
	(108,'Scottish','scottish',1),
	(109,'Siberian','siberian',1),
	(110,'Somali','somali',1),
	(111,'South African','south_african',1),
	(112,'South Asian','south_asian',1),
	(113,'South Korean','south_korean',1),
	(114,'Spanish','spanish',1),
	(115,'Swedish','swedish',1),
	(116,'Swiss','swiss',1),
	(117,'Syrian','syrian',1),
	(118,'Taiwanese','taiwanese',1),
	(119,'Thai','thai',1),
	(120,'Tibetan','tibetan',1),
	(121,'Tongan','tongan',1),
	(122,'Turkish','turkish',1),
	(123,'Ukrainian','ukrainian',1),
	(124,'Vietnamese','vietnamese',1),
	(125,'Welsh','welsh',1),
	(126,'West African','west_african',1),
	(127,'White','white',1),
	(141,'Blackenese','blackenese',0),
	(140,'Fligger','fligger',0),
	(142,'','',0),
	(143,'','',0);

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


# 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,
  `approved` int(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=771 DEFAULT CHARSET=latin1;

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

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


# Dump of table users
# ------------------------------------------------------------

DROP TABLE IF EXISTS `users`;

CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fname` varchar(255) DEFAULT NULL,
  `mname` varchar(255) DEFAULT NULL,
  `lname` varchar(255) DEFAULT NULL,
  `age` int(3) DEFAULT NULL,
  `sex` varchar(11) DEFAULT NULL,
  `address1` varchar(255) DEFAULT NULL,
  `address2` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `zip` int(5) DEFAULT NULL,
  `country` varchar(2) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `salt` varchar(255) DEFAULT NULL,
  `crypted_password` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone_type` varchar(100) DEFAULT NULL,
  `country_code` varchar(3) DEFAULT NULL,
  `area_code` int(5) DEFAULT NULL,
  `number` int(10) DEFAULT NULL,
  `extension` int(10) DEFAULT NULL,
  `participate` int(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=124 DEFAULT CHARSET=latin1;



# Dump of table users_access_codes
# ------------------------------------------------------------

DROP TABLE IF EXISTS `users_access_codes`;

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

LOCK TABLES `users_access_codes` WRITE;
/*!40000 ALTER TABLE `users_access_codes` DISABLE KEYS */;
INSERT INTO `users_access_codes` (`user_id`,`access_code_id`)
VALUES
	(120,88),
	(121,88);

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


# Dump of table users_descriptors
# ------------------------------------------------------------

DROP TABLE IF EXISTS `users_descriptors`;

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

LOCK TABLES `users_descriptors` WRITE;
/*!40000 ALTER TABLE `users_descriptors` DISABLE KEYS */;
INSERT INTO `users_descriptors` (`user_id`,`descriptor_id`)
VALUES
	(120,11),
	(120,36),
	(120,48),
	(121,11),
	(121,36),
	(121,48);

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


# Dump of table users_ethnicities
# ------------------------------------------------------------

DROP TABLE IF EXISTS `users_ethnicities`;

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

LOCK TABLES `users_ethnicities` WRITE;
/*!40000 ALTER TABLE `users_ethnicities` DISABLE KEYS */;
INSERT INTO `users_ethnicities` (`user_id`,`ethnicity_id`)
VALUES
	(120,2),
	(120,3),
	(121,2),
	(121,3);

/*!40000 ALTER TABLE `users_ethnicities` 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;

LOCK TABLES `users_occupations` WRITE;
/*!40000 ALTER TABLE `users_occupations` DISABLE KEYS */;
INSERT INTO `users_occupations` (`user_id`,`occupation_id`)
VALUES
	(120,2),
	(120,3),
	(121,2),
	(121,3);

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





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