--- MySQL dump 10.13 Distrib 5.5.38, for debian-linux-gnu (i686)
---
--- Host: localhost Database: divinelegy
--- ------------------------------------------------------
--- Server version 5.5.38-0ubuntu0.12.04.1
-
-/*!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 `artists`
---
-
-DROP TABLE IF EXISTS `artists`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `artists` (
- `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
- `name` varchar(255) NOT NULL,
- PRIMARY KEY (`id`)
-) ENGINE=InnoDB AUTO_INCREMENT=360 DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Table structure for table `downloads`
---
-
-DROP TABLE IF EXISTS `downloads`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `downloads` (
- `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
- `file_id` mediumint(8) unsigned NOT NULL,
- `user_id` mediumint(8) unsigned NOT NULL,
- `timestamp` int(10) unsigned NOT NULL,
- `ip` varchar(15) DEFAULT NULL,
- PRIMARY KEY (`id`)
-) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Table structure for table `files`
---
-
-DROP TABLE IF EXISTS `files`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `files` (
- `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
- `filename` varchar(255) NOT NULL,
- `hash` varchar(255) NOT NULL,
- `path` varchar(255) NOT NULL,
- `mimetype` varchar(255) NOT NULL,
- `size` int(10) unsigned NOT NULL,
- `uploaded` int(10) unsigned NOT NULL,
- PRIMARY KEY (`id`)
-) ENGINE=InnoDB AUTO_INCREMENT=291 DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Table structure for table `mirrors`
---
-
-DROP TABLE IF EXISTS `mirrors`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `mirrors` (
- `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
- `uri` varchar(255) DEFAULT NULL,
- `file_id` mediumint(8) unsigned NOT NULL,
- `source` varchar(255) NOT NULL,
- PRIMARY KEY (`id`)
-) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Table structure for table `packs`
---
-
-DROP TABLE IF EXISTS `packs`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `packs` (
- `title` varchar(255) NOT NULL,
- `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
- `file_id` mediumint(8) unsigned DEFAULT NULL,
- `user_id` mediumint(8) unsigned NOT NULL,
- `banner_file_id` mediumint(8) unsigned DEFAULT NULL,
- PRIMARY KEY (`id`)
-) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Table structure for table `simfiles`
---
-
-DROP TABLE IF EXISTS `simfiles`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `simfiles` (
- `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
- `title` varchar(255) NOT NULL,
- `artist_id` mediumint(8) unsigned NOT NULL,
- `user_id` mediumint(8) unsigned NOT NULL,
- `bpm_high` int(11) NOT NULL,
- `bpm_low` int(11) NOT NULL,
- `bpm_changes` int(1) DEFAULT NULL,
- `stops` int(1) DEFAULT NULL,
- `fg_changes` int(1) DEFAULT NULL,
- `bg_changes` int(1) DEFAULT NULL,
- `banner_file_id` mediumint(8) unsigned DEFAULT NULL,
- `simfile_file_id` mediumint(8) unsigned DEFAULT NULL,
- `pack_id` mediumint(8) unsigned DEFAULT NULL,
- PRIMARY KEY (`id`)
-) ENGINE=InnoDB AUTO_INCREMENT=427 DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Table structure for table `step_artists`
---
-
-DROP TABLE IF EXISTS `step_artists`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `step_artists` (
- `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
- `tag` varchar(255) NOT NULL,
- `user_id` mediumint(8) unsigned DEFAULT NULL,
- PRIMARY KEY (`id`)
-) ENGINE=InnoDB AUTO_INCREMENT=162 DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Table structure for table `steps`
---
-
-DROP TABLE IF EXISTS `steps`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `steps` (
- `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
- `simfile_id` mediumint(8) unsigned NOT NULL,
- `mode` enum('dance-single','dance-double') NOT NULL,
- `rating` int(10) unsigned NOT NULL,
- `difficulty` enum('Beginner','Easy','Medium','Hard','Challenge','Edit') NOT NULL,
- `step_artist_id` mediumint(8) unsigned DEFAULT NULL,
- PRIMARY KEY (`id`)
-) ENGINE=InnoDB AUTO_INCREMENT=481 DEFAULT CHARSET=latin1;
-/*!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` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
- `email` varchar(255) NOT NULL,
- `display_name` varchar(255) NOT NULL,
- `facebook_id` varchar(255) DEFAULT NULL,
- `quota` int(10) unsigned NOT NULL,
- PRIMARY KEY (`id`)
-) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Table structure for table `users_meta`
---
-
-DROP TABLE IF EXISTS `users_meta`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `users_meta` (
- `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
- `user_id` mediumint(8) unsigned NOT NULL,
- `firstname` varchar(255) DEFAULT NULL,
- `lastname` varchar(255) DEFAULT NULL,
- `country` varchar(255) NOT NULL,
- PRIMARY KEY (`id`)
-) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;
-/*!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 2014-12-05 14:59:50
+-- MySQL dump 10.13 Distrib 5.6.12, for Win64 (x86_64)\r
+--\r
+-- Host: localhost Database: divinelegy\r
+-- ------------------------------------------------------\r
+-- Server version 5.6.12\r
+\r
+/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;\r
+/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;\r
+/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;\r
+/*!40101 SET NAMES utf8 */;\r
+/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;\r
+/*!40103 SET TIME_ZONE='+00:00' */;\r
+/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;\r
+/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;\r
+/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;\r
+/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;\r
+\r
+--\r
+-- Table structure for table `artists`\r
+--\r
+\r
+DROP TABLE IF EXISTS `artists`;\r
+/*!40101 SET @saved_cs_client = @@character_set_client */;\r
+/*!40101 SET character_set_client = utf8 */;\r
+CREATE TABLE `artists` (\r
+ `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,\r
+ `name` varchar(255) NOT NULL,\r
+ PRIMARY KEY (`id`)\r
+) ENGINE=InnoDB AUTO_INCREMENT=24930 DEFAULT CHARSET=utf8;\r
+/*!40101 SET character_set_client = @saved_cs_client */;\r
+\r
+--\r
+-- Table structure for table `downloads`\r
+--\r
+\r
+DROP TABLE IF EXISTS `downloads`;\r
+/*!40101 SET @saved_cs_client = @@character_set_client */;\r
+/*!40101 SET character_set_client = utf8 */;\r
+CREATE TABLE `downloads` (\r
+ `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,\r
+ `file_id` mediumint(8) unsigned NOT NULL,\r
+ `user_id` mediumint(8) unsigned NOT NULL,\r
+ `timestamp` int(10) unsigned NOT NULL,\r
+ `ip` varchar(15) DEFAULT NULL,\r
+ PRIMARY KEY (`id`)\r
+) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8;\r
+/*!40101 SET character_set_client = @saved_cs_client */;\r
+\r
+--\r
+-- Table structure for table `files`\r
+--\r
+\r
+DROP TABLE IF EXISTS `files`;\r
+/*!40101 SET @saved_cs_client = @@character_set_client */;\r
+/*!40101 SET character_set_client = utf8 */;\r
+CREATE TABLE `files` (\r
+ `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,\r
+ `filename` varchar(255) NOT NULL,\r
+ `hash` varchar(255) NOT NULL,\r
+ `path` varchar(255) NOT NULL,\r
+ `mimetype` varchar(255) NOT NULL,\r
+ `size` int(10) unsigned NOT NULL,\r
+ `uploaded` int(10) unsigned NOT NULL,\r
+ PRIMARY KEY (`id`)\r
+) ENGINE=InnoDB AUTO_INCREMENT=31153 DEFAULT CHARSET=utf8;\r
+/*!40101 SET character_set_client = @saved_cs_client */;\r
+\r
+--\r
+-- Table structure for table `mirrors`\r
+--\r
+\r
+DROP TABLE IF EXISTS `mirrors`;\r
+/*!40101 SET @saved_cs_client = @@character_set_client */;\r
+/*!40101 SET character_set_client = utf8 */;\r
+CREATE TABLE `mirrors` (\r
+ `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,\r
+ `uri` varchar(255) DEFAULT NULL,\r
+ `file_id` mediumint(8) unsigned NOT NULL,\r
+ `source` varchar(255) NOT NULL,\r
+ PRIMARY KEY (`id`)\r
+) ENGINE=InnoDB AUTO_INCREMENT=2637 DEFAULT CHARSET=utf8;\r
+/*!40101 SET character_set_client = @saved_cs_client */;\r
+\r
+--\r
+-- Table structure for table `packs`\r
+--\r
+\r
+DROP TABLE IF EXISTS `packs`;\r
+/*!40101 SET @saved_cs_client = @@character_set_client */;\r
+/*!40101 SET character_set_client = utf8 */;\r
+CREATE TABLE `packs` (\r
+ `title` varchar(255) NOT NULL,\r
+ `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,\r
+ `file_id` mediumint(8) unsigned DEFAULT NULL,\r
+ `user_id` mediumint(8) unsigned NOT NULL,\r
+ `banner_file_id` mediumint(8) unsigned DEFAULT NULL,\r
+ PRIMARY KEY (`id`)\r
+) ENGINE=InnoDB AUTO_INCREMENT=2638 DEFAULT CHARSET=utf8;\r
+/*!40101 SET character_set_client = @saved_cs_client */;\r
+\r
+--\r
+-- Table structure for table `simfiles`\r
+--\r
+\r
+DROP TABLE IF EXISTS `simfiles`;\r
+/*!40101 SET @saved_cs_client = @@character_set_client */;\r
+/*!40101 SET character_set_client = utf8 */;\r
+CREATE TABLE `simfiles` (\r
+ `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,\r
+ `title` varchar(255) NOT NULL,\r
+ `artist_id` mediumint(8) unsigned NOT NULL,\r
+ `user_id` mediumint(8) unsigned NOT NULL,\r
+ `bpm_high` int(11) NOT NULL,\r
+ `bpm_low` int(11) NOT NULL,\r
+ `bpm_changes` int(1) DEFAULT NULL,\r
+ `stops` int(1) DEFAULT NULL,\r
+ `fg_changes` int(1) DEFAULT NULL,\r
+ `bg_changes` int(1) DEFAULT NULL,\r
+ `banner_file_id` mediumint(8) unsigned DEFAULT NULL,\r
+ `simfile_file_id` mediumint(8) unsigned DEFAULT NULL,\r
+ `pack_id` mediumint(8) unsigned DEFAULT NULL,\r
+ PRIMARY KEY (`id`)\r
+) ENGINE=InnoDB AUTO_INCREMENT=56572 DEFAULT CHARSET=utf8;\r
+/*!40101 SET character_set_client = @saved_cs_client */;\r
+\r
+--\r
+-- Table structure for table `step_artists`\r
+--\r
+\r
+DROP TABLE IF EXISTS `step_artists`;\r
+/*!40101 SET @saved_cs_client = @@character_set_client */;\r
+/*!40101 SET character_set_client = utf8 */;\r
+CREATE TABLE `step_artists` (\r
+ `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,\r
+ `tag` varchar(255) NOT NULL,\r
+ `user_id` mediumint(8) unsigned DEFAULT NULL,\r
+ PRIMARY KEY (`id`)\r
+) ENGINE=InnoDB AUTO_INCREMENT=5697 DEFAULT CHARSET=utf8;\r
+/*!40101 SET character_set_client = @saved_cs_client */;\r
+\r
+--\r
+-- Table structure for table `steps`\r
+--\r
+\r
+DROP TABLE IF EXISTS `steps`;\r
+/*!40101 SET @saved_cs_client = @@character_set_client */;\r
+/*!40101 SET character_set_client = utf8 */;\r
+CREATE TABLE `steps` (\r
+ `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,\r
+ `simfile_id` mediumint(8) unsigned NOT NULL,\r
+ `mode` enum('dance-single','dance-double','dance-couple','dance-solo','dance-threepanel','dance-routine','pump-single','pump-double','pump-couple','pump-halfdouble','pump-routine','kb7-single','ez2-single','ez2-double','ez2-real','para-single','para-versus','ds3ddx-single','bm-single','bm-single5','bm-single7','bm-double','bm-double5','bm-double7','bm-versus5','bm-versus7','iidx-single','iidx-single5','iidx-single7','iidx-double','iidx-double5','iidx-double7','iidx-versus5','iidx-versus7','maniax-single','maniax-double','techno-single4','techno-single5','techno-single8','techno-double4','techno-double5','techno-double8','pnm-five','pnm-nine') DEFAULT NULL,\r
+ `rating` int(10) unsigned NOT NULL,\r
+ `difficulty` enum('Beginner','Easy','Medium','Hard','Challenge','Edit') DEFAULT NULL,\r
+ `step_artist_id` mediumint(8) unsigned DEFAULT NULL,\r
+ PRIMARY KEY (`id`)\r
+) ENGINE=InnoDB AUTO_INCREMENT=159447 DEFAULT CHARSET=utf8;\r
+/*!40101 SET character_set_client = @saved_cs_client */;\r
+\r
+--\r
+-- Table structure for table `users`\r
+--\r
+\r
+DROP TABLE IF EXISTS `users`;\r
+/*!40101 SET @saved_cs_client = @@character_set_client */;\r
+/*!40101 SET character_set_client = utf8 */;\r
+CREATE TABLE `users` (\r
+ `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,\r
+ `display_name` varchar(255) NOT NULL,\r
+ `facebook_id` varchar(255) DEFAULT NULL,\r
+ `quota` int(10) unsigned NOT NULL,\r
+ PRIMARY KEY (`id`)\r
+) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;\r
+/*!40101 SET character_set_client = @saved_cs_client */;\r
+\r
+--\r
+-- Table structure for table `users_meta`\r
+--\r
+\r
+DROP TABLE IF EXISTS `users_meta`;\r
+/*!40101 SET @saved_cs_client = @@character_set_client */;\r
+/*!40101 SET character_set_client = utf8 */;\r
+CREATE TABLE `users_meta` (\r
+ `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,\r
+ `user_id` mediumint(8) unsigned NOT NULL,\r
+ `firstname` varchar(255) DEFAULT NULL,\r
+ `lastname` varchar(255) DEFAULT NULL,\r
+ `country` varchar(255) NOT NULL,\r
+ PRIMARY KEY (`id`)\r
+) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;\r
+/*!40101 SET character_set_client = @saved_cs_client */;\r
+/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;\r
+\r
+/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;\r
+/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;\r
+/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;\r
+/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;\r
+/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;\r
+/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;\r
+/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;\r
+\r
+-- Dump completed on 2014-12-22 2:44:50\r