Файл: baza-yamus.sql
Строк: 245
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=91214 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","WAP мастеру","Для
взрослых - ххх загрузки для телефона,
эротика, порно, 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");
INSERT INTO
`cat` VALUES("14","Новые
сайты","","14");
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;
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;
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;
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',
`skrit` int(1)
NOT NULL DEFAULT '0',
`mob` int(11) NOT NULL,
`pk` int(11) NOT
NULL,
`mob2` text NOT NULL,
`mob30` text NOT NULL,
`pk2` text NOT
NULL,
`pk30` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=cp1251;
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;
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","0");
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","StatOK.Net -
Бесплатные мобильные сайты.");
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
DEFAULT CHARSET=cp1251;
DROP TABLE IF EXISTS
`yamus_gold`;
CREATE TABLE `yamus_gold` (
`id` int(11) unsigned NOT
NULL AUTO_INCREMENT COMMENT 'ID платежа (Внутренний
ID)',
`id_user` int(11) unsigned NOT NULL COMMENT 'ID
пользователя',
`id_bill` int(11) unsigned NOT NULL COMMENT
'ID платежа в Worldkassa',
`time` int(11) unsigned NOT NULL
COMMENT 'Время инициализации платежа',
`time_oplata` int(11) unsigned DEFAULT '0' COMMENT 'Время
оплаты',
`summa` decimal(11,2) NOT NULL DEFAULT '0.00' COMMENT
'Сумма',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
COMMENT='Статистика платежей через
WorldKassa';