Просмотр архива Топ o5on.ru

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