-- phpMyAdmin SQL Dump
-- version 3.2.3
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 25, 2015 at 10:22 PM
-- Server version: 5.1.40
-- PHP Version: 5.3.3

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `rcms`
--

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

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

CREATE TABLE IF NOT EXISTS `ban` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` bigint(20) NOT NULL,
  `why` varchar(150) NOT NULL,
  `type` varchar(5) NOT NULL,
  `user` varchar(100) NOT NULL,
  `moder` varchar(32) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=21 ;

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


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

--
-- Table structure for table `banip`
--

CREATE TABLE IF NOT EXISTS `banip` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ip` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `banip`
--


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

--
-- Table structure for table `diz`
--

CREATE TABLE IF NOT EXISTS `diz` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `path` varchar(50) NOT NULL,
  `avtor` varchar(50) NOT NULL,
  `opis` varchar(250) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `diz`
--


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

--
-- Table structure for table `d_file`
--

CREATE TABLE IF NOT EXISTS `d_file` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `kid` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `path` varchar(250) NOT NULL,
  `downed` int(11) NOT NULL,
  `reit` int(11) NOT NULL,
  `skrin` varchar(250) NOT NULL,
  `size` bigint(20) NOT NULL,
  `opis` varchar(1000) NOT NULL,
  `date` bigint(20) NOT NULL,
  `look` int(11) NOT NULL,
  `avtor` varchar(100) NOT NULL,
  `moded` varchar(3) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=107 ;

--
-- Dumping data for table `d_file`
--

INSERT INTO `d_file` (`id`, `kid`, `name`, `path`, `downed`, `reit`, `skrin`, `size`, `opis`, `date`, `look`, `avtor`, `moded`) VALUES
(93, 125, 'ava.png', 'userfile/1010456051ava.png', 2, 1, '1010456051ava.png', 8206, '', 1010456051, 12, 'admin', 'yes');

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

--
-- Table structure for table `d_kateg`
--

CREATE TABLE IF NOT EXISTS `d_kateg` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `upid` int(11) NOT NULL,
  `kname` varchar(150) NOT NULL,
  `razd` varchar(3) NOT NULL,
  `file` varchar(3) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=127 ;

--
-- Dumping data for table `d_kateg`
--

INSERT INTO `d_kateg` (`id`, `upid`, `kname`, `razd`, `file`) VALUES
(123, 0, 'Графика', 'yes', ''),
(124, 123, 'Иконки', '', ''),
(125, 124, 'Разные', '', 'yes'),
(126, 0, 'Скрипты', 'yes', '');

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

--
-- Table structure for table `d_komm`
--

CREATE TABLE IF NOT EXISTS `d_komm` (
  `komm_id` int(11) NOT NULL AUTO_INCREMENT,
  `s_id` int(11) NOT NULL,
  `komm_name` varchar(30) NOT NULL,
  `komm_msg` varchar(500) NOT NULL,
  `komm_date` bigint(20) NOT NULL,
  `ip` varchar(15) NOT NULL,
  `brows` varchar(100) NOT NULL,
  PRIMARY KEY (`komm_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=12 ;

--
-- Dumping data for table `d_komm`
--

INSERT INTO `d_komm` (`komm_id`, `s_id`, `komm_name`, `komm_msg`, `komm_date`, `ip`, `brows`) VALUES
(10, 93, 'admin', 'птми', 1010456100, '127.0.0.1', 'Opera/9.80 (Windows NT 5.1; U; ru) Presto/2.7.62 Version/11.00'),
(11, 93, 'admin', '4', 1422209705, '127.0.0.1', 'Opera/9.80 (Windows NT 5.1; U; ru) Presto/2.7.62 Version/11.00');

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

--
-- Table structure for table `f_forums`
--

CREATE TABLE IF NOT EXISTS `f_forums` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(250) NOT NULL,
  `opis` varchar(250) NOT NULL,
  `group` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=13 ;

--
-- Dumping data for table `f_forums`
--

INSERT INTO `f_forums` (`id`, `name`, `opis`, `group`) VALUES
(8, 'Скрипты', 'Всё что связано с скриптами', ''),
(9, 'WAP-мастер', 'Всё для мастера', ''),
(10, 'Общение', 'Общение на разнообразные темы', ''),
(11, 'Купля/Продажа', 'Купля/Продажа товаров', ''),
(12, 'Хакерам', 'Хак раздел', '');

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

--
-- Table structure for table `f_post`
--

CREATE TABLE IF NOT EXISTS `f_post` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tid` int(11) NOT NULL,
  `name` varchar(250) NOT NULL,
  `msg` text NOT NULL,
  `date` bigint(20) NOT NULL,
  `ip` varchar(15) NOT NULL,
  `brows` varchar(100) NOT NULL,
  `attach` varchar(32) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=2324 ;

--
-- Dumping data for table `f_post`
--

INSERT INTO `f_post` (`id`, `tid`, `name`, `msg`, `date`, `ip`, `brows`, `attach`) VALUES
(2312, 317, 'admin', 'тест 2', 1327495021, '127.0.0.1', 'Opera/9.80 (Windows NT 5.1; U; ru) Presto/2.7.62 Version/11.00', ''),
(2311, 319, 'admin', 'Тест тема', 1327494453, '127.0.0.1', 'Opera/9.80 (Windows NT 5.1; U; ru) Presto/2.7.62 Version/11.00', ''),
(2309, 317, 'admin', 'Тест тема', 1327494420, '127.0.0.1', 'Opera/9.80 (Windows NT 5.1; U; ru) Presto/2.7.62 Version/11.00', ''),
(2310, 318, 'admin', 'Тест тема', 1327494437, '127.0.0.1', 'Opera/9.80 (Windows NT 5.1; U; ru) Presto/2.7.62 Version/11.00', '');

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

--
-- Table structure for table `f_razd`
--

CREATE TABLE IF NOT EXISTS `f_razd` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fid` int(11) NOT NULL,
  `name` varchar(250) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=66 ;

--
-- Dumping data for table `f_razd`
--

INSERT INTO `f_razd` (`id`, `fid`, `name`) VALUES
(48, 8, 'Помощь по установке'),
(49, 8, 'Поиск скриптов'),
(50, 11, 'Купля'),
(51, 11, 'Продажа'),
(52, 12, 'Защита'),
(53, 12, 'Взлом'),
(54, 12, 'Разное'),
(55, 12, 'Халява'),
(56, 10, 'Общение!'),
(57, 10, 'Музыка'),
(58, 10, 'Игры'),
(59, 10, 'Флуд/Оффтоп'),
(60, 10, 'Киды/Барыги'),
(61, 9, 'Графика/Дизайн'),
(62, 9, 'PHP/MySQL/(x)HTML'),
(63, 9, 'Хостинги/Домены'),
(64, 9, 'Обучение/Вопросы'),
(65, 8, 'Скрипты');

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

--
-- Table structure for table `f_tems`
--

CREATE TABLE IF NOT EXISTS `f_tems` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rid` int(11) NOT NULL,
  `name` varchar(250) NOT NULL,
  `avtor` varchar(250) NOT NULL,
  `lastorder` bigint(20) NOT NULL,
  `open` tinyint(4) NOT NULL,
  `stuck` tinyint(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=320 ;

--
-- Dumping data for table `f_tems`
--

INSERT INTO `f_tems` (`id`, `rid`, `name`, `avtor`, `lastorder`, `open`, `stuck`) VALUES
(319, 59, 'Тест тема', 'admin', 1327494453, 0, 0),
(318, 61, 'Тест тема', 'admin', 1327494437, 0, 0),
(317, 48, 'Тест тема', 'admin', 1327496734, 0, 0);

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

--
-- Table structure for table `gb`
--

CREATE TABLE IF NOT EXISTS `gb` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT NULL,
  `msg` varchar(500) NOT NULL,
  `date` bigint(20) NOT NULL,
  `otvet` varchar(1000) DEFAULT NULL,
  `ip` varchar(15) NOT NULL,
  `brows` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=104 ;

--
-- Dumping data for table `gb`
--

INSERT INTO `gb` (`id`, `name`, `msg`, `date`, `otvet`, `ip`, `brows`) VALUES
(102, 'admin', 'Тестовое сообщние <img src="../img/smile/).gif" alt=""/>', 1327494521, NULL, '127.0.0.1', 'Opera/9.80 (Windows NT 5.1; U; ru) Presto/2.7.62 Version/11.00'),
(103, 'admin', 'Тест 2', 1327494944, NULL, '127.0.0.1', 'Opera/9.80 (Windows NT 5.1; U; ru) Presto/2.7.62 Version/11.00');

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

--
-- Table structure for table `group`
--

CREATE TABLE IF NOT EXISTS `group` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `gname` varchar(150) NOT NULL,
  `gmoder` varchar(150) NOT NULL,
  `open` varchar(3) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `group`
--

INSERT INTO `group` (`id`, `gname`, `gmoder`, `open`) VALUES
(3, 'WAP мастеры', 'admin', 'yes'),
(4, 'Кодеры', 'admin', 'yes'),
(5, 'Дизайнеры', 'admin', 'yes'),
(6, 'Продавцы', 'admin', 'yes'),
(8, 'Журналисты газеты', 'admin', '');

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

--
-- Table structure for table `icqshop`
--

CREATE TABLE IF NOT EXISTS `icqshop` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `icq` int(11) NOT NULL,
  `kateg` varchar(4) NOT NULL,
  `price` int(11) NOT NULL,
  `icqpass` varchar(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=189 ;

--
-- Dumping data for table `icqshop`
--


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

--
-- Table structure for table `ignorlist`
--

CREATE TABLE IF NOT EXISTS `ignorlist` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `kto` varchar(150) NOT NULL,
  `kogo` varchar(150) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `ignorlist`
--


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

--
-- Table structure for table `isvoted`
--

CREATE TABLE IF NOT EXISTS `isvoted` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `vid` int(11) NOT NULL,
  `answer` varchar(25) NOT NULL,
  `ip` varchar(15) NOT NULL,
  `name` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=271 ;

--
-- Dumping data for table `isvoted`
--

INSERT INTO `isvoted` (`id`, `vid`, `answer`, `ip`, `name`) VALUES
(269, 10, 'otvet3', '127.0.0.1', 'admin'),
(270, 10, 'otvet1', '127.0.0.1', 'adm');

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

--
-- Table structure for table `kontaktlist`
--

CREATE TABLE IF NOT EXISTS `kontaktlist` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `kto` varchar(150) NOT NULL,
  `kogo` varchar(150) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=19 ;

--
-- Dumping data for table `kontaktlist`
--


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

--
-- Table structure for table `l_kateg`
--

CREATE TABLE IF NOT EXISTS `l_kateg` (
  `k_id` int(11) NOT NULL AUTO_INCREMENT,
  `r_id` int(11) NOT NULL,
  `k_name` varchar(50) NOT NULL,
  `k_opis` varchar(500) NOT NULL,
  PRIMARY KEY (`k_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=42 ;

--
-- Dumping data for table `l_kateg`
--

INSERT INTO `l_kateg` (`k_id`, `r_id`, `k_name`, `k_opis`) VALUES
(41, 7, 'test', 'test');

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

--
-- Table structure for table `l_komm`
--

CREATE TABLE IF NOT EXISTS `l_komm` (
  `komm_id` int(11) NOT NULL AUTO_INCREMENT,
  `s_id` int(11) NOT NULL,
  `komm_name` varchar(30) NOT NULL,
  `komm_msg` varchar(500) NOT NULL,
  `komm_date` bigint(20) DEFAULT NULL,
  `ip` varchar(15) NOT NULL,
  `brows` varchar(100) NOT NULL,
  PRIMARY KEY (`komm_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=15 ;

--
-- Dumping data for table `l_komm`
--

INSERT INTO `l_komm` (`komm_id`, `s_id`, `komm_name`, `komm_msg`, `komm_date`, `ip`, `brows`) VALUES
(13, 10375, 'admin', 'hj,,,,', 1010456847, '127.0.0.1', 'Opera/9.80 (Windows NT 5.1; U; ru) Presto/2.7.62 Version/11.00'),
(14, 10375, 'admin', 'ppp', 1010456899, '127.0.0.1', 'Opera/9.80 (Windows NT 5.1; U; ru) Presto/2.7.62 Version/11.00');

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

--
-- Table structure for table `l_razd`
--

CREATE TABLE IF NOT EXISTS `l_razd` (
  `r_id` int(11) NOT NULL AUTO_INCREMENT,
  `r_name` varchar(50) NOT NULL,
  `r_opis` varchar(500) NOT NULL,
  PRIMARY KEY (`r_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `l_razd`
--

INSERT INTO `l_razd` (`r_id`, `r_name`, `r_opis`) VALUES
(7, 'Авторские статьи', 'Авторские статьи');

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

--
-- Table structure for table `l_stat`
--

CREATE TABLE IF NOT EXISTS `l_stat` (
  `s_id` int(11) NOT NULL AUTO_INCREMENT,
  `k_id` int(11) NOT NULL,
  `s_name` varchar(50) NOT NULL,
  `s_stat` text NOT NULL,
  `s_read` int(11) NOT NULL,
  `s_reit` int(11) NOT NULL,
  PRIMARY KEY (`s_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=10378 ;

--
-- Dumping data for table `l_stat`
--

INSERT INTO `l_stat` (`s_id`, `k_id`, `s_name`, `s_stat`, `s_read`, `s_reit`) VALUES
(10377, 41, 'test 2', 'test 2', 1, 0),
(10376, 41, 'Тест', 'ТЕСТ\r\nТЕСТ\r\nТЕСТ\r\nТЕСТ\r\nТЕСТ\r\nТЕСТ\r\nТЕСТ\r\nТЕСТ', 2, 0);

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

--
-- Table structure for table `masspay`
--

CREATE TABLE IF NOT EXISTS `masspay` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `wmr` varchar(13) NOT NULL,
  `num` int(11) NOT NULL,
  `user` varchar(32) NOT NULL,
  `moded` varchar(3) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `masspay`
--


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

--
-- Table structure for table `moderstat`
--

CREATE TABLE IF NOT EXISTS `moderstat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uname` varchar(50) NOT NULL,
  `sname` varchar(100) NOT NULL,
  `stat` text NOT NULL,
  `rid` int(11) NOT NULL,
  `kid` int(11) NOT NULL,
  `date` bigint(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=18 ;

--
-- Dumping data for table `moderstat`
--


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

--
-- Table structure for table `news`
--

CREATE TABLE IF NOT EXISTS `news` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tema` varchar(500) NOT NULL,
  `news` varchar(1000) NOT NULL,
  `date` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=21 ;

--
-- Dumping data for table `news`
--

INSERT INTO `news` (`id`, `tema`, `news`, `date`) VALUES
(20, 'МЫ ОТКРЫТЫ', '<img src="img/smile/).gif" alt=""/> И та мы установили новый движок RGameCMS(модификация двига сайта КОДЕР-БИБЛИОТЕКА.РУ', 1327492503);

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

--
-- Table structure for table `news_komm`
--

CREATE TABLE IF NOT EXISTS `news_komm` (
  `news_id` int(11) NOT NULL,
  `komm_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT NULL,
  `msg` varchar(500) NOT NULL,
  `date` bigint(20) NOT NULL,
  `ip` varchar(15) NOT NULL,
  `brows` varchar(100) NOT NULL,
  PRIMARY KEY (`komm_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=40 ;

--
-- Dumping data for table `news_komm`
--

INSERT INTO `news_komm` (`news_id`, `komm_id`, `name`, `msg`, `date`, `ip`, `brows`) VALUES
(19, 36, 'admin', 'аааа', 1010454971, '127.0.0.1', 'Opera/9.80 (Windows NT 5.1; U; ru) Presto/2.7.62 Version/11.00'),
(19, 37, 'admin', 'патм', 1010455978, '127.0.0.1', 'Opera/9.80 (Windows NT 5.1; U; ru) Presto/2.7.62 Version/11.00'),
(20, 38, 'admin', 'Тест', 1422207746, '127.0.0.1', 'Opera/9.80 (Windows NT 5.1; U; ru) Presto/2.7.62 Version/11.00'),
(20, 39, 'admin', '123123', 1422210074, '127.0.0.1', 'Opera/9.80 (Windows NT 5.1; U; ru) Presto/2.7.62 Version/11.00');

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

--
-- Table structure for table `online`
--

CREATE TABLE IF NOT EXISTS `online` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ip` varchar(15) NOT NULL,
  `brows` varchar(300) NOT NULL,
  `lastvisit` bigint(20) NOT NULL,
  `whereis` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=41307 ;

--
-- Dumping data for table `online`
--

INSERT INTO `online` (`id`, `ip`, `brows`, `lastvisit`, `whereis`) VALUES
(41306, '127.0.0.1', 'Opera/9.80 (Windows NT 5.1; U; ru) Presto/2.7.62 Version/11.00', 1422213747, '');

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

--
-- Table structure for table `privat`
--

CREATE TABLE IF NOT EXISTS `privat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ot` varchar(50) NOT NULL,
  `komu` varchar(50) NOT NULL,
  `msg` varchar(1000) NOT NULL,
  `readed` varchar(2) NOT NULL,
  `date` bigint(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=173 ;

--
-- Dumping data for table `privat`
--


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

--
-- Table structure for table `refer`
--

CREATE TABLE IF NOT EXISTS `refer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rid` int(11) NOT NULL,
  `ip` varchar(15) NOT NULL,
  `date` bigint(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `refer`
--


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

--
-- Table structure for table `reitlog`
--

CREATE TABLE IF NOT EXISTS `reitlog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `kto` varchar(150) NOT NULL,
  `komu` varchar(150) NOT NULL,
  `msg` varchar(500) NOT NULL,
  `reit` varchar(1) NOT NULL,
  `date` bigint(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `reitlog`
--


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

--
-- Table structure for table `reklama`
--

CREATE TABLE IF NOT EXISTS `reklama` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `link` varchar(35) NOT NULL,
  `podpis` varchar(35) NOT NULL,
  `time` bigint(20) NOT NULL,
  `type` varchar(6) NOT NULL,
  `user` varchar(150) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `reklama`
--


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

--
-- Table structure for table `serflink`
--

CREATE TABLE IF NOT EXISTS `serflink` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `link` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `serflink`
--


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

--
-- Table structure for table `serfvisited`
--

CREATE TABLE IF NOT EXISTS `serfvisited` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `linkid` int(11) NOT NULL,
  `ip` varchar(15) NOT NULL,
  `date` bigint(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=127 ;

--
-- Dumping data for table `serfvisited`
--


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

--
-- Table structure for table `sps`
--

CREATE TABLE IF NOT EXISTS `sps` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pid` int(11) NOT NULL,
  `komu` varchar(32) NOT NULL,
  `kto` varchar(32) NOT NULL,
  `date` bigint(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=22 ;

--
-- Dumping data for table `sps`
--

INSERT INTO `sps` (`id`, `pid`, `komu`, `kto`, `date`) VALUES
(20, 2309, 'admin', 'adm', 1327496740);

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

--
-- Table structure for table `sysconf`
--

CREATE TABLE IF NOT EXISTS `sysconf` (
  `balforstat` int(11) NOT NULL,
  `balforstatmin` int(11) NOT NULL,
  `changegroup` int(11) NOT NULL,
  `baltowmr` double NOT NULL,
  `buyreklrotate` int(11) NOT NULL,
  `buyreklstatic` int(11) NOT NULL,
  `balforserf` int(11) NOT NULL,
  `balforref` int(11) NOT NULL,
  `g_write` varchar(1) NOT NULL,
  `balfornewskomm` int(11) NOT NULL,
  `reittime` int(11) NOT NULL,
  `flud` int(11) NOT NULL,
  `balforgb` int(11) NOT NULL,
  `balforforum` int(11) NOT NULL,
  `balforforumtema` int(11) NOT NULL,
  `forumedit` int(11) NOT NULL,
  `changestatus` int(11) NOT NULL,
  `balfordownkomm` int(11) NOT NULL,
  `balforfile` int(11) NOT NULL,
  `balforreit` int(11) NOT NULL,
  `balforlibkomm` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

--
-- Dumping data for table `sysconf`
--

INSERT INTO `sysconf` (`balforstat`, `balforstatmin`, `changegroup`, `baltowmr`, `buyreklrotate`, `buyreklstatic`, `balforserf`, `balforref`, `g_write`, `balfornewskomm`, `reittime`, `flud`, `balforgb`, `balforforum`, `balforforumtema`, `forumedit`, `changestatus`, `balfordownkomm`, `balforfile`, `balforreit`, `balforlibkomm`) VALUES
(5, 5, 50, 0, 0, 0, 0, 0, '1', 1, 0, 1, 1, 1, 2, 1, 0, 1, 1, 0, 1);

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

--
-- Table structure for table `translog`
--

CREATE TABLE IF NOT EXISTS `translog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `kto` varchar(32) NOT NULL,
  `komu` varchar(32) NOT NULL,
  `sum` int(11) NOT NULL,
  `komm` varchar(250) NOT NULL,
  `date` bigint(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `votes`
--

CREATE TABLE IF NOT EXISTS `votes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `vopros` varchar(250) NOT NULL,
  `otvet1` varchar(100) NOT NULL,
  `otvet2` varchar(100) NOT NULL,
  `otvet3` varchar(100) NOT NULL,
  `otvet4` varchar(100) NOT NULL,
  `otvet5` varchar(100) NOT NULL,
  `type` varchar(3) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=11 ;

--
-- Dumping data for table `votes`
--

INSERT INTO `votes` (`id`, `vopros`, `otvet1`, `otvet2`, `otvet3`, `otvet4`, `otvet5`, `type`) VALUES
(10, '123', '123', '123', '123', '123', '123', 'reg');