Файл: dmbuy.sql
Строк: 249
-- phpMyAdmin SQL Dump
-- version 3.2.3
-- http://www.phpmyadmin.net
--
--
Host: localhost
-- Generation Time: Jul 04, 2013 at 01:01 PM
-- Server
version: 5.1.40
-- PHP Version: 5.3.3
SET
SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!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 */;
--
-- Database: `dmbuy`
--
--
--------------------------------------------------------
--
-- Table
structure for table `ads`
--
CREATE TABLE IF NOT EXISTS `ads` (
`id`
int(16) NOT NULL AUTO_INCREMENT,
`name` varchar(150) NOT NULL,
`link`
varchar(250) NOT NULL,
`image` varchar(250) NOT NULL,
`type` int(1) NOT
NULL,
`redirect` int(1) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table
`ads`
--
--
--------------------------------------------------------
--
-- Table
structure for table `friends`
--
CREATE TABLE IF NOT EXISTS `friends` (
`id` int(16) NOT NULL AUTO_INCREMENT,
`user_id` int(16) NOT NULL,
`friend_id` int(16) NOT NULL,
`active` int(1) NOT NULL,
PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=3 ;
--
--
Dumping data for table `friends`
--
INSERT INTO `friends` (`id`,
`user_id`, `friend_id`, `active`) VALUES
(1, 7, 1, 1),
(2, 1, 7, 1);
--
--------------------------------------------------------
--
-- Table
structure for table `guests`
--
CREATE TABLE IF NOT EXISTS `guests` (
`id` int(20) NOT NULL AUTO_INCREMENT,
`ip` varchar(20) NOT NULL,
`browser` text NOT NULL,
`time` text NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=14 ;
--
-- Dumping data
for table `guests`
--
INSERT INTO `guests` (`id`, `ip`, `browser`, `time`)
VALUES
(1, '82.145.211.39', 'Opera Mini 7.5', '1375082309'),
(2,
'85.26.184.58', 'IE 9.0', '1375082361'),
(3, '159.160.149.214', 'Firefox
12.0', '1375084749'),
(4, '46.174.248.17', 'Chrome 25.0.1364',
'1375083013'),
(5, '213.87.128.236', 'IE 9.0', '1375082376'),
(6,
'82.145.211.87', 'Opera Mini 4.2', '1375082618'),
(7, '217.118.81.19',
'Safari 5.1', '1375082710'),
(8, '188.130.146.34', 'Chrome 28.0.1500',
'1375084457'),
(9, '95.134.194.213', 'Opera 12.16', '1375083296'),
(10,
'46.211.182.31', 'Chrome 28.0.1500', '1375083812'),
(11, '82.145.210.93',
'Opera Mini 5.1', '1375084307'),
(12, '195.189.123.4', 'Nokia 2700c-2',
'1375085196'),
(13, '127.0.0.1', 'Firefox 12.0', '1372928095');
--
--------------------------------------------------------
--
-- Table
structure for table `mail`
--
CREATE TABLE IF NOT EXISTS `mail` (
`id`
int(11) NOT NULL AUTO_INCREMENT,
`mail_chat_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`text` text NOT NULL,
`time` int(11) NOT
NULL,
`who_id` int(11) NOT NULL,
`read` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2
;
--
-- Dumping data for table `mail`
--
INSERT INTO `mail` (`id`,
`mail_chat_id`, `user_id`, `text`, `time`, `who_id`, `read`) VALUES
(1, 2,
7, 'Ну так что меняемся?))))', 1375084280, 1, 1);
--
--------------------------------------------------------
--
-- Table
structure for table `mail_chat`
--
CREATE TABLE IF NOT EXISTS `mail_chat`
(
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`who_id` int(11) NOT NULL,
`time_last_message` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3
;
--
-- Dumping data for table `mail_chat`
--
INSERT INTO `mail_chat`
(`id`, `user_id`, `who_id`, `time_last_message`) VALUES
(1, 2, 1,
1372748257),
(2, 7, 1, 1375084280);
--
--------------------------------------------------------
--
-- Table
structure for table `mini_chat`
--
CREATE TABLE IF NOT EXISTS `mini_chat`
(
`id` int(20) NOT NULL AUTO_INCREMENT,
`text` varchar(1000) NOT NULL,
`user_id` int(32) NOT NULL,
`time` int(32) NOT NULL,
PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--
Dumping data for table `mini_chat`
--
--
--------------------------------------------------------
--
-- Table
structure for table `notify`
--
CREATE TABLE IF NOT EXISTS `notify` (
`id` int(16) NOT NULL AUTO_INCREMENT,
`user_id` int(16) NOT NULL,
`request_id` int(16) NOT NULL,
`from_id` int(16) NOT NULL,
`type`
varchar(20) NOT NULL,
`time` int(16) NOT NULL,
`read` int(1) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251
AUTO_INCREMENT=2 ;
--
-- Dumping data for table `notify`
--
INSERT INTO
`notify` (`id`, `user_id`, `request_id`, `from_id`, `type`, `time`, `read`)
VALUES
(1, 7, 0, 1, 'notify_verify_friend', 1372926596, 0);
--
--------------------------------------------------------
--
-- Table
structure for table `pages`
--
CREATE TABLE IF NOT EXISTS `pages` (
`id`
int(20) NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
`lat_name` varchar(100) NOT NULL,
`text` text NOT NULL,
PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--
Dumping data for table `pages`
--
--
--------------------------------------------------------
--
-- Table
structure for table `settings`
--
CREATE TABLE IF NOT EXISTS `settings` (
`user_id` int(20) NOT NULL,
`lang` varchar(10) NOT NULL,
`ames`
varchar(2) NOT NULL,
`theme` varchar(50) NOT NULL,
`web_theme`
varchar(50) NOT NULL,
`fast_mess` varchar(3) NOT NULL,
`view_profile`
varchar(50) NOT NULL,
`show_email` varchar(50) NOT NULL,
`timezone`
varchar(55) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping
data for table `settings`
--
INSERT INTO `settings` (`user_id`, `lang`,
`ames`, `theme`, `web_theme`, `fast_mess`, `view_profile`, `show_email`,
`timezone`) VALUES
(1, 'ru', '10', 'default', 'default', 'no', 'all', 'no',
'Europe/Kiev'),
(1, 'uk', '10', 'default', 'default', 'yes', 'all', 'no',
'Europe/Kiev'),
(1, 'uk', '10', 'default', 'default', 'yes', 'all', 'no',
'Europe/Kiev'),
(2, 'ru', '10', 'default', 'default', 'yes', 'all', 'no',
'Europe/Kiev'),
(3, 'uk', '10', 'default', 'default', 'yes', 'all', 'no',
'Europe/Kiev'),
(4, 'uk', '10', 'default', 'default', 'yes', 'all', 'no',
'Europe/Kiev'),
(5, 'uk', '10', 'default', 'default', 'yes', 'all', 'no',
'Europe/Kiev'),
(6, 'uk', '10', 'default', 'default', 'yes', 'all', 'no',
'Europe/Kiev'),
(7, 'uk', '10', 'default', 'default', 'yes', 'all', 'no',
'Europe/Kiev');
--
--------------------------------------------------------
--
-- Table
structure for table `share`
--
CREATE TABLE IF NOT EXISTS `share` (
`id`
int(20) NOT NULL AUTO_INCREMENT,
`name` varchar(32) NOT NULL,
`desc`
varchar(200) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=4 ;
--
-- Dumping data for table
`share`
--
INSERT INTO `share` (`id`, `name`, `desc`) VALUES
(3,
'Купля-продажа доменов', '');
--
--------------------------------------------------------
--
-- Table
structure for table `share_c`
--
CREATE TABLE IF NOT EXISTS `share_c` (
`id` int(20) NOT NULL AUTO_INCREMENT,
`rid` int(20) NOT NULL,
`name`
varchar(32) NOT NULL,
`who_upload` int(1) NOT NULL,
`desc` varchar(200)
NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=8 ;
--
-- Dumping data for table `share_c`
--
INSERT INTO
`share_c` (`id`, `rid`, `name`, `who_upload`, `desc`) VALUES
(2, 3,
'Россия и СНГ', 2, '.ru, .рф, .su, .ua и др.'),
(3, 3,
'Международные', 2, '.com, .net, .org, .biz и др.'),
(4, 3,
'Европа', 2, '.eu, .lt, .cz, .pl и др.'),
(5, 3, 'Америка',
2, '.us, .co, .bz, .lc и др.'),
(6, 3, 'Азия и Африка', 2,
'.asia, .tw, .mn, .in и др.'),
(7, 3, 'Другие страны', 2,
'.cc, .ws, .cx, .ms и др.');
--
--------------------------------------------------------
--
-- Table
structure for table `share_files`
--
CREATE TABLE IF NOT EXISTS
`share_files` (
`id` int(20) NOT NULL AUTO_INCREMENT,
`cat_id` int(32)
NOT NULL,
`user_id` int(32) NOT NULL,
`dload_times` int(32) NOT NULL,
`name` varchar(32) NOT NULL,
`reg` varchar(32) NOT NULL,
`panel`
varchar(32) NOT NULL,
`data` varchar(32) NOT NULL,
`do` varchar(32) NOT
NULL,
`cena` varchar(32) NOT NULL,
`path_name` varchar(100) NOT NULL,
`path` varchar(100) NOT NULL,
`time` int(50) NOT NULL,
`size` int(75)
NOT NULL,
`text` varchar(10000) NOT NULL,
`ext` varchar(10) NOT NULL,
`moderate` int(1) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=11 ;
--
-- Dumping data for table
`share_files`
--
INSERT INTO `share_files` (`id`, `cat_id`, `user_id`,
`dload_times`, `name`, `reg`, `panel`, `data`, `do`, `cena`, `path_name`,
`path`, `time`, `size`, `text`, `ext`, `moderate`) VALUES
(7, 2, 1, 0,
'yyy.pp.ua', 'PP.UA', '2name.net', '28.06.2013', '28.06.2014', '50', '',
'/home/ktz12902/public_html/files/domens/', 1374955474, 0, 'Хороший
универсальный домен.', '', 0),
(8, 2, 5, 0, 'axaxa.tk',
'dot.tk', 'dot.tk', '15.07.2013', '15.07.2014', '15', '',
'/home/ktz12902/public_html/files/domens/', 1375001435, 0, 'Хороший
домен для сайтов приколов или шутоа', '',
0),
(9, 2, 7, 0, 'kizmuz.ru', 'ru', '2domains.ru', '05.03.2013',
'05.03.2013', '55', '', '/home/ktz12902/public_html/files/domens/',
1375082892, 0, 'Домен Музыкального портала', '',
0),
(10, 2, 7, 0, '05club.ru', 'ru', '2domains.ru', '19.07.2013',
'19.07.2013', '70', '', '/home/ktz12902/public_html/files/domens/',
1375083195, 0, 'Домен от хостинга', '', 0);
--
--------------------------------------------------------
--
-- Table
structure for table `share_rating`
--
CREATE TABLE IF NOT EXISTS
`share_rating` (
`file_id` int(16) NOT NULL,
`user_id` int(16) NOT
NULL,
`rated` int(16) NOT NULL,
`rating` int(16) NOT NULL
)
ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table
`share_rating`
--
--
--------------------------------------------------------
--
-- Table
structure for table `system`
--
CREATE TABLE IF NOT EXISTS `system` (
`open_reg` varchar(10) NOT NULL,
`ames` varchar(2) NOT NULL,
`theme`
varchar(50) NOT NULL,
`web_theme` varchar(50) NOT NULL,
`keywords`
varchar(150) NOT NULL,
`description` varchar(200) NOT NULL,
`open_forum` varchar(3) NOT NULL,
`open_mini_chat` varchar(3) NOT NULL,
`open_library` varchar(3) NOT NULL,
`open_share` varchar(3) NOT NULL,
`open_news` varchar(3) NOT NULL,
`copyright` varchar(25) NOT NULL,
`balans_chat` int(11) NOT NULL,
`balans_obmen` int(11) NOT NULL,
`balans_forum` int(11) NOT NULL,
`title` varchar(25) NOT NULL,
`open_site` varchar(3) NOT NULL,
`ads_footer` varchar(5000) NOT NULL,
`ads_header` varchar(5000) NOT NULL,
`ads_banners` varchar(5000) NOT
NULL,
`bb_b` varchar(3) NOT NULL,
`bb_u` varchar(3) NOT NULL,
`bb_s`
varchar(3) NOT NULL,
`bb_i` varchar(3) NOT NULL,
`bb_big` varchar(3)
NOT NULL,
`bb_small` varchar(3) NOT NULL,
`bb_yellow` varchar(3) NOT
NULL,
`bb_blue` varchar(3) NOT NULL,
`bb_green` varchar(3) NOT NULL,
`bb_red` varchar(3) NOT NULL,
`bb_color` varchar(3) NOT NULL,
`bb_size`
varchar(3) NOT NULL,
`bb_quote` varchar(3) NOT NULL,
`lang` varchar(10)
NOT NULL,
`public_site` varchar(10) NOT NULL,
`files_types` text NOT
NULL,
`who_upload` int(1) NOT NULL,
`timezone` varchar(55) NOT NULL,
`mainpage` text NOT NULL,
`show_topics` int(1) NOT NULL,
`downloads_opened` int(1) NOT NULL
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;
--
-- Dumping data for table `system`
--
INSERT INTO
`system` (`open_reg`, `ames`, `theme`, `web_theme`, `keywords`,
`description`, `open_forum`, `open_mini_chat`, `open_library`,
`open_share`, `open_news`, `copyright`, `balans_chat`, `balans_obmen`,
`balans_forum`, `title`, `open_site`, `ads_footer`, `ads_header`,
`ads_banners`, `bb_b`, `bb_u`, `bb_s`, `bb_i`, `bb_big`, `bb_small`,
`bb_yellow`, `bb_blue`, `bb_green`, `bb_red`, `bb_color`, `bb_size`,
`bb_quote`, `lang`, `public_site`, `files_types`, `who_upload`, `timezone`,
`mainpage`, `show_topics`, `downloads_opened`) VALUES
('yes', '10',
'default', 'default', 'domen, домен, купить, продать',
'Купля-продажа доменов.', 'yes', 'yes', 'yes', 'yes',
'yes', 'W6M.ru', 0, 0, 0, 'W6M.ru', 'yes', '', '', '', 'on', 'on', 'on',
'on', 'on', 'on', 'on', 'on', 'on', 'on', 'on', 'on', 'on', 'uk', 'yes',
'png;gif;jpg;jpeg;bmp;sis;sisx;zip;rar;jar;jad;mp4;3gp;mp3;mid;midi;wav;amr;exe;tar.gz;3gpp;',
0, 'Europe/Kiev', '', 1, 1);
--
--------------------------------------------------------
--
-- Table
structure for table `users`
--
CREATE TABLE IF NOT EXISTS `users` (
`id`
int(20) NOT NULL AUTO_INCREMENT,
`nick` varchar(32) NOT NULL,
`balans`
int(11) NOT NULL,
`password` varchar(32) NOT NULL,
`email` varchar(100)
NOT NULL,
`name` varchar(25) NOT NULL,
`surname` varchar(40) NOT NULL,
`device` varchar(40) NOT NULL,
`icq` int(9) NOT NULL,
`skype`
varchar(50) NOT NULL,
`mmail` varchar(50) NOT NULL,
`phone` varchar(40)
NOT NULL,
`site` varchar(40) NOT NULL,
`info` varchar(3000) NOT NULL,
`gender` varchar(1) NOT NULL,
`day` int(2) NOT NULL,
`month` int(2) NOT
NULL,
`year` int(4) NOT NULL,
`interests` varchar(1000) NOT NULL,
`city` varchar(55) NOT NULL,
`country` varchar(55) NOT NULL,
`time`
varchar(55) NOT NULL,
`reg_time` varchar(55) NOT NULL,
`locate`
varchar(100) NOT NULL,
`level` int(2) NOT NULL,
`ban_time` int(32) NOT
NULL,
`ban_text` varchar(1000) NOT NULL,
`wmid` varchar(12) NOT NULL,
`wmr` varchar(12) NOT NULL,
`tel` varchar(50) NOT NULL,
PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
--
--
Dumping data for table `users`
--
INSERT INTO `users` (`id`, `nick`,
`balans`, `password`, `email`, `name`, `surname`, `device`, `icq`, `skype`,
`mmail`, `phone`, `site`, `info`, `gender`, `day`, `month`, `year`,
`interests`, `city`, `country`, `time`, `reg_time`, `locate`, `level`,
`ban_time`, `ban_text`, `wmid`, `wmr`, `tel`) VALUES
(1, 'W6M', 0,
'a105d439ce7181452bf026ba49a07db1', 'mail@w6m.ru', 'Александр',
'', '', 45656565, 'W6Mcompany', 'mail@w6m.ru', '', 'w6m.ru', '', '1', 0, 0,
0, '', '', '', '1372928083', '1372705228', 'in_site', 7, 0, '',
'205879940289', 'R39664545487', '+380931206935'),
(2, 'test', 0,
'4fb3b0a8534753a3bcdeacc3d8bb9bd6', 'test@test.ru', 'test', '', '', 0, '',
'', '', '', '', '1', 0, 0, 0, '', '', '', '1372787128', '1372748040',
'in_site', 1, 0, '', '', '', ''),
(3, 'GreenMark', 0,
'8c6586e0090df3952c7bb971850e8c5d', 'green_mark@bk.ru', 'Марк',
'Грин', '', 7868644, 'noskype', 'green_mark@bk.ru', '', 'usa.com', '',
'1', 1, 1, 1960, '', 'New-York', 'USA', '1375000776', '1375000463',
'in_site', 1, 0, '', '', '', ''),
(4, 'iswe', 0,
'88209f10c9f65c3770c43ab45a49c781', 'sir4uk@iprogrammer.me',
'Евгений', '', '', 0, '', '', '', '', '', '1', 0, 0, 0, '', '', '',
'1375000989', '1375000845', 'in_site', 1, 0, '', '', '', ''),
(5,
'CoolBoy', 0, '9c6079d7bde666b4689dae0cc3763418', 'danuas@yandex.ru',
'Даниил', 'Смирнов', '', 652811, 'coolcopy01',
'danuas@yandex.ru', '', 'axaxa.tk', '', '1', 15, 8, 1990, '', 'Moscow',
'Russia', '1375001441', '1375001268', 'in_site', 1, 0, '', '', '', ''),
(6,
'2bit', 0, 'dcc839c6301fcaf3b85024b7119159da', 'xbenil@ya.ru',
'Данил', '', '', 0, '', '', '', '', '', '1', 0, 0, 0, '', '', '',
'1375021250', '1375021211', 'in_site', 1, 0, '', '', '', ''),
(7, 'Trafle',
0, '49f660f2f6aec9961a0464dbba0eed19', 'freelogo@bk.ru',
'Александр', 'Кузнецов', '', 111438222, '',
'freelogo@bk.ru', '', '05club.ru', '', '1', 31, 8, 1991, '',
'Кизляр', 'Россия', '1375084405', '1375082702', 'in_site', 1,
0, '', '', '', '');