· 9 years ago · Nov 30, 2016, 10:22 AM
1-- phpMyAdmin SQL Dump
2-- version 4.6.4
3-- https://www.phpmyadmin.net/
4--
5-- Host: localhost:3306
6-- Generation Time: Nov 30, 2016 at 11:21 AM
7-- Server version: 5.6.28
8-- PHP Version: 5.6.25
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13--
14-- Database: `worldof_db`
15--
16CREATE DATABASE IF NOT EXISTS `worldof_db` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
17USE `worldof_db`;
18
19-- --------------------------------------------------------
20
21--
22-- Table structure for table `accounts`
23--
24
25DROP TABLE IF EXISTS `accounts`;
26CREATE TABLE `accounts` (
27 `id` int(255) NOT NULL,
28 `username` varchar(25) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
29 `password` varchar(60) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL
30) ENGINE=InnoDB DEFAULT CHARSET=utf8;
31
32--
33-- Dumping data for table `accounts`
34--
35
36INSERT INTO `accounts` (`id`, `username`, `password`) VALUES
37(12, 'boop', '$2y$11$IItmeuA1Iz5a/Q4RP/WsuuB8hmo/DMXBJ/iIeWZZFCnuFDUYF.QNO'),
38(13, 'Kim', '$2y$11$w8db9v08w33YvA7D7NfxkuSfG9hC3dJH3R5nc/KiYbvR9h6ZMBcQO'),
39(14, 'Adarsh', '$2y$11$/XTEWYPB7FTX/JDKMtVm4eClk1vrIO99wK/K7pcZEWHfIBhCpcsUG'),
40(15, 'Kimberly', '$2y$11$I2PQYYApVYXWkAiJozH7A.an/nhUa4cb9NtK6tRzHo5x.WhCs.SU.');
41
42-- --------------------------------------------------------
43
44--
45-- Table structure for table `collaborators`
46--
47
48DROP TABLE IF EXISTS `collaborators`;
49CREATE TABLE `collaborators` (
50 `id` int(255) NOT NULL,
51 `collaborator_id` int(255) NOT NULL,
52 `world_id` int(255) NOT NULL
53) ENGINE=InnoDB DEFAULT CHARSET=utf8;
54
55--
56-- Dumping data for table `collaborators`
57--
58
59INSERT INTO `collaborators` (`id`, `collaborator_id`, `world_id`) VALUES
60(8, 13, 20),
61(9, 14, 24),
62(10, 14, 27);
63
64-- --------------------------------------------------------
65
66--
67-- Table structure for table `hubs`
68--
69
70DROP TABLE IF EXISTS `hubs`;
71CREATE TABLE `hubs` (
72 `id` int(255) NOT NULL,
73 `user_id` int(255) NOT NULL,
74 `world_id` int(255) NOT NULL,
75 `name` varchar(500) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL
76) ENGINE=MyISAM DEFAULT CHARSET=latin1;
77
78--
79-- Dumping data for table `hubs`
80--
81
82INSERT INTO `hubs` (`id`, `user_id`, `world_id`, `name`) VALUES
83(1, 1, 1, 'hub1'),
84(2, 1, 1, 'HI'),
85(3, 14, 3, 'hey'),
86(9, 14, 22, 'First Page'),
87(10, 14, 22, 'Go to Sleep'),
88(11, 14, 22, 'Play-through'),
89(12, 14, 22, 'Run in direction of scream'),
90(13, 14, 22, 'Attack the monster'),
91(14, 14, 22, 'Leave Starting Attributes'),
92(15, 14, 22, 'Drink Coffee'),
93(16, 14, 22, 'Change to 10 damage'),
94(17, 14, 22, 'Drink Tea'),
95(23, 14, 27, 'Whatever'),
96(28, 14, 29, 'First Day'),
97(24, 14, 27, 'hub2'),
98(25, 14, 27, 'hub1'),
99(26, 14, 27, 'hub2');
100
101-- --------------------------------------------------------
102
103--
104-- Table structure for table `hubs_content`
105--
106
107DROP TABLE IF EXISTS `hubs_content`;
108CREATE TABLE `hubs_content` (
109 `id` int(255) NOT NULL,
110 `hub_id` int(255) NOT NULL,
111 `user_id` int(255) NOT NULL,
112 `text` varchar(500) DEFAULT NULL,
113 `ordering` int(255) NOT NULL DEFAULT '1',
114 `conditions` text,
115 `linked_hub` int(255) DEFAULT NULL,
116 `state_modifiers` text
117) ENGINE=MyISAM DEFAULT CHARSET=latin1;
118
119--
120-- Dumping data for table `hubs_content`
121--
122
123INSERT INTO `hubs_content` (`id`, `hub_id`, `user_id`, `text`, `ordering`, `conditions`, `linked_hub`, `state_modifiers`) VALUES
124(1, 9, 14, '2:07 AM, Thursday.\n\nThe RPG you\'ve been developing for the past three years is to be sent to the publisher at the end of the week. You\'ve spent the past months playtesting, debugging, checking your code, and re-reading feedback from your college friends, just to make sure you haven\'t missed any major bugs.\n\nYou\'re exhausted. Still, you can\'t rest now.\n', 1, NULL, NULL, '[{"lhs":"Energy Level","op":"=","rhs":"0","$$hashKey":"object:931"},{"lhs":"IsHired","op":"=","rhs":"0","$$hashKey":"object:932"},{"lhs":"playedFirstWorld","op":"=","rhs":"1","$$hashKey":"object:989"}]'),
125(2, 9, 14, 'Yes, I can. Go to sleep.', 2, NULL, 10, NULL),
126(13, 11, 14, 'You run in the direction of the scream', 2, NULL, 12, NULL),
127(14, 12, 14, 'You jump into a sprint. Like a reflex, your hand goes to the sword at your hip. You come to a small clearing in the woods and see a large, leathery, pale demon with burning red eyes. Thrown over its shoulder is a young woman. She\'s unconscious. The demon sees you and lunges.\n\nThe screen shifts into a random encounter. \n\nThe demon attacks. You dodge it. \n\nWhat will you do?', 1, NULL, NULL, NULL),
128(12, 11, 14, 'You double-click on the game\'s icon on your desktop: a little 8-bit sword in a ring of green fire. \n\nThe game window opens and the cute midi soundtrack that you annoyed your friend into writing plays as a 16-bit fantasy world comes into view as you start a new game.\n\nA little sprite of a woman in a plain leather jerkin wanders through the forest in distress.\n\n"AGHHHHH!! SOMEBODY HELP ME!"', 1, NULL, NULL, NULL),
129(8, 9, 14, 'Let\'s do one more run-though. Just to be sure.', 3, NULL, 11, NULL),
130(9, 10, 14, 'You put the game out of your mind and go about the rest of the week without a care.\n\nTwo weeks later you receive an email from Sam, your point of contact at the publishing studio.', 1, NULL, NULL, NULL),
131(15, 12, 14, 'ATTACK', 2, NULL, 13, NULL),
132(16, 12, 14, 'Drink coffee. You\'re getting tired.', 3, NULL, 15, '[{"lhs":"Energy Level","op":"+","rhs":"2","$$hashKey":"object:3817"}]'),
133(17, 14, 14, 'You leave the starting attributes as they are.\n\nYou save the girl and bring her back to her village. She tells you that demons are kidnapping people as sacrifices for a demon god they are trying to summon.\n\nYou progress through the story, one-shotting every enemy you encounter for the next three days. You beat the game and send it to your publisher.', 1, NULL, NULL, NULL),
134(11, 10, 14, '"Hello,\n\nRegarding your recent game submission--during our playtests, we found an insurmountable amount of bugs in the game, rendering the game unplayable. We here at This Studio hold our content to a high standard. Which you are not. Bye.\n\nBest,\nSam"\n\n<b>THE END</b>', 2, NULL, NULL, NULL),
135(32, 14, 14, 'Play Again?', 2, NULL, 9, NULL),
136(19, 13, 14, 'Your character tackles the demon and a slashing effect appears on it. \n\n1000 damage!\n\nWas this fight meant to be that easy? Maybe you should change the hero\'s starting attributes.\n', 1, NULL, NULL, NULL),
137(37, 25, 14, 'something', 1, NULL, 26, '[{"lhs":"Energy","op":"=","rhs":"5","$$hashKey":"object:4293"}]'),
138(20, 13, 14, 'Set strength to 10.', 2, '{"op":"ALL","conditions":[{"lhs":"Energy Level","op":"n===","rhs":"2"}]}', 16, NULL),
139(21, 13, 14, 'Leave as is.', 3, '{"op":"ALL","conditions":[{"lhs":"Energy Level","op":"n===","rhs":"2"}]}', 14, NULL),
140(22, 15, 14, 'You drink some coffee and look in the mirror.\n\nThe bags under your eyes have begun to turn purple and you have blood shot eyes but you need this job so you soldier on anyway.', 1, NULL, NULL, NULL),
141(23, 15, 14, 'Now, ATTACK THE MONSTER.', 2, NULL, 13, NULL),
142(24, 16, 14, 'You change the starting attribute to 10 attack power.\n\nAfter a long hard battle with the demon, you save the girl and bring her back to her village. She tells you that demons are kidnapping people to sacrifice and open a portal to hell dimension.\n\nYou progress through the story slowly but surely for the next five days. You beat the game and send it to your publisher.\n\n<b>THE END..?</b>', 1, NULL, NULL, '[{"lhs":"IsHired","op":"=","rhs":"1","$$hashKey":"object:4297"}]'),
143(40, 28, 14, '<i>You have a nightmare about the application you had sent to This Studio, which got rejected, leaving you sad and depressed before you buckled up and worked harder on your game and applied to That Studio.</i>', 1, '{"op":"ALL","conditions":[{"lhs":"IsHired","op":"n===","rhs":"0"},{"lhs":"playedFirstWorld","op":"n===","rhs":"1"}]}', NULL, NULL),
144(26, 13, 14, 'You\'re about to fix the bug when you pass out from sleep deprivation.', 4, '{"op":"ALL","conditions":[{"lhs":"Energy Level","op":"n===","rhs":"0"}]}', 10, NULL),
145(27, 12, 14, 'Drink Tea. You\'re not a filthy coffee drinker.', 4, NULL, 17, '[{"lhs":"Energy Level","op":"+","rhs":"1","$$hashKey":"object:3775"}]'),
146(28, 10, 14, 'Play again?', 3, NULL, 9, NULL),
147(29, 17, 14, 'You drink some tea and look in the mirror.\n\nThe bags under your eyes have begun to turn purple and you have blood shot eyes but you need this job so you soldier on anyway.', 1, NULL, NULL, NULL),
148(30, 17, 14, 'Attack the monster.', 2, NULL, 13, NULL),
149(31, 13, 14, 'You\'re about to fix the bug when you realize you drank Chamomile Tea. You fall into a relaxing slumber.', 5, '{"op":"ALL","conditions":[{"lhs":"Energy Level","op":"n===","rhs":"1"}]}', 10, NULL),
150(36, 23, 14, 'asgdagdsgasdg', 1, NULL, 24, NULL),
151(43, 28, 14, '<i>You dream about the job that was offered to you by This Studio upon accepting your game application. However, you realized that they had pretty bad working conditions and so you decided to apply to That Studio, and you got accepted!</i>', 2, '{"op":"ALL","conditions":[{"lhs":"playedFirstWorld","op":"t===","rhs":"1"},{"lhs":"IsHired","op":"t===","rhs":"1"}]}', NULL, NULL),
152(44, 28, 14, 'You wake up at 5:00 am, eager to get ready for your first day at <b>That Studio</b>.', 3, NULL, NULL, NULL);
153
154-- --------------------------------------------------------
155
156--
157-- Table structure for table `reviews`
158--
159
160DROP TABLE IF EXISTS `reviews`;
161CREATE TABLE `reviews` (
162 `id` int(255) NOT NULL,
163 `user_id` int(255) NOT NULL,
164 `rating` tinyint(1) NOT NULL,
165 `world_id` int(255) NOT NULL,
166 `text` text NOT NULL
167) ENGINE=MyISAM DEFAULT CHARSET=latin1;
168
169--
170-- Dumping data for table `reviews`
171--
172
173INSERT INTO `reviews` (`id`, `user_id`, `rating`, `world_id`, `text`) VALUES
174(4, 14, 3, 21, ''),
175(5, 14, 1, 22, ' Not really. This world sucks. SERIOUSLY!'),
176(6, 14, 1, 28, 'this sucks');
177
178-- --------------------------------------------------------
179
180--
181-- Table structure for table `worlds`
182--
183
184DROP TABLE IF EXISTS `worlds`;
185CREATE TABLE `worlds` (
186 `id` int(255) NOT NULL,
187 `user_id` int(255) NOT NULL,
188 `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
189 `description` varchar(500) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
190 `state_variables` text,
191 `times_played` int(255) NOT NULL DEFAULT '0',
192 `avg_time` int(255) NOT NULL DEFAULT '0' COMMENT 'minutes',
193 `published` tinyint(1) NOT NULL DEFAULT '0',
194 `start_hub` int(255) NOT NULL DEFAULT '0',
195 `linked_world` int(255) DEFAULT NULL
196) ENGINE=MyISAM DEFAULT CHARSET=latin1;
197
198--
199-- Dumping data for table `worlds`
200--
201
202INSERT INTO `worlds` (`id`, `user_id`, `name`, `description`, `state_variables`, `times_played`, `avg_time`, `published`, `start_hub`, `linked_world`) VALUES
203(22, 14, 'RPG Maker', 'You\'re making a game', '[{"name":"Energy Level","type":"number","initial":0,"show":true},{"name":"IsHired","type":"number","initial":0,"show":false},{"name":"playedFirstWorld","type":"number","initial":0,"show":false}]', 0, 0, 0, 9, 0),
204(25, 14, 'sample world', 'this is a world', '[{"name":"Energy Level","type":"number","initial":"0","show":true,"inherited":true}]', 0, 0, 0, 0, 22),
205(29, 14, 'RPG Maker 2: The Making', 'The long-awaited continuation to RPG Maker 1. Join your RPG Developer on their journey as they begin their first job!', '[{"name":"Energy Level","type":"number","initial":0,"show":true,"inherited":true},{"name":"IsHired","type":"number","initial":0,"show":false,"inherited":true},{"name":"playedFirstWorld","type":"number","initial":0,"show":false,"inherited":true}]', 0, 0, 0, 28, 22),
206(27, 14, 'Hi', 'this is description', '[{"name":"Energy","type":"number","initial":"1000","show":true}]', 0, 0, 0, 25, 0);
207
208--
209-- Indexes for dumped tables
210--
211
212--
213-- Indexes for table `accounts`
214--
215ALTER TABLE `accounts`
216 ADD PRIMARY KEY (`id`),
217 ADD UNIQUE KEY `username` (`username`);
218
219--
220-- Indexes for table `collaborators`
221--
222ALTER TABLE `collaborators`
223 ADD PRIMARY KEY (`id`);
224
225--
226-- Indexes for table `hubs`
227--
228ALTER TABLE `hubs`
229 ADD PRIMARY KEY (`id`);
230
231--
232-- Indexes for table `hubs_content`
233--
234ALTER TABLE `hubs_content`
235 ADD PRIMARY KEY (`id`);
236
237--
238-- Indexes for table `reviews`
239--
240ALTER TABLE `reviews`
241 ADD PRIMARY KEY (`id`);
242
243--
244-- Indexes for table `worlds`
245--
246ALTER TABLE `worlds`
247 ADD PRIMARY KEY (`id`);
248
249--
250-- AUTO_INCREMENT for dumped tables
251--
252
253--
254-- AUTO_INCREMENT for table `accounts`
255--
256ALTER TABLE `accounts`
257 MODIFY `id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;
258--
259-- AUTO_INCREMENT for table `collaborators`
260--
261ALTER TABLE `collaborators`
262 MODIFY `id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
263--
264-- AUTO_INCREMENT for table `hubs`
265--
266ALTER TABLE `hubs`
267 MODIFY `id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;
268--
269-- AUTO_INCREMENT for table `hubs_content`
270--
271ALTER TABLE `hubs_content`
272 MODIFY `id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=45;
273--
274-- AUTO_INCREMENT for table `reviews`
275--
276ALTER TABLE `reviews`
277 MODIFY `id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
278--
279-- AUTO_INCREMENT for table `worlds`
280--
281ALTER TABLE `worlds`
282 MODIFY `id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;