265 lines
8.9 KiB
SQL
265 lines
8.9 KiB
SQL
-- --------------------------------------------------------
|
|
-- Host: 127.0.0.1
|
|
-- Server version: 10.11.3-MariaDB-1:10.11.3+maria~deb11 - mariadb.org binary distribution
|
|
-- Server OS: debian-linux-gnu
|
|
-- HeidiSQL Version: 12.5.0.6677
|
|
-- --------------------------------------------------------
|
|
|
|
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
|
|
/*!40101 SET NAMES utf8 */;
|
|
/*!50503 SET NAMES utf8mb4 */;
|
|
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
|
|
/*!40103 SET TIME_ZONE='+00:00' */;
|
|
/*!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' */;
|
|
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
|
|
|
|
-- Dumping structure for table accounts.flashii_apikeys
|
|
CREATE TABLE IF NOT EXISTS `flashii_apikeys` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`admin` int(11) NOT NULL,
|
|
`apikey` varchar(32) NOT NULL,
|
|
`level` int(11) NOT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
|
|
|
|
-- Data exporting was unselected.
|
|
|
|
-- Dumping structure for table accounts.flashii_bans
|
|
CREATE TABLE IF NOT EXISTS `flashii_bans` (
|
|
`id` bigint(64) NOT NULL AUTO_INCREMENT,
|
|
`uid` bigint(64) NOT NULL,
|
|
`ip` varchar(255) NOT NULL,
|
|
`type` int(1) NOT NULL,
|
|
`perma` int(1) NOT NULL,
|
|
`bannedtill` int(64) NOT NULL,
|
|
`timestamp` int(64) NOT NULL,
|
|
`mid` bigint(255) NOT NULL,
|
|
`mip` varchar(255) NOT NULL,
|
|
`reason` varchar(255) DEFAULT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin;
|
|
|
|
-- Data exporting was unselected.
|
|
|
|
-- Dumping structure for table accounts.flashii_chat_banned_users
|
|
CREATE TABLE IF NOT EXISTS `flashii_chat_banned_users` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`ip` varchar(50) DEFAULT NULL,
|
|
`uid` int(11) DEFAULT NULL,
|
|
`username` varchar(256) DEFAULT NULL,
|
|
`expiration` bigint(20) NOT NULL DEFAULT -1,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
|
|
|
|
-- Data exporting was unselected.
|
|
|
|
-- Dumping structure for table accounts.flashii_chat_channels
|
|
CREATE TABLE IF NOT EXISTS `flashii_chat_channels` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`chname` varchar(256) NOT NULL,
|
|
`pwd` varchar(512) DEFAULT NULL,
|
|
`priv` int(11) DEFAULT 0,
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `name` (`chname`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
|
|
|
|
-- Data exporting was unselected.
|
|
|
|
-- Dumping structure for table accounts.flashii_chat_logs
|
|
CREATE TABLE IF NOT EXISTS `flashii_chat_logs` (
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
`epoch` int(11) DEFAULT NULL,
|
|
`userid` int(11) NOT NULL,
|
|
`username` varchar(256) NOT NULL,
|
|
`color` varchar(24) NOT NULL,
|
|
`channel` varchar(1024) NOT NULL,
|
|
`chrank` int(11) NOT NULL,
|
|
`message` longtext NOT NULL,
|
|
`flags` varchar(10) NOT NULL DEFAULT '10010',
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
|
|
|
|
-- Data exporting was unselected.
|
|
|
|
-- Dumping structure for table accounts.flashii_chat_online_users
|
|
CREATE TABLE IF NOT EXISTS `flashii_chat_online_users` (
|
|
`userid` int(11) NOT NULL,
|
|
`username` varchar(256) NOT NULL,
|
|
`color` varchar(16) NOT NULL,
|
|
`perms` varchar(512) NOT NULL,
|
|
UNIQUE KEY `userid` (`userid`,`username`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
|
|
|
|
-- Data exporting was unselected.
|
|
|
|
-- Dumping structure for table accounts.flashii_groups
|
|
CREATE TABLE IF NOT EXISTS `flashii_groups` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`gid` int(11) NOT NULL,
|
|
`name` text NOT NULL,
|
|
`mname` text NOT NULL,
|
|
`style` text NOT NULL,
|
|
`colour` varchar(9) NOT NULL,
|
|
`descr` text NOT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
|
|
|
|
-- Data exporting was unselected.
|
|
|
|
-- Dumping structure for table accounts.flashii_legacy_feedback
|
|
CREATE TABLE IF NOT EXISTS `flashii_legacy_feedback` (
|
|
`id` int(12) NOT NULL AUTO_INCREMENT,
|
|
`title` text NOT NULL,
|
|
`name` text NOT NULL,
|
|
`trip` text NOT NULL,
|
|
`email` text NOT NULL,
|
|
`uid` int(12) NOT NULL,
|
|
`date` text NOT NULL,
|
|
`content` text NOT NULL,
|
|
`password` text NOT NULL,
|
|
`ip` text NOT NULL,
|
|
`op` int(1) NOT NULL,
|
|
`tid` int(12) NOT NULL,
|
|
`locked` int(1) NOT NULL,
|
|
`ban` int(1) NOT NULL,
|
|
`del` int(1) NOT NULL,
|
|
`type` int(12) NOT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
|
|
|
|
-- Data exporting was unselected.
|
|
|
|
-- Dumping structure for table accounts.flashii_manage_sessions
|
|
CREATE TABLE IF NOT EXISTS `flashii_manage_sessions` (
|
|
`sid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`uid` int(11) NOT NULL,
|
|
`ip` text NOT NULL,
|
|
`uagent` text NOT NULL,
|
|
`time` int(11) NOT NULL,
|
|
`skey` text NOT NULL,
|
|
PRIMARY KEY (`sid`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
|
|
|
|
-- Data exporting was unselected.
|
|
|
|
-- Dumping structure for table accounts.flashii_messages
|
|
CREATE TABLE IF NOT EXISTS `flashii_messages` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`fromUser` int(11) NOT NULL,
|
|
`toUsers` text NOT NULL,
|
|
`readBy` text NOT NULL,
|
|
`deletedBy` text NOT NULL,
|
|
`date` int(11) NOT NULL,
|
|
`title` text NOT NULL,
|
|
`content` text NOT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
|
|
|
|
-- Data exporting was unselected.
|
|
|
|
-- Dumping structure for table accounts.flashii_news
|
|
CREATE TABLE IF NOT EXISTS `flashii_news` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`ip` text NOT NULL,
|
|
`uid` text NOT NULL,
|
|
`date` text NOT NULL,
|
|
`title` text NOT NULL,
|
|
`content` text NOT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
|
|
|
|
-- Data exporting was unselected.
|
|
|
|
-- Dumping structure for table accounts.flashii_regcodes
|
|
CREATE TABLE IF NOT EXISTS `flashii_regcodes` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`code` varchar(32) NOT NULL,
|
|
`uid` int(11) NOT NULL,
|
|
`used` int(11) NOT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
|
|
|
|
-- Data exporting was unselected.
|
|
|
|
-- Dumping structure for table accounts.flashii_sessions
|
|
CREATE TABLE IF NOT EXISTS `flashii_sessions` (
|
|
`sid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`uid` int(11) NOT NULL,
|
|
`ip` text NOT NULL,
|
|
`uagent` text NOT NULL,
|
|
`time` int(11) NOT NULL,
|
|
`skey` text NOT NULL,
|
|
PRIMARY KEY (`sid`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
|
|
|
|
-- Data exporting was unselected.
|
|
|
|
-- Dumping structure for table accounts.flashii_tenshi
|
|
CREATE TABLE IF NOT EXISTS `flashii_tenshi` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`uid` int(11) NOT NULL,
|
|
`start` int(11) NOT NULL,
|
|
`length` int(11) NOT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
|
|
|
|
-- Data exporting was unselected.
|
|
|
|
-- Dumping structure for table accounts.flashii_users
|
|
CREATE TABLE IF NOT EXISTS `flashii_users` (
|
|
`id` int(5) NOT NULL AUTO_INCREMENT,
|
|
`userrole` int(5) NOT NULL,
|
|
`groups` text NOT NULL,
|
|
`username` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
|
|
`username_clean` text NOT NULL,
|
|
`password` tinytext DEFAULT NULL,
|
|
`email` text NOT NULL,
|
|
`register_ip` text NOT NULL,
|
|
`last_ip` text NOT NULL,
|
|
`usertitle` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
|
|
`profilemarkdown` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
|
|
`avatar_url` text NOT NULL,
|
|
`profilebg` text NOT NULL,
|
|
`join_date` int(11) NOT NULL,
|
|
`last_seen` int(11) NOT NULL,
|
|
`last_namechange` int(11) NOT NULL,
|
|
`birthdate` text NOT NULL,
|
|
`website` text NOT NULL,
|
|
`steam` text NOT NULL,
|
|
`skype` text NOT NULL,
|
|
`youtube` text NOT NULL,
|
|
`youtube_type` int(11) NOT NULL,
|
|
`twitter` text NOT NULL,
|
|
`github` text NOT NULL,
|
|
`osu` text NOT NULL,
|
|
`soundcloud` text NOT NULL,
|
|
`eaorigin` text NOT NULL,
|
|
`playstation` text NOT NULL,
|
|
`xboxlive` text NOT NULL,
|
|
`gender` int(11) NOT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
|
|
|
|
-- Data exporting was unselected.
|
|
|
|
-- Dumping structure for table accounts.flashii_warnings
|
|
CREATE TABLE IF NOT EXISTS `flashii_warnings` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID for management',
|
|
`userid` int(11) NOT NULL COMMENT 'User ID of warned user',
|
|
`issuer` int(11) NOT NULL COMMENT 'User ID of Moderator that issued the warning',
|
|
`issued` int(11) NOT NULL COMMENT 'Time of warning',
|
|
`time` int(11) NOT NULL COMMENT 'Amount of time till expiration',
|
|
`reason` text NOT NULL COMMENT 'Reason for the warning',
|
|
`action` text NOT NULL COMMENT 'The action taken',
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
|
|
|
|
-- Data exporting was unselected.
|
|
|
|
/*!40103 SET TIME_ZONE=IFNULL(@OLD_TIME_ZONE, 'system') */;
|
|
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
|
|
/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
|
|
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
|
|
/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;
|