· 6 years ago · May 12, 2019, 03:52 PM
1-- --------------------------------------------------------
2-- Host: 127.0.0.1
3-- Server version: 5.7.25 - MySQL Community Server (GPL)
4-- Server OS: Linux
5-- HeidiSQL Version: 10.1.0.5464
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8 */;
10/*!50503 SET NAMES utf8mb4 */;
11/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
12/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
13
14
15-- Dumping database structure for ripple
16CREATE DATABASE IF NOT EXISTS `ripple` /*!40100 DEFAULT CHARACTER SET latin1 */;
17USE `ripple`;
18
19-- Dumping structure for table ripple.2fa
20CREATE TABLE IF NOT EXISTS `2fa` (
21 `userid` int(11) NOT NULL,
22 `token` varchar(32) DEFAULT NULL,
23 `ip` int(11) NOT NULL,
24 `expire` int(11) DEFAULT NULL,
25 `sent` int(11) DEFAULT NULL,
26 PRIMARY KEY (`userid`)
27) ENGINE=InnoDB DEFAULT CHARSET=latin1;
28
29
30-- Dumping structure for table ripple.2fa_telegram
31CREATE TABLE IF NOT EXISTS `2fa_telegram` (
32 `userid` int(11) NOT NULL,
33 `id` text,
34 PRIMARY KEY (`userid`)
35) ENGINE=InnoDB DEFAULT CHARSET=latin1;
36
37
38-- Dumping structure for table ripple.2fa_totp
39CREATE TABLE IF NOT EXISTS `2fa_totp` (
40 `enabled` tinyint(1) NOT NULL DEFAULT '0',
41 `userid` int(11) NOT NULL,
42 PRIMARY KEY (`userid`)
43) ENGINE=InnoDB DEFAULT CHARSET=latin1;
44
45
46-- Dumping structure for table ripple.achievements
47CREATE TABLE IF NOT EXISTS `achievements` (
48 `id` int(11) NOT NULL,
49 `name` varchar(64) NOT NULL,
50 `description` varchar(128) NOT NULL,
51 `icon` varchar(32) NOT NULL,
52 `version` int(11) NOT NULL DEFAULT '0'
53) ENGINE=InnoDB DEFAULT CHARSET=latin1;
54
55
56-- Dumping structure for table ripple.badges
57CREATE TABLE IF NOT EXISTS `badges` (
58 `id` int(11) NOT NULL AUTO_INCREMENT,
59 `name` varchar(32) NOT NULL,
60 `icon` varchar(32) NOT NULL,
61 PRIMARY KEY (`id`)
62) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
63
64INSERT INTO `badges` (`id`, `name`, `icon`) VALUES
65 (2, '', 'fa-blank');
66
67
68-- Dumping structure for table ripple.bancho_channels
69CREATE TABLE IF NOT EXISTS `bancho_channels` (
70 `id` int(11) NOT NULL AUTO_INCREMENT,
71 `name` varchar(32) NOT NULL,
72 `description` varchar(127) NOT NULL,
73 `public_read` tinyint(4) NOT NULL,
74 `public_write` tinyint(4) NOT NULL,
75 `status` tinyint(4) NOT NULL,
76 `temp` tinyint(1) NOT NULL DEFAULT '0',
77 `hidden` tinyint(1) NOT NULL DEFAULT '0',
78 PRIMARY KEY (`id`)
79) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
80
81INSERT INTO `bancho_channels` (`id`, `name`, `description`, `public_read`, `public_write`, `status`, `temp`, `hidden`) VALUES
82 (1, '#osu', 'Main Atoka Channel', 1, 1, 1, 0, 0),
83 (2, '#announce', 'Announce Channel', 1, 0, 1, 0, 0),
84 (3, '#admin', 'Admin Only Channel', 0, 0, 1, 0, 0),
85 (4, '#english', 'English Community Channel', 1, 1, 1, 0, 0);
86
87-- Dumping structure for table ripple.bancho_messages
88CREATE TABLE IF NOT EXISTS `bancho_messages` (
89 `id` int(11) NOT NULL AUTO_INCREMENT,
90 `msg_from_userid` int(11) NOT NULL,
91 `msg_from_username` varchar(30) NOT NULL,
92 `msg_to` varchar(32) NOT NULL,
93 `msg` varchar(127) NOT NULL,
94 `time` int(11) NOT NULL,
95 PRIMARY KEY (`id`)
96) ENGINE=InnoDB DEFAULT CHARSET=latin1;
97
98
99-- Dumping structure for table ripple.bancho_private_messages
100CREATE TABLE IF NOT EXISTS `bancho_private_messages` (
101 `id` int(11) NOT NULL AUTO_INCREMENT,
102 `msg_from_userid` int(11) NOT NULL,
103 `msg_from_username` varchar(30) NOT NULL,
104 `msg_to` varchar(32) NOT NULL,
105 `msg` varchar(127) NOT NULL,
106 `time` int(11) NOT NULL,
107 PRIMARY KEY (`id`)
108) ENGINE=InnoDB DEFAULT CHARSET=latin1;
109
110
111-- Dumping structure for table ripple.bancho_settings
112CREATE TABLE IF NOT EXISTS `bancho_settings` (
113 `id` int(11) NOT NULL AUTO_INCREMENT,
114 `name` varchar(32) NOT NULL,
115 `value_int` int(11) NOT NULL DEFAULT '0',
116 `value_string` varchar(512) NOT NULL,
117 PRIMARY KEY (`id`)
118) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
119
120INSERT INTO `bancho_settings` (`id`, `name`, `value_int`, `value_string`) VALUES
121 (1, 'bancho_maintenance', 0, ''),
122 (2, 'free_direct', 0, ''),
123 (3, 'menu_icon', 1, 'https://ripple.moe/static/logos/logo-pink.svg'),
124 (4, 'login_messages', 0, ''),
125 (5, 'restricted_joke', 0, ''),
126 (6, 'login_notification', 0, 'Put something here'),
127 (7, 'osu_versions', 0, ''),
128 (8, 'osu_md5s', 0, '');
129
130-- Dumping structure for table ripple.bancho_tokens
131CREATE TABLE IF NOT EXISTS `bancho_tokens` (
132 `id` int(11) NOT NULL AUTO_INCREMENT,
133 `token` varchar(16) NOT NULL,
134 `osu_id` int(11) NOT NULL,
135 `latest_message_id` int(11) NOT NULL,
136 `latest_private_message_id` int(11) NOT NULL,
137 `latest_packet_time` int(11) NOT NULL,
138 `latest_heavy_packet_time` int(11) NOT NULL,
139 `joined_channels` varchar(512) NOT NULL,
140 `game_mode` tinyint(4) NOT NULL,
141 `action` int(11) NOT NULL,
142 `action_text` varchar(128) NOT NULL,
143 `kicked` tinyint(4) NOT NULL,
144 PRIMARY KEY (`id`)
145) ENGINE=InnoDB DEFAULT CHARSET=latin1;
146
147
148-- Dumping structure for table ripple.beatmaps
149CREATE TABLE IF NOT EXISTS `beatmaps` (
150 `id` int(11) NOT NULL AUTO_INCREMENT,
151 `beatmap_id` int(11) NOT NULL DEFAULT '0',
152 `beatmapset_id` int(11) NOT NULL DEFAULT '0',
153 `beatmap_md5` varchar(32) NOT NULL,
154 `song_name` varchar(1024) NOT NULL DEFAULT '',
155 `ar` float NOT NULL DEFAULT '0',
156 `od` float NOT NULL DEFAULT '0',
157 `difficulty_std` float NOT NULL DEFAULT '0',
158 `difficulty_taiko` float NOT NULL DEFAULT '0',
159 `difficulty_ctb` float NOT NULL DEFAULT '0',
160 `difficulty_mania` float NOT NULL DEFAULT '0',
161 `max_combo` int(11) NOT NULL DEFAULT '0',
162 `hit_length` int(11) NOT NULL DEFAULT '0',
163 `bpm` int(11) NOT NULL DEFAULT '0',
164 `ranked` tinyint(4) NOT NULL DEFAULT '0',
165 `latest_update` int(11) NOT NULL DEFAULT '0',
166 `ranked_status_freezed` tinyint(1) NOT NULL DEFAULT '0',
167 `playcount` int(11) NOT NULL DEFAULT '0',
168 `passcount` int(11) NOT NULL DEFAULT '0',
169 `disable_pp` int(11) DEFAULT '0',
170 `pp_100` int(11) NOT NULL DEFAULT '0',
171 `pp_99` int(11) NOT NULL DEFAULT '0',
172 `pp_98` int(11) NOT NULL DEFAULT '0',
173 `pp_95` int(11) NOT NULL DEFAULT '0',
174 `allow_fl` int(11) NOT NULL DEFAULT '0',
175 `rating` int(32) NOT NULL DEFAULT '0',
176 PRIMARY KEY (`id`),
177 KEY `beatmapset_id` (`beatmapset_id`)
178) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
179
180
181-- Dumping structure for table ripple.beatmaps_names
182CREATE TABLE IF NOT EXISTS `beatmaps_names` (
183 `id` int(11) NOT NULL AUTO_INCREMENT,
184 `beatmap_md5` varchar(32) NOT NULL DEFAULT '',
185 `beatmap_name` varchar(256) NOT NULL DEFAULT '',
186 PRIMARY KEY (`id`)
187) ENGINE=InnoDB DEFAULT CHARSET=latin1;
188
189
190-- Dumping structure for table ripple.beatmaps_rating
191CREATE TABLE IF NOT EXISTS `beatmaps_rating` (
192 `id` int(11) NOT NULL AUTO_INCREMENT,
193 `user_id` int(11) DEFAULT NULL,
194 `rating` float DEFAULT NULL,
195 `beatmap_md5` varchar(32) DEFAULT NULL,
196 PRIMARY KEY (`id`)
197) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
198
199
200-- Dumping structure for table ripple.beta_keys
201CREATE TABLE IF NOT EXISTS `beta_keys` (
202 `id` int(11) NOT NULL,
203 `key_md5` varchar(32) NOT NULL DEFAULT '',
204 `description` varchar(128) NOT NULL DEFAULT '',
205 `allowed` tinyint(4) NOT NULL DEFAULT '0',
206 `public` tinyint(4) NOT NULL DEFAULT '0'
207) ENGINE=InnoDB DEFAULT CHARSET=latin1;
208
209
210-- Dumping structure for table ripple.cakes
211CREATE TABLE IF NOT EXISTS `cakes` (
212 `id` int(11) NOT NULL AUTO_INCREMENT,
213 `userid` int(11) NOT NULL,
214 `score_id` int(11) NOT NULL,
215 `processes` json NOT NULL,
216 `detected` json NOT NULL,
217 `flags` int(11) NOT NULL DEFAULT '0',
218 PRIMARY KEY (`id`)
219) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
220
221
222-- Dumping structure for table ripple.clans
223CREATE TABLE IF NOT EXISTS `clans` (
224 `id` int(11) NOT NULL AUTO_INCREMENT,
225 `tag` varchar(50) NOT NULL,
226 `name` varchar(32) NOT NULL,
227 `description` varchar(512) NOT NULL,
228 `icon` varchar(512) DEFAULT NULL,
229 `mlimit` int(128) NOT NULL DEFAULT '50',
230 PRIMARY KEY (`id`)
231) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
232
233
234-- Dumping structure for table ripple.clans_invites
235CREATE TABLE IF NOT EXISTS `clans_invites` (
236 `clan` int(11) DEFAULT NULL,
237 `invite` varchar(100) DEFAULT NULL,
238 KEY `invite` (`invite`)
239) ENGINE=InnoDB DEFAULT CHARSET=latin1;
240
241
242-- Dumping structure for table ripple.comments
243CREATE TABLE IF NOT EXISTS `comments` (
244 `id` int(11) NOT NULL AUTO_INCREMENT,
245 `user_id` int(11) DEFAULT NULL,
246 `beatmap_id` varchar(32) DEFAULT NULL,
247 `beatmapset_id` int(11) DEFAULT NULL,
248 `comment` varchar(50) DEFAULT NULL,
249 `who` varchar(50) DEFAULT NULL,
250 `time` varchar(18) DEFAULT NULL,
251 `special_format` varchar(18) DEFAULT NULL,
252 `score_id` varchar(18) DEFAULT NULL,
253 PRIMARY KEY (`id`)
254) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
255
256
257-- Dumping structure for table ripple.discord_roles
258CREATE TABLE IF NOT EXISTS `discord_roles` (
259 `userid` varchar(25) COLLATE latin1_bin NOT NULL DEFAULT '0',
260 `discordid` varchar(50) COLLATE latin1_bin NOT NULL DEFAULT '0',
261 `roleid` varchar(50) COLLATE latin1_bin NOT NULL DEFAULT '0',
262 `verified` varchar(50) COLLATE latin1_bin NOT NULL DEFAULT '0',
263 PRIMARY KEY (`userid`)
264) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_bin;
265
266
267-- Dumping structure for table ripple.docs
268CREATE TABLE IF NOT EXISTS `docs` (
269 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
270 `doc_name` varchar(255) NOT NULL DEFAULT 'New Documentation File',
271 `doc_contents` mediumtext NOT NULL,
272 `public` tinyint(1) unsigned NOT NULL DEFAULT '0',
273 `old_name` varchar(200) DEFAULT NULL,
274 PRIMARY KEY (`id`)
275) ENGINE=MyISAM DEFAULT CHARSET=latin1;
276
277
278-- Dumping structure for table ripple.eggs
279CREATE TABLE IF NOT EXISTS `eggs` (
280 `id` int(11) NOT NULL AUTO_INCREMENT,
281 `type` enum('hash','path','file','title') NOT NULL DEFAULT 'hash',
282 `value` varchar(128) NOT NULL,
283 `tag` varchar(128) NOT NULL,
284 `ban` tinyint(1) NOT NULL DEFAULT '0',
285 `is_regex` tinyint(1) NOT NULL DEFAULT '0',
286 PRIMARY KEY (`id`)
287) ENGINE=InnoDB DEFAULT CHARSET=latin1;
288
289
290-- Dumping structure for table ripple.hw_user
291CREATE TABLE IF NOT EXISTS `hw_user` (
292 `id` int(11) NOT NULL AUTO_INCREMENT,
293 `userid` int(11) NOT NULL,
294 `ip` int(45) NOT NULL,
295 `mac` varchar(32) NOT NULL,
296 `unique_id` varchar(32) NOT NULL,
297 `disk_id` varchar(32) NOT NULL,
298 `occurencies` int(11) NOT NULL DEFAULT '0',
299 `activated` tinyint(1) NOT NULL DEFAULT '0',
300 PRIMARY KEY (`id`),
301 UNIQUE KEY `userid_ip` (`userid`, `ip`)
302) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
303
304
305-- Dumping structure for table ripple.identity_tokens
306CREATE TABLE IF NOT EXISTS `identity_tokens` (
307 `userid` int(11) NOT NULL,
308 `token` varchar(64) NOT NULL,
309 UNIQUE KEY `userid` (`userid`)
310) ENGINE=InnoDB DEFAULT CHARSET=latin1;
311
312
313-- Dumping structure for table ripple.ip_user
314CREATE TABLE IF NOT EXISTS `ip_user` (
315 `userid` int(11) NOT NULL,
316 `ip` text NOT NULL,
317 `occurencies` int(11) NOT NULL,
318 UNIQUE KEY `userid` (`userid`)
319) ENGINE=InnoDB DEFAULT CHARSET=latin1;
320
321
322-- Dumping structure for table ripple.irc_tokens
323CREATE TABLE IF NOT EXISTS `irc_tokens` (
324 `userid` int(11) NOT NULL DEFAULT '0',
325 `token` varchar(32) NOT NULL DEFAULT '',
326 PRIMARY KEY (`userid`),
327 UNIQUE KEY `userid` (`userid`)
328) ENGINE=InnoDB DEFAULT CHARSET=latin1;
329
330
331-- Dumping structure for table ripple.leaderboard_ctb
332CREATE TABLE IF NOT EXISTS `leaderboard_ctb` (
333 `position` int(10) unsigned NOT NULL,
334 `user` int(11) NOT NULL,
335 `v` bigint(20) NOT NULL,
336 PRIMARY KEY (`position`)
337) ENGINE=InnoDB DEFAULT CHARSET=latin1;
338
339
340-- Dumping structure for table ripple.leaderboard_mania
341CREATE TABLE IF NOT EXISTS `leaderboard_mania` (
342 `position` int(10) unsigned NOT NULL,
343 `user` int(11) NOT NULL,
344 `v` bigint(20) NOT NULL,
345 PRIMARY KEY (`position`)
346) ENGINE=InnoDB DEFAULT CHARSET=latin1;
347
348
349-- Dumping structure for table ripple.leaderboard_std
350CREATE TABLE IF NOT EXISTS `leaderboard_std` (
351 `position` int(10) unsigned NOT NULL,
352 `user` int(11) NOT NULL,
353 `v` bigint(20) NOT NULL,
354 PRIMARY KEY (`position`)
355) ENGINE=InnoDB DEFAULT CHARSET=latin1;
356
357
358-- Dumping structure for table ripple.leaderboard_taiko
359CREATE TABLE IF NOT EXISTS `leaderboard_taiko` (
360 `position` int(10) unsigned NOT NULL,
361 `user` int(11) NOT NULL,
362 `v` bigint(20) NOT NULL,
363 PRIMARY KEY (`position`)
364) ENGINE=InnoDB DEFAULT CHARSET=latin1;
365
366
367-- Dumping structure for table ripple.main_menu_icons
368CREATE TABLE IF NOT EXISTS `main_menu_icons` (
369 `file_id` varchar(50) NOT NULL,
370 `url` varchar(256) NOT NULL,
371 `is_current` varchar(128) NOT NULL
372) ENGINE=InnoDB DEFAULT CHARSET=latin1;
373
374INSERT INTO `main_menu_icons` (`file_id`, `url`, `is_current`) VALUES
375 ('logo', 'https://atoka.pw/', '1');
376
377-- Dumping structure for table ripple.osin_access
378CREATE TABLE IF NOT EXISTS `osin_access` (
379 `scope` int(11) NOT NULL DEFAULT '0',
380 `created_at` int(11) NOT NULL DEFAULT '0',
381 `client` int(11) NOT NULL DEFAULT '0',
382 `extra` int(11) NOT NULL DEFAULT '0'
383) ENGINE=InnoDB DEFAULT CHARSET=latin1;
384
385
386-- Dumping structure for table ripple.osin_client
387CREATE TABLE IF NOT EXISTS `osin_client` (
388 `id` int(11) NOT NULL AUTO_INCREMENT,
389 `secret` varchar(64) NOT NULL DEFAULT '',
390 `extra` varchar(127) NOT NULL DEFAULT '',
391 `redirect_uri` varchar(127) NOT NULL DEFAULT '',
392 PRIMARY KEY (`id`)
393) ENGINE=InnoDB DEFAULT CHARSET=latin1;
394
395
396-- Dumping structure for table ripple.osin_client_user
397CREATE TABLE IF NOT EXISTS `osin_client_user` (
398 `client_id` int(11) NOT NULL DEFAULT '0',
399 `user` int(11) NOT NULL DEFAULT '0'
400) ENGINE=InnoDB DEFAULT CHARSET=latin1;
401
402
403-- Dumping structure for table ripple.password_recovery
404CREATE TABLE IF NOT EXISTS `password_recovery` (
405 `id` int(11) NOT NULL AUTO_INCREMENT,
406 `k` varchar(80) NOT NULL,
407 `u` varchar(30) NOT NULL,
408 `t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
409 PRIMARY KEY (`id`)
410) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
411
412
413-- Dumping structure for table ripple.privileges_groups
414CREATE TABLE IF NOT EXISTS `privileges_groups` (
415 `id` int(11) NOT NULL AUTO_INCREMENT,
416 `name` varchar(32) NOT NULL,
417 `privileges` int(11) NOT NULL,
418 `color` varchar(32) NOT NULL,
419 PRIMARY KEY (`id`),
420 UNIQUE KEY `name` (`name`)
421) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
422
423INSERT INTO `privileges_groups` (`id`, `name`, `privileges`, `color`) VALUES
424 (1, 'Banned', 0, ''),
425 (2, 'BAT', 271, 'warning'),
426 (3, 'Moderator', 2916575, 'success'),
427 (4, 'Administrator', 3063295, 'primary'),
428 (5, 'Developer', 1043995, ''),
429 (6, 'Donor', 7, ''),
430 (7, 'God', 3145727, 'danger'),
431 (8, 'Normal User', 3, ''),
432 (9, 'Pending', 1048576, 'default'),
433 (10, 'Restricted', 2, ''),
434 (11, 'Bots', 1048575, 'info');
435
436
437-- Dumping structure for table ripple.profile_backgrounds
438CREATE TABLE IF NOT EXISTS `profile_backgrounds` (
439 `uid` int(11) NOT NULL,
440 `time` int(11) NOT NULL,
441 `type` int(11) NOT NULL,
442 `value` text NOT NULL,
443 PRIMARY KEY (`uid`)
444) ENGINE=InnoDB DEFAULT CHARSET=latin1;
445
446
447-- Dumping structure for table ripple.rank_requests
448CREATE TABLE IF NOT EXISTS `rank_requests` (
449 `id` int(11) NOT NULL AUTO_INCREMENT,
450 `userid` int(11) NOT NULL,
451 `bid` int(11) NOT NULL,
452 `type` varchar(8) NOT NULL,
453 `time` int(11) NOT NULL,
454 `blacklisted` tinyint(1) NOT NULL,
455 PRIMARY KEY (`id`),
456 UNIQUE KEY `bid` (`bid`)
457) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
458
459
460-- Dumping structure for table ripple.rap_logs
461CREATE TABLE IF NOT EXISTS `rap_logs` (
462 `id` int(11) NOT NULL AUTO_INCREMENT,
463 `userid` int(11) NOT NULL,
464 `text` longtext NOT NULL,
465 `datetime` int(30) NOT NULL,
466 `through` text NOT NULL,
467 KEY `id` (`id`)
468) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
469
470
471-- Dumping structure for table ripple.remember
472CREATE TABLE IF NOT EXISTS `remember` (
473 `id` int(11) NOT NULL AUTO_INCREMENT,
474 `userid` int(11) NOT NULL,
475 `series_identifier` int(11) DEFAULT NULL,
476 `token_sha` varchar(255) DEFAULT NULL,
477 PRIMARY KEY (`id`)
478) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
479
480
481-- Dumping structure for table ripple.reports
482CREATE TABLE IF NOT EXISTS `reports` (
483 `id` int(11) NOT NULL AUTO_INCREMENT,
484 `name` varchar(128) NOT NULL,
485 `from_username` varchar(32) NOT NULL,
486 `content` varchar(1024) NOT NULL,
487 `type` tinyint(4) NOT NULL,
488 `open_time` varchar(18) NOT NULL,
489 `update_time` varchar(18) NOT NULL,
490 `status` tinyint(4) NOT NULL,
491 `response` varchar(1024) NOT NULL,
492 PRIMARY KEY (`id`),
493 KEY `id` (`id`)
494) ENGINE=InnoDB DEFAULT CHARSET=latin1;
495
496
497-- Dumping structure for table ripple.scores
498CREATE TABLE IF NOT EXISTS `scores` (
499 `id` int(11) NOT NULL AUTO_INCREMENT,
500 `beatmap_md5` varchar(32) NOT NULL DEFAULT '',
501 `userid` int(11) NOT NULL,
502 `score` bigint(20) DEFAULT NULL,
503 `max_combo` int(11) NOT NULL DEFAULT '0',
504 `full_combo` tinyint(1) NOT NULL DEFAULT '0',
505 `mods` int(11) NOT NULL DEFAULT '0',
506 `300_count` int(11) NOT NULL DEFAULT '0',
507 `100_count` int(11) NOT NULL DEFAULT '0',
508 `50_count` int(11) NOT NULL DEFAULT '0',
509 `katus_count` int(11) NOT NULL DEFAULT '0',
510 `gekis_count` int(11) NOT NULL DEFAULT '0',
511 `misses_count` int(11) NOT NULL DEFAULT '0',
512 `time` varchar(18) NOT NULL DEFAULT '',
513 `play_mode` tinyint(4) NOT NULL DEFAULT '0',
514 `completed` tinyint(11) NOT NULL DEFAULT '0',
515 `accuracy` float(15,12) DEFAULT NULL,
516 `pp` float DEFAULT '0',
517 `beatmaps` varchar(32) DEFAULT NULL,
518 PRIMARY KEY (`id`)
519) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
520
521
522-- Dumping structure for table ripple.scores_removed
523CREATE TABLE IF NOT EXISTS `scores_removed` (
524 `id` int(11) NOT NULL AUTO_INCREMENT,
525 `beatmap_md5` varchar(32) NOT NULL DEFAULT '',
526 `userid` int(11) NOT NULL,
527 `score` bigint(20) DEFAULT NULL,
528 `max_combo` int(11) NOT NULL DEFAULT '0',
529 `full_combo` tinyint(1) NOT NULL DEFAULT '0',
530 `mods` int(11) NOT NULL DEFAULT '0',
531 `300_count` int(11) NOT NULL DEFAULT '0',
532 `100_count` int(11) NOT NULL DEFAULT '0',
533 `50_count` int(11) NOT NULL DEFAULT '0',
534 `katus_count` int(11) NOT NULL DEFAULT '0',
535 `gekis_count` int(11) NOT NULL DEFAULT '0',
536 `misses_count` int(11) NOT NULL DEFAULT '0',
537 `time` varchar(18) NOT NULL DEFAULT '',
538 `play_mode` tinyint(4) NOT NULL DEFAULT '0',
539 `completed` tinyint(11) NOT NULL DEFAULT '0',
540 `accuracy` float(15,12) DEFAULT NULL,
541 `pp` float DEFAULT '0',
542 `beatmaps` varchar(32) DEFAULT NULL,
543 PRIMARY KEY (`id`)
544) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
545
546
547-- Dumping structure for table ripple.system_settings
548CREATE TABLE IF NOT EXISTS `system_settings` (
549 `id` int(11) NOT NULL AUTO_INCREMENT,
550 `name` varchar(32) NOT NULL,
551 `value_int` int(11) NOT NULL DEFAULT '0',
552 `value_string` varchar(512) NOT NULL,
553 PRIMARY KEY (`id`)
554) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
555
556INSERT INTO `system_settings` (`id`, `name`, `value_int`, `value_string`) VALUES
557 (1, 'website_maintenance', 0, ''),
558 (2, 'game_maintenance', 0, ''),
559 (3, 'website_global_alert', 1, ''),
560 (4, 'website_home_alert', 0, ''),
561 (5, 'registrations_enabled', 1, ''),
562 (6, 'ccreation_enabled', 1, ''),
563 (7, 'staff_applications_enabled', 1, '');
564
565
566-- Dumping structure for table ripple.tokens
567CREATE TABLE IF NOT EXISTS `tokens` (
568 `id` int(11) NOT NULL AUTO_INCREMENT,
569 `user` varchar(31) NOT NULL,
570 `privileges` int(11) NOT NULL,
571 `description` varchar(255) NOT NULL,
572 `token` varchar(127) NOT NULL,
573 `private` tinyint(4) NOT NULL,
574 `last_updated` int(11) NOT NULL DEFAULT '0',
575 PRIMARY KEY (`id`)
576) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
577
578
579-- Dumping structure for table ripple.users
580CREATE TABLE IF NOT EXISTS `users` (
581 `id` int(11) NOT NULL AUTO_INCREMENT,
582 `username` varchar(30) NOT NULL,
583 `username_safe` varchar(30) NOT NULL,
584 `password_md5` varchar(127) NOT NULL,
585 `salt` varchar(32) NOT NULL,
586 `email` varchar(254) NOT NULL,
587 `register_datetime` int(10) NOT NULL,
588 `rank` tinyint(1) NOT NULL DEFAULT '1',
589 `allowed` tinyint(1) NOT NULL DEFAULT '1',
590 `latest_activity` int(10) NOT NULL DEFAULT '0',
591 `silence_end` int(11) NOT NULL DEFAULT '0',
592 `silence_reason` varchar(127) NOT NULL DEFAULT '',
593 `password_version` tinyint(4) NOT NULL DEFAULT '1',
594 `privileges` int(11) NOT NULL,
595 `donor_expire` int(11) NOT NULL DEFAULT '0',
596 `flags` int(11) NOT NULL DEFAULT '0',
597 `notes` text,
598 `ban_datetime` text,
599 `strikes` int(11) NOT NULL DEFAULT '0',
600 `nwipes` int(11) NOT NULL DEFAULT '0',
601 `cwipes` int(11) NOT NULL DEFAULT '0',
602 `achievements_version` int(11) NOT NULL DEFAULT '6',
603 `flags_reason` text,
604 `aqn` int(11) DEFAULT '0',
605 PRIMARY KEY (`id`)
606) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
607
608
609-- Dumping structure for table ripple.users_achievements
610CREATE TABLE IF NOT EXISTS `users_achievements` (
611 `id` int(11) NOT NULL AUTO_INCREMENT,
612 `user_id` int(11) NOT NULL,
613 `achievement_id` int(11) NOT NULL,
614 `time` int(11) NOT NULL,
615 KEY `id` (`id`)
616) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
617
618
619-- Dumping structure for table ripple.users_relationships
620CREATE TABLE IF NOT EXISTS `users_relationships` (
621 `id` int(11) NOT NULL AUTO_INCREMENT,
622 `user1` int(11) NOT NULL,
623 `user2` int(11) NOT NULL,
624 PRIMARY KEY (`id`)
625) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
626
627
628-- Dumping structure for table ripple.users_stats
629CREATE TABLE IF NOT EXISTS `users_stats` (
630 `id` int(11) NOT NULL AUTO_INCREMENT,
631 `username` varchar(30) NOT NULL,
632 `username_aka` varchar(32) NOT NULL DEFAULT '',
633 `user_color` varchar(16) NOT NULL DEFAULT 'black',
634 `user_style` varchar(128) NOT NULL DEFAULT '',
635 `ranked_score_std` bigint(20) NOT NULL DEFAULT '0',
636 `playcount_std` int(11) NOT NULL DEFAULT '0',
637 `total_score_std` bigint(20) NOT NULL DEFAULT '0',
638 `replays_watched_std` int(11) unsigned NOT NULL DEFAULT '0',
639 `ranked_score_taiko` bigint(20) NOT NULL DEFAULT '0',
640 `playcount_taiko` int(11) NOT NULL DEFAULT '0',
641 `total_score_taiko` bigint(20) NOT NULL DEFAULT '0',
642 `replays_watched_taiko` int(11) NOT NULL DEFAULT '0',
643 `ranked_score_ctb` bigint(20) NOT NULL DEFAULT '0',
644 `playcount_ctb` int(11) NOT NULL DEFAULT '0',
645 `total_score_ctb` bigint(20) NOT NULL DEFAULT '0',
646 `replays_watched_ctb` int(11) NOT NULL DEFAULT '0',
647 `ranked_score_mania` bigint(20) NOT NULL DEFAULT '0',
648 `playcount_mania` int(11) NOT NULL DEFAULT '0',
649 `total_score_mania` bigint(20) NOT NULL DEFAULT '0',
650 `replays_watched_mania` int(10) unsigned NOT NULL DEFAULT '0',
651 `total_hits_std` int(11) NOT NULL DEFAULT '0',
652 `total_hits_taiko` int(11) NOT NULL DEFAULT '0',
653 `total_hits_ctb` int(11) NOT NULL DEFAULT '0',
654 `total_hits_mania` int(11) NOT NULL DEFAULT '0',
655 `country` char(2) NOT NULL DEFAULT 'XX',
656 `show_country` tinyint(4) NOT NULL DEFAULT '1',
657 `level_std` int(11) NOT NULL DEFAULT '1',
658 `level_taiko` int(11) NOT NULL DEFAULT '1',
659 `level_ctb` int(11) NOT NULL DEFAULT '1',
660 `level_mania` int(11) NOT NULL DEFAULT '1',
661 `avg_accuracy_std` float(15,12) NOT NULL DEFAULT '0.000000000000',
662 `avg_accuracy_taiko` float(15,12) NOT NULL DEFAULT '0.000000000000',
663 `avg_accuracy_ctb` float(15,12) NOT NULL DEFAULT '0.000000000000',
664 `avg_accuracy_mania` float(15,12) NOT NULL DEFAULT '0.000000000000',
665 `pp_std` int(11) NOT NULL DEFAULT '0',
666 `pp_taiko` int(11) NOT NULL DEFAULT '0',
667 `pp_ctb` int(11) NOT NULL DEFAULT '0',
668 `pp_mania` int(11) NOT NULL DEFAULT '0',
669 `badges_shown` varchar(24) NOT NULL DEFAULT '1,0,0,0,0,0',
670 `safe_title` tinyint(4) NOT NULL DEFAULT '0',
671 `userpage_content` varchar(5120) DEFAULT NULL,
672 `play_style` smallint(6) NOT NULL DEFAULT '0',
673 `favourite_mode` tinyint(4) NOT NULL DEFAULT '0',
674 `custom_badge_icon` varchar(32) NOT NULL DEFAULT '',
675 `custom_badge_name` varchar(32) NOT NULL DEFAULT '',
676 `can_custom_badge` tinyint(1) NOT NULL DEFAULT '0',
677 `show_custom_badge` tinyint(1) NOT NULL DEFAULT '0',
678 PRIMARY KEY (`id`)
679) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
680
681
682-- Dumping structure for table ripple.user_badges
683CREATE TABLE IF NOT EXISTS `user_badges` (
684 `id` int(11) NOT NULL AUTO_INCREMENT,
685 `badge` int(11) NOT NULL,
686 `user` varchar(64) NOT NULL,
687 PRIMARY KEY (`id`)
688) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
689
690
691-- Dumping structure for table ripple.user_clans
692CREATE TABLE IF NOT EXISTS `user_clans` (
693 `clan` int(11) NOT NULL,
694 `user` int(11) NOT NULL,
695 `perms` int(11) NOT NULL
696) ENGINE=InnoDB DEFAULT CHARSET=latin1;
697
698
699-- Dumping structure for table ripple.user_wipes
700CREATE TABLE IF NOT EXISTS `user_wipes` (
701 `id` int(2) NOT NULL AUTO_INCREMENT,
702 `userid` int(4) NOT NULL,
703 `modid` int(11) NOT NULL,
704 `datetime` int(30) NOT NULL,
705 `evidence` longtext NOT NULL,
706 `text` longtext NOT NULL,
707 KEY `id` (`id`)
708) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
709
710
711/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
712/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
713/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;