-- --------------------------------------------------------
-- Хост: 127.0.0.1
-- Server version: 5.5.53 - MySQL Community Server (GPL)
-- Server OS: Win32
-- HeidiSQL Версия: 9.3.0.4998
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 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 structure for table logs.logs_battleground
DROP TABLE IF EXISTS `logs_battleground`;
CREATE TABLE IF NOT EXISTS `logs_battleground` (
 `time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
 `bgid` int(11) DEFAULT NULL,
 `bgtype` int(11) DEFAULT NULL,
 `bgteamcount` int(11) DEFAULT NULL,
 `bgduration` int(11) DEFAULT NULL,
 `playerGuid` int(11) DEFAULT NULL,
 `team` int(11) DEFAULT NULL,
 `deaths` int(11) DEFAULT NULL,
 `honorBonus` int(11) DEFAULT NULL,
 `honorableKills` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Data exporting was unselected.


-- Dumping structure for table logs.logs_behavior
DROP TABLE IF EXISTS `logs_behavior`;
CREATE TABLE IF NOT EXISTS `logs_behavior` (
 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 `account` int(10) unsigned NOT NULL,
 `detection` varchar(255) NOT NULL,
 `data` varchar(255) NOT NULL,
 KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Data exporting was unselected.


-- Dumping structure for table logs.logs_characters
DROP TABLE IF EXISTS `logs_characters`;
CREATE TABLE IF NOT EXISTS `logs_characters` (
 `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 `type` enum('LostSocket','Create','Delete','Login','Logout','') NOT NULL DEFAULT '',
 `guid` int(11) NOT NULL DEFAULT '0',
 `account` int(11) NOT NULL DEFAULT '0',
 `name` varchar(255) NOT NULL DEFAULT '',
 `ip` varchar(255) NOT NULL DEFAULT '',
 `clientHash` varchar(255) NOT NULL DEFAULT '',
 KEY `guid` (`guid`),
 KEY `ip` (`ip`),
 KEY `clientHash` (`clientHash`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Data exporting was unselected.


-- Dumping structure for table logs.logs_chat
DROP TABLE IF EXISTS `logs_chat`;
CREATE TABLE IF NOT EXISTS `logs_chat` (
 `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 `type` enum('Say','Whisp','Group','Guild','Officer','Raid','BG','Chan','') NOT NULL DEFAULT '',
 `guid` int(11) NOT NULL DEFAULT '0',
 `target` int(11) NOT NULL DEFAULT '0',
 `channelId` int(11) NOT NULL DEFAULT '0',
 `channelName` varchar(255) NOT NULL DEFAULT '',
 `message` varchar(255) NOT NULL DEFAULT '',
 KEY `guid` (`guid`),
 KEY `target` (`target`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Data exporting was unselected.


-- Dumping structure for table logs.logs_spamdetect
DROP TABLE IF EXISTS `logs_spamdetect`;
CREATE TABLE IF NOT EXISTS `logs_spamdetect` (
 `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 `accountId` int(11) DEFAULT '0',
 `guid` int(11) NOT NULL DEFAULT '0',
 `message` varchar(255) NOT NULL DEFAULT '',
 `reason` varchar(255) NOT NULL DEFAULT '',
 KEY `guid` (`guid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Data exporting was unselected.


-- Dumping structure for table logs.logs_trade
DROP TABLE IF EXISTS `logs_trade`;
CREATE TABLE IF NOT EXISTS `logs_trade` (
 `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 `type` enum('AuctionBid','AuctionBuyout','SellItem','GM','Mail','QuestMaxLevel','Quest','Loot','Trade','') NOT NULL DEFAULT '',
 `sender` int(11) unsigned NOT NULL DEFAULT '0',
 `senderType` int(11) unsigned NOT NULL DEFAULT '0',
 `senderEntry` int(11) unsigned NOT NULL DEFAULT '0',
 `receiver` int(11) unsigned NOT NULL DEFAULT '0',
 `amount` int(11) NOT NULL DEFAULT '0',
 `data` int(11) NOT NULL DEFAULT '0',
 KEY `sender` (`sender`),
 KEY `receiver` (`receiver`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Data exporting was unselected.


-- Dumping structure for table logs.logs_transactions
DROP TABLE IF EXISTS `logs_transactions`;
CREATE TABLE IF NOT EXISTS `logs_transactions` (
 `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 `type` enum('Bid','Buyout','PlaceAuction','Trade','Mail','MailCOD') DEFAULT NULL,
 `guid1` int(11) unsigned NOT NULL DEFAULT '0',
 `money1` int(11) unsigned NOT NULL DEFAULT '0',
 `spell1` int(11) unsigned NOT NULL DEFAULT '0',
 `items1` varchar(255) NOT NULL DEFAULT '',
 `guid2` int(11) unsigned NOT NULL DEFAULT '0',
 `money2` int(11) unsigned NOT NULL DEFAULT '0',
 `spell2` int(11) unsigned NOT NULL DEFAULT '0',
 `items2` varchar(255) NOT NULL DEFAULT '',
 KEY `guid2` (`guid2`),
 KEY `guid1` (`guid1`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Data exporting was unselected.


-- Dumping structure for table logs.logs_trashcharacters
DROP TABLE IF EXISTS `logs_trashcharacters`;
CREATE TABLE IF NOT EXISTS `logs_trashcharacters` (
 `guid` int(10) unsigned NOT NULL,
 `data` varchar(255) NOT NULL,
 `cluster` tinyint(3) unsigned NOT NULL DEFAULT '0',
 PRIMARY KEY (`guid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Data exporting was unselected.


-- Dumping structure for table logs.migrations
DROP TABLE IF EXISTS `migrations`;
CREATE TABLE IF NOT EXISTS `migrations` (
 `id` varchar(255) NOT NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Data exporting was unselected.


-- Dumping structure for table logs.smartlog_creature
DROP TABLE IF EXISTS `smartlog_creature`;
CREATE TABLE IF NOT EXISTS `smartlog_creature` (
 `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 `type` enum('Death','LongCombat','ScriptInfo','') NOT NULL DEFAULT '',
 `entry` int(11) NOT NULL DEFAULT '0',
 `guid` int(11) NOT NULL DEFAULT '0',
 `specifier` varchar(255) NOT NULL DEFAULT '',
 `combatTime` int(11) NOT NULL DEFAULT '0',
 `content` varchar(255) NOT NULL DEFAULT '',
 KEY `entry` (`entry`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Data exporting was unselected.
/*!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 */;