-- MySQL dump 10.14  Distrib 5.5.60-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: musicminer
-- ------------------------------------------------------
-- Server version	5.5.60-MariaDB

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

DROP TABLE IF EXISTS `artwork`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `artwork` (
  `RecID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `hash` tinytext NOT NULL,
  `Picture` mediumblob,
  PRIMARY KEY (`RecID`),
  KEY `hashindex` (`hash`(40))
) ENGINE=MyISAM AUTO_INCREMENT=76 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `counter`
--

DROP TABLE IF EXISTS `counter`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `counter` (
  `counter_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`counter_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fulltext`
--

DROP TABLE IF EXISTS `fulltext`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fulltext` (
  `ftindex` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `libraries`
--

DROP TABLE IF EXISTS `libraries`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `libraries` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `manufacturers_id` int(11) NOT NULL,
  `date_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `description` text,
  `logo_file` varchar(250) DEFAULT NULL,
  `database` varchar(250) DEFAULT NULL,
  `db_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_libraries_name` (`name`),
  KEY `idx_libraries_date_created` (`date_created`),
  KEY `idx_libraries_manufacturers_id` (`manufacturers_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `links`
--

DROP TABLE IF EXISTS `links`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `links` (
  `playlistNameRecID` int(10) unsigned NOT NULL,
  `metadataRecID` int(10) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `manufacturers`
--

DROP TABLE IF EXISTS `manufacturers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `manufacturers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `description` text,
  `logo_file` varchar(250) DEFAULT NULL,
  `database` varchar(250) DEFAULT NULL,
  `db_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_manufacturers_name` (`name`),
  KEY `idx_manufacturers_date_created` (`date_created`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `metadata`
--

DROP TABLE IF EXISTS `metadata`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `metadata` (
  `RecID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `Filename` varchar(255) NOT NULL,
  `Pathname` varchar(255) NOT NULL,
  `Duration` varchar(10) NOT NULL DEFAULT '',
  `CreationDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `ModificationDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `ReleaseDate` date NOT NULL DEFAULT '0000-00-00',
  `ChannelLayout` varchar(31) NOT NULL DEFAULT '',
  `AudioFileType` varchar(4) NOT NULL DEFAULT '',
  `FileType` varchar(4) NOT NULL DEFAULT '',
  `Channels` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `BitDepth` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `SampleRate` int(5) unsigned NOT NULL DEFAULT '0',
  `TotalFrames` int(10) unsigned NOT NULL DEFAULT '0',
  `Popularity` int(10) unsigned NOT NULL DEFAULT '0',
  `EntryDate` double NOT NULL DEFAULT '0',
  `ScannedDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `TouchedDate` double NOT NULL DEFAULT '0',
  `Volume` varchar(100) NOT NULL DEFAULT '',
  `Track` smallint(5) unsigned DEFAULT NULL,
  `Index` tinyint(3) unsigned DEFAULT NULL,
  `_Dirty` tinyint(3) unsigned DEFAULT NULL,
  `_Time` float unsigned DEFAULT NULL,
  `FilePath` text NOT NULL,
  `_FilePathHash` varchar(62) NOT NULL,
  `_AudioCRC` varchar(32) DEFAULT NULL,
  `_FlatCategory` varchar(255) NOT NULL DEFAULT '',
  `_Tags` varchar(255) DEFAULT NULL,
  `_UMID` varchar(64) NOT NULL DEFAULT '',
  `Split` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `Rating` smallint(5) unsigned NOT NULL DEFAULT '0',
  `_WaveformLink` int(10) unsigned NOT NULL DEFAULT '0',
  `_PictureLink` int(10) unsigned NOT NULL DEFAULT '0',
  `Time` time DEFAULT NULL,
  `Description` varchar(1000) DEFAULT NULL,
  `Source` varchar(64) DEFAULT NULL,
  `Category` varchar(64) DEFAULT NULL,
  `SubCategory` varchar(64) DEFAULT NULL,
  `Notes` varchar(255) DEFAULT NULL,
  `Show` varchar(62) DEFAULT NULL,
  `Library` varchar(64) DEFAULT NULL,
  `Keywords` varchar(1000) DEFAULT NULL,
  `Manufacturer` varchar(64) DEFAULT NULL,
  `Composer` varchar(512) DEFAULT NULL,
  `Arranger` varchar(128) DEFAULT NULL,
  `Artist` varchar(128) DEFAULT NULL,
  `Conductor` varchar(128) DEFAULT NULL,
  `Publisher` varchar(512) DEFAULT NULL,
  `Performer` varchar(128) DEFAULT NULL,
  `Mood` varchar(1000) DEFAULT NULL,
  `Usage` varchar(128) DEFAULT NULL,
  `LongID` varchar(128) DEFAULT NULL,
  `BPM` varchar(31) DEFAULT NULL,
  `ISRC` varchar(16) DEFAULT NULL,
  `Tempo` varchar(62) DEFAULT NULL,
  `TrackYear` varchar(10) DEFAULT NULL,
  `Key` varchar(15) DEFAULT NULL,
  `TrackTitle` varchar(128) DEFAULT NULL,
  `CDTitle` varchar(128) DEFAULT NULL,
  `CDDescription` varchar(512) DEFAULT NULL,
  `FeaturedInstrument` varchar(128) DEFAULT NULL,
  `Version` varchar(62) DEFAULT NULL,
  `UserComments` varchar(255) DEFAULT NULL,
  `URL` varchar(512) DEFAULT NULL,
  `Lyrics` text,
  `_OriginalFilename` varchar(255) DEFAULT NULL,
  `_PathnameLink` int(10) unsigned NOT NULL DEFAULT '0',
  `_VolumeLink` int(10) unsigned NOT NULL DEFAULT '0',
  `_CategoryLink` int(10) unsigned NOT NULL DEFAULT '0',
  `_SubCategoryLink` int(10) unsigned NOT NULL DEFAULT '0',
  `_ShowLink` int(10) unsigned NOT NULL DEFAULT '0',
  `_LibraryLink` int(10) unsigned NOT NULL DEFAULT '0',
  `_ManufacturerLink` int(10) unsigned NOT NULL DEFAULT '0',
  `_ComposerLink` int(10) unsigned NOT NULL DEFAULT '0',
  `_ArrangerLink` int(10) unsigned NOT NULL DEFAULT '0',
  `_ArtistLink` int(10) unsigned NOT NULL DEFAULT '0',
  `_ConductorLink` int(10) unsigned NOT NULL DEFAULT '0',
  `_PublisherLink` int(10) unsigned NOT NULL DEFAULT '0',
  `_PerformerLink` int(10) unsigned NOT NULL DEFAULT '0',
  `_MoodLink` int(10) unsigned NOT NULL DEFAULT '0',
  `_UsageLink` int(10) unsigned NOT NULL DEFAULT '0',
  `_BPMLink` int(10) unsigned NOT NULL DEFAULT '0',
  `_TrackYearLink` int(10) unsigned NOT NULL DEFAULT '0',
  `_KeyLink` int(10) unsigned NOT NULL DEFAULT '0',
  `_CDTitleLink` int(10) unsigned NOT NULL DEFAULT '0',
  `_FeaturedInstrumentLink` int(10) unsigned NOT NULL DEFAULT '0',
  `BWDescription` varchar(255) NOT NULL DEFAULT '',
  `BWOriginator` varchar(62) NOT NULL DEFAULT '',
  `BWOriginatorRef` varchar(62) NOT NULL DEFAULT '',
  `BWTimeStamp` int(10) unsigned DEFAULT '0',
  `BWTime` varchar(8) NOT NULL DEFAULT '',
  `BWDate` varchar(10) NOT NULL DEFAULT '',
  `ShortID` varchar(32) DEFAULT NULL,
  `GlobalComment` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`RecID`),
  UNIQUE KEY `_FilePathHash` (`_FilePathHash`),
  KEY `Pathnamelinkindex` (`_PathnameLink`),
  KEY `Volumelinkindex` (`_VolumeLink`),
  KEY `Categorylinkindex` (`_CategoryLink`),
  KEY `SubCategorylinkindex` (`_SubCategoryLink`),
  KEY `Showlinkindex` (`_ShowLink`),
  KEY `Librarylinkindex` (`_LibraryLink`),
  KEY `Manufacturerlinkindex` (`_ManufacturerLink`),
  KEY `Composerlinkindex` (`_ComposerLink`),
  KEY `Arrangerlinkindex` (`_ArrangerLink`),
  KEY `Artistlinkindex` (`_ArtistLink`),
  KEY `Conductorlinkindex` (`_ConductorLink`),
  KEY `Publisherlinkindex` (`_PublisherLink`),
  KEY `Performerlinkindex` (`_PerformerLink`),
  KEY `Moodlinkindex` (`_MoodLink`),
  KEY `Usagelinkindex` (`_UsageLink`),
  KEY `BPMlinkindex` (`_BPMLink`),
  KEY `TrackYearlinkindex` (`_TrackYearLink`),
  KEY `Keylinkindex` (`_KeyLink`),
  KEY `CDTitlelinkindex` (`_CDTitleLink`),
  KEY `FeaturedInstrumentlinkindex` (`_FeaturedInstrumentLink`),
  KEY `_PictureLinkindex` (`_PictureLink`),
  FULLTEXT KEY `search_index` (`Filename`,`Pathname`,`Description`,`Category`,`SubCategory`,`Library`,`CDTitle`,`Composer`,`Artist`,`TrackTitle`,`Keywords`,`UserComments`)
) ENGINE=MyISAM AUTO_INCREMENT=860 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `multitags`
--

DROP TABLE IF EXISTS `multitags`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `multitags` (
  `RecID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `tag_name` varchar(128) NOT NULL,
  `tag_type` varchar(128) NOT NULL,
  PRIMARY KEY (`RecID`),
  KEY `tag_name` (`tag_name`),
  KEY `tag_type` (`tag_type`)
) ENGINE=MyISAM AUTO_INCREMENT=732 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `multitagshash`
--

DROP TABLE IF EXISTS `multitagshash`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `multitagshash` (
  `RecID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id` int(10) unsigned DEFAULT NULL,
  `ids` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`RecID`),
  KEY `id` (`id`),
  KEY `ids` (`ids`)
) ENGINE=MyISAM AUTO_INCREMENT=28884 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `playlists`
--

