divinelegy.sql

   1 -- MySQL dump 10.13  Distrib 5.5.38, for debian-linux-gnu (i686)
   2 --
   3 -- Host: localhost    Database: divinelegy
   4 -- ------------------------------------------------------
   5 -- Server version       5.5.38-0ubuntu0.12.04.1
   6
   7 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
   8 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
   9 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  10 /*!40101 SET NAMES utf8 */;
  11 /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
  12 /*!40103 SET TIME_ZONE='+00:00' */;
  13 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  14 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  15 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  16 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  17
  18 --
  19 -- Table structure for table `artists`
  20 --
  21
  22 DROP TABLE IF EXISTS `artists`;
  23 /*!40101 SET @saved_cs_client     = @@character_set_client */;
  24 /*!40101 SET character_set_client = utf8 */;
  25 CREATE TABLE `artists` (
  26   `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  27   `name` varchar(255) NOT NULL,
  28   PRIMARY KEY (`id`)
  29 ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;
  30 /*!40101 SET character_set_client = @saved_cs_client */;
  31
  32 --
  33 -- Table structure for table `files`
  34 --
  35
  36 DROP TABLE IF EXISTS `files`;
  37 /*!40101 SET @saved_cs_client     = @@character_set_client */;
  38 /*!40101 SET character_set_client = utf8 */;
  39 CREATE TABLE `files` (
  40   `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  41   `filename` varchar(255) NOT NULL,
  42   `hash` varchar(255) NOT NULL,
  43   `path` varchar(255) NOT NULL,
  44   `mimetype` varchar(255) NOT NULL,
  45   `size` int(10) unsigned NOT NULL,
  46   `uploaded` int(10) unsigned NOT NULL,
  47   PRIMARY KEY (`id`)
  48 ) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=latin1;
  49 /*!40101 SET character_set_client = @saved_cs_client */;
  50
  51 --
  52 -- Table structure for table `packs`
  53 --
  54
  55 DROP TABLE IF EXISTS `packs`;
  56 /*!40101 SET @saved_cs_client     = @@character_set_client */;
  57 /*!40101 SET character_set_client = utf8 */;
  58 CREATE TABLE `packs` (
  59   `title` varchar(255) NOT NULL,
  60   `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  61   `file_id` mediumint(8) unsigned DEFAULT NULL,
  62   `user_id` mediumint(8) unsigned NOT NULL,
  63   PRIMARY KEY (`id`)
  64 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  65 /*!40101 SET character_set_client = @saved_cs_client */;
  66
  67 --
  68 -- Table structure for table `simfiles`
  69 --
  70
  71 DROP TABLE IF EXISTS `simfiles`;
  72 /*!40101 SET @saved_cs_client     = @@character_set_client */;
  73 /*!40101 SET character_set_client = utf8 */;
  74 CREATE TABLE `simfiles` (
  75   `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  76   `title` varchar(255) NOT NULL,
  77   `artist_id` mediumint(8) unsigned NOT NULL,
  78   `user_id` mediumint(8) unsigned NOT NULL,
  79   `bpm_high` int(11) NOT NULL,
  80   `bpm_low` int(11) NOT NULL,
  81   `bpm_changes` int(1) DEFAULT NULL,
  82   `stops` int(1) DEFAULT NULL,
  83   `fg_changes` int(1) DEFAULT NULL,
  84   `bg_changes` int(1) DEFAULT NULL,
  85   `banner_file_id` mediumint(8) unsigned DEFAULT NULL,
  86   `simfile_file_id` mediumint(8) unsigned DEFAULT NULL,
  87   `pack_id` mediumint(8) unsigned DEFAULT NULL,
  88   PRIMARY KEY (`id`)
  89 ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;
  90 /*!40101 SET character_set_client = @saved_cs_client */;
  91
  92 --
  93 -- Table structure for table `step_artists`
  94 --
  95
  96 DROP TABLE IF EXISTS `step_artists`;
  97 /*!40101 SET @saved_cs_client     = @@character_set_client */;
  98 /*!40101 SET character_set_client = utf8 */;
  99 CREATE TABLE `step_artists` (
 100   `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
 101   `tag` varchar(255) NOT NULL,
 102   `user_id` mediumint(8) unsigned DEFAULT NULL,
 103   PRIMARY KEY (`id`)
 104 ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;
 105 /*!40101 SET character_set_client = @saved_cs_client */;
 106
 107 --
 108 -- Table structure for table `steps`
 109 --
 110
 111 DROP TABLE IF EXISTS `steps`;
 112 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 113 /*!40101 SET character_set_client = utf8 */;
 114 CREATE TABLE `steps` (
 115   `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
 116   `simfile_id` mediumint(8) unsigned NOT NULL,
 117   `mode` enum('dance-single','dance-double') NOT NULL,
 118   `rating` int(10) unsigned NOT NULL,
 119   `difficulty` enum('Beginner','Easy','Medium','Hard','Challenge','Edit') NOT NULL,
 120   `step_artist_id` mediumint(8) unsigned NOT NULL,
 121   PRIMARY KEY (`id`)
 122 ) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;
 123 /*!40101 SET character_set_client = @saved_cs_client */;
 124
 125 --
 126 -- Table structure for table `users`
 127 --
 128
 129 DROP TABLE IF EXISTS `users`;
 130 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 131 /*!40101 SET character_set_client = utf8 */;
 132 CREATE TABLE `users` (
 133   `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
 134   `email` varchar(255) NOT NULL,
 135   `display_name` varchar(255) NOT NULL,
 136   `facebook_id` varchar(255) DEFAULT NULL,
 137   `auth_token` varchar(255) DEFAULT NULL,
 138   PRIMARY KEY (`id`)
 139 ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
 140 /*!40101 SET character_set_client = @saved_cs_client */;
 141
 142 --
 143 -- Table structure for table `users_meta`
 144 --
 145
 146 DROP TABLE IF EXISTS `users_meta`;
 147 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 148 /*!40101 SET character_set_client = utf8 */;
 149 CREATE TABLE `users_meta` (
 150   `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
 151   `user_id` mediumint(8) unsigned NOT NULL,
 152   `firstname` varchar(255) DEFAULT NULL,
 153   `lastname` varchar(255) DEFAULT NULL,
 154   `country` varchar(255) NOT NULL,
 155   PRIMARY KEY (`id`)
 156 ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
 157 /*!40101 SET character_set_client = @saved_cs_client */;
 158 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
 159
 160 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
 161 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
 162 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
 163 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
 164 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
 165 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 166 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 167
 168 -- Dump completed on 2014-11-17 16:49:39