View file top-kat/tabla.sql

File size: 21.67Kb
-- phpMyAdmin SQL Dump
-- version 3.5.1
-- http://www.phpmyadmin.net
--
-- РҐРѕСЃС‚: 127.0.0.1
-- Р’СЂРµРјСЏ СЃРѕР·РґР°РЅРёСЏ: Р”РµРє 10 2014 Рі., 04:57
-- Р’РµСЂСЃРёСЏ СЃРµСЂРІРµСЂР°: 5.5.25
-- Р’РµСЂСЃРёСЏ PHP: 5.3.13

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 */;

--
-- Р‘Р°Р·Р° РґР°РЅРЅС‹С…: `on`
--

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

--
-- РЎС‚СЂСѓРєС‚СѓСЂР° С‚Р°Р±Р»РёС†С‹ `admin`
--

CREATE TABLE IF NOT EXISTS `admin` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `login` varchar(255) NOT NULL COMMENT 'Логин админа',
  `pas` varchar(32) NOT NULL COMMENT 'Пароль Админа',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Таблица данных админа' AUTO_INCREMENT=1 ;

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

--
-- РЎС‚СЂСѓРєС‚СѓСЂР° С‚Р°Р±Р»РёС†С‹ `ban`
--

CREATE TABLE IF NOT EXISTS `ban` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `ip` varchar(15) NOT NULL COMMENT 'IP забаненного',
  `ua` varchar(255) DEFAULT NULL COMMENT 'User-Agent забаненного',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Таблица забаненных' AUTO_INCREMENT=1 ;

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

--
-- РЎС‚СЂСѓРєС‚СѓСЂР° С‚Р°Р±Р»РёС†С‹ `cat`
--

CREATE TABLE IF NOT EXISTS `cat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL,
  `position` int(3) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=21 ;

--
-- Р”Р°РјРї РґР°РЅРЅС‹С… С‚Р°Р±Р»РёС†С‹ `cat`
--

INSERT INTO `cat` (`id`, `name`, `position`) VALUES
(11, 'РџСЂРѕС‡РёРµ', 11),
(10, 'РЈРІР»РµС‡РµРЅРёСЏ, С…РѕР±Р±Рё', 10),
(8, 'Р Р°Р·РІР»РµС‡РµРЅРёСЏ', 8),
(9, 'РЎРµСЂРІРёСЃС‹', 9),
(6, 'РњР°РіР°Р·РёРЅС‹, СѓСЃР»СѓРіРё', 6),
(7, 'РћР±С‰РµРЅРёРµ', 7),
(3, 'Р—РЅР°РєРѕРјСЃС‚РІР°', 3),
(5, 'Р?РЅС„РѕСЂРјР°С†РёРѕРЅРЅС‹Рµ', 5),
(1, 'Р‘РёР·РЅРµСЃ', 1),
(2, 'Р—Р°РіСЂСѓР·РєРё', 2),
(4, 'Р”Р»СЏ РІР·СЂРѕСЃР»С‹С…', 4),
(12, 'РўРѕРї Р РµР№С‚РёРЅРіРё', 4),
(13, 'WAP РјР°СЃС‚РµСЂСѓ', 8),
(14, 'РџР°СЂС‚РЅС‘СЂРєРё', 10),
(15, 'РђРІС‚Рѕ Рё РўРµС…РЅРёРєР°', 8),
(16, 'РћРЅР»Р°Р№РЅ РёРіСЂС‹', 7),
(17, 'Р Р°Р±РѕС‚Р° Рё РљР°СЂСЊРµСЂР°', 9),
(18, 'РҐРѕСЃС‚РёРЅРіРё', 10),
(19, 'Hi-Tech, Р?РЅС‚РµСЂРЅРµС‚', 12),
(20, 'Р’Р·Р»РѕРј, С…Р°РєРµСЂСЃС‚РІРѕ', 13);

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

--
-- РЎС‚СЂСѓРєС‚СѓСЂР° С‚Р°Р±Р»РёС†С‹ `dd_online`
--

CREATE TABLE IF NOT EXISTS `dd_online` (
  `id` int(16) NOT NULL AUTO_INCREMENT,
  `ip` text NOT NULL,
  `browser` text NOT NULL,
  `os` text NOT NULL,
  `visit` int(16) NOT NULL,
  `online` int(11) NOT NULL DEFAULT '0',
  `steps` int(11) NOT NULL DEFAULT '1',
  `place` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- РЎС‚СЂСѓРєС‚СѓСЂР° С‚Р°Р±Р»РёС†С‹ `hits`
--

CREATE TABLE IF NOT EXISTS `hits` (
  `id_sait` int(11) NOT NULL,
  `time` int(8) NOT NULL,
  `ip` varchar(16) NOT NULL,
  `browser` varchar(30) NOT NULL,
  `operator` int(6) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- РЎС‚СЂСѓРєС‚СѓСЂР° С‚Р°Р±Р»РёС†С‹ `hosts`
--

CREATE TABLE IF NOT EXISTS `hosts` (
  `id_sait` int(11) NOT NULL,
  `time` int(8) NOT NULL,
  `ip` varchar(16) NOT NULL,
  `browser` varchar(30) NOT NULL,
  `operator` int(6) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- РЎС‚СЂСѓРєС‚СѓСЂР° С‚Р°Р±Р»РёС†С‹ `in`
--

CREATE TABLE IF NOT EXISTS `in` (
  `id_sait` int(11) NOT NULL,
  `ip` varchar(16) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- РЎС‚СЂСѓРєС‚СѓСЂР° С‚Р°Р±Р»РёС†С‹ `ip`
--

CREATE TABLE IF NOT EXISTS `ip` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `id_c` int(100) NOT NULL,
  `start` int(100) NOT NULL,
  `finish` int(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- РЎС‚СЂСѓРєС‚СѓСЂР° С‚Р°Р±Р»РёС†С‹ `ip_name`
--

CREATE TABLE IF NOT EXISTS `ip_name` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `ids` int(100) NOT NULL,
  `operator` varchar(50) NOT NULL,
  `country` varchar(50) NOT NULL,
  `coun` varchar(2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- РЎС‚СЂСѓРєС‚СѓСЂР° С‚Р°Р±Р»РёС†С‹ `messages`
--

CREATE TABLE IF NOT EXISTS `messages` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'Id сообщения',
  `name` varchar(25) NOT NULL COMMENT 'Ник пользователя',
  `date` datetime NOT NULL COMMENT 'Дата добавления сообщения',
  `message` text NOT NULL COMMENT 'Текст сообщения',
  `ip` varchar(15) DEFAULT NULL COMMENT 'IP пользователя',
  `ua` varchar(255) DEFAULT NULL COMMENT 'User-Agent пользователя',
  `otvet` text COMMENT 'Ответ админа',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Таблица сообщений гостевой книги' AUTO_INCREMENT=1 ;

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

--
-- РЎС‚СЂСѓРєС‚СѓСЂР° С‚Р°Р±Р»РёС†С‹ `news`
--

CREATE TABLE IF NOT EXISTS `news` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(40) NOT NULL,
  `text` varchar(1000) NOT NULL,
  `time` int(8) NOT NULL,
  `author` varchar(30) NOT NULL,
  `plus` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

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

--
-- РЎС‚СЂСѓРєС‚СѓСЂР° С‚Р°Р±Р»РёС†С‹ `news_comments`
--

CREATE TABLE IF NOT EXISTS `news_comments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_news` int(11) NOT NULL,
  `name` varchar(30) NOT NULL,
  `text` varchar(100) NOT NULL,
  `time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=46 ;

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

--
-- РЎС‚СЂСѓРєС‚СѓСЂР° С‚Р°Р±Р»РёС†С‹ `news_rep`
--

CREATE TABLE IF NOT EXISTS `news_rep` (
  `id_news` int(11) NOT NULL,
  `time` int(11) NOT NULL,
  `ip` varchar(15) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- РЎС‚СЂСѓРєС‚СѓСЂР° С‚Р°Р±Р»РёС†С‹ `online`
--

CREATE TABLE IF NOT EXISTS `online` (
  `ip` varchar(16) NOT NULL,
  `ua` varchar(20) NOT NULL,
  `time` int(7) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Р”Р°РјРї РґР°РЅРЅС‹С… С‚Р°Р±Р»РёС†С‹ `online`
--

INSERT INTO `online` (`ip`, `ua`, `time`) VALUES
('127.0.0.1', 'Mozilla', 1418144216);

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

--
-- РЎС‚СЂСѓРєС‚СѓСЂР° С‚Р°Р±Р»РёС†С‹ `onlines`
--

CREATE TABLE IF NOT EXISTS `onlines` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `stamp` int(11) NOT NULL,
  `ip` varchar(255) NOT NULL,
  `ua` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;

--
-- Р”Р°РјРї РґР°РЅРЅС‹С… С‚Р°Р±Р»РёС†С‹ `onlines`
--

INSERT INTO `onlines` (`id`, `stamp`, `ip`, `ua`) VALUES
(14, 1396079744, '5.10.83.79', 'Mozilla/5.0 (compatible; AhrefsBot/5.0; +http://ahrefs.com/robot/)');

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

--
-- РЎС‚СЂСѓРєС‚СѓСЂР° С‚Р°Р±Р»РёС†С‹ `out`
--

CREATE TABLE IF NOT EXISTS `out` (
  `id_sait` int(11) NOT NULL,
  `ip` varchar(16) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Р”Р°РјРї РґР°РЅРЅС‹С… С‚Р°Р±Р»РёС†С‹ `out`
--

INSERT INTO `out` (`id_sait`, `ip`) VALUES
(1, '127.0.0.1');

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

--
-- РЎС‚СЂСѓРєС‚СѓСЂР° С‚Р°Р±Р»РёС†С‹ `sait`
--

CREATE TABLE IF NOT EXISTS `sait` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_user` int(11) NOT NULL,
  `id_mod` int(11) NOT NULL,
  `name` varchar(30) NOT NULL,
  `about` varchar(150) NOT NULL,
  `time_reg` int(8) NOT NULL,
  `time_activ` int(8) NOT NULL,
  `hits` int(11) NOT NULL,
  `hits2` int(11) NOT NULL,
  `hits3` int(11) NOT NULL,
  `hits4` int(11) NOT NULL,
  `hits5` int(11) NOT NULL,
  `hits6` int(11) NOT NULL,
  `hits7` int(11) NOT NULL,
  `hosts` int(11) NOT NULL,
  `hosts2` int(11) NOT NULL,
  `hosts3` int(11) NOT NULL,
  `hosts4` int(11) NOT NULL,
  `hosts5` int(11) NOT NULL,
  `hosts6` int(11) NOT NULL,
  `hosts7` int(11) NOT NULL,
  `all_hits` int(11) NOT NULL,
  `all_hosts` int(11) NOT NULL,
  `in` int(11) NOT NULL,
  `in2` int(11) NOT NULL,
  `in3` int(11) NOT NULL,
  `in4` int(11) NOT NULL,
  `in5` int(11) NOT NULL,
  `in6` int(11) NOT NULL,
  `in7` int(11) NOT NULL,
  `out` int(11) NOT NULL,
  `out2` int(11) NOT NULL,
  `out3` int(11) NOT NULL,
  `out4` int(11) NOT NULL,
  `out5` int(11) NOT NULL,
  `out6` int(11) NOT NULL,
  `out7` int(11) NOT NULL,
  `all_in` int(11) NOT NULL,
  `all_out` int(11) NOT NULL,
  `category` int(6) NOT NULL,
  `image` varchar(6) NOT NULL,
  `image_s` varchar(6) NOT NULL,
  `url` varchar(30) NOT NULL,
  `status` int(1) NOT NULL,
  `auto_ban` int(1) NOT NULL,
  `ban` int(1) NOT NULL,
  `ban_reason` varchar(50) NOT NULL,
  `ban_who` int(11) NOT NULL,
  `ban_time` int(8) NOT NULL,
  `cy` int(5) NOT NULL,
  `pr` int(2) NOT NULL,
  `auto_del` int(1) NOT NULL,
  `hits8` int(11) DEFAULT '0',
  `hits9` int(11) DEFAULT '0',
  `hits10` int(11) DEFAULT '0',
  `hits11` int(11) DEFAULT '0',
  `hits12` int(11) DEFAULT '0',
  `hits13` int(11) DEFAULT '0',
  `hits14` int(11) DEFAULT '0',
  `hits15` int(11) DEFAULT '0',
  `hits16` int(11) DEFAULT '0',
  `hits17` int(11) DEFAULT '0',
  `hits18` int(11) DEFAULT '0',
  `hits19` int(11) DEFAULT '0',
  `hits20` int(11) DEFAULT '0',
  `hits21` int(11) DEFAULT '0',
  `hits22` int(11) DEFAULT '0',
  `hits23` int(11) DEFAULT '0',
  `hits24` int(11) DEFAULT '0',
  `hits25` int(11) DEFAULT '0',
  `hits26` int(11) DEFAULT '0',
  `hits27` int(11) DEFAULT '0',
  `hits28` int(11) DEFAULT '0',
  `hits29` int(11) DEFAULT '0',
  `hits30` int(11) DEFAULT '0',
  `hosts8` int(11) DEFAULT '0',
  `hosts9` int(11) DEFAULT '0',
  `hosts10` int(11) DEFAULT '0',
  `hosts11` int(11) DEFAULT '0',
  `hosts12` int(11) DEFAULT '0',
  `hosts13` int(11) DEFAULT '0',
  `hosts14` int(11) DEFAULT '0',
  `hosts15` int(11) DEFAULT '0',
  `hosts16` int(11) DEFAULT '0',
  `hosts17` int(11) DEFAULT '0',
  `hosts18` int(11) DEFAULT '0',
  `hosts19` int(11) DEFAULT '0',
  `hosts20` int(11) DEFAULT '0',
  `hosts21` int(11) DEFAULT '0',
  `hosts22` int(11) DEFAULT '0',
  `hosts23` int(11) DEFAULT '0',
  `hosts24` int(11) DEFAULT '0',
  `hosts25` int(11) DEFAULT '0',
  `hosts26` int(11) DEFAULT '0',
  `hosts27` int(11) DEFAULT '0',
  `hosts28` int(11) DEFAULT '0',
  `hosts29` int(11) DEFAULT '0',
  `hosts30` int(11) DEFAULT '0',
  `in8` int(11) DEFAULT '0',
  `in9` int(11) DEFAULT '0',
  `in10` int(11) DEFAULT '0',
  `in11` int(11) DEFAULT '0',
  `in12` int(11) DEFAULT '0',
  `in13` int(11) DEFAULT '0',
  `in14` int(11) DEFAULT '0',
  `in15` int(11) DEFAULT '0',
  `in16` int(11) DEFAULT '0',
  `in17` int(11) DEFAULT '0',
  `in18` int(11) DEFAULT '0',
  `in19` int(11) DEFAULT '0',
  `in20` int(11) DEFAULT '0',
  `in21` int(11) DEFAULT '0',
  `in22` int(11) DEFAULT '0',
  `in23` int(11) DEFAULT '0',
  `in24` int(11) DEFAULT '0',
  `in25` int(11) DEFAULT '0',
  `in26` int(11) DEFAULT '0',
  `in27` int(11) DEFAULT '0',
  `in28` int(11) DEFAULT '0',
  `in29` int(11) DEFAULT '0',
  `in30` int(11) DEFAULT '0',
  `out8` int(11) DEFAULT '0',
  `out9` int(11) DEFAULT '0',
  `out10` int(11) DEFAULT '0',
  `out11` int(11) DEFAULT '0',
  `out12` int(11) DEFAULT '0',
  `out13` int(11) DEFAULT '0',
  `out14` int(11) DEFAULT '0',
  `out15` int(11) DEFAULT '0',
  `out16` int(11) DEFAULT '0',
  `out17` int(11) DEFAULT '0',
  `out18` int(11) DEFAULT '0',
  `out19` int(11) DEFAULT '0',
  `out20` int(11) DEFAULT '0',
  `out21` int(11) DEFAULT '0',
  `out22` int(11) DEFAULT '0',
  `out23` int(11) DEFAULT '0',
  `out24` int(11) DEFAULT '0',
  `out25` int(11) DEFAULT '0',
  `out26` int(11) DEFAULT '0',
  `out27` int(11) DEFAULT '0',
  `out28` int(11) DEFAULT '0',
  `out29` int(11) DEFAULT '0',
  `out30` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;

--
-- Р”Р°РјРї РґР°РЅРЅС‹С… С‚Р°Р±Р»РёС†С‹ `sait`
--

INSERT INTO `sait` (`id`, `id_user`, `id_mod`, `name`, `about`, `time_reg`, `time_activ`, `hits`, `hits2`, `hits3`, `hits4`, `hits5`, `hits6`, `hits7`, `hosts`, `hosts2`, `hosts3`, `hosts4`, `hosts5`, `hosts6`, `hosts7`, `all_hits`, `all_hosts`, `in`, `in2`, `in3`, `in4`, `in5`, `in6`, `in7`, `out`, `out2`, `out3`, `out4`, `out5`, `out6`, `out7`, `all_in`, `all_out`, `category`, `image`, `image_s`, `url`, `status`, `auto_ban`, `ban`, `ban_reason`, `ban_who`, `ban_time`, `cy`, `pr`, `auto_del`, `hits8`, `hits9`, `hits10`, `hits11`, `hits12`, `hits13`, `hits14`, `hits15`, `hits16`, `hits17`, `hits18`, `hits19`, `hits20`, `hits21`, `hits22`, `hits23`, `hits24`, `hits25`, `hits26`, `hits27`, `hits28`, `hits29`, `hits30`, `hosts8`, `hosts9`, `hosts10`, `hosts11`, `hosts12`, `hosts13`, `hosts14`, `hosts15`, `hosts16`, `hosts17`, `hosts18`, `hosts19`, `hosts20`, `hosts21`, `hosts22`, `hosts23`, `hosts24`, `hosts25`, `hosts26`, `hosts27`, `hosts28`, `hosts29`, `hosts30`, `in8`, `in9`, `in10`, `in11`, `in12`, `in13`, `in14`, `in15`, `in16`, `in17`, `in18`, `in19`, `in20`, `in21`, `in22`, `in23`, `in24`, `in25`, `in26`, `in27`, `in28`, `in29`, `in30`, `out8`, `out9`, `out10`, `out11`, `out12`, `out13`, `out14`, `out15`, `out16`, `out17`, `out18`, `out19`, `out20`, `out21`, `out22`, `out23`, `out24`, `out25`, `out26`, `out27`, `out28`, `out29`, `out30`) VALUES
(1, 1, 0, 'onstats.ru', 'РўРѕРї СЂРµР№С‚РёРЅРі WAP/WEB СЃР°Р№С‚РѕРІ!', 1403701256, 0, 654, 0, 0, 0, 0, 0, 0, 310, 0, 0, 0, 0, 0, 0, 654, 13, 5001, 0, 0, 0, 0, 0, 0, 4000, 0, 0, 0, 0, 0, 0, 1, 0, 1, '1', '1', 'onstatss.ru', 1, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(11, 1, 0, 'loxadfhjk', 'il;jh;k&#39;uklhlkih', 1418143410, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '1', '1', 'mybit.su', 1, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(4, 1, 1, 'goldtop.tk', 'С‚РµСЃС‚РёРј С‚РѕРї СЂРµР№С‚РёРЅРі', 1417103255, 1417103269, 4, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 4, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '1', '1', 'goldtop.tk', 1, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(5, 1, 1, 'staydm', 'С‚РµСЃС‚РёРј СЂР°Р±РѕС‚Сѓ С‚РѕРї СЂРµР№С‚РёРЅРіР°', 1417103417, 1417103488, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '1', '1', 'statok.net', 1, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(6, 1, 1, 'staydm', 'С‚РµСЃС‚РёРј СЂР°Р±РѕС‚Сѓ С‚РѕРї СЂРµР№С‚РёРЅРіР°', 1417103443, 1417103486, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '1', '1', 'xxxdag.ru', 1, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

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

--
-- РЎС‚СЂСѓРєС‚СѓСЂР° С‚Р°Р±Р»РёС†С‹ `sait_online`
--

CREATE TABLE IF NOT EXISTS `sait_online` (
  `id_sait` int(11) NOT NULL,
  `ip` varchar(16) NOT NULL,
  `ua` varchar(20) NOT NULL,
  `time` int(7) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Р”Р°РјРї РґР°РЅРЅС‹С… С‚Р°Р±Р»РёС†С‹ `sait_online`
--

INSERT INTO `sait_online` (`id_sait`, `ip`, `ua`, `time`) VALUES
(1, '127.0.0.1', 'Mozilla', 1418144216),
(4, '127.0.0.1', 'Mozilla', 1417103332);

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

--
-- РЎС‚СЂСѓРєС‚СѓСЂР° С‚Р°Р±Р»РёС†С‹ `settings`
--

CREATE TABLE IF NOT EXISTS `settings` (
  `name` varchar(60) NOT NULL,
  `value` varchar(60) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Р”Р°РјРї РґР°РЅРЅС‹С… С‚Р°Р±Р»РёС†С‹ `settings`
--

INSERT INTO `settings` (`name`, `value`) VALUES
('home', 'onstatss.ru'),
('top_name', 'OnSTaTS.Ru СЂРµР№С‚РёРЅРі WAP/WEB СЃР°Р№С‚РѕРІ'),
('max_platforms', '20'),
('page_platforms', '10'),
('page_sait', '10'),
('page_top', '10'),
('pages', '10'),
('page_moderacia', '10'),
('page_users', '10'),
('mail', 'robot@onstats.ru'),
('power_reg', '1'),
('install', '1367297874'),
('moderacia', '0'),
('auto_moderacia', '1'),
('adm_email', '9_dasik@mail.ru'),
('home', 'onstatss.ru'),
('top_name', 'OnSTaTS.Ru СЂРµР№С‚РёРЅРі WAP/WEB СЃР°Р№С‚РѕРІ'),
('max_platforms', '20'),
('page_platforms', '10'),
('page_sait', '10'),
('page_top', '10'),
('pages', '10'),
('page_moderacia', '10'),
('page_users', '10'),
('mail', 'robot@onstats.ru'),
('power_reg', '1'),
('install', '1367297874'),
('moderacia', '0'),
('auto_moderacia', '1'),
('adm_email', '9_dasik@mail.ru');

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

--
-- РЎС‚СЂСѓРєС‚СѓСЂР° С‚Р°Р±Р»РёС†С‹ `sms`
--

CREATE TABLE IF NOT EXISTS `sms` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `author` varchar(30) NOT NULL,
  `smska` varchar(500) NOT NULL,
  `data` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- РЎС‚СЂСѓРєС‚СѓСЂР° С‚Р°Р±Р»РёС†С‹ `sms_adm`
--

CREATE TABLE IF NOT EXISTS `sms_adm` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `author` varchar(30) NOT NULL,
  `smska` varchar(500) NOT NULL,
  `data` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=262 ;

--
-- Р”Р°РјРї РґР°РЅРЅС‹С… С‚Р°Р±Р»РёС†С‹ `sms_adm`
--

INSERT INTO `sms_adm` (`id`, `author`, `smska`, `data`) VALUES
(261, 'Admin', 'РњРѕРґРµСЂР°С‚РѕСЂР°Рј РџСЂРёРІРµС‚:)', 1389763879);

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

--
-- РЎС‚СЂСѓРєС‚СѓСЂР° С‚Р°Р±Р»РёС†С‹ `top_online`
--

CREATE TABLE IF NOT EXISTS `top_online` (
  `ip` varchar(16) NOT NULL,
  `ua` varchar(20) NOT NULL,
  `time` int(7) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Р”Р°РјРї РґР°РЅРЅС‹С… С‚Р°Р±Р»РёС†С‹ `top_online`
--

INSERT INTO `top_online` (`ip`, `ua`, `time`) VALUES
('8.37.224.129', 'Nokia1680c-2', 1372415709);

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

--
-- РЎС‚СЂСѓРєС‚СѓСЂР° С‚Р°Р±Р»РёС†С‹ `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `time_reg` int(8) NOT NULL,
  `login` varchar(30) NOT NULL,
  `password` varchar(50) NOT NULL,
  `mail` varchar(30) NOT NULL,
  `level` int(2) NOT NULL,
  `pages` int(2) NOT NULL,
  `page_platforms` int(2) NOT NULL,
  `page_sait` int(2) NOT NULL,
  `page_top` int(2) NOT NULL,
  `auto_del` int(1) NOT NULL,
  `kr` int(6) DEFAULT '0',
  `balans` float NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Р”Р°РјРї РґР°РЅРЅС‹С… С‚Р°Р±Р»РёС†С‹ `users`
--

INSERT INTO `users` (`id`, `time_reg`, `login`, `password`, `mail`, `level`, `pages`, `page_platforms`, `page_sait`, `page_top`, `auto_del`, `kr`, `balans`) VALUES
(1, 1403697018, 'Admin', 'on123456', 'robot@mail.ru', 3, 10, 10, 10, 10, 0, 0, 0);

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

--
-- РЎС‚СЂСѓРєС‚СѓСЂР° С‚Р°Р±Р»РёС†С‹ `worldkassa`
--

CREATE TABLE IF NOT EXISTS `worldkassa` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Р’РЅСѓС‚СЂРµРЅРЅРёР№ ID РїР»Р°С‚РµР¶Р°',
  `id_bill` int(11) unsigned NOT NULL COMMENT 'ID РїР»Р°С‚РµР¶Р° РІ Worldkassa',
  `init` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Р’СЂРµРјСЏ РёРЅРёС†РёР°Р»РёР·Р°С†РёРё РїР»Р°С‚РµР¶Р°',
  `payment` datetime NOT NULL COMMENT 'Р’СЂРµРјСЏ РѕРїР»Р°С‚С‹',
  `summa` decimal(11,2) NOT NULL DEFAULT '0.00' COMMENT 'РЎСѓРјРјР°',
  `days` int(11) NOT NULL DEFAULT '0' COMMENT 'РљРѕР»РёС‡РµСЃС‚РІРѕ РґРЅРµР№',
  `expire` datetime NOT NULL COMMENT 'Р?СЃС‚РµРєР°РµС‚',
  `url` varchar(50) NOT NULL COMMENT 'РђРґСЂРµСЃ СЃР°Р№С‚Р°',
  `name` varchar(32) NOT NULL COMMENT 'РќР°Р·РІР°РЅРёРµ СЃСЃС‹Р»РєРё',
  `color` varchar(20) NOT NULL COMMENT 'Р¦РІРµС‚ СЃСЃС‹Р»РєРё',
  `bold` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Р–РёСЂРЅС‹Р№',
  `italic` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'РљСѓСЂСЃРёРІРЅС‹Р№',
  PRIMARY KEY (`id`),
  KEY `time_expire` (`expire`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='РЎС‚Р°С‚РёСЃС‚РёРєР° РїР»Р°С‚РµР¶РµР№ С‡РµСЂРµР· WorldKassa' AUTO_INCREMENT=2 ;

--
-- Р”Р°РјРї РґР°РЅРЅС‹С… С‚Р°Р±Р»РёС†С‹ `worldkassa`
--

INSERT INTO `worldkassa` (`id`, `id_bill`, `init`, `payment`, `summa`, `days`, `expire`, `url`, `name`, `color`, `bold`, `italic`) VALUES
(1, 1, '2014-11-27 15:24:39', '2014-11-27 13:24:39', '100.00', 28, '2014-12-10 21:58:20', 'http://o5ebu.ru', 'РїРѕСЂРЅРѕ СЃРєР°С‡Р°С‚СЊ', 'red', 1, 1);

/*!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 */;