Файл: base.sql
Строк: 189
-- phpMyAdmin SQL Dump
-- version 3.5.1
-- http://www.phpmyadmin.net
--
--
Хост: localhost
-- Время создания: Авг 10 2013 г.,
21:25
-- Версия сервера: 5.1.63
-- Версия 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 */;
--
-- База данных: `db1376153494`
--
--
--------------------------------------------------------
--
--
Структура таблицы `files`
--
CREATE TABLE IF NOT EXISTS
`files` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`dir`
enum('0','1') NOT NULL DEFAULT '0',
`dir_count` int(11) unsigned NOT NULL
DEFAULT '0',
`fileid` int(11) NOT NULL,
`path` varchar(255) NOT NULL,
`infolder` varchar(255) NOT NULL,
`name` text NOT NULL,
`rus_name` text
NOT NULL,
`name_ot` text NOT NULL,
`priority` tinyint(3) NOT NULL
DEFAULT '0',
`size` int(11) unsigned NOT NULL,
`loads` int(11) unsigned
NOT NULL DEFAULT '0',
`timeload` int(11) unsigned NOT NULL,
`timeupload` int(11) unsigned NOT NULL,
`ips` text NOT NULL,
`yes`
mediumint(4) unsigned NOT NULL DEFAULT '0',
`no` mediumint(4) unsigned
NOT NULL DEFAULT '0',
`hidden` enum('0','1') NOT NULL DEFAULT '0',
`bt`
enum('0','1','2') NOT NULL,
`3d` enum('0','1','2') NOT NULL,
`god`
varchar(4) NOT NULL,
`lang` varchar(255) NOT NULL,
`country`
varchar(255) NOT NULL,
`vendor` varchar(255) NOT NULL,
`prim`
varchar(255) NOT NULL,
`rejj` varchar(255) NOT NULL,
`akt` text NOT
NULL,
`babki` varchar(255) NOT NULL,
`sbory` varchar(255) NOT NULL,
`kachestvo` varchar(255) NOT NULL,
`trans` varchar(255) NOT NULL,
`3d_dir` varchar(255) NOT NULL,
`bt_dir` varchar(255) NOT NULL,
`top_dir` varchar(255) NOT NULL,
`vendor_dir` varchar(255) NOT NULL,
`alp_dir` varchar(255) NOT NULL,
`new_dir` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `path` (`path`),
KEY `loads` (`loads`),
KEY `yes` (`yes`),
KEY `infolder` (`infolder`),
KEY
`infolder_timeupload` (`infolder`,`timeupload`),
KEY `yes_2` (`yes`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `komments`
--
CREATE TABLE IF NOT EXISTS
`komments` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`file_id`
int(11) unsigned NOT NULL,
`name` varchar(255) NOT NULL,
`text` text
NOT NULL,
`time` int(11) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY
`file_id` (`file_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-- --------------------------------------------------------
--
--
Структура таблицы `loginlog`
--
CREATE TABLE IF NOT EXISTS
`loginlog` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`ua`
varchar(255) NOT NULL,
`ip` varchar(23) NOT NULL,
`time` int(10)
unsigned NOT NULL,
`access_num` tinyint(3) unsigned NOT NULL,
PRIMARY
KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `news`
--
CREATE TABLE IF NOT EXISTS
`news` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`news` text NOT
NULL,
`rus_news` text NOT NULL,
`time` int(11) unsigned NOT NULL
DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `news_komments`
--
CREATE TABLE IF NOT
EXISTS `news_komments` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`id_news` int(11) unsigned NOT NULL,
`text` text NOT NULL,
`name`
varchar(32) NOT NULL,
`time` int(11) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `id_news` (`id_news`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `online`
--
CREATE TABLE IF NOT EXISTS
`online` (
`ip` varchar(23) NOT NULL,
`time` datetime NOT NULL,
UNIQUE KEY `ip` (`ip`)
) ENGINE=MEMORY DEFAULT CHARSET=utf8;
--
--------------------------------------------------------
--
--
Структура таблицы `reklames`
--
CREATE TABLE IF NOT EXISTS
`reklames` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255)
NOT NULL,
`http` varchar(255) NOT NULL,
`img` varchar(255) NOT NULL,
`kolls` bigint(60) NOT NULL,
`day` int(11) NOT NULL,
`time` bigint(60)
NOT NULL,
`timeoff` bigint(60) NOT NULL,
`pozition` int(11) NOT NULL,
`mesto` int(11) NOT NULL,
`stat` enum('0','1','2') NOT NULL,
`br`
enum('0','1') NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `reklames_log`
--
CREATE TABLE IF NOT
EXISTS `reklames_log` (
`id_link` int(11) NOT NULL AUTO_INCREMENT,
`ip`
varchar(255) NOT NULL,
`user` varchar(255) NOT NULL,
`time` bigint(60)
NOT NULL,
PRIMARY KEY (`id_link`),
KEY `ip` (`ip`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `setting`
--
CREATE TABLE IF NOT EXISTS
`setting` (
`name` varchar(32) NOT NULL,
`value` varchar(1023) NOT
NULL,
UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;
--
-- Дамп данных таблицы
`setting`
--
INSERT INTO `setting` (`name`, `value`) VALUES
('password',
'670b14728ad9902aecba32e22fa4f6bd'),
('path', 'files'),
('opath',
'about'),
('spath', 'screen'),
('jpath', 'data/jar'),
('ipath',
'data/jar_ico'),
('zpath', 'data/zip'),
('zppath',
'data/zip_pic'),
('tpath', 'data/theme'),
('mp3path',
'data/mp3'),
('ffmpegpath', 'data/ffmpeg'),
('picpath',
'data/pic'),
('limit', '10'),
('klimit', '25'),
('onpage', '10'),
('prew',
'1'),
('pagehand', '10'),
('hackmess', 'Error!'),
('view_size',
'128*128,120*160,132*176,240*320'),
('lib_desc', '1'),
('lib',
'1024'),
('lib_str', '160'),
('desc', '50'),
('marker', '2'),
('css',
'default'),
('countban', '2'),
('autologin', '1'),
('timeban',
'10'),
('site_url', 'http://osexy.ru'),
('anim_change',
'1'),
('onpage_change', '0'),
('screen_change',
'1'),
('screen_file_change', '1'),
('swf_change', '1'),
('swf_file_change',
'1'),
('jar_change', '1'),
('jar_file_change', '1'),
('lib_change',
'1'),
('abuse_change', '1'),
('send_email', '1'),
('online_max',
'22'),
('online_max_time', '2013-07-22 11:38:31'),
('ffmpeg_frame',
'5'),
('ffmpeg_frames', '25,120,250,350'),
('zag', 'oSEXy.ru - Добро
пожаловать'),
('day_new', '2'),
('komments_change',
'1'),
('komments_captcha', '1'),
('top_change', '1'),
('ext',
'1'),
('delete_dir', '1'),
('delete_file', '1'),
('search_change',
'1'),
('prev_next', '1'),
('preview_change', '1'),
('prev_size',
'80*80'),
('top_num', '20'),
('pagehand_change', '1'),
('zip_change',
'1'),
('jad_change', '1'),
('cut_change', '1'),
('buy_change',
'1'),
('online', '1'),
('online_time', '60'),
('nomination',
'files/'),
('zakaz_change', '1'),
('zakaz_email',
'admin@osexy.ru'),
('apk_ico', '1'),
('apkpath',
'data/apk_ico'),
('adv_link', '0'),
('eval_change', '1'),
('apk_change',
'1'),
('stat_change', '0'),
('exchanger_change', '0');
/*!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 */;