Файл: dvig128_cat.sql
Строк: 867
-- phpMyAdmin SQL Dump
-- version 4.0.8
-- http://www.phpmyadmin.net
--
--
Хост: localhost
-- Время создания: Янв 06 2014 г.,
15:23
-- Версия сервера: 5.1.72-cll
-- Версия PHP:
5.3.17
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 */;
--
-- База данных: `dvig128_cat`
--
--
--------------------------------------------------------
--
--
Структура таблицы `admin_jurnal`
--
CREATE TABLE IF NOT
EXISTS `admin_jurnal` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user`
int(11) NOT NULL,
`text` text NOT NULL,
`time` int(11) NOT NULL,
`new` int(11) NOT NULL,
`news` int(11) NOT NULL,
`forum` int(11) NOT
NULL,
`diary` int(11) NOT NULL,
`chat` int(11) NOT NULL,
`blog`
int(11) NOT NULL,
`foto` int(11) NOT NULL,
`ban` int(11) NOT NULL,
`edit` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=utf8 AUTO_INCREMENT=32 ;
--
--------------------------------------------------------
--
--
Структура таблицы `admin_jurnal_ban`
--
CREATE TABLE IF
NOT EXISTS `admin_jurnal_ban` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL,
`text` text NOT NULL,
`time` int(11) NOT
NULL,
`new` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB
DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
--
--------------------------------------------------------
--
--
Структура таблицы `admin_jurnal_blog`
--
CREATE TABLE IF
NOT EXISTS `admin_jurnal_blog` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL,
`text` text NOT NULL,
`time` int(11) NOT
NULL,
`new` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `admin_jurnal_edit`
--
CREATE TABLE IF
NOT EXISTS `admin_jurnal_edit` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL,
`text` text NOT NULL,
`time` int(11) NOT
NULL,
`new` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB
DEFAULT CHARSET=utf8 AUTO_INCREMENT=26 ;
--
--------------------------------------------------------
--
--
Структура таблицы `admin_jurnal_forum`
--
CREATE TABLE IF
NOT EXISTS `admin_jurnal_forum` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL,
`text` text NOT NULL,
`time` int(11) NOT
NULL,
`new` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `admin_jurnal_foto`
--
CREATE TABLE IF
NOT EXISTS `admin_jurnal_foto` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL,
`text` text NOT NULL,
`time` int(11) NOT
NULL,
`new` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB
DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
--------------------------------------------------------
--
--
Структура таблицы `admin_jurnal_money`
--
CREATE TABLE IF
NOT EXISTS `admin_jurnal_money` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL,
`text` text NOT NULL,
`time` int(11) NOT
NULL,
`new` int(11) NOT NULL,
`code` text NOT NULL,
PRIMARY KEY
(`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `admin_jurnal_news`
--
CREATE TABLE IF
NOT EXISTS `admin_jurnal_news` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL,
`text` text NOT NULL,
`time` int(11) NOT
NULL,
`new` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB
DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
--
--------------------------------------------------------
--
--
Структура таблицы `arbour`
--
CREATE TABLE IF NOT EXISTS
`arbour` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT
NULL,
`message` text NOT NULL,
`time` int(11) NOT NULL,
PRIMARY KEY
(`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
--
--------------------------------------------------------
--
--
Структура таблицы `chat_messages`
--
CREATE TABLE IF NOT
EXISTS `chat_messages` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user`
text NOT NULL,
`message` text NOT NULL,
`time` int(11) NOT NULL,
`priv` int(11) NOT NULL,
`room` int(11) NOT NULL,
`umnik` int(11) NOT
NULL,
`vopros` int(11) NOT NULL,
`timevopros` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-- --------------------------------------------------------
--
--
Структура таблицы `chat_room`
--
CREATE TABLE IF NOT
EXISTS `chat_room` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` text
NOT NULL,
`descr` text NOT NULL,
`time` int(11) NOT NULL,
`type`
int(11) NOT NULL,
`ord` int(11) NOT NULL,
`bes` int(11) NOT NULL,
`admin` int(11) NOT NULL,
`user` int(11) NOT NULL,
`etime` int(11) NOT
NULL,
`edit` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `chat_vopros`
--
CREATE TABLE IF NOT
EXISTS `chat_vopros` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`vopros`
varchar(1024) NOT NULL,
`otvet` varchar(32) NOT NULL,
PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `dialogs_contacts`
--
CREATE TABLE IF
NOT EXISTS `dialogs_contacts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL,
`contact` int(11) NOT NULL,
`time` int(11) NOT
NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `dialogs_messages`
--
CREATE TABLE IF
NOT EXISTS `dialogs_messages` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL,
`outuser` int(11) NOT NULL,
`inuser` int(11)
NOT NULL,
`message` text NOT NULL,
`time` int(11) NOT NULL,
`new`
int(11) NOT NULL,
`id2` int(11) NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `diary_comm`
--
CREATE TABLE IF NOT
EXISTS `diary_comm` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user`
int(11) NOT NULL,
`message` text NOT NULL,
`time` int(11) NOT NULL,
`diary` int(11) NOT NULL,
`new` int(11) NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;
--
--------------------------------------------------------
--
--
Структура таблицы `diary_like`
--
CREATE TABLE IF NOT
EXISTS `diary_like` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user`
int(11) NOT NULL,
`time` int(11) NOT NULL,
`diary` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=11
;
-- --------------------------------------------------------
--
--
Структура таблицы `diary_messages`
--
CREATE TABLE IF NOT
EXISTS `diary_messages` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user`
int(11) NOT NULL,
`name` text NOT NULL,
`message` text NOT NULL,
`time` int(11) NOT NULL,
`view` int(11) NOT NULL,
`comm_priv` int(11)
NOT NULL,
`cedit` int(11) NOT NULL,
`priv` int(11) NOT NULL,
`etime`
int(11) NOT NULL,
`who` int(11) NOT NULL,
`rating` int(11) NOT NULL,
`18` int(11) NOT NULL,
`votes` char(250) NOT NULL,
`vote1` char(50) NOT
NULL,
`vote2` char(50) NOT NULL,
`vote3` char(50) NOT NULL,
`vote4`
char(50) NOT NULL,
`vote5` char(50) NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;
--
--------------------------------------------------------
--
--
Структура таблицы `diary_view`
--
CREATE TABLE IF NOT
EXISTS `diary_view` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user`
int(11) NOT NULL,
`view` int(11) NOT NULL,
`last_time` int(11) NOT
NULL,
`time` int(11) NOT NULL,
`diary` int(11) NOT NULL,
PRIMARY KEY
(`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=36 ;
--
--------------------------------------------------------
--
--
Структура таблицы `duels_add`
--
CREATE TABLE IF NOT
EXISTS `duels_add` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user1`
int(11) NOT NULL,
`user2` int(11) NOT NULL,
`time` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2
;
--
-- Дамп данных таблицы `duels_add`
--
INSERT INTO
`duels_add` (`id`, `user1`, `user2`, `time`) VALUES
(1, 7, 22,
1373868043);
--
--------------------------------------------------------
--
--
Структура таблицы `duels_list`
--
CREATE TABLE IF NOT
EXISTS `duels_list` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user1`
int(11) NOT NULL,
`user2` int(11) NOT NULL,
`time` int(11) NOT NULL,
`time_end` int(11) NOT NULL,
`victory` int(11) NOT NULL,
PRIMARY KEY
(`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
--
--------------------------------------------------------
--
--
Структура таблицы `duels_votes`
--
CREATE TABLE IF NOT
EXISTS `duels_votes` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user`
int(11) NOT NULL,
`vote` int(11) NOT NULL,
`time` int(11) NOT NULL,
`duel` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=utf8 AUTO_INCREMENT=15 ;
--
--------------------------------------------------------
--
--
Структура таблицы `forum_categories`
--
CREATE TABLE IF
NOT EXISTS `forum_categories` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` text NOT NULL,
`time` int(11) NOT NULL,
`opis` text NOT NULL,
`user` int(11) NOT NULL,
`edit` int(11) NOT NULL,
`ord` int(11) NOT
NULL,
`etime` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB
DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;
--
-- Дамп данных
таблицы `forum_categories`
--
INSERT INTO `forum_categories` (`id`,
`name`, `time`, `opis`, `user`, `edit`, `ord`, `etime`) VALUES
(1, 'Все
о сайте', 1373879515, 'Правила сайта, новости,
обсуждения', 1, 1, 0, 1389006709),
(2, 'Моб. связь и
Интернет', 1373879698, 'ICQ, Opera, E-mail, WAP, Internet,
Операторы', 1, 1, 0, 1373879698),
(3, 'Моб. телефоны',
1373879743, 'Информация, Советы, Хитрости', 1, 1,
0, 1373879743),
(5, 'Android', 1373879819, 'Всё про Android', 1, 1,
0, 1373898572),
(6, 'iPhone и др платформы', 1373879870,
'Всё про iPhone', 1, 1, 0, 1373879870),
(7, 'Symbian
смартфоны', 1373879918, 'Все версии Symbian', 1, 1, 0,
1373879918),
(8, 'Windows Mobile/Phone', 1373879994, 'Всё про Windows
Phone', 1, 1, 0, 1373879994);
--
--------------------------------------------------------
--
--
Структура таблицы `forum_deleted`
--
CREATE TABLE IF NOT
EXISTS `forum_deleted` (
`user` int(11) NOT NULL,
`time` int(11) NOT
NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Дамп данных
таблицы `forum_deleted`
--
INSERT INTO `forum_deleted` (`user`,
`time`) VALUES
(1, 1373879882);
--
--------------------------------------------------------
--
--
Структура таблицы `forum_forums`
--
CREATE TABLE IF NOT
EXISTS `forum_forums` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name`
text NOT NULL,
`time` int(11) NOT NULL,
`cat` int(11) NOT NULL,
`ord`
int(11) NOT NULL,
`user` int(11) NOT NULL,
`edit` int(11) NOT NULL,
`etime` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Дамп данных таблицы
`forum_forums`
--
INSERT INTO `forum_forums` (`id`, `name`, `time`, `cat`,
`ord`, `user`, `edit`, `etime`) VALUES
(1, 'Правила сайта.
Информация', 1373879604, 1, 0, 1, 1, 1373879604);
--
--------------------------------------------------------
--
--
Структура таблицы `forum_messages`
--
CREATE TABLE IF NOT
EXISTS `forum_messages` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user`
int(11) NOT NULL,
`message` text NOT NULL,
`time` int(11) NOT NULL,
`cedit` int(11) NOT NULL,
`etime` int(11) NOT NULL,
`main` int(11) NOT
NULL,
`theme` int(11) NOT NULL,
`forum` int(11) NOT NULL,
`cat`
int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `forum_themes`
--
CREATE TABLE IF NOT
EXISTS `forum_themes` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user`
int(11) NOT NULL,
`name` text NOT NULL,
`time` int(11) NOT NULL,
`forum` int(11) NOT NULL,
`cat` int(11) NOT NULL,
`ord` int(11) NOT
NULL,
`opis` text NOT NULL,
`close` int(11) NOT NULL,
`close_id`
int(11) NOT NULL,
`who` int(11) NOT NULL,
`cedit` int(11) NOT NULL,
`etime` int(11) NOT NULL,
`fix` int(11) NOT NULL,
`18` int(11) NOT
NULL,
`admin` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `friends`
--
CREATE TABLE IF NOT EXISTS
`friends` (
`user` int(11) NOT NULL,
`friend` int(11) NOT NULL,
`time` int(11) NOT NULL,
`rating` int(11) NOT NULL,
`online` int(11)
NOT NULL,
`active` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT
CHARSET=utf8;
--
-- Дамп данных таблицы
`friends`
--
INSERT INTO `friends` (`user`, `friend`, `time`, `rating`,
`online`, `active`) VALUES
(1, 2, 1373727628, 51, 1375188346, 0),
(2, 1,
1373727628, 78, 1375280725, 0),
(1, 4, 1373742324, 72, 1374266532, 0),
(4,
1, 1373742324, 78, 1375190463, 0),
(5, 4, 1373742852, 72, 1374266532,
0),
(4, 5, 1373742852, 120, 1373743204, 0),
(2, 4, 1373815566, 72,
1374266532, 0),
(4, 2, 1373815566, 51, 1375188346, 0),
(3, 4, 1373823286,
72, 1374266532, 0),
(4, 3, 1373823286, 0, 1374151343, 0),
(15, 4,
1373841161, 72, 1374266532, 0),
(4, 15, 1373841161, 10, 1373842236, 0),
(7,
4, 1373853592, 72, 1374266532, 0),
(4, 7, 1373853592, 252, 1375142890,
0),
(2, 7, 1373864942, 252, 1375142890, 0),
(7, 2, 1373864942, 51,
1375188346, 0),
(1, 7, 1373872089, 252, 1375142890, 0),
(7, 1, 1373872089,
78, 1375280725, 0),
(23, 4, 1373959966, 72, 1374266532, 0),
(4, 23,
1373959966, 52, 1373994785, 0),
(10, 1, 1373966919, 78, 1375137823, 0),
(1,
10, 1373966919, 91, 1374959157, 0),
(10, 4, 1373966928, 72, 1374266532,
0),
(4, 10, 1373966928, 91, 1374959157, 0),
(12, 4, 1373980231, 72,
1374266532, 0),
(4, 12, 1373980231, 30, 1375120353, 0),
(1, 28, 1374043772,
0, 1374038384, 0),
(28, 1, 1374043772, 77, 1374771045, 0),
(26, 4,
1374749159, 72, 1374266532, 0),
(4, 26, 1374749159, 0, 1375122702, 0),
(12,
53, 1374863933, 10, 1374840000, 0),
(53, 12, 1374863933, 30, 1374905712,
0),
(31, 1, 1375178735, 0, 0, 0),
(1, 31, 1375178735, 4, 1375178738,
0);
-- --------------------------------------------------------
--
--
Структура таблицы `friends_adding`
--
CREATE TABLE IF NOT
EXISTS `friends_adding` (
`user` int(11) NOT NULL,
`friend` int(11) NOT
NULL,
`time` int(11) NOT NULL,
`message` text NOT NULL
) ENGINE=InnoDB
DEFAULT CHARSET=utf8;
--
-- Дамп данных таблицы
`friends_adding`
--
INSERT INTO `friends_adding` (`user`, `friend`,
`time`, `message`) VALUES
(16, 8, 1373827420, 'Privet'),
(4, 8, 1373833369,
''),
(4, 19, 1373833387, ''),
(4, 13, 1373833422, ''),
(15, 19, 1373841129,
'Ку о деня'),
(7, 5, 1373862654, 'привет, добавь
меня в друзья'),
(7, 8, 1373862719, 'привет, добавь
меня в друзья!!!'),
(7, 19, 1373862746, 'привет,
добавь меня в друзья!!!'),
(7, 14, 1373862758,
'привет, добавь меня в друзья!!!'),
(7, 16,
1373862774, 'привет, добавь меня в друзья!!!'),
(7,
18, 1373862786, 'привет, добавь меня в
друзья!!!'),
(7, 20, 1373862799, 'привет, добавь меня
в друзья!!!'),
(7, 21, 1373862811, 'привет, добавь
меня в друзья!!!'),
(4, 25, 1373958692, ''),
(4, 24, 1373958722,
''),
(4, 21, 1373958796, ''),
(4, 20, 1373958825, ''),
(4, 27, 1373978520,
''),
(4, 11, 1373978584, ''),
(4, 6, 1373978755, '');
--
--------------------------------------------------------
--
--
Структура таблицы `garems_list`
--
CREATE TABLE IF NOT
EXISTS `garems_list` (
`id` int(11) NOT NULL,
`users` int(11) NOT
NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Дамп данных
таблицы `garems_list`
--
INSERT INTO `garems_list` (`id`, `users`)
VALUES
(2, 1),
(4, 0),
(1, 0),
(10, 0),
(23, 0),
(12, 0),
(30, 0),
(43,
0),
(49, 0),
(51, 0),
(54, 0),
(59, 0),
(31, 0);
--
--------------------------------------------------------
--
--
Структура таблицы `garems_users`
--
CREATE TABLE IF NOT
EXISTS `garems_users` (
`id` int(11) NOT NULL,
`garem` int(11) NOT
NULL,
`time` int(11) NOT NULL,
`steals` int(11) NOT NULL,
`price`
int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Дамп
данных таблицы `garems_users`
--
INSERT INTO `garems_users`
(`id`, `garem`, `time`, `steals`, `price`) VALUES
(3, 0, 0, 0, 10),
(10, 0,
0, 0, 10),
(7, 0, 0, 0, 10),
(12, 2, 1374301754, 1, 20),
(2, 0, 0, 0,
10);
-- --------------------------------------------------------
--
--
Структура таблицы `gazeta`
--
CREATE TABLE IF NOT EXISTS
`gazeta` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT
NULL,
`time` int(11) NOT NULL,
`name` text NOT NULL,
`message` text
NOT NULL,
`who` int(11) NOT NULL,
`cedit` int(11) NOT NULL,
`etime`
int(11) NOT NULL,
`close` int(11) NOT NULL,
`close_id` int(11) NOT
NULL,
`rating` int(11) NOT NULL,
`img` int(11) NOT NULL,
PRIMARY KEY
(`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `gazeta_comm`
--
CREATE TABLE IF NOT
EXISTS `gazeta_comm` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user`
int(11) NOT NULL,
`time` int(11) NOT NULL,
`message` text NOT NULL,
`gazeta` int(11) NOT NULL,
`comm` int(11) NOT NULL,
PRIMARY KEY
(`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `gazeta_like`
--
CREATE TABLE IF NOT
EXISTS `gazeta_like` (
`user` int(11) NOT NULL,
`time` int(11) NOT
NULL,
`gazeta` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
--------------------------------------------------------
--
--
Структура таблицы `gifts_cat`
--
CREATE TABLE IF NOT
EXISTS `gifts_cat` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` text
NOT NULL,
`ord` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Дамп данных
таблицы `gifts_cat`
--
INSERT INTO `gifts_cat` (`id`, `name`,
`ord`) VALUES
(1, 'Новый Год', 0);
--
--------------------------------------------------------
--
--
Структура таблицы `gifts_list`
--
CREATE TABLE IF NOT
EXISTS `gifts_list` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`price`
int(11) NOT NULL,
`cat` int(11) NOT NULL,
`ord` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-- --------------------------------------------------------
--
--
Структура таблицы `gifts_users`
--
CREATE TABLE IF NOT
EXISTS `gifts_users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user`
int(11) NOT NULL,
`outuser` int(11) NOT NULL,
`gift` int(11) NOT NULL,
`message` text NOT NULL,
`time` int(11) NOT NULL,
`priv` int(11) NOT
NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `guest`
--
CREATE TABLE IF NOT EXISTS
`guest` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`idguest` int(11) NOT
NULL,
`idg` int(11) NOT NULL,
`data` text NOT NULL,
`msg` text NOT
NULL,
`time` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `jurnal`
--
CREATE TABLE IF NOT EXISTS
`jurnal` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT
NULL,
`outuser` int(11) NOT NULL,
`text` text NOT NULL,
`time`
int(11) NOT NULL,
`new` int(11) NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=176 ;
--
--------------------------------------------------------
--
--
Структура таблицы `lenta`
--
CREATE TABLE IF NOT EXISTS
`lenta` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT
NULL,
`text` text NOT NULL,
`time` int(11) NOT NULL,
`new` int(11)
NOT NULL,
`diary` int(11) NOT NULL,
`blog` int(11) NOT NULL,
`forum`
int(11) NOT NULL,
`foto` int(11) NOT NULL,
`comm` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=117
;
--
-- Дамп данных таблицы `lenta`
--
INSERT INTO
`lenta` (`id`, `user`, `text`, `time`, `new`, `diary`, `blog`, `forum`,
`foto`, `comm`) VALUES
(91, 12, 'Загрузила <a href =
"photos.php?act=photo&id=12&show=comm">фото</a>.',
1374067516, 0, 0, 0, 0, 0, 0),
(92, 12, 'Сменила <a href =
"photo.php?act=view&id=28">аватар</a>.',
1374067662, 0, 0, 0, 0, 0, 0),
(93, 1, 'Загрузил <a href =
"photos.php?act=photo&id=13&show=comm">фото</a>.',
1374176368, 0, 0, 0, 0, 0, 0),
(94, 30, 'Сменил <a href =
"photo.php?act=view&id=29">аватар</a>.',
1374220412, 0, 0, 0, 0, 0, 0),
(95, 31, 'Оставил сообщение
в <a href = "arbour.php?">беседкке</a>.',
1374357363, 0, 0, 0, 0, 0, 1),
(96, 31,
'Прокомментировал<a href =
"photo.php?act=view&id=16&show=comm">
аватарку</a>.', 1374357514, 0, 0, 0, 0, 0, 0),
(97, 33,
'Сменила <a href =
"photo.php?act=view&id=30">аватар</a>.',
1374399181, 0, 0, 0, 0, 0, 0),
(98, 34, 'Сменила <a href =
"photo.php?act=view&id=31">аватар</a>.',
1374401614, 0, 0, 0, 0, 0, 0),
(99, 35, 'Сменила <a href =
"photo.php?act=view&id=32">аватар</a>.',
1374402285, 0, 0, 0, 0, 0, 0),
(100, 37, 'Сменила <a href =
"photo.php?act=view&id=33">аватар</a>.',
1374403537, 0, 0, 0, 0, 0, 0),
(101, 46, 'Опубликовал <a href
=
"microblog.php?act=view&id=11&show=comm">микроблог</a>.',
1374579456, 0, 0, 0, 0, 0, 0),
(102, 50, 'Сменила <a href =
"photo.php?act=view&id=34">аватар</a>.',
1374668648, 0, 0, 0, 0, 0, 0),
(103, 53, 'Сменил <a href =
"photo.php?act=view&id=35">аватар</a>.',
1374839180, 0, 0, 0, 0, 0, 0),
(104, 51, 'Сменила <a href =
"photo.php?act=view&id=36">аватар</a>.',
1374852805, 0, 0, 0, 0, 0, 0),
(105, 58, 'Загрузила <a href =
"photos.php?act=photo&id=13&show=comm">фото</a>.',
1374944756, 0, 0, 0, 0, 0, 0),
(106, 58, 'Загрузила <a href =
"photos.php?act=photo&id=14&show=comm">фото</a>.',
1374944883, 0, 0, 0, 0, 0, 0),
(107, 60, 'Сменила <a href =
"photo.php?act=view&id=37">аватар</a>.',
1375027807, 0, 0, 0, 0, 0, 0),
(108, 60, 'Опубликовала <a
href =
"microblog.php?act=view&id=12&show=comm">микроблог</a>.',
1375029405, 0, 0, 0, 0, 0, 0),
(109, 60, 'Загрузила <a href =
"photos.php?act=photo&id=15&show=comm">фото</a>.',
1375030067, 0, 0, 0, 0, 0, 0),
(110, 60, 'Загрузила <a href =
"photos.php?act=photo&id=16&show=comm">фото</a>.',
1375030222, 0, 0, 0, 0, 0, 0),
(111, 31, 'Оставил сообщение
в <a href = "arbour.php?">беседкке</a>.',
1375048617, 0, 0, 0, 0, 0, 1),
(112, 1, 'Оставил сообщение
в <a href = "arbour.php?">беседкке</a>.',
1375120159, 0, 0, 0, 0, 0, 1),
(113, 31, 'Оставил сообщение
в <a href = "arbour.php?">беседкке</a>.',
1375138263, 0, 0, 0, 0, 0, 1),
(114, 64, 'Сменил <a href =
"photo.php?act=view&id=38">аватар</a>.',
1375280547, 0, 0, 0, 0, 0, 0),
(115, 1, 'Сменил <a href =
"photo.php?act=view&id=39">аватар</a>.',
1389005476, 0, 0, 0, 0, 0, 0),
(116, 1, 'Сменил <a href =
"photo.php?act=view&id=40">аватар</a>.',
1389006561, 0, 0, 0, 0, 0, 0);
--
--------------------------------------------------------
--
--
Структура таблицы `lenta_blog`
--
CREATE TABLE IF NOT
EXISTS `lenta_blog` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user`
int(11) NOT NULL,
`text` text NOT NULL,
`time` int(11) NOT NULL,
`new` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=utf8 AUTO_INCREMENT=19 ;
--
--------------------------------------------------------
--
--
Структура таблицы `lenta_diary`
--
CREATE TABLE IF NOT
EXISTS `lenta_diary` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user`
int(11) NOT NULL,
`text` text NOT NULL,
`time` int(11) NOT NULL,
`new` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `lenta_forum`
--
CREATE TABLE IF NOT
EXISTS `lenta_forum` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user`
int(11) NOT NULL,
`text` text NOT NULL,
`time` int(11) NOT NULL,
`new` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `lenta_foto`
--
CREATE TABLE IF NOT
EXISTS `lenta_foto` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user`
int(11) NOT NULL,
`text` text NOT NULL,
`time` int(11) NOT NULL,
`new` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=utf8 AUTO_INCREMENT=30 ;
--
--------------------------------------------------------
--
--
Структура таблицы `mail_contacts`
--
CREATE TABLE IF NOT
EXISTS `mail_contacts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user`
int(11) NOT NULL,
`contact` int(11) NOT NULL,
`time` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=44
;
-- --------------------------------------------------------
--
--
Структура таблицы `mail_messages`
--
CREATE TABLE IF NOT
EXISTS `mail_messages` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user`
int(11) NOT NULL,
`inuser` int(11) NOT NULL,
`outuser` int(11) NOT
NULL,
`message` text NOT NULL,
`time` int(11) NOT NULL,
`new` int(11)
NOT NULL,
`id2` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=515 ;
--
--------------------------------------------------------
--
--
Структура таблицы `microblog_comm`
--
CREATE TABLE IF NOT
EXISTS `microblog_comm` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user`
int(11) NOT NULL,
`message` text NOT NULL,
`time` int(11) NOT NULL,
`microblog` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=utf8 AUTO_INCREMENT=7 ;
--
--------------------------------------------------------
--
--
Структура таблицы `microblog_like`
--
CREATE TABLE IF NOT
EXISTS `microblog_like` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user`
int(11) NOT NULL,
`time` int(11) NOT NULL,
`microblog` int(11) NOT
NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=11 ;
--
--------------------------------------------------------
--
--
Структура таблицы `microblog_messages`
--
CREATE TABLE IF
NOT EXISTS `microblog_messages` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL,
`message` text NOT NULL,
`time` int(11) NOT
NULL,
`view` int(11) NOT NULL,
`likes` int(11) NOT NULL,
`comm`
int(11) NOT NULL,
`main` int(11) NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;
--
--------------------------------------------------------
--
--
Структура таблицы `microblog_view`
--
CREATE TABLE IF NOT
EXISTS `microblog_view` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user`
int(11) NOT NULL,
`view` int(11) NOT NULL,
`last_time` int(11) NOT
NULL,
`time` int(11) NOT NULL,
`microblog` int(11) NOT NULL,
PRIMARY
KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=40 ;
--
--------------------------------------------------------
--
--
Структура таблицы `news`
--
CREATE TABLE IF NOT EXISTS
`news` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT
NULL,
`time` int(11) NOT NULL,
`name` text NOT NULL,
`message` text
NOT NULL,
`who` int(11) NOT NULL,
`cedit` int(11) NOT NULL,
`etime`
int(11) NOT NULL,
`close` int(11) NOT NULL,
`close_id` int(11) NOT
NULL,
`rating` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB
DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
--------------------------------------------------------
--
--
Структура таблицы `news_comm`
--
CREATE TABLE IF NOT
EXISTS `news_comm` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user`
int(11) NOT NULL,
`time` int(11) NOT NULL,
`message` text NOT NULL,
`news` int(11) NOT NULL,
`comm` int(11) NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `news_like`
--
CREATE TABLE IF NOT
EXISTS `news_like` (
`user` int(11) NOT NULL,
`time` int(11) NOT NULL,
`news` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
--------------------------------------------------------
--
--
Структура таблицы `photos_albums`
--
CREATE TABLE IF NOT
EXISTS `photos_albums` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name`
text NOT NULL,
`descr` text NOT NULL,
`user` int(11) NOT NULL,
`time`
int(11) NOT NULL,
`priv` int(11) NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;
--
--------------------------------------------------------
--
--
Структура таблицы `photos_comm`
--
CREATE TABLE IF NOT
EXISTS `photos_comm` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user`
int(11) NOT NULL,
`message` text NOT NULL,
`time` int(11) NOT NULL,
`photo` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=utf8 AUTO_INCREMENT=3 ;
--
--------------------------------------------------------
--
--
Структура таблицы `photos_like`
--
CREATE TABLE IF NOT
EXISTS `photos_like` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user`
int(11) NOT NULL,
`time` int(11) NOT NULL,
`photo` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=13
;
-- --------------------------------------------------------
--
--
Структура таблицы `photos_photo`
--
CREATE TABLE IF NOT
EXISTS `photos_photo` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name`
text NOT NULL,
`descr` text NOT NULL,
`user` int(11) NOT NULL,
`time`
int(11) NOT NULL,
`album` int(11) NOT NULL,
`rating` double NOT NULL,
`top` int(11) NOT NULL,
`edit` text NOT NULL,
`who` int(11) NOT NULL,
`cedit` int(11) NOT NULL,
`etime` int(11) NOT NULL,
PRIMARY KEY
(`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=17 ;
--
--------------------------------------------------------
--
--
Структура таблицы `popular`
--
CREATE TABLE IF NOT EXISTS
`popular` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT
NULL,
`time` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB
DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
--
--------------------------------------------------------
--
--
Структура таблицы `popular_history`
--
CREATE TABLE IF NOT
EXISTS `popular_history` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user`
int(11) NOT NULL,
`time` int(11) NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
--
--------------------------------------------------------
--
--
Структура таблицы `rating_history`
--
CREATE TABLE IF NOT
EXISTS `rating_history` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user`
int(11) NOT NULL,
`outuser` int(11) NOT NULL,
`time` int(11) NOT NULL,
`rating` int(11) NOT NULL,
`money` int(11) NOT NULL,
PRIMARY KEY
(`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
--
--------------------------------------------------------
--
--
Структура таблицы `ref`
--
CREATE TABLE IF NOT EXISTS
`ref` (
`id` int(11) NOT NULL,
`user` int(11) NOT NULL,
`moneyuser`
int(11) NOT NULL,
`data` text NOT NULL,
`ip` text NOT NULL
)
ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Дамп данных
таблицы `ref`
--
INSERT INTO `ref` (`id`, `user`, `moneyuser`,
`data`, `ip`) VALUES
(8, 12, 0, '1373823985', '217.212.231.103'),
(8, 15,
0, '1373826331', '95.133.61.60'),
(8, 16, 0, '1373827344',
'141.170.237.235'),
(8, 23, 0, '1373865667', '82.145.209.182');
--
--------------------------------------------------------
--
--
Структура таблицы `smiles`
--
CREATE TABLE IF NOT EXISTS
`smiles` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`code` text NOT NULL,
`category` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=31 ;
--
-- Дамп данных
таблицы `smiles`
--
INSERT INTO `smiles` (`id`, `code`, `category`)
VALUES
(1, ':)', 1),
(2, ':biggrin', 1),
(3, ':lol', 1),
(4, ':wink',
1),
(5, ':blink', 1),
(6, ':sad', 1),
(7, ':cool', 1),
(8, ':bebe', 1),
(9,
':shok', 1),
(10, ':plak', 1),
(11, ':plaksa', 1),
(12, ':blush', 1),
(13,
':shout', 1),
(14, ':unsure', 1),
(15, ':privet', 1),
(16, ':poka',
1),
(17, ':kiss', 1),
(18, ':skalka', 1),
(19, ':pivo', 1),
(20, ':devil',
1),
(21, ':dash', 1),
(22, ':druzhba', 1),
(23, ':kur', 1),
(24, ':cofe',
1),
(25, ':idiot', 1),
(26, ':fingal', 1),
(27, ':zlodej', 1),
(28,
':uzhas', 1),
(29, ':vopros', 1),
(30, ':poka2', 1);
--
--------------------------------------------------------
--
--
Структура таблицы `smiles_category`
--
CREATE TABLE IF NOT
EXISTS `smiles_category` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name`
text NOT NULL,
`ord` int(11) NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Дамп
данных таблицы `smiles_category`
--
INSERT INTO
`smiles_category` (`id`, `name`, `ord`) VALUES
(1, 'Основные',
0);
-- --------------------------------------------------------
--
--
Структура таблицы `spam`
--
CREATE TABLE IF NOT EXISTS
`spam` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT
NULL,
`spamer` int(11) NOT NULL,
`message` text NOT NULL,
`type` text
NOT NULL,
`time` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `users`
--
CREATE TABLE IF NOT EXISTS
`users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`login` text NOT NULL,
`pass` text NOT NULL,
`password` text NOT NULL,
`sex` text NOT NULL,
`admin` int(11) NOT NULL,
`likes` int(11) NOT NULL,
`rating` int(11)
NOT NULL,
`rating_time` int(11) NOT NULL,
`money` int(11) NOT NULL,
`money_time` int(11) NOT NULL,
`online` int(11) NOT NULL,
`location`
text NOT NULL,
`ban` int(11) NOT NULL,
`anketa_name` text NOT NULL,
`anketa_surname` text NOT NULL,
`anketa_bday` int(11) NOT NULL,
`anketa_bmonth` int(11) NOT NULL,
`anketa_byear` int(11) NOT NULL,
`anketa_sp` int(11) NOT NULL,
`anketa_spu` int(11) NOT NULL,
`anketa_city` text NOT NULL,
`anketa_mphone` text NOT NULL,
`anketa_icq` text NOT NULL,
`anketa_site` text NOT NULL,
`anketa_activity` text NOT NULL,
`anketa_interests` text NOT NULL,
`anketa_about` text NOT NULL,
`anketa_datareg` int(11) NOT NULL,
`anketa_alltime` int(11) NOT NULL,
`setting_theme` text NOT NULL,
`setting_users_list` text NOT NULL,
`setting_mail_list` text NOT NULL,
`setting_jurnal_list` text NOT NULL,
`priv_mypage` text NOT NULL,
`priv_anketa` text NOT NULL,
`priv_friends` text NOT NULL,
`priv_mail`
text NOT NULL,
`chat_location` int(11) NOT NULL,
`stat_arbour` int(11)
NOT NULL,
`stat_guestbook` int(11) NOT NULL,
`stat_chat` int(11) NOT
NULL,
`stat_forum_themes` int(11) NOT NULL,
`stat_forum_messages`
int(11) NOT NULL,
`count_mail` int(11) NOT NULL,
`count_friends`
int(11) NOT NULL,
`developer` int(11) NOT NULL,
`ip` char(20) NOT
NULL,
`ua` char(200) NOT NULL,
`mail` int(11) NOT NULL,
`money_ref`
int(11) NOT NULL,
`link` varchar(200) NOT NULL,
`clock` int(11) NOT
NULL,
`panel1` int(11) NOT NULL,
`panel2` int(11) NOT NULL,
`panel3`
int(11) NOT NULL,
`panel4` int(11) NOT NULL,
`panel5` int(11) NOT
NULL,
`panel6` int(11) NOT NULL,
`panel7` int(11) NOT NULL,
`panel8`
int(11) NOT NULL,
`panel9` int(11) NOT NULL,
`panel10` int(11) NOT
NULL,
`panel11` int(11) NOT NULL,
`panel12` int(11) NOT NULL,
`delete` int(11) NOT NULL,
`vip` int(11) NOT NULL,
`flirt1` int(11) NOT
NULL,
`flirt2` int(11) NOT NULL,
`flirt3` int(11) NOT NULL,
`flirt4`
int(11) NOT NULL,
`flirt5` int(11) NOT NULL,
`flirt6` int(11) NOT
NULL,
`flirt7` int(11) NOT NULL,
`flirt8` int(11) NOT NULL,
`smile`
varchar(20) NOT NULL,
`family` int(11) NOT NULL,
`growth` varchar(11)
NOT NULL DEFAULT '0',
`weight` varchar(11) NOT NULL DEFAULT '0',
`hair`
varchar(100) NOT NULL,
`eyes` varchar(100) NOT NULL,
`physique` int(11)
NOT NULL,
`character` varchar(100) NOT NULL,
`orientation` int(11) NOT
NULL,
`dating1` int(11) NOT NULL,
`dating2` int(11) NOT NULL,
`dating3` int(11) NOT NULL,
`dating4` int(11) NOT NULL,
`dating5`
int(11) NOT NULL,
`dating6` int(11) NOT NULL,
`dating7` int(11) NOT
NULL,
`dating8` int(11) NOT NULL,
`business` int(11) NOT NULL,
`profession` varchar(100) NOT NULL,
`smoke` int(11) NOT NULL,
`policy`
int(11) NOT NULL,
`world_view` int(11) NOT NULL,
`life` int(11) NOT
NULL,
`people` int(11) NOT NULL,
`inspire` varchar(1000) NOT NULL,
`pcolor` varchar(11) NOT NULL DEFAULT '#D4EEFF',
`plink` varchar(11) NOT
NULL DEFAULT '#434e60',
`pfon` varchar(11) NOT NULL DEFAULT '#b4c8e9',
`ncolor` varchar(11) NOT NULL DEFAULT '#FF0000',
`bb_code` int(11) NOT
NULL,
`evip` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB
DEFAULT CHARSET=utf8 AUTO_INCREMENT=68 ;
--
-- Дамп данных
таблицы `users`
--
INSERT INTO `users` (`id`, `login`, `pass`,
`password`, `sex`, `admin`, `likes`, `rating`, `rating_time`, `money`,
`money_time`, `online`, `location`, `ban`, `anketa_name`, `anketa_surname`,
`anketa_bday`, `anketa_bmonth`, `anketa_byear`, `anketa_sp`, `anketa_spu`,
`anketa_city`, `anketa_mphone`, `anketa_icq`, `anketa_site`,
`anketa_activity`, `anketa_interests`, `anketa_about`, `anketa_datareg`,
`anketa_alltime`, `setting_theme`, `setting_users_list`,
`setting_mail_list`, `setting_jurnal_list`, `priv_mypage`, `priv_anketa`,
`priv_friends`, `priv_mail`, `chat_location`, `stat_arbour`,
`stat_guestbook`, `stat_chat`, `stat_forum_themes`, `stat_forum_messages`,
`count_mail`, `count_friends`, `developer`, `ip`, `ua`, `mail`,
`money_ref`, `link`, `clock`, `panel1`, `panel2`, `panel3`, `panel4`,
`panel5`, `panel6`, `panel7`, `panel8`, `panel9`, `panel10`, `panel11`,
`panel12`, `delete`, `vip`, `flirt1`, `flirt2`, `flirt3`, `flirt4`,
`flirt5`, `flirt6`, `flirt7`, `flirt8`, `smile`, `family`, `growth`,
`weight`, `hair`, `eyes`, `physique`, `character`, `orientation`,
`dating1`, `dating2`, `dating3`, `dating4`, `dating5`, `dating6`,
`dating7`, `dating8`, `business`, `profession`, `smoke`, `policy`,
`world_view`, `life`, `people`, `inspire`, `pcolor`, `plink`, `pfon`,
`ncolor`, `bb_code`, `evip`) VALUES
(1, 'Admin',
'248a3e5b6a79d22a9e0a0efb9112bf0a', 'pro100admin', 'm', 1, 9, 98, 0, 0, 0,
1389007149, '', 0, '', '', 31, 1, 1988, 0, 0, '', '', '', '', '', 'PHP,
MySQL, CSS, HTML, JavaScript, Flash, C#', '', 1373708151, 318088, '', '',
'', '', '', '', '', '', 0, 1, 2, 7, 0, 0, 0, 0, 0, '94.178.210.32',
'Mozilla/5.0', 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0, 0, '', 1, '0', '0', 'Шатен', 'Зелёные', 3,
'Принциповы', 1, 0, 0, 0, 0, 0, 0, 0, 0, 7, '', 1, 4, 2, 1, 2,
'', '#D4EEFF', '#434e60', '#b4c8e9', '#FF0000', 0, 0);
--
--------------------------------------------------------
--
--
Структура таблицы `users_ban`
--
CREATE TABLE IF NOT
EXISTS `users_ban` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user`
int(11) NOT NULL,
`message` text NOT NULL,
`admin` int(11) NOT NULL,
`time` int(11) NOT NULL,
`time_ban` int(11) NOT NULL,
`who` int(11) NOT
NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `users_ban_post`
--
CREATE TABLE IF NOT
EXISTS `users_ban_post` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user`
int(11) NOT NULL,
`message` text NOT NULL,
`admin` int(11) NOT NULL,
`time` int(11) NOT NULL,
`time_ban` int(11) NOT NULL,
`who` int(11) NOT
NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=2 ;
--
--------------------------------------------------------
--
--
Структура таблицы `users_likes`
--
CREATE TABLE IF NOT
EXISTS `users_likes` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user`
int(11) NOT NULL,
`outuser` int(11) NOT NULL,
`time` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=33
;
-- --------------------------------------------------------
--
--
Структура таблицы `users_photo`
--
CREATE TABLE IF NOT
EXISTS `users_photo` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user`
int(11) NOT NULL,
`time` int(11) NOT NULL,
`page` int(11) NOT NULL,
`rating` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=utf8 AUTO_INCREMENT=41 ;
--
--------------------------------------------------------
--
--
Структура таблицы `users_photo_comm`
--
CREATE TABLE IF
NOT EXISTS `users_photo_comm` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL,
`message` text NOT NULL,
`time` int(11) NOT
NULL,
`photo` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB
DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;
--
--------------------------------------------------------
--
--
Структура таблицы `users_photo_like`
--
CREATE TABLE IF
NOT EXISTS `users_photo_like` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL,
`time` int(11) NOT NULL,
`photo` int(11) NOT
NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=34 ;
--
--------------------------------------------------------
--
--
Структура таблицы `wall`
--
CREATE TABLE IF NOT EXISTS
`wall` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT
NULL,
`message` text NOT NULL,
`time` int(11) NOT NULL,
`wall`
int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=utf8 AUTO_INCREMENT=7 ;
/*!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 */;