DROP TABLE IF EXISTS `playlists`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `playlists` (
  `RecID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `playlistName` varchar(62) NOT NULL DEFAULT '',
  PRIMARY KEY (`RecID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `rdb_Arranger`
--

DROP TABLE IF EXISTS `rdb_Arranger`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rdb_Arranger` (
  `RecID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `Arranger` varchar(128) DEFAULT NULL,
  `weighting` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`RecID`),
  KEY `Arranger_key` (`Arranger`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `rdb_Artist`
--

DROP TABLE IF EXISTS `rdb_Artist`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rdb_Artist` (
  `RecID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `Artist` varchar(128) DEFAULT NULL,
  `weighting` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`RecID`),
  KEY `Artist_key` (`Artist`)
) ENGINE=MyISAM AUTO_INCREMENT=39 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `rdb_BPM`
--

DROP TABLE IF EXISTS `rdb_BPM`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rdb_BPM` (
  `RecID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `BPM` varchar(31) DEFAULT NULL,
  `weighting` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`RecID`),
  KEY `BPM_key` (`BPM`)
) ENGINE=MyISAM AUTO_INCREMENT=189 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `rdb_CDTitle`
--

DROP TABLE IF EXISTS `rdb_CDTitle`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rdb_CDTitle` (
  `RecID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `CDTitle` varchar(128) DEFAULT NULL,
  `weighting` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`RecID`),
  KEY `CDTitle_key` (`CDTitle`)
) ENGINE=MyISAM AUTO_INCREMENT=145 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `rdb_Category`
--

