-- MySQL dump 10.13  Distrib 5.7.12, for Win64 (x86_64)
--
-- Host: localhost    Database: playlist
-- ------------------------------------------------------
-- Server version	5.7.12-log

/*!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 */;

CREATE SCHEMA playlist_demo;
USE playlist_demo;

--
-- Table structure for table `album`
--

DROP TABLE IF EXISTS `album`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `album` (
  `title` varchar(100) NOT NULL,
  `albumdate` date NOT NULL,
  `artist` varchar(100) NOT NULL,
  PRIMARY KEY (`title`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `album`
--

LOCK TABLES `album` WRITE;
/*!40000 ALTER TABLE `album` DISABLE KEYS */;
/*!40000 ALTER TABLE `album` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `artifact`
--

DROP TABLE IF EXISTS `artifact`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `artifact` (
  `id` int(11) NOT NULL,
  `plname` varchar(100) DEFAULT NULL,
  `end` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `artifact`
--

LOCK TABLES `artifact` WRITE;
/*!40000 ALTER TABLE `artifact` DISABLE KEYS */;
/*!40000 ALTER TABLE `artifact` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `artifactartist`
--

DROP TABLE IF EXISTS `artifactartist`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `artifactartist` (
  `id` int(11) NOT NULL,
  `artist` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `artifactartist`
--

LOCK TABLES `artifactartist` WRITE;
/*!40000 ALTER TABLE `artifactartist` DISABLE KEYS */;
/*!40000 ALTER TABLE `artifactartist` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `artifactplaylist`
--

DROP TABLE IF EXISTS `artifactplaylist`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `artifactplaylist` (
  `id` int(11) NOT NULL,
  `playlist` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `artifactplaylist`
--

LOCK TABLES `artifactplaylist` WRITE;
/*!40000 ALTER TABLE `artifactplaylist` DISABLE KEYS */;
/*!40000 ALTER TABLE `artifactplaylist` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `artifacttrack`
--

DROP TABLE IF EXISTS `artifacttrack`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `artifacttrack` (
  `id` int(11) NOT NULL,
  `number` int(11) NOT NULL,
  `album` varchar(100) NOT NULL,
  PRIMARY KEY (`id`,`number`,`album`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `artifacttrack`
--

LOCK TABLES `artifacttrack` WRITE;
/*!40000 ALTER TABLE `artifacttrack` DISABLE KEYS */;
/*!40000 ALTER TABLE `artifacttrack` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `artist`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `artist` (
  `name` varchar(100) NOT NULL,
  `physicalgroup` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `artist` WRITE;
/*!40000 ALTER TABLE `artist` DISABLE KEYS */;
/*!40000 ALTER TABLE `artist` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `del_album`
--

DROP TABLE IF EXISTS `del_album`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `del_album` (
  `title` varchar(100) NOT NULL,
  PRIMARY KEY (`title`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `del_album`
--

LOCK TABLES `del_album` WRITE;
/*!40000 ALTER TABLE `del_album` DISABLE KEYS */;
/*!40000 ALTER TABLE `del_album` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `del_albumdate`
--

DROP TABLE IF EXISTS `del_albumdate`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `del_albumdate` (
  `title` varchar(100) NOT NULL,
  `albumdate` date DEFAULT NULL,
  PRIMARY KEY (`title`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `del_albumdate`
--

LOCK TABLES `del_albumdate` WRITE;
/*!40000 ALTER TABLE `del_albumdate` DISABLE KEYS */;
/*!40000 ALTER TABLE `del_albumdate` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `del_artifact`
--

DROP TABLE IF EXISTS `del_artifact`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `del_artifact` (
  `id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `del_artifact`
--

LOCK TABLES `del_artifact` WRITE;
/*!40000 ALTER TABLE `del_artifact` DISABLE KEYS */;
/*!40000 ALTER TABLE `del_artifact` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `del_artifactartist`
--

DROP TABLE IF EXISTS `del_artifactartist`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `del_artifactartist` (
  `id` int(11) NOT NULL,
  `artist` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `del_artifactartist`
--

LOCK TABLES `del_artifactartist` WRITE;
/*!40000 ALTER TABLE `del_artifactartist` DISABLE KEYS */;
/*!40000 ALTER TABLE `del_artifactartist` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `del_artifactend`
--

DROP TABLE IF EXISTS `del_artifactend`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `del_artifactend` (
  `id` int(11) NOT NULL,
  `end` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `del_artifactend`
--

LOCK TABLES `del_artifactend` WRITE;
/*!40000 ALTER TABLE `del_artifactend` DISABLE KEYS */;
/*!40000 ALTER TABLE `del_artifactend` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `del_artifactplaylist`
--

DROP TABLE IF EXISTS `del_artifactplaylist`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `del_artifactplaylist` (
  `id` int(11) NOT NULL,
  `playlist` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `del_artifactplaylist`
--

LOCK TABLES `del_artifactplaylist` WRITE;
/*!40000 ALTER TABLE `del_artifactplaylist` DISABLE KEYS */;
/*!40000 ALTER TABLE `del_artifactplaylist` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `del_artifactplname`
--

DROP TABLE IF EXISTS `del_artifactplname`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `del_artifactplname` (
  `id` int(11) NOT NULL,
  `plname` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `del_artifactplname`
--

LOCK TABLES `del_artifactplname` WRITE;
/*!40000 ALTER TABLE `del_artifactplname` DISABLE KEYS */;
/*!40000 ALTER TABLE `del_artifactplname` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `del_artifacttrack`
--

DROP TABLE IF EXISTS `del_artifacttrack`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `del_artifacttrack` (
  `id` int(11) NOT NULL,
  `number` int(11) NOT NULL,
  `album` varchar(100) NOT NULL,
  PRIMARY KEY (`id`,`number`,`album`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `del_artifacttrack`
--

LOCK TABLES `del_artifacttrack` WRITE;
/*!40000 ALTER TABLE `del_artifacttrack` DISABLE KEYS */;
/*!40000 ALTER TABLE `del_artifacttrack` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `del_artist`
--

DROP TABLE IF EXISTS `del_artist`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `del_artist` (
  `name` varchar(100) NOT NULL,
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `del_artist`
--

LOCK TABLES `del_artist` WRITE;
/*!40000 ALTER TABLE `del_artist` DISABLE KEYS */;
/*!40000 ALTER TABLE `del_artist` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `del_artistgroup`
--

DROP TABLE IF EXISTS `del_artistgroup`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `del_artistgroup` (
  `name` varchar(100) NOT NULL,
  `physicialgroup` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `del_artistgroup`
--

LOCK TABLES `del_artistgroup` WRITE;
/*!40000 ALTER TABLE `del_artistgroup` DISABLE KEYS */;
/*!40000 ALTER TABLE `del_artistgroup` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `del_bonus`
--

DROP TABLE IF EXISTS `del_bonus`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `del_bonus` (
  `number` int(11) NOT NULL,
  `album` varchar(100) NOT NULL,
  `specialedition` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`number`,`album`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `del_bonus`
--

LOCK TABLES `del_bonus` WRITE;
/*!40000 ALTER TABLE `del_bonus` DISABLE KEYS */;
/*!40000 ALTER TABLE `del_bonus` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `del_playlist`
--

DROP TABLE IF EXISTS `del_playlist`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `del_playlist` (
  `name` varchar(100) NOT NULL,
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `del_playlist`
--

LOCK TABLES `del_playlist` WRITE;
/*!40000 ALTER TABLE `del_playlist` DISABLE KEYS */;
/*!40000 ALTER TABLE `del_playlist` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `del_recordedby`
--

DROP TABLE IF EXISTS `del_recordedby`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `del_recordedby` (
  `title` varchar(100) NOT NULL,
  `artist` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`title`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `del_recordedby`
--

LOCK TABLES `del_recordedby` WRITE;
/*!40000 ALTER TABLE `del_recordedby` DISABLE KEYS */;
/*!40000 ALTER TABLE `del_recordedby` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `del_specialedition`
--

DROP TABLE IF EXISTS `del_specialedition`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `del_specialedition` (
  `title` varchar(100) NOT NULL,
  PRIMARY KEY (`title`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `del_specialedition`
--

LOCK TABLES `del_specialedition` WRITE;
/*!40000 ALTER TABLE `del_specialedition` DISABLE KEYS */;
/*!40000 ALTER TABLE `del_specialedition` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `del_track`
--

DROP TABLE IF EXISTS `del_track`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `del_track` (
  `number` int(11) NOT NULL,
  `album` varchar(100) NOT NULL,
  PRIMARY KEY (`number`,`album`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `del_track`
--

LOCK TABLES `del_track` WRITE;
/*!40000 ALTER TABLE `del_track` DISABLE KEYS */;
/*!40000 ALTER TABLE `del_track` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `del_trackduration`
--

DROP TABLE IF EXISTS `del_trackduration`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `del_trackduration` (
  `number` int(11) NOT NULL,
  `album` varchar(100) NOT NULL,
  `duration` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`number`,`album`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `del_trackduration`
--

LOCK TABLES `del_trackduration` WRITE;
/*!40000 ALTER TABLE `del_trackduration` DISABLE KEYS */;
/*!40000 ALTER TABLE `del_trackduration` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `del_trackin`
--

DROP TABLE IF EXISTS `del_trackin`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `del_trackin` (
  `number` int(11) NOT NULL,
  `album` varchar(100) NOT NULL,
  `playlist` varchar(100) NOT NULL,
  PRIMARY KEY (`number`,`album`,`playlist`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `del_trackin`
--

LOCK TABLES `del_trackin` WRITE;
/*!40000 ALTER TABLE `del_trackin` DISABLE KEYS */;
/*!40000 ALTER TABLE `del_trackin` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `del_trackname`
--

DROP TABLE IF EXISTS `del_trackname`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `del_trackname` (
  `number` int(11) NOT NULL,
  `album` varchar(100) NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`number`,`album`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `del_trackname`
--

LOCK TABLES `del_trackname` WRITE;
/*!40000 ALTER TABLE `del_trackname` DISABLE KEYS */;
/*!40000 ALTER TABLE `del_trackname` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ins_album`
--

DROP TABLE IF EXISTS `ins_album`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ins_album` (
  `title` varchar(100) NOT NULL,
  PRIMARY KEY (`title`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ins_album`
--

LOCK TABLES `ins_album` WRITE;
/*!40000 ALTER TABLE `ins_album` DISABLE KEYS */;
/*!40000 ALTER TABLE `ins_album` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ins_albumdate`
--

DROP TABLE IF EXISTS `ins_albumdate`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ins_albumdate` (
  `title` varchar(100) NOT NULL,
  `albumdate` date DEFAULT NULL,
  PRIMARY KEY (`title`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ins_albumdate`
--

LOCK TABLES `ins_albumdate` WRITE;
/*!40000 ALTER TABLE `ins_albumdate` DISABLE KEYS */;
/*!40000 ALTER TABLE `ins_albumdate` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ins_artifact`
--

DROP TABLE IF EXISTS `ins_artifact`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ins_artifact` (
  `id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ins_artifact`
--

LOCK TABLES `ins_artifact` WRITE;
/*!40000 ALTER TABLE `ins_artifact` DISABLE KEYS */;
/*!40000 ALTER TABLE `ins_artifact` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ins_artifactartist`
--

DROP TABLE IF EXISTS `ins_artifactartist`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ins_artifactartist` (
  `id` int(11) NOT NULL,
  `artist` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ins_artifactartist`
--

LOCK TABLES `ins_artifactartist` WRITE;
/*!40000 ALTER TABLE `ins_artifactartist` DISABLE KEYS */;
/*!40000 ALTER TABLE `ins_artifactartist` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ins_artifactend`
--

DROP TABLE IF EXISTS `ins_artifactend`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ins_artifactend` (
  `id` int(11) NOT NULL,
  `end` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ins_artifactend`
--

LOCK TABLES `ins_artifactend` WRITE;
/*!40000 ALTER TABLE `ins_artifactend` DISABLE KEYS */;
/*!40000 ALTER TABLE `ins_artifactend` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ins_artifactplaylist`
--

DROP TABLE IF EXISTS `ins_artifactplaylist`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ins_artifactplaylist` (
  `id` int(11) NOT NULL,
  `playlist` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ins_artifactplaylist`
--

LOCK TABLES `ins_artifactplaylist` WRITE;
/*!40000 ALTER TABLE `ins_artifactplaylist` DISABLE KEYS */;
/*!40000 ALTER TABLE `ins_artifactplaylist` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ins_artifactplname`
--

DROP TABLE IF EXISTS `ins_artifactplname`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ins_artifactplname` (
  `id` int(11) NOT NULL,
  `plname` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ins_artifactplname`
--

LOCK TABLES `ins_artifactplname` WRITE;
/*!40000 ALTER TABLE `ins_artifactplname` DISABLE KEYS */;
/*!40000 ALTER TABLE `ins_artifactplname` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ins_artifacttrack`
--

DROP TABLE IF EXISTS `ins_artifacttrack`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ins_artifacttrack` (
  `id` int(11) NOT NULL,
  `number` int(11) NOT NULL,
  `album` varchar(100) NOT NULL,
  PRIMARY KEY (`id`,`number`,`album`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ins_artifacttrack`
--

LOCK TABLES `ins_artifacttrack` WRITE;
/*!40000 ALTER TABLE `ins_artifacttrack` DISABLE KEYS */;
/*!40000 ALTER TABLE `ins_artifacttrack` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ins_artist`
--

DROP TABLE IF EXISTS `ins_artist`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ins_artist` (
  `name` varchar(100) NOT NULL,
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ins_artist`
--

LOCK TABLES `ins_artist` WRITE;
/*!40000 ALTER TABLE `ins_artist` DISABLE KEYS */;
/*!40000 ALTER TABLE `ins_artist` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ins_artistgroup`
--

DROP TABLE IF EXISTS `ins_artistgroup`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ins_artistgroup` (
  `name` varchar(100) NOT NULL,
  `physicialgroup` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ins_artistgroup`
--

LOCK TABLES `ins_artistgroup` WRITE;
/*!40000 ALTER TABLE `ins_artistgroup` DISABLE KEYS */;
/*!40000 ALTER TABLE `ins_artistgroup` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ins_bonus`
--

DROP TABLE IF EXISTS `ins_bonus`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ins_bonus` (
  `number` int(11) NOT NULL,
  `album` varchar(100) NOT NULL,
  `specialedition` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`number`,`album`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ins_bonus`
--

LOCK TABLES `ins_bonus` WRITE;
/*!40000 ALTER TABLE `ins_bonus` DISABLE KEYS */;
/*!40000 ALTER TABLE `ins_bonus` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ins_playlist`
--

DROP TABLE IF EXISTS `ins_playlist`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ins_playlist` (
  `name` varchar(100) NOT NULL,
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ins_playlist`
--

LOCK TABLES `ins_playlist` WRITE;
/*!40000 ALTER TABLE `ins_playlist` DISABLE KEYS */;
/*!40000 ALTER TABLE `ins_playlist` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ins_recordedby`
--

DROP TABLE IF EXISTS `ins_recordedby`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ins_recordedby` (
  `title` varchar(100) NOT NULL,
  `artist` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`title`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ins_recordedby`
--

LOCK TABLES `ins_recordedby` WRITE;
/*!40000 ALTER TABLE `ins_recordedby` DISABLE KEYS */;
/*!40000 ALTER TABLE `ins_recordedby` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ins_specialedition`
--

DROP TABLE IF EXISTS `ins_specialedition`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ins_specialedition` (
  `title` varchar(100) NOT NULL,
  PRIMARY KEY (`title`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ins_specialedition`
--

LOCK TABLES `ins_specialedition` WRITE;
/*!40000 ALTER TABLE `ins_specialedition` DISABLE KEYS */;
/*!40000 ALTER TABLE `ins_specialedition` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ins_track`
--

DROP TABLE IF EXISTS `ins_track`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ins_track` (
  `number` int(11) NOT NULL,
  `album` varchar(100) NOT NULL,
  PRIMARY KEY (`number`,`album`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ins_track`
--

LOCK TABLES `ins_track` WRITE;
/*!40000 ALTER TABLE `ins_track` DISABLE KEYS */;
/*!40000 ALTER TABLE `ins_track` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ins_trackduration`
--

DROP TABLE IF EXISTS `ins_trackduration`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ins_trackduration` (
  `number` int(11) NOT NULL,
  `album` varchar(100) NOT NULL,
  `duration` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`number`,`album`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ins_trackduration`
--

LOCK TABLES `ins_trackduration` WRITE;
/*!40000 ALTER TABLE `ins_trackduration` DISABLE KEYS */;
/*!40000 ALTER TABLE `ins_trackduration` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ins_trackin`
--

DROP TABLE IF EXISTS `ins_trackin`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ins_trackin` (
  `number` int(11) NOT NULL,
  `album` varchar(100) NOT NULL,
  `playlist` varchar(100) NOT NULL,
  PRIMARY KEY (`number`,`album`,`playlist`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ins_trackin`
--

LOCK TABLES `ins_trackin` WRITE;
/*!40000 ALTER TABLE `ins_trackin` DISABLE KEYS */;
/*!40000 ALTER TABLE `ins_trackin` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ins_trackname`
--

DROP TABLE IF EXISTS `ins_trackname`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ins_trackname` (
  `number` int(11) NOT NULL,
  `album` varchar(100) NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`number`,`album`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ins_trackname`
--

LOCK TABLES `ins_trackname` WRITE;
/*!40000 ALTER TABLE `ins_trackname` DISABLE KEYS */;
/*!40000 ALTER TABLE `ins_trackname` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `playlist`
--

DROP TABLE IF EXISTS `playlist`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `playlist` (
  `name` varchar(100) NOT NULL,
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `playlist`
--

LOCK TABLES `playlist` WRITE;
/*!40000 ALTER TABLE `playlist` DISABLE KEYS */;
/*!40000 ALTER TABLE `playlist` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `specialedition`
--

DROP TABLE IF EXISTS `specialedition`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `specialedition` (
  `title` varchar(100) NOT NULL,
  PRIMARY KEY (`title`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `specialedition`
--

LOCK TABLES `specialedition` WRITE;
/*!40000 ALTER TABLE `specialedition` DISABLE KEYS */;
/*!40000 ALTER TABLE `specialedition` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `track`
--

DROP TABLE IF EXISTS `track`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `track` (
  `number` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `duration` double NOT NULL,
  `album` varchar(100) NOT NULL,
  `specialedition` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`number`,`album`),
  KEY `specialedition` (`specialedition`),
  CONSTRAINT `track_ibfk_1` FOREIGN KEY (`specialedition`) REFERENCES `specialedition` (`title`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `track`
--

LOCK TABLES `track` WRITE;
/*!40000 ALTER TABLE `track` DISABLE KEYS */;
/*!40000 ALTER TABLE `track` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `trackin`
--

DROP TABLE IF EXISTS `trackin`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `trackin` (
  `number` int(11) NOT NULL,
  `album` varchar(100) NOT NULL,
  `playlist` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`number`,`album`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `trackin`
--

LOCK TABLES `trackin` WRITE;
/*!40000 ALTER TABLE `trackin` DISABLE KEYS */;
/*!40000 ALTER TABLE `trackin` ENABLE KEYS */;
UNLOCK TABLES;
/*!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 2016-06-13 16:24:48
