-- phpMyAdmin SQL Dump
-- version 2.6.1
-- http://www.phpmyadmin.net
--
-- Хост: localhost
-- Время создания: Май 13 2009 г., 18:05
-- Версия сервера: 5.0.45
-- Версия PHP: 5.2.4
--
-- БД: `d`
--
-- --------------------------------------------------------
--
-- Структура таблицы `categorys`
--
CREATE TABLE `categorys` (
`id` int(16) unsigned NOT NULL auto_increment,
`parent` int(16) unsigned NOT NULL default '0',
`name` varchar(150) NOT NULL default '',
`desc` mediumtext NOT NULL,
`adult` tinyint(1) NOT NULL default '0',
`position` int(9) NOT NULL default '0',
`acc_ext` mediumtext NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=49 DEFAULT CHARSET=utf8 AUTO_INCREMENT=49 ;
--
-- Дамп данных таблицы `categorys`
--
INSERT INTO `categorys` VALUES (1, 0, 'MEЛОДИИ', '', 0, 1, 'mmf| mid| amr| mp3| wav| aac| seq| vox| dxm| imy| emy| pmd| rng');
INSERT INTO `categorys` VALUES (2, 1, 'MP3', '', 0, 1, '');
INSERT INTO `categorys` VALUES (3, 1, 'MMF', '', 0, 2, '');
INSERT INTO `categorys` VALUES (4, 1, 'MID', '', 0, 3, '');
INSERT INTO `categorys` VALUES (5, 1, 'AMR', '', 0, 4, '');
INSERT INTO `categorys` VALUES (6, 1, 'WAV', '', 0, 5, '');
INSERT INTO `categorys` VALUES (7, 1, 'AAC', '', 0, 6, '');
INSERT INTO `categorys` VALUES (8, 1, 'SEQ', '', 0, 7, '');
INSERT INTO `categorys` VALUES (9, 1, 'VOX', '', 0, 8, '');
INSERT INTO `categorys` VALUES (10, 1, 'DXM', '', 0, 9, '');
INSERT INTO `categorys` VALUES (11, 1, 'IMY', '', 0, 10, '');
INSERT INTO `categorys` VALUES (12, 1, 'EMY', '', 0, 11, '');
INSERT INTO `categorys` VALUES (13, 1, 'PMD', '', 0, 12, '');
INSERT INTO `categorys` VALUES (14, 1, 'RNG', '', 0, 13, '');
INSERT INTO `categorys` VALUES (15, 0, 'КАРТИНКИ', '', 0, 2, 'gif| jpg| jpeg| bmp| png| wbmp| pic| ani| pco');
INSERT INTO `categorys` VALUES (16, 15, 'GIF', '', 0, 1, '');
INSERT INTO `categorys` VALUES (17, 15, 'JPG', '', 0, 2, '');
INSERT INTO `categorys` VALUES (18, 15, 'JPEG', '', 0, 3, '');
INSERT INTO `categorys` VALUES (19, 15, 'BMP', '', 0, 4, '');
INSERT INTO `categorys` VALUES (20, 15, 'PNG', '', 0, 5, '');
INSERT INTO `categorys` VALUES (21, 15, 'WBMP', '', 0, 6, '');
INSERT INTO `categorys` VALUES (22, 15, 'PIC', '', 0, 7, '');
INSERT INTO `categorys` VALUES (23, 15, 'ANI', '', 0, 8, '');
INSERT INTO `categorys` VALUES (24, 15, 'PCO', '', 0, 9, '');
INSERT INTO `categorys` VALUES (25, 0, 'BИДЕO', '', 0, 3, '3gp| mp4| avi| mpeg| rm');
INSERT INTO `categorys` VALUES (26, 25, '3GP', '', 0, 1, '');
INSERT INTO `categorys` VALUES (27, 25, 'MP4', '', 0, 2, '');
INSERT INTO `categorys` VALUES (28, 25, 'AVI', '', 0, 3, '');
INSERT INTO `categorys` VALUES (29, 25, 'MPEG', '', 0, 4, '');
INSERT INTO `categorys` VALUES (30, 25, 'RM', '', 0, 5, '');
INSERT INTO `categorys` VALUES (31, 0, 'ТЕМЫ', '', 0, 4, 'thm| sdt| nth| mtf| col| scs| utz');
INSERT INTO `categorys` VALUES (32, 31, 'THM (Sony Ericsson)', '', 0, 1, '');
INSERT INTO `categorys` VALUES (33, 31, 'NTH (Nokia S40)', '', 0, 2, '');
INSERT INTO `categorys` VALUES (34, 31, 'SDT (Siemens)', '', 0, 3, '');
INSERT INTO `categorys` VALUES (35, 31, 'MTF (Motorola)', '', 0, 4, '');
INSERT INTO `categorys` VALUES (36, 31, 'COL (Siemens)', '', 0, 5, '');
INSERT INTO `categorys` VALUES (37, 31, 'SCS (Siemens)', '', 0, 6, '');
INSERT INTO `categorys` VALUES (38, 31, 'UTZ (Sony Ericsson)', '', 0, 7, '');
INSERT INTO `categorys` VALUES (39, 0, 'XXX-Картинки', '', 0, 5, 'gif| jpg| jpeg| bmp| png| wbmp| pic| ani| pco');
INSERT INTO `categorys` VALUES (40, 39, 'XXX-Картинки', '', 1, 1, '');
INSERT INTO `categorys` VALUES (41, 0, 'XXX-Видео', '', 0, 6, '3gp| mp4| avi| mpeg| rm');
INSERT INTO `categorys` VALUES (42, 41, '3GP', 'ХХХ-Видео формата 3GP', 1, 1, '');
INSERT INTO `categorys` VALUES (43, 41, 'AVI', 'ХХХ-Видео в формате AVI', 1, 2, '');
INSERT INTO `categorys` VALUES (44, 0, 'Приложения', '', 0, 7, 'jar|jad|sis|sys');
INSERT INTO `categorys` VALUES (47, 44, 'Игры', '', 0, 1, '');
INSERT INTO `categorys` VALUES (48, 44, 'Программы', '', 0, 2, '');
-- --------------------------------------------------------
--
-- Структура таблицы `comments`
--
CREATE TABLE `comments` (
`id` int(16) unsigned NOT NULL auto_increment,
`fid` int(16) unsigned NOT NULL default '0',
`author` varchar(150) NOT NULL default '',
`text` mediumtext NOT NULL,
`time` int(16) unsigned NOT NULL default '0',
`ip` varchar(150) NOT NULL default '',
`soft` varchar(150) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Дамп данных таблицы `comments`
--
-- --------------------------------------------------------
--
-- Структура таблицы `files`
--
CREATE TABLE `files` (
`id` int(16) unsigned NOT NULL auto_increment,
`cat` int(16) unsigned NOT NULL default '0',
`refcat` int(16) unsigned NOT NULL default '0',
`filename` varchar(150) NOT NULL default '',
`desc` mediumtext NOT NULL,
`screen` varchar(150) NOT NULL default '',
`jad` varchar(150) NOT NULL default '',
`downloads` int(16) unsigned NOT NULL default '0',
`last_download` int(16) unsigned NOT NULL default '0',
`abuse` tinyint(3) unsigned NOT NULL default '0',
`uploaded` int(16) unsigned NOT NULL default '0',
`author` varchar(100) NOT NULL default '0',
`ip` varchar(150) NOT NULL default '',
`soft` varchar(150) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `abuse` (`abuse`),
KEY `author` (`author`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Дамп данных таблицы `files`
--
-- --------------------------------------------------------
--
-- Структура таблицы `msg`
--
CREATE TABLE `msg` (
`lid` int(11) unsigned NOT NULL auto_increment,
`id` int(11) NOT NULL default '0',
`to` int(11) unsigned NOT NULL default '0',
`from` int(11) unsigned NOT NULL default '0',
`subject` tinyblob NOT NULL,
`body` blob NOT NULL,
`date` tinyblob NOT NULL,
`time` int(11) unsigned NOT NULL default '0',
`read` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`lid`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
--
-- Дамп данных таблицы `msg`
--
-- --------------------------------------------------------
--
-- Структура таблицы `privat`
--
CREATE TABLE `privat` (
`mid` int(10) unsigned NOT NULL auto_increment,
`tonick` blob,
`mynick` blob,
`tema` blob,
`msg` blob,
`read` int(1) default '0',
`time` tinytext collate cp1250_bin NOT NULL,
PRIMARY KEY (`mid`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=cp1250 COLLATE=cp1250_bin AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Структура таблицы `users`
--
CREATE TABLE `users` (
`id` int(16) unsigned NOT NULL auto_increment,
`login` varchar(50) NOT NULL default '',
`pass` varchar(50) NOT NULL default '',
`name` varchar(100) NOT NULL default '',
`sex` tinyint(1) unsigned NOT NULL default '0',
`city` varchar(100) NOT NULL default '',
`age` tinyint(3) unsigned NOT NULL default '0',
`email` varchar(100) NOT NULL default '',
`icq` varchar(20) NOT NULL default '',
`upl_files` int(16) unsigned NOT NULL default '0',
`upl_files_size` int(16) unsigned NOT NULL default '0',
`dwl_files` int(16) unsigned NOT NULL default '0',
`dwl_files_size` int(16) unsigned NOT NULL default '0',
`dwl_filelist` text NOT NULL,
`comments` smallint(5) unsigned NOT NULL default '0',
`reg_date` int(16) unsigned NOT NULL default '0',
`level` tinyint(2) unsigned NOT NULL default '0',
`session` varchar(50) NOT NULL default '',
`last` int(16) unsigned NOT NULL default '0',
`ver` varchar(10) NOT NULL default '',
`ip` varchar(15) NOT NULL default '',
`soft` varchar(100) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `session` (`session`),
KEY `last` (`last`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=2 ;
--
-- Дамп данных таблицы `users`
--
INSERT INTO `users` VALUES (1, 'Admin', 'admin', 'Николай', 1, 'Николаев/Новый Буг', 26, 'nickolas2007s@rambler.ru', '188656', 6, 1058005, 13, 7146942, ':13:', 0, 1213175588, 2, '', 1242227032, 'html', '127.0.0.1', 'Opera/9.64');