DROP TABLE IF EXISTS `rdb_Category`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rdb_Category` (
  `RecID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `Category` varchar(64) DEFAULT NULL,
  `weighting` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`RecID`),
  KEY `Category_key` (`Category`)
) ENGINE=MyISAM AUTO_INCREMENT=57 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `rdb_Composer`
--

DROP TABLE IF EXISTS `rdb_Composer`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rdb_Composer` (
  `RecID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `Composer` varchar(512) DEFAULT NULL,
  `weighting` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`RecID`),
  KEY `Composer_key` (`Composer`(330))
) ENGINE=MyISAM AUTO_INCREMENT=59 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `rdb_Conductor`
--

DROP TABLE IF EXISTS `rdb_Conductor`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rdb_Conductor` (
  `RecID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `Conductor` varchar(128) DEFAULT NULL,
  `weighting` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`RecID`),
  KEY `Conductor_key` (`Conductor`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `rdb_FeaturedInstrument`
--

DROP TABLE IF EXISTS `rdb_FeaturedInstrument`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rdb_FeaturedInstrument` (
  `RecID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `FeaturedInstrument` varchar(128) DEFAULT NULL,
  `weighting` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`RecID`),
  KEY `FeaturedInstrument_key` (`FeaturedInstrument`)
) ENGINE=MyISAM AUTO_INCREMENT=154 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `rdb_Key`
--

DROP TABLE IF EXISTS `rdb_Key`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rdb_Key` (
  `RecID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `Key` varchar(15) DEFAULT NULL,
  `weighting` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`RecID`),
  KEY `Key_key` (`Key`)
) ENGINE=MyISAM AUTO_INCREMENT=52 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `rdb_Library`
--

DROP TABLE IF EXISTS `rdb_Library`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rdb_Library` (
  `RecID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `Library` varchar(64) DEFAULT NULL,
  `weighting` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`RecID`),
  KEY `Library_key` (`Library`)
) ENGINE=MyISAM AUTO_INCREMENT=37 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `rdb_Manufacturer`
--

DROP TABLE IF EXISTS `rdb_Manufacturer`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rdb_Manufacturer` (
  `RecID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `Manufacturer` varchar(64) DEFAULT NULL,
  `weighting` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`RecID`),
  KEY `Manufacturer_key` (`Manufacturer`)
) ENGINE=MyISAM AUTO_INCREMENT=44 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `rdb_Mood`
--

DROP TABLE IF EXISTS `rdb_Mood`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rdb_Mood` (
  `RecID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `Mood` varchar(255) DEFAULT NULL,
  `weighting` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`RecID`),
  KEY `Mood_key` (`Mood`)
) ENGINE=MyISAM AUTO_INCREMENT=109 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `rdb_Pathname`
--

DROP TABLE IF EXISTS `rdb_Pathname`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rdb_Pathname` (
  `RecID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `Pathname` varchar(256) DEFAULT NULL,
  `weighting` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`RecID`),
  KEY `Pathname_key` (`Pathname`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `rdb_Performer`
--

DROP TABLE IF EXISTS `rdb_Performer`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rdb_Performer` (
  `RecID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `Performer` varchar(128) DEFAULT NULL,
  `weighting` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`RecID`),
  KEY `Performer_key` (`Performer`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `rdb_Publisher`
--

DROP TABLE IF EXISTS `rdb_Publisher`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rdb_Publisher` (
  `RecID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `Publisher` varchar(512) DEFAULT NULL,
  `weighting` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`RecID`),
  KEY `Publisher_key` (`Publisher`(330))
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `rdb_Show`
--

DROP TABLE IF EXISTS `rdb_Show`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rdb_Show` (
  `RecID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `Show` varchar(62) DEFAULT NULL,
  `weighting` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`RecID`),
  KEY `Show_key` (`Show`)
) ENGINE=MyISAM AUTO_INCREMENT=52 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `rdb_SubCategory`
--

DROP TABLE IF EXISTS `rdb_SubCategory`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rdb_SubCategory` (
  `RecID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `SubCategory` varchar(64) DEFAULT NULL,
  `weighting` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`RecID`),
  KEY `SubCategory_key` (`SubCategory`)
) ENGINE=MyISAM AUTO_INCREMENT=224 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `rdb_TrackYear`
--

DROP TABLE IF EXISTS `rdb_TrackYear`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rdb_TrackYear` (
  `RecID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `TrackYear` varchar(10) DEFAULT NULL,
  `weighting` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`RecID`),
  KEY `TrackYear_key` (`TrackYear`)
) ENGINE=MyISAM AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `rdb_Usage`
--

DROP TABLE IF EXISTS `rdb_Usage`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rdb_Usage` (
  `RecID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `Usage` varchar(128) DEFAULT NULL,
  `weighting` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`RecID`),
  KEY `Usage_key` (`Usage`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `rdb_Volume`
--

DROP TABLE IF EXISTS `rdb_Volume`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rdb_Volume` (
  `RecID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `Volume` varchar(100) DEFAULT NULL,
  `weighting` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`RecID`),
  KEY `Volume_key` (`Volume`)
) ENGINE=MyISAM AUTO_INCREMENT=34 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `schema`
--

DROP TABLE IF EXISTS `schema`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `schema` (
  `schema` varchar(30) NOT NULL DEFAULT '',
  `version` tinyint(3) unsigned DEFAULT NULL,
  `version_min` tinyint(3) unsigned DEFAULT NULL,
  `UMID` varchar(128) NOT NULL,
  `sm_version` varchar(255) DEFAULT NULL,
  `display_name` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 MAX_ROWS=1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `uuid`
--

DROP TABLE IF EXISTS `uuid`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `uuid` (
  `_UMID` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `waveform`
--

DROP TABLE IF EXISTS `waveform`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `waveform` (
  `RecID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `FilePath` text NOT NULL,
  `WaveformLength` int(10) unsigned DEFAULT NULL,
  `WaveformData` mediumblob,
  `WaveformRep` mediumblob,
  `SpectroRep` mediumblob,
  PRIMARY KEY (`RecID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 MAX_ROWS=4200000000;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!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 2022-03-30 23:04:49
