Last active
March 19, 2016 15:46
-
-
Save Zaffy/22f838b9d6ef1a406952 to your computer and use it in GitHub Desktop.
realmd.sql
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- ---------------------- -- | |
-- Oregon Realmd Database -- | |
-- ---------------------- -- | |
-- Please do not edit this file directly, | |
-- create and update query and place it | |
-- to the updates/ folder. | |
-- | |
-- Table structure for table `account` | |
-- | |
DROP TABLE IF EXISTS `account`; | |
CREATE TABLE `account` ( | |
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Identifier', | |
`username` varchar(32) NOT NULL, | |
`sha_pass_hash` varchar(40) NOT NULL DEFAULT '', | |
`sessionkey` longtext, | |
`v` longtext, | |
`s` longtext, | |
`email` text, | |
`joindate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, | |
`last_ip` varchar(30) NOT NULL DEFAULT '127.0.0.1', | |
`failed_logins` int(11) unsigned NOT NULL DEFAULT '0', | |
`locked` tinyint(3) unsigned NOT NULL DEFAULT '0', | |
`last_login` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', | |
`online` int(4) unsigned NOT NULL DEFAULT '0', | |
`expansion` tinyint(3) unsigned NOT NULL DEFAULT '0', | |
`mutetime` bigint(40) unsigned NOT NULL DEFAULT '0', | |
`locale` tinyint(3) unsigned NOT NULL DEFAULT '0', | |
`os` varchar(4) NOT NULL DEFAULT '', | |
PRIMARY KEY (`id`), | |
UNIQUE KEY `idx_username` (`username`) | |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Account System'; | |
-- | |
-- Dumping data for table `account` | |
-- | |
-- | |
-- Table structure for table `account_access` | |
-- | |
DROP TABLE IF EXISTS `account_access`; | |
CREATE TABLE `account_access` ( | |
`id` int(11) unsigned NOT NULL, | |
`gmlevel` tinyint(3) unsigned NOT NULL, | |
`RealmID` int(11) NOT NULL DEFAULT '-1', | |
PRIMARY KEY (`id`,`RealmID`) | |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; | |
-- | |
-- Dumping data for table `account_access` | |
-- | |
-- | |
-- Table structure for table `account_banned` | |
-- | |
DROP TABLE IF EXISTS `account_banned`; | |
CREATE TABLE `account_banned` ( | |
`id` int(11) NOT NULL DEFAULT '0' COMMENT 'Account id', | |
`bandate` bigint(40) NOT NULL DEFAULT '0', | |
`unbandate` bigint(40) NOT NULL DEFAULT '0', | |
`bannedby` varchar(50) NOT NULL, | |
`banreason` varchar(255) NOT NULL, | |
`active` tinyint(4) NOT NULL DEFAULT '1', | |
PRIMARY KEY (`id`,`bandate`) | |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Ban List'; | |
-- | |
-- Dumping data for table `account_banned` | |
-- | |
-- | |
-- Table structure for table `account_referred` | |
-- | |
DROP TABLE IF EXISTS `account_referred`; | |
CREATE TABLE `account_referred` ( | |
`id1` bigint(20) unsigned NOT NULL COMMENT 'Referring Account', | |
`id2` bigint(20) unsigned NOT NULL COMMENT 'Referred Account', | |
PRIMARY KEY (`id1`), | |
KEY `id2` (`id2`) | |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Refer-A-Friend'; | |
-- | |
-- Dumping data for table `account_referred` | |
-- | |
-- | |
-- Table structure for table `ip_banned` | |
-- | |
DROP TABLE IF EXISTS `ip_banned`; | |
CREATE TABLE `ip_banned` ( | |
`ip` varchar(32) NOT NULL DEFAULT '127.0.0.1', | |
`bandate` int(11) NOT NULL, | |
`unbandate` int(11) NOT NULL, | |
`bannedby` varchar(50) NOT NULL DEFAULT '[Console]', | |
`banreason` varchar(50) NOT NULL DEFAULT 'no reason', | |
PRIMARY KEY (`ip`) | |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Banned IPs'; | |
-- | |
-- Dumping data for table `ip_banned` | |
-- | |
-- | |
-- Table structure for table `logs` | |
-- | |
DROP TABLE IF EXISTS `logs`; | |
CREATE TABLE `logs` ( | |
`time` int(14) NOT NULL, | |
`realm` int(4) NOT NULL, | |
`type` int(4) NOT NULL, | |
`string` text | |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; | |
-- | |
-- Dumping data for table `logs` | |
-- | |
-- | |
-- Table structure for table `realmcharacters` | |
-- | |
DROP TABLE IF EXISTS `realmcharacters`; | |
CREATE TABLE `realmcharacters` ( | |
`realmid` int(11) unsigned NOT NULL DEFAULT '0', | |
`acctid` bigint(20) unsigned NOT NULL, | |
`numchars` tinyint(3) unsigned NOT NULL DEFAULT '0', | |
PRIMARY KEY (`realmid`,`acctid`), | |
KEY `acctid` (`acctid`) | |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Realm Character Tracker'; | |
-- | |
-- Dumping data for table `realmcharacters` | |
-- | |
-- | |
-- Table structure for table `realmlist` | |
-- | |
DROP TABLE IF EXISTS `realmlist`; | |
CREATE TABLE `realmlist` ( | |
`id` int(11) unsigned NOT NULL AUTO_INCREMENT, | |
`name` varchar(32) NOT NULL DEFAULT '', | |
`address` varchar(32) NOT NULL DEFAULT '127.0.0.1', | |
`port` int(11) NOT NULL DEFAULT '8085', | |
`icon` tinyint(3) unsigned NOT NULL DEFAULT '0', | |
`realmflags` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Supported masks: 0x1 (invalid, not show in realm list), 0x2 (offline, set by realmd), 0x4 (show version and build), 0x20 (new players), 0x40 (recommended)', | |
`timezone` tinyint(3) unsigned NOT NULL DEFAULT '0', | |
`allowedSecurityLevel` tinyint(3) unsigned NOT NULL DEFAULT '0', | |
`population` float unsigned NOT NULL DEFAULT '0', | |
`realmbuilds` varchar(64) NOT NULL DEFAULT '8606', | |
PRIMARY KEY (`id`), | |
UNIQUE KEY `idx_name` (`name`) | |
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='Realm System'; | |
-- | |
-- Dumping data for table `realmlist` | |
-- | |
INSERT INTO `realmlist` VALUES (1,'OregonCore','127.0.0.1',8085,1,2,1,0,0,'8606 '); | |
-- | |
-- Table structure for table `uptime` | |
-- | |
DROP TABLE IF EXISTS `uptime`; | |
CREATE TABLE `uptime` ( | |
`realmid` int(10) unsigned NOT NULL, | |
`starttime` int(10) unsigned NOT NULL DEFAULT '0', | |
`uptime` int(10) unsigned NOT NULL DEFAULT '0', | |
`maxplayers` smallint(5) unsigned NOT NULL DEFAULT '0', | |
`revision` varchar(255) NOT NULL DEFAULT 'OregonCore', | |
PRIMARY KEY (`realmid`,`starttime`) | |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Uptime system'; | |
-- | |
-- Dumping data for table `uptime` | |
-- | |
-- | |
-- Table structure for table `updates` | |
-- | |
DROP TABLE IF EXISTS `updates`; | |
CREATE TABLE `updates` | |
( | |
`update` varchar(255) not null primary key comment 'Filename of the update', | |
`applied` timestamp not null comment 'Date when the update was applied.' | |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT 'DB versioning information (Used by auto-updater)'; | |
-- Dump completed on 2016-01-07 2:24:06 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment