Просмотр файла base.sql

-- phpMyAdmin SQL Dump
-- version 2.6.1
-- http://www.phpmyadmin.net
-- 
-- Хост: localhost
-- Время создания: Сен 30 2008 г., 18:42
-- Версия сервера: 4.1.16
-- Версия PHP: 4.4.4
-- 
-- БД: `waplog`
-- 
 
-- --------------------------------------------------------
 
-- 
-- Структура таблицы `ban_user`
-- 
 
CREATE TABLE `ban_user` (
  `uid` int(10) unsigned NOT NULL default '0',
  `link` varchar(35) NOT NULL default '',
  PRIMARY KEY  (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
 
-- 
-- Дамп данных таблицы `ban_user`
-- 
 
 
-- --------------------------------------------------------
 
-- 
-- Структура таблицы `count_24`
-- 
 
CREATE TABLE `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 ;
 
-- 
-- Дамп данных таблицы `count_24`
-- 
 
 
-- --------------------------------------------------------
 
-- 
-- Структура таблицы `hits_ip`
-- 
 
CREATE TABLE `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_ip`
-- 
 
 
-- --------------------------------------------------------
 
-- 
-- Структура таблицы `hits_time`
-- 
 
CREATE TABLE `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;
 
-- 
-- Дамп данных таблицы `hits_time`
-- 
 
 
-- --------------------------------------------------------
 
-- 
-- Структура таблицы `models_data`
-- 
 
CREATE TABLE `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;
 
-- 
-- Дамп данных таблицы `models_data`
-- 
 
 
-- --------------------------------------------------------
 
-- 
-- Структура таблицы `months`
-- 
 
CREATE TABLE `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 ;
 
-- 
-- Дамп данных таблицы `months`
-- 
 
 
-- --------------------------------------------------------
 
-- 
-- Структура таблицы `online_ip`
-- 
 
CREATE TABLE `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;
 
-- 
-- Дамп данных таблицы `online_ip`
-- 
 
 
-- --------------------------------------------------------
 
-- 
-- Структура таблицы `razdels`
-- 
 
CREATE TABLE `razdels` (
  `id` int(2) NOT NULL auto_increment,
  `name` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
 
-- 
-- Дамп данных таблицы `razdels`
-- 
 
 
-- --------------------------------------------------------
 
-- 
-- Структура таблицы `superadmin`
-- 
 
CREATE TABLE `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=2 ;
 
-- 
-- Дамп данных таблицы `superadmin`
-- 
 
INSERT INTO `superadmin` VALUES (1, 'Admin', '12345');
 
-- --------------------------------------------------------
 
-- 
-- Структура таблицы `top_ip`
-- 
 
CREATE TABLE `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_ip`
-- 
 
INSERT INTO `top_ip` VALUES (1, 1402273792, 1402275839);
INSERT INTO `top_ip` VALUES (2, 1402277888, 1402278911);
INSERT INTO `top_ip` VALUES (3, 1402279936, 1402280959);
INSERT INTO `top_ip` VALUES (4, 1402281984, 1402283007);
INSERT INTO `top_ip` VALUES (5, 1402284032, 1402285055);
INSERT INTO `top_ip` VALUES (6, 1402286080, 1402287103);
INSERT INTO `top_ip` VALUES (7, 1402287104, 1402288127);
INSERT INTO `top_ip` VALUES (8, 3251233792, 3251234815);
INSERT INTO `top_ip` VALUES (9, 3582031776, 3582031807);
INSERT INTO `top_ip` VALUES (10, 1427812352, 1427813375);
INSERT INTO `top_ip` VALUES (11, 1402278912, 1402279935);
INSERT INTO `top_ip` VALUES (12, 1346621440, 1346622463);
INSERT INTO `top_ip` VALUES (13, 1402275840, 1402276863);
INSERT INTO `top_ip` VALUES (14, 1433657344, 1433657599);
INSERT INTO `top_ip` VALUES (15, 3648405504, 3648406527);
INSERT INTO `top_ip` VALUES (16, 3648406528, 3648407551);
INSERT INTO `top_ip` VALUES (17, 3648408576, 3648409599);
INSERT INTO `top_ip` VALUES (18, 3648409600, 3648410623);
INSERT INTO `top_ip` VALUES (19, 3648410624, 3648411647);
INSERT INTO `top_ip` VALUES (20, 3648411648, 3648412671);
INSERT INTO `top_ip` VALUES (21, 3648412672, 3648413695);
INSERT INTO `top_ip` VALUES (22, 1047070464, 1047072255);
INSERT INTO `top_ip` VALUES (23, 1401450496, 1401450751);
INSERT INTO `top_ip` VALUES (24, 1401451520, 1401451775);
INSERT INTO `top_ip` VALUES (25, 1425981440, 1425997823);
INSERT INTO `top_ip` VALUES (26, 1441366016, 1441371903);
INSERT INTO `top_ip` VALUES (27, 1494507776, 1494508031);
INSERT INTO `top_ip` VALUES (28, 3272364544, 3272364799);
INSERT INTO `top_ip` VALUES (29, 3564675072, 3564675583);
INSERT INTO `top_ip` VALUES (30, 3564676832, 3564676863);
INSERT INTO `top_ip` VALUES (31, 3571187712, 3571191807);
INSERT INTO `top_ip` VALUES (32, 3641816064, 3641816319);
INSERT INTO `top_ip` VALUES (33, 3641816576, 3641816831);
INSERT INTO `top_ip` VALUES (34, 1347599104, 1347599359);
INSERT INTO `top_ip` VALUES (35, 3588519936, 3588520063);
INSERT INTO `top_ip` VALUES (36, 1360163840, 1360164351);
INSERT INTO `top_ip` VALUES (37, 1360162816, 1360166911);
INSERT INTO `top_ip` VALUES (38, 3274599168, 3274599423);
INSERT INTO `top_ip` VALUES (39, 3283979776, 3283980287);
INSERT INTO `top_ip` VALUES (40, 3242554368, 3242554495);
INSERT INTO `top_ip` VALUES (41, 1357411584, 1357411839);
INSERT INTO `top_ip` VALUES (42, 3588390912, 3588391935);
INSERT INTO `top_ip` VALUES (43, 3274702592, 3274702847);
INSERT INTO `top_ip` VALUES (44, 3253698560, 3253699071);
INSERT INTO `top_ip` VALUES (45, 3650368512, 3650368767);
INSERT INTO `top_ip` VALUES (46, 3650367488, 3650368511);
INSERT INTO `top_ip` VALUES (47, 3278955480, 3278955515);
INSERT INTO `top_ip` VALUES (48, 3278956288, 3278956543);
INSERT INTO `top_ip` VALUES (49, 3278960128, 3278960383);
INSERT INTO `top_ip` VALUES (50, 3648294912, 3648295935);
INSERT INTO `top_ip` VALUES (51, 1481787392, 1481787647);
INSERT INTO `top_ip` VALUES (52, 3652001536, 3652001599);
INSERT INTO `top_ip` VALUES (53, 1506762752, 1506764799);
INSERT INTO `top_ip` VALUES (54, 1052193280, 1052193535);
INSERT INTO `top_ip` VALUES (55, 1347125248, 1347125759);
INSERT INTO `top_ip` VALUES (56, 1347126528, 1347127167);
INSERT INTO `top_ip` VALUES (57, 1358118912, 1358119423);
INSERT INTO `top_ip` VALUES (58, 1358119424, 1358120703);
INSERT INTO `top_ip` VALUES (59, 1386348544, 1386414079);
INSERT INTO `top_ip` VALUES (60, 3651751936, 3651752191);
INSERT INTO `top_ip` VALUES (61, 3651752192, 3651752447);
INSERT INTO `top_ip` VALUES (62, 3651755008, 3651756031);
INSERT INTO `top_ip` VALUES (63, 3287244288, 3287244543);
INSERT INTO `top_ip` VALUES (64, 3273026560, 3273027583);
INSERT INTO `top_ip` VALUES (65, 3273026560, 3273027583);
INSERT INTO `top_ip` VALUES (66, 3240705024, 3240706047);
INSERT INTO `top_ip` VALUES (67, 3560612352, 3560612863);
INSERT INTO `top_ip` VALUES (68, 3560612864, 3560613887);
INSERT INTO `top_ip` VALUES (69, 1360467968, 1360470015);
INSERT INTO `top_ip` VALUES (70, 1360465920, 1360467967);
INSERT INTO `top_ip` VALUES (71, 1536286720, 1536294911);
INSERT INTO `top_ip` VALUES (72, 1536278528, 1536286719);
INSERT INTO `top_ip` VALUES (73, 1333559296, 1333592063);
INSERT INTO `top_ip` VALUES (74, 3560615936, 3560620031);
INSERT INTO `top_ip` VALUES (75, 3560611840, 3560612095);
INSERT INTO `top_ip` VALUES (76, 3560613888, 3560615935);
INSERT INTO `top_ip` VALUES (77, 1346736128, 1346737151);
INSERT INTO `top_ip` VALUES (78, 3260286336, 3260286463);
INSERT INTO `top_ip` VALUES (79, 3645731072, 3645731079);
INSERT INTO `top_ip` VALUES (80, 1310210048, 1310211071);
INSERT INTO `top_ip` VALUES (81, 1536099328, 1536099839);
INSERT INTO `top_ip` VALUES (82, 3587219456, 3587219711);
INSERT INTO `top_ip` VALUES (83, 1389383040, 1389383167);
INSERT INTO `top_ip` VALUES (84, 1432330240, 1432334335);
INSERT INTO `top_ip` VALUES (85, 3282161664, 3282163711);
INSERT INTO `top_ip` VALUES (86, 3282171904, 3282173951);
INSERT INTO `top_ip` VALUES (87, 3585171456, 3585174271);
INSERT INTO `top_ip` VALUES (88, 3267008512, 3267008767);
INSERT INTO `top_ip` VALUES (89, 3277992448, 3277992959);
INSERT INTO `top_ip` VALUES (90, 1404862464, 1404870655);
INSERT INTO `top_ip` VALUES (91, 1404846080, 1404854271);
INSERT INTO `top_ip` VALUES (92, 1404854272, 1404862463);
INSERT INTO `top_ip` VALUES (93, 1404837888, 1404846079);
INSERT INTO `top_ip` VALUES (94, 1404829696, 1404837887);
INSERT INTO `top_ip` VALUES (95, 1518927872, 1518944255);
INSERT INTO `top_ip` VALUES (96, 1518993408, 1519058943);
INSERT INTO `top_ip` VALUES (97, 2197028864, 2197094399);
INSERT INTO `top_ip` VALUES (98, 1406740480, 1406746623);
INSERT INTO `top_ip` VALUES (99, 3564593152, 3564593919);
INSERT INTO `top_ip` VALUES (100, 3564595968, 3564596735);
INSERT INTO `top_ip` VALUES (101, 3564599808, 3564601343);
INSERT INTO `top_ip` VALUES (102, 3565248512, 3565250047);
INSERT INTO `top_ip` VALUES (103, 3565250048, 3565250559);
INSERT INTO `top_ip` VALUES (104, 3565250560, 3565254655);
INSERT INTO `top_ip` VALUES (105, 3578853376, 3578854079);
INSERT INTO `top_ip` VALUES (106, 3648212992, 3648217087);
 
-- --------------------------------------------------------
 
-- 
-- Структура таблицы `top_operators`
-- 
 
CREATE TABLE `top_operators` (
  `id` int(10) unsigned NOT NULL default '0',
  `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;
 
-- 
-- Дамп данных таблицы `top_operators`
-- 
 
INSERT INTO `top_operators` VALUES (1, 'Megafon', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (2, 'Megafon', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (3, 'Megafon', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (4, 'Megafon', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (5, 'Megafon', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (6, 'Megafon', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (7, 'Megafon', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (8, 'Megafon', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (9, 'Megafon', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (10, 'Megafon', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (11, 'Megafon', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (12, 'Megafon', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (13, 'Megafon', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (14, 'Beeline', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (15, 'Beeline', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (16, 'Beeline', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (17, 'Beeline', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (18, 'Beeline', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (19, 'Beeline', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (20, 'Beeline', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (21, 'Beeline', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (22, 'Utel', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (23, 'Utel', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (24, 'Utel', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (25, 'Utel', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (26, 'Utel', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (27, 'Utel', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (28, 'Utel', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (29, 'Utel', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (30, 'Utel', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (31, 'Utel', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (32, 'Utel', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (33, 'Utel', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (34, 'BWC', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (35, 'BWC', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (36, 'BWC', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (37, 'BWC', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (38, 'BWC', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (39, 'Opera Mini', '', '', '', 0);
INSERT INTO `top_operators` VALUES (40, 'Opera Mini', '', '', '', 0);
INSERT INTO `top_operators` VALUES (41, 'Opera Mini', '', '', '', 0);
INSERT INTO `top_operators` VALUES (42, 'BITE', '', '', 'LT', 0);
INSERT INTO `top_operators` VALUES (43, 'KCELL', '', '', 'KZ', 0);
INSERT INTO `top_operators` VALUES (44, 'WELLCOM', '', '', 'BL', 0);
INSERT INTO `top_operators` VALUES (45, 'Motiv', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (46, 'Motiv', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (47, 'ЕТК', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (48, 'ЕТК', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (49, 'ЕТК', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (50, 'STEK GSM', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (51, 'Tatinkom-T', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (52, 'Tatinkom-T', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (53, 'Tatinkom-T', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (54, 'MTT', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (55, 'MTT', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (56, 'MTT', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (57, 'НТК', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (58, 'НТК', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (59, 'AKOC', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (60, 'Digital Expansion', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (61, 'Digital Expansion', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (62, 'Digital Expansion', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (63, 'Indigo', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (64, 'Indigo', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (65, 'BASHCELL', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (66, 'KievStar', '', '', 'UA', 0);
INSERT INTO `top_operators` VALUES (67, 'KievStar', '', '', 'UA', 0);
INSERT INTO `top_operators` VALUES (68, 'KievStar', '', '', 'UA', 0);
INSERT INTO `top_operators` VALUES (69, 'KievStar', '', '', 'UA', 0);
INSERT INTO `top_operators` VALUES (70, 'KievStar', '', '', 'UA', 0);
INSERT INTO `top_operators` VALUES (71, 'life:)', '', '', 'UA', 0);
INSERT INTO `top_operators` VALUES (72, 'life:)', '', '', 'UA', 0);
INSERT INTO `top_operators` VALUES (73, 'life:)', '', '', 'UA', 0);
INSERT INTO `top_operators` VALUES (74, 'life:)', '', '', 'UA', 0);
INSERT INTO `top_operators` VALUES (75, 'life:)', '', '', 'UA', 0);
INSERT INTO `top_operators` VALUES (76, 'life:)', '', '', 'UA', 0);
INSERT INTO `top_operators` VALUES (77, 'CMAPTC', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (78, 'CMAPTC', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (79, 'CMAPTC', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (80, 'CMAPTC', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (81, 'CMAPTC', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (82, 'CMAPTC', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (83, 'HCC', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (84, 'HCC', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (85, 'HCC', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (86, 'HCC', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (87, 'HCC', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (88, 'HCC', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (89, 'HCC', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (90, 'TELE2', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (91, 'TELE2', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (92, 'TELE2', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (93, 'TELE2', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (94, 'TELE2', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (95, 'TELE2', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (96, 'TELE2', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (97, 'TELE2', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (98, 'Sky Link', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (99, 'Sky Link', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (100, 'Sky Link', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (101, 'Sky Link', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (102, 'Sky Link', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (103, 'Sky Link', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (104, 'Sky Link', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (105, 'Sky Link', '', '', 'RU', 0);
INSERT INTO `top_operators` VALUES (106, 'Sky Link', '', '', 'RU', 0);
 
-- --------------------------------------------------------
 
-- 
-- Структура таблицы `top_operators_stat`
-- 
 
CREATE TABLE `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=12 ;
 
-- 
-- Дамп данных таблицы `top_operators_stat`
-- 
 
INSERT INTO `top_operators_stat` VALUES (11, 3, 20081006, 20080930, 2, 0, 11);
INSERT INTO `top_operators_stat` VALUES (10, 1, 20081006, 20080930, 2, 0, 85);
 
-- --------------------------------------------------------
 
-- 
-- Структура таблицы `user_agents`
-- 
 
CREATE TABLE `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 ;
 
-- 
-- Дамп данных таблицы `user_agents`
-- 
 
 
-- --------------------------------------------------------
 
-- 
-- Структура таблицы `users`
-- 
 
CREATE TABLE `users` (
  `uid` int(10) unsigned NOT NULL auto_increment,
  `site_name` varchar(50) NOT NULL default '',
  `link` varchar(50) NOT NULL default '',
  `admin` varchar(30) NOT NULL default '',
  `email` varchar(30) NOT NULL default '',
  `info` varchar(200) NOT NULL default '',
  `razdel` int(2) NOT NULL default '1',
  `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',
  PRIMARY KEY  (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
 
-- 
-- Дамп данных таблицы `users`
-- 
 
 
-- --------------------------------------------------------
 
-- 
-- Структура таблицы `weeks`
-- 
 
CREATE TABLE `weeks` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `uid` int(10) unsigned NOT NULL default '0',
  `razdel` int(2) NOT NULL default '1',
  `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',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
 
-- 
-- Дамп данных таблицы `weeks`
--