-- MySQL dump 10.11
--
-- Host: localhost    Database: gaybooklondon
-- ------------------------------------------------------
-- Server version	5.0.75-0ubuntu10.2

/*!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 `bogaybook_agenda`
--

DROP TABLE IF EXISTS `bogaybook_agenda`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `bogaybook_agenda` (
  `id` int(11) NOT NULL auto_increment,
  `nom` varchar(1536) collate latin1_bin NOT NULL,
  `description` varchar(512) collate latin1_bin default NULL,
  `categorie` varchar(1536) collate latin1_bin NOT NULL,
  `refAdresse_id` int(11) NOT NULL,
  `refCategorie_id` int(11) NOT NULL,
  `image` varchar(100) collate latin1_bin NOT NULL,
  `weekly` tinyint(1) NOT NULL,
  `date` date NOT NULL,
  `horaire` varchar(100) collate latin1_bin NOT NULL,
  `prix` varchar(100) collate latin1_bin NOT NULL,
  `urlWeb` varchar(765) collate latin1_bin NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `bogaybook_agenda_refAdresse_id` (`refAdresse_id`),
  KEY `bogaybook_agenda_refCategorie_id` (`refCategorie_id`)
) ENGINE=MyISAM AUTO_INCREMENT=77 DEFAULT CHARSET=latin1 COLLATE=latin1_bin;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `bogaybook_agenda`
--

LOCK TABLES `bogaybook_agenda` WRITE;
/*!40000 ALTER TABLE `bogaybook_agenda` DISABLE KEYS */;
INSERT INTO `bogaybook_agenda` VALUES (6,'Homosocial','','',202,1,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100111212928/barcode.jpg',1,'2010-01-21','9pm-1am','Free',''),(12,'Popstarz','Fridays 10pm-4am','',565,1,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100114163146/pop.jpg',1,'2010-01-22','','','http://www.popstarz.org/'),(3,'Beyond','','',271,1,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100111183257/beyond.jpg',1,'2010-01-24','6am-1pm ','','http://www.areaclublondon.com/'),(4,'Popcorn',NULL,'',228,1,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100111184230/popcorn.jpg',1,'2010-01-25','','','http://www.heavennightclub-london.com/'),(5,'Hard On','','',530,3,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100111190128/hard.jpg',0,'2010-01-30','','','http://www.hardonclub.co.uk/'),(13,'Camp Attack','Fridays','',228,1,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100114170154/heaven.gif',1,'2010-01-22','','','http://www.heavennightclub-london.com/'),(8,'Orange','','',274,1,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100111220408/orange.jpg',1,'2010-01-24','11pm-9am.','','http://www.myspace.com/firelondon'),(9,'Hot Pink','Dusty O.','',210,1,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100111221121/dusty.jpg',1,'2010-01-26','','',''),(10,'Fabulous','Saturdays are Hosted and Run by DJP and Toumo Foxx, Bringing you the latest Pop Chart and R& B hits and remixes.  ','',217,1,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100111222354/ku.jpg',1,'2010-01-23','10pm-3am','Free before 11:30pm, £3 after.',''),(14,'Porn Idol','Thursdays','',228,1,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100114170722/heaven.gif',1,'2010-01-21','','','http://www.heavennightclub-london.com/'),(15,'Retrosexual','Tasty Tim plays all things 80s  A whole night dedicated to the decade that gave us Madge and Kyle!  ','',217,1,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100114171837/ku.jpg',1,'2010-01-21','10pm-3am','',''),(16,'Trannyshack','Wednesdays','',566,1,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100114173153/dusty.jpg',1,'2010-01-27','10:30pm-3am','£5, free til midnight to anyone making a suitable gender-bending effort.','http://www.madamejojos.com/'),(17,'Kinky Cabaret','Mondays; Hosted by Dusty O. ','',210,1,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100114173640/dusty.png',1,'2010-01-25','9pm-3am; Show 11pm.','Free',''),(18,'DiscoLiscious','Non-stop hits from the 70s and 80s; With host and DJ Heidi Liscious.','',225,1,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100114175150/disco.jpg',1,'2010-01-22','9:30pm-1am','','http://www.village-soho.co.uk/'),(19,'Pop Tarts','Saturdays with the sexiest DJ in town Adamix and the campest Heidi Liscious','',225,1,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100114175747/adamix.jpg',1,'2010-01-23','9:30pm-1am.','','http://profile.myspace.com/index.cfm?fuseaction=user.viewProfile&friendID=183443430'),(20,'G-Spot (Lesbian)','Girls and their guests','',218,1,'',1,'2010-01-27',' 6pm til late','',''),(21,'G-Spot (Lesbian)','Girls and their guests','',218,1,'',1,'2010-01-21','6pm til late','',''),(22,'G-Spot (Lesbian)','Girls and their guests','',218,1,'',1,'2010-01-23','6pm til late','',''),(23,'Gay Sat','','',228,1,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100117153707/HeavenLogoNew.gif',1,'2010-01-23','10:30pm-5am','','http://www.heavennightclub-london.com/'),(24,'Lady Llloyd','','',207,1,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100117154310/lady_lloyd.jpg',1,'2010-01-22','9:30pm-1am','Free b4 10:30pm, £3 after','http://www.myspace.com/theladylloyd'),(25,'Boudoir','Dusty O.','',207,1,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100117154501/dusty.jpg',1,'2010-01-23','9pm-1am','',''),(26,'Homo Electric','Luke UnaBomber and resident Jamie Bul','',567,1,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100117155204/homo_el.jpg',0,'2010-01-22','10pm-3am','',''),(27,'I Love This Song','','',567,1,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100117155955/love_this.jpg',1,'2010-01-24','7:30pm-12:30am','Free',''),(28,'Dandy Boys','','',568,1,'',1,'2010-01-27','7:30pm-1am','',''),(29,'Amateur Strip','Amateur Strip Contest','',244,1,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100117162751/amateur.jpg',1,'2010-01-27','9pm-3am','Free','http://www.bjswhiteswan.com/'),(30,'Caligula','Fridays','',569,1,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100117163234/caligul.jpg',1,'2010-01-22','11pm-5am','£5 before 12.30am, £8 after',''),(31,'XXL','','',570,1,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100117163654/XXL.png',1,'2010-01-27','9pm-3am','','http://www.the-arches.com/'),(32,'XXL','','',570,1,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100117163759/XXL.png',1,'2010-01-23','9pm-6am','','http://www.the-arches.com/'),(33,'Exilio','Gay latino dance club, biweekly','',571,1,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100117165022/exilio.jpg',0,'2010-01-30','9:30pm-2:30am','','http://www.exilio.co.uk/'),(34,'Wig Out','@former Ghetto, Saturdays','',248,1,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100118115314/wig.jpg',1,'2010-01-23','9pm-5am','£5','http://www.ghetto-london.co.uk/'),(35,'GutterSlut','End of Detox Party','',573,1,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100117171950/gutter.jpg',0,'2010-01-23','11pm-late','','http://www.myspace.com/gutterslutuk'),(36,'Club Kali','Bollywood, Bhangra, Arabic, R&B and Dance classics spiced up by DJ Ritu, Riz & Qurra at the world\'s biggest Asian music based LGBT club! Every 3rd Friday monthly','',574,1,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100117182615/kali.jpg',0,'2010-02-19','','','http://www.clubkali.com/'),(37,'Later','After-after Party','',274,1,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100117174109/later.jpg',1,'2010-01-24','11am-6pm','£5','http://www.myspace.com/firelondon'),(38,'Gravity','','',274,1,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100117175354/gravity.jpg',1,'2010-01-28','Midnight-10am','','http://www.myspace.com/firelondon'),(39,'Jason\'s Jukebox','Thursdays','',271,1,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100117175949/jason.jpg',1,'2010-01-28','10pm-late','Free',''),(40,'A:M','Every Saturday morning','',274,1,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100117180816/am.jpg',1,'2010-01-23','3am-10:30am','£8 with flyer/ad, £12 without','http://www.myspace.com/firelondon'),(41,'Tonker','','',273,1,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100117182002/tonker.jpg',1,'2010-01-22','9pm-3am','','http://www.britishmusclebear.com/clubs.htm'),(42,'Bootylicious','Every 3rd Saturday of the month','',575,1,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100117182544/booty.jpg',0,'2010-02-20','11pm-5:30am','entry £5 b412 / £6 after for Students with photo ID - £10 b412 / £12 full price','http://www.bootylicious-club.co.uk/'),(43,'Gay City Rollers','','',576,1,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100117183247/rollers.jpg',0,'2010-02-03','7pm-Midnight','','http://gaycityrollers.com/'),(44,'Eagle Saturday','','',273,1,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100117183608/eagle-logo.png',1,'2010-01-23','9pm-4am','','http://www.eaglelondon.com'),(45,'Onyx','','',271,1,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100117184121/onyx.jpg',1,'2010-01-22','10pm-5am','','http://www.myspace.com/firelondon'),(46,'Horse Meat Disco','','',273,1,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100117184429/eagle-logo.png',1,'2010-01-24','8pm-3am','£6','http://www.eaglelondon.com/'),(47,'Work!','Wednesdays; RNB hip hop ','',530,1,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100117185151/work.jpg',1,'2010-01-27','11pm-4am','',''),(48,'Industri','','',265,1,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100117185709/barcode.jpg',1,'2010-01-21','8pm-2am','Free',''),(49,'Polari','Gay literary salon; Feb 10 with Max Shaefer, Celine Hispiche and Mia Farlane','',577,1,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100117190624/polari.jpg',0,'2010-02-10','7pm-11pm','Free. Numbers are limited to 75 though, so arrive early to ensure a place.','http://www.myspace.com/polarigaysalon'),(50,'Bootcamp','','',273,3,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100119115417/eagle-logo.png',1,'2010-01-26','9pm-2am','£3, Eagle members and those in Skin / Military gear £2','http://www.eaglelondon.com/'),(51,'Grape 101','Night for wrestling fans','',273,1,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100119120043/eagle-logo.png',1,'2010-01-27','9pm-2am','£3 all night, Eagle members free before 10pm £2 after','http://www.eaglelondon.com/'),(52,'Eagle Retro','DJ Screwpulous takes you on a trip down memory lane with his 80s and 90s 12\" classics.','',273,1,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100119120849/eagle-logo.png',1,'2010-01-21','9pm-2am','£3, Eagle members free entry all night','http://www.eaglelondon.com'),(53,'Eagle Classic','','',273,1,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100119121121/eagle-logo.png',1,'2010-01-25','9pm-2am','£3, Eagle members free entry all night','http://www.eaglelondon.com'),(54,'Comedy Camp','Award winning comedy night','',202,4,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100119122607/comedy.gif',1,'2010-01-26','7:30pm, show 8:30pm','','http://www.comedycamp.co.uk/'),(55,'Bar Wotever','','',277,5,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100119125930/wotever.jpg',1,'2010-01-26','6pm-Midnight','Free','http://www.rvt.org.uk'),(56,' David Hoyle\'s Licking Wounds','\'Hoyle’s shows are car crash, rage-fuelled, issue-based comedy. Even when it goes horribly wrong, which it occasionally does, it\'s always horribly funny.\' The Times','',277,6,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100119141733/davids_hs.jpg',1,'2010-01-21','Doors 7pm, Show 8.30pm','£8.50','http://www.rvt.org.uk'),(57,'Duckie','Authentic London Honky-Tonk, Hosted by Amy Lamé, Record Players Readers Wifes, Door Whore The Cloths','',277,6,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100119142736/duckie.jpg',1,'2010-01-23','9pm-2am','£6','http://www.rvt.org.uk'),(58,'S.L.A.G.S / CHILL-OUT','Huge dance anthems and commercial house + The Dame Edna Experience ','',277,1,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100119142713/small.jpg',1,'2010-01-24','2pm-Midnight. Show at 5.30pm','£7','http://www.rvt.org.uk'),(59,'Bingo Pub Night','Bingo-cabaret-mayhem ','',277,7,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100119143214/bingo.jpg',1,'2010-01-25','Doors 7pm','FREE entry, £1 a round','http://www.rvt.org.uk'),(60,'Hit Factory','Lady Lloyd','',217,1,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100119145727/ku.jpg',1,'2010-01-24','8pm-late','Free, £3 after 11pm',''),(61,'Major Mondays','Cheap drinks, hot boys and the best commercial Pop, R&B and 90\'s classics','',217,1,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100119145956/ku.jpg',1,'2010-01-25','10pm-3am','Free',''),(62,'Ruby Tuesdays ','Girls and their guests','',217,1,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100119150650/ruby.jpg',1,'2010-01-26','8:30pm-late','',''),(63,'Shinky Shonky ','Crazy Pop Party with Boogaloo Stu and the gang','',217,1,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100119151016/shinky.jpg',1,'2010-01-27','10pm-3am','',''),(64,'The O Zone','Dusty O ','',217,1,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100119151342/ku.jpg',1,'2010-01-22','9pm-3am','Free b4 11pm, £3 after',''),(65,'Shadow Couture','','',231,1,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100119152832/shadow.jpg',1,'2010-01-25','9pm-3am','Free',''),(66,'Shadow Salon','','',231,1,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100119152959/shadow.jpg',1,'2010-01-26','9pm-3am','Free b4 11pm, £5 after',''),(67,'Shadow Boxer','','',231,1,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100119153146/shadow.jpg',1,'2010-01-27','9pm-3am','Free b4 11pm, £5 after',''),(68,'Glitz & Glamour','','',231,1,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100119153423/shadow.jpg',1,'2010-01-21','9pm-3am','Free b4 11pm, £5 after',''),(69,'Shadow Therapy','','',231,1,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100119153606/shadow.jpg',1,'2010-01-22','9pm-3am','',''),(70,'Shadow Inferno','','',231,1,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100119153812/shadow.jpg',1,'2010-01-23','9pm-3am','',''),(71,'Pervert Gold','','',274,1,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100120103737/perv.jpg',0,'2010-01-23','11pm-8am','','http://www.myspace.com/firelondon'),(72,'Your Mum\'s House','Resident DJ\'s: SCALLY DANDAN (D.I.Y) JAMIE D WINTER (Trailer trash)  Guest DJ\'s: JOSHYOU ARE DEAD HEAD DJ\'s (Nuke Them All) EROL SABADOSH','',578,1,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100120104241/mum.jpg',1,'2010-01-21','9pm-3am','£3 before 11pm, £5 after ','http://www.punksoho.co.uk'),(73,'Work!','Work at the Weekend','',530,1,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100120104608/work.jpg',0,'2010-01-23','11pm-5am','£8',''),(74,'Lo-Profile','','',229,1,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100120110347/lo-profile.jpg',1,'2010-01-22','10pm-4am','£8',''),(75,'Lo-Profile','','',229,1,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100120110546/lo-profile.jpg',1,'2010-01-23','10pm-4am','£8',''),(76,'Beartronic','Djs: Ben Jamin, Sandiego, Wayne Shires & guests','',248,1,'http://www.trombinogay.fr/gaybookanglais/admin/bogaybook/agenda/20100120112459/beartr.jpg',1,'2010-01-22','10pm-6am','FREE B4 11pm, £5 after ','');
/*!40000 ALTER TABLE `bogaybook_agenda` ENABLE KEYS */;
UNLOCK TABLES;
/*!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 */;

-- Dump completed on 2010-01-21  8:48:41
