Файл: db_auxe.sql
Строк: 98
DROP TABLE IF EXISTS `cat_smiles`;
CREATE TABLE `cat_smiles` (
`id`
int(11) NOT NULL AUTO_INCREMENT,
`name` char(20) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF
EXISTS `elfinder_file`;
CREATE TABLE `elfinder_file` (
`id` int(7)
unsigned NOT NULL AUTO_INCREMENT,
`parent_id` int(7) unsigned NOT NULL,
`name` varchar(256) NOT NULL,
`content` longblob NOT NULL,
`size`
int(10) unsigned NOT NULL DEFAULT '0',
`mtime` int(10) unsigned NOT
NULL,
`mime` varchar(256) NOT NULL DEFAULT 'unknown',
`read`
enum('1','0') NOT NULL DEFAULT '1',
`write` enum('1','0') NOT NULL
DEFAULT '1',
`locked` enum('1','0') NOT NULL DEFAULT '0',
`hidden`
enum('1','0') NOT NULL DEFAULT '0',
`width` int(5) NOT NULL,
`height`
int(5) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `parent_name`
(`parent_id`,`name`),
KEY `parent_id` (`parent_id`)
) ENGINE=MyISAM
AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
INSERT INTO elfinder_file
VALUES("1","0","DATABASE","","0","0","directory","1","1","0","0","0","0");
DROP
TABLE IF EXISTS `guests`;
CREATE TABLE `guests` (
`ip` bigint(20) NOT
NULL,
`ua` char(32) NOT NULL,
`date_aut` int(11) NOT NULL,
`date_last` int(11) NOT NULL,
`url` char(64) NOT NULL,
`pereh` int(11)
NOT NULL DEFAULT '0',
KEY `ip_2` (`ip`,`ua`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;
INSERT INTO guests
VALUES("1347678005","Mozilla/5.0","1385380117","1385381212","","2");
INSERT
INTO guests
VALUES("1385291253","Mozilla/5.0","1385392153","1385392153","","0");
INSERT
INTO guests
VALUES("1385291224","Mozilla/5.0","1385415931","1385425062","","16");
INSERT
INTO guests
VALUES("1123633553","Mozilla/5.0","1385426385","1388880129","","3");
INSERT
INTO guests
VALUES("1347677704","Mozilla/5.0","1385439392","1385463282","","11");
INSERT
INTO guests
VALUES("1056545910","Mozilla/5.0","1385455081","1387174689","","7");
INSERT
INTO guests
VALUES("1385291316","Mozilla/5.0","1385499633","1385500211","","1");
INSERT
INTO guests
VALUES("1347678059","Mozilla/5.0","1385520418","1385526735","","7");
INSERT
INTO guests
VALUES("1123634179","Mozilla/5.0","1385525073","1389293376","","11");
INSERT
INTO guests
VALUES("1123634321","SAMSUNG-SGH-E250/1.0","1385540626","1388536746","","7");
INSERT
INTO guests
VALUES("1385290871","Mozilla/5.0","1385611113","1385611113","","0");
INSERT
INTO guests
VALUES("1347677808","Mozilla/5.0","1385614563","1385615993","","13");
INSERT
INTO guests
VALUES("1123634785","SAMSUNG-SGH-E250/1.0","1385701619","1386537459","","3");
INSERT
INTO guests
VALUES("1123634785","Mozilla/5.0","1385725975","1389574330","","4");
INSERT
INTO guests
VALUES("3648409910","Mozilla/5.0","1385818224","1385819084","","4");
INSERT
INTO guests
VALUES("1123634695","Mozilla/5.0","1385922010","1389555403","","3");
INSERT
INTO guests
VALUES("3633385102","Mozilla/5.0","1386004426","1386004426","","0");
INSERT
INTO guests
VALUES("1347677968","Mozilla/5.0","1386036111","1386036111","","0");
INSERT
INTO guests
VALUES("1123633983","SAMSUNG-SGH-E250/1.0","1386048466","1389067389","","1");
INSERT
INTO guests
VALUES("1347678032","Mozilla/5.0","1386062408","1386062408","","0");
INSERT
INTO guests
VALUES("1385291025","Mozilla/5.0","1386107612","1386107612","","0");
INSERT
INTO guests
VALUES("1123631679","SAMSUNG-SGH-E250/1.0","1386219234","1389213624","","2");
INSERT
INTO guests
VALUES("3105535071","Mozilla/5.0","1386836985","1386838867","","2");
INSERT
INTO guests
VALUES("1427814538","Mozilla/5.0","1386837839","1386837839","","0");
INSERT
INTO guests
VALUES("2959881491","Mozilla/5.0","1386837849","1386837861","","2");
INSERT
INTO guests
VALUES("1385291396","Mozilla/5.0","1386837894","1386837962","","1");
INSERT
INTO guests
VALUES("1385291101","Mozilla/5.0","1386837945","1386837945","","0");
INSERT
INTO guests
VALUES("1385288325","Opera/9.80","1386837997","1386837997","","0");
INSERT
INTO guests
VALUES("3648409361","Mozilla/5.0","1386838005","1387522682","","4");
INSERT
INTO guests
VALUES("1385290826","Mozilla/5.0","1386838048","1386838048","","0");
INSERT
INTO guests
VALUES("630697478","Opera/9.80","1386838394","1386838433","","1");
INSERT
INTO guests
VALUES("1385291272","Opera/9.80","1386838627","1386838627","","0");
INSERT
INTO guests
VALUES("3162673698","Mozilla/5.0","1386838749","1386838749","","0");
INSERT
INTO guests
VALUES("1433663693","Mozilla/5.0","1386838811","1386838811","","0");
INSERT
INTO guests
VALUES("3154159421","Mozilla/5.0","1386838833","1386838844","","2");
INSERT
INTO guests
VALUES("1347678063","Mozilla/5.0","1386838880","1386838880","","0");
INSERT
INTO guests
VALUES("1603914178","Mozilla/5.0","1386839024","1386839024","","0");
INSERT
INTO guests
VALUES("1385291337","Mozilla/5.0","1386839227","1386839227","","0");
INSERT
INTO guests
VALUES("1385288090","LG-GM360","1386839488","1386839488","","0");
INSERT
INTO guests
VALUES("622061928","Opera/9.80","1386839513","1386839513","","0");
INSERT
INTO guests
VALUES("1295292488","Opera/9.80","1386840143","1386840143","","0");
INSERT
INTO guests
VALUES("1385290368","NokiaX2-00","1386840237","1386840237","","0");
INSERT
INTO guests
VALUES("1385287920","Mozilla/5.0","1386841046","1386841046","","0");
INSERT
INTO guests
VALUES("1123634321","Mozilla/5.0","1387016015","1388426200","","2");
INSERT
INTO guests
VALUES("1089906130","Mozilla/5.0","1387117250","1387117250","","0");
INSERT
INTO guests
VALUES("1385290772","Mozilla/5.0","1387229064","1387229064","","0");
INSERT
INTO guests
VALUES("1385290774","Nokia6120c","1387247172","1387247172","","0");
INSERT
INTO guests
VALUES("1347677745","Mozilla/5.0","1387280438","1387280438","","0");
INSERT
INTO guests
VALUES("1123633411","Mozilla/5.0","1387444342","1387444342","","0");
INSERT
INTO guests
VALUES("1385291281","Mozilla/5.0","1387509487","1387509487","","0");
INSERT
INTO guests
VALUES("1385290105","Nokia2710c-2/2.0","1387521777","1387521777","","0");
INSERT
INTO guests
VALUES("1385290904","Mozilla/5.0","1387521795","1387521795","","0");
INSERT
INTO guests
VALUES("86884429","Mozilla/5.0","1387521898","1387521898","","0");
INSERT
INTO guests
VALUES("1385289924","Opera/9.80","1387521932","1387521932","","0");
INSERT
INTO guests
VALUES("1053668806","Mozilla/5.0","1387521945","1387521976","","2");
INSERT
INTO guests
VALUES("1427814539","Mozilla/5.0","1387522005","1387522005","","0");
INSERT
INTO guests
VALUES("1385291413","Mozilla/5.0","1387522286","1387522286","","0");
INSERT
INTO guests
VALUES("1385291088","Opera/9.80","1387522522","1387522522","","0");
INSERT
INTO guests
VALUES("785613772","Mozilla/5.0","1387523114","1387523114","","0");
INSERT
INTO guests
VALUES("1385289800","LG-A155/V100","1387523170","1387523170","","0");
INSERT
INTO guests
VALUES("1385287944","Mozilla/5.0","1387523625","1387523625","","0");
INSERT
INTO guests
VALUES("3154158376","Mozilla/5.0","1387524878","1387524911","","2");
INSERT
INTO guests
VALUES("3582304882","Opera/9.80","1387525881","1387525881","","0");
INSERT
INTO guests
VALUES("1385290267","Mozilla/5.0","1387660475","1387660475","","0");
INSERT
INTO guests
VALUES("1385288311","SAMSUNG-GT-S5292","1387660890","1387660890","","0");
INSERT
INTO guests
VALUES("1385288269","Mozilla/5.0","1387661065","1387661074","","1");
INSERT
INTO guests
VALUES("624307819","Mozilla/5.0","1387661142","1387661142","","0");
INSERT
INTO guests
VALUES("2006160061","Mozilla/4.0","1387661146","1387661146","","0");
INSERT
INTO guests
VALUES("3105535066","Mozilla/5.0","1387661187","1387661187","","0");
INSERT
INTO guests
VALUES("3283974926","NokiaC2-00/2.0","1387661547","1387661547","","0");
INSERT
INTO guests
VALUES("1385288052","Mozilla/5.0","1387661907","1387661907","","0");
INSERT
INTO guests
VALUES("1385290845","Mozilla/5.0","1387661996","1387661996","","0");
INSERT
INTO guests
VALUES("2365589609","LG-KP500","1387662072","1387662072","","0");
INSERT
INTO guests
VALUES("1385289851","Opera/9.80","1387662546","1387662546","","0");
INSERT
INTO guests
VALUES("1385287846","NokiaN73-1/3.0638.0.0.","1387662912","1387662912","","0");
INSERT
INTO guests
VALUES("1592243274","Mozilla/5.0","1387663311","1387663311","","0");
INSERT
INTO guests
VALUES("1385291233","Mozilla/5.0","1387663326","1387663326","","0");
INSERT
INTO guests
VALUES("1602588716","Mozilla/5.0","1387663943","1387663943","","0");
INSERT
INTO guests
VALUES("1385290509","Mozilla/5.0","1387664036","1387664036","","0");
INSERT
INTO guests
VALUES("1315944984","Opera/9.80","1387667577","1387667577","","0");
INSERT
INTO guests
VALUES("1385290851","Mozilla/5.0","1388150433","1388150433","","0");
INSERT
INTO guests
VALUES("1089905086","Mozilla/5.0","1388508666","1388508666","","0");
INSERT
INTO guests
VALUES("1123633553","SAMSUNG-SGH-E250/1.0","1388724950","1388869796","","1");
INSERT
INTO guests
VALUES("1385291111","Mozilla/5.0","1389087056","1389087056","","0");
INSERT
INTO guests
VALUES("3103990282","Mozilla/5.0","1389396798","1389396798","","0");
INSERT
INTO guests
VALUES("86884438","Mozilla/5.0","1389460400","1389460466","","1");
INSERT
INTO guests
VALUES("1385291064","Mozilla/5.0","1389623896","1389624632","","1");
INSERT
INTO guests
VALUES("86884432","Mozilla/5.0","1389624742","1389625204","","2");
DROP
TABLE IF EXISTS `ignor`;
CREATE TABLE `ignor` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`user_id` int(11) NOT NULL DEFAULT '0',
`ig_id` int(11)
NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;
DROP TABLE IF EXISTS `news`;
CREATE TABLE `news` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` char(255) NOT NULL,
`content` text NOT NULL,
`edit` char(20) NOT NULL,
`look` int(11) NOT
NULL DEFAULT '0',
`date` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY
(`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
INSERT INTO
news
VALUES("1","Открытие!!","Открытие
нашего хостинга для мобильных
телефонов!","","6","1371123749");
DROP
TABLE IF EXISTS `prodlenie`;
CREATE TABLE `prodlenie` (
`id` int(11) NOT
NULL AUTO_INCREMENT,
`kto` varchar(30) NOT NULL DEFAULT '',
`chp`
varchar(5) NOT NULL DEFAULT '0',
`st` varchar(5) NOT NULL DEFAULT '0',
`date` varchar(15) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
)
ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS
`reklama`;
CREATE TABLE `reklama` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`link` char(100) NOT NULL,
`name` char(25) NOT NULL,
`look` tinyint(1) NOT NULL DEFAULT '0',
`who` int(11) NOT NULL DEFAULT
'10',
`srok` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
)
ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8
ROW_FORMAT=DYNAMIC;
INSERT INTO reklama
VALUES("1","gferma.tk","Ферма!","0","0","5");
DROP
TABLE IF EXISTS `smiles`;
CREATE TABLE `smiles` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`name` char(30) NOT NULL DEFAULT '0',
`path` char(30)
NOT NULL DEFAULT '0',
`cat` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS
`support`;
CREATE TABLE `support` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`kto` varchar(30) NOT NULL DEFAULT '',
`vopros`
varchar(250) NOT NULL DEFAULT '',
`otvet` varchar(250) NOT NULL DEFAULT
'',
`status` varchar(2) NOT NULL DEFAULT '0',
`date` varchar(15) NOT
NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=utf8;
DROP TABLE IF EXISTS `tarif`;
CREATE TABLE `tarif` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(30) NOT NULL DEFAULT
'',
`a` varchar(5) NOT NULL DEFAULT '',
`b` varchar(5) NOT NULL DEFAULT
'',
`v` varchar(5) NOT NULL DEFAULT '',
`g` varchar(5) NOT NULL DEFAULT
'',
`d` varchar(5) NOT NULL DEFAULT '',
`e` varchar(5) NOT NULL DEFAULT
'',
`zh` varchar(5) NOT NULL DEFAULT '',
`z` varchar(5) NOT NULL
DEFAULT '',
`i` varchar(5) NOT NULL DEFAULT '',
`k` varchar(5) NOT NULL
DEFAULT '',
`l` varchar(5) NOT NULL DEFAULT '',
`m` varchar(5) NOT NULL
DEFAULT '',
`n` varchar(5) NOT NULL DEFAULT '',
`o` varchar(5) NOT NULL
DEFAULT '',
`pr` varchar(5) NOT NULL DEFAULT '',
`rekl` varchar(5) NOT
NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3
DEFAULT CHARSET=utf8;
INSERT INTO tarif
VALUES("1","HDD-1","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0");
DROP
TABLE IF EXISTS `users`;
CREATE TABLE `users` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`login` varchar(15) NOT NULL DEFAULT '',
`pass`
varchar(15) NOT NULL DEFAULT '',
`sex` int(11) NOT NULL DEFAULT '0',
`email` varchar(30) NOT NULL DEFAULT '',
`tarif` varchar(40) NOT NULL
DEFAULT '',
`srok` varchar(2) NOT NULL DEFAULT '',
`summa` varchar(5)
NOT NULL DEFAULT '',
`date` varchar(15) NOT NULL DEFAULT '',
`status`
varchar(1) NOT NULL DEFAULT '0',
`opld` varchar(20) NOT NULL DEFAULT
'0',
`serv` varchar(50) NOT NULL DEFAULT '',
`serv_log` varchar(50) NOT
NULL DEFAULT '',
`serv_pass` varchar(50) NOT NULL DEFAULT '',
`sn`
varchar(5) NOT NULL DEFAULT '',
`bsn` varchar(5) NOT NULL DEFAULT '',
`ip` int(11) NOT NULL DEFAULT '0',
`onl` int(11) NOT NULL DEFAULT '0',
`user_soft` char(200) NOT NULL DEFAULT '',
`user_ip` char(20) NOT NULL
DEFAULT '',
`date_last` int(11) NOT NULL DEFAULT '0',
`on_time` int(11)
NOT NULL DEFAULT '0',
`latuser` char(30) NOT NULL DEFAULT '',
`visit`
char(20) NOT NULL,
`room` char(10) NOT NULL DEFAULT '',
`mod_reg`
smallint(2) NOT NULL DEFAULT '0',
`level` int(11) NOT NULL DEFAULT '0',
`web` smallint(1) DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB
AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
INSERT INTO users
VALUES("1","Admin","123123","2","kotvickiy1997@list.ru","1","1","30","27.11.13","1","0","","","","0","0","0","1389625777","Mozilla/5.0","86884432","0","5144","","13/01/14
19:09","main","1","3","0");