-- phpMyAdmin SQL Dump
-- version 3.2.3
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 24, 2012 at 05:40 PM
-- Server version: 5.1.40
-- PHP Version: 5.2.12

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `axclick2`
--

-- --------------------------------------------------------

--
-- Table structure for table `ban`
--

CREATE TABLE IF NOT EXISTS `ban` (
  `name` text NOT NULL,
  `cto` int(11) NOT NULL,
  `cfrom` int(11) NOT NULL,
  `message` text NOT NULL,
  `time` bigint(20) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

--
-- Dumping data for table `ban`
--


-- --------------------------------------------------------

--
-- Table structure for table `birja`
--

CREATE TABLE IF NOT EXISTS `birja` (
  `in` float(11,2) DEFAULT '0.00',
  `out` float(11,2) DEFAULT '0.00'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `birja`
--


-- --------------------------------------------------------

--
-- Table structure for table `cat`
--

CREATE TABLE IF NOT EXISTS `cat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `login` text COLLATE utf8_unicode_ci,
  `url` text COLLATE utf8_unicode_ci,
  `nameurl` text COLLATE utf8_unicode_ci,
  `opis` text COLLATE utf8_unicode_ci,
  `kateg` text COLLATE utf8_unicode_ci,
  `ts` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Dumping data for table `cat`
--


-- --------------------------------------------------------

--
-- Table structure for table `catk`
--

CREATE TABLE IF NOT EXISTS `catk` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `kateg` text COLLATE utf8_unicode_ci,
  `num` float DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Dumping data for table `catk`
--


-- --------------------------------------------------------

--
-- Table structure for table `cclub_actia`
--

CREATE TABLE IF NOT EXISTS `cclub_actia` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `text` text,
  `ts` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `cclub_actia`
--


-- --------------------------------------------------------

--
-- Table structure for table `cclub_akomm`
--

CREATE TABLE IF NOT EXISTS `cclub_akomm` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `log` text NOT NULL,
  `text` text NOT NULL,
  `ts` int(15) NOT NULL DEFAULT '0',
  `k` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `cclub_akomm`
--


-- --------------------------------------------------------

--
-- Table structure for table `cclub_auction`
--

CREATE TABLE IF NOT EXISTS `cclub_auction` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` text NOT NULL,
  `kol` int(11) NOT NULL,
  `bank` int(11) NOT NULL,
  `time` int(11) NOT NULL,
  `login` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `cclub_auction`
--


-- --------------------------------------------------------

--
-- Table structure for table `cclub_clicks`
--

CREATE TABLE IF NOT EXISTS `cclub_clicks` (
  `who` text CHARACTER SET latin1,
  `to` text CHARACTER SET latin1,
  `ts` bigint(20) DEFAULT NULL,
  `id` int(11) NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

--
-- Dumping data for table `cclub_clicks`
--


-- --------------------------------------------------------

--
-- Table structure for table `cclub_guest`
--

CREATE TABLE IF NOT EXISTS `cclub_guest` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `who` text,
  `text` text,
  `answer` text,
  `ts` bigint(20) DEFAULT NULL,
  `ua` text,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `cclub_guest`
--


-- --------------------------------------------------------

--
-- Table structure for table `cclub_komm`
--

CREATE TABLE IF NOT EXISTS `cclub_komm` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `log` text NOT NULL,
  `text` text NOT NULL,
  `ts` int(15) NOT NULL DEFAULT '0',
  `k` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `cclub_komm`
--


-- --------------------------------------------------------

--
-- Table structure for table `cclub_kredlog`
--

CREATE TABLE IF NOT EXISTS `cclub_kredlog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `who` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `where` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `kred` int(11) NOT NULL,
  `data` datetime NOT NULL,
  `koment` text COLLATE utf8_unicode_ci NOT NULL,
  `dat` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Dumping data for table `cclub_kredlog`
--


-- --------------------------------------------------------

--
-- Table structure for table `cclub_news`
--

CREATE TABLE IF NOT EXISTS `cclub_news` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `text` text CHARACTER SET cp1251,
  `ts` bigint(20) DEFAULT NULL,
  `tema` text CHARACTER SET utf8,
  `glav` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `cclub_news`
--


-- --------------------------------------------------------

--
-- Table structure for table `cclub_nomera`
--

CREATE TABLE IF NOT EXISTS `cclub_nomera` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nomer` text,
  `znak` text,
  `cena` text,
  `login` text,
  `pass` text NOT NULL,
  `stats` tinyint(4) DEFAULT '1',
  `whopay` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `cclub_nomera`
--


-- --------------------------------------------------------

--
-- Table structure for table `cclub_online`
--

CREATE TABLE IF NOT EXISTS `cclub_online` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ip` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `uniq` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `time` bigint(20) NOT NULL,
  `br` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `adm` tinyint(3) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uniq` (`uniq`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Dumping data for table `cclub_online`
--

INSERT INTO `cclub_online` (`id`, `user`, `ip`, `uniq`, `time`, `br`, `adm`) VALUES
(1, 'System', '127.0.0.1', '10df659ae7a41aa7180b4c3f0b01c957a947a2b4', 1345815602, 'Opera', 0);

-- --------------------------------------------------------

--
-- Table structure for table `cclub_otziv`
--

CREATE TABLE IF NOT EXISTS `cclub_otziv` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_login` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `ts` bigint(20) NOT NULL,
  `text` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `tip` bigint(20) NOT NULL,
  `login` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `cclub_otziv`
--


-- --------------------------------------------------------

--
-- Table structure for table `cclub_proclick`
--

CREATE TABLE IF NOT EXISTS `cclub_proclick` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `who` text NOT NULL,
  `time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `cclub_proclick`
--


-- --------------------------------------------------------

--
-- Table structure for table `cclub_s_auction`
--

CREATE TABLE IF NOT EXISTS `cclub_s_auction` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` text NOT NULL,
  `bank` int(11) NOT NULL,
  `data` text NOT NULL,
  `user_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `cclub_s_auction`
--


-- --------------------------------------------------------

--
-- Table structure for table `cclub_userrekl`
--

CREATE TABLE IF NOT EXISTS `cclub_userrekl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `login` text CHARACTER SET utf8 NOT NULL,
  `silka` text CHARACTER SET utf8 NOT NULL,
  `text` text CHARACTER SET utf8 NOT NULL,
  `time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `cclub_userrekl`
--


-- --------------------------------------------------------

--
-- Table structure for table `cclub_users`
--

CREATE TABLE IF NOT EXISTS `cclub_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `login` text,
  `password` text,
  `mail` text,
  `icq` int(9) DEFAULT NULL,
  `name` varchar(30) NOT NULL,
  `pol` int(1) NOT NULL,
  `gorod` varchar(40) NOT NULL,
  `info` text NOT NULL,
  `proklik` tinytext,
  `ts` bigint(20) DEFAULT NULL,
  `cto` bigint(20) DEFAULT NULL,
  `cfrom` float DEFAULT NULL,
  `ip` text,
  `ua` text,
  `ets` bigint(20) DEFAULT '0',
  `admin` tinyint(4) DEFAULT '0',
  `moder` tinyint(4) NOT NULL DEFAULT '0',
  `typeclick` int(11) DEFAULT '0',
  `pid` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `bank` float NOT NULL DEFAULT '0',
  `numlink` varchar(10) NOT NULL DEFAULT '100',
  `avtoban` varchar(50) NOT NULL,
  `mesto` text NOT NULL,
  `anti` int(11) NOT NULL,
  `anti_time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `cclub_users`
--

INSERT INTO `cclub_users` (`id`, `login`, `password`, `mail`, `icq`, `name`, `pol`, `gorod`, `info`, `proklik`, `ts`, `cto`, `cfrom`, `ip`, `ua`, `ets`, `admin`, `moder`, `typeclick`, `pid`, `bank`, `numlink`, `avtoban`, `mesto`, `anti`, `anti_time`) VALUES
(2, 'System', '5b2d71ab77c42b20f3a3f19de02e283f98c6aab5', '', 0, ' ', 0, ' ', ' ', '1278677974', 1265619936, 53, 53, '80.254.110.117', 'Opera', 1278679903, 0, 0, 0, '', 95, '100', '', ' ', 0, 0),
(1, 'admin', '5b2d71ab77c42b20f3a3f19de02e283f98c6aab5', 'RAINUR48@yandex.ru', 3355805, '', 1, ' :)', ',  :)', '1298461152', 1277913547, 23734, 30533, '80.239.243.25', 'Opera', 1294908941, 1, 0, 0, 'actek', 559.5, '300', '', ' ', 28, 1298461152);

-- --------------------------------------------------------

--
-- Table structure for table `cclub_zadanie`
--

CREATE TABLE IF NOT EXISTS `cclub_zadanie` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `login` text CHARACTER SET utf8 NOT NULL,
  `name` text CHARACTER SET utf8 NOT NULL,
  `text` text CHARACTER SET utf8 NOT NULL,
  `bank` int(11) NOT NULL,
  `bank_isp` int(11) NOT NULL,
  `time_on` int(11) NOT NULL,
  `time_off` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `kol_user` int(11) NOT NULL,
  `kol_user_isp` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `cclub_zadanie`
--


-- --------------------------------------------------------

--
-- Table structure for table `cclub_zmsg`
--

CREATE TABLE IF NOT EXISTS `cclub_zmsg` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_zadanie` text NOT NULL,
  `login` text,
  `text` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `date` text,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `cclub_zmsg`
--


-- --------------------------------------------------------

--
-- Table structure for table `cclub_zperevod`
--

CREATE TABLE IF NOT EXISTS `cclub_zperevod` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_zadanie` int(11) NOT NULL,
  `login` text NOT NULL,
  `time` int(11) NOT NULL,
  `komm` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `cclub_zperevod`
--


-- --------------------------------------------------------

--
-- Table structure for table `chislo`
--

CREATE TABLE IF NOT EXISTS `chislo` (
  `chislo` int(11) NOT NULL AUTO_INCREMENT,
  `caption` text NOT NULL,
  PRIMARY KEY (`chislo`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `chislo`
--


-- --------------------------------------------------------

--
-- Table structure for table `clikus`
--

CREATE TABLE IF NOT EXISTS `clikus` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `login` text NOT NULL,
  `pass` text NOT NULL,
  `time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `clikus`
--


-- --------------------------------------------------------

--
-- Table structure for table `forum`
--

CREATE TABLE IF NOT EXISTS `forum` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `refid` int(11) NOT NULL,
  `type` char(1) NOT NULL,
  `time` int(11) NOT NULL,
  `avtor` varchar(25) NOT NULL,
  `priority` int(1) NOT NULL,
  `text` text NOT NULL,
  `close` int(1) NOT NULL,
  `vip` int(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `forum`
--


-- --------------------------------------------------------

--
-- Table structure for table `history`
--

CREATE TABLE IF NOT EXISTS `history` (
  `login` varchar(50) NOT NULL DEFAULT '',
  `type` int(1) NOT NULL DEFAULT '0',
  `credit` int(11) NOT NULL DEFAULT '0',
  `summa` float(11,2) NOT NULL DEFAULT '0.00',
  `time` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `history`
--


-- --------------------------------------------------------

--
-- Table structure for table `kol`
--

CREATE TABLE IF NOT EXISTS `kol` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `data` date NOT NULL,
  `kol` int(11) DEFAULT '0',
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `kol`
--


-- --------------------------------------------------------

--
-- Table structure for table `lib`
--

CREATE TABLE IF NOT EXISTS `lib` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `text` text NOT NULL,
  `id_kat` int(11) NOT NULL,
  `data` int(11) NOT NULL,
  `avtor` text NOT NULL,
  `dobavil` text NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `lib`
--


-- --------------------------------------------------------

--
-- Table structure for table `lib_kat`
--

CREATE TABLE IF NOT EXISTS `lib_kat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `kat` text NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `lib_kat`
--


-- --------------------------------------------------------

--
-- Table structure for table `lib_kom`
--

CREATE TABLE IF NOT EXISTS `lib_kom` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nick` text NOT NULL,
  `text` text NOT NULL,
  `id_lib` int(11) NOT NULL,
  `pl_mi` int(11) NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `lib_kom`
--


-- --------------------------------------------------------

--
-- Table structure for table `lib_stat`
--

CREATE TABLE IF NOT EXISTS `lib_stat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `text` text NOT NULL,
  `avtor` text NOT NULL,
  `dobavil` text NOT NULL,
  `date` text NOT NULL,
  `id_kat` int(11) NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `lib_stat`
--


-- --------------------------------------------------------

--
-- Table structure for table `link`
--

CREATE TABLE IF NOT EXISTS `link` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `url` text NOT NULL,
  `color` varchar(10) DEFAULT NULL,
  `bb` tinyint(4) DEFAULT NULL,
  `pow` int(11) NOT NULL,
  `data` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `link`
--


-- --------------------------------------------------------

--
-- Table structure for table `links`
--

CREATE TABLE IF NOT EXISTS `links` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` tinytext,
  `url` tinytext,
  `nick` tinytext,
  `in_nick` tinytext,
  `c_type` tinyint(4) DEFAULT NULL,
  `act` int(1) NOT NULL,
  `referer` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `links`
--


-- --------------------------------------------------------

--
-- Table structure for table `logs`
--

CREATE TABLE IF NOT EXISTS `logs` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `log` varchar(50) NOT NULL DEFAULT '',
  `ua` varchar(100) NOT NULL DEFAULT '',
  `refer` varchar(100) NOT NULL DEFAULT '',
  `time` varchar(20) NOT NULL DEFAULT '',
  `ip` varchar(50) NOT NULL DEFAULT '',
  `ts` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `logs`
--


-- --------------------------------------------------------

--
-- Table structure for table `mnogoak`
--

CREATE TABLE IF NOT EXISTS `mnogoak` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `login` text NOT NULL,
  `login1` text NOT NULL,
  `time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `mnogoak`
--

INSERT INTO `mnogoak` (`id`, `login`, `login1`, `time`) VALUES
(1, 'System', 'RAINUR', 1345815598);

-- --------------------------------------------------------

--
-- Table structure for table `pochta`
--

CREATE TABLE IF NOT EXISTS `pochta` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `kto` varchar(50) NOT NULL,
  `komu` varchar(50) NOT NULL,
  `time` varchar(20) NOT NULL,
  `status` varchar(10) NOT NULL DEFAULT '0',
  `tema` varchar(100) NOT NULL,
  `sms` text CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `pochta`
--


-- --------------------------------------------------------

--
-- Table structure for table `refb`
--

CREATE TABLE IF NOT EXISTS `refb` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `login` text,
  `prcen` bigint(20) DEFAULT NULL,
  `realcen` bigint(20) DEFAULT NULL,
  `ids` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `ts` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `refb`
--


-- --------------------------------------------------------

--
-- Table structure for table `stavki`
--

CREATE TABLE IF NOT EXISTS `stavki` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `kr` int(11) DEFAULT '0',
  `pr` float(11,4) DEFAULT '0.0000',
  `nick` tinytext,
  `time` tinytext,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `stavki`
--


-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nick` tinytext,
  `money` float(11,4) DEFAULT '0.0000',
  `in_money` int(11) DEFAULT '0',
  `out_money` int(11) DEFAULT '0',
  `wmr` tinytext,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `nick`, `money`, `in_money`, `out_money`, `wmr`) VALUES
(1, 'System', 0.0000, 0, 0, NULL);
