· 6 years ago · Oct 10, 2019, 11:08 AM
1-- phpMyAdmin SQL Dump
2-- version 4.5.4.1deb2ubuntu2.1
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Mar 03, 2019 at 06:47 AM
7-- Server version: 5.7.25-0ubuntu0.16.04.2
8-- PHP Version: 7.0.33-2+ubuntu16.04.1+deb.sury.org+2+will+reach+end+of+life+in+april+2019
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8mb4 */;
18
19--
20-- Database: `ripple`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `2fa`
27--
28
29CREATE TABLE `2fa` (
30 `userid` int(11) NOT NULL,
31 `ip` int(11) NOT NULL
32) ENGINE=InnoDB DEFAULT CHARSET=utf8;
33
34-- --------------------------------------------------------
35
36--
37-- Table structure for table `2fa_telegram`
38--
39
40CREATE TABLE `2fa_telegram` (
41 `id` int(11) NOT NULL,
42 `userid` int(11) NOT NULL
43) ENGINE=InnoDB DEFAULT CHARSET=latin1;
44
45-- --------------------------------------------------------
46
47--
48-- Table structure for table `2fa_totp`
49--
50
51CREATE TABLE `2fa_totp` (
52 `enabled` tinyint(1) NOT NULL DEFAULT '0',
53 `userid` int(11) NOT NULL
54) ENGINE=InnoDB DEFAULT CHARSET=utf8;
55
56-- --------------------------------------------------------
57
58--
59-- Table structure for table `achievements`
60--
61
62CREATE TABLE `achievements` (
63 `id` int(11) NOT NULL,
64 `name` varchar(32) CHARACTER SET latin1 NOT NULL,
65 `description` varchar(128) CHARACTER SET latin1 NOT NULL,
66 `icon` varchar(32) CHARACTER SET latin1 NOT NULL,
67 `version` int(11) NOT NULL DEFAULT '0'
68) ENGINE=InnoDB DEFAULT CHARSET=utf8;
69
70--
71-- Dumping data for table `achievements`
72--
73
74INSERT INTO `achievements` (`id`, `name`, `description`, `icon`, `version`) VALUES
75(1, '500 Combo (osu!std)', '500 big ones! You\'re moving up in the world!', 'osu-combo-500', 1),
76(2, '750 Combo (osu!std)', '750 big ones! You\'re moving up in the world!', 'osu-combo-750', 1),
77(3, '1000 Combo (osu!std)', '1000 big ones! You\'re moving up in the world!', 'osu-combo-1000', 1),
78(4, '2000 Combo (osu!std)', '2000 big ones! You\'re moving up in the world!', 'osu-combo-2000', 1),
79(5, '500 Combo (osu!taiko)', '500 big ones! You\'re moving up in the world!', 'osu-combo-500', 1),
80(6, '750 Combo (osu!taiko)', '750 big ones! You\'re moving up in the world!', 'osu-combo-750', 1),
81(7, '1000 Combo (osu!taiko)', '1000 big ones! You\'re moving up in the world!', 'osu-combo-1000', 1),
82(8, '2000 Combo (osu!taiko)', '2000 big ones! You\'re moving up in the world!', 'osu-combo-2000', 1),
83(9, '500 Combo (osu!ctb)', '500 big ones! You\'re moving up in the world!', 'osu-combo-500', 1),
84(10, '750 Combo (osu!ctb)', '750 big ones! You\'re moving up in the world!', 'osu-combo-750', 1),
85(11, '1000 Combo (osu!ctb)', '1000 big ones! You\'re moving up in the world!', 'osu-combo-1000', 1),
86(12, '2000 Combo (osu!ctb)', '2000 big ones! You\'re moving up in the world!', 'osu-combo-2000', 1),
87(13, '500 Combo (osu!mania)', '500 big ones! You\'re moving up in the world!', 'osu-combo-500', 1),
88(14, '750 Combo (osu!mania)', '750 big ones! You\'re moving up in the world!', 'osu-combo-750', 1),
89(15, '1000 Combo (osu!mania)', '1000 big ones! You\'re moving up in the world!', 'osu-combo-1000', 1),
90(16, '2000 Combo (osu!mania)', '2000 big ones! You\'re moving up in the world!', 'osu-combo-2000', 1),
91(17, 'Rising Star', 'Can\'t go forward without the first steps.', 'osu-skill-pass-1', 2),
92(18, 'My First Don', 'Can\'t go forward without the first steps.', 'taiko-skill-pass-1', 2),
93(19, 'A Slice Of Life', 'Can\'t go forward without the first steps.', 'fruits-skill-pass-1', 2),
94(20, 'First Steps', 'Can\'t go forward without the first steps.', 'mania-skill-pass-1', 2),
95(21, 'Constellation Prize', 'Definitely not a consolation prize. Now things start getting hard!', 'osu-skill-pass-2', 2),
96(22, 'Katsu Katsu Katsu', 'Definitely not a consolation prize. Now things start getting hard!', 'taiko-skill-pass-2', 2),
97(23, 'Dashing Ever Forward', 'Definitely not a consolation prize. Now things start getting hard!', 'fruits-skill-pass-2', 2),
98(24, 'No Normal Player', 'Definitely not a consolation prize. Now things start getting hard!', 'mania-skill-pass-2', 2),
99(25, 'Building Confidence', 'Oh, you\'ve SO got this.', 'osu-skill-pass-3', 2),
100(26, 'Not Even Trying', 'Oh, you\'ve SO got this.', 'taiko-skill-pass-3', 2),
101(27, 'Zesty Disposition', 'Oh, you\'ve SO got this.', 'fruits-skill-pass-3', 2),
102(28, 'Impulse Drive', 'Oh, you\'ve SO got this.', 'mania-skill-pass-3', 2),
103(29, 'Insanity Approaches', 'You\'re not twitching, you\'re just ready.', 'osu-skill-pass-4', 2),
104(30, 'Face Your Demons', 'You\'re not twitching, you\'re just ready.', 'taiko-skill-pass-4', 2),
105(31, 'Hyperdash ON!', 'You\'re not twitching, you\'re just ready.', 'fruits-skill-pass-4', 2),
106(32, 'Hyperspeed', 'You\'re not twitching, you\'re just ready.', 'mania-skill-pass-4', 2),
107(33, 'These Clarion Skies', 'Everything seems so clear now.', 'osu-skill-pass-5', 2),
108(34, 'The Demon Within', 'Everything seems so clear now.', 'taiko-skill-pass-5', 2),
109(35, 'It\'s Raining Fruit', 'Everything seems so clear now.', 'fruits-skill-pass-5', 2),
110(36, 'Ever Onwards', 'Everything seems so clear now.', 'mania-skill-pass-5', 2),
111(37, 'Above and Beyond', 'A cut above the rest.', 'osu-skill-pass-6', 2),
112(38, 'Drumbreaker', 'A cut above the rest.', 'taiko-skill-pass-6', 2),
113(39, 'Fruit Ninja', 'A cut above the rest.', 'fruits-skill-pass-6', 2),
114(40, 'Another Surpassed', 'A cut above the rest.', 'mania-skill-pass-6', 2),
115(41, 'Supremacy', 'All marvel before your prowess.', 'osu-skill-pass-7', 2),
116(42, 'The Godfather', 'All marvel before your prowess.', 'taiko-skill-pass-7', 2),
117(43, 'Dreamcatcher', 'All marvel before your prowess.', 'fruits-skill-pass-7', 2),
118(44, 'Extra Credit', 'All marvel before your prowess.', 'mania-skill-pass-7', 2),
119(45, 'Absolution', 'My god, you\'re full of stars!', 'osu-skill-pass-8', 2),
120(46, 'Rhythm Incarnate', 'My god, you\'re full of stars!', 'taiko-skill-pass-8', 2),
121(47, 'Lord of the Catch', 'My god, you\'re full of stars!', 'fruits-skill-pass-8', 2),
122(48, 'Maniac', 'My god, you\'re full of stars!', 'mania-skill-pass-8', 2),
123(49, 'Totality', 'All the notes. Every single one.', 'osu-skill-fc-1', 3),
124(50, 'Keeping Time', 'All the notes. Every single one.', 'taiko-skill-fc-1', 3),
125(51, 'Sweet And Sour', 'All the notes. Every single one.', 'fruits-skill-fc-1', 3),
126(52, 'Keystruck', 'All the notes. Every single one.', 'mania-skill-fc-1', 3),
127(53, 'Business As Usual', 'Two to go, please.', 'osu-skill-fc-2', 3),
128(54, 'To Your Own Beat', 'Two to go, please.', 'taiko-skill-fc-2', 3),
129(55, 'Reaching The Core', 'Two to go, please.', 'fruits-skill-fc-2', 3),
130(56, 'Keying In', 'Two to go, please.', 'mania-skill-fc-2', 3),
131(57, 'Building Steam', 'Hey, this isn\'t so bad.', 'osu-skill-fc-3', 3),
132(58, 'Big Drums', 'Hey, this isn\'t so bad.', 'taiko-skill-fc-3', 3),
133(59, 'Clean Platter', 'Hey, this isn\'t so bad.', 'fruits-skill-fc-3', 3),
134(60, 'Hyperflow', 'Hey, this isn\'t so bad.', 'mania-skill-fc-3', 3),
135(61, 'Moving Forward', 'Bet you feel good about that.', 'osu-skill-fc-4', 3),
136(62, 'Adversity Overcome', 'Bet you feel good about that.', 'taiko-skill-fc-4', 3),
137(63, 'Between The Rain', 'Bet you feel good about that.', 'fruits-skill-fc-4', 3),
138(64, 'Breakthrough', 'Bet you feel good about that.', 'mania-skill-fc-4', 3),
139(65, 'Paradigm Shift', 'Surprisingly difficult.', 'osu-skill-fc-5', 3),
140(66, 'Demonslayer', 'Surprisingly difficult.', 'taiko-skill-fc-5', 3),
141(67, 'Addicted', 'Surprisingly difficult.', 'fruits-skill-fc-5', 3),
142(68, 'Everything Extra', 'Surprisingly difficult.', 'mania-skill-fc-5', 3),
143(69, 'Anguish Quelled', 'Don\'t choke.', 'osu-skill-fc-6', 3),
144(70, 'Rhythm\'s Call', 'Don\'t choke.', 'taiko-skill-fc-6', 3),
145(71, 'Quickening', 'Don\'t choke.', 'fruits-skill-fc-6', 3),
146(72, 'Level Breaker', 'Don\'t choke.', 'mania-skill-fc-6', 3),
147(73, 'Never Give Up', 'Excellence is its own reward.', 'osu-skill-fc-7', 3),
148(74, 'Time Everlasting', 'Excellence is its own reward.', 'taiko-skill-fc-7', 3),
149(75, 'Supersonic', 'Excellence is its own reward.', 'fruits-skill-fc-7', 3),
150(76, 'Step Up', 'Excellence is its own reward.', 'mania-skill-fc-7', 3),
151(77, 'Aberration', 'They said it couldn\'t be done. They were wrong.', 'osu-skill-fc-8', 3),
152(78, 'The Drummer\'s Throne', 'They said it couldn\'t be done. They were wrong.', 'taiko-skill-fc-8', 3),
153(79, 'Dashing Scarlet', 'They said it couldn\'t be done. They were wrong.', 'fruits-skill-fc-8', 3),
154(80, 'Behind The Veil', 'They said it couldn\'t be done. They were wrong.', 'mania-skill-fc-8', 3),
155(81, 'Finality', 'High stakes, no regrets.', 'all-intro-suddendeath', 4),
156(82, 'Perfectionist', 'Accept nothing but the best.', 'all-intro-perfect', 4),
157(83, 'Rock Around The Clock', 'You can\'t stop the rock.', 'all-intro-hardrock', 4),
158(84, 'Time And A Half', 'Having a right ol\' time. One and a half of them, almost.', 'all-intro-doubletime', 4),
159(85, 'Sweet Rave Party', 'Founded in the fine tradition of changing things that were just fine as they were.', 'all-intro-nightcore', 4),
160(86, 'Blindsight', 'I can see just perfectly.', 'all-intro-hidden', 4),
161(87, 'Are You Afraid Of The Dark?', 'Harder than it looks, probably because it\'s hard to look.', 'all-intro-flashlight', 4),
162(88, 'Dial It Right Back', 'Sometimes you just want to take it easy.', 'all-intro-easy', 4),
163(89, 'Risk Averse', 'Safety nets are fun!', 'all-intro-nofail', 4),
164(90, 'Slowboat', 'You got there. Eventually.', 'all-intro-halftime', 4),
165(91, 'Burned Out', 'One cannot always spin to win.', 'all-intro-spunout', 4);
166
167-- --------------------------------------------------------
168
169--
170-- Table structure for table `badges`
171--
172
173CREATE TABLE `badges` (
174 `id` int(11) NOT NULL,
175 `name` varchar(32) CHARACTER SET latin1 NOT NULL,
176 `icon` varchar(32) CHARACTER SET latin1 NOT NULL
177) ENGINE=InnoDB DEFAULT CHARSET=utf8;
178
179--
180-- Dumping data for table `badges`
181--
182
183INSERT INTO `badges` (`id`, `name`, `icon`) VALUES
184(0, '', ''),
185(1, 'Beta tester 1.5', 'fa-gift'),
186(2, 'Developer', 'blue fa-code'),
187(3, 'Big PP boi', 'blue fa-paypal'),
188(4, 'Community Manager', 'red fa-bolt'),
189(5, 'Bot', 'fa-cogs'),
190(6, 'Verified osu!std player', 'green check'),
191(7, 'Verified osu!ctb player', 'green check'),
192(8, 'Verified osu!mania player', 'green check'),
193(9, 'Verified osu!taiko player', 'green check'),
194(30, 'Chat Moderator', 'location arrow'),
195(31, 'Donator', 'fa-money'),
196(32, 'washed up', 'fa-plane');
197
198-- --------------------------------------------------------
199
200--
201-- Table structure for table `bancho_channels`
202--
203
204CREATE TABLE `bancho_channels` (
205 `id` int(11) NOT NULL,
206 `name` varchar(32) NOT NULL,
207 `description` varchar(127) NOT NULL,
208 `public_read` tinyint(4) NOT NULL,
209 `public_write` tinyint(4) NOT NULL,
210 `status` tinyint(4) NOT NULL,
211 `temp` tinyint(1) NOT NULL DEFAULT '0',
212 `hidden` tinyint(1) NOT NULL DEFAULT '0'
213) ENGINE=InnoDB DEFAULT CHARSET=utf8;
214
215--
216-- Dumping data for table `bancho_channels`
217--
218
219INSERT INTO `bancho_channels` (`id`, `name`, `description`, `public_read`, `public_write`, `status`, `temp`, `hidden`) VALUES
220(1, '#osu', 'Ripple global chat', 1, 1, 1, 0, 0),
221(2, '#announce', 'Announce channel', 1, 0, 1, 0, 0),
222(3, '#thai', 'Thai community', 1, 1, 1, 0, 0),
223(4, '#english', 'English community', 1, 1, 1, 0, 0),
224(5, '#admin', 'Are you admin?', 1, 1, 1, 0, 1),
225(6, '#lobby', 'This is the lobby where you find games to play with others!', 1, 1, 1, 0, 1);
226
227-- --------------------------------------------------------
228
229--
230-- Table structure for table `bancho_messages`
231--
232
233CREATE TABLE `bancho_messages` (
234 `id` int(11) NOT NULL,
235 `msg_from_userid` int(11) NOT NULL,
236 `msg_from_username` varchar(30) CHARACTER SET latin1 NOT NULL,
237 `msg_to` varchar(32) CHARACTER SET latin1 NOT NULL,
238 `msg` varchar(127) CHARACTER SET latin1 NOT NULL,
239 `time` int(11) NOT NULL
240) ENGINE=InnoDB DEFAULT CHARSET=utf8;
241
242-- --------------------------------------------------------
243
244--
245-- Table structure for table `bancho_private_messages`
246--
247
248CREATE TABLE `bancho_private_messages` (
249 `id` int(11) NOT NULL,
250 `msg_from_userid` int(11) NOT NULL,
251 `msg_from_username` varchar(30) CHARACTER SET latin1 NOT NULL,
252 `msg_to` varchar(32) CHARACTER SET latin1 NOT NULL,
253 `msg` varchar(127) CHARACTER SET latin1 NOT NULL,
254 `time` int(11) NOT NULL
255) ENGINE=InnoDB DEFAULT CHARSET=utf8;
256
257-- --------------------------------------------------------
258
259--
260-- Table structure for table `bancho_settings`
261--
262
263CREATE TABLE `bancho_settings` (
264 `id` int(11) NOT NULL,
265 `name` varchar(32) NOT NULL,
266 `value_int` int(11) NOT NULL DEFAULT '0',
267 `value_string` varchar(512) NOT NULL
268) ENGINE=InnoDB DEFAULT CHARSET=utf8;
269
270--
271-- Dumping data for table `bancho_settings`
272--
273
274INSERT INTO `bancho_settings` (`id`, `name`, `value_int`, `value_string`) VALUES
275(1, 'bancho_maintenance', 0, ''),
276(2, 'free_direct', 1, ''),
277(3, 'menu_icon', 1, 'https://i.ppy.sh/logo.png | https://bigtu.vip'),
278(4, 'login_messages', 1, ''),
279(5, 'restricted_joke', 0, 'You\'re banned from the server.'),
280(6, 'login_notification', 1, 'Welcome to pep.py'),
281(7, 'osu_versions', 0, ''),
282(8, 'osu_md5s', 0, '');
283-- --------------------------------------------------------
284--
285-- Table structure for table `bancho_tokens`
286--
287CREATE TABLE `bancho_tokens` (
288 `id` int(11) NOT NULL,
289 `token` varchar(16) CHARACTER SET latin1 NOT NULL,
290 `osu_id` int(11) NOT NULL,
291 `latest_message_id` int(11) NOT NULL,
292 `latest_private_message_id` int(11) NOT NULL,
293 `latest_packet_time` int(11) NOT NULL,
294 `latest_heavy_packet_time` int(11) NOT NULL,
295 `joined_channels` varchar(512) CHARACTER SET latin1 NOT NULL,
296 `game_mode` tinyint(4) NOT NULL,
297 `action` int(11) NOT NULL,
298 `action_text` varchar(128) CHARACTER SET latin1 NOT NULL,
299 `kicked` tinyint(4) NOT NULL
300) ENGINE=InnoDB DEFAULT CHARSET=utf8;
301-- --------------------------------------------------------
302--
303-- Table structure for table `beatmaps`
304--
305CREATE TABLE `beatmaps` (
306 `id` int(11) NOT NULL,
307 `beatmap_id` int(11) NOT NULL DEFAULT '0',
308 `beatmapset_id` int(11) NOT NULL DEFAULT '0',
309 `beatmap_md5` varchar(32) CHARACTER SET latin1 NOT NULL DEFAULT '',
310 `song_name` varchar(128) CHARACTER SET latin1 NOT NULL DEFAULT '',
311 `ar` float NOT NULL DEFAULT '0',
312 `od` float NOT NULL DEFAULT '0',
313 `rating` int(11) NOT NULL DEFAULT '10',
314 `difficulty_std` float NOT NULL DEFAULT '0',
315 `difficulty_taiko` float NOT NULL DEFAULT '0',
316 `difficulty_ctb` float NOT NULL DEFAULT '0',
317 `difficulty_mania` float NOT NULL DEFAULT '0',
318 `max_combo` int(11) NOT NULL DEFAULT '0',
319 `hit_length` int(11) NOT NULL DEFAULT '0',
320 `bpm` int(11) NOT NULL DEFAULT '0',
321 `ranked` tinyint(4) NOT NULL DEFAULT '0',
322 `latest_update` int(11) NOT NULL DEFAULT '0',
323 `ranked_status_freezed` tinyint(1) NOT NULL DEFAULT '0',
324 `playcount` int(11) NOT NULL DEFAULT '0',
325 `passcount` int(11) NOT NULL DEFAULT '0',
326 `pp_100` int(11) NOT NULL DEFAULT '0',
327 `pp_99` int(11) NOT NULL DEFAULT '0',
328 `pp_98` int(11) NOT NULL DEFAULT '0',
329 `pp_95` int(11) NOT NULL DEFAULT '0',
330 `disable_pp` tinyint(4) NOT NULL DEFAULT '0'
331) ENGINE=InnoDB DEFAULT CHARSET=utf8;
332-- --------------------------------------------------------
333--
334-- Table structure for table `beatmaps_names`
335--
336CREATE TABLE `beatmaps_names` (
337 `id` int(11) NOT NULL,
338 `beatmap_md5` varchar(32) CHARACTER SET latin1 NOT NULL DEFAULT '',
339 `beatmap_name` varchar(256) CHARACTER SET latin1 NOT NULL DEFAULT ''
340) ENGINE=InnoDB DEFAULT CHARSET=utf8;
341-- --------------------------------------------------------
342--
343-- Table structure for table `beatmaps_rating`
344--
345CREATE TABLE `beatmaps_rating` (
346 `id` int(11) NOT NULL,
347 `user_id` int(11) NOT NULL,
348 `beatmap_md5` varchar(32) NOT NULL,
349 `rating` int(11) NOT NULL
350) ENGINE=InnoDB DEFAULT CHARSET=utf8;
351-- --------------------------------------------------------
352--
353-- Table structure for table `comments`
354--
355CREATE TABLE `comments` (
356 `id` int(11) NOT NULL,
357 `user_id` int(11) NOT NULL,
358 `beatmap_id` int(11) NOT NULL DEFAULT '0',
359 `beatmapset_id` int(11) NOT NULL DEFAULT '0',
360 `score_id` int(11) NOT NULL DEFAULT '0',
361 `comment` varchar(128) CHARACTER SET utf8 NOT NULL,
362 `time` int(11) NOT NULL,
363 `who` varchar(11) NOT NULL,
364 `special_format` varchar(2556) CHARACTER SET utf8 DEFAULT 'FFFFFF'
365) ENGINE=InnoDB DEFAULT CHARSET=latin1;
366-- --------------------------------------------------------
367--
368-- Table structure for table `discord_roles`
369--
370CREATE TABLE `discord_roles` (
371 `id` int(11) NOT NULL,
372 `userid` int(11) NOT NULL,
373 `discordid` bigint(19) NOT NULL,
374 `roleid` bigint(19) NOT NULL
375) ENGINE=InnoDB DEFAULT CHARSET=utf8;
376-- --------------------------------------------------------
377--
378-- Table structure for table `docs`
379--
380CREATE TABLE `docs` (
381 `id` int(11) UNSIGNED NOT NULL,
382 `doc_name` varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT 'New Documentation File',
383 `doc_contents` mediumtext CHARACTER SET latin1 NOT NULL,
384 `public` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
385 `old_name` varchar(200) CHARACTER SET latin1 DEFAULT NULL
386) ENGINE=MyISAM DEFAULT CHARSET=utf8;
387-- --------------------------------------------------------
388--
389-- Table structure for table `hw_user`
390--
391CREATE TABLE `hw_user` (
392 `id` int(11) NOT NULL,
393 `userid` int(11) NOT NULL,
394 `mac` varchar(32) CHARACTER SET latin1 NOT NULL,
395 `unique_id` varchar(32) CHARACTER SET latin1 NOT NULL,
396 `disk_id` varchar(32) CHARACTER SET latin1 NOT NULL,
397 `occurencies` int(11) NOT NULL DEFAULT '0',
398 `activated` tinyint(1) NOT NULL DEFAULT '0'
399) ENGINE=InnoDB DEFAULT CHARSET=utf8;
400-- --------------------------------------------------------
401--
402-- Table structure for table `identity_tokens`
403--
404CREATE TABLE `identity_tokens` (
405 `userid` int(11) NOT NULL,
406 `token` varchar(64) CHARACTER SET latin1 NOT NULL
407) ENGINE=InnoDB DEFAULT CHARSET=utf8;
408-- --------------------------------------------------------
409--
410-- Table structure for table `ip_user`
411--
412CREATE TABLE `ip_user` (
413 `userid` int(11) NOT NULL,
414 `ip` text CHARACTER SET latin1 NOT NULL,
415 `occurencies` int(11) NOT NULL
416) ENGINE=InnoDB DEFAULT CHARSET=utf8;
417-- --------------------------------------------------------
418--
419-- Table structure for table `irc_tokens`
420--
421CREATE TABLE `irc_tokens` (
422 `userid` int(11) NOT NULL DEFAULT '0',
423 `token` varchar(32) CHARACTER SET latin1 NOT NULL DEFAULT ''
424) ENGINE=InnoDB DEFAULT CHARSET=utf8;
425--
426-- Dumping data for table `irc_tokens`
427--
428INSERT INTO `irc_tokens` (`userid`, `token`) VALUES
429(1018, '9f4ac9130c532f23cf3e8bc5807554df');
430-- --------------------------------------------------------
431--
432-- Table structure for table `leaderboard_ctb`
433--
434CREATE TABLE `leaderboard_ctb` (
435 `position` int(10) UNSIGNED NOT NULL,
436 `user` int(11) NOT NULL,
437 `v` bigint(20) NOT NULL
438) ENGINE=InnoDB DEFAULT CHARSET=utf8;
439-- --------------------------------------------------------
440--
441-- Table structure for table `leaderboard_mania`
442--
443CREATE TABLE `leaderboard_mania` (
444 `position` int(10) UNSIGNED NOT NULL,
445 `user` int(11) NOT NULL,
446 `v` bigint(20) NOT NULL
447) ENGINE=InnoDB DEFAULT CHARSET=utf8;
448-- --------------------------------------------------------
449--
450-- Table structure for table `leaderboard_std`
451--
452CREATE TABLE `leaderboard_std` (
453 `position` int(10) UNSIGNED NOT NULL,
454 `user` int(11) NOT NULL,
455 `v` bigint(20) NOT NULL
456) ENGINE=InnoDB DEFAULT CHARSET=utf8;
457-- --------------------------------------------------------
458--
459-- Table structure for table `leaderboard_taiko`
460--
461CREATE TABLE `leaderboard_taiko` (
462 `position` int(10) UNSIGNED NOT NULL,
463 `user` int(11) NOT NULL,
464 `v` bigint(20) NOT NULL
465) ENGINE=InnoDB DEFAULT CHARSET=utf8;
466-- --------------------------------------------------------
467--
468-- Table structure for table `main_menu_icons`
469--
470CREATE TABLE `main_menu_icons` (
471 `id` int(11) NOT NULL,
472 `is_current` int(11) NOT NULL,
473 `file_id` varchar(128) NOT NULL,
474 `name` varchar(256) NOT NULL,
475 `url` text CHARACTER SET utf8 NOT NULL
476) ENGINE=InnoDB DEFAULT CHARSET=latin1;
477--
478-- Dumping data for table `main_menu_icons`
479--
480INSERT INTO `main_menu_icons` (`id`, `is_current`, `file_id`, `name`, `url`) VALUES
481(1, 0, 'logo', 'osu!thailand', 'https://aspire-world.pw/'),
482(2, 1, 'logo-halloween', 'osu!thailand halloween', 'https://aspire-world.pw/');
483-- --------------------------------------------------------
484--
485-- Table structure for table `osin_access`
486--
487CREATE TABLE `osin_access` (
488 `scope` int(11) NOT NULL DEFAULT '0',
489 `created_at` int(11) NOT NULL DEFAULT '0',
490 `client` int(11) NOT NULL DEFAULT '0',
491 `extra` int(11) NOT NULL DEFAULT '0'
492) ENGINE=InnoDB DEFAULT CHARSET=utf8;
493-- --------------------------------------------------------
494--
495-- Table structure for table `osin_client`
496--
497CREATE TABLE `osin_client` (
498 `id` int(11) NOT NULL,
499 `secret` varchar(64) CHARACTER SET latin1 NOT NULL DEFAULT '',
500 `extra` varchar(127) CHARACTER SET latin1 NOT NULL DEFAULT '',
501 `redirect_uri` varchar(127) CHARACTER SET latin1 NOT NULL DEFAULT ''
502) ENGINE=InnoDB DEFAULT CHARSET=utf8;
503-- --------------------------------------------------------
504--
505-- Table structure for table `osin_client_user`
506--
507CREATE TABLE `osin_client_user` (
508 `client_id` int(11) NOT NULL DEFAULT '0',
509 `user` int(11) NOT NULL DEFAULT '0'
510) ENGINE=InnoDB DEFAULT CHARSET=utf8;
511-- --------------------------------------------------------
512--
513-- Table structure for table `password_recovery`
514--
515CREATE TABLE `password_recovery` (
516 `id` int(11) NOT NULL,
517 `k` varchar(80) CHARACTER SET latin1 NOT NULL,
518 `u` varchar(30) CHARACTER SET latin1 NOT NULL,
519 `t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
520) ENGINE=MyISAM DEFAULT CHARSET=utf8;
521-- --------------------------------------------------------
522--
523-- Table structure for table `privileges_groups`
524--
525CREATE TABLE `privileges_groups` (
526 `id` int(11) NOT NULL,
527 `name` varchar(32) CHARACTER SET latin1 NOT NULL,
528 `privileges` int(11) NOT NULL,
529 `color` varchar(32) CHARACTER SET latin1 NOT NULL
530) ENGINE=InnoDB DEFAULT CHARSET=utf8;
531--
532-- Dumping data for table `privileges_groups`
533--
534INSERT INTO `privileges_groups` (`id`, `name`, `privileges`, `color`) VALUES
535(1, 'Banned', 0, ''),
536(2, 'BAT', 267, ''),
537(3, 'Chat Moderators', 2883911, 'success'),
538(4, 'Admin', 1048575, 'danger'),
539(5, 'Developer', 1043995, 'info'),
540(6, 'Donor', 7, 'warning'),
541(7, 'God', 1048575, 'info'),
542(8, 'Normal User', 3, 'primary'),
543(9, 'Pending', 1048579, 'default'),
544(10, 'Restricted', 2, ''),
545(11, 'Beatmap Nominator', 267, 'primary');
546-- --------------------------------------------------------
547--
548-- Table structure for table `profile_backgrounds`
549--
550CREATE TABLE `profile_backgrounds` (
551 `uid` int(11) NOT NULL,
552 `time` int(11) NOT NULL,
553 `type` int(11) NOT NULL,
554 `value` text CHARACTER SET latin1 NOT NULL
555) ENGINE=InnoDB DEFAULT CHARSET=utf8;
556-- --------------------------------------------------------
557--
558-- Table structure for table `rank_requests`
559--
560CREATE TABLE `rank_requests` (
561 `id` int(11) NOT NULL,
562 `userid` int(11) NOT NULL,
563 `bid` int(11) NOT NULL,
564 `type` varchar(8) CHARACTER SET latin1 NOT NULL,
565 `time` int(11) NOT NULL,
566 `blacklisted` tinyint(1) NOT NULL
567) ENGINE=InnoDB DEFAULT CHARSET=utf8;
568-- --------------------------------------------------------
569--
570-- Table structure for table `remember`
571--
572CREATE TABLE `remember` (
573 `id` int(11) NOT NULL,
574 `userid` int(11) NOT NULL,
575 `series_identifier` int(11) DEFAULT NULL,
576 `token_sha` varchar(255) CHARACTER SET latin1 DEFAULT NULL
577) ENGINE=InnoDB DEFAULT CHARSET=utf8;
578-- --------------------------------------------------------
579--
580-- Table structure for table `reports`
581--
582CREATE TABLE `reports` (
583 `id` int(11) NOT NULL,
584 `name` varchar(128) CHARACTER SET latin1 NOT NULL,
585 `from_username` varchar(32) CHARACTER SET latin1 NOT NULL,
586 `content` varchar(1024) CHARACTER SET latin1 NOT NULL,
587 `type` tinyint(4) NOT NULL,
588 `open_time` varchar(18) CHARACTER SET latin1 NOT NULL,
589 `update_time` varchar(18) CHARACTER SET latin1 NOT NULL,
590 `status` tinyint(4) NOT NULL,
591 `response` varchar(1024) CHARACTER SET latin1 NOT NULL
592) ENGINE=InnoDB DEFAULT CHARSET=utf8;
593-- --------------------------------------------------------
594--
595-- Table structure for table `scores`
596--
597CREATE TABLE `scores` (
598 `id` int(11) NOT NULL,
599 `beatmap_md5` varchar(32) CHARACTER SET latin1 NOT NULL DEFAULT '',
600 `userid` int(11) NOT NULL,
601 `score` bigint(20) DEFAULT NULL,
602 `max_combo` int(11) NOT NULL DEFAULT '0',
603 `full_combo` tinyint(1) NOT NULL DEFAULT '0',
604 `mods` int(11) NOT NULL DEFAULT '0',
605 `300_count` int(11) NOT NULL DEFAULT '0',
606 `100_count` int(11) NOT NULL DEFAULT '0',
607 `50_count` int(11) NOT NULL DEFAULT '0',
608 `katus_count` int(11) NOT NULL DEFAULT '0',
609 `gekis_count` int(11) NOT NULL DEFAULT '0',
610 `misses_count` int(11) NOT NULL DEFAULT '0',
611 `time` varchar(18) CHARACTER SET latin1 NOT NULL DEFAULT '',
612 `play_mode` tinyint(4) NOT NULL DEFAULT '0',
613 `completed` tinyint(11) NOT NULL DEFAULT '0',
614 `accuracy` float(15,12) DEFAULT NULL,
615 `pp` float DEFAULT '0'
616) ENGINE=InnoDB DEFAULT CHARSET=utf8;
617-- --------------------------------------------------------
618--
619-- Table structure for table `system_settings`
620--
621CREATE TABLE `system_settings` (
622 `id` int(11) NOT NULL,
623 `name` varchar(32) CHARACTER SET latin1 NOT NULL,
624 `value_int` int(11) NOT NULL DEFAULT '0',
625 `value_string` varchar(512) CHARACTER SET latin1 NOT NULL
626) ENGINE=InnoDB DEFAULT CHARSET=utf8;
627--
628-- Dumping data for table `system_settings`
629--
630INSERT INTO `system_settings` (`id`, `name`, `value_int`, `value_string`) VALUES
631(1, 'website_maintenance', 0, ''),
632(2, 'game_maintenance', 0, ''),
633(3, 'website_global_alert', 0, '<center>Welcome to Ripple Clone! Setup by Aoba!
634<br><a href="https://new.bigtu.vip/">You can play Ainu! here</a></center>'),
635(4, 'website_home_alert', 0, 'Welcome to Ripple clone'),
636(5, 'registrations_enabled', 1, ''),
637(6, 'aql_threshold_std', 0, '1333.77'),
638(7, 'aql_threshold_taiko', 0, '1333.77'),
639(8, 'aql_threshold_ctb', 0, '1333.77'),
640(9, 'aql_threshold_mania', 0, '1333.77');
641-- --------------------------------------------------------
642--
643-- Table structure for table `tokens`
644--
645CREATE TABLE `tokens` (
646 `id` int(11) NOT NULL,
647 `user` varchar(31) CHARACTER SET latin1 NOT NULL,
648 `privileges` int(11) NOT NULL,
649 `description` varchar(255) CHARACTER SET latin1 NOT NULL,
650 `token` varchar(127) CHARACTER SET latin1 NOT NULL,
651 `private` tinyint(4) NOT NULL,
652 `last_updated` int(11) NOT NULL DEFAULT '0'
653) ENGINE=InnoDB DEFAULT CHARSET=utf8;
654-- --------------------------------------------------------
655--
656-- Table structure for table `users`
657--
658CREATE TABLE `users` (
659 `id` int(15) NOT NULL,
660 `username` varchar(30) CHARACTER SET latin1 NOT NULL,
661 `username_safe` varchar(30) CHARACTER SET latin1 NOT NULL,
662 `notes` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
663 `ban_datetime` varchar(30) DEFAULT NULL,
664 `password_md5` varchar(127) CHARACTER SET latin1 NOT NULL,
665 `salt` varchar(32) CHARACTER SET latin1 NOT NULL,
666 `email` varchar(254) CHARACTER SET latin1 NOT NULL,
667 `register_datetime` int(10) NOT NULL,
668 `rank` tinyint(1) NOT NULL DEFAULT '1',
669 `allowed` tinyint(1) NOT NULL DEFAULT '1',
670 `latest_activity` int(10) NOT NULL DEFAULT '0',
671 `silence_end` int(11) NOT NULL DEFAULT '0',
672 `silence_reason` varchar(127) CHARACTER SET latin1 NOT NULL DEFAULT '',
673 `password_version` tinyint(4) NOT NULL DEFAULT '1',
674 `privileges` int(11) NOT NULL,
675 `donor_expire` int(11) NOT NULL DEFAULT '0',
676 `flags` int(11) NOT NULL DEFAULT '0',
677 `achievements_version` int(11) NOT NULL DEFAULT '4'
678) ENGINE=InnoDB DEFAULT CHARSET=utf8;
679--
680-- Dumping data for table `users`
681--
682INSERT INTO `users` (`id`, `username`, `username_safe`, `notes`, `ban_datetime`, `password_md5`, `salt`, `email`, `register_datetime`, `rank`, `allowed`, `latest_activity`, `silence_end`, `silence_reason`, `password_version`, `privileges`, `donor_expire`, `flags`, `achievements_version`) VALUES
683(999, 'FokaBot', 'fokabot', '', NULL, '*0', '', 'fo@kab.ot', 0, 4, 1, 0, 0, '', 1, 3145727, 0, 0, 0);
684-- --------------------------------------------------------
685--
686-- Table structure for table `users_achievements`
687--
688CREATE TABLE `users_achievements` (
689 `id` int(11) NOT NULL,
690 `user_id` int(11) NOT NULL,
691 `achievement_id` int(11) NOT NULL,
692 `time` int(11) NOT NULL
693) ENGINE=InnoDB DEFAULT CHARSET=latin1;
694-- --------------------------------------------------------
695--
696-- Table structure for table `users_relationships`
697--
698CREATE TABLE `users_relationships` (
699 `id` int(11) NOT NULL,
700 `user1` int(11) NOT NULL,
701 `user2` int(11) NOT NULL
702) ENGINE=InnoDB DEFAULT CHARSET=utf8;
703-- --------------------------------------------------------
704--
705-- Table structure for table `users_stats`
706--
707CREATE TABLE `users_stats` (
708 `id` int(11) NOT NULL,
709 `username` varchar(30) CHARACTER SET latin1 NOT NULL,
710 `username_aka` varchar(32) CHARACTER SET latin1 NOT NULL DEFAULT '',
711 `user_color` varchar(16) CHARACTER SET latin1 NOT NULL DEFAULT 'black',
712 `user_style` varchar(128) CHARACTER SET latin1 NOT NULL DEFAULT '',
713 `ranked_score_std` bigint(20) DEFAULT NULL,
714 `playcount_std` int(11) NOT NULL DEFAULT '0',
715 `total_score_std` bigint(20) DEFAULT NULL,
716 `replays_watched_std` int(11) UNSIGNED NOT NULL DEFAULT '0',
717 `ranked_score_taiko` bigint(20) DEFAULT NULL,
718 `playcount_taiko` int(11) NOT NULL DEFAULT '0',
719 `total_score_taiko` bigint(20) DEFAULT NULL,
720 `replays_watched_taiko` int(11) NOT NULL DEFAULT '0',
721 `ranked_score_ctb` bigint(20) DEFAULT NULL,
722 `playcount_ctb` int(11) NOT NULL DEFAULT '0',
723 `total_score_ctb` bigint(20) DEFAULT NULL,
724 `replays_watched_ctb` int(11) NOT NULL DEFAULT '0',
725 `ranked_score_mania` bigint(20) DEFAULT NULL,
726 `playcount_mania` int(11) NOT NULL DEFAULT '0',
727 `total_score_mania` bigint(20) DEFAULT NULL,
728 `replays_watched_mania` int(10) UNSIGNED NOT NULL DEFAULT '0',
729 `total_hits_std` int(11) NOT NULL DEFAULT '0',
730 `total_hits_taiko` int(11) NOT NULL DEFAULT '0',
731 `total_hits_ctb` int(11) NOT NULL DEFAULT '0',
732 `total_hits_mania` int(11) NOT NULL DEFAULT '0',
733 `country` char(2) CHARACTER SET latin1 NOT NULL DEFAULT 'XX',
734 `show_country` tinyint(4) NOT NULL DEFAULT '1',
735 `level_std` int(11) NOT NULL DEFAULT '1',
736 `level_taiko` int(11) NOT NULL DEFAULT '1',
737 `level_ctb` int(11) NOT NULL DEFAULT '1',
738 `level_mania` int(11) NOT NULL DEFAULT '1',
739 `playtime_std` int(11) NOT NULL DEFAULT '0',
740 `playtime_taiko` int(11) NOT NULL DEFAULT '0',
741 `playtime_ctb` int(11) NOT NULL DEFAULT '0',
742 `playtime_mania` int(11) NOT NULL DEFAULT '0',
743 `avg_accuracy_std` float(15,12) NOT NULL DEFAULT '0.000000000000',
744 `avg_accuracy_taiko` float(15,12) NOT NULL DEFAULT '0.000000000000',
745 `avg_accuracy_ctb` float(15,12) NOT NULL DEFAULT '0.000000000000',
746 `avg_accuracy_mania` float(15,12) NOT NULL DEFAULT '0.000000000000',
747 `pp_std` int(11) NOT NULL DEFAULT '0',
748 `pp_taiko` int(11) NOT NULL DEFAULT '0',
749 `pp_ctb` int(11) NOT NULL DEFAULT '0',
750 `pp_mania` int(11) NOT NULL DEFAULT '0',
751 `badges_shown` varchar(24) CHARACTER SET latin1 NOT NULL DEFAULT '1,0,0,0,0,0',
752 `safe_title` tinyint(4) NOT NULL DEFAULT '0',
753 `userpage_content` mediumtext CHARACTER SET latin1,
754 `play_style` smallint(6) NOT NULL DEFAULT '0',
755 `favourite_mode` tinyint(4) NOT NULL DEFAULT '0',
756 `custom_badge_icon` varchar(32) CHARACTER SET latin1 NOT NULL DEFAULT '',
757 `custom_badge_name` varchar(32) CHARACTER SET latin1 NOT NULL DEFAULT '',
758 `can_custom_badge` tinyint(1) NOT NULL DEFAULT '0',
759 `show_custom_badge` tinyint(1) NOT NULL DEFAULT '0'
760) ENGINE=InnoDB DEFAULT CHARSET=utf8;
761-- Create Table `users_beatmap_playcount`
762CREATE TABLE `users_beatmap_playcount` (
763 `user_id` INT(11) NOT NULL,
764 `beatmap_id` INT(11) NULL DEFAULT NULL,
765 `game_mode` INT(11) NULL DEFAULT NULL,
766 `playcount` INT(11) NULL DEFAULT NULL,
767 UNIQUE INDEX `playcount_index` (`user_id`, `beatmap_id`)
768)
769COLLATE='utf8_general_ci'
770ENGINE=InnoDB
771;
772
773-- --------------------------------------------------------
774-- Dumping structure for table ripple.rap_logs
775CREATE TABLE IF NOT EXISTS `rap_logs` (
776 `id` int(10) NOT NULL AUTO_INCREMENT,
777 `userid` int(10) NOT NULL,
778 `text` longtext NOT NULL,
779 `datetime` int(30) NOT NULL,
780 `through` text NOT NULL,
781 KEY `id` (`id`)
782) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
783-- --------------------------------------------------------
784--
785-- Dumping data for table `users_stats`
786--
787INSERT INTO `users_stats` (`id`, `username`, `username_aka`, `user_color`, `user_style`, `ranked_score_std`, `playcount_std`, `total_score_std`, `replays_watched_std`, `ranked_score_taiko`, `playcount_taiko`, `total_score_taiko`, `replays_watched_taiko`, `ranked_score_ctb`, `playcount_ctb`, `total_score_ctb`, `replays_watched_ctb`, `ranked_score_mania`, `playcount_mania`, `total_score_mania`, `replays_watched_mania`, `total_hits_std`, `total_hits_taiko`, `total_hits_ctb`, `total_hits_mania`, `country`, `show_country`, `level_std`, `level_taiko`, `level_ctb`, `level_mania`, `avg_accuracy_std`, `avg_accuracy_taiko`, `avg_accuracy_ctb`, `avg_accuracy_mania`, `pp_std`, `pp_taiko`, `pp_ctb`, `pp_mania`, `badges_shown`, `safe_title`, `userpage_content`, `play_style`, `favourite_mode`, `custom_badge_icon`, `custom_badge_name`, `can_custom_badge`, `show_custom_badge`) VALUES
788(999, 'FokaBot', '', 'black', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'KP', 1, 0, 0, 0, 0, 0.000000000000, 0.000000000000, 0.000000000000, 0.000000000000, 0, 0, 0, 0, '3,4,11,0,0,0', 0, '', 0, 0, '', '', 0, 0);
789-- --------------------------------------------------------
790--
791-- Table structure for table `user_badges`
792--
793CREATE TABLE `user_badges` (
794 `user` int(11) NOT NULL,
795 `badge` int(11) NOT NULL
796) ENGINE=InnoDB DEFAULT CHARSET=utf8;
797--
798-- Indexes for dumped tables
799--
800--
801-- Indexes for table `2fa`
802--
803ALTER TABLE `2fa`
804 ADD PRIMARY KEY (`userid`);
805--
806-- Indexes for table `2fa_telegram`
807--
808ALTER TABLE `2fa_telegram`
809 ADD PRIMARY KEY (`id`);
810--
811-- Indexes for table `2fa_totp`
812--
813ALTER TABLE `2fa_totp`
814 ADD PRIMARY KEY (`userid`);
815--
816-- Indexes for table `achievements`
817--
818ALTER TABLE `achievements`
819 ADD PRIMARY KEY (`id`);
820--
821-- Indexes for table `badges`
822--
823ALTER TABLE `badges`
824 ADD PRIMARY KEY (`id`);
825--
826-- Indexes for table `bancho_channels`
827--
828ALTER TABLE `bancho_channels`
829 ADD PRIMARY KEY (`id`);
830--
831-- Indexes for table `bancho_messages`
832--
833ALTER TABLE `bancho_messages`
834 ADD PRIMARY KEY (`id`);
835--
836-- Indexes for table `bancho_private_messages`
837--
838ALTER TABLE `bancho_private_messages`
839 ADD PRIMARY KEY (`id`);
840--
841-- Indexes for table `bancho_settings`
842--
843ALTER TABLE `bancho_settings`
844 ADD PRIMARY KEY (`id`);
845--
846-- Indexes for table `bancho_tokens`
847--
848ALTER TABLE `bancho_tokens`
849 ADD PRIMARY KEY (`id`);
850--
851-- Indexes for table `beatmaps`
852--
853ALTER TABLE `beatmaps`
854 ADD PRIMARY KEY (`id`);
855--
856-- Indexes for table `beatmaps_names`
857--
858ALTER TABLE `beatmaps_names`
859 ADD PRIMARY KEY (`id`);
860--
861-- Indexes for table `beatmaps_rating`
862--
863ALTER TABLE `beatmaps_rating`
864 ADD PRIMARY KEY (`id`);
865--
866-- Indexes for table `comments`
867--
868ALTER TABLE `comments`
869 ADD PRIMARY KEY (`id`);
870--
871-- Indexes for table `discord_roles`
872--
873ALTER TABLE `discord_roles`
874 ADD PRIMARY KEY (`id`);
875--
876-- Indexes for table `docs`
877--
878ALTER TABLE `docs`
879 ADD PRIMARY KEY (`id`);
880--
881-- Indexes for table `hw_user`
882--
883ALTER TABLE `hw_user`
884 ADD PRIMARY KEY (`id`),
885 ADD UNIQUE KEY `userid` (`userid`);
886--
887-- Indexes for table `identity_tokens`
888--
889ALTER TABLE `identity_tokens`
890 ADD UNIQUE KEY `userid` (`userid`);
891--
892-- Indexes for table `ip_user`
893--
894ALTER TABLE `ip_user`
895 ADD PRIMARY KEY (`userid`),
896 ADD UNIQUE KEY `userid` (`userid`);
897--
898-- Indexes for table `irc_tokens`
899--
900ALTER TABLE `irc_tokens`
901 ADD UNIQUE KEY `userid` (`userid`);
902--
903-- Indexes for table `leaderboard_ctb`
904--
905ALTER TABLE `leaderboard_ctb`
906 ADD PRIMARY KEY (`position`);
907--
908-- Indexes for table `leaderboard_mania`
909--
910ALTER TABLE `leaderboard_mania`
911 ADD PRIMARY KEY (`position`);
912--
913-- Indexes for table `leaderboard_std`
914--
915ALTER TABLE `leaderboard_std`
916 ADD PRIMARY KEY (`position`);
917--
918-- Indexes for table `leaderboard_taiko`
919--
920ALTER TABLE `leaderboard_taiko`
921 ADD PRIMARY KEY (`position`);
922--
923-- Indexes for table `main_menu_icons`
924--
925ALTER TABLE `main_menu_icons`
926 ADD PRIMARY KEY (`id`);
927--
928-- Indexes for table `osin_client`
929--
930ALTER TABLE `osin_client`
931 ADD PRIMARY KEY (`id`);
932--
933-- Indexes for table `password_recovery`
934--
935ALTER TABLE `password_recovery`
936 ADD PRIMARY KEY (`id`);
937--
938-- Indexes for table `privileges_groups`
939--
940ALTER TABLE `privileges_groups`
941 ADD PRIMARY KEY (`id`),
942 ADD UNIQUE KEY `name` (`name`);
943--
944-- Indexes for table `profile_backgrounds`
945--
946ALTER TABLE `profile_backgrounds`
947 ADD PRIMARY KEY (`uid`);
948--
949-- Indexes for table `rank_requests`
950--
951ALTER TABLE `rank_requests`
952 ADD PRIMARY KEY (`id`),
953 ADD UNIQUE KEY `bid` (`bid`);
954--
955-- Indexes for table `remember`
956--
957ALTER TABLE `remember`
958 ADD PRIMARY KEY (`id`);
959--
960-- Indexes for table `reports`
961--
962ALTER TABLE `reports`
963 ADD PRIMARY KEY (`id`);
964--
965-- Indexes for table `scores`
966--
967ALTER TABLE `scores`
968 ADD PRIMARY KEY (`id`);
969--
970-- Indexes for table `system_settings`
971--
972ALTER TABLE `system_settings`
973 ADD PRIMARY KEY (`id`);
974--
975-- Indexes for table `tokens`
976--
977ALTER TABLE `tokens`
978 ADD PRIMARY KEY (`id`);
979--
980-- Indexes for table `users`
981--
982ALTER TABLE `users`
983 ADD PRIMARY KEY (`id`);
984--
985-- Indexes for table `users_achievements`
986--
987ALTER TABLE `users_achievements`
988 ADD PRIMARY KEY (`id`);
989--
990-- Indexes for table `users_relationships`
991--
992ALTER TABLE `users_relationships`
993 ADD PRIMARY KEY (`id`);
994--
995-- Indexes for table `users_stats`
996--
997ALTER TABLE `users_stats`
998 ADD PRIMARY KEY (`id`);
999--
1000-- AUTO_INCREMENT for dumped tables
1001--
1002--
1003-- AUTO_INCREMENT for table `2fa_telegram`
1004--
1005ALTER TABLE `2fa_telegram`
1006 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
1007--
1008-- AUTO_INCREMENT for table `badges`
1009--
1010ALTER TABLE `badges`
1011 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33;
1012--
1013-- AUTO_INCREMENT for table `bancho_channels`
1014--
1015ALTER TABLE `bancho_channels`
1016 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
1017--
1018-- AUTO_INCREMENT for table `bancho_messages`
1019--
1020ALTER TABLE `bancho_messages`
1021 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
1022--
1023-- AUTO_INCREMENT for table `bancho_private_messages`
1024--
1025ALTER TABLE `bancho_private_messages`
1026 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
1027--
1028-- AUTO_INCREMENT for table `bancho_settings`
1029--
1030ALTER TABLE `bancho_settings`
1031 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
1032--
1033-- AUTO_INCREMENT for table `bancho_tokens`
1034--
1035ALTER TABLE `bancho_tokens`
1036 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
1037--
1038-- AUTO_INCREMENT for table `beatmaps`
1039--
1040ALTER TABLE `beatmaps`
1041 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
1042--
1043-- AUTO_INCREMENT for table `beatmaps_names`
1044--
1045ALTER TABLE `beatmaps_names`
1046 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
1047--
1048-- AUTO_INCREMENT for table `beatmaps_rating`
1049--
1050ALTER TABLE `beatmaps_rating`
1051 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
1052--
1053-- AUTO_INCREMENT for table `comments`
1054--
1055ALTER TABLE `comments`
1056 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
1057--
1058-- AUTO_INCREMENT for table `discord_roles`
1059--
1060ALTER TABLE `discord_roles`
1061 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
1062--
1063-- AUTO_INCREMENT for table `docs`
1064--
1065ALTER TABLE `docs`
1066 MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
1067--
1068-- AUTO_INCREMENT for table `hw_user`
1069--
1070ALTER TABLE `hw_user`
1071 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
1072--
1073-- AUTO_INCREMENT for table `main_menu_icons`
1074--
1075ALTER TABLE `main_menu_icons`
1076 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
1077--
1078-- AUTO_INCREMENT for table `osin_client`
1079--
1080ALTER TABLE `osin_client`
1081 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
1082--
1083-- AUTO_INCREMENT for table `password_recovery`
1084--
1085ALTER TABLE `password_recovery`
1086 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
1087--
1088-- AUTO_INCREMENT for table `privileges_groups`
1089--
1090ALTER TABLE `privileges_groups`
1091 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
1092--
1093-- AUTO_INCREMENT for table `rank_requests`
1094--
1095ALTER TABLE `rank_requests`
1096 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
1097--
1098-- AUTO_INCREMENT for table `remember`
1099--
1100ALTER TABLE `remember`
1101 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
1102--
1103-- AUTO_INCREMENT for table `reports`
1104--
1105ALTER TABLE `reports`
1106 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
1107--
1108-- AUTO_INCREMENT for table `scores`
1109--
1110ALTER TABLE `scores`
1111 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
1112--
1113-- AUTO_INCREMENT for table `system_settings`
1114--
1115ALTER TABLE `system_settings`
1116 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
1117--
1118-- AUTO_INCREMENT for table `tokens`
1119--
1120ALTER TABLE `tokens`
1121 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
1122--
1123-- AUTO_INCREMENT for table `users`
1124--
1125ALTER TABLE `users`
1126 MODIFY `id` int(15) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1000;
1127--
1128-- AUTO_INCREMENT for table `users_achievements`
1129--
1130ALTER TABLE `users_achievements`
1131 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
1132--
1133-- AUTO_INCREMENT for table `users_relationships`
1134--
1135ALTER TABLE `users_relationships`
1136 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
1137--
1138-- AUTO_INCREMENT for table `users_stats`
1139--
1140ALTER TABLE `users_stats`
1141 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1000;
1142/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1143/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1144/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;