Rev 44 | Blame | Compare with Previous | Last modification | View Log | RSS feed
/*!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 `artistAliases`--DROP TABLE IF EXISTS `artistAliases`;/*!40101 SET @saved_cs_client = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `artistAliases` (`id` mediumint(8) unsigned NOT NULL,`name` text NOT NULL,KEY `artistAliasesId` (`id`),KEY `artistAliasesName` (`name`(255))) ENGINE=InnoDB DEFAULT CHARSET=utf8;/*!40101 SET character_set_client = @saved_cs_client */;---- Table structure for table `artistGroups`--DROP TABLE IF EXISTS `artistGroups`;/*!40101 SET @saved_cs_client = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `artistGroups` (`id` mediumint(8) unsigned NOT NULL,`name` text NOT NULL,KEY `artistGroupsId` (`id`),KEY `artistGroupsName` (`name`(255))) ENGINE=InnoDB DEFAULT CHARSET=utf8;/*!40101 SET character_set_client = @saved_cs_client */;---- Table structure for table `artistMembers`--DROP TABLE IF EXISTS `artistMembers`;/*!40101 SET @saved_cs_client = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `artistMembers` (`id` mediumint(8) unsigned NOT NULL,`mid` mediumint(8) unsigned NOT NULL,KEY `artistMembersId` (`id`),KEY `artistMembersMId` (`mid`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;/*!40101 SET character_set_client = @saved_cs_client */;---- Table structure for table `artistProfiles`--DROP TABLE IF EXISTS `artistProfiles`;/*!40101 SET @saved_cs_client = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `artistProfiles` (`id` mediumint(8) unsigned NOT NULL,`profile` blob NOT NULL,PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;/*!40101 SET character_set_client = @saved_cs_client */;---- Table structure for table `artistUrls`--DROP TABLE IF EXISTS `artistUrls`;/*!40101 SET @saved_cs_client = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `artistUrls` (`id` mediumint(8) unsigned NOT NULL,`url` text NOT NULL,KEY `artistUrlsId` (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;/*!40101 SET character_set_client = @saved_cs_client */;---- Table structure for table `artistVariations`--DROP TABLE IF EXISTS `artistVariations`;/*!40101 SET @saved_cs_client = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `artistVariations` (`id` mediumint(8) unsigned NOT NULL,`name` text NOT NULL,KEY `artistVariationsId` (`id`),KEY `artistVariationsName` (`name`(255))) ENGINE=InnoDB DEFAULT CHARSET=utf8;/*!40101 SET character_set_client = @saved_cs_client */;---- Table structure for table `artists`--DROP TABLE IF EXISTS `artists`;/*!40101 SET @saved_cs_client = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `artists` (`id` mediumint(8) unsigned NOT NULL,`name` text DEFAULT NULL,`realname` text DEFAULT NULL,PRIMARY KEY (`id`),KEY `artistsName` (`name`(255))) ENGINE=InnoDB DEFAULT CHARSET=utf8;/*!40101 SET character_set_client = @saved_cs_client */;---- Table structure for table `labelUrls`--DROP TABLE IF EXISTS `labelUrls`;/*!40101 SET @saved_cs_client = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `labelUrls` (`id` mediumint(8) unsigned NOT NULL,`url` text NOT NULL,KEY `labelUrlsId` (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;/*!40101 SET character_set_client = @saved_cs_client */;---- Table structure for table `labels`--DROP TABLE IF EXISTS `labels`;/*!40101 SET @saved_cs_client = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `labels` (`id` mediumint(8) unsigned NOT NULL,`name` text DEFAULT NULL,`parentlabel` tinytext DEFAULT NULL,`sublabel` text DEFAULT NULL,PRIMARY KEY (`id`),KEY `labelsName` (`name`(255))) ENGINE=InnoDB DEFAULT CHARSET=utf8;/*!40101 SET character_set_client = @saved_cs_client */;---- Table structure for table `masterArtists`--DROP TABLE IF EXISTS `masterArtists`;/*!40101 SET @saved_cs_client = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `masterArtists` (`id` mediumint(8) unsigned NOT NULL,`aid` mediumint(8) unsigned NOT NULL,KEY `masterArtistsId` (`id`),KEY `masterArtistsAId` (`aid`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;/*!40101 SET character_set_client = @saved_cs_client */;---- Table structure for table `masters`--DROP TABLE IF EXISTS `masters`;/*!40101 SET @saved_cs_client = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `masters` (`id` mediumint(8) unsigned NOT NULL,`rid` mediumint(8) unsigned NOT NULL,`year` smallint(4) unsigned DEFAULT NULL,`title` text DEFAULT NULL,`genres` varchar(192) DEFAULT NULL,`styles` text DEFAULT NULL,PRIMARY KEY (`id`),KEY `mastersRId` (`rid`),KEY `mastersTitle` (`title`(255))) ENGINE=InnoDB DEFAULT CHARSET=utf8;/*!40101 SET character_set_client = @saved_cs_client */;---- Table structure for table `releaseArtists`--DROP TABLE IF EXISTS `releaseArtists`;/*!40101 SET @saved_cs_client = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `releaseArtists` (`id` mediumint(8) unsigned NOT NULL,`aid` mediumint(8) unsigned NOT NULL,KEY `releaseArtistsId` (`id`),KEY `releaseArtistsAId` (`aid`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;/*!40101 SET character_set_client = @saved_cs_client */;---- Table structure for table `releaseLabels`--DROP TABLE IF EXISTS `releaseLabels`;/*!40101 SET @saved_cs_client = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `releaseLabels` (`id` mediumint(8) unsigned NOT NULL,`lid` mediumint(8) unsigned DEFAULT NULL,`catno` text DEFAULT NULL,KEY `releaseLabelsId` (`id`),KEY `releaseLabelsLId` (`lid`),KEY `releaseLabelsCatno` (`catno`(255))) ENGINE=InnoDB DEFAULT CHARSET=utf8;/*!40101 SET character_set_client = @saved_cs_client */;---- Table structure for table `releaseTracks`--DROP TABLE IF EXISTS `releaseTracks`;/*!40101 SET @saved_cs_client = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `releaseTracks` (`id` mediumint(8) unsigned NOT NULL,`track` blob NOT NULL,PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;/*!40101 SET character_set_client = @saved_cs_client */;---- Table structure for table `releases`--DROP TABLE IF EXISTS `releases`;/*!40101 SET @saved_cs_client = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `releases` (`id` mediumint(8) unsigned NOT NULL,`mid` mediumint(8) unsigned DEFAULT NULL,`title` text DEFAULT NULL,`country` enum('Abkhazia','Afghanistan','Africa','Albania','Algeria','Andorra','Angola','Anguilla','Antigua & Barbuda','Antigua & Barbuda','Argentina','Armenia','Aruba','Asia','Australasia','Australia','Australia & New Zealand','Austria','Austria-Hungary','Azerbaijan','Bahamas, The','Bahrain','Bangladesh','Barbados','Belarus','Belgium','Belize','Benelux','Benin','Bermuda','Bhutan','Bohemia','Bolivia','Bosnia & Herzegovina','Botswana','Brazil','British Virgin Islands','Brunei','Bulgaria','Burkina Faso','Burma','Cambodia','Cameroon','Canada','Cape Verde','Cayman Islands','Central African Republic','Central America','Chad','Chile','China','Colombia','Comoros','Congo, Democratic Republic of the','Congo, Republic of the','Cook Islands','Costa Rica','Croatia','Cuba','Curaçao','Cyprus','Czech Republic','Czech Republic & Slovakia','Czechoslovakia','Dahomey','Denmark','Djibouti','Dominica','Dominican Republic','Dutch East Indies','East Timor','Ecuador','Egypt','El Salvador','Equatorial Guinea','Eritrea','Estonia','Ethiopia','Europe','Falkland Islands','Faroe Islands','Fiji','Finland','France','France & Benelux','French Guiana','French Polynesia','Gabon','Gambia, The','Gaza Strip','Georgia','German Democratic Republic (GDR)','Germany','Germany & Switzerland','Germany, Austria, & Switzerland','Ghana','Gibraltar','Greece','Greenland','Grenada','Guadeloupe','Guam','Guatemala','Guernsey','Guinea','Guinea-Bissau','Gulf Cooperation Council','Guyana','Haiti','Honduras','Hong Kong','Hungary','Iceland','India','Indochina','Indonesia','Iran','Iraq','Ireland','Israel','Italy','Ivory Coast','Jamaica','Japan','Jersey','Jordan','Kazakhstan','Kenya','Korea (pre-1945)','Kosovo','Kuwait','Kyrgyzstan','Laos','Latvia','Lebanon','Lesotho','Liberia','Libya','Liechtenstein','Lithuania','Luxembourg','Macau','Macedonia','Madagascar','Malawi','Malaysia','Maldives','Mali','Malta','Man, Isle of','Marshall Islands','Martinique','Mauritania','Mauritius','Mayotte','Mexico','Middle East','Moldova, Republic of','Monaco','Mongolia','Montenegro','Montserrat','Morocco','Mozambique','Namibia','Nepal','Netherlands','Netherlands Antilles','New Caledonia','New Zealand','Nicaragua','Niger','Nigeria','North America (inc Mexico)','North Korea','Northern Mariana Islands','Norway','Oman','Ottoman Empire','Pakistan','Palau','Panama','Papua New Guinea','Paraguay','Peru','Philippines','Poland','Portugal','Protectorate of Bohemia and Moravia','Puerto Rico','Qatar','Reunion','Rhodesia','Romania','Russia','Rwanda','Saint Helena','Saint Kitts and Nevis','Saint Lucia','Saint Vincent and the Grenadines','Samoa','San Marino','Sao Tome and Principe','Saudi Arabia','Scandinavia','Senegal','Serbia','Serbia and Montenegro','Seychelles','Sierra Leone','Singapore','Singapore, Malaysia & Hong Kong','Sint Maarten','Slovakia','Slovenia','Solomon Islands','Somalia','South Africa','South America','South East Asia','South Korea','South Pacific','South Vietnam','South West Africa','Southern Rhodesia','Southern Sudan','Spain','Sri Lanka','Sudan','Suriname','Swaziland','Sweden','Switzerland','Syria','Taiwan','Tajikistan','Tanzania','Thailand','Togo','Tonga','Trinidad & Tobago','Tunisia','Turkey','Turkmenistan','Turks and Caicos Islands','Uganda','UK','UK & Europe','UK & France','UK & Ireland','UK & US','UK, Europe & Israel','UK, Europe & Japan','UK, Europe & US','Ukraine','United Arab Emirates','Upper Volta','Uruguay','US','USA & Canada','USA & Europe','USA, Canada & Europe','USA, Canada & UK','USSR','Uzbekistan','Vanuatu','Vatican City','Venezuela','Vietnam','Virgin Islands','West Bank','Yemen','Yugoslavia','Zaire','Zambia','Zimbabwe'),`released` smallint(4) unsigned DEFAULT NULL,`barcode` char(14) DEFAULT NULL,`quantity` smallint(4) unsigned DEFAULT NULL,`format` enum('12"','4-Track Cartridge','8-Track Cartridge','Acetate','All Media','Betacam','Betacam SP','Betamax','Blu-ray','Blu-ray-R','Box Set','Cassette','CD','CDr','CDV','Cylinder','DAT','DC-International','DCC','DVD','DVDr','Edison Disc','Elcaset','File','Flexi-disc','Floppy Disk','HD DVD','Hybrid','Laserdisc','Lathe Cut','Memory Stick','Microcassette','Minidisc','MiniDV','MVD','NT Cassette','Pathé Disc','PlayTape','Pocket Rocker','RCA Tape Cartridge','Reel-To-Reel','SACD','SelectaVision','Shellac','Tefifon','U-matic','UMD','Various','VHD','VHS','Video 2000','Video8','Vinyl','Wire Recording') NOT NULL,`formatExt` text DEFAULT NULL,`formats` text DEFAULT NULL,`genres` varchar(163) DEFAULT NULL,`styles` text DEFAULT NULL,PRIMARY KEY (`id`),KEY `releasesMId` (`mid`),KEY `releasesTitle` (`title`(255)),KEY `releasesBarcode` (`barcode`),KEY `releasesFormat` (`format`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;/*!40101 SET character_set_client = @saved_cs_client */;---- Table structure for table `barcodes`--DROP TABLE IF EXISTS `barcodes`;/*!40101 SET @saved_cs_client = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `barcodes` (`id` mediumint(8) unsigned NOT NULL,`mid` mediumint(8) unsigned DEFAULT NULL,`country` enum('Abkhazia','Afghanistan','Africa','Albania','Algeria','Andorra','Angola','Anguilla','Antigua & Barbuda','Antigua & Barbuda','Argentina','Armenia','Aruba','Asia','Australasia','Australia','Australia & New Zealand','Austria','Austria-Hungary','Azerbaijan','Bahamas, The','Bahrain','Bangladesh','Barbados','Belarus','Belgium','Belize','Benelux','Benin','Bermuda','Bhutan','Bohemia','Bolivia','Bosnia & Herzegovina','Botswana','Brazil','British Virgin Islands','Brunei','Bulgaria','Burkina Faso','Burma','Cambodia','Cameroon','Canada','Cape Verde','Cayman Islands','Central African Republic','Central America','Chad','Chile','China','Colombia','Comoros','Congo, Democratic Republic of the','Congo, Republic of the','Cook Islands','Costa Rica','Croatia','Cuba','Curaçao','Cyprus','Czech Republic','Czech Republic & Slovakia','Czechoslovakia','Dahomey','Denmark','Djibouti','Dominica','Dominican Republic','Dutch East Indies','East Timor','Ecuador','Egypt','El Salvador','Equatorial Guinea','Eritrea','Estonia','Ethiopia','Europe','Falkland Islands','Faroe Islands','Fiji','Finland','France','France & Benelux','French Guiana','French Polynesia','Gabon','Gambia, The','Gaza Strip','Georgia','German Democratic Republic (GDR)','Germany','Germany & Switzerland','Germany, Austria, & Switzerland','Ghana','Gibraltar','Greece','Greenland','Grenada','Guadeloupe','Guam','Guatemala','Guernsey','Guinea','Guinea-Bissau','Gulf Cooperation Council','Guyana','Haiti','Honduras','Hong Kong','Hungary','Iceland','India','Indochina','Indonesia','Iran','Iraq','Ireland','Israel','Italy','Ivory Coast','Jamaica','Japan','Jersey','Jordan','Kazakhstan','Kenya','Korea (pre-1945)','Kosovo','Kuwait','Kyrgyzstan','Laos','Latvia','Lebanon','Lesotho','Liberia','Libya','Liechtenstein','Lithuania','Luxembourg','Macau','Macedonia','Madagascar','Malawi','Malaysia','Maldives','Mali','Malta','Man, Isle of','Marshall Islands','Martinique','Mauritania','Mauritius','Mayotte','Mexico','Middle East','Moldova, Republic of','Monaco','Mongolia','Montenegro','Montserrat','Morocco','Mozambique','Namibia','Nepal','Netherlands','Netherlands Antilles','New Caledonia','New Zealand','Nicaragua','Niger','Nigeria','North America (inc Mexico)','North Korea','Northern Mariana Islands','Norway','Oman','Ottoman Empire','Pakistan','Palau','Panama','Papua New Guinea','Paraguay','Peru','Philippines','Poland','Portugal','Protectorate of Bohemia and Moravia','Puerto Rico','Qatar','Reunion','Rhodesia','Romania','Russia','Rwanda','Saint Helena','Saint Kitts and Nevis','Saint Lucia','Saint Vincent and the Grenadines','Samoa','San Marino','Sao Tome and Principe','Saudi Arabia','Scandinavia','Senegal','Serbia','Serbia and Montenegro','Seychelles','Sierra Leone','Singapore','Singapore, Malaysia & Hong Kong','Sint Maarten','Slovakia','Slovenia','Solomon Islands','Somalia','South Africa','South America','South East Asia','South Korea','South Pacific','South Vietnam','South West Africa','Southern Rhodesia','Southern Sudan','Spain','Sri Lanka','Sudan','Suriname','Swaziland','Sweden','Switzerland','Syria','Taiwan','Tajikistan','Tanzania','Thailand','Togo','Tonga','Trinidad & Tobago','Tunisia','Turkey','Turkmenistan','Turks and Caicos Islands','Uganda','UK','UK & Europe','UK & France','UK & Ireland','UK & US','UK, Europe & Israel','UK, Europe & Japan','UK, Europe & US','Ukraine','United Arab Emirates','Upper Volta','Uruguay','US','USA & Canada','USA & Europe','USA, Canada & Europe','USA, Canada & UK','USSR','Uzbekistan','Vanuatu','Vatican City','Venezuela','Vietnam','Virgin Islands','West Bank','Yemen','Yugoslavia','Zaire','Zambia','Zimbabwe'),`released` smallint(4) unsigned DEFAULT NULL,`barcode` char(14) DEFAULT NULL,`quantity` smallint(4) unsigned DEFAULT NULL,`format` enum('12"','4-Track Cartridge','8-Track Cartridge','Acetate','All Media','Betacam','Betacam SP','Betamax','Blu-ray','Blu-ray-R','Box Set','Cassette','CD','CDr','CDV','Cylinder','DAT','DC-International','DCC','DVD','DVDr','Edison Disc','Elcaset','File','Flexi-disc','Floppy Disk','HD DVD','Hybrid','Laserdisc','Lathe Cut','Memory Stick','Microcassette','Minidisc','MiniDV','MVD','NT Cassette','Pathé Disc','PlayTape','Pocket Rocker','RCA Tape Cartridge','Reel-To-Reel','SACD','SelectaVision','Shellac','Tefifon','U-matic','UMD','Various','VHD','VHS','Video 2000','Video8','Vinyl','Wire Recording') NOT NULL,`formatExt` text DEFAULT NULL,PRIMARY KEY (`id`),KEY `releasesMId` (`mid`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;/*!40101 SET character_set_client = @saved_cs_client */;/*!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 */;