DROP TABLE IF EXISTS `cat`;

CREATE TABLE `cat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL,
  `about` varchar(80) NOT NULL,
  `position` int(3) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=91213 DEFAULT CHARSET=cp1251;

INSERT INTO `cat` VALUES("1","Общение","Общение - сайты, форумы, общения для мобильных","1");
INSERT INTO `cat` VALUES("2","Бизнес","Бизнес - все для бизнеса заработка в сети","2");
INSERT INTO `cat` VALUES("3","Загрузки","Загрузки - мобильные сайты бесплатных загрузок","3");
INSERT INTO `cat` VALUES("4","Знакомства","Знакомства - сайты знакомств для мобильных","4");
INSERT INTO `cat` VALUES("5","Сервисы, услуги","Сервисы, услуги - сайты мобильных сервисов, услуг","5");
INSERT INTO `cat` VALUES("6","Для взрослых","Для взрослых - ххх загрузки для телефона, эротика, порно, 18+","6");
INSERT INTO `cat` VALUES("7","Развлечения","Развлечения - сайты мобильных развлечений, игры, викторины, конкурсы","7");
INSERT INTO `cat` VALUES("8","Информационные","Информационные - информационные мобильные сайты, новости","8");
INSERT INTO `cat` VALUES("9","Музыка","Музыка - мобильные сайты с музыкой, загрузка музыки на телефон","9");
INSERT INTO `cat` VALUES("10","Спорт","Спор - все о спорте, новости спорта, мобильные спортивные сайты","10");
INSERT INTO `cat` VALUES("11","Кино","Кино - мобильные кино порталы, фильмы, видео, мультфильмы","11");
INSERT INTO `cat` VALUES("12","Халява","Халява - мобильные cайты с играми и программами на телефон, планшет, смартфон","12");
INSERT INTO `cat` VALUES("13","Прочие","Прочие - сайты без категории","13");



DROP TABLE IF EXISTS `hits`;

CREATE TABLE `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=cp1251;

INSERT INTO `hits` VALUES("1","1494585168","192.241.204.127","Mozilla","0");
INSERT INTO `hits` VALUES("1","1494585175","192.241.204.127","Mozilla","0");
INSERT INTO `hits` VALUES("1","1494585202","192.241.204.127","Mozilla","0");
INSERT INTO `hits` VALUES("1","1494585220","192.241.204.127","Mozilla","0");
INSERT INTO `hits` VALUES("1","1494585232","192.241.204.127","Mozilla","0");
INSERT INTO `hits` VALUES("1","1494585238","192.241.204.127","Mozilla","0");
INSERT INTO `hits` VALUES("1","1494585247","192.241.204.127","Mozilla","0");
INSERT INTO `hits` VALUES("1","1494585249","192.241.204.127","Mozilla","0");
INSERT INTO `hits` VALUES("3","1494585302","192.241.204.127","Mozilla","0");
INSERT INTO `hits` VALUES("4","1494585328","192.241.204.127","Mozilla","0");



DROP TABLE IF EXISTS `hosts`;

CREATE TABLE `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=cp1251;

INSERT INTO `hosts` VALUES("1","1494585168","192.241.204.127","Mozilla","0");
INSERT INTO `hosts` VALUES("3","1494585302","192.241.204.127","Mozilla","0");
INSERT INTO `hosts` VALUES("4","1494585328","192.241.204.127","Mozilla","0");



DROP TABLE IF EXISTS `online`;

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

INSERT INTO `online` VALUES("82.145.222.52","Mozilla","1494591587");
INSERT INTO `online` VALUES("213.230.78.231","Mozilla","1494591821");
INSERT INTO `online` VALUES("82.145.220.250","Opera","1494591631");
INSERT INTO `online` VALUES("95.108.133.216","Mozilla","1494591575");
INSERT INTO `online` VALUES("217.118.83.166","Mozilla","1494591800");



DROP TABLE IF EXISTS `sait`;

CREATE TABLE `sait` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_user` int(11) NOT NULL,
  `id_mod` int(11) NOT NULL,
  `name` varchar(35) 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,
  `hits8` int(11) NOT NULL,
  `hits9` int(11) NOT NULL,
  `hits10` int(11) NOT NULL,
  `hits11` int(11) NOT NULL,
  `hits12` int(11) NOT NULL,
  `hits13` int(11) NOT NULL,
  `hits14` int(11) NOT NULL,
  `hits15` int(11) NOT NULL,
  `hits16` int(11) NOT NULL,
  `hits17` int(11) NOT NULL,
  `hits18` int(11) NOT NULL,
  `hits19` int(11) NOT NULL,
  `hits20` int(11) NOT NULL,
  `hits21` int(11) NOT NULL,
  `hits22` int(11) NOT NULL,
  `hits23` int(11) NOT NULL,
  `hits24` int(11) NOT NULL,
  `hits25` int(11) NOT NULL,
  `hits26` int(11) NOT NULL,
  `hits27` int(11) NOT NULL,
  `hits28` int(11) NOT NULL,
  `hits29` int(11) NOT NULL,
  `hits30` 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,
  `hosts8` int(11) NOT NULL,
  `hosts9` int(11) NOT NULL,
  `hosts10` int(11) NOT NULL,
  `hosts11` int(11) NOT NULL,
  `hosts12` int(11) NOT NULL,
  `hosts13` int(11) NOT NULL,
  `hosts14` int(11) NOT NULL,
  `hosts15` int(11) NOT NULL,
  `hosts16` int(11) NOT NULL,
  `hosts17` int(11) NOT NULL,
  `hosts18` int(11) NOT NULL,
  `hosts19` int(11) NOT NULL,
  `hosts20` int(11) NOT NULL,
  `hosts21` int(11) NOT NULL,
  `hosts22` int(11) NOT NULL,
  `hosts23` int(11) NOT NULL,
  `hosts24` int(11) NOT NULL,
  `hosts25` int(11) NOT NULL,
  `hosts26` int(11) NOT NULL,
  `hosts27` int(11) NOT NULL,
  `hosts28` int(11) NOT NULL,
  `hosts29` int(11) NOT NULL,
  `hosts30` 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,
  `in8` int(11) NOT NULL,
  `in9` int(11) NOT NULL,
  `in10` int(11) NOT NULL,
  `in11` int(11) NOT NULL,
  `in12` int(11) NOT NULL,
  `in13` int(11) NOT NULL,
  `in14` int(11) NOT NULL,
  `in15` int(11) NOT NULL,
  `in16` int(11) NOT NULL,
  `in17` int(11) NOT NULL,
  `in18` int(11) NOT NULL,
  `in19` int(11) NOT NULL,
  `in20` int(11) NOT NULL,
  `in21` int(11) NOT NULL,
  `in22` int(11) NOT NULL,
  `in23` int(11) NOT NULL,
  `in24` int(11) NOT NULL,
  `in25` int(11) NOT NULL,
  `in26` int(11) NOT NULL,
  `in27` int(11) NOT NULL,
  `in28` int(11) NOT NULL,
  `in29` int(11) NOT NULL,
  `in30` 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,
  `out8` int(11) NOT NULL,
  `out9` int(11) NOT NULL,
  `out10` int(11) NOT NULL,
  `out11` int(11) NOT NULL,
  `out12` int(11) NOT NULL,
  `out13` int(11) NOT NULL,
  `out14` int(11) NOT NULL,
  `out15` int(11) NOT NULL,
  `out16` int(11) NOT NULL,
  `out17` int(11) NOT NULL,
  `out18` int(11) NOT NULL,
  `out19` int(11) NOT NULL,
  `out20` int(11) NOT NULL,
  `out21` int(11) NOT NULL,
  `out22` int(11) NOT NULL,
  `out23` int(11) NOT NULL,
  `out24` int(11) NOT NULL,
  `out25` int(11) NOT NULL,
  `out26` int(11) NOT NULL,
  `out27` int(11) NOT NULL,
  `out28` int(11) NOT NULL,
  `out29` int(11) NOT NULL,
  `out30` 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,
  `auto_del` int(1) NOT NULL,
  `count` int(9) NOT NULL,
  `gold` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=cp1251;

INSERT INTO `sait` VALUES("1","1","0","","Мобильный ФТП менеджер сайтов","1494526288","0","131","123","123","123","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","124","123","123","123","123","123","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","131","124","127","123","123","123","0","0","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","0","0","0","0","0","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","11","5","1","1","theftp.ru","1","0","0","","0","0","0","0","1594574138");
INSERT INTO `sait` VALUES("2","1","0","","сайт ямуса xD","1494526400","0","123","231","2147483647","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","1231231","32112321","11312","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","25","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","25","5","1","1","byamus.ru","1","0","0","","0","0","0","2","0");
INSERT INTO `sait` VALUES("3","1","0","","Этот топ рейтинг","1494585004","0","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","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","1","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","7","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","7","1","1","1","dizmas.ga","1","0","0","","0","0","0","0","2147483647");
INSERT INTO `sait` VALUES("4","1","0","","Бесплатные загрузки","1494585321","0","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","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","1","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","18","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","18","3","1","1","gruzee.ru","1","0","0","","0","0","0","0","2147483647");



DROP TABLE IF EXISTS `sait_online`;

CREATE TABLE `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=cp1251;

INSERT INTO `sait_online` VALUES("1","192.241.204.127","Mozilla","1494585249");
INSERT INTO `sait_online` VALUES("3","192.241.204.127","Mozilla","1494585302");
INSERT INTO `sait_online` VALUES("4","192.241.204.127","Mozilla","1494585328");



DROP TABLE IF EXISTS `settings`;

CREATE TABLE `settings` (
  `name` varchar(60) NOT NULL,
  `value` varchar(60) NOT NULL,
  PRIMARY KEY (`name`,`value`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

INSERT INTO `settings` VALUES("auto_moderacia","0");
INSERT INTO `settings` VALUES("home","dizmas.ga");
INSERT INTO `settings` VALUES("mail","admin@top.ru");
INSERT INTO `settings` VALUES("max_platforms","10");
INSERT INTO `settings` VALUES("moderacia","1");
INSERT INTO `settings` VALUES("pages","10");
INSERT INTO `settings` VALUES("page_moderacia","10");
INSERT INTO `settings` VALUES("page_platforms","10");
INSERT INTO `settings` VALUES("page_sait","10");
INSERT INTO `settings` VALUES("page_top","10");
INSERT INTO `settings` VALUES("page_users","10");
INSERT INTO `settings` VALUES("power_reg","1");
INSERT INTO `settings` VALUES("top_name","SEX в большом городе");



DROP TABLE IF EXISTS `users`;

CREATE TABLE `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,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=cp1251;

INSERT INTO `users` VALUES("1","1494522753","Admin","123000","asd@asd.ru","3","10","10","10","10","0");



