delimiter $$

CREATE TABLE `SongArtists` (
  `ID` int(10) NOT NULL auto_increment,
  `ArtistName` varchar(255) NOT NULL,
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `ArtistName_Index` (`ArtistName`)
) ENGINE=InnoDB AUTO_INCREMENT=55786 DEFAULT CHARSET=latin1$$;

delimiter $$

CREATE TABLE `SongArtistsFeaturedInSongs` (
  `ID` int(10) NOT NULL auto_increment,
  `SongArtistID` int(10) NOT NULL,
  `SongID` int(10) NOT NULL,
  PRIMARY KEY  (`ID`),
  KEY `FK_SongArtistsFeaturedInSongs_Song` (`SongID`),
  KEY `FK_SongArtistsFeaturedInSongs_SongArtists` (`SongArtistID`),
  CONSTRAINT `FK_SongArtistsFeaturedInSongs_SongArtists` FOREIGN KEY (`SongArtistID`) REFERENCES `SongArtists` (`ID`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `FK_SongArtistsFeaturedInSongs_Song` FOREIGN KEY (`SongID`) REFERENCES `Songs` (`ID`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=7808 DEFAULT CHARSET=latin1$$;

delimiter $$

CREATE TABLE `SongArtistsInSongs` (
  `ID` int(10) NOT NULL auto_increment,
  `SongArtistID` int(10) NOT NULL,
  `SongID` int(10) NOT NULL,
  PRIMARY KEY  (`ID`),
  KEY `FK_SongArtistsInSongs_SongArtists` (`SongArtistID`),
  KEY `FK_SongArtistsInSongs_Songs` (`SongID`),
  CONSTRAINT `FK_SongArtistsInSongs_SongArtists` FOREIGN KEY (`SongArtistID`) REFERENCES `SongArtists` (`ID`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `FK_SongArtistsInSongs_Songs` FOREIGN KEY (`SongID`) REFERENCES `Songs` (`ID`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=185125 DEFAULT CHARSET=latin1$$;

delimiter $$

CREATE TABLE `Songs` (
  `ID` int(11) NOT NULL auto_increment,
  `MMSerial` int(10) unsigned NOT NULL,
  `SongName` varchar(255) NOT NULL,
  `AlbumName` varchar(255) default NULL,
  `Rating` int(11) NOT NULL,
  `AudioRating` int(11) default NULL,
  `DateAdded` datetime NOT NULL,
  `DateModified` datetime NOT NULL,
  `LabelName` varchar(255) NOT NULL,
  `SubLabelName` varchar(255) NOT NULL default '',
  `Year` int(11) default NULL,
  `BPM` int(11) default NULL,
  `Genre` varchar(45) default NULL,
  `LegacyDBID` int(11) default NULL,
  `DateActive` datetime default NULL,
  `DateExpired` datetime default NULL,
  `DateVideoDeployed` datetime NOT NULL,
  `DateVideoRecalled` datetime default NULL,
  `CreatedBy` varchar(45) default NULL,
  `OTSYear` int(11) default NULL,
  `OTSAlbumName` varchar(255) default NULL,
  `OTSAlbumCopyright` varchar(255) default NULL,
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `MMSerial_UNIQUE` (`MMSerial`),
  KEY `IX_SONGNAME` (`SongName`)
) ENGINE=InnoDB AUTO_INCREMENT=3055723 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC$$;

delimiter $$

CREATE TABLE `SongCategories` (
  `ID` int(10) NOT NULL auto_increment,
  `CategoryName` varchar(245) NOT NULL,
  PRIMARY KEY  USING BTREE (`ID`),
  UNIQUE KEY `UQ_SONGCATEGORYNAME` USING BTREE (`CategoryName`)
) ENGINE=InnoDB AUTO_INCREMENT=359 DEFAULT CHARSET=latin1$$;

delimiter $$

CREATE TABLE `SongsInCategories` (
  `ID` int(10) NOT NULL auto_increment,
  `SongID` int(10) NOT NULL,
  `CategoryID` int(10) NOT NULL,
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `UQ_SONGSINCATEGORIES` (`SongID`,`CategoryID`),
  KEY `Cat_Index` (`CategoryID`),
  KEY `FK_SONGCATEGORYLINK_SONGS` (`SongID`),
  KEY `FK_SONGCATEGORYLINK_CATEGORIES` (`CategoryID`),
  KEY `FK_SONGSINCATEGORIES` (`SongID`),
  KEY `FK_SONGSINCATEGORIES_CATEGORY` (`CategoryID`),
  CONSTRAINT `FK_SONGSINCATEGORIES_CATEGORY` FOREIGN KEY (`CategoryID`) REFERENCES `SongCategories` (`ID`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `FK_SONGSINCATEGORIES_SONGS` FOREIGN KEY (`SongID`) REFERENCES `Songs` (`ID`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=260221 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC$$;