SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

CREATE DATABASE `raffle` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `raffle`;

CREATE TABLE IF NOT EXISTS `alert_text` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `msg` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ;

CREATE TABLE IF NOT EXISTS `bots` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `steamID` varchar(64) NOT NULL,
  `steamName` varchar(255) NOT NULL,
  `isRunning` bit(1) NOT NULL,
  `isFree` bit(1) NOT NULL,
  `steamCommID` bigint(20) NOT NULL,
  `tradeLink` text NOT NULL,
  `myLastRound` int(11) NOT NULL,
  `type` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `steamName` (`steamName`),
  UNIQUE KEY `steamCommID` (`steamCommID`),
  KEY `myLastRound` (`myLastRound`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

CREATE TABLE IF NOT EXISTS `bots_running` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pid` bigint(20) NOT NULL,
  `timeStart` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `currency` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(10) NOT NULL,
  `sym` varchar(20) NOT NULL,
  `pos` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `code` (`code`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

CREATE TABLE IF NOT EXISTS `items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(225) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `name_id` varchar(225) NOT NULL,
  `statrack` int(1) NOT NULL DEFAULT '0',
  `img_url` text NOT NULL,
  `tier` varchar(20) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name_id` (`name_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=24573 ;

CREATE TABLE IF NOT EXISTS `items_prices` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_name_id` varchar(225) NOT NULL,
  `currency_id` int(225) NOT NULL,
  `price` float(100,2) NOT NULL,
  `admin` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_index` (`item_name_id`,`currency_id`,`admin`),
  KEY `item_name_id` (`item_name_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=39028 ;

CREATE TABLE IF NOT EXISTS `queue` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `trade_offer_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `botID` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `round` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `roundhash` varchar(225) NOT NULL,
  `winner` int(11) NOT NULL DEFAULT '0',
  `winTime` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=900 ;

CREATE TABLE IF NOT EXISTS `round_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `round_id` int(225) NOT NULL,
  `user_id` int(225) NOT NULL,
  `item_id` int(225) NOT NULL,
  `returned` int(1) NOT NULL DEFAULT '0',
  `botID` bigint(40) NOT NULL,
  `botInventoryID` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `round_id` (`round_id`,`user_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=19558 ;

CREATE TABLE IF NOT EXISTS `round_logs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `prices` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `win_prices` text NOT NULL,
  `round_id` int(11) NOT NULL,
  `steamNICK` varchar(225) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `user_steam_url` text NOT NULL,
  `user_profile_photo` text NOT NULL,
  `log_type` int(1) NOT NULL DEFAULT '0',
  `item_number` int(11) NOT NULL,
  `win_items` int(11) NOT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `round_id` (`round_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3311 ;

CREATE TABLE IF NOT EXISTS `trade_offers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `bot_id` int(11) NOT NULL,
  `stat` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `trade_offers_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `trade_offer_id` int(11) NOT NULL,
  `nameId` varchar(225) NOT NULL,
  `inventorId` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `trade_offer_id` (`trade_offer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `user_alerts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `msg` text NOT NULL,
  `type` int(11) NOT NULL,
  `vienkartinis` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `type` (`type`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13485 ;

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(225) NOT NULL AUTO_INCREMENT,
  `logTime` bigint(20) NOT NULL,
  `steamID` varchar(225) NOT NULL,
  `steamNICK` varchar(225) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `SteamURL` text NOT NULL,
  `SmallAvatar` text NOT NULL,
  `MediumAvatar` text NOT NULL,
  `LargeAvatar` text NOT NULL,
  `currency_id` int(5) NOT NULL DEFAULT '1',
  `tradeLink` text NOT NULL,
  `tradeToken` varchar(225) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `steamID` (`steamID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7175 ;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;