
CREATE TABLE IF NOT EXISTS `autopay` (
  `payid` int(11) NOT NULL auto_increment,
  `hz` varchar(150) NOT NULL,
  KEY `payid` (`payid`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=20584 ;



CREATE TABLE IF NOT EXISTS `bannedUsers` (
  `id` int(12) NOT NULL auto_increment,
  `name` varchar(60) NOT NULL,
  `why` varchar(200) NOT NULL,
  `link` varchar(200) NOT NULL,
  `ip` varchar(60) NOT NULL,
  `date` varchar(20) default NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=99 ;



CREATE TABLE IF NOT EXISTS `chat` (
  `name` varchar(200) NOT NULL,
  `message` varchar(200) NOT NULL,
  `id` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;



CREATE TABLE IF NOT EXISTS `chat_banned` (
  `id` int(15) NOT NULL auto_increment,
  `user` varchar(150) NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=25 ;



CREATE TABLE IF NOT EXISTS `convertSponsr` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(20) NOT NULL,
  `linktoBanner` varchar(200) NOT NULL,
  `urlFrombanner` varchar(200) NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=15 ;



CREATE TABLE IF NOT EXISTS `kasoi_chat` (
  `id` int(50) NOT NULL auto_increment,
  `userName` varchar(60) NOT NULL,
  `message` varchar(120) NOT NULL,
  `date` varchar(60) NOT NULL,
  `system` varchar(150) NOT NULL default '0',
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=22372 ;


CREATE TABLE IF NOT EXISTS `kasoi_sovet` (
  `id` int(11) NOT NULL auto_increment,
  `sovet` varchar(400) default NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=4 ;


CREATE TABLE IF NOT EXISTS `Merchant` (
  `chto` varchar(200) NOT NULL,
  `cena` varchar(200) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

--
--    `Merchant`
--

INSERT INTO `Merchant` (`chto`, `cena`) VALUES
('reklama_surf_wmz', '0.03'),
('min_zakaz_reklami', '5'),
('adsBannersMin', '5'),
('adsBannersRefPrice', '0.0015'),
('adsBannersPrice', '0.04');



CREATE TABLE IF NOT EXISTS `merchantBalance` (
  `id` int(15) NOT NULL auto_increment,
  `user` varchar(60) NOT NULL,
  `amount` varchar(150) NOT NULL,
  `date` varchar(150) NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=2225 ;


CREATE TABLE IF NOT EXISTS `news` (
  `id` int(11) NOT NULL auto_increment,
  `date` date default NULL,
  `message` varchar(150) NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=22 ;

--
--    `news`
--

INSERT INTO `news` (`id`, `date`, `message`) VALUES
(1, '2009-02-27', '  !!!    ');

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

--
--   `online`
--

CREATE TABLE IF NOT EXISTS `online` (
  `id` int(10) NOT NULL auto_increment,
  `ip` varchar(20) NOT NULL default '0',
  `unix` varchar(60) NOT NULL default '',
  `username` varchar(150) NOT NULL default '0',
  `admin` int(1) NOT NULL default '0',
  `page` varchar(150) NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1178454 ;



CREATE TABLE IF NOT EXISTS `optimize_bots` (
  `description` varchar(300) NOT NULL,
  `keywords` varchar(300) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

--
--    `optimize_bots`
--

INSERT INTO `optimize_bots` (`description`, `keywords`) VALUES
('', 'bux,');



CREATE TABLE IF NOT EXISTS `paidComment` (
  `id` int(10) NOT NULL auto_increment,
  `name` varchar(60) NOT NULL,
  `message` varchar(150) NOT NULL,
  `moderated` int(1) NOT NULL default '0',
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=4 ;



CREATE TABLE IF NOT EXISTS `platnBanners` (
  `id` int(100) NOT NULL auto_increment,
  `img` varchar(200) NOT NULL,
  `link` varchar(200) NOT NULL,
  `name` varchar(200) NOT NULL,
  `date` varchar(200) NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=2 ;


CREATE TABLE IF NOT EXISTS `platnRekl` (
  `id` int(11) NOT NULL auto_increment,
  `date` varchar(10) NOT NULL,
  `userName` varchar(60) NOT NULL,
  `userMessage` varchar(70) NOT NULL,
  `userLink` varchar(150) NOT NULL,
  `highlight` int(1) NOT NULL default '0',
  `redir` int(1) default '0',
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=475 ;



INSERT INTO `platnRekl` (`id`, `date`, `userName`, `userMessage`, `userLink`, `highlight`, `redir`) VALUES
(306, '20.02.2009', 'admin', ' BuX  ', 'http://avtowmr.ru', 0, 1);


CREATE TABLE IF NOT EXISTS `regmonitor` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(150) NOT NULL,
  `registered` varchar(150) NOT NULL,
  `referrer` varchar(300) NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=4790 ;



--
--   `ReklBannedUsers`
--

CREATE TABLE IF NOT EXISTS `ReklBannedUsers` (
  `id` int(11) NOT NULL auto_increment,
  `date` varchar(60) NOT NULL,
  `username` varchar(60) NOT NULL,
  `comment` varchar(150) NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
--    `ReklBannedUsers`
--


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

--
--   `tb_ads`
--

CREATE TABLE IF NOT EXISTS `tb_ads` (
  `id` int(11) NOT NULL auto_increment,
  `user` varchar(150) NOT NULL,
  `ip` varchar(15) NOT NULL,
  `tipo` varchar(150) NOT NULL,
  `visitime` varchar(150) NOT NULL,
  `ident` int(11) default NULL,
  `fechainicia` varchar(150) NOT NULL,
  `paypalname` varchar(150) NOT NULL,
  `paypalemail` varchar(150) NOT NULL,
  `plan` varchar(150) NOT NULL,
  `bold` varchar(150) NOT NULL,
  `highlight` varchar(150) NOT NULL,
  `url` varchar(150) NOT NULL,
  `description` varchar(150) NOT NULL,
  `category` varchar(150) NOT NULL,
  `members` varchar(150) NOT NULL default '0',
  `outside` varchar(150) NOT NULL default '0',
  `total` varchar(150) NOT NULL default '0',
  `idprovr` varchar(1) NOT NULL default '0',
  `use_http_ref` int(10) NOT NULL default '0',
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=179251 ;


CREATE TABLE IF NOT EXISTS `tb_ads_categories` (
  `id` int(11) NOT NULL,
  `catname` varchar(50) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;



INSERT INTO `tb_ads_categories` (`id`, `catname`) VALUES
(1, '  V.I.P  '),
(2, ' '),
(3, ' AvtoWMR.ru');

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

--
--   `tb_advertisers`
--

CREATE TABLE IF NOT EXISTS `tb_advertisers` (
  `id` int(11) NOT NULL auto_increment,
  `pname` varchar(150) NOT NULL,
  `pemail` varchar(150) NOT NULL,
  `plan` varchar(150) NOT NULL,
  `url` varchar(150) NOT NULL,
  `description` varchar(150) NOT NULL,
  `category` varchar(150) NOT NULL,
  `ip` varchar(15) NOT NULL,
  `bold` varchar(150) NOT NULL,
  `highlight` varchar(150) NOT NULL,
  `tipo` varchar(150) NOT NULL,
  `money` varchar(150) NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=134 ;

--
--    `tb_advertisers`
--


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

--
--   `tb_buyref`
--

CREATE TABLE IF NOT EXISTS `tb_buyref` (
  `id` int(11) NOT NULL auto_increment,
  `item` varchar(150) NOT NULL,
  `price` varchar(150) NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=114 ;

--
--    `tb_buyref`
--

INSERT INTO `tb_buyref` (`id`, `item`, `price`) VALUES
(111, 'refPrice', '6'),
(112, 'visitPrice', '0.05'),
(113, 'reklPrice', '0.7');

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

--
--   `tb_clickpack`
--

CREATE TABLE IF NOT EXISTS `tb_clickpack` (
  `id` int(11) NOT NULL,
  `item` varchar(150) NOT NULL,
  `howmany` varchar(150) NOT NULL,
  `price` varchar(150) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

--
--    `tb_clickpack`
--

INSERT INTO `tb_clickpack` (`id`, `item`, `howmany`, `price`) VALUES
(1, 'hits', '1000', '1');

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

--
--   `tb_config`
--

CREATE TABLE IF NOT EXISTS `tb_config` (
  `id` int(11) NOT NULL auto_increment,
  `item` varchar(15) NOT NULL,
  `howmany` varchar(15) NOT NULL,
  `price` varchar(150) NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=40 ;

--
--    `tb_config`
--

INSERT INTO `tb_config` (`id`, `item`, `howmany`, `price`) VALUES
(1, 'click', '1', '0.015'),
(1, 'referalclick', '1', '0.005'),
(1, 'premiumclick', '1', '2.0'),
(1, 'premiumreferalc', '1', '1.0'),
(20, 'timerPrice', '1', '10'),
(24, 'shagUpgrclick', '1', '0.005'),
(1, 'payment', '1', '0.01'),
(1, 'upgrade', '1', '3000'),
(23, 'RefClickUpgrade', '1', '26'),
(22, 'perClickUpgrade', '1', '22'),
(21, 'timerPerUpdate', '1', '3'),
(1, 'click', '1', '0.015'),
(1, 'referalclick', '1', '0.005'),
(1, 'premiumclick', '1', '2.0'),
(1, 'premiumreferalc', '1', '1.0'),
(19, 'timer', '1', '20'),
(1, 'payment', '1', '0.01'),
(1, 'upgrade', '1', '3000'),
(34, 'chatPrice', '1', '0000'),
(33, 'surfRefBonus', '1', '0.0005'),
(32, 'paidComentBonus', '1', '1'),
(31, 'PaidComment', '1', '8'),
(30, 'refBonusPrem', '1', '20'),
(29, 'refbonus', '1', '10'),
(28, 'maxLeveltimer', '1', '5'),
(27, 'maxLevelReclick', '1', '8'),
(26, 'maxLevelclick', '1', '5'),
(25, 'shagUpgrReClick', '1', '0.005'),
(1, 'wmrkoshel', '1', 'R177663760673'),
(1, 'wmykoshel', '1', 'Y219189123160'),
(1, 'wmzkoshel', '1', 'R326818046577'),
(1, 'wmbkoshel', '1', 'B245093525686'),
(1, 'icqnumber', '1', '2081840'),
(1, 'adminmail', '1', 'avtowmr@mail.ru'),
(1, 'boldwmz', '1', '2'),
(1, 'boldwmr', '1', '0.5'),
(1, 'boldwmb', '1', '10'),
(1, 'boldwmy', '1', '7'),
(1, 'wmzhigh', '1', '0.1'),
(1, 'wmrhigh', '1', '0.5'),
(1, 'wmbhigh', '1', '10'),
(1, 'wmyhigh', '1', '7'),
(1, 'upgradewmz', '1', '1.2'),
(1, 'upgradewmr', '1', '31.91'),
(1, 'upgradewmb', '1', '3000'),
(1, 'upgradewmy', '1', '2143'),
(1, 'premiumpayment', '1', '300'),
(7, 'planReklCena', '1', '0.01'),
(8, 'platnReklKolvo', '1', '3'),
(9, 'platnRekllight', '1', '0.02'),
(10, 'platnReklRedir', '1', '0.05'),
(11, 'paidCommentB', '1', '55'),
(12, 'paidCommentZ', '1', '55'),
(13, 'paidCommentR', '1', '55'),
(14, 'paidCommentY', '1', '55'),
(15, 'bannerz', '1', '15'),
(16, 'bannerr', '1', '1'),
(17, 'bannerb', '1', '77'),
(18, 'bannery', '1', '77'),
(36, 'finsetref', '1', '4'),
(35, 'finset', '1', '6'),
(37, 'chatUpgrade', '1', '2.1'),
(38, 'useredir', '1', '0.5'),
(39, 'hide_httpref', '1', '0.5');

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

--
--   `tb_contact`
--

CREATE TABLE IF NOT EXISTS `tb_contact` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(150) NOT NULL,
  `email` varchar(150) NOT NULL,
  `topic` varchar(150) NOT NULL,
  `subject` varchar(150) NOT NULL,
  `comments` varchar(200) NOT NULL,
  `ip` varchar(15) NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=146 ;

--
--    `tb_contact`
--


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

--
--   `tb_history`
--

CREATE TABLE IF NOT EXISTS `tb_history` (
  `id` int(11) NOT NULL auto_increment,
  `user` varchar(150) NOT NULL,
  `date` varchar(150) NOT NULL,
  `amount` varchar(150) default NULL,
  `method` varchar(150) NOT NULL,
  `status` varchar(150) NOT NULL,
  `comment` varchar(200) NOT NULL,
  `type` varchar(50) NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=21958 ;




CREATE TABLE IF NOT EXISTS `tb_lottery` (
  `id` int(15) NOT NULL auto_increment,
  `name` varchar(60) NOT NULL,
  `postavil` varchar(60) NOT NULL,
  `viigral` varchar(60) NOT NULL,
  `data` varchar(20) NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=13621 ;




CREATE TABLE IF NOT EXISTS `tb_messenger` (
  `id` int(11) NOT NULL auto_increment,
  `sendfrom` varchar(11) NOT NULL,
  `sendto` varchar(11) NOT NULL,
  `date` varchar(35) NOT NULL,
  `comments` varchar(150) NOT NULL,
  `status` varchar(11) NOT NULL default 'unread',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=29 ;




CREATE TABLE IF NOT EXISTS `tb_payme` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(150) NOT NULL,
  `pasword` varchar(150) NOT NULL,
  `email` varchar(150) NOT NULL,
  `pemail` varchar(150) NOT NULL,
  `country` varchar(150) NOT NULL,
  `money` varchar(150) NOT NULL,
  `ip` varchar(15) NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1076 ;


CREATE TABLE IF NOT EXISTS `tb_refset` (
  `id` int(11) NOT NULL,
  `howmany` int(5) NOT NULL,
  `price` varchar(5) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

--
--    `tb_refset`
--

INSERT INTO `tb_refset` (`id`, `howmany`, `price`) VALUES
(2, 2, '590'),
(3, 4, '800'),
(1, 1, '350'),
(4, 8, '1850'),
(5, 16, '3500');

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

--
--   `tb_site`
--

CREATE TABLE IF NOT EXISTS `tb_site` (
  `id` varchar(11) NOT NULL,
  `sitename` varchar(30) NOT NULL,
  `sitepp` varchar(30) NOT NULL,
  `slogan` varchar(200) NOT NULL,
  `offline` int(11) NOT NULL default '0',
  `offlineMessage` varchar(300) default NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

--
--    `tb_site`
--

INSERT INTO `tb_site` (`id`, `sitename`, `sitepp`, `slogan`, `offline`, `offlineMessage`) VALUES
('1', 'Av5R', '3572', '5!', 0, '');

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

--
--   `tb_upgrade`
--

CREATE TABLE IF NOT EXISTS `tb_upgrade` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(150) NOT NULL,
  `pemail` varchar(150) NOT NULL,
  `email` varchar(150) NOT NULL,
  `status` varchar(150) NOT NULL,
  `date` varchar(150) NOT NULL,
  `end` varchar(150) NOT NULL,
  `ip` varchar(15) NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=49 ;

--
--    `tb_upgrade`
--


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

--
--   `tb_users`
--

CREATE TABLE IF NOT EXISTS `tb_users` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(15) NOT NULL,
  `password` varchar(100) NOT NULL,
  `ip` varchar(15) NOT NULL,
  `email` varchar(150) NOT NULL,
  `pemail` varchar(150) default '0',
  `referer` varchar(15) NOT NULL,
  `country` varchar(150) default '0',
  `visits` int(150) default '0',
  `referals` varchar(150) default '0',
  `referalvisits` int(150) default '0',
  `money` varchar(150) default '0',
  `paid` varchar(150) default '0',
  `joindate` varchar(150) NOT NULL,
  `lastlogdate` varchar(150) default '!',
  `lastiplog` varchar(150) NOT NULL,
  `account` varchar(150) NOT NULL,
  `user_status` varchar(15) NOT NULL default 'user',
  `popolneno` varchar(200) NOT NULL default '0',
  `nareklamy` varchar(150) default '0',
  `clickLevel` int(15) NOT NULL default '0',
  `refClickLevel` int(15) NOT NULL default '0',
  `timerLevel` int(15) NOT NULL default '0',
  `birthDay` varchar(20) NOT NULL default '0',
  `fio` varchar(150) NOT NULL default '0',
  `icq` int(30) NOT NULL default '0',
  `sex` varchar(30) NOT NULL default '0',
  `chatMessages` int(255) default '0',
  `chatMoney` varchar(200) default '0',
  `finset` int(11) NOT NULL default '0',
  `paySound` int(11) NOT NULL default '1',
  `accountStyle` int(11) NOT NULL default '1',
  `chatname` int(11) NOT NULL default '0',
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=3364 ;

--
--    `tb_users`
--

INSERT INTO `tb_users` (`id`, `username`, `password`, `ip`, `email`, `pemail`, `referer`, `country`, `visits`, `referals`, `referalvisits`, `money`, `paid`, `joindate`, `lastlogdate`, `lastiplog`, `account`, `user_status`, `popolneno`, `nareklamy`, `clickLevel`, `refClickLevel`, `timerLevel`, `birthDay`, `fio`, `icq`, `sex`, `chatMessages`, `chatMoney`, `finset`, `paySound`, `accountStyle`, `chatname`) VALUES
(1, 'admin', 'admin', '11', 'au1l.ru', 'R91464', '', '', 7, '3', 39, '0.36', '59.73', '20.02.2009', '28.02.2009', '949', '', 'admin', '0.09', '17', 5, 8, 3, '789789', '789879', 79, '', 0, '0', 1, 1, 1, 2);


CREATE TABLE IF NOT EXISTS `users_online` (
  `visitor` varchar(15) NOT NULL,
  `lastvisit` int(14) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

