Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- --------------------------------------------------------
- -- Host: 127.0.0.1
- -- Server version: 5.7.25 - MySQL Community Server (GPL)
- -- Server OS: Linux
- -- HeidiSQL Version: 10.1.0.5464
- -- --------------------------------------------------------
- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
- /*!40101 SET NAMES utf8 */;
- /*!50503 SET NAMES utf8mb4 */;
- /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
- /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
- -- Dumping database structure for ripple
- CREATE DATABASE IF NOT EXISTS `ripple` /*!40100 DEFAULT CHARACTER SET latin1 */;
- USE `ripple`;
- -- Dumping structure for table ripple.2fa
- CREATE TABLE IF NOT EXISTS `2fa` (
- `userid` int(11) NOT NULL,
- `token` varchar(32) DEFAULT NULL,
- `ip` int(11) NOT NULL,
- `expire` int(11) DEFAULT NULL,
- `sent` int(11) DEFAULT NULL,
- PRIMARY KEY (`userid`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- -- Dumping structure for table ripple.2fa_telegram
- CREATE TABLE IF NOT EXISTS `2fa_telegram` (
- `userid` int(11) NOT NULL,
- `id` text,
- PRIMARY KEY (`userid`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- -- Dumping structure for table ripple.2fa_totp
- CREATE TABLE IF NOT EXISTS `2fa_totp` (
- `enabled` tinyint(1) NOT NULL DEFAULT '0',
- `userid` int(11) NOT NULL,
- PRIMARY KEY (`userid`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- -- Dumping structure for table ripple.achievements
- CREATE TABLE IF NOT EXISTS `achievements` (
- `id` int(11) NOT NULL,
- `name` varchar(64) NOT NULL,
- `description` varchar(128) NOT NULL,
- `icon` varchar(32) NOT NULL,
- `version` int(11) NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- -- Dumping structure for table ripple.badges
- CREATE TABLE IF NOT EXISTS `badges` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `name` varchar(32) NOT NULL,
- `icon` varchar(32) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
- INSERT INTO `badges` (`id`, `name`, `icon`) VALUES
- (2, '', 'fa-blank');
- -- Dumping structure for table ripple.bancho_channels
- CREATE TABLE IF NOT EXISTS `bancho_channels` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `name` varchar(32) NOT NULL,
- `description` varchar(127) NOT NULL,
- `public_read` tinyint(4) NOT NULL,
- `public_write` tinyint(4) NOT NULL,
- `status` tinyint(4) NOT NULL,
- `temp` tinyint(1) NOT NULL DEFAULT '0',
- `hidden` tinyint(1) NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
- INSERT INTO `bancho_channels` (`id`, `name`, `description`, `public_read`, `public_write`, `status`, `temp`, `hidden`) VALUES
- (1, '#osu', 'Main Atoka Channel', 1, 1, 1, 0, 0),
- (2, '#announce', 'Announce Channel', 1, 0, 1, 0, 0),
- (3, '#admin', 'Admin Only Channel', 0, 0, 1, 0, 0),
- (4, '#english', 'English Community Channel', 1, 1, 1, 0, 0);
- -- Dumping structure for table ripple.bancho_messages
- CREATE TABLE IF NOT EXISTS `bancho_messages` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `msg_from_userid` int(11) NOT NULL,
- `msg_from_username` varchar(30) NOT NULL,
- `msg_to` varchar(32) NOT NULL,
- `msg` varchar(127) NOT NULL,
- `time` int(11) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- -- Dumping structure for table ripple.bancho_private_messages
- CREATE TABLE IF NOT EXISTS `bancho_private_messages` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `msg_from_userid` int(11) NOT NULL,
- `msg_from_username` varchar(30) NOT NULL,
- `msg_to` varchar(32) NOT NULL,
- `msg` varchar(127) NOT NULL,
- `time` int(11) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- -- Dumping structure for table ripple.bancho_settings
- CREATE TABLE IF NOT EXISTS `bancho_settings` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `name` varchar(32) NOT NULL,
- `value_int` int(11) NOT NULL DEFAULT '0',
- `value_string` varchar(512) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
- INSERT INTO `bancho_settings` (`id`, `name`, `value_int`, `value_string`) VALUES
- (1, 'bancho_maintenance', 0, ''),
- (2, 'free_direct', 0, ''),
- (3, 'menu_icon', 1, 'https://ripple.moe/static/logos/logo-pink.svg'),
- (4, 'login_messages', 0, ''),
- (5, 'restricted_joke', 0, ''),
- (6, 'login_notification', 0, 'Put something here'),
- (7, 'osu_versions', 0, ''),
- (8, 'osu_md5s', 0, '');
- -- Dumping structure for table ripple.bancho_tokens
- CREATE TABLE IF NOT EXISTS `bancho_tokens` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `token` varchar(16) NOT NULL,
- `osu_id` int(11) NOT NULL,
- `latest_message_id` int(11) NOT NULL,
- `latest_private_message_id` int(11) NOT NULL,
- `latest_packet_time` int(11) NOT NULL,
- `latest_heavy_packet_time` int(11) NOT NULL,
- `joined_channels` varchar(512) NOT NULL,
- `game_mode` tinyint(4) NOT NULL,
- `action` int(11) NOT NULL,
- `action_text` varchar(128) NOT NULL,
- `kicked` tinyint(4) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- -- Dumping structure for table ripple.beatmaps
- CREATE TABLE IF NOT EXISTS `beatmaps` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `beatmap_id` int(11) NOT NULL DEFAULT '0',
- `beatmapset_id` int(11) NOT NULL DEFAULT '0',
- `beatmap_md5` varchar(32) NOT NULL,
- `song_name` varchar(1024) NOT NULL DEFAULT '',
- `ar` float NOT NULL DEFAULT '0',
- `od` float NOT NULL DEFAULT '0',
- `difficulty_std` float NOT NULL DEFAULT '0',
- `difficulty_taiko` float NOT NULL DEFAULT '0',
- `difficulty_ctb` float NOT NULL DEFAULT '0',
- `difficulty_mania` float NOT NULL DEFAULT '0',
- `max_combo` int(11) NOT NULL DEFAULT '0',
- `hit_length` int(11) NOT NULL DEFAULT '0',
- `bpm` int(11) NOT NULL DEFAULT '0',
- `ranked` tinyint(4) NOT NULL DEFAULT '0',
- `latest_update` int(11) NOT NULL DEFAULT '0',
- `ranked_status_freezed` tinyint(1) NOT NULL DEFAULT '0',
- `playcount` int(11) NOT NULL DEFAULT '0',
- `passcount` int(11) NOT NULL DEFAULT '0',
- `disable_pp` int(11) DEFAULT '0',
- `pp_100` int(11) NOT NULL DEFAULT '0',
- `pp_99` int(11) NOT NULL DEFAULT '0',
- `pp_98` int(11) NOT NULL DEFAULT '0',
- `pp_95` int(11) NOT NULL DEFAULT '0',
- `allow_fl` int(11) NOT NULL DEFAULT '0',
- `rating` int(32) NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`),
- KEY `beatmapset_id` (`beatmapset_id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
- -- Dumping structure for table ripple.beatmaps_names
- CREATE TABLE IF NOT EXISTS `beatmaps_names` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `beatmap_md5` varchar(32) NOT NULL DEFAULT '',
- `beatmap_name` varchar(256) NOT NULL DEFAULT '',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- -- Dumping structure for table ripple.beatmaps_rating
- CREATE TABLE IF NOT EXISTS `beatmaps_rating` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `user_id` int(11) DEFAULT NULL,
- `rating` float DEFAULT NULL,
- `beatmap_md5` varchar(32) DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
- -- Dumping structure for table ripple.beta_keys
- CREATE TABLE IF NOT EXISTS `beta_keys` (
- `id` int(11) NOT NULL,
- `key_md5` varchar(32) NOT NULL DEFAULT '',
- `description` varchar(128) NOT NULL DEFAULT '',
- `allowed` tinyint(4) NOT NULL DEFAULT '0',
- `public` tinyint(4) NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- -- Dumping structure for table ripple.cakes
- CREATE TABLE IF NOT EXISTS `cakes` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `userid` int(11) NOT NULL,
- `score_id` int(11) NOT NULL,
- `processes` json NOT NULL,
- `detected` json NOT NULL,
- `flags` int(11) NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
- -- Dumping structure for table ripple.clans
- CREATE TABLE IF NOT EXISTS `clans` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `tag` varchar(50) NOT NULL,
- `name` varchar(32) NOT NULL,
- `description` varchar(512) NOT NULL,
- `icon` varchar(512) DEFAULT NULL,
- `mlimit` int(128) NOT NULL DEFAULT '50',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
- -- Dumping structure for table ripple.clans_invites
- CREATE TABLE IF NOT EXISTS `clans_invites` (
- `clan` int(11) DEFAULT NULL,
- `invite` varchar(100) DEFAULT NULL,
- KEY `invite` (`invite`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- -- Dumping structure for table ripple.comments
- CREATE TABLE IF NOT EXISTS `comments` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `user_id` int(11) DEFAULT NULL,
- `beatmap_id` varchar(32) DEFAULT NULL,
- `beatmapset_id` int(11) DEFAULT NULL,
- `comment` varchar(50) DEFAULT NULL,
- `who` varchar(50) DEFAULT NULL,
- `time` varchar(18) DEFAULT NULL,
- `special_format` varchar(18) DEFAULT NULL,
- `score_id` varchar(18) DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
- -- Dumping structure for table ripple.discord_roles
- CREATE TABLE IF NOT EXISTS `discord_roles` (
- `userid` varchar(25) COLLATE latin1_bin NOT NULL DEFAULT '0',
- `discordid` varchar(50) COLLATE latin1_bin NOT NULL DEFAULT '0',
- `roleid` varchar(50) COLLATE latin1_bin NOT NULL DEFAULT '0',
- `verified` varchar(50) COLLATE latin1_bin NOT NULL DEFAULT '0',
- PRIMARY KEY (`userid`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_bin;
- -- Dumping structure for table ripple.docs
- CREATE TABLE IF NOT EXISTS `docs` (
- `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
- `doc_name` varchar(255) NOT NULL DEFAULT 'New Documentation File',
- `doc_contents` mediumtext NOT NULL,
- `public` tinyint(1) unsigned NOT NULL DEFAULT '0',
- `old_name` varchar(200) DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- -- Dumping structure for table ripple.eggs
- CREATE TABLE IF NOT EXISTS `eggs` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `type` enum('hash','path','file','title') NOT NULL DEFAULT 'hash',
- `value` varchar(128) NOT NULL,
- `tag` varchar(128) NOT NULL,
- `ban` tinyint(1) NOT NULL DEFAULT '0',
- `is_regex` tinyint(1) NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- -- Dumping structure for table ripple.hw_user
- CREATE TABLE IF NOT EXISTS `hw_user` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `userid` int(11) NOT NULL,
- `ip` int(45) NOT NULL,
- `mac` varchar(32) NOT NULL,
- `unique_id` varchar(32) NOT NULL,
- `disk_id` varchar(32) NOT NULL,
- `occurencies` int(11) NOT NULL DEFAULT '0',
- `activated` tinyint(1) NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`),
- UNIQUE KEY `userid_ip` (`userid`, `ip`)
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
- -- Dumping structure for table ripple.identity_tokens
- CREATE TABLE IF NOT EXISTS `identity_tokens` (
- `userid` int(11) NOT NULL,
- `token` varchar(64) NOT NULL,
- UNIQUE KEY `userid` (`userid`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- -- Dumping structure for table ripple.ip_user
- CREATE TABLE IF NOT EXISTS `ip_user` (
- `userid` int(11) NOT NULL,
- `ip` text NOT NULL,
- `occurencies` int(11) NOT NULL,
- UNIQUE KEY `userid` (`userid`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- -- Dumping structure for table ripple.irc_tokens
- CREATE TABLE IF NOT EXISTS `irc_tokens` (
- `userid` int(11) NOT NULL DEFAULT '0',
- `token` varchar(32) NOT NULL DEFAULT '',
- PRIMARY KEY (`userid`),
- UNIQUE KEY `userid` (`userid`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- -- Dumping structure for table ripple.leaderboard_ctb
- CREATE TABLE IF NOT EXISTS `leaderboard_ctb` (
- `position` int(10) unsigned NOT NULL,
- `user` int(11) NOT NULL,
- `v` bigint(20) NOT NULL,
- PRIMARY KEY (`position`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- -- Dumping structure for table ripple.leaderboard_mania
- CREATE TABLE IF NOT EXISTS `leaderboard_mania` (
- `position` int(10) unsigned NOT NULL,
- `user` int(11) NOT NULL,
- `v` bigint(20) NOT NULL,
- PRIMARY KEY (`position`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- -- Dumping structure for table ripple.leaderboard_std
- CREATE TABLE IF NOT EXISTS `leaderboard_std` (
- `position` int(10) unsigned NOT NULL,
- `user` int(11) NOT NULL,
- `v` bigint(20) NOT NULL,
- PRIMARY KEY (`position`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- -- Dumping structure for table ripple.leaderboard_taiko
- CREATE TABLE IF NOT EXISTS `leaderboard_taiko` (
- `position` int(10) unsigned NOT NULL,
- `user` int(11) NOT NULL,
- `v` bigint(20) NOT NULL,
- PRIMARY KEY (`position`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- -- Dumping structure for table ripple.main_menu_icons
- CREATE TABLE IF NOT EXISTS `main_menu_icons` (
- `file_id` varchar(50) NOT NULL,
- `url` varchar(256) NOT NULL,
- `is_current` varchar(128) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- INSERT INTO `main_menu_icons` (`file_id`, `url`, `is_current`) VALUES
- ('logo', 'https://atoka.pw/', '1');
- -- Dumping structure for table ripple.osin_access
- CREATE TABLE IF NOT EXISTS `osin_access` (
- `scope` int(11) NOT NULL DEFAULT '0',
- `created_at` int(11) NOT NULL DEFAULT '0',
- `client` int(11) NOT NULL DEFAULT '0',
- `extra` int(11) NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- -- Dumping structure for table ripple.osin_client
- CREATE TABLE IF NOT EXISTS `osin_client` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `secret` varchar(64) NOT NULL DEFAULT '',
- `extra` varchar(127) NOT NULL DEFAULT '',
- `redirect_uri` varchar(127) NOT NULL DEFAULT '',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- -- Dumping structure for table ripple.osin_client_user
- CREATE TABLE IF NOT EXISTS `osin_client_user` (
- `client_id` int(11) NOT NULL DEFAULT '0',
- `user` int(11) NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- -- Dumping structure for table ripple.password_recovery
- CREATE TABLE IF NOT EXISTS `password_recovery` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `k` varchar(80) NOT NULL,
- `u` varchar(30) NOT NULL,
- `t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
- -- Dumping structure for table ripple.privileges_groups
- CREATE TABLE IF NOT EXISTS `privileges_groups` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `name` varchar(32) NOT NULL,
- `privileges` int(11) NOT NULL,
- `color` varchar(32) NOT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `name` (`name`)
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
- INSERT INTO `privileges_groups` (`id`, `name`, `privileges`, `color`) VALUES
- (1, 'Banned', 0, ''),
- (2, 'BAT', 271, 'warning'),
- (3, 'Moderator', 2916575, 'success'),
- (4, 'Administrator', 3063295, 'primary'),
- (5, 'Developer', 1043995, ''),
- (6, 'Donor', 7, ''),
- (7, 'God', 3145727, 'danger'),
- (8, 'Normal User', 3, ''),
- (9, 'Pending', 1048576, 'default'),
- (10, 'Restricted', 2, ''),
- (11, 'Bots', 1048575, 'info');
- -- Dumping structure for table ripple.profile_backgrounds
- CREATE TABLE IF NOT EXISTS `profile_backgrounds` (
- `uid` int(11) NOT NULL,
- `time` int(11) NOT NULL,
- `type` int(11) NOT NULL,
- `value` text NOT NULL,
- PRIMARY KEY (`uid`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- -- Dumping structure for table ripple.rank_requests
- CREATE TABLE IF NOT EXISTS `rank_requests` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `userid` int(11) NOT NULL,
- `bid` int(11) NOT NULL,
- `type` varchar(8) NOT NULL,
- `time` int(11) NOT NULL,
- `blacklisted` tinyint(1) NOT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `bid` (`bid`)
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
- -- Dumping structure for table ripple.rap_logs
- CREATE TABLE IF NOT EXISTS `rap_logs` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `userid` int(11) NOT NULL,
- `text` longtext NOT NULL,
- `datetime` int(30) NOT NULL,
- `through` text NOT NULL,
- KEY `id` (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
- -- Dumping structure for table ripple.remember
- CREATE TABLE IF NOT EXISTS `remember` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `userid` int(11) NOT NULL,
- `series_identifier` int(11) DEFAULT NULL,
- `token_sha` varchar(255) DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
- -- Dumping structure for table ripple.reports
- CREATE TABLE IF NOT EXISTS `reports` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `name` varchar(128) NOT NULL,
- `from_username` varchar(32) NOT NULL,
- `content` varchar(1024) NOT NULL,
- `type` tinyint(4) NOT NULL,
- `open_time` varchar(18) NOT NULL,
- `update_time` varchar(18) NOT NULL,
- `status` tinyint(4) NOT NULL,
- `response` varchar(1024) NOT NULL,
- PRIMARY KEY (`id`),
- KEY `id` (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- -- Dumping structure for table ripple.scores
- CREATE TABLE IF NOT EXISTS `scores` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `beatmap_md5` varchar(32) NOT NULL DEFAULT '',
- `userid` int(11) NOT NULL,
- `score` bigint(20) DEFAULT NULL,
- `max_combo` int(11) NOT NULL DEFAULT '0',
- `full_combo` tinyint(1) NOT NULL DEFAULT '0',
- `mods` int(11) NOT NULL DEFAULT '0',
- `300_count` int(11) NOT NULL DEFAULT '0',
- `100_count` int(11) NOT NULL DEFAULT '0',
- `50_count` int(11) NOT NULL DEFAULT '0',
- `katus_count` int(11) NOT NULL DEFAULT '0',
- `gekis_count` int(11) NOT NULL DEFAULT '0',
- `misses_count` int(11) NOT NULL DEFAULT '0',
- `time` varchar(18) NOT NULL DEFAULT '',
- `play_mode` tinyint(4) NOT NULL DEFAULT '0',
- `completed` tinyint(11) NOT NULL DEFAULT '0',
- `accuracy` float(15,12) DEFAULT NULL,
- `pp` float DEFAULT '0',
- `beatmaps` varchar(32) DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
- -- Dumping structure for table ripple.scores_removed
- CREATE TABLE IF NOT EXISTS `scores_removed` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `beatmap_md5` varchar(32) NOT NULL DEFAULT '',
- `userid` int(11) NOT NULL,
- `score` bigint(20) DEFAULT NULL,
- `max_combo` int(11) NOT NULL DEFAULT '0',
- `full_combo` tinyint(1) NOT NULL DEFAULT '0',
- `mods` int(11) NOT NULL DEFAULT '0',
- `300_count` int(11) NOT NULL DEFAULT '0',
- `100_count` int(11) NOT NULL DEFAULT '0',
- `50_count` int(11) NOT NULL DEFAULT '0',
- `katus_count` int(11) NOT NULL DEFAULT '0',
- `gekis_count` int(11) NOT NULL DEFAULT '0',
- `misses_count` int(11) NOT NULL DEFAULT '0',
- `time` varchar(18) NOT NULL DEFAULT '',
- `play_mode` tinyint(4) NOT NULL DEFAULT '0',
- `completed` tinyint(11) NOT NULL DEFAULT '0',
- `accuracy` float(15,12) DEFAULT NULL,
- `pp` float DEFAULT '0',
- `beatmaps` varchar(32) DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
- -- Dumping structure for table ripple.system_settings
- CREATE TABLE IF NOT EXISTS `system_settings` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `name` varchar(32) NOT NULL,
- `value_int` int(11) NOT NULL DEFAULT '0',
- `value_string` varchar(512) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
- INSERT INTO `system_settings` (`id`, `name`, `value_int`, `value_string`) VALUES
- (1, 'website_maintenance', 0, ''),
- (2, 'game_maintenance', 0, ''),
- (3, 'website_global_alert', 1, ''),
- (4, 'website_home_alert', 0, ''),
- (5, 'registrations_enabled', 1, ''),
- (6, 'ccreation_enabled', 1, ''),
- (7, 'staff_applications_enabled', 1, '');
- -- Dumping structure for table ripple.tokens
- CREATE TABLE IF NOT EXISTS `tokens` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `user` varchar(31) NOT NULL,
- `privileges` int(11) NOT NULL,
- `description` varchar(255) NOT NULL,
- `token` varchar(127) NOT NULL,
- `private` tinyint(4) NOT NULL,
- `last_updated` int(11) NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
- -- Dumping structure for table ripple.users
- CREATE TABLE IF NOT EXISTS `users` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `username` varchar(30) NOT NULL,
- `username_safe` varchar(30) NOT NULL,
- `password_md5` varchar(127) NOT NULL,
- `salt` varchar(32) NOT NULL,
- `email` varchar(254) NOT NULL,
- `register_datetime` int(10) NOT NULL,
- `rank` tinyint(1) NOT NULL DEFAULT '1',
- `allowed` tinyint(1) NOT NULL DEFAULT '1',
- `latest_activity` int(10) NOT NULL DEFAULT '0',
- `silence_end` int(11) NOT NULL DEFAULT '0',
- `silence_reason` varchar(127) NOT NULL DEFAULT '',
- `password_version` tinyint(4) NOT NULL DEFAULT '1',
- `privileges` int(11) NOT NULL,
- `donor_expire` int(11) NOT NULL DEFAULT '0',
- `flags` int(11) NOT NULL DEFAULT '0',
- `notes` text,
- `ban_datetime` text,
- `strikes` int(11) NOT NULL DEFAULT '0',
- `nwipes` int(11) NOT NULL DEFAULT '0',
- `cwipes` int(11) NOT NULL DEFAULT '0',
- `achievements_version` int(11) NOT NULL DEFAULT '6',
- `flags_reason` text,
- `aqn` int(11) DEFAULT '0',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
- -- Dumping structure for table ripple.users_achievements
- CREATE TABLE IF NOT EXISTS `users_achievements` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `user_id` int(11) NOT NULL,
- `achievement_id` int(11) NOT NULL,
- `time` int(11) NOT NULL,
- KEY `id` (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
- -- Dumping structure for table ripple.users_relationships
- CREATE TABLE IF NOT EXISTS `users_relationships` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `user1` int(11) NOT NULL,
- `user2` int(11) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
- -- Dumping structure for table ripple.users_stats
- CREATE TABLE IF NOT EXISTS `users_stats` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `username` varchar(30) NOT NULL,
- `username_aka` varchar(32) NOT NULL DEFAULT '',
- `user_color` varchar(16) NOT NULL DEFAULT 'black',
- `user_style` varchar(128) NOT NULL DEFAULT '',
- `ranked_score_std` bigint(20) NOT NULL DEFAULT '0',
- `playcount_std` int(11) NOT NULL DEFAULT '0',
- `total_score_std` bigint(20) NOT NULL DEFAULT '0',
- `replays_watched_std` int(11) unsigned NOT NULL DEFAULT '0',
- `ranked_score_taiko` bigint(20) NOT NULL DEFAULT '0',
- `playcount_taiko` int(11) NOT NULL DEFAULT '0',
- `total_score_taiko` bigint(20) NOT NULL DEFAULT '0',
- `replays_watched_taiko` int(11) NOT NULL DEFAULT '0',
- `ranked_score_ctb` bigint(20) NOT NULL DEFAULT '0',
- `playcount_ctb` int(11) NOT NULL DEFAULT '0',
- `total_score_ctb` bigint(20) NOT NULL DEFAULT '0',
- `replays_watched_ctb` int(11) NOT NULL DEFAULT '0',
- `ranked_score_mania` bigint(20) NOT NULL DEFAULT '0',
- `playcount_mania` int(11) NOT NULL DEFAULT '0',
- `total_score_mania` bigint(20) NOT NULL DEFAULT '0',
- `replays_watched_mania` int(10) unsigned NOT NULL DEFAULT '0',
- `total_hits_std` int(11) NOT NULL DEFAULT '0',
- `total_hits_taiko` int(11) NOT NULL DEFAULT '0',
- `total_hits_ctb` int(11) NOT NULL DEFAULT '0',
- `total_hits_mania` int(11) NOT NULL DEFAULT '0',
- `country` char(2) NOT NULL DEFAULT 'XX',
- `show_country` tinyint(4) NOT NULL DEFAULT '1',
- `level_std` int(11) NOT NULL DEFAULT '1',
- `level_taiko` int(11) NOT NULL DEFAULT '1',
- `level_ctb` int(11) NOT NULL DEFAULT '1',
- `level_mania` int(11) NOT NULL DEFAULT '1',
- `avg_accuracy_std` float(15,12) NOT NULL DEFAULT '0.000000000000',
- `avg_accuracy_taiko` float(15,12) NOT NULL DEFAULT '0.000000000000',
- `avg_accuracy_ctb` float(15,12) NOT NULL DEFAULT '0.000000000000',
- `avg_accuracy_mania` float(15,12) NOT NULL DEFAULT '0.000000000000',
- `pp_std` int(11) NOT NULL DEFAULT '0',
- `pp_taiko` int(11) NOT NULL DEFAULT '0',
- `pp_ctb` int(11) NOT NULL DEFAULT '0',
- `pp_mania` int(11) NOT NULL DEFAULT '0',
- `badges_shown` varchar(24) NOT NULL DEFAULT '1,0,0,0,0,0',
- `safe_title` tinyint(4) NOT NULL DEFAULT '0',
- `userpage_content` varchar(5120) DEFAULT NULL,
- `play_style` smallint(6) NOT NULL DEFAULT '0',
- `favourite_mode` tinyint(4) NOT NULL DEFAULT '0',
- `custom_badge_icon` varchar(32) NOT NULL DEFAULT '',
- `custom_badge_name` varchar(32) NOT NULL DEFAULT '',
- `can_custom_badge` tinyint(1) NOT NULL DEFAULT '0',
- `show_custom_badge` tinyint(1) NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
- -- Dumping structure for table ripple.user_badges
- CREATE TABLE IF NOT EXISTS `user_badges` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `badge` int(11) NOT NULL,
- `user` varchar(64) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
- -- Dumping structure for table ripple.user_clans
- CREATE TABLE IF NOT EXISTS `user_clans` (
- `clan` int(11) NOT NULL,
- `user` int(11) NOT NULL,
- `perms` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- -- Dumping structure for table ripple.user_wipes
- CREATE TABLE IF NOT EXISTS `user_wipes` (
- `id` int(2) NOT NULL AUTO_INCREMENT,
- `userid` int(4) NOT NULL,
- `modid` int(11) NOT NULL,
- `datetime` int(30) NOT NULL,
- `evidence` longtext NOT NULL,
- `text` longtext NOT NULL,
- KEY `id` (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
- /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
- /*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
- /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement