1 -- MySQL dump 10.13 Distrib 5.6.12, for Win64 (x86_64)
3 -- Host: localhost Database: divinelegy
4 -- ------------------------------------------------------
5 -- Server version 5.6.12
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 */;
19 -- Table structure for table `artists`
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,
29 ) ENGINE
=InnoDB AUTO_INCREMENT
=24930 DEFAULT CHARSET
=utf8
;
30 /*!40101 SET character_set_client = @saved_cs_client */;
33 -- Table structure for table `downloads`
36 DROP TABLE IF EXISTS `downloads`
;
37 /*!40101 SET @saved_cs_client = @@character_set_client */;
38 /*!40101 SET character_set_client = utf8 */;
39 CREATE TABLE `downloads`
(
40 `
id`
mediumint(8) unsigned
NOT NULL AUTO_INCREMENT
,
41 `file_id`
mediumint(8) unsigned
NOT NULL,
42 `user_id`
mediumint(8) unsigned
NOT NULL,
43 `
timestamp`
int(10) unsigned
NOT NULL,
44 `ip`
varchar(15) DEFAULT NULL,
46 ) ENGINE
=InnoDB AUTO_INCREMENT
=41 DEFAULT CHARSET
=utf8
;
47 /*!40101 SET character_set_client = @saved_cs_client */;
50 -- Table structure for table `files`
53 DROP TABLE IF EXISTS `files`
;
54 /*!40101 SET @saved_cs_client = @@character_set_client */;
55 /*!40101 SET character_set_client = utf8 */;
56 CREATE TABLE `files`
(
57 `
id`
mediumint(8) unsigned
NOT NULL AUTO_INCREMENT
,
58 `filename`
varchar(255) NOT NULL,
59 `hash`
varchar(255) NOT NULL,
60 `
path`
varchar(255) NOT NULL,
61 `mimetype`
varchar(255) NOT NULL,
62 `
size`
int(10) unsigned
NOT NULL,
63 `uploaded`
int(10) unsigned
NOT NULL,
65 ) ENGINE
=InnoDB AUTO_INCREMENT
=31153 DEFAULT CHARSET
=utf8
;
66 /*!40101 SET character_set_client = @saved_cs_client */;
69 -- Table structure for table `mirrors`
72 DROP TABLE IF EXISTS `mirrors`
;
73 /*!40101 SET @saved_cs_client = @@character_set_client */;
74 /*!40101 SET character_set_client = utf8 */;
75 CREATE TABLE `mirrors`
(
76 `
id`
mediumint(8) unsigned
NOT NULL AUTO_INCREMENT
,
77 `
uri`
varchar(255) DEFAULT NULL,
78 `file_id`
mediumint(8) unsigned
NOT NULL,
79 `
source`
varchar(255) NOT NULL,
81 ) ENGINE
=InnoDB AUTO_INCREMENT
=2637 DEFAULT CHARSET
=utf8
;
82 /*!40101 SET character_set_client = @saved_cs_client */;
85 -- Table structure for table `packs`
88 DROP TABLE IF EXISTS `packs`
;
89 /*!40101 SET @saved_cs_client = @@character_set_client */;
90 /*!40101 SET character_set_client = utf8 */;
91 CREATE TABLE `packs`
(
92 `title`
varchar(255) NOT NULL,
93 `
id`
mediumint(8) unsigned
NOT NULL AUTO_INCREMENT
,
94 `file_id`
mediumint(8) unsigned
DEFAULT NULL,
95 `user_id`
mediumint(8) unsigned
NOT NULL,
96 `banner_file_id`
mediumint(8) unsigned
DEFAULT NULL,
98 ) ENGINE
=InnoDB AUTO_INCREMENT
=2638 DEFAULT CHARSET
=utf8
;
99 /*!40101 SET character_set_client = @saved_cs_client */;
102 -- Table structure for table `simfiles`
105 DROP TABLE IF EXISTS `simfiles`
;
106 /*!40101 SET @saved_cs_client = @@character_set_client */;
107 /*!40101 SET character_set_client = utf8 */;
108 CREATE TABLE `simfiles`
(
109 `
id`
mediumint(8) unsigned
NOT NULL AUTO_INCREMENT
,
110 `title`
varchar(255) NOT NULL,
111 `artist_id`
mediumint(8) unsigned
NOT NULL,
112 `user_id`
mediumint(8) unsigned
NOT NULL,
113 `bpm_high`
int(11) NOT NULL,
114 `bpm_low`
int(11) NOT NULL,
115 `bpm_changes`
int(1) DEFAULT NULL,
116 `stops`
int(1) DEFAULT NULL,
117 `fg_changes`
int(1) DEFAULT NULL,
118 `bg_changes`
int(1) DEFAULT NULL,
119 `banner_file_id`
mediumint(8) unsigned
DEFAULT NULL,
120 `simfile_file_id`
mediumint(8) unsigned
DEFAULT NULL,
121 `pack_id`
mediumint(8) unsigned
DEFAULT NULL,
123 ) ENGINE
=InnoDB AUTO_INCREMENT
=56572 DEFAULT CHARSET
=utf8
;
124 /*!40101 SET character_set_client = @saved_cs_client */;
127 -- Table structure for table `step_artists`
130 DROP TABLE IF EXISTS `step_artists`
;
131 /*!40101 SET @saved_cs_client = @@character_set_client */;
132 /*!40101 SET character_set_client = utf8 */;
133 CREATE TABLE `step_artists`
(
134 `
id`
mediumint(8) unsigned
NOT NULL AUTO_INCREMENT
,
135 `tag`
varchar(255) NOT NULL,
136 `user_id`
mediumint(8) unsigned
DEFAULT NULL,
138 ) ENGINE
=InnoDB AUTO_INCREMENT
=5697 DEFAULT CHARSET
=utf8
;
139 /*!40101 SET character_set_client = @saved_cs_client */;
142 -- Table structure for table `steps`
145 DROP TABLE IF EXISTS `steps`
;
146 /*!40101 SET @saved_cs_client = @@character_set_client */;
147 /*!40101 SET character_set_client = utf8 */;
148 CREATE TABLE `steps`
(
149 `
id`
mediumint(8) unsigned
NOT NULL AUTO_INCREMENT
,
150 `simfile_id`
mediumint(8) unsigned
NOT NULL,
151 `
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,
152 `rating`
int(10) unsigned
NOT NULL,
153 `difficulty`
enum('Beginner','Easy','Medium','Hard','Challenge','Edit') DEFAULT NULL,
154 `step_artist_id`
mediumint(8) unsigned
DEFAULT NULL,
156 ) ENGINE
=InnoDB AUTO_INCREMENT
=159447 DEFAULT CHARSET
=utf8
;
157 /*!40101 SET character_set_client = @saved_cs_client */;
160 -- Table structure for table `users`
163 DROP TABLE IF EXISTS `users`
;
164 /*!40101 SET @saved_cs_client = @@character_set_client */;
165 /*!40101 SET character_set_client = utf8 */;
166 CREATE TABLE `users`
(
167 `
id`
mediumint(8) unsigned
NOT NULL AUTO_INCREMENT
,
168 `display_name`
varchar(255) NOT NULL,
169 `facebook_id`
varchar(255) DEFAULT NULL,
170 `quota`
int(10) unsigned
NOT NULL,
172 ) ENGINE
=InnoDB AUTO_INCREMENT
=15 DEFAULT CHARSET
=utf8
;
173 /*!40101 SET character_set_client = @saved_cs_client */;
176 -- Table structure for table `users_meta`
179 DROP TABLE IF EXISTS `users_meta`
;
180 /*!40101 SET @saved_cs_client = @@character_set_client */;
181 /*!40101 SET character_set_client = utf8 */;
182 CREATE TABLE `users_meta`
(
183 `
id`
mediumint(8) unsigned
NOT NULL AUTO_INCREMENT
,
184 `user_id`
mediumint(8) unsigned
NOT NULL,
185 `firstname`
varchar(255) DEFAULT NULL,
186 `lastname`
varchar(255) DEFAULT NULL,
187 `country`
varchar(255) NOT NULL,
189 ) ENGINE
=InnoDB AUTO_INCREMENT
=19 DEFAULT CHARSET
=utf8
;
190 /*!40101 SET character_set_client = @saved_cs_client */;
191 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
193 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
194 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
195 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
196 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
197 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
198 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
199 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
201 -- Dump completed on 2014-12-22 2:44:50