--
-- Host: localhost    Database: listentoit
-- ------------------------------------------------------


--
-- Table structure for table `affiliation`
--

CREATE TABLE `affiliation` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `jobtitle` varchar(100) collate utf8_unicode_ci NOT NULL,
  `company` varchar(100) collate utf8_unicode_ci NOT NULL,
  `address` text collate utf8_unicode_ci,
  `city` varchar(100) collate utf8_unicode_ci default NULL,
  `country` varchar(255) collate utf8_unicode_ci NOT NULL,
  `url` varchar(255) collate utf8_unicode_ci default NULL,
  `phone` varchar(255) collate utf8_unicode_ci default NULL,
  `created` timestamp NOT NULL default CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `aff` (`jobtitle`,`company`,`city`,`country`,`phone`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `affiliation`
--

INSERT INTO `affiliation` VALUES (1,'Nothing','Home','','Kolkata','India','','000','2011-06-30 03:38:24');

--
-- Table structure for table `artist`
--

CREATE TABLE `artist` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `email` varchar(255) NOT NULL,
  `password` varchar(60) NOT NULL,
  `firstname` varchar(60) default NULL,
  `lastname` varchar(60) default NULL,
  `info` mediumtext,
  `mobile` varchar(15) default NULL,
  `address` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `zipcode` varchar(255) NOT NULL,
  `country` varchar(255) NOT NULL,
  `lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00',
  `iplast` varchar(15) default '000.000.000.000',
  `ip` varchar(15) default '000.000.000.000',
  `created` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `deleted` binary(1) default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=77 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `artist`
--

INSERT INTO `artist` VALUES (1,'pras.svo@gmail.com','e10adc3949ba59abbe56e057f20f883e','Prasun','Mukherjee',NULL,'+919830894336','','','','Select Country','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-04-09 04:33:04','0'),(2,'ronik.web@gmail.com','e10adc3949ba59abbe56e057f20f883e','Ronik','Web',NULL,'','','','','India','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-04-13 07:34:25','0'),(3,'andrea.corelli@modamusic.it','c0007b08b4098bfa0b2a369f370b85ff','Andrea','Corelli',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-04-13 09:40:11','0'),(4,'miklopaklo@gmail.com','c4fbe973a641a2a3ba11e116bb732274','Naiblebiagene','Naiblebiagene',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-04 11:18:29','0'),(5,'grivennikoziraqi@mail.ru','661cc35dbf72d8673d711ace514dbae5','foenomyncneds','foenomyncneds',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-04 11:56:45','0'),(6,'jannyjohanson@yahoo.com','1e02aa3e6f1e1950246bc65a4f57f8ee','Fapescomamelo','Fapescomamelo',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-04 18:52:43','0'),(7,'cassidylobo@aol.com','9b6ba4c24b19c1adfeb6b00694018486','raphNeatDaype','raphNeatDaype',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-04 23:02:13','0'),(8,'agopcreameniw@gmail.com','8d5a7f31d0746cf2f3e208b8043754ec','rairwerry','rairwerry',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-05 15:28:20','0'),(9,'zdoo2000@aol.com','275561ba6159e511d021c881355793a5','quipunisp','quipunisp',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-05 19:22:28','0'),(10,'japadvoff@ukrmail.org','6972875be0b7e3d3ddc7240e1b1bde66','BLEANIABS','BLEANIABS',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-05 22:18:42','0'),(11,'botangoklow@gmail.com','345b04f5482a491f16acc0260c003a71','BernieR','BernieR',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-06 05:37:15','0'),(12,'5.6441cotton@gmail.com','52e5011fe19e0dc8fd6f68cf2220f0e3','1fiverrjt','1fiverrjt',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-06 05:58:01','0'),(13,'mc2www@mc2.pl','b5cd9ac71d4dbab88e8b78c669356833','pleaddeds','pleaddeds',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-06 11:25:53','0'),(14,'xrgodabcdefg.hijklmnopqrstuvwyz@gmail.com','2db803a4c87db70b52ab4d852f800bf1','xrumerSellclerrub','xrumerSellclerrub',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-06 21:28:04','0'),(15,'thisismygoodmailhere@gmail.com','83f992cb8fed239324cb09d1ca1102dd','agihedajiopa','agihedajiopa',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-07 02:50:26','0'),(16,'addservice6@gmail.com','92b372f9d660f6181e54c3bd1b7abad3','WarlSpapdah','WarlSpapdah',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-07 03:14:39','0'),(17,'fotygamonika+fjv@gmail.com','b3fc8950b9f6fc05c8e36fb0113275e2','BrodeLonersegew','BrodeLonersegew',NULL,'07756557475','','','','Central African Republic','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-07 23:21:58','0'),(18,'ritaboven@xs4all.nl','df3aac6fcb9fd1165782ea201114dcf2','RitaBoven','RitaBoven',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-08 07:01:37','0'),(19,'derase.rt.a.r.es.o@gmail.com','774de8fb7ed7482f5c70cd44d9379261','Teexminnae','Teexminnae',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-08 10:12:20','0'),(20,'mc2www2@mc2.pl','fa390dd8e9b195f1f5dde3619f131fd3','pleaddeds','pleaddeds',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-08 15:55:57','0'),(21,'lsadjfo.iovjz.jeoiwjfeklj.so.djfe.w@gmail.com','190dcf0b5797d071fcfcf5c4745a446d','yhicerkac','yhicerkac',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-08 20:49:08','0'),(22,'crombbanbhkux@gmail.com','087e8b794ae98e3af8ea098857c07b00','clibrareina','clibrareina',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-08 22:55:19','0'),(23,'cflemming25@gmail.com','ae3d01f443061ee421598198b200d096','arraguerlolet','arraguerlolet',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-09 11:01:05','0'),(24,'b.o.rizzzy@gmail.com','5e0bc29ebadb022801acbc58c0361c8d','ImpennyUnenry','ImpennyUnenry',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-10 18:18:46','0'),(25,'aaa624492@dabjam.com','1ea738db1c78ee3fbb4d440b2a307ccb','uteneourei','uteneourei',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-11 06:43:41','0'),(26,'electronicbooks2011@gmail.com','157d3b1d911ec582d2964f43af94946b','ornadiola','ornadiola',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-11 09:54:34','0'),(27,'fotygamonika+fic@gmail.com','992fa83c3753e8a9b7ad1647483ccc7d','Affoffdrurrounc','Affoffdrurrounc',NULL,'07756557475','','','','Central African Republic','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-11 20:45:26','0'),(28,'admin2@discountreo.com','08ea931ed4be7ae54bc8b67f84116271','FoexInsenceme','FoexInsenceme',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-11 23:03:38','0'),(29,'alpetrovskiy@gmail.com','2bcc10a4d62bc4b67533934967796128','Imagmagow','Imagmagow',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-12 01:29:04','0'),(30,'alvfri.ea.d.a.s@gmail.com','337317cbb495474b430280f451dc8647','Autoppy','Autoppy',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-12 15:23:17','0'),(31,'mihaki19@gmail.com','fe721c0e99db645cc8307c3b47ea48f8','esorolfloable','esorolfloable',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-13 22:36:16','0'),(32,'immilmapemler@cvportal.net','3564dda80d4d6939ac9e56d2f03c5e8d','annotaoremy','annotaoremy',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-14 04:40:42','0'),(33,'dirinfoss@mail.ru','9981eecd6b21bb4fd1f297e1ca8b1398','vidakin','vidakin',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-14 05:18:56','0'),(34,'follitmarcgic@gmail.com','0539a9d20ffec46a55adca91a3db8689','Smedgeweddy','Smedgeweddy',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-14 07:57:35','0'),(35,'icerceque@gmail.com','dbd8725c68e0e92f1436a31a7a92378c','swassiseexhop','swassiseexhop',NULL,'','','','','Equatorial Guinea','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-14 12:11:39','0'),(36,'arreceprolync@lvovs.com','43a7bd12a081de1a06df0e7d1fba1b8b','Alammathe','Alammathe',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-14 20:07:31','0'),(37,'ruudgroen@xs4all.nl','e753a0e6b825f4294c4f8171f1c2159a','ruudgrc','ruudgrc',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-15 07:19:26','0'),(38,'arsenkovkuyjonip@mail.ru','7c54f8f5085ed906d8053546f8af7038','naftFiettezed','naftFiettezed',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-15 08:17:18','0'),(39,'profili63@mail.ru','c1e88c112d82fca3c56a85453de4905c','profiless','profiless',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-15 09:00:36','0'),(40,'talaenaplylom@vinbazar.com','5bb7bd77fdc6074ddeb31e5386ea6601','impessKef','impessKef',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-15 12:10:46','0'),(41,'brianbarry.b@gmail.com','11958e20a4f8913c76435a859e0e0eef','Reampedsmat','Reampedsmat',NULL,'','','','','Andorra','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-16 22:37:08','0'),(42,'lsadjfo.iovjz.jeo.iwjfeklj.so.djfe.w@gmail.com','c9a91a582e550e29cd6fcef02f61bce0','ugddviol','ugddviol',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-17 18:52:24','0'),(43,'gudini888@gmail.com','606d1f3e2f59dd7c937904aa834f6375','AmodeToma','AmodeToma',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-17 21:36:20','0'),(44,'kromkada@mail.ru','09c3db6c8526c98b26eb2b51a24afd8b','frotrad','frotrad',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-17 21:42:46','0'),(45,'prom.ome.ha@gmail.com','ff04afb545e14b64be3bd1bf59cd89e2','PapaffekEpina','PapaffekEpina',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-18 13:18:09','0'),(46,'branduffbehap@gmail.com','a766c10390a041ff03a8e33c6c4e3135','Pydayasyday','Pydayasyday',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-18 15:43:34','0'),(47,'ka.tie.vo.n.der@gmail.com','bca749de5f20ea8856f157d051365fd3','indeceino','indeceino',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-18 15:58:16','0'),(48,'uewjmuto68@gmail.com','535cbbc1de0fbb624926636fcaa58615','GENDDREARLY','GENDDREARLY',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-18 16:08:05','0'),(49,'pozh.2011@yandex.com','585832c98dace73f48011ef1a86bccb4','cheececisse','cheececisse',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-19 03:28:50','0'),(50,'webmaster@igotrentals.com','f29bd78f8c516d5de6aaf94da88ea9aa','insickkek','insickkek',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-19 04:29:57','0'),(51,'jack.acai@aol.com','d2021c89081a30b80c46fb87b61ee8a3','joepure','joepure',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-19 16:50:06','0'),(52,'berserklemon40@aol.com','af110d1a6179159af90bf626f6a0dca4','! afhdw','! afhdw',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-20 00:05:18','0'),(53,'gen..esemeliwuq@gmail.com','1eed7705394eae45375774e3733ed845','stisharry','stisharry',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-20 05:59:45','0'),(54,'janskyefraqar@gmail.com','86716dadebfbb681857d71f2426894f7','Twidderindy','Twidderindy',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-20 08:54:08','0'),(55,'armandafilantbhg@hotmail.com','d9ea4cefd03389701c80e62b63d23c3d','Repelaste','Repelaste',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-20 13:53:18','0'),(56,'rebpwiqbceli@qhdgiqkvhiyn.com','4d1bec6cb0c6c2cbb4907b41e27f6290','zsosktnczw','zsosktnczw',NULL,'','','','','Central African Republic','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-20 15:39:09','0'),(57,'cowar.d120224@gmail.com','2c095055effddc0aa277d2011dbb7650','3babynutoj0-','3babynutoj0-',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-20 22:18:31','0'),(58,'rohini..govibux@gmail.com','8ad515e928700db9351add65b498eb2a','laurneunfaibe','laurneunfaibe',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-20 23:08:25','0'),(59,'psychedelicsadn@aol.com','4bdfe6bfe74f5b89a0acffcab2048361','! azat','! azat',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-21 03:24:54','0'),(60,'edrebriwen@redkum.com','4228dee466024274016d55d61e4153ad','marmushkin','marmushkin',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-21 16:38:26','0'),(61,'weehobo20@aol.com','bc412ab0d9fc43afb62b96315e8bfa82','! aomcp','! aomcp',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-21 18:50:22','0'),(62,'forgetfulgun50@aol.com','eb534d80fed053602049fb865702585b','! ajbku','! ajbku',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-21 20:47:39','0'),(63,'idioticwrinkle2@aol.com','ccbf4909cded9929a8b8658c13a9a213','! aedwa','! aedwa',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-21 21:30:38','0'),(64,'john.nelson1@gmx.us','c5887effae7d4c6a58bc35a589e6f335','TheomsEsoro','TheomsEsoro',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-22 12:25:16','0'),(65,'p.e.t.yap.upki.nv.a.s.y.a@gmail.com','12f33f1f8d8069ff25eace7bba57bb6b','BOBANOLULSE','BOBANOLULSE',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-23 17:01:20','0'),(66,'kiddlipsconun@gmail.com','de7fc60c7adff2cfe197afde136d405c','marvajj','marvajj',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-23 22:57:26','0'),(67,'amiranlamapaz@gmail.com','8e0664246632cf8b05a8ac4752bc5361','SolomOntrep','SolomOntrep',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-24 01:07:32','0'),(68,'pricklyappendix@aol.com','c39b1480a5276c61d804b01fc8c8bf51','! asinu','! asinu',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-24 01:16:34','0'),(69,'coward.120224@gmail.com','c808abefa7a55a27ed30e85631a0b5e9','9babeGGdr99','9babeGGdr99',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-24 09:27:35','0'),(70,'s.hohalon@gmail.com','692267f7ec34747a039d0f043e1a7ad4','DwerrodoKes','DwerrodoKes',NULL,'215111327','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-24 12:34:50','0'),(71,'soso.loma@mail.ru','2a4db9761700b08e3d4becc0c764e176','GoonseQueency','GoonseQueency',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-25 16:16:39','0'),(72,'sho.halon@gmail.com','d326a9ab315b917bab079ecde9684668','DwerrodoKes','DwerrodoKes',NULL,'215111327','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-27 12:37:16','0'),(73,'lohduyegfgsfdag@fastmailforyou.net','904fa73459e410a745ebdc4fd378ed98','bypePypeCok','bypePypeCok',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-29 05:00:43','0'),(74,'shoshannacfab@gmail.com','2f1c23285eb2ff5d4fd47a386f9c9d04','Brightdragon','Brightdragon',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-29 11:14:56','0'),(75,'dullmuseum63@aol.com','bc72d9f3bdc4db21b81bb79f1bf7b397','! altnve','! altnve',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-30 04:30:49','0'),(76,'errolbarber6@gmail.com','ad4a04c715b721a3a7ebf7647c95eb46','Fraunkbub','Fraunkbub',NULL,'','','','','Italy','0000-00-00 00:00:00','000.000.000.000','000.000.000.000','2011-05-30 09:01:23','0');

--
-- Table structure for table `country`
--

CREATE TABLE `country` (
  `id` int(11) NOT NULL,
  `code` char(2) NOT NULL,
  `name` varchar(200) default NULL,
  `phoneprefix` varchar(50) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `country`
--

INSERT INTO `country` VALUES (1,'AF','Afghanistan','+93'),(2,'AL','Albania','+355'),(3,'DZ','Algeria','+213'),(4,'AD','Andorra','+376'),(5,'AO','Angola','+244'),(6,'AG','Antigua and Barbuda','+1-268'),(7,'AR','Argentina','+54'),(8,'AM','Armenia','+374'),(9,'AU','Australia','+61'),(10,'AT','Austria','+43'),(11,'AZ','Azerbaijan','+994'),(12,'BS','Bahamas, The','+1-242'),(13,'BH','Bahrain','+973'),(14,'BD','Bangladesh','+880'),(15,'BB','Barbados','+1-246'),(16,'BY','Belarus','+375'),(17,'BE','Belgium','+32'),(18,'BZ','Belize','+501'),(19,'BJ','Benin','+229'),(20,'BT','Bhutan','+975'),(21,'BO','Bolivia','+591'),(22,'BA','Bosnia and Herzegovina','+387'),(23,'BW','Botswana','+267'),(24,'BR','Brazil','+55'),(25,'BN','Brunei','+673'),(26,'BG','Bulgaria','+359'),(27,'BF','Burkina Faso','+226'),(28,'BI','Burundi','+257'),(29,'KH','Cambodia','+855'),(30,'CM','Cameroon','+237'),(31,'CA','Canada','+1'),(32,'CV','Cape Verde','+238'),(33,'CF','Central African Republic','+236'),(34,'TD','Chad','+235'),(35,'CL','Chile','+56'),(36,'CN','China, People\'s Republic of','+86'),(37,'CO','Colombia','+57'),(38,'KM','Comoros','+269'),(39,'CD','Congo, Democratic Republic of the (Congo ? Kinshasa)','+243'),(40,'CG','Congo, Republic of the (Congo ? Brazzaville)','+242'),(41,'CR','Costa Rica','+506'),(42,'CI','Cote d\'Ivoire (Ivory Coast)','+225'),(43,'HR','Croatia','+385'),(44,'CU','Cuba','+53'),(45,'CY','Cyprus','+357'),(46,'CZ','Czech Republic','+420'),(47,'DK','Denmark','+45'),(48,'DJ','Djibouti','+253'),(49,'DM','Dominica','+1-767'),(50,'DO','Dominican Republic','+1-809 and 1-829'),(51,'EC','Ecuador','+593'),(52,'EG','Egypt','+20'),(53,'SV','El Salvador','+503'),(54,'GQ','Equatorial Guinea','+240'),(55,'ER','Eritrea','+291'),(56,'EE','Estonia','+372'),(57,'ET','Ethiopia','+251'),(58,'FJ','Fiji','+679'),(59,'FI','Finland','+358'),(60,'FR','France','+33'),(61,'GA','Gabon','+241'),(62,'GM','Gambia, The','+220'),(63,'GE','Georgia','+995'),(64,'DE','Germany','+49'),(65,'GH','Ghana','+233'),(66,'GR','Greece','+30'),(67,'GD','Grenada','+1-473'),(68,'GT','Guatemala','+502'),(69,'GN','Guinea','+224'),(70,'GW','Guinea-Bissau','+245'),(71,'GY','Guyana','+592'),(72,'HT','Haiti','+509'),(73,'HN','Honduras','+504'),(74,'HU','Hungary','+36'),(75,'IS','Iceland','+354'),(76,'IN','India','+91'),(77,'ID','Indonesia','+62'),(78,'IR','Iran','+98'),(79,'IQ','Iraq','+964'),(80,'IE','Ireland','+353'),(81,'IL','Israel','+972'),(82,'IT','Italy','+39'),(83,'JM','Jamaica','+1-876'),(84,'JP','Japan','+81'),(85,'JO','Jordan','+962'),(86,'KZ','Kazakhstan','+7'),(87,'KE','Kenya','+254'),(88,'KI','Kiribati','+686'),(89,'KP','Korea, Democratic People\'s Republic of (North Korea)','+850'),(90,'KR','Korea, Republic of  (South Korea)','+82'),(91,'KW','Kuwait','+965'),(92,'KG','Kyrgyzstan','+996'),(93,'LA','Laos','+856'),(94,'LV','Latvia','+371'),(95,'LB','Lebanon','+961'),(96,'LS','Lesotho','+266'),(97,'LR','Liberia','+231'),(98,'LY','Libya','+218'),(99,'LI','Liechtenstein','+423'),(100,'LT','Lithuania','+370'),(101,'LU','Luxembourg','+352'),(102,'MK','Macedonia','+389'),(103,'MG','Madagascar','+261'),(104,'MW','Malawi','+265'),(105,'MY','Malaysia','+60'),(106,'MV','Maldives','+960'),(107,'ML','Mali','+223'),(108,'MT','Malta','+356'),(109,'MH','Marshall Islands','+692'),(110,'MR','Mauritania','+222'),(111,'MU','Mauritius','+230'),(112,'MX','Mexico','+52'),(113,'FM','Micronesia','+691'),(114,'MD','Moldova','+373'),(115,'MC','Monaco','+377'),(116,'MN','Mongolia','+976'),(117,'ME','Montenegro','+382'),(118,'MA','Morocco','+212'),(119,'MZ','Mozambique','+258'),(120,'MM','Myanmar (Burma)','+95'),(121,'NA','Namibia','+264'),(122,'NR','Nauru','+674'),(123,'NP','Nepal','+977'),(124,'NL','Netherlands','+31'),(125,'NZ','New Zealand','+64'),(126,'NI','Nicaragua','+505'),(127,'NE','Niger','+227'),(128,'NG','Nigeria','+234'),(129,'NO','Norway','+47'),(130,'OM','Oman','+968'),(131,'PK','Pakistan','+92'),(132,'PW','Palau','+680'),(133,'PA','Panama','+507'),(134,'PG','Papua New Guinea','+675'),(135,'PY','Paraguay','+595'),(136,'PE','Peru','+51'),(137,'PH','Philippines','+63'),(138,'PL','Poland','+48'),(139,'PT','Portugal','+351'),(140,'QA','Qatar','+974'),(141,'RO','Romania','+40'),(142,'RU','Russia','+7'),(143,'RW','Rwanda','+250'),(144,'KN','Saint Kitts and Nevis','+1-869'),(145,'LC','Saint Lucia','+1-758'),(146,'VC','Saint Vincent and the Grenadines','+1-784'),(147,'WS','Samoa','+685'),(148,'SM','San Marino','+378'),(149,'ST','Sao Tome and Principe','+239'),(150,'SA','Saudi Arabia','+966'),(151,'SN','Senegal','+221'),(152,'RS','Serbia','+381'),(153,'SC','Seychelles','+248'),(154,'SL','Sierra Leone','+232'),(155,'SG','Singapore','+65'),(156,'SK','Slovakia','+421'),(157,'SI','Slovenia','+386'),(158,'SB','Solomon Islands','+677'),(159,'SO','Somalia','+252'),(160,'ZA','South Africa','+27'),(161,'ES','Spain','+34'),(162,'LK','Sri Lanka','+94'),(163,'SD','Sudan','+249'),(164,'SR','Suriname','+597'),(165,'SZ','Swaziland','+268'),(166,'SE','Sweden','+46'),(167,'CH','Switzerland','+41'),(168,'SY','Syria','+963'),(169,'TJ','Tajikistan','+992'),(170,'TZ','Tanzania','+255'),(171,'TH','Thailand','+66'),(172,'TL','Timor-Leste (East Timor)','+670'),(173,'TG','Togo','+228'),(174,'TO','Tonga','+676'),(175,'TT','Trinidad and Tobago','+1-868'),(176,'TN','Tunisia','+216'),(177,'TR','Turkey','+90'),(178,'TM','Turkmenistan','+993'),(179,'TV','Tuvalu','+688'),(180,'UG','Uganda','+256'),(181,'UA','Ukraine','+380'),(182,'AE','United Arab Emirates','+971'),(183,'GB','United Kingdom','+44'),(184,'US','United States','+1'),(185,'UY','Uruguay','+598'),(186,'UZ','Uzbekistan','+998'),(187,'VU','Vanuatu','+678'),(188,'VA','Vatican City','+379'),(189,'VE','Venezuela','+58'),(190,'VN','Viet Nam','+84'),(191,'YE','Yemen','+967'),(192,'ZM','Zambia','+260'),(193,'ZW','Zimbabwe','+263'),(194,'GE','Abkhazia','+995'),(195,'TW','China, Republic of (Taiwan)','+886'),(196,'AZ','Nagorno-Karabakh','+374-97'),(197,'CY','Northern Cyprus','+90-392'),(198,'MD','Pridnestrovie (Transnistria)','+373-533'),(199,'SO','Somaliland','+252'),(200,'GE','South Ossetia','+995'),(201,'AU','Ashmore and Cartier Islands',''),(202,'CX','Christmas Island','+61'),(203,'CC','Cocos (Keeling) Islands','+61'),(204,'AU','Coral Sea Islands',''),(205,'HM','Heard Island and McDonald Islands',''),(206,'NF','Norfolk Island','+672'),(207,'NC','New Caledonia','+687'),(208,'PF','French Polynesia','+689'),(209,'YT','Mayotte','+269'),(210,'PM','Saint Pierre and Miquelon','+508'),(211,'WF','Wallis and Futuna','+681'),(212,'TF','French Southern and Antarctic Lands',''),(213,'PF','Clipperton Island',''),(214,'','French Scattered Islands in the Indian Ocean',''),(215,'BV','Bouvet Island',''),(216,'CK','Cook Islands','+682'),(217,'NU','Niue','+683'),(218,'TK','Tokelau','+690'),(219,'GG','Guernsey','+44'),(220,'IM','Isle of Man','+44'),(221,'JE','Jersey','+44'),(222,'AI','Anguilla','+1-264'),(223,'BM','Bermuda','+1-441'),(224,'IO','British Indian Ocean Territory','+246'),(225,'','British Sovereign Base Areas','+357'),(226,'VG','British Virgin Islands','+1-284'),(227,'KY','Cayman Islands','+1-345'),(228,'FK','Falkland Islands (Islas Malvinas)','+500'),(229,'GI','Gibraltar','+350'),(230,'MS','Montserrat','+1-664'),(231,'PN','Pitcairn Islands',''),(232,'SH','Saint Helena','+290'),(233,'GS','South Georgia and the South Sandwich Islands',''),(234,'TC','Turks and Caicos Islands','+1-649'),(235,'MP','Northern Mariana Islands','+1-670'),(236,'PR','Puerto Rico','+1-787 and 1-939'),(237,'AS','American Samoa','+1-684'),(238,'UM','Baker Island',''),(239,'GU','Guam','+1-671'),(240,'UM','Howland Island',''),(241,'UM','Jarvis Island',''),(242,'UM','Johnston Atoll',''),(243,'UM','Kingman Reef',''),(244,'UM','Midway Islands',''),(245,'UM','Navassa Island',''),(246,'UM','Palmyra Atoll',''),(247,'VI','U.S. Virgin Islands','+1-340'),(248,'UM','Wake Island',''),(249,'HK','Hong Kong','+852'),(250,'MO','Macau','+853'),(251,'FO','Faroe Islands','+298'),(252,'GL','Greenland','+299'),(253,'GF','French Guiana','+594'),(254,'GP','Guadeloupe','+590'),(255,'MQ','Martinique','+596'),(256,'RE','Reunion','+262'),(257,'AX','Aland','+358-18'),(258,'AW','Aruba','+297'),(259,'AN','Netherlands Antilles','+599'),(260,'SJ','Svalbard','+47'),(261,'AC','Ascension','+247'),(262,'TA','Tristan da Cunha',''),(263,'AQ','Antarctica',''),(264,'CS','Kosovo','+381'),(265,'PS','Palestinian Territories (Gaza Strip and West Bank)','+970'),(266,'EH','Western Sahara','+212'),(267,'AQ','Australian Antarctic Territory',''),(268,'AQ','Ross Dependency',''),(269,'AQ','Peter I Island',''),(270,'AQ','Queen Maud Land',''),(271,'AQ','British Antarctic Territory',''),(272,'TW','China','+886'),(273,'','Cape Verde Islands',NULL),(274,'KR','Korea','+82'),(275,'YU','Yugoslavia',NULL),(276,'TW','Taiwan','+886'),(277,'WI','West Indies',NULL);

--
-- Table structure for table `genre`
--

CREATE TABLE `genre` (
  `id` smallint(5) unsigned NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  `description` mediumtext,
  `parentid` smallint(5) unsigned default '0',
  `deleted` binary(1) default '0',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=908 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `genre`
--

INSERT INTO `genre` VALUES (1,'Audio Books','',0,'0'),(2,'Blues','',0,'0'),(3,'Children\'s','',0,'0'),(4,'Christian','',0,'0'),(5,'Classical','',0,'0'),(6,'Country','',0,'0'),(7,'DVD','',0,'0'),(8,'Educational','',0,'0'),(9,'Electronic','',0,'0'),(10,'Folk','',0,'0'),(11,'Hip-hop/Rap','',0,'0'),(12,'Holiday','',0,'0'),(13,'Jazz','',0,'0'),(14,'Latin Music','',0,'0'),(15,'Metal','',0,'0'),(16,'New Age','',0,'0'),(17,'Pop','',0,'0'),(18,'Punk','',0,'0'),(19,'R&B','',0,'0'),(20,'Reggae','',0,'0'),(21,'Rock','',0,'0'),(22,'Soundtracks','',0,'0'),(23,'Spoken Word','',0,'0'),(24,'Video','',0,'0'),(25,'World Music','',0,'0'),(26,'Arts and Entertainment','',1,'0'),(27,'Biography and Memoir','',1,'0'),(28,'Business','',1,'0'),(29,'Classics','',1,'0'),(30,'Comedy','',1,'0'),(31,'Drama and Poetry','',1,'0'),(32,'Fiction','',1,'0'),(33,'Health and Fitness','',1,'0'),(34,'History','',1,'0'),(35,'Kids and Young Adults','',1,'0'),(36,'Languages','',1,'0'),(37,'Live Events','',1,'0'),(38,'Mystery','',1,'0'),(39,'News','',1,'0'),(40,'Non Fiction','',1,'0'),(41,'Originals','',1,'0'),(42,'Other','',1,'0'),(43,'Periodicals','',1,'0'),(44,'Radio & TV','',1,'0'),(45,'Religion','',1,'0'),(46,'Sci Fi and Fantasy','',1,'0'),(47,'Science','',1,'0'),(48,'Self Development','',1,'0'),(49,'Speakers and Storytellers','',1,'0'),(50,'Technology','',1,'0'),(51,'Travel and Adventure','',1,'0'),(52,'Acoustic Blues','',2,'0'),(53,'Blues Revival','',2,'0'),(54,'Blues Rock','',2,'0'),(55,'Boogie Woogie','',2,'0'),(56,'Chicago Blues','',2,'0'),(57,'Contemporary Blues','',2,'0'),(58,'Country Blues','',2,'0'),(59,'Delta Blues','',2,'0'),(60,'Dirty Blues','',2,'0'),(61,'Electric Blues','',2,'0'),(62,'Gospel','',2,'0'),(63,'Harmonica Blues','',2,'0'),(64,'Inspirational','',2,'0'),(65,'Juke Joint Blues','',2,'0'),(66,'Jump-Blues','',2,'0'),(67,'Louisiana Blues','',2,'0'),(68,'Memphis Blues','',2,'0'),(69,'New Orleans R&B','',2,'0'),(70,'Piano Blues','',2,'0'),(71,'Piedmont Blues','',2,'0'),(72,'Pre-War','',2,'0'),(73,'Songster','',2,'0'),(74,'Soul','',2,'0'),(75,'Soul / R&B','',2,'0'),(76,'Swamp Blues','',2,'0'),(77,'Swing','',2,'0'),(78,'Texas Blues','',2,'0'),(79,'Traditional Blues','',2,'0'),(80,'Urban Blues','',2,'0'),(81,'Vaudeville Blues','',2,'0'),(82,'Work Songs','',2,'0'),(83,'Ancient Tales','',3,'0'),(84,'Children\'s','',3,'0'),(85,'Circus','',3,'0'),(86,'Classical','',3,'0'),(87,'Educational','',3,'0'),(88,'Folk/Sing-Along','',3,'0'),(89,'Lullabies','',3,'0'),(90,'Other','',3,'0'),(91,'Religious','',3,'0'),(92,'Rhymes/Fairytales','',3,'0'),(93,'Alternative CCM','',4,'0'),(94,'Christian Metal','',4,'0'),(95,'Christian Pop','',4,'0'),(96,'Christian Punk','',4,'0'),(97,'Christian Rap','',4,'0'),(98,'Christian Rock','',4,'0'),(99,'Contemporary Gospel','',4,'0'),(100,'Country','',4,'0'),(101,'Gospel','',4,'0'),(102,'Gospel Choir','',4,'0'),(103,'Instrumental Gospel','',4,'0'),(104,'Other','',4,'0'),(105,'Praise & Worship','',4,'0'),(106,'Ska','',4,'0'),(107,'Spoken Word','',4,'0'),(108,'Traditional Gospel','',4,'0'),(109,'20th/21st Century','',5,'0'),(110,'Avant-garde','',5,'0'),(111,'Ballet','',5,'0'),(112,'Band Music','',5,'0'),(113,'Baroque','',5,'0'),(114,'Chamber Music','',5,'0'),(115,'Choral Music','',5,'0'),(116,'Classical','',5,'0'),(117,'Classical Sacred','',5,'0'),(118,'Classical Vocal','',5,'0'),(119,'Concerto','',5,'0'),(120,'Crossover','',5,'0'),(121,'Early','',5,'0'),(122,'Electronic/Avant-Garde/Minimalis','',5,'0'),(123,'Film Music','',5,'0'),(124,'Gregorian','',5,'0'),(125,'Guitar','',5,'0'),(126,'Keyboard Music','',5,'0'),(127,'Medieval/ Renaissance','',5,'0'),(128,'Musical Theater','',5,'0'),(129,'Opera','',5,'0'),(130,'Orchestral Music','',5,'0'),(131,'Other','',5,'0'),(132,'Postmodern','',5,'0'),(133,'Pre-Baroque','',5,'0'),(134,'Romantic','',5,'0'),(135,'Symphony','',5,'0'),(136,'Vocal','',5,'0'),(137,'Zarzuela','',5,'0'),(138,'Alt. Country','',6,'0'),(139,'Americana','',6,'0'),(140,'Bluegrass','',6,'0'),(141,'Classic Country','',6,'0'),(142,'Compilations','',6,'0'),(143,'Contemporary Country','',6,'0'),(144,'Country Boogie','',6,'0'),(145,'Country Folk','',6,'0'),(146,'Country Rock','',6,'0'),(147,'Country-Pop','',6,'0'),(148,'Cowboy','',6,'0'),(149,'Honky-Tonk','',6,'0'),(150,'Instrumental','',6,'0'),(151,'Live Country','',6,'0'),(152,'Modern Country','',6,'0'),(153,'Nashville Sound/Countrypolitan','',6,'0'),(154,'Neo-Traditionalist','',6,'0'),(155,'Old-Timey','',6,'0'),(156,'Other','',6,'0'),(157,'Outlaw','',6,'0'),(158,'Progressive','',6,'0'),(159,'Rockabilly','',6,'0'),(160,'Singer-Songwriter','',6,'0'),(161,'String Bands','',6,'0'),(162,'Traditional Country','',6,'0'),(163,'Urban Cowboy','',6,'0'),(164,'Western Swing','',6,'0'),(165,'Yodeling','',6,'0'),(166,'2-step/British Garage','',9,'0'),(167,'Abstract','',9,'0'),(168,'Acid Jazz','',9,'0'),(169,'Ambient','',9,'0'),(170,'Ambient Dub','',9,'0'),(171,'Avant-garde','',9,'0'),(172,'Big Beat','',9,'0'),(173,'Break Beat','',9,'0'),(174,'Breaks','',9,'0'),(175,'Chill','',9,'0'),(176,'Club/Dance','',9,'0'),(177,'Compilations','',9,'0'),(178,'Crossover','',9,'0'),(179,'Dance-Pop','',9,'0'),(180,'Dark','',9,'0'),(181,'Dark Wave','',9,'0'),(182,'Deep House','',9,'0'),(183,'Digital Hardcore','',9,'0'),(184,'DJ','',9,'0'),(185,'DJ Mix','',9,'0'),(186,'Downbeat','',9,'0'),(187,'Downtempo','',9,'0'),(188,'Drum\'n\'Bass / Jungle','',9,'0'),(189,'Electro','',9,'0'),(190,'Electro Dark','',9,'0'),(191,'Electroclash','',9,'0'),(192,'Electronic 12-inches','',9,'0'),(193,'Electronic Dub','',9,'0'),(194,'Euro-Beat','',9,'0'),(195,'Euro-Dance','',9,'0'),(196,'Experimental','',9,'0'),(197,'Freestyle','',9,'0'),(198,'Funky Breaks','',9,'0'),(199,'Future Pop-Synth','',9,'0'),(200,'Gabba','',9,'0'),(201,'Glitch','',9,'0'),(202,'Global Groove','',9,'0'),(203,'Gloom Wave','',9,'0'),(204,'Groove','',9,'0'),(205,'Happy Hardcore','',9,'0'),(206,'Hard House','',9,'0'),(207,'Hard Techno','',9,'0'),(208,'Hi-NRG','',9,'0'),(209,'House','',9,'0'),(210,'I.D.M.','',9,'0'),(211,'Illbient','',9,'0'),(212,'Industrial','',9,'0'),(213,'Jam Band','',9,'0'),(214,'Krautrock','',9,'0'),(215,'Lounge','',9,'0'),(216,'Minimal Techno','',9,'0'),(217,'Newbeat','',9,'0'),(218,'Nu Breaks','',9,'0'),(219,'Nu-Jazz/Broken Beat','',9,'0'),(220,'Other','',9,'0'),(221,'Post-Rock','',9,'0'),(222,'Psychedelic','',9,'0'),(223,'Rave','',9,'0'),(224,'Remix','',9,'0'),(225,'Space','',9,'0'),(226,'Tech-House','',9,'0'),(227,'Techno','',9,'0'),(228,'Techno Clash','',9,'0'),(229,'Techno Dark','',9,'0'),(230,'Techno Dub','',9,'0'),(231,'Teknobody','',9,'0'),(232,'Trance','',9,'0'),(233,'Tribal','',9,'0'),(234,'Tribal House','',9,'0'),(235,'Trip-Hop','',9,'0'),(236,'Acoustic','',10,'0'),(237,'Anti-Folk','',10,'0'),(238,'Bluegrass','',10,'0'),(239,'Chassidic','',10,'0'),(240,'Contemporary','',10,'0'),(241,'Dark','',10,'0'),(242,'Drinking Songs','',10,'0'),(243,'Field Recordings','',10,'0'),(244,'Flamenco','',10,'0'),(245,'Folk Revival','',10,'0'),(246,'Folk-Rock','',10,'0'),(247,'Gypsy','',10,'0'),(248,'Historical','',10,'0'),(249,'Jota','',10,'0'),(250,'Jug Bands','',10,'0'),(251,'Live Folk','',10,'0'),(252,'Medieval','',10,'0'),(253,'Mediterranean','',10,'0'),(254,'Old Time','',10,'0'),(255,'Other','',10,'0'),(256,'Political/Protest','',10,'0'),(257,'Progressive Folk','',10,'0'),(258,'Sardana','',10,'0'),(259,'Scottish Folk','',10,'0'),(260,'Sea Shanties','',10,'0'),(261,'Sepharad','',10,'0'),(262,'Singer/Songwriter','',10,'0'),(263,'Skiffle','',10,'0'),(264,'Spoken Word','',10,'0'),(265,'Traditional Folk','',10,'0'),(266,'A Cappellas','',11,'0'),(267,'Alternative Rap','',11,'0'),(268,'Bass','',11,'0'),(269,'Beats & Breaks','',11,'0'),(270,'British Rap','',11,'0'),(271,'Comedy Rap','',11,'0'),(272,'Conscious/Political','',11,'0'),(273,'Dirty South/Crunk','',11,'0'),(274,'East Coast','',11,'0'),(275,'Electro','',11,'0'),(276,'Electro-Funk','',11,'0'),(277,'Foreign Language Rap','',11,'0'),(278,'Funk','',11,'0'),(279,'Gangsta','',11,'0'),(280,'Hip-Hop','',11,'0'),(281,'Hip-Hop 12-inches','',11,'0'),(282,'Instrumentals','',11,'0'),(283,'Latin','',11,'0'),(284,'Live Urban/Hip-Hop','',11,'0'),(285,'New Jack Swing','',11,'0'),(286,'New School','',11,'0'),(287,'Old School','',11,'0'),(288,'Other','',11,'0'),(289,'Party Rap','',11,'0'),(290,'R&B','',11,'0'),(291,'Rap','',11,'0'),(292,'Soul','',11,'0'),(293,'Turntablism','',11,'0'),(294,'Underground','',11,'0'),(295,'West Coast','',11,'0'),(296,'Buddhist','',12,'0'),(297,'Christian','',12,'0'),(298,'Christmas','',12,'0'),(299,'Easter','',12,'0'),(300,'Hanukkah','',12,'0'),(301,'Hindu','',12,'0'),(302,'Jewish','',12,'0'),(303,'Kwaanza','',12,'0'),(304,'Muslim','',12,'0'),(305,'Others','',12,'0'),(306,'Zorastrian','',12,'0'),(307,'Acid Jazz','',13,'0'),(308,'African Jazz','',13,'0'),(309,'Afro-Cuban Jazz','',13,'0'),(310,'Avant-garde','',13,'0'),(311,'BeBop','',13,'0'),(312,'Big Band','',13,'0'),(313,'Bop','',13,'0'),(314,'Brass Bands','',13,'0'),(315,'Brazilian Jazz','',13,'0'),(316,'Cabaret','',13,'0'),(317,'Classic Jazz','',13,'0'),(318,'Contemporary','',13,'0'),(319,'Cool Jazz','',13,'0'),(320,'Crossover','',13,'0'),(321,'Cuban Jazz','',13,'0'),(322,'Dixieland','',13,'0'),(323,'Easy Listening','',13,'0'),(324,'Electronic','',13,'0'),(325,'Flamenco','',13,'0'),(326,'Free Jazz','',13,'0'),(327,'Funk','',13,'0'),(328,'Fusion','',13,'0'),(329,'Hard Bop','',13,'0'),(330,'Jazz','',13,'0'),(331,'Jazz/Blues','',13,'0'),(332,'Jive','',13,'0'),(333,'Klezmer','',13,'0'),(334,'Latin Jazz','',13,'0'),(335,'Live Jazz','',13,'0'),(336,'Lounge','',13,'0'),(337,'Marching Bands','',13,'0'),(338,'New Orleans Jazz','',13,'0'),(339,'Orchestral Jazz','',13,'0'),(340,'Other','',13,'0'),(341,'Post-Bop','',13,'0'),(342,'Progressive Jazz','',13,'0'),(343,'Ragtime','',13,'0'),(344,'Smooth Jazz','',13,'0'),(345,'Soul Jazz','',13,'0'),(346,'Swing','',13,'0'),(347,'Traditional','',13,'0'),(348,'Vocal','',13,'0'),(349,'World Fusion','',13,'0'),(350,'Afro-Brazilian','',14,'0'),(351,'Afro-Cuban','',14,'0'),(352,'Afro-Peruvian','',14,'0'),(353,'Argentine Folklore','',14,'0'),(354,'Bachata','',14,'0'),(355,'Banda','',14,'0'),(356,'Big Band Latino','',14,'0'),(357,'Bolera','',14,'0'),(358,'Bomba','',14,'0'),(359,'Bossa Nova','',14,'0'),(360,'Brazilian','',14,'0'),(361,'Can','',14,'0'),(362,'candombe','',14,'0'),(363,'Cantautor','',14,'0'),(364,'Caribbean','',14,'0'),(365,'Cha Cha Cha','',14,'0'),(366,'Conjunto','',14,'0'),(367,'Copla','',14,'0'),(368,'Cuatro','',14,'0'),(369,'Cumbia','',14,'0'),(370,'Danzon','',14,'0'),(371,'Fado','',14,'0'),(372,'Flamenco','',14,'0'),(373,'Forr','',14,'0'),(374,'Guaganco','',14,'0'),(375,'Guajira','',14,'0'),(376,'Italian','',14,'0'),(377,'Jibaro','',14,'0'),(378,'Latin','',14,'0'),(379,'Latin Folk','',14,'0'),(380,'Latin Jazz','',14,'0'),(381,'Latin Pop','',14,'0'),(382,'Latin Soul','',14,'0'),(383,'Mambo','',14,'0'),(384,'Mariachi','',14,'0'),(385,'Merengue','',14,'0'),(386,'Musica Popular Brasileira (MPB)','',14,'0'),(387,'Norte','',14,'0'),(388,'Novo Fado','',14,'0'),(389,'Nueva Canci','',14,'0'),(390,'Nuevo Flamenco','',14,'0'),(391,'Other','',14,'0'),(392,'Pachanga','',14,'0'),(393,'Plena','',14,'0'),(394,'Pop Rock Latino','',14,'0'),(395,'Quechua','',14,'0'),(396,'Ranchero','',14,'0'),(397,'Reggaeton','',14,'0'),(398,'Rock en Espa','',14,'0'),(399,'Rumba','',14,'0'),(400,'Salsa','',14,'0'),(401,'Samba','',14,'0'),(402,'Son','',14,'0'),(403,'Spanish','',14,'0'),(404,'Tango','',14,'0'),(405,'Tejano','',14,'0'),(406,'Timba','',14,'0'),(407,'Toque','',14,'0'),(408,'Tropicalia','',14,'0'),(409,'Trova','',14,'0'),(410,'Vallenato','',14,'0'),(411,'Zarauela','',14,'0'),(412,'Alternative','',15,'0'),(413,'Black','',15,'0'),(414,'British Metal','',15,'0'),(415,'Death','',15,'0'),(416,'Doom','',15,'0'),(417,'Emo','',15,'0'),(418,'Glitter','',15,'0'),(419,'Goth-Metal','',15,'0'),(420,'Grindcore','',15,'0'),(421,'Guitar Virtuoso','',15,'0'),(422,'Hair Band','',15,'0'),(423,'Hardcore','',15,'0'),(424,'Heavy','',15,'0'),(425,'Industrial','',15,'0'),(426,'Instrumental','',15,'0'),(427,'Metal','',15,'0'),(428,'Other','',15,'0'),(429,'Pop-Metal','',15,'0'),(430,'Power Metal','',15,'0'),(431,'Rap Metal','',15,'0'),(432,'Scandinavian','',15,'0'),(433,'Sludge','',15,'0'),(434,'Speed','',15,'0'),(435,'Stoner Rock','',15,'0'),(436,'Teenager','',15,'0'),(437,'Thrash','',15,'0'),(438,'Ambient/Atmospheres','',16,'0'),(439,'Cartoon Music','',16,'0'),(440,'Contemporary Instrumental','',16,'0'),(441,'Electro-Acoustic','',16,'0'),(442,'Environmental','',16,'0'),(443,'Ethnic Fusion','',16,'0'),(444,'Healing','',16,'0'),(445,'Meditation/Relaxation','',16,'0'),(446,'Minimalism','',16,'0'),(447,'Nature','',16,'0'),(448,'Neo-Classical','',16,'0'),(449,'New Age','',16,'0'),(450,'Other','',16,'0'),(451,'Progressive','',16,'0'),(452,'Relaxation','',16,'0'),(453,'Sacred','',16,'0'),(454,'Self-Help','',16,'0'),(455,'Solo Instrumental','',16,'0'),(456,'Spiritual','',16,'0'),(457,'Vocal','',16,'0'),(458,'World','',16,'0'),(459,'A Cappella','',17,'0'),(460,'Brit-Pop','',17,'0'),(461,'Bubble Gum','',17,'0'),(462,'Chamber Pop','',17,'0'),(463,'Christian Music','',17,'0'),(464,'Dance-Pop','',17,'0'),(465,'Disco','',17,'0'),(466,'Diva','',17,'0'),(467,'Dream Pop','',17,'0'),(468,'Euro-Pop','',17,'0'),(469,'Female Vocalist','',17,'0'),(470,'Girl Group','',17,'0'),(471,'Indie Pop','',17,'0'),(472,'Instrumental','',17,'0'),(473,'Male Vocalist','',17,'0'),(474,'Other','',17,'0'),(475,'Parody','',17,'0'),(476,'Pop','',17,'0'),(477,'Power Pop','',17,'0'),(478,'Singer/Songwriter','',17,'0'),(479,'Alt/Punk Ska','',18,'0'),(480,'Anarchist','',18,'0'),(481,'Brit-Punk','',18,'0'),(482,'Cowpunk','',18,'0'),(483,'Digital Hardcore','',18,'0'),(484,'Emo','',18,'0'),(485,'Hardcore','',18,'0'),(486,'Industrial','',18,'0'),(487,'International Punk','',18,'0'),(488,'L.A. Punk','',18,'0'),(489,'Live Alt/Punk','',18,'0'),(490,'New York Punk','',18,'0'),(491,'No Wave','',18,'0'),(492,'Oi!','',18,'0'),(493,'Other','',18,'0'),(494,'Political','',18,'0'),(495,'Pop-Punk','',18,'0'),(496,'Post-Punk','',18,'0'),(497,'Punk','',18,'0'),(498,'Punkabilly','',18,'0'),(499,'Queercore','',18,'0'),(500,'Riot Girl','',18,'0'),(501,'Ska-Punk','',18,'0'),(502,'Skate-Punk','',18,'0'),(503,'Straight Edge','',18,'0'),(504,'Diva','',19,'0'),(505,'Doo Wop','',19,'0'),(506,'Funk','',19,'0'),(507,'Gospel','',19,'0'),(508,'Other','',19,'0'),(509,'Soul','',19,'0'),(510,'Calypso','',20,'0'),(511,'Dancehall','',20,'0'),(512,'Dub','',20,'0'),(513,'Lovers Rock','',20,'0'),(514,'Other','',20,'0'),(515,'Political','',20,'0'),(516,'Ragga','',20,'0'),(517,'Reggae','',20,'0'),(518,'Reggae Gospel','',20,'0'),(519,'Rocksteady','',20,'0'),(520,'Roots','',20,'0'),(521,'Ska','',20,'0'),(522,'Soca','',20,'0'),(523,'80\'s','',21,'0'),(524,'Adult Alternative','',21,'0'),(525,'Adult Contemporary','',21,'0'),(526,'Alternative','',21,'0'),(527,'Americana','',21,'0'),(528,'Boogie Rock','',21,'0'),(529,'Brit-Pop','',21,'0'),(530,'British Invasion','',21,'0'),(531,'Classic Rock','',21,'0'),(532,'Commercial Alternative','',21,'0'),(533,'Country-Rock','',21,'0'),(534,'Drone','',21,'0'),(535,'Duro','',21,'0'),(536,'Folk Rock','',21,'0'),(537,'Foreign Language Rock','',21,'0'),(538,'Funk Rock','',21,'0'),(539,'Garage Rock','',21,'0'),(540,'Glam Rock','',21,'0'),(541,'Goth','',21,'0'),(542,'Grunge','',21,'0'),(543,'Hard Rock','',21,'0'),(544,'Indie Rock','',21,'0'),(545,'Industrial','',21,'0'),(546,'Instrumental','',21,'0'),(547,'Jam Band','',21,'0'),(548,'Jam Rock','',21,'0'),(549,'Krautrock','',21,'0'),(550,'Live Rock','',21,'0'),(551,'Lo-fi','',21,'0'),(552,'Math Rock','',21,'0'),(553,'Modern Rock','',21,'0'),(554,'New Wave','',21,'0'),(555,'Noise-Rock','',21,'0'),(556,'Oldies','',21,'0'),(557,'Other','',21,'0'),(558,'Pop-Rock','',21,'0'),(559,'Post-Punk','',21,'0'),(560,'Post-Rock / Experimental','',21,'0'),(561,'Power-Pop','',21,'0'),(562,'Progressive','',21,'0'),(563,'Proto-Punk','',21,'0'),(564,'Psychedelic Rock','',21,'0'),(565,'Psychobilly','',21,'0'),(566,'Radical','',21,'0'),(567,'Rock \'n\' Roll','',21,'0'),(568,'Rockabilly','',21,'0'),(569,'Roots','',21,'0'),(570,'Singer-Songwriter','',21,'0'),(571,'Soft Rock','',21,'0'),(572,'Southern Rock','',21,'0'),(573,'Surf','',21,'0'),(574,'Tex-Mex','',21,'0'),(575,'Urbano','',21,'0'),(576,'Children\'s','',22,'0'),(577,'Comedy','',22,'0'),(578,'Film Soundtracks','',22,'0'),(579,'Holiday','',22,'0'),(580,'Marching Band','',22,'0'),(581,'Other','',22,'0'),(582,'Other Environmental','',22,'0'),(583,'Radio','',22,'0'),(584,'Sound Effects','',22,'0'),(585,'Spoken Word','',22,'0'),(586,'Theatre Scores','',22,'0'),(587,'TV Soundtracks','',22,'0'),(588,'Vocal Pop','',22,'0'),(589,'Blue Humor','',23,'0'),(590,'Christian Comedy','',23,'0'),(591,'Comedy','',23,'0'),(592,'Ethnic Comedy','',23,'0'),(593,'Gay Comedy','',23,'0'),(594,'Lectures','',23,'0'),(595,'Musical Comedy','',23,'0'),(596,'Novelty','',23,'0'),(597,'Observational Humor','',23,'0'),(598,'Poetry','',23,'0'),(599,'Political Humor','',23,'0'),(600,'Prank Calls','',23,'0'),(601,'Radio Comedy','',23,'0'),(602,'Satire','',23,'0'),(603,'Self-Help','',23,'0'),(604,'Sketch Comedy','',23,'0'),(605,'Spoken Word','',23,'0'),(606,'Standup Comedy','',23,'0'),(607,'Animation','',24,'0'),(608,'Arts','',24,'0'),(609,'Celebrities','',24,'0'),(610,'Children\'s','',24,'0'),(611,'Comedy','',24,'0'),(612,'Concerts','',24,'0'),(613,'Documentary','',24,'0'),(614,'Drama','',24,'0'),(615,'Educational','',24,'0'),(616,'Full Length Feature','',24,'0'),(617,'Health and Fitness','',24,'0'),(618,'History','',24,'0'),(619,'Horror','',24,'0'),(620,'Live Events','',24,'0'),(621,'Mature Content','',24,'0'),(622,'Mobile - Animation','',24,'0'),(623,'Mobile - Celebrities','',24,'0'),(624,'Mobile - Comedy','',24,'0'),(625,'Mobile - Mature','',24,'0'),(626,'Mobile - Music','',24,'0'),(627,'Mobile - Other','',24,'0'),(628,'Mobile - Sports','',24,'0'),(629,'Music - Alternative','',24,'0'),(630,'Music - Blues','',24,'0'),(631,'Music - Classical','',24,'0'),(632,'Music - Country','',24,'0'),(633,'Music - Dance','',24,'0'),(634,'Music - Electronic','',24,'0'),(635,'Music - Electronic','',24,'0'),(636,'Music - Folk','',24,'0'),(637,'Music - Hip-hop/rap','',24,'0'),(638,'Music - Jazz','',24,'0'),(639,'Music - Metal','',24,'0'),(640,'Music - Other','',24,'0'),(641,'Music - Pop','',24,'0'),(642,'Music - Punk','',24,'0'),(643,'Music - R&B','',24,'0'),(644,'Music - Reggae','',24,'0'),(645,'Music - Rock','',24,'0'),(646,'Music - World','',24,'0'),(647,'News','',24,'0'),(648,'Other','',24,'0'),(649,'Religon and Spirituality','',24,'0'),(650,'Science and Technology','',24,'0'),(651,'Self Development','',24,'0'),(652,'Shorts','',24,'0'),(653,'Spanish','',24,'0'),(654,'Thriller','',24,'0'),(655,'Travel','',24,'0'),(656,'TV Shows','',24,'0'),(657,'Video','',24,'0'),(658,'African','',25,'0'),(659,'African Pop','',25,'0'),(660,'Afrobeat','',25,'0'),(661,'Alternative','',25,'0'),(662,'Arabic Belly-Dance','',25,'0'),(663,'Arabic Children','',25,'0'),(664,'Arabic Classic','',25,'0'),(665,'Arabic Dance','',25,'0'),(666,'Arabic Folklore','',25,'0'),(667,'Arabic Pop','',25,'0'),(668,'Arabic Rock','',25,'0'),(669,'Arabic Romantic','',25,'0'),(670,'Asia','',25,'0'),(671,'Asturias','',25,'0'),(672,'Australian','',25,'0'),(673,'Basque','',25,'0'),(674,'Belgian','',25,'0'),(675,'Blues','',25,'0'),(676,'Brazil','',25,'0'),(677,'Brazilian Blues','',25,'0'),(678,'Brazilian Hip Hop','',25,'0'),(679,'Brazilian Metal','',25,'0'),(680,'Brazilian Pop','',25,'0'),(681,'Brazilian Reggae','',25,'0'),(682,'Brazilian Rock','',25,'0'),(683,'Brazilian Soul','',25,'0'),(684,'Brazilian-Afro','',25,'0'),(685,'Brazilian-Ax','',25,'0'),(686,'Brazilian-Baiao','',25,'0'),(687,'Brazilian-Boi Bumba','',25,'0'),(688,'Brazilian-Bossa Nova','',25,'0'),(689,'Brazilian-Brega','',25,'0'),(690,'Brazilian-Caipira','',25,'0'),(691,'Brazilian-Candomble','',25,'0'),(692,'Brazilian-Capoiera','',25,'0'),(693,'Brazilian-Children\'s','',25,'0'),(694,'Brazilian-Choro','',25,'0'),(695,'Brazilian-Christian','',25,'0'),(696,'Brazilian-Classical','',25,'0'),(697,'Brazilian-Forr','',25,'0'),(698,'Brazilian-Funk Carioca','',25,'0'),(699,'Brazilian-Gaucho','',25,'0'),(700,'Brazilian-Instrumental','',25,'0'),(701,'Brazilian-Jazz','',25,'0'),(702,'Brazilian-Jovem Guarda','',25,'0'),(703,'Brazilian-Mangue Beat/Pernambuco','',25,'0'),(704,'Brazilian-MPB','',25,'0'),(705,'Brazilian-Regional','',25,'0'),(706,'Brazilian-Samba/Pagode','',25,'0'),(707,'Brazilian-Sertaneja','',25,'0'),(708,'Brazilian-Spoken Word','',25,'0'),(709,'Brazilian-Tropicalia','',25,'0'),(710,'Cantopop','',25,'0'),(711,'Cap-verde','',25,'0'),(712,'Caribbean','',25,'0'),(713,'Castilla','',25,'0'),(714,'Celtic','',25,'0'),(715,'Central Asian','',25,'0'),(716,'Central European','',25,'0'),(717,'Chants','',25,'0'),(718,'Chinese Alternative','',25,'0'),(719,'Chinese Children\'s','',25,'0'),(720,'Chinese Classical','',25,'0'),(721,'Chinese Comedy','',25,'0'),(722,'Chinese Electrical','',25,'0'),(723,'Chinese Folk','',25,'0'),(724,'Chinese Hip-Hop','',25,'0'),(725,'Chinese Instrumental','',25,'0'),(726,'Chinese Local Opera','',25,'0'),(727,'Chinese Pop','',25,'0'),(728,'Chinese R&B','',25,'0'),(729,'Chinese Rock','',25,'0'),(730,'Chinese Singer/Songwriter','',25,'0'),(731,'Chinese Soundtrack','',25,'0'),(732,'Chinese Spoken Word','',25,'0'),(733,'Chinese Traditional Opera','',25,'0'),(734,'Chinese Vocalist','',25,'0'),(735,'Classical','',25,'0'),(736,'Comedy','',25,'0'),(737,'Country-Rock','',25,'0'),(738,'Cuba','',25,'0'),(739,'Eastern Europe','',25,'0'),(740,'Electronic','',25,'0'),(741,'Electronica','',25,'0'),(742,'Fado','',25,'0'),(743,'Far Eastern','',25,'0'),(744,'Flamenco/ Tango','',25,'0'),(745,'Folk','',25,'0'),(746,'Folklore','',25,'0'),(747,'Foreign Language Rock','',25,'0'),(748,'France','',25,'0'),(749,'Galicia','',25,'0'),(750,'Gamelan','',25,'0'),(751,'Greece','',25,'0'),(752,'Greek','',25,'0'),(753,'Hip/Hop Rap','',25,'0'),(754,'Indian - Assamese','',25,'0'),(755,'Indian - Assamese Film','',25,'0'),(756,'Indian - Bengali','',25,'0'),(757,'Indian - Bengali Film','',25,'0'),(758,'Indian - Bhangra','',25,'0'),(759,'Indian - Carnatic Classical','',25,'0'),(760,'Indian - DJ','',25,'0'),(761,'Indian - Fusion','',25,'0'),(762,'Indian - Ghazal','',25,'0'),(763,'Indian - Gujarati','',25,'0'),(764,'Indian - Gujarati Film','',25,'0'),(765,'Indian - Hindi','',25,'0'),(766,'Indian - Hindi Devotional','',25,'0'),(767,'Indian - Hindi Film','',25,'0'),(768,'Indian - Hindi Non-Film','',25,'0'),(769,'Indian - Hindustani Classical','',25,'0'),(770,'Indian - Kannada','',25,'0'),(771,'Indian - Kannada Film','',25,'0'),(772,'Indian - Konkani','',25,'0'),(773,'Indian - Malayalam','',25,'0'),(774,'Indian - Malayalam Film','',25,'0'),(775,'Indian - Marathi','',25,'0'),(776,'Indian - Marathi Film','',25,'0'),(777,'Indian - Oriya','',25,'0'),(778,'Indian - Oriya Film','',25,'0'),(779,'Indian - Pop','',25,'0'),(780,'Indian - Punjabi','',25,'0'),(781,'Indian - Punjabi Film','',25,'0'),(782,'Indian - Tamil','',25,'0'),(783,'Indian - Tamil Film','',25,'0'),(784,'Indian - Telugu','',25,'0'),(785,'Indian - Telugu Film','',25,'0'),(786,'Indigenous','',25,'0'),(787,'Indonesia','',25,'0'),(788,'Inspirational','',25,'0'),(789,'International Pop','',25,'0'),(790,'Irish','',25,'0'),(791,'Irish','',25,'0'),(792,'Italy','',25,'0'),(793,'J-Rock','',25,'0'),(794,'Jazz','',25,'0'),(795,'Jewish Folk','',25,'0'),(796,'Klezmer','',25,'0'),(797,'Latin','',25,'0'),(798,'Mediterranean','',25,'0'),(799,'Mestizo','',25,'0'),(800,'Metal','',25,'0'),(801,'Mexico','',25,'0'),(802,'Middle Eastern','',25,'0'),(803,'Morocco','',25,'0'),(804,'Native American','',25,'0'),(805,'New Age','',25,'0'),(806,'Nordic','',25,'0'),(807,'North America','',25,'0'),(808,'Other','',25,'0'),(809,'Other','',25,'0'),(810,'Pacific Islands','',25,'0'),(811,'Pakistan','',25,'0'),(812,'Pan Global','',25,'0'),(813,'Peking Opera','',25,'0'),(814,'Peru','',25,'0'),(815,'Polka','',25,'0'),(816,'Pop','',25,'0'),(817,'Portugal','',25,'0'),(818,'Punk','',25,'0'),(819,'R&B','',25,'0'),(820,'Rai','',25,'0'),(821,'Reggae','',25,'0'),(822,'Rock','',25,'0'),(823,'Romanian','',25,'0'),(824,'Romanian Manele','',25,'0'),(825,'Russian Alternative','',25,'0'),(826,'Russian Banner Singing','',25,'0'),(827,'Russian Bard Songs','',25,'0'),(828,'Russian Estrada','',25,'0'),(829,'Russian Folk','',25,'0'),(830,'Russian Folk-Chastooshkas','',25,'0'),(831,'Russian Folk-Cossacks\' chorus si','',25,'0'),(832,'Russian Folk-Cossacks\' singing','',25,'0'),(833,'Russian Folk-Feast songs','',25,'0'),(834,'Russian Folk-Russian gypsy songs','',25,'0'),(835,'Russian Folk-Russian humour','',25,'0'),(836,'Russian Folk-Russian romances','',25,'0'),(837,'Russian Folk-Weeping','',25,'0'),(838,'Russian Great Patronimic War Son','',25,'0'),(839,'Russian Hard-rock','',25,'0'),(840,'Russian Military Marches','',25,'0'),(841,'Russian Military Songs','',25,'0'),(842,'Russian National Music-Buryat Gu','',25,'0'),(843,'Russian National Music-Lezginka','',25,'0'),(844,'Russian National Music-Tatar Fol','',25,'0'),(845,'Russian National Music-Tyva Gutt','',25,'0'),(846,'Russian Opera','',25,'0'),(847,'Russian Operetta','',25,'0'),(848,'Russian Orthodox Song Singing','',25,'0'),(849,'Russian Pop','',25,'0'),(850,'Russian Religious Ringing of Bel','',25,'0'),(851,'Russian Religious Valaam Song Si','',25,'0'),(852,'Russian Revolution Songs','',25,'0'),(853,'Russian Rock','',25,'0'),(854,'Russian Shanson-Thieves Slang So','',25,'0'),(855,'Russian Symphonic','',25,'0'),(856,'Russian Valaam Song Singing','',25,'0'),(857,'Russian WWI Songs','',25,'0'),(858,'Russican Church Choir Singing','',25,'0'),(859,'Russican Church Song Singing','',25,'0'),(860,'Salsa','',25,'0'),(861,'Scandinavian','',25,'0'),(862,'Scottish','',25,'0'),(863,'Social Commentary','',25,'0'),(864,'Soukos','',25,'0'),(865,'Soundtracks','',25,'0'),(866,'South American','',25,'0'),(867,'South Pacific','',25,'0'),(868,'Southeast Asian','',25,'0'),(869,'Spain','',25,'0'),(870,'Spain - Asturias','',25,'0'),(871,'Spain - Castilian','',25,'0'),(872,'Spain - Galician','',25,'0'),(873,'Spoken Word','',25,'0'),(874,'Swiss','',25,'0'),(875,'Turkish Arabesque','',25,'0'),(876,'Turkish Ashik Songs','',25,'0'),(877,'Turkish Blacksee Reg.','',25,'0'),(878,'Turkish Children\'s','',25,'0'),(879,'Turkish Classical','',25,'0'),(880,'Turkish Dance','',25,'0'),(881,'Turkish Electronic','',25,'0'),(882,'Turkish Folk','',25,'0'),(883,'Turkish Hip Hop','',25,'0'),(884,'Turkish Instrumental','',25,'0'),(885,'Turkish Islamic And Sufi','',25,'0'),(886,'Turkish Islamic Spoken','',25,'0'),(887,'Turkish Jazz','',25,'0'),(888,'Turkish Metal','',25,'0'),(889,'Turkish New Age','',25,'0'),(890,'Turkish Oriental','',25,'0'),(891,'Turkish Poetry','',25,'0'),(892,'Turkish Pop','',25,'0'),(893,'Turkish Punk','',25,'0'),(894,'Turkish Rock','',25,'0'),(895,'Turkish Soundtrack','',25,'0'),(896,'Turkish Standup','',25,'0'),(897,'Turkish Tango','',25,'0'),(898,'Turkish Techno','',25,'0'),(899,'Turkish Traditional','',25,'0'),(900,'Turkish Trip Hop','',25,'0'),(901,'Turkish World','',25,'0'),(902,'Variete Francaise','',25,'0'),(903,'Western European','',25,'0'),(904,'World Beat','',25,'0'),(905,'World Compilations','',25,'0'),(906,'World Fusion','',25,'0'),(907,'Zydeco','',25,'0');

--
-- Table structure for table `genre_map`
--

CREATE TABLE `genre_map` (
  `genreid` smallint(5) unsigned NOT NULL,
  `type` enum('song','release') collate utf8_unicode_ci default 'song',
  `mapid` bigint(20) unsigned NOT NULL,
  `order` tinyint(4) default '1',
  UNIQUE KEY `map` (`genreid`,`type`,`mapid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `genre_map`
--

INSERT INTO `genre_map` VALUES (8,'release',1,1),(8,'song',2,1),(8,'song',3,1),(8,'song',4,1),(12,'song',4,2),(8,'song',5,1),(12,'song',5,2),(8,'song',6,1),(12,'song',6,2),(3,'song',7,1),(16,'song',8,1),(16,'song',10,1),(2,'song',1,1),(24,'song',1,2),(4,'song',9,1),(21,'song',11,1),(523,'song',11,2),(2,'song',12,1);

--
-- Table structure for table `label`
--

CREATE TABLE `label` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `email` varchar(255) collate utf8_unicode_ci NOT NULL,
  `password` varchar(60) collate utf8_unicode_ci NOT NULL,
  `name` varchar(100) collate utf8_unicode_ci NOT NULL,
  `tagline` varchar(255) collate utf8_unicode_ci default NULL,
  `address` text collate utf8_unicode_ci,
  `country` varchar(255) collate utf8_unicode_ci NOT NULL,
  `url` varchar(255) collate utf8_unicode_ci default NULL,
  `priority` tinyint(4) default '1',
  `created` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `deleted` binary(1) default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `label`
--


--
-- Table structure for table `master`
--

CREATE TABLE `master` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `username` varchar(60) NOT NULL,
  `password` varchar(60) NOT NULL,
  `email` varchar(80) NOT NULL,
  `iplast` varchar(15) default '000.000.000.000',
  `lastlogin` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `deleted` binary(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `username` (`username`,`email`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `master`
--

INSERT INTO `master` VALUES (1,'master','e10adc3949ba59abbe56e057f20f883e','pras.svo@gmail.com','217.133.119.190','2011-04-29 12:05:22','0');

--
-- Table structure for table `release`
--

CREATE TABLE `release` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `title` varchar(255) collate utf8_unicode_ci NOT NULL,
  `utype` enum('artist','label') collate utf8_unicode_ci default 'artist',
  `umapid` bigint(20) unsigned NOT NULL,
  `artist` varchar(255) collate utf8_unicode_ci NOT NULL,
  `label` varchar(255) collate utf8_unicode_ci NOT NULL,
  `rcn` varchar(255) collate utf8_unicode_ci default NULL,
  `ean` varchar(255) collate utf8_unicode_ci default NULL,
  `rdate` date default '0000-00-00',
  `promodate` date default '0000-00-00',
  `artwork_b` varchar(255) collate utf8_unicode_ci default NULL,
  `artwork_m` varchar(255) collate utf8_unicode_ci default NULL,
  `artwork_s` varchar(255) collate utf8_unicode_ci default NULL,
  `priority` tinyint(4) default '1',
  `released` binary(1) default '0',
  `created` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `deleted` binary(1) default '0',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `release`
--

INSERT INTO `release` VALUES (1,'Test Release 1','artist',1,'xxx','zzz','123','12','2011-07-31','2011-06-08','artwork/xxx/test-release-1-450px.jpg','artwork/xxx/test-release-1-200px.jpg','artwork/xxx/test-release-1-75px.jpg',1,'0','2011-05-18 10:54:58','0');

--
-- Table structure for table `release_track`
--

CREATE TABLE `release_track` (
  `releaseid` smallint(5) unsigned NOT NULL,
  `tracknum` tinyint(4) default '1',
  `songid` bigint(20) unsigned NOT NULL,
  UNIQUE KEY `track` (`releaseid`,`songid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `release_track`
--

INSERT INTO `release_track` VALUES (1,2,1),(1,1,2),(1,3,7);

--
-- Table structure for table `song`
--

CREATE TABLE `song` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `title` varchar(255) collate utf8_unicode_ci NOT NULL,
  `version` varchar(255) collate utf8_unicode_ci default 'Original Mix',
  `artist` varchar(255) collate utf8_unicode_ci NOT NULL,
  `label` varchar(255) collate utf8_unicode_ci NOT NULL,
  `utype` enum('artist','label') collate utf8_unicode_ci default 'artist',
  `umapid` bigint(20) unsigned NOT NULL,
  `remixer` varchar(255) collate utf8_unicode_ci default NULL,
  `isrc` varchar(255) collate utf8_unicode_ci default NULL,
  `fileflac` varchar(255) collate utf8_unicode_ci default NULL,
  `filemp3320` varchar(255) collate utf8_unicode_ci default NULL,
  `filemp3128` varchar(255) collate utf8_unicode_ci default NULL,
  `preview` varchar(255) collate utf8_unicode_ci default NULL,
  `waveform` varchar(255) collate utf8_unicode_ci default NULL,
  `preview_waveform` varchar(255) collate utf8_unicode_ci default NULL,
  `length` varchar(255) collate utf8_unicode_ci default NULL,
  `preview_startpt` varchar(255) collate utf8_unicode_ci default NULL,
  `instrumental` binary(1) default '0',
  `composer` varchar(255) collate utf8_unicode_ci default NULL,
  `author` varchar(255) collate utf8_unicode_ci default NULL,
  `publisher` varchar(255) collate utf8_unicode_ci default NULL,
  `produced` varchar(255) collate utf8_unicode_ci default NULL,
  `credit` text collate utf8_unicode_ci,
  `priority` tinyint(4) default '1',
  `created` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `deleted` binary(1) default '0',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `song`
--

INSERT INTO `song` VALUES (1,'test track 1','test version 1','xxx','yyyzzz','artist',1,'zzz,p0p,0op','123','flac/a-1/xxx-test_track_1-test_version_1.flac','mp3320k/a-1/xxx-test_track_1-test_version_1-320k.mp3','mp3128k/a-1/xxx-test_track_1-test_version_1-128k.mp3','mp3320k/a-1/preview/xxx-test_track_1-test_version_1.mp3','waveform/a-1/xxx-test_track_1-test_version_1.png','waveform/a-1/preview/xxx-test_track_1-test_version_1.png','0:11','00:04','1','','','','2011','ppp',1,'2011-05-21 09:37:47','0'),(2,'test track 2','test version 2','Black Label Society','Black Label Society','artist',1,'BLS,BLS1','987','flac/a-1/Black_Label_Society-test_track_2-test_version_2.flac','mp3320k/a-1/Black_Label_Society-test_track_2-test_version_2-320k.mp3','mp3128k/a-1/Black_Label_Society-test_track_2-test_version_2-128k.mp3',NULL,'waveform/a-1/Black_Label_Society-test_track_2-test_version_2.png',NULL,'1:57','00:00','1','BLS','','','','ppp',1,'2011-05-21 11:20:51','0'),(4,'test 2','version 2','xxz','yyz','artist',1,'ytr','123455','flac/a-1/xxz-test_2-version_2.flac','mp3320k/a-1/xxz-test_2-version_2-320k.mp3','mp3128k/a-1/xxz-test_2-version_2-128k.mp3',NULL,'waveform/a-1/xxz-test_2-version_2.png',NULL,'0:11','00:00','1','','','','','',1,'2011-06-08 13:40:21','0'),(7,'Tu hi re','album version','S. P. Balashubhramaniyam','Sony & BMG','artist',1,'','000000','flac/a-1/S._P._Balashubhramaniyam-Tu_hi_re-album_version.flac','mp3320k/a-1/S._P._Balashubhramaniyam-Tu_hi_re-album_version-320k.mp3','mp3128k/a-1/S._P._Balashubhramaniyam-Tu_hi_re-album_version-128k.mp3',NULL,'waveform/a-1/S._P._Balashubhramaniyam-Tu_hi_re-album_version.png',NULL,'0:47','00:00','0','','','','','',1,'2011-06-08 17:01:11','0'),(8,'Cyclist\'s Rythm','Album Version','A. R. Rahman','Sony & BMG','artist',1,'','000000','flac/a-1/A._R._Rahman-Cyclist_s_Rythm-Album_Version.flac','mp3320k/a-1/A._R._Rahman-Cyclist_s_Rythm-Album_Version-320k.mp3','mp3128k/a-1/A._R._Rahman-Cyclist_s_Rythm-Album_Version-128k.mp3','mp3320k/a-1/A._R._Rahman-Cyclist_s_Rythm-Album_Version-preview.mp3','waveform/a-1/A._R._Rahman-Cyclist_s_Rythm-Album_Version.png',NULL,'0:25','00:00','1','A. R. Rahman','','','','',1,'2011-06-09 04:24:28','0'),(9,'Bombay - Tu hi re','Album Version','S. P. Balashubhramaniyam','Sony & BMG','artist',1,'','000000','flac/a-1/S._P._Balashubhramaniyam-Bombay_-_Tu_hi_re-Album_Version.flac','mp3320k/a-1/S._P._Balashubhramaniyam-Bombay_-_Tu_hi_re-Album_Version-320k.mp3','mp3128k/a-1/S._P._Balashubhramaniyam-Bombay_-_Tu_hi_re-Album_Version-128k.mp3','mp3320k/a-1/preview/S._P._Balashubhramaniyam-Bombay_-_Tu_hi_re-Album_Version.mp3','waveform/a-1/S._P._Balashubhramaniyam-Bombay_-_Tu_hi_re-Album_Version.png','waveform/a-1/preview/S._P._Balashubhramaniyam-Bombay_-_Tu_hi_re-Album_Version.png','0:47','00:13','0','A. R. Rahman','','','','',1,'2011-06-10 02:09:49','0'),(10,'Sample 3','Album Version','xxx','xxx','artist',1,'yyy','000000','flac/a-1/xxx-Sample_3-Album_Version.flac','mp3320k/a-1/xxx-Sample_3-Album_Version-320k.mp3','mp3128k/a-1/xxx-Sample_3-Album_Version-128k.mp3','mp3320k/a-1/preview/xxx-Sample_3-Album_Version.mp3','waveform/a-1/xxx-Sample_3-Album_Version.png','waveform/a-1/preview/xxx-Sample_3-Album_Version.png','0:11','00:00','1','sss','sss,aaa','aa,uuifv','you','',1,'2011-06-10 03:08:38','0'),(11,'hhh','','zzz','Sony & BMG','artist',1,'','','flac/a-1/undefined-undefined-undefined.flac','mp3320k/a-1/undefined-undefined-undefined-320k.mp3','mp3128k/a-1/undefined-undefined-undefined-128k.mp3','mp3320k/a-1/preview/zzz-hhh.mp3','waveform/a-1/undefined-undefined-undefined.png','waveform/a-1/preview/zzz-hhh.png','0:11','00:10','1','jjj,opp','','','','...',1,'2011-06-20 04:12:58','0'),(12,'test 7','','zzz','Sony & BMG','artist',1,'test 1,test 2','','flac/a-1/zzz-test_7.flac','mp3320k/a-1/zzz-test_7-320k.mp3','mp3128k/a-1/zzz-test_7-128k.mp3','mp3320k/a-1/preview/zzz-test_7.mp3','waveform/a-1/zzz-test_7.png','waveform/a-1/preview/zzz-test_7.png','0:11','00:05','1','','','','','',1,'2011-06-20 04:19:53','0');

--
-- Table structure for table `subscription`
--

CREATE TABLE `subscription` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `type` enum('label','artist') default 'artist',
  `mapid` bigint(20) unsigned NOT NULL,
  `uid` bigint(20) unsigned NOT NULL,
  `newsletter` binary(1) default '1',
  `updates` binary(1) default '1',
  `created` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `deleted` binary(1) default '0',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `subscription`
--


--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `email` varchar(100) collate utf8_unicode_ci NOT NULL,
  `emaillang` varchar(100) collate utf8_unicode_ci NOT NULL,
  `password` varchar(255) collate utf8_unicode_ci NOT NULL,
  `name` varchar(30) collate utf8_unicode_ci NOT NULL,
  `surname` varchar(40) collate utf8_unicode_ci default NULL,
  `mobile` varchar(30) collate utf8_unicode_ci default NULL,
  `address` text collate utf8_unicode_ci,
  `zipcode` varchar(10) collate utf8_unicode_ci default NULL,
  `city` varchar(60) collate utf8_unicode_ci default NULL,
  `country` varchar(255) collate utf8_unicode_ci default NULL,
  `feedback` binary(1) default '0',
  `lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00',
  `iplast` varchar(15) collate utf8_unicode_ci default '000.000.000.000',
  `ip` varchar(15) collate utf8_unicode_ci default '000.000.000.000',
  `status` tinyint(4) default '0',
  `priority` tinyint(4) default '1',
  `created` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `deleted` binary(1) default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `user`
--

INSERT INTO `user` VALUES (1,'pras.svo@gmail.com','','e10adc3949ba59abbe56e057f20f883e','Prasun','Mukherjee','','','700135','Kolkata','India','0','0000-00-00 00:00:00','000.000.000.000','223.223.130.17',2,1,'2011-06-30 03:35:38','0');

--
-- Table structure for table `user_affiliation`
--

CREATE TABLE `user_affiliation` (
  `userid` bigint(20) unsigned NOT NULL,
  `affid` bigint(20) unsigned NOT NULL,
  `created` timestamp NOT NULL default CURRENT_TIMESTAMP,
  UNIQUE KEY `affiliation` (`userid`,`affid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `user_affiliation`
--

INSERT INTO `user_affiliation` VALUES (1,1,'2011-06-30 03:38:24');


