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
=3 DEFAULT CHARSET
=latin1
;
30 /*!40101 SET character_set_client = @saved_cs_client */;
33 -- Dumping data for table `artists`
36 LOCK TABLES `artists`
WRITE;
37 /*!40000 ALTER TABLE `artists` DISABLE KEYS */;
38 INSERT INTO `artists`
VALUES (1,'atpunk01'),(2,'FaggotForce');
39 /*!40000 ALTER TABLE `artists` ENABLE KEYS */;
43 -- Table structure for table `simfiles`
46 DROP TABLE IF EXISTS `simfiles`
;
47 /*!40101 SET @saved_cs_client = @@character_set_client */;
48 /*!40101 SET character_set_client = utf8 */;
49 CREATE TABLE `simfiles`
(
50 `
id`
mediumint(8) unsigned
NOT NULL AUTO_INCREMENT
,
51 `title`
varchar(255) NOT NULL,
52 `artist_id`
mediumint(8) unsigned
NOT NULL,
53 `user_id`
mediumint(8) unsigned
NOT NULL,
54 `bpm_high`
int(11) NOT NULL,
55 `bpm_low`
int(11) NOT NULL,
56 `bpm_changes`
bit(1) NOT NULL,
57 `stops`
bit(1) NOT NULL,
58 `fg_changes`
bit(1) NOT NULL,
59 `bg_changes`
bit(1) NOT NULL,
61 ) ENGINE
=InnoDB AUTO_INCREMENT
=4 DEFAULT CHARSET
=latin1
;
62 /*!40101 SET character_set_client = @saved_cs_client */;
65 -- Dumping data for table `simfiles`
68 LOCK TABLES `simfiles`
WRITE;
69 /*!40000 ALTER TABLE `simfiles` DISABLE KEYS */;
70 INSERT INTO `simfiles`
VALUES (1,'BaBoom',1,1,177,177,'\ 1','\0','\0','\0'),(2,'Some Faggot Chart',2,2,230,230,'\0','\0','\0','\0'),(3,'More Bullshit',2,2,210,210,'\0','\0','\0','\0');
71 /*!40000 ALTER TABLE `simfiles` ENABLE KEYS */;
75 -- Table structure for table `step_artists`
78 DROP TABLE IF EXISTS `step_artists`
;
79 /*!40101 SET @saved_cs_client = @@character_set_client */;
80 /*!40101 SET character_set_client = utf8 */;
81 CREATE TABLE `step_artists`
(
82 `
id`
mediumint(8) unsigned
NOT NULL AUTO_INCREMENT
,
83 `tag`
varchar(255) NOT NULL,
84 `user_id`
mediumint(8) unsigned
DEFAULT NULL,
86 ) ENGINE
=InnoDB AUTO_INCREMENT
=4 DEFAULT CHARSET
=latin1
;
87 /*!40101 SET character_set_client = @saved_cs_client */;
90 -- Dumping data for table `step_artists`
93 LOCK TABLES `step_artists`
WRITE;
94 /*!40000 ALTER TABLE `step_artists` DISABLE KEYS */;
95 INSERT INTO `step_artists`
VALUES (1,'(-[Jayce]-)',1),(2,'Zaia',2),(3,'Serenade',2);
96 /*!40000 ALTER TABLE `step_artists` ENABLE KEYS */;
100 -- Table structure for table `steps`
103 DROP TABLE IF EXISTS `steps`
;
104 /*!40101 SET @saved_cs_client = @@character_set_client */;
105 /*!40101 SET character_set_client = utf8 */;
106 CREATE TABLE `steps`
(
107 `
id`
mediumint(8) unsigned
NOT NULL AUTO_INCREMENT
,
108 `simfile_id`
mediumint(8) unsigned
NOT NULL,
109 `
mode`
enum('dance-single','dance-double') NOT NULL,
110 `rating`
int(10) unsigned
NOT NULL,
111 `difficulty`
enum('beginner','easy','medium','hard','challenge','edit') NOT NULL,
112 `step_artist_id`
mediumint(8) unsigned
NOT NULL,
114 ) ENGINE
=InnoDB AUTO_INCREMENT
=8 DEFAULT CHARSET
=latin1
;
115 /*!40101 SET character_set_client = @saved_cs_client */;
118 -- Dumping data for table `steps`
121 LOCK TABLES `steps`
WRITE;
122 /*!40000 ALTER TABLE `steps` DISABLE KEYS */;
123 INSERT INTO `steps`
VALUES (1,1,'dance-single',10,'challenge',1),(2,1,'dance-single',9,'hard',1),(3,1,'dance-single',7,'medium',1),(4,1,'dance-single',4,'easy',1),(5,1,'dance-single',2,'beginner',1),(6,2,'dance-single',15,'beginner',2),(7,3,'dance-single',16,'beginner',3);
124 /*!40000 ALTER TABLE `steps` ENABLE KEYS */;
128 -- Table structure for table `users`
131 DROP TABLE IF EXISTS `users`
;
132 /*!40101 SET @saved_cs_client = @@character_set_client */;
133 /*!40101 SET character_set_client = utf8 */;
134 CREATE TABLE `users`
(
135 `
id`
mediumint(8) unsigned
NOT NULL AUTO_INCREMENT
,
136 `email`
varchar(255) NOT NULL,
137 `display_name`
varchar(255) NOT NULL,
139 ) ENGINE
=InnoDB AUTO_INCREMENT
=3 DEFAULT CHARSET
=latin1
;
140 /*!40101 SET character_set_client = @saved_cs_client */;
143 -- Dumping data for table `users`
146 LOCK TABLES `users`
WRITE;
147 /*!40000 ALTER TABLE `users` DISABLE KEYS */;
148 INSERT INTO `users`
VALUES (1,'jayce@divinelegy.com','Jayce'),(2,'chino@chino.net','Chino');
149 /*!40000 ALTER TABLE `users` ENABLE KEYS */;
153 -- Table structure for table `users_meta`
156 DROP TABLE IF EXISTS `users_meta`
;
157 /*!40101 SET @saved_cs_client = @@character_set_client */;
158 /*!40101 SET character_set_client = utf8 */;
159 CREATE TABLE `users_meta`
(
160 `
id`
mediumint(8) unsigned
NOT NULL AUTO_INCREMENT
,
161 `user_id`
mediumint(8) unsigned
NOT NULL,
162 `firstname`
varchar(255) DEFAULT NULL,
163 `lastname`
varchar(255) DEFAULT NULL,
164 `country`
varchar(255) NOT NULL,
166 ) ENGINE
=InnoDB AUTO_INCREMENT
=3 DEFAULT CHARSET
=latin1
;
167 /*!40101 SET character_set_client = @saved_cs_client */;
170 -- Dumping data for table `users_meta`
173 LOCK TABLES `users_meta`
WRITE;
174 /*!40000 ALTER TABLE `users_meta` DISABLE KEYS */;
175 INSERT INTO `users_meta`
VALUES (1,1,'Jayce','Newton','Australia'),(2,2,'Chino','Wood','Australia');
176 /*!40000 ALTER TABLE `users_meta` ENABLE KEYS */;
178 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
180 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
181 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
182 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
183 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
184 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
185 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
186 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
188 -- Dump completed on 2014-08-31 19:53:16