-- MySQL dump 10.10
--
-- Host: miscdbs.3edges.org    Database: hobos
-- ------------------------------------------------------
-- Server version	5.0.18-standard-log

/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!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 */;

--
-- Table structure for table `hobos_to_tags`
--

DROP TABLE IF EXISTS `hobos_to_tags`;
CREATE TABLE `hobos_to_tags` (
  `id` int(11) NOT NULL auto_increment,
  `hobo_id` int(11) NOT NULL,
  `tag_id` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `hobos_to_tags`
--


/*!40000 ALTER TABLE `hobos_to_tags` DISABLE KEYS */;
LOCK TABLES `hobos_to_tags` WRITE;
INSERT INTO `hobos_to_tags` VALUES (1,1,1),(2,1,2),(3,1,3),(4,1,4),(5,1,5),(6,1,6),(7,2,7),(8,2,8),(9,2,1),(10,2,9),(11,2,4),(12,3,4),(13,3,10),(14,3,11),(15,3,1),(16,3,8),(17,3,3),(18,3,12),(19,4,13),(20,4,10),(21,4,14),(22,4,15),(23,5,4),(24,5,16),(25,5,17),(26,5,18),(27,5,19),(28,6,4),(29,6,16),(30,6,20),(31,6,21),(32,6,17),(33,6,18),(34,6,22),(35,7,23),(36,7,24),(37,7,4),(38,7,25),(39,7,26),(40,8,4),(41,8,10),(42,8,14),(43,8,27),(44,8,15),(45,9,28),(46,9,4),(47,9,20),(48,9,7),(49,9,8),(50,9,21),(51,9,29),(52,9,30),(53,9,31),(54,9,32),(55,10,20),(56,10,5),(57,10,33),(58,11,34),(59,11,16),(60,11,35),(61,11,36),(62,12,4),(63,12,37),(64,12,20),(65,12,38),(66,12,7),(67,13,39),(68,13,40),(69,13,41),(70,14,13),(71,14,42),(72,14,43),(73,15,30),(74,15,44),(75,15,45),(76,15,46),(77,15,47),(78,15,20),(79,15,32),(80,16,6),(81,16,48),(82,17,49),(83,17,41),(84,17,48),(85,18,8),(86,18,50),(87,18,4),(88,18,16),(89,19,5),(90,19,10),(91,19,14),(92,19,51),(93,19,1),(94,19,4),(95,19,20),(96,19,8),(97,19,15),(98,20,20),(99,20,36),(100,20,52),(101,20,32),(102,21,23),(103,21,27),(104,21,4),(105,21,42),(106,21,53),(107,22,4),(108,22,10),(109,22,54),(110,22,20),(111,22,14),(112,22,7),(113,23,4),(114,23,30),(115,23,55),(116,23,32),(117,24,4),(118,24,30),(119,24,56),(120,24,57),(121,24,33),(122,24,40),(123,24,32),(124,25,4),(125,25,58),(126,25,59),(127,25,49),(128,25,32),(129,26,20),(130,27,13),(131,27,60),(132,27,33),(133,28,4),(134,28,42),(135,28,61),(136,29,5),(137,29,33),(138,29,9),(139,29,3),(140,29,4),(141,29,62),(142,29,63),(143,29,64),(144,29,65),(145,29,66),(146,30,23),(147,30,20),(148,30,5),(149,30,3),(150,31,10),(151,31,14),(152,32,4),(153,32,55),(154,32,30),(155,32,8),(156,32,32),(157,33,6),(158,33,67),(159,33,5),(160,34,23),(161,34,4),(162,34,68),(163,34,69),(164,35,8),(165,35,70),(166,35,16),(167,35,71),(168,35,30),(169,35,72),(170,35,73),(171,36,30),(172,36,47),(173,36,57),(174,36,74),(175,37,8),(176,37,75),(177,37,16),(178,37,49),(179,37,76),(180,38,8),(181,38,4),(182,38,48),(183,38,5),(184,38,33),(185,39,5),(186,39,27),(187,39,20),(188,39,33),(189,39,77),(190,40,78),(191,40,4),(192,40,73),(193,40,79),(194,41,4),(195,41,60),(196,41,18),(197,42,4),(198,42,60),(199,42,18),(200,43,4),(201,43,8),(202,43,60),(203,43,80),(204,43,81),(205,44,18),(206,44,20),(207,44,82),(208,44,83),(209,45,33),(210,45,77),(211,45,4),(212,45,20),(213,45,5),(214,45,84),(215,46,84),(216,46,3),(217,46,8),(218,46,4),(219,46,1),(220,46,65),(221,46,66),(222,47,23),(223,47,85),(224,47,3),(225,47,1),(226,47,6),(227,47,8),(228,47,4),(229,47,86),(230,47,36),(231,47,58),(232,47,39),(233,48,4),(234,48,82),(235,48,18),(236,48,39),(237,49,4),(238,49,82),(239,49,18),(240,49,39),(241,50,4),(242,50,82),(243,50,18),(244,50,39),(245,50,49),(246,50,87),(247,51,20),(248,51,8),(249,51,82),(250,51,18),(251,51,39),(252,51,88),(253,51,10),(254,51,14),(255,51,89),(256,52,18),(257,52,10),(258,52,14),(259,52,82),(260,52,39),(261,53,25),(262,53,90),(263,53,36),(264,54,16),(265,54,91),(266,54,92),(267,54,93),(268,55,8),(269,55,3),(270,55,65),(271,55,53),(272,56,8),(273,56,48),(274,56,41),(275,56,49),(276,57,18),(277,57,21),(278,57,94),(279,57,4),(280,57,95),(281,57,22),(282,57,96),(283,57,8),(284,57,32),(285,58,4),(286,58,20),(287,58,18),(288,58,28),(289,58,22),(290,58,33),(291,58,49),(292,58,97),(293,59,33),(294,59,4),(295,59,20),(296,59,98),(297,60,78),(298,60,86),(299,60,10),(300,60,14),(301,60,1),(302,60,15),(303,61,4),(304,61,99),(305,61,57),(306,61,16),(307,61,100),(308,61,32),(309,62,27),(310,62,4),(311,62,20),(312,62,29),(313,62,32),(314,63,62),(315,63,93),(316,63,4),(317,63,16),(318,63,72),(319,63,5),(320,63,33),(321,63,8),(322,63,2),(323,64,23),(324,64,24),(325,64,8),(326,64,16),(327,64,101),(328,64,97),(329,64,41),(330,65,52),(331,65,30),(332,65,63),(333,65,32),(334,66,10),(335,66,11),(336,66,15),(337,67,8),(338,67,20),(339,67,16),(340,67,102),(341,67,1),(342,68,2),(343,68,4),(344,69,63),(345,69,103),(346,69,36),(347,69,4),(348,69,98),(349,70,20),(350,70,97),(351,70,66),(352,71,4),(353,71,65),(354,71,3),(355,71,60),(356,72,60),(357,72,28),(358,72,8),(359,72,1),(360,72,104),(361,73,10),(362,73,14),(363,73,8),(364,73,21),(365,73,82),(366,73,15),(367,74,8),(368,74,63),(369,74,12),(370,74,105),(371,74,3),(372,74,82),(373,74,106),(374,75,50),(375,76,23),(376,76,68),(377,76,10),(378,76,14),(379,77,20),(380,77,107),(381,77,64),(382,77,15),(383,78,4),(384,78,108),(385,78,32),(386,79,36),(387,79,109),(388,80,4),(389,80,2),(390,80,8),(391,80,72),(392,80,110),(393,80,15),(394,81,4),(395,81,36),(396,81,40),(397,82,20),(398,82,111),(399,82,46),(400,82,32),(401,83,49),(402,83,4),(403,84,8),(404,84,4),(405,84,1),(406,84,93),(407,85,20),(408,85,112),(409,86,10),(410,86,11),(411,86,15),(412,86,33),(413,86,18),(414,87,10),(415,87,11),(416,87,15),(417,87,103),(418,87,18),(419,88,23),(420,88,24),(421,88,113),(422,88,57),(423,88,27),(424,89,10),(425,89,110),(426,89,89),(427,89,2),(428,89,54),(429,90,16),(430,90,72),(431,90,2),(432,90,4),(433,90,114),(434,91,8),(435,91,82),(436,91,76),(437,91,9),(438,91,5),(439,91,33),(440,91,3),(441,92,10),(442,92,14),(443,93,63),(444,93,7),(445,93,33),(446,93,73),(447,93,98),(448,94,4),(449,94,23),(450,94,115),(451,94,30),(452,94,58),(453,95,112),(454,96,20),(455,96,7),(456,96,112),(457,97,4),(458,97,112),(459,98,29),(460,98,32),(461,98,57),(462,98,20),(463,98,116),(464,99,8),(465,99,28),(466,99,98),(467,100,8),(468,100,27),(469,100,4),(470,100,15),(471,100,34),(472,101,3),(473,101,105),(474,101,4),(475,101,107),(476,102,10),(477,102,49),(478,102,110),(479,102,15),(480,103,50),(481,103,13),(482,103,5),(483,103,86),(484,103,1),(485,104,98),(486,104,4),(487,105,20),(488,105,112),(489,106,20),(490,106,94),(491,106,96),(492,107,4),(493,107,7),(494,107,112),(495,108,70),(496,108,4),(497,108,117),(498,108,118),(499,108,11),(500,108,10),(501,109,119),(502,109,29),(503,109,32),(504,109,69),(505,109,62),(506,110,20),(507,110,49),(508,110,107),(509,110,120),(510,110,121),(511,111,4),(512,111,20),(513,111,42),(514,111,122),(515,112,48),(516,112,4),(517,112,123),(518,112,2),(519,113,4),(520,113,20),(521,113,112),(522,114,112),(523,114,124),(524,115,20),(525,115,27),(526,115,76),(527,116,4),(528,116,20),(529,116,5),(530,116,65),(531,116,66),(532,117,66),(533,117,4),(534,117,30),(535,117,125),(536,118,23),(537,118,124),(538,118,126),(539,118,127),(540,119,4),(541,119,63),(542,119,29),(543,119,128),(544,119,32),(545,119,107),(546,120,18),(547,120,129),(548,120,20),(549,121,18),(550,121,129),(551,121,20),(552,122,18),(553,122,129),(554,122,20),(555,123,18),(556,123,129),(557,123,20),(558,124,18),(559,124,129),(560,124,49),(561,125,15),(562,125,34),(563,125,124),(564,125,10),(565,125,110);
UNLOCK TABLES;
/*!40000 ALTER TABLE `hobos_to_tags` ENABLE KEYS */;

--
-- Table structure for table `names`
--

DROP TABLE IF EXISTS `names`;
CREATE TABLE `names` (
  `id` int(11) NOT NULL,
  `name` varchar(200) NOT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `names`
--


/*!40000 ALTER TABLE `names` DISABLE KEYS */;
LOCK TABLES `names` WRITE;
INSERT INTO `names` VALUES (1,'Stewbuilder Dennis'),(2,'Cholly the Yegg'),(3,'Holden the Expert Dreamtwister'),(4,'The Rza'),(5,'Jack Skunk'),(6,'Jack Skunk Fils'),(7,'Lord Dan X. Still-Standing'),(8,'Marlon Fitz-fancy'),(9,'Bazino Bazino, The Kid Whose Hair Is On Fire'),(10,'Whispering-Lies McGruder'),(11,'Nit Louse'),(12,'Dan\'l Dinsmore Tackadoo'),(13,'Hobo Zero'),(14,'The Silver Jacket Man'),(15,'No-Shoulders Smalltooth Jones'),(16,'Sistery Brothery Nabob'),(17,'Name Withheld'),(18,'Staniel the Spaniel'),(19,'Frederick Bannister, the Tree Surgeon'),(20,'Tarnose Cohen'),(21,'Mr. Wilson Fancypants'),(22,'Floyd Dangle'),(23,'Shane Stoopback'),(24,'Wicked Paul Fourteen-Toes'),(25,'Normal-Face Olaf'),(26,'Tearbaby Hannity Stoop'),(27,'The Damned Swede'),(28,'Pierre Tin-Hat'),(29,'Ol\' Barb Stab-You-Quick'),(30,'Mr. Whist'),(31,'James Fenimore Cooper'),(32,'Twistback John, the Scoliosis Sufferer'),(33,'Sweet Daddy Champagne'),(34,'Senator Cletus Scoffpossum'),(35,'Horus, the Bird-Headed Fool'),(36,'50-Tooth Slim'),(37,'Monk, the Monkey Man (which is to say: \"the Man\")'),(38,'Thad the Bunter'),(39,'Balloonpopper Chillingsworth'),(40,'All-but-Dissertation Tucker Dummychuck'),(41,'Finnish Jim'),(42,'Flemish Jim'),(43,'Foreign Tomas, the Strangetalker'),(44,'Roadhouse Ogilvy and Sons'),(45,'Jokestealer John Selden'),(46,'Giancarlo, Master of the Metal Trapeze'),(47,'Dr. Bill Stain-Chin, the Boxcar Medic'),(48,'Boxcar Ted'),(49,'Boxcar Mick'),(50,'Boxcars [sic] Timothy Twin'),(51,'Boxcar Jones, the Boxcar Benjamin Disraeli'),(52,'Boxcar Aldous Huxley'),(53,'JR Lintstockings'),(54,'Gila Monster Jr.'),(55,'Irontrousers the Strong'),(56,'\"X,\" the Anonymous Man or Woman'),(57,'Orphaned Reynaldo, the Child with Haunting Eyes'),(58,'Reynaldo Reynaldoson, Who Will One Day Kill His Father'),(59,'Thoughtless Harry Hsu'),(60,'Clinical Psychiatrist Hugo Rivera'),(61,'Peter Ox-Hands'),(62,'Ponytail Douglas Winthrop'),(63,'Lil\' Jonny Songbird, the Songbird-Eater'),(64,'King Snake: The Eternal Mystery'),(65,'Ghostly Nose Silvie'),(66,'Fonzie'),(67,'DiCapa the Hound'),(68,'Beef-or-Chicken Bob Nubbins'),(69,'Honest Amelia Dirt'),(70,'Slow Motion Jones'),(71,'Canadian Football Pete'),(72,'Meep Meep, the Italian Tailor'),(73,'Jonathan William Coulton, the Colchester Kid'),(74,'Maria the Pumpkin-Patch Crooner'),(75,'Bix Shmix'),(76,'Vice President Garrett Hobart'),(77,'Stun Gun Jones'),(78,'Prostate Davey'),(79,'Flea Stick'),(80,'Niles Butterball, the Frozen Turkey'),(81,'Todd Four-Flush'),(82,'Stick-Legs McOhio'),(83,'The Unanswered Question of Timothy'),(84,'Mickey the Assistant Manager'),(85,'Guesstimate Jones'),(86,'Goofus'),(87,'Gallant'),(88,'Sir Roundbelly DeDelight'),(89,'Newton Fig'),(90,'Chicken Nugget Will'),(91,'Parlor Peter, the Sneak Thief'),(92,'Ovid'),(93,'Bathsheba Ditz'),(94,'Alan Pockmark, Esq.'),(95,'Lolly Hoot Holler'),(96,'Von Skump'),(97,'Lonnie Choke'),(98,'Chisolm Chesthair'),(99,'Freak Le Freak, the Freakster'),(100,'Rex Spangler, the Bedazzler'),(101,'Randall Mouth-Harp'),(102,'Chrysler LeBaron'),(103,'The Fishin\' Physician'),(104,'Persuasive Frederick'),(105,'Celestial Stubbs'),(106,'Teary-Eyed Fingal'),(107,'Mairah Nix'),(108,'Cthulhu Carl'),(109,'Del Folksy-Beard'),(110,'No-Banjo Burnes'),(111,'Chainmail Giles Godfrey'),(112,'Lois \"Charles\" Ladyfinger'),(113,'Plausible Zane Scarrey'),(114,'Huckle Smothered'),(115,'MmmmmDandy Dundee'),(116,'Mountain-Humper Edgar Ames'),(117,'Spasmodic Hilary'),(118,'Doc Aquatic'),(119,'Molly Bewigged'),(120,'Cincinnati O\'Gurk'),(121,'Metuchen O\'Sullivan'),(122,'Cherry Hill O\'Manley'),(123,'Cheesequake O\'Lennox'),(124,'Booper O\'Montauk'),(125,'Zaxxon Galaxian');
UNLOCK TABLES;
/*!40000 ALTER TABLE `names` ENABLE KEYS */;

--
-- Table structure for table `tags`
--

DROP TABLE IF EXISTS `tags`;
CREATE TABLE `tags` (
  `id` int(11) NOT NULL,
  `tag` varchar(200) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tags`
--


/*!40000 ALTER TABLE `tags` DISABLE KEYS */;
LOCK TABLES `tags` WRITE;
INSERT INTO `tags` VALUES (1,'occupation'),(2,'culinary'),(3,'talent'),(4,'name-first'),(5,'proclivity'),(6,'benefactor'),(7,'name-unusual'),(8,'x-the-y'),(9,'criminal'),(10,'eponymous'),(11,'eponymous-fictional'),(12,'talent-creative'),(13,'the-x'),(14,'eponymous-real'),(15,'anachronism'),(16,'animal'),(17,'odor'),(18,'meta-group'),(19,'family-father'),(20,'name-last'),(21,'age-young'),(22,'family-son'),(23,'title'),(24,'title-royalty'),(25,'name-initial'),(26,'endurance'),(27,'foppish'),(28,'name-reduplicated'),(29,'bodypart-hair'),(30,'bodypart-dysfunction'),(31,'flammable'),(32,'trademark-bodypart'),(33,'character-flaw'),(34,'name-reduplicated-meta'),(35,'insect'),(36,'hygiene'),(37,'name-middle'),(38,'name-first-contraction'),(39,'hobo-reference'),(40,'number'),(41,'anonymous'),(42,'trademark-clothing'),(43,'clothing-jacket'),(44,'bodypart-missing'),(45,'bodypart-shoulder'),(46,'bodypart-deficient'),(47,'bodypart-tooth'),(48,'gender-indeterminate'),(49,'meta'),(50,'rhyme'),(51,'euphemism'),(52,'bodypart-nose'),(53,'clothing-pants'),(54,'eponymous-near'),(55,'bodypart-back'),(56,'bodypart-foot'),(57,'bodypart-excessive'),(58,'bodypart-face'),(59,'bodypart-meta'),(60,'nationality'),(61,'clothing-hat'),(62,'name-prefix'),(63,'gender-female'),(64,'weapon'),(65,'talent-physical'),(66,'kinetic'),(67,'beverage-alcoholic'),(68,'title-political'),(69,'hillbilly'),(70,'mythology'),(71,'bodypart-head'),(72,'animal-bird'),(73,'intelligence-low'),(74,'bodypart-weight'),(75,'animal-monkey'),(76,'alliteration'),(77,'character-flaw-killjoy'),(78,'academic'),(79,'intelligence-high'),(80,'nationality-unknown'),(81,'linguistics'),(82,'residence'),(83,'family'),(84,'entertainer'),(85,'title-medicine'),(86,'medicine'),(87,'family-twin'),(88,'political'),(89,'eponymous-meta'),(90,'clothing-sock'),(91,'animal-lizard'),(92,'name-suffix'),(93,'diminutive'),(94,'bodypart-eyes'),(95,'family-missing'),(96,'bodypart-expressive'),(97,'temporal'),(98,'trademark-personality'),(99,'bodypart-hand'),(100,'animal-ox'),(101,'animal-snake'),(102,'animal-dog'),(103,'character-positive'),(104,'onomatopoeia'),(105,'talent-musical'),(106,'residence-vegetable'),(107,'trademark-object'),(108,'bodypart-prostate'),(109,'animal-insect'),(110,'eponymous-corporate'),(111,'bodypart-leg'),(112,'unclassifiable'),(113,'bodypart-belly'),(114,'culinary-processed'),(115,'title-legal'),(116,'bodypart-chest'),(117,'comes-it-now-from-the-deep-to-devour-tags-semantic'),(118,'gods-elder'),(119,'bodypart-beard'),(120,'trademark-object-meta'),(121,'music'),(122,'clothing-chainmail'),(123,'name-nickname'),(124,'assonance'),(125,'bodypart-nervoussystem'),(126,'title-education'),(127,'qua-qua-qua'),(128,'bodypart-prosthetic'),(129,'nationality-city');
UNLOCK TABLES;
/*!40000 ALTER TABLE `tags` ENABLE KEYS */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;