8df01c6795fcd061326917c4490f79c07a9cc71d
1 -- MySQL dump 10.13 Distrib 5.5.38, for debian-linux-gnu (i686)
3 -- Host: localhost Database: divinelegy
4 -- ------------------------------------------------------
5 -- Server version 5.5.38-0ubuntu0.12.04.1
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
=360 DEFAULT CHARSET
=latin1
;
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
=39 DEFAULT CHARSET
=latin1
;
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
=291 DEFAULT CHARSET
=latin1
;
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
=11 DEFAULT CHARSET
=latin1
;
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
=37 DEFAULT CHARSET
=latin1
;
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
=427 DEFAULT CHARSET
=latin1
;
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
=162 DEFAULT CHARSET
=latin1
;
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') NOT NULL,
152 `rating`
int(10) unsigned
NOT NULL,
153 `difficulty`
enum('Beginner','Easy','Medium','Hard','Challenge','Edit') NOT NULL,
154 `step_artist_id`
mediumint(8) unsigned
DEFAULT NULL,
156 ) ENGINE
=InnoDB AUTO_INCREMENT
=481 DEFAULT CHARSET
=latin1
;
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 `email`
varchar(255) NOT NULL,
169 `display_name`
varchar(255) NOT NULL,
170 `facebook_id`
varchar(255) DEFAULT NULL,
171 `quota`
int(10) unsigned
NOT NULL,
173 ) ENGINE
=InnoDB AUTO_INCREMENT
=11 DEFAULT CHARSET
=latin1
;
174 /*!40101 SET character_set_client = @saved_cs_client */;
177 -- Table structure for table `users_meta`
180 DROP TABLE IF EXISTS `users_meta`
;
181 /*!40101 SET @saved_cs_client = @@character_set_client */;
182 /*!40101 SET character_set_client = utf8 */;
183 CREATE TABLE `users_meta`
(
184 `
id`
mediumint(8) unsigned
NOT NULL AUTO_INCREMENT
,
185 `user_id`
mediumint(8) unsigned
NOT NULL,
186 `firstname`
varchar(255) DEFAULT NULL,
187 `lastname`
varchar(255) DEFAULT NULL,
188 `country`
varchar(255) NOT NULL,
190 ) ENGINE
=InnoDB AUTO_INCREMENT
=15 DEFAULT CHARSET
=latin1
;
191 /*!40101 SET character_set_client = @saved_cs_client */;
192 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
194 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
195 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
196 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
197 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
198 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
199 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
200 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
202 -- Dump completed on 2014-12-05 14:59:50