View file o5on.ru/baza.sql

-- phpMyAdmin SQL Dump
-- version 3.5.1
-- http://www.phpmyadmin.net
--
-- Хост: 127.0.0.1
-- Время создания: Апр 17 2014 г., 00:09
-- Версия сервера: 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 */;

--
-- База данных: `wapukr`
--

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

--
-- Структура таблицы `ban_user`
--

CREATE TABLE IF NOT EXISTS `ban_user` (
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `link` varchar(35) NOT NULL DEFAULT '',
  PRIMARY KEY (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

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

--
-- Структура таблицы `cat`
--

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

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

--
-- Структура таблицы `count_24`
--

CREATE TABLE IF NOT EXISTS `count_24` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `date` int(10) unsigned NOT NULL DEFAULT '0',
  `hour` smallint(5) unsigned NOT NULL DEFAULT '0',
  `count` int(10) unsigned NOT NULL DEFAULT '0',
  `host` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

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

--
-- Структура таблицы `gener`
--

CREATE TABLE IF NOT EXISTS `gener` (
  `time` varchar(100) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

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

--
-- Структура таблицы `hits_ip`
--

CREATE TABLE IF NOT EXISTS `hits_ip` (
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `ip` varchar(15) NOT NULL DEFAULT '',
  `ua` varchar(255) NOT NULL DEFAULT 'n/a',
  `time` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`ip`,`ua`,`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

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

--
-- Структура таблицы `hits_time`
--

CREATE TABLE IF NOT EXISTS `hits_time` (
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `time` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

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

--
-- Структура таблицы `models_data`
--

CREATE TABLE IF NOT EXISTS `models_data` (
  `ua` varchar(40) NOT NULL DEFAULT '',
  `vendor` varchar(20) NOT NULL DEFAULT 'n/a',
  `model` varchar(20) NOT NULL DEFAULT 'n/a',
  `screensize` varchar(7) NOT NULL DEFAULT 'n/a',
  `bitsperpixel` smallint(5) unsigned NOT NULL DEFAULT '0',
  `supportedbearers` varchar(50) NOT NULL DEFAULT 'n/a',
  `javaplatform` varchar(50) NOT NULL DEFAULT 'n/a',
  `wapversion` varchar(30) NOT NULL DEFAULT 'n/a',
  `wmlversion` varchar(30) NOT NULL DEFAULT 'n/a',
  `wmlscript` varchar(30) NOT NULL DEFAULT 'n/a',
  `keyboard` varchar(40) NOT NULL DEFAULT 'n/a',
  `numsoftkeys` varchar(5) NOT NULL DEFAULT 'n/a',
  `charset` varchar(50) NOT NULL DEFAULT 'n/a',
  `emailschemes` varchar(30) NOT NULL DEFAULT 'n/a',
  `browserframes` varchar(10) NOT NULL DEFAULT 'n/a',
  `browserjavaapplet` varchar(10) NOT NULL DEFAULT 'n/a',
  `html` varchar(10) NOT NULL DEFAULT 'n/a',
  `xhtml` varchar(10) NOT NULL DEFAULT 'n/a',
  `browsertables` varchar(10) NOT NULL DEFAULT 'n/a',
  PRIMARY KEY (`ua`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

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

--
-- Структура таблицы `months`
--

CREATE TABLE IF NOT EXISTS `months` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `date` int(10) unsigned NOT NULL DEFAULT '0',
  `count` int(10) unsigned NOT NULL DEFAULT '0',
  `host` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

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

--
-- Структура таблицы `new_operators`
--

CREATE TABLE IF NOT EXISTS `new_operators` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ip_new` varchar(255) NOT NULL DEFAULT '',
  `name_not` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

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

--
-- Структура таблицы `online_ip`
--

CREATE TABLE IF NOT EXISTS `online_ip` (
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `ip` varchar(15) NOT NULL DEFAULT '',
  `time` int(10) unsigned NOT NULL DEFAULT '0',
  `browser` varchar(25) NOT NULL DEFAULT 'unknow',
  PRIMARY KEY (`ip`,`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

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

--
-- Структура таблицы `superadmin`
--

CREATE TABLE IF NOT EXISTS `superadmin` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `login` varchar(20) NOT NULL DEFAULT '',
  `pass` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`,`login`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

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

--
-- Структура таблицы `top_ip`
--

CREATE TABLE IF NOT EXISTS `top_ip` (
  `id_operator` int(10) unsigned NOT NULL DEFAULT '0',
  `ip1` int(10) unsigned NOT NULL DEFAULT '0',
  `ip2` int(10) unsigned NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

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

--
-- Структура таблицы `top_operators`
--

CREATE TABLE IF NOT EXISTS `top_operators` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '',
  `label` varchar(25) NOT NULL DEFAULT '',
  `tld` varchar(10) NOT NULL DEFAULT '',
  `country` varchar(50) NOT NULL DEFAULT '',
  `publish` smallint(5) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

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

--
-- Структура таблицы `top_operators_stat`
--

CREATE TABLE IF NOT EXISTS `top_operators_stat` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `next_mon` int(10) unsigned NOT NULL DEFAULT '0',
  `date` int(10) unsigned NOT NULL DEFAULT '0',
  `day_week` smallint(5) unsigned NOT NULL DEFAULT '0',
  `id_operator` int(10) unsigned NOT NULL DEFAULT '0',
  `count` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

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

--
-- Структура таблицы `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `uid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `site_name` varchar(50) NOT NULL DEFAULT '',
  `link` varchar(50) NOT NULL DEFAULT '',
  `admin` varchar(155) NOT NULL DEFAULT '',
  `email` varchar(30) NOT NULL DEFAULT '',
  `info` varchar(200) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `date` int(10) unsigned NOT NULL DEFAULT '0',
  `pass` varchar(50) NOT NULL DEFAULT '',
  `type` int(1) unsigned NOT NULL DEFAULT '2',
  `typeStat` int(1) unsigned NOT NULL DEFAULT '1',
  `cat_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

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

--
-- Структура таблицы `users_reg`
--

CREATE TABLE IF NOT EXISTS `users_reg` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `admin` varchar(255) NOT NULL DEFAULT '',
  `email` varchar(255) NOT NULL DEFAULT '',
  `pass` varchar(255) NOT NULL DEFAULT '',
  `ext` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

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

--
-- Структура таблицы `user_agents`
--

CREATE TABLE IF NOT EXISTS `user_agents` (
  `id_phone` int(11) NOT NULL AUTO_INCREMENT,
  `vendor` varchar(64) NOT NULL DEFAULT '',
  `model` varchar(64) NOT NULL DEFAULT '',
  `ua` varchar(255) NOT NULL DEFAULT '',
  `wap` tinyint(3) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`id_phone`),
  KEY `vendor` (`vendor`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

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

--
-- Структура таблицы `weeks`
--

CREATE TABLE IF NOT EXISTS `weeks` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `next_mon` int(10) unsigned NOT NULL DEFAULT '0',
  `date` int(10) unsigned NOT NULL DEFAULT '0',
  `day_week` smallint(5) unsigned NOT NULL DEFAULT '0',
  `count` int(10) unsigned NOT NULL DEFAULT '0',
  `host` int(10) unsigned NOT NULL DEFAULT '0',
  `in` int(10) unsigned NOT NULL DEFAULT '0',
  `out` int(10) unsigned NOT NULL DEFAULT '0',
  `Siemens` int(10) unsigned NOT NULL DEFAULT '0',
  `Nokia` int(10) unsigned NOT NULL DEFAULT '0',
  `Samsung` int(10) unsigned NOT NULL DEFAULT '0',
  `Motorola` int(10) unsigned NOT NULL DEFAULT '0',
  `LG` int(10) unsigned NOT NULL DEFAULT '0',
  `Sagem` int(10) unsigned NOT NULL DEFAULT '0',
  `SonyEricsson` int(10) unsigned NOT NULL DEFAULT '0',
  `Alcatel` int(10) unsigned NOT NULL DEFAULT '0',
  `Sharp` int(10) unsigned NOT NULL DEFAULT '0',
  `Pantech` int(10) unsigned NOT NULL DEFAULT '0',
  `Panasonic` int(10) unsigned NOT NULL DEFAULT '0',
  `Other` int(10) unsigned NOT NULL DEFAULT '0',
  `cat_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=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 */;