-- Copyright 2017-2018 Low Power Company, Inc. All rights reserved.
-- Copyright 2017-2018 Andrew Sharp.  All rights reserved.
-- MySQL dump 10.13  Distrib 5.5.53, for debian-linux-gnu (x86_64)
--
-- Host: 10.1.1.203    Database: grplens
-- ------------------------------------------------------
-- Server version	5.5.55-0+deb8u1
/*!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 */;


-- for some reason, this variable in the config file is being ignored --
-- SET GLOBAL innodb_file_per_table=on;

--
-- Current Database: `grplens`
--

/*!40000 DROP DATABASE IF EXISTS `grplens`*/;

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `grplens` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `grplens`;

--
-- Table structure for table `genomescores`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `genomescores` (
  `movieID` int(11) NOT NULL,
  `tagId` int(11) NOT NULL,
  `relevance` float DEFAULT NULL,
  PRIMARY KEY (`movieID`,`tagId`)
) ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `genometags`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `genometags` (
  `tagId` int(11) NOT NULL,
  `tag` varchar(90) CHARACTER SET utf8 DEFAULT NULL,
  PRIMARY KEY (`tagId`)
) ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

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

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `links` (
  `idlinks` int(11) NOT NULL,
  `imdbId` int(11) DEFAULT NULL,
  `tmdbId` int(11) DEFAULT NULL,
  PRIMARY KEY (`idlinks`)
) ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `movies`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `movies` (
  `movieId` int(11) NOT NULL,
  `title` varchar(200) CHARACTER SET utf8 DEFAULT NULL,
  `genres` varchar(120) CHARACTER SET utf8 DEFAULT NULL,
  PRIMARY KEY (`movieId`)
) ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ratings`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ratings` (
  `user_id` int(11) DEFAULT NULL,
  `movie_id` int(11) DEFAULT NULL,
  `rating` int(11) DEFAULT NULL,
  `timestamp` int(11) DEFAULT NULL,
  KEY `user_id` (`user_id`)
) ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ratings_sample`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ratings_sample` (
  `user_id` int(11) DEFAULT NULL,
  `movie_id` int(11) DEFAULT NULL,
  `rating` int(11) DEFAULT NULL,
  `timestamp` int(11) DEFAULT NULL,
  KEY `user_id` (`user_id`)
) ROW_FORMAT=DYNAMIC
/*!50100 PARTITION BY KEY (user_id)
PARTITIONS 4 */;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tags`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tags` (
  `userId` int(11) NOT NULL,
  `movieID` int(11) NOT NULL,
  `tag` varchar(250) CHARACTER SET utf8 DEFAULT NULL,
  `timestamp` int(11) DEFAULT NULL,
  KEY `tags_userId` (`userId`),
  KEY `tags_movieID` (`movieID`)
) ROW_FORMAT=DYNAMIC;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

DROP TABLE IF EXISTS `coratings`;
-- Dump completed on 2017-07-26 14:23:38
