Rev 38 | Blame | Compare with Previous | Last modification | View Log | RSS feed
-- MySQL dump 10.13 Distrib 5.1.73, for redhat-linux-gnu (x86_64)---- Host: localhost Database: cheapmusic-- -------------------------------------------------------- Server version 5.1.73/*!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` int(10) unsigned NOT NULL,`name` varchar(1024) DEFAULT 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` int(10) unsigned NOT NULL,`name` varchar(1024) DEFAULT 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` int(10) unsigned NOT NULL,`mid` int(10) 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` int(10) unsigned NOT NULL,`profile` blob,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` int(10) unsigned NOT NULL,`url` varchar(1024) DEFAULT 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` int(10) unsigned NOT NULL,`name` varchar(1024) DEFAULT 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` int(10) unsigned NOT NULL,`name` varchar(1024) DEFAULT NULL,`realname` varchar(1024) 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` int(10) unsigned NOT NULL,`url` varchar(1024) DEFAULT 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` int(10) unsigned NOT NULL,`name` varchar(1024) DEFAULT NULL,`parentlabel` varchar(1024) DEFAULT NULL,`sublabel` varchar(4096) 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` int(10) unsigned NOT NULL,`aid` int(10) 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` int(10) unsigned NOT NULL,`rid` int(10) unsigned NOT NULL,`year` smallint(6) DEFAULT NULL,`title` varchar(1024) DEFAULT NULL,`genres` varchar(1024) DEFAULT NULL,`styles` varchar(1024) 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` int(10) unsigned NOT NULL,`aid` int(10) 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` int(10) unsigned NOT NULL,`lid` int(10) unsigned NOT NULL,`catno` varchar(128) DEFAULT NULL,KEY `releaseLabelsId` (`id`),KEY `releaseLabelsLId` (`lid`),KEY `releaseLabelsCatno` (`catno`)) 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` int(10) unsigned NOT NULL,`track` blob,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` int(10) unsigned NOT NULL,`mid` int(10) unsigned DEFAULT NULL,`title` varchar(1024) DEFAULT NULL,`country` varchar(64) DEFAULT NULL,`released` year(4) DEFAULT NULL,`barcode` varchar(16) DEFAULT NULL,`quantity` tinyint(3) unsigned DEFAULT NULL,`format` varchar(24) DEFAULT NULL,`formatExt` varchar(2048) DEFAULT NULL,`formats` varchar(1024) DEFAULT NULL,`genres` varchar(1024) DEFAULT NULL,`styles` varchar(1024) 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 `searches`--DROP TABLE IF EXISTS `searches`;/*!40101 SET @saved_cs_client = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `searches` (`id` bigint(14) NOT NULL AUTO_INCREMENT,`sessId` varchar(32) NOT NULL,`access` int(10) unsigned DEFAULT NULL,`country` char(2) NOT NULL DEFAULT 'US',`currency` char(3) NOT NULL DEFAULT 'USD',`zip` char(5) DEFAULT NULL,`condNew` char(1) DEFAULT 'Y',`condUsed` char(1) DEFAULT 'Y',`mediaCD` char(1) DEFAULT 'Y',`mediaRecord` char(1) DEFAULT 'N',`mediaDigital` char(1) DEFAULT 'N',`data` text,`lowNew` decimal(12,2) DEFAULT '0.00',`lowUsed` decimal(12,2) DEFAULT '0.00',`lowDigital` decimal(12,2) DEFAULT '0.00',`count` smallint(4) DEFAULT '0',`mediaBook` char(1) DEFAULT 'N',`lowBook` decimal(12,2) DEFAULT '0.00',`userId` int(11) DEFAULT NULL,PRIMARY KEY (`id`),KEY `userId` (`userId`)) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;/*!40101 SET character_set_client = @saved_cs_client */;---- Table structure for table `sessions`--DROP TABLE IF EXISTS `sessions`;/*!40101 SET @saved_cs_client = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `sessions` (`id` varchar(32) NOT NULL,`tab` bigint(12) NOT NULL,`access` int(10) unsigned DEFAULT NULL,`data` mediumtext,`userId` int(11) DEFAULT NULL,PRIMARY KEY (`id`,`tab`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;/*!40101 SET character_set_client = @saved_cs_client */;---- Table structure for table `transfers`--DROP TABLE IF EXISTS `transfers`;/*!40101 SET @saved_cs_client = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `transfers` (`id` bigint(14) NOT NULL AUTO_INCREMENT,`sessId` varchar(32) NOT NULL,`access` int(10) unsigned DEFAULT NULL,`url` text,`userId` int(11) DEFAULT NULL,PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;/*!40101 SET character_set_client = @saved_cs_client */;---- Table structure for table `users`--DROP TABLE IF EXISTS `users`;/*!40101 SET @saved_cs_client = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `users` (`id` int(11) NOT NULL AUTO_INCREMENT,`oauth_provider` enum('','facebook','google','twitter','linkedin') COLLATE utf8_unicode_ci NOT NULL,`oauth_uid` varchar(100) COLLATE utf8_unicode_ci NOT NULL,`first_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,`last_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,`email` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,`password` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,`picture` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,`zip` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,`username` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,`link` varchar(100) COLLATE utf8_unicode_ci NOT NULL,`activation_code` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,`forgot_pass_identity` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,`activated` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',`created` datetime NOT NULL,`modified` datetime NOT NULL,`status` enum('1','0') COLLATE utf8_unicode_ci NOT NULL DEFAULT '1' COMMENT '1=Active | 0=Inactive',PRIMARY KEY (`id`),KEY `email` (`email`),KEY `forgot_pass_identity` (`forgot_pass_identity`),KEY `activation_code` (`activation_code`)) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;/*!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 2019-06-23 8:08:32