Вход Регистрация
Файл: vii engine 2.0.sql
Строк: 794
-- phpMyAdmin SQL Dump -- version 3.5.2 -- http://www.phpmyadmin.net -- --
Хост: localhost -- Время создания: Дек 22 2013 г.,
18:46 -- Версия сервера: 5.1.61 -- Версия PHP:
5.3.3 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 */; -- -- База данных: `evillion` -- --
-------------------------------------------------------- -- --
Структура таблицы `vii_albums` -- CREATE TABLE IF NOT
EXISTS `vii_albums` ( `aid` int(11) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(11) unsigned NOT NULL, `name` varchar(100) NOT NULL,
`descr` varchar(255) NOT NULL, `photo_num` smallint(6) unsigned NOT
NULL, `comm_num` mediumint(8) unsigned NOT NULL, `ahash` varchar(32)
NOT NULL, `adate` datetime NOT NULL, `cover` varchar(25) NOT NULL,
`position` smallint(6) unsigned NOT NULL, `privacy` varchar(3) NOT NULL,
PRIMARY KEY (`aid`), KEY `user_id` (`user_id`), KEY `photo_num`
(`photo_num`), KEY `position` (`position`), KEY `privacy` (`privacy`),
KEY `ahash` (`ahash`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `vii_antispam` -- CREATE TABLE IF NOT
EXISTS `vii_antispam` ( `act` tinyint(3) NOT NULL, `user_id` int(11)
NOT NULL, `date` int(10) NOT NULL, `txt` varchar(32) NOT NULL, KEY
`act` (`act`,`user_id`,`date`), KEY `act_2`
(`act`,`user_id`,`date`,`txt`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; --
-------------------------------------------------------- -- --
Структура таблицы `vii_apps` -- CREATE TABLE IF NOT EXISTS
`vii_apps` ( `id` int(11) NOT NULL AUTO_INCREMENT, `url` varchar(255)
NOT NULL, `flash` varchar(255) NOT NULL DEFAULT '', `title`
varchar(255) NOT NULL, `desc` varchar(255) NOT NULL, `img` varchar(255)
NOT NULL, `secret` varchar(255) NOT NULL, `balance` int(10) NOT NULL
DEFAULT '0', `cols` int(11) NOT NULL DEFAULT '0', `width` int(5) NOT
NULL DEFAULT '696', `height` int(5) NOT NULL DEFAULT '800', `status`
int(2) NOT NULL DEFAULT '-1', `type` int(11) NOT NULL, `admins`
varchar(255) NOT NULL DEFAULT '|0|', `admins_num` int(11) NOT NULL
DEFAULT '1', `user_id` int(10) NOT NULL, `app` int(11) NOT NULL,
`url_embed` text NOT NULL, `api_embed` text NOT NULL, `iframe` text NOT
NULL, `tb1.game_id` int(11) NOT NULL, PRIMARY KEY (`id`) )
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `vii_apps_transactions` -- CREATE TABLE
IF NOT EXISTS `vii_apps_transactions` ( `id` int(11) NOT NULL,
`application_id` int(11) NOT NULL, `votes` int(11) NOT NULL, `from`
int(11) NOT NULL, `whom` int(11) NOT NULL, `date` int(11) NOT NULL )
ENGINE=MyISAM DEFAULT CHARSET=utf8; --
-------------------------------------------------------- -- --
Структура таблицы `vii_apps_users` -- CREATE TABLE IF NOT
EXISTS `vii_apps_users` ( `id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL, `application_id` int(11) NOT NULL,
`balance` int(10) NOT NULL DEFAULT '0', `date` int(11) NOT NULL,
PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
; -- -------------------------------------------------------- -- --
Структура таблицы `vii_attach` -- CREATE TABLE IF NOT
EXISTS `vii_attach` ( `id` int(11) NOT NULL AUTO_INCREMENT, `photo`
varchar(255) NOT NULL, `ouser_id` int(11) NOT NULL, `acomm_num`
mediumint(8) NOT NULL, `public_id` int(11) NOT NULL, `add_date`
varchar(10) NOT NULL, PRIMARY KEY (`id`), KEY `photo` (`photo`), KEY
`public_id` (`public_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `vii_attach_comm` -- CREATE TABLE IF NOT
EXISTS `vii_attach_comm` ( `id` int(11) NOT NULL AUTO_INCREMENT,
`forphoto` varchar(30) NOT NULL, `auser_id` int(11) NOT NULL, `text`
text NOT NULL, `adate` varchar(10) NOT NULL, PRIMARY KEY (`id`), KEY
`forphoto` (`forphoto`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `vii_audio` -- CREATE TABLE IF NOT
EXISTS `vii_audio` ( `aid` int(11) unsigned NOT NULL AUTO_INCREMENT,
`auser_id` int(11) unsigned NOT NULL, `url` text NOT NULL, `artist`
varchar(50) NOT NULL, `name` varchar(50) NOT NULL, `adate` varchar(10)
NOT NULL, PRIMARY KEY (`aid`), KEY `auser_id` (`auser_id`), KEY
`adate` (`adate`), FULLTEXT KEY `artist` (`artist`,`name`) )
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `vii_banned` -- CREATE TABLE IF NOT
EXISTS `vii_banned` ( `id` int(11) NOT NULL AUTO_INCREMENT, `descr`
text NOT NULL, `date` varchar(15) NOT NULL, `always` smallint(4) NOT
NULL, `ip` varchar(50) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `vii_blog` -- CREATE TABLE IF NOT EXISTS
`vii_blog` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `title`
varchar(65) NOT NULL, `story` text NOT NULL, `date` varchar(15) NOT
NULL, PRIMARY KEY (`id`), KEY `date` (`date`) ) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `vii_city` -- CREATE TABLE IF NOT EXISTS
`vii_city` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`id_country` int(11) unsigned NOT NULL, `name` varchar(255) NOT NULL,
PRIMARY KEY (`id`), KEY `id_country` (`id_country`) ) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `vii_communities` -- CREATE TABLE IF NOT
EXISTS `vii_communities` ( `id` int(11) unsigned NOT NULL
AUTO_INCREMENT, `admin` text NOT NULL, `title` varchar(60) NOT NULL,
`descr` text NOT NULL, `cat` smallint(6) unsigned NOT NULL, `type`
tinyint(3) unsigned NOT NULL, `traf` int(11) unsigned NOT NULL, `ulist`
text NOT NULL, `date` datetime NOT NULL, `photo` varchar(25) NOT NULL,
`feedback` smallint(6) unsigned NOT NULL, `comments` tinyint(1) unsigned
NOT NULL, `real_admin` int(11) unsigned NOT NULL, `rec_num` int(11)
unsigned NOT NULL, `photos_num` int(11) unsigned NOT NULL, `del`
tinyint(2) NOT NULL, `ban` tinyint(2) NOT NULL, `adres` varchar(40) NOT
NULL, `audio_num` mediumint(8) NOT NULL, `forum_num` mediumint(8) NOT
NULL, `discussion` tinyint(1) NOT NULL, `status_text` varchar(255) NOT
NULL, `web` varchar(255) NOT NULL, `videos_num` int(11) NOT NULL,
`cover` varchar(25) NOT NULL, `cover_pos` varchar(4) NOT NULL, PRIMARY
KEY (`id`), KEY `del` (`del`), KEY `ban` (`ban`), KEY `traf`
(`traf`), KEY `photo` (`photo`), FULLTEXT KEY `title` (`title`) )
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `vii_communities_audio` -- CREATE TABLE
IF NOT EXISTS `vii_communities_audio` ( `aid` int(11) unsigned NOT NULL
AUTO_INCREMENT, `public_id` int(11) unsigned NOT NULL, `url` text NOT
NULL, `artist` varchar(50) NOT NULL, `name` varchar(50) NOT NULL,
`adate` varchar(10) NOT NULL, PRIMARY KEY (`aid`), KEY `auser_id`
(`public_id`), KEY `adate` (`adate`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `vii_communities_feedback` -- CREATE
TABLE IF NOT EXISTS `vii_communities_feedback` ( `cid` int(11) NOT NULL,
`fuser_id` int(11) NOT NULL, `office` varchar(30) NOT NULL, `fphone`
varchar(15) NOT NULL, `femail` varchar(40) NOT NULL, `fdate`
varchar(10) NOT NULL, KEY `cid` (`cid`), KEY `fuser_id` (`fuser_id`),
KEY `fdate` (`fdate`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; --
-------------------------------------------------------- -- --
Структура таблицы `vii_communities_forum` -- CREATE TABLE
IF NOT EXISTS `vii_communities_forum` ( `fid` int(11) unsigned NOT NULL
AUTO_INCREMENT, `public_id` int(11) unsigned NOT NULL, `fuser_id`
int(11) unsigned NOT NULL, `title` varchar(65) NOT NULL, `text` text
NOT NULL, `attach` text NOT NULL, `fdate` varchar(10) NOT NULL,
`msg_num` mediumint(8) unsigned NOT NULL, `lastdate` varchar(10) NOT
NULL, `lastuser_id` int(11) unsigned NOT NULL, `fixed` tinyint(2)
unsigned NOT NULL, `status` tinyint(2) unsigned NOT NULL, `vote`
mediumint(8) unsigned NOT NULL, PRIMARY KEY (`fid`), KEY `public_id`
(`public_id`), KEY `fdate` (`fdate`), KEY `lastdate` (`lastdate`),
KEY `fixed` (`fixed`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
; -- -------------------------------------------------------- -- --
Структура таблицы `vii_communities_forum_msg` -- CREATE
TABLE IF NOT EXISTS `vii_communities_forum_msg` ( `mid` int(11) unsigned
NOT NULL AUTO_INCREMENT, `fid` int(11) unsigned NOT NULL, `muser_id`
int(11) unsigned NOT NULL, `msg` text NOT NULL, `attach` text NOT
NULL, `mdate` varchar(10) NOT NULL, PRIMARY KEY (`mid`), KEY `fid`
(`fid`), KEY `muser_id` (`muser_id`), KEY `mdate` (`mdate`) )
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `vii_communities_join` -- CREATE TABLE
IF NOT EXISTS `vii_communities_join` ( `id` int(11) NOT NULL
AUTO_INCREMENT, `user_id` int(11) NOT NULL, `for_user_id` int(11) NOT
NULL, `public_id` int(11) NOT NULL, `date` varchar(10) NOT NULL,
PRIMARY KEY (`id`), KEY `for_sel` (`for_user_id`,`public_id`), KEY
`for_sel_1` (`user_id`,`public_id`,`date`), KEY `for_sel_2`
(`for_user_id`,`public_id`,`user_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `vii_communities_stats` -- CREATE TABLE
IF NOT EXISTS `vii_communities_stats` ( `gid` int(11) NOT NULL, `date`
int(10) NOT NULL, `cnt` int(11) NOT NULL, `hits` int(11) NOT NULL,
`new_users` int(11) NOT NULL, `exit_users` int(11) NOT NULL, `date_x`
int(10) NOT NULL, KEY `sel` (`gid`,`date`), KEY `date` (`date`), KEY
`cnt` (`cnt`), KEY `hits` (`hits`), KEY `new_users` (`new_users`),
KEY `exit_users` (`exit_users`), KEY `sel_1` (`gid`,`date_x`) )
ENGINE=MyISAM DEFAULT CHARSET=utf8; --
-------------------------------------------------------- -- --
Структура таблицы `vii_communities_stats_log` -- CREATE
TABLE IF NOT EXISTS `vii_communities_stats_log` ( `gid` int(11) NOT
NULL, `user_id` int(11) NOT NULL, `act` tinyint(3) NOT NULL, `date`
int(10) NOT NULL, KEY `gid` (`gid`,`user_id`,`date`,`act`) )
ENGINE=MyISAM DEFAULT CHARSET=utf8; --
-------------------------------------------------------- -- --
Структура таблицы `vii_communities_wall` -- CREATE TABLE
IF NOT EXISTS `vii_communities_wall` ( `id` int(11) unsigned NOT NULL
AUTO_INCREMENT, `public_id` int(11) unsigned NOT NULL, `text` text NOT
NULL, `add_date` varchar(15) NOT NULL, `fast_comm_id` int(11) unsigned
NOT NULL, `fasts_num` mediumint(8) unsigned NOT NULL, `likes_num`
mediumint(8) unsigned NOT NULL, `likes_users` text NOT NULL, `attach`
text NOT NULL, `tell_uid` int(11) unsigned NOT NULL, `tell_date`
varchar(10) NOT NULL, `public` tinyint(1) unsigned NOT NULL,
`tell_comm` text NOT NULL, `fixed` tinyint(1) unsigned NOT NULL,
PRIMARY KEY (`id`), KEY `fast_comm_id` (`fast_comm_id`), KEY
`public_id` (`public_id`), KEY `add_date` (`add_date`), KEY `tell_date`
(`tell_date`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `vii_communities_wall_like` -- CREATE
TABLE IF NOT EXISTS `vii_communities_wall_like` ( `rec_id` int(11)
unsigned NOT NULL, `user_id` int(11) unsigned NOT NULL, `date`
varchar(10) NOT NULL, KEY `rec_id` (`rec_id`), KEY `user_id`
(`user_id`), KEY `date` (`date`) ) ENGINE=MyISAM DEFAULT
CHARSET=utf8; --
-------------------------------------------------------- -- --
Структура таблицы `vii_country` -- CREATE TABLE IF NOT
EXISTS `vii_country` ( `id` int(5) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `vii_doc` -- CREATE TABLE IF NOT EXISTS
`vii_doc` ( `did` int(11) unsigned NOT NULL AUTO_INCREMENT, `duser_id`
int(11) unsigned NOT NULL, `dname` varchar(255) NOT NULL, `dsize`
varchar(10) NOT NULL, `ddate` varchar(10) NOT NULL, `ddownload_name`
varchar(30) NOT NULL, PRIMARY KEY (`did`), KEY `duser_id`
(`duser_id`), KEY `ddate` (`ddate`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `vii_fave` -- CREATE TABLE IF NOT EXISTS
`vii_fave` ( `user_id` int(11) unsigned NOT NULL, `fave_id` int(11)
unsigned NOT NULL, `date` datetime NOT NULL, KEY `for_fast_select1`
(`user_id`,`fave_id`,`date`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; --
-------------------------------------------------------- -- --
Структура таблицы `vii_friends` -- CREATE TABLE IF NOT
EXISTS `vii_friends` ( `user_id` int(11) NOT NULL, `friend_id` int(11)
unsigned NOT NULL, `friends_date` datetime NOT NULL, `subscriptions`
tinyint(3) unsigned NOT NULL, `views` mediumint(8) unsigned NOT NULL,
KEY `for_fast_select1` (`user_id`,`friend_id`,`friends_date`), KEY
`subscriptions` (`subscriptions`), KEY `views` (`views`), KEY
`friends_date` (`friends_date`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; --
-------------------------------------------------------- -- --
Структура таблицы `vii_friends_demands` -- CREATE TABLE IF
NOT EXISTS `vii_friends_demands` ( `for_user_id` int(11) unsigned NOT
NULL, `from_user_id` int(11) unsigned NOT NULL, `demand_date` datetime
NOT NULL, KEY `for_fast_select1`
(`for_user_id`,`from_user_id`,`demand_date`) ) ENGINE=MyISAM DEFAULT
CHARSET=utf8; --
-------------------------------------------------------- -- --
Структура таблицы `vii_games` -- CREATE TABLE IF NOT
EXISTS `vii_games` ( `id` int(11) NOT NULL AUTO_INCREMENT, `poster`
varchar(25) NOT NULL, `title` varchar(200) NOT NULL, `descr` text NOT
NULL, `flash` varchar(255) NOT NULL, `traf` int(11) NOT NULL, `date`
varchar(10) NOT NULL, `width` smallint(6) NOT NULL, `height`
smallint(6) NOT NULL, PRIMARY KEY (`id`), FULLTEXT KEY `title`
(`title`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `vii_games_activity` -- CREATE TABLE IF
NOT EXISTS `vii_games_activity` ( `user_id` int(11) NOT NULL, `action`
tinyint(2) NOT NULL, `date` varchar(10) NOT NULL, `game_id` int(11) NOT
NULL, KEY `for_select` (`user_id`,`game_id`), KEY `game_id`
(`game_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; --
-------------------------------------------------------- -- --
Структура таблицы `vii_games_files` -- CREATE TABLE IF NOT
EXISTS `vii_games_files` ( `game_id` int(11) NOT NULL, `user_id`
int(11) NOT NULL, `file` varchar(25) NOT NULL, `hash` varchar(32) NOT
NULL, `type` varchar(20) NOT NULL, KEY `hash` (`hash`,`type`), KEY
`for_select_3` (`hash`,`user_id`), KEY `game_id` (`game_id`), KEY
`for_select_4` (`game_id`,`type`), KEY `user_id`
(`user_id`,`type`,`game_id`), KEY `for_select`
(`hash`,`user_id`,`type`,`game_id`), KEY `file` (`file`) ) ENGINE=MyISAM
DEFAULT CHARSET=utf8; --
-------------------------------------------------------- -- --
Структура таблицы `vii_games_users` -- CREATE TABLE IF NOT
EXISTS `vii_games_users` ( `user_id` int(11) NOT NULL, `game_id`
int(11) NOT NULL, `setdate` varchar(10) NOT NULL, `lastdate`
varchar(10) NOT NULL, KEY `for_select` (`user_id`,`game_id`), KEY
`game_id` (`game_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; --
-------------------------------------------------------- -- --
Структура таблицы `vii_gifts` -- CREATE TABLE IF NOT
EXISTS `vii_gifts` ( `gid` int(11) unsigned NOT NULL AUTO_INCREMENT,
`uid` int(11) unsigned NOT NULL, `from_uid` int(11) unsigned NOT NULL,
`gift` varchar(10) NOT NULL, `msg` varchar(200) NOT NULL, `privacy`
tinyint(3) unsigned NOT NULL, `gdate` varchar(10) NOT NULL, `status`
tinyint(3) unsigned NOT NULL, PRIMARY KEY (`gid`), KEY `uid` (`uid`),
KEY `from_uid` (`from_uid`), KEY `status` (`status`), KEY `gdate`
(`gdate`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `vii_gifts_list` -- CREATE TABLE IF NOT
EXISTS `vii_gifts_list` ( `gid` int(11) NOT NULL AUTO_INCREMENT, `img`
varchar(50) NOT NULL, `price` mediumint(8) NOT NULL, PRIMARY KEY
(`gid`), KEY `img` (`img`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `vii_guests` -- CREATE TABLE IF NOT
EXISTS `vii_guests` ( `ouid` int(11) NOT NULL, `guid` int(11) NOT
NULL, `gdate` varchar(10) NOT NULL, `new` tinyint(1) NOT NULL, KEY
`ouid` (`ouid`), KEY `guid` (`guid`), KEY `new` (`new`) ) ENGINE=MyISAM
DEFAULT CHARSET=utf8; --
-------------------------------------------------------- -- --
Структура таблицы `vii_im` -- CREATE TABLE IF NOT EXISTS
`vii_im` ( `iuser_id` int(11) unsigned NOT NULL, `im_user_id` int(11)
unsigned NOT NULL, `idate` varchar(10) NOT NULL, `msg_num` mediumint(8)
unsigned NOT NULL, `all_msg_num` int(11) unsigned NOT NULL, KEY
`iuser_id` (`iuser_id`), KEY `im_user_id` (`im_user_id`), KEY `idate`
(`idate`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; --
-------------------------------------------------------- -- --
Структура таблицы `vii_invites` -- CREATE TABLE IF NOT
EXISTS `vii_invites` ( `uid` int(11) NOT NULL, `ruid` int(11) NOT
NULL, KEY `uid` (`uid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; --
-------------------------------------------------------- -- --
Структура таблицы `vii_log` -- CREATE TABLE IF NOT EXISTS
`vii_log` ( `uid` int(11) NOT NULL, `browser` text NOT NULL, `ip`
varchar(15) NOT NULL, KEY `uid` (`uid`) ) ENGINE=MyISAM DEFAULT
CHARSET=utf8; --
-------------------------------------------------------- -- --
Структура таблицы `vii_mail_tpl` -- CREATE TABLE IF NOT
EXISTS `vii_mail_tpl` ( `id` mediumint(8) NOT NULL AUTO_INCREMENT,
`text` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `vii_messages` -- CREATE TABLE IF NOT
EXISTS `vii_messages` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`theme` varchar(255) NOT NULL, `text` text NOT NULL, `for_user_id`
int(11) unsigned NOT NULL, `from_user_id` int(11) unsigned NOT NULL,
`history_user_id` int(11) unsigned NOT NULL, `date` varchar(15) NOT
NULL, `pm_read` char(3) NOT NULL, `folder` varchar(10) NOT NULL,
`attach` text NOT NULL, `tell_uid` int(11) unsigned NOT NULL,
`tell_date` varchar(10) NOT NULL, `public` tinyint(2) unsigned NOT NULL,
`tell_comm` text NOT NULL, PRIMARY KEY (`id`), KEY `for_fast_select1`
(`for_user_id`,`from_user_id`,`folder`,`history_user_id`), KEY `date`
(`date`), KEY `for_user_id` (`for_user_id`), KEY `from_user_id`
(`from_user_id`), KEY `history_user_id` (`history_user_id`), KEY
`folder` (`folder`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
; -- -------------------------------------------------------- -- --
Структура таблицы `vii_news` -- CREATE TABLE IF NOT EXISTS
`vii_news` ( `ac_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`ac_user_id` int(11) unsigned NOT NULL, `action_type` tinyint(4) unsigned
NOT NULL, `action_text` text NOT NULL, `obj_id` int(11) unsigned NOT
NULL, `action_time` int(11) unsigned NOT NULL, `for_user_id` int(11)
unsigned NOT NULL, `answer_text` text NOT NULL, `link` varchar(200) NOT
NULL, PRIMARY KEY (`ac_id`), KEY `for_fast_select1`
(`ac_user_id`,`action_time`), KEY `for_fast_select2`
(`ac_user_id`,`action_type`,`action_time`), KEY `for_user_id`
(`for_user_id`), KEY `obj_id` (`obj_id`), KEY `action_time`
(`action_time`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `vii_notes` -- CREATE TABLE IF NOT
EXISTS `vii_notes` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`owner_user_id` int(11) unsigned NOT NULL, `title` varchar(65) NOT NULL,
`full_text` text NOT NULL, `date` datetime NOT NULL, `comm_num`
mediumint(8) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `owner_user_id`
(`owner_user_id`), KEY `date` (`date`), FULLTEXT KEY `title`
(`title`,`full_text`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
; -- -------------------------------------------------------- -- --
Структура таблицы `vii_notes_comments` -- CREATE TABLE IF
NOT EXISTS `vii_notes_comments` ( `id` int(11) unsigned NOT NULL
AUTO_INCREMENT, `note_id` int(11) unsigned NOT NULL, `from_user_id`
int(11) unsigned NOT NULL, `text` text NOT NULL, `add_date` datetime
NOT NULL, PRIMARY KEY (`id`), KEY `note_id` (`note_id`), KEY
`from_user_id` (`from_user_id`), KEY `add_date` (`add_date`) )
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `vii_photos` -- CREATE TABLE IF NOT
EXISTS `vii_photos` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`album_id` int(11) unsigned NOT NULL, `photo_name` varchar(25) NOT NULL,
`user_id` int(11) unsigned NOT NULL, `descr` text NOT NULL, `comm_num`
mediumint(8) unsigned NOT NULL, `date` datetime NOT NULL, `position`
int(11) unsigned NOT NULL, `rating_num` int(11) NOT NULL, `rating_all`
int(11) NOT NULL, `rating_max` int(11) NOT NULL, PRIMARY KEY (`id`),
KEY `album_id` (`album_id`), KEY `user_id` (`user_id`), KEY `position`
(`position`), KEY `date` (`date`), KEY `photo_name` (`photo_name`) )
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `vii_photos_comments` -- CREATE TABLE IF
NOT EXISTS `vii_photos_comments` ( `id` int(11) unsigned NOT NULL
AUTO_INCREMENT, `owner_id` int(11) unsigned NOT NULL, `album_id`
int(11) unsigned NOT NULL, `pid` int(11) unsigned NOT NULL, `user_id`
mediumint(8) unsigned NOT NULL, `text` text NOT NULL, `date` datetime
NOT NULL, `hash` varchar(32) NOT NULL, `photo_name` varchar(25) NOT
NULL, PRIMARY KEY (`id`), KEY `owner_id` (`owner_id`), KEY `album_id`
(`album_id`), KEY `user_id` (`user_id`), KEY `hash` (`hash`), KEY
`photo_name` (`photo_name`), KEY `date` (`date`) ) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `vii_photos_mark` -- CREATE TABLE IF NOT
EXISTS `vii_photos_mark` ( `muser_id` int(11) unsigned NOT NULL,
`mphoto_id` int(11) unsigned NOT NULL, `mphoto_name` varchar(50) NOT
NULL, `mdate` varchar(15) NOT NULL, `msettings_pos` varchar(90) NOT
NULL, `mmark_user_id` int(11) unsigned NOT NULL, `mapprove` tinyint(1)
unsigned NOT NULL, KEY `muser_id` (`muser_id`), KEY `mphoto_id`
(`mphoto_id`), KEY `mdate` (`mdate`), FULLTEXT KEY `mphoto_name`
(`mphoto_name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; --
-------------------------------------------------------- -- --
Структура таблицы `vii_photos_rating` -- CREATE TABLE IF
NOT EXISTS `vii_photos_rating` ( `id` int(11) NOT NULL AUTO_INCREMENT,
`photo_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `date`
varchar(10) NOT NULL, `rating` tinyint(3) NOT NULL, `owner_user_id`
int(11) NOT NULL, PRIMARY KEY (`id`), KEY `for_select_1`
(`id`,`user_id`), KEY `for_select_2` (`photo_id`,`user_id`) )
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `vii_report` -- CREATE TABLE IF NOT
EXISTS `vii_report` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`act` varchar(10) NOT NULL, `type` smallint(5) unsigned NOT NULL,
`text` text NOT NULL, `mid` int(11) unsigned NOT NULL, `date`
varchar(10) NOT NULL, `ruser_id` int(11) unsigned NOT NULL, PRIMARY KEY
(`id`), KEY `ruser_id` (`ruser_id`), KEY `mid` (`mid`), KEY `act`
(`act`), KEY `date` (`date`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `vii_restore` -- CREATE TABLE IF NOT
EXISTS `vii_restore` ( `id` int(11) NOT NULL AUTO_INCREMENT, `email`
varchar(50) NOT NULL, `hash` varchar(32) NOT NULL, `ip` varchar(15) NOT
NULL, PRIMARY KEY (`id`), KEY `email` (`email`), KEY `hash`
(`hash`), KEY `ip` (`ip`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `vii_reviews` -- CREATE TABLE IF NOT
EXISTS `vii_reviews` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id`
int(11) NOT NULL, `text` text NOT NULL, `date` int(10) NOT NULL,
`approve` tinyint(1) NOT NULL, PRIMARY KEY (`id`), KEY `date`
(`date`), KEY `for_sel` (`user_id`,`approve`), KEY `approve`
(`approve`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `vii_sms_log` -- CREATE TABLE IF NOT
EXISTS `vii_sms_log` ( `user_id` int(11) NOT NULL, `from_u` varchar(20)
NOT NULL, `msg` varchar(100) NOT NULL, `operator_id` int(11) NOT NULL,
`country` int(11) NOT NULL, `short_number` varchar(50) NOT NULL,
`abonent_cost` float NOT NULL, `date` varchar(10) NOT NULL, KEY
`user_id` (`user_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; --
-------------------------------------------------------- -- --
Структура таблицы `vii_static` -- CREATE TABLE IF NOT
EXISTS `vii_static` ( `id` int(11) NOT NULL AUTO_INCREMENT, `alt_name`
varchar(50) NOT NULL, `title` varchar(150) NOT NULL, `text` text NOT
NULL, PRIMARY KEY (`id`), KEY `alt_name` (`alt_name`) ) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `vii_support` -- CREATE TABLE IF NOT
EXISTS `vii_support` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(65) NOT NULL, `question` text NOT NULL, `suser_id`
int(11) unsigned NOT NULL, `sfor_user_id` int(11) unsigned NOT NULL,
`sdate` varchar(15) NOT NULL, `сdate` varchar(15) NOT NULL, PRIMARY
KEY (`id`), KEY `suser_id` (`suser_id`), KEY `сdate` (`сdate`) )
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `vii_support_answers` -- CREATE TABLE IF
NOT EXISTS `vii_support_answers` ( `id` int(11) unsigned NOT NULL
AUTO_INCREMENT, `qid` int(11) unsigned NOT NULL, `auser_id` int(11)
unsigned NOT NULL, `adate` varchar(15) NOT NULL, `answer` text NOT
NULL, PRIMARY KEY (`id`), KEY `qid` (`qid`), KEY `auser_id`
(`auser_id`), KEY `adate` (`adate`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `vii_updates` -- CREATE TABLE IF NOT
EXISTS `vii_updates` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`for_user_id` mediumint(8) unsigned NOT NULL, `from_user_id` mediumint(8)
unsigned NOT NULL, `type` smallint(6) unsigned NOT NULL, `date`
varchar(10) NOT NULL, `text` text NOT NULL, `lnk` varchar(100) NOT
NULL, `user_search_pref` varchar(50) NOT NULL, `user_photo` varchar(25)
NOT NULL, PRIMARY KEY (`id`), KEY `for_user_id` (`for_user_id`), KEY
`date` (`date`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `vii_users` -- CREATE TABLE IF NOT
EXISTS `vii_users` ( `user_id` mediumint(11) NOT NULL AUTO_INCREMENT,
`user_email` varchar(50) NOT NULL, `user_password` varchar(32) NOT NULL,
`user_name` varchar(30) NOT NULL, `user_lastname` varchar(30) NOT NULL,
`user_photo` varchar(255) NOT NULL, `user_wall_id` int(11) NOT NULL,
`user_birthday` varchar(30) NOT NULL, `user_sex` varchar(3) NOT NULL,
`user_day` varchar(3) NOT NULL, `user_month` varchar(3) NOT NULL,
`user_year` varchar(4) NOT NULL, `user_country` varchar(6) NOT NULL,
`user_city` varchar(6) NOT NULL, `user_reg_date` varchar(20) NOT NULL,
`user_lastdate` varchar(20) NOT NULL, `user_group` varchar(1) NOT NULL,
`user_hid` varchar(64) NOT NULL, `user_country_city_name` varchar(100)
NOT NULL, `user_search_pref` varchar(60) NOT NULL, `user_xfields` text
NOT NULL, `xfields` text NOT NULL, `user_xfields_all` text NOT NULL,
`user_albums_num` smallint(6) NOT NULL, `user_friends_demands` int(11)
NOT NULL, `user_friends_num` mediumint(8) NOT NULL, `user_last_visit`
varchar(15) NOT NULL, `user_fave_num` mediumint(8) NOT NULL,
`user_pm_num` mediumint(8) NOT NULL, `user_notes_num` mediumint(8) NOT
NULL, `user_subscriptions_num` mediumint(8) NOT NULL, `user_videos_num`
mediumint(8) NOT NULL, `user_wall_num` int(11) NOT NULL, `user_status`
varchar(255) NOT NULL, `user_privacy` varchar(250) NOT NULL,
`user_blacklist_num` mediumint(8) NOT NULL, `user_blacklist` text NOT
NULL, `user_sp` varchar(10) NOT NULL, `user_support` smallint(6) NOT
NULL, `user_balance` mediumint(8) NOT NULL, `user_lastupdate`
varchar(10) NOT NULL, `user_gifts` mediumint(8) NOT NULL,
`user_public_num` mediumint(8) NOT NULL, `user_audio` int(11) NOT NULL,
`user_msg_type` tinyint(2) NOT NULL, `user_delet` tinyint(3) NOT NULL,
`user_ban` tinyint(3) NOT NULL, `user_ban_date` varchar(10) NOT NULL,
`user_new_mark_photos` mediumint(8) NOT NULL, `user_doc_num` mediumint(8)
NOT NULL, `user_logged_mobile` tinyint(1) NOT NULL, `guests`
mediumint(8) NOT NULL, `user_cover` varchar(25) NOT NULL,
`user_cover_pos` varchar(4) NOT NULL, `balance_rub` double NOT NULL,
`user_rating` mediumint(8) NOT NULL, `invties_pub_num` smallint(6) NOT
NULL, PRIMARY KEY (`user_id`), KEY `user_logged_hash` (`user_hid`),
KEY `user_password` (`user_password`), KEY `user_email` (`user_email`),
KEY `user_country` (`user_country`), KEY `user_city` (`user_city`), KEY
`user_photo` (`user_photo`), KEY `user_sex` (`user_sex`), KEY
`user_day` (`user_day`), KEY `user_month` (`user_month`), KEY
`user_year` (`user_year`), KEY `user_delet` (`user_delet`), KEY
`user_ban` (`user_ban`), KEY `user_reg_date` (`user_reg_date`), KEY
`user_last_visit` (`user_last_visit`), KEY `user_sp` (`user_sp`), KEY
`user_rating` (`user_rating`), KEY `user_search_pref`
(`user_search_pref`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
; -- -------------------------------------------------------- -- --
Структура таблицы `vii_users_rating` -- CREATE TABLE IF
NOT EXISTS `vii_users_rating` ( `id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL, `for_user_id` int(11) NOT NULL, `addnum`
int(11) NOT NULL, `date` varchar(10) NOT NULL, PRIMARY KEY (`id`),
KEY `for_select` (`user_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `vii_users_stats` -- CREATE TABLE IF NOT
EXISTS `vii_users_stats` ( `user_id` int(11) unsigned NOT NULL, `users`
int(11) unsigned NOT NULL, `views` int(11) unsigned NOT NULL, `date`
int(6) unsigned NOT NULL, `date_x` int(8) unsigned NOT NULL, KEY `date`
(`date`), KEY `user_id` (`user_id`), KEY `date_x` (`date_x`), KEY
`views` (`views`), KEY `users` (`users`) ) ENGINE=MyISAM DEFAULT
CHARSET=utf8; --
-------------------------------------------------------- -- --
Структура таблицы `vii_users_stats_log` -- CREATE TABLE IF
NOT EXISTS `vii_users_stats_log` ( `user_id` int(11) unsigned NOT NULL,
`for_user_id` int(11) unsigned NOT NULL, `date` int(8) unsigned NOT
NULL, KEY `user_id` (`user_id`,`for_user_id`,`date`) ) ENGINE=MyISAM
DEFAULT CHARSET=utf8; --
-------------------------------------------------------- -- --
Структура таблицы `vii_videos` -- CREATE TABLE IF NOT
EXISTS `vii_videos` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`owner_user_id` int(11) unsigned NOT NULL, `public_id` int(11) unsigned
NOT NULL, `video` text NOT NULL, `photo` varchar(255) NOT NULL,
`title` varchar(65) NOT NULL, `descr` text NOT NULL, `comm_num`
mediumint(8) unsigned NOT NULL, `add_date` datetime NOT NULL, `privacy`
tinyint(3) unsigned NOT NULL, `views` mediumint(8) unsigned NOT NULL,
PRIMARY KEY (`id`), KEY `owner_user_id` (`owner_user_id`), KEY
`privacy` (`privacy`), KEY `public_id` (`public_id`), KEY `add_date`
(`add_date`), FULLTEXT KEY `title` (`title`) ) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `vii_videos_comments` -- CREATE TABLE IF
NOT EXISTS `vii_videos_comments` ( `id` int(11) unsigned NOT NULL
AUTO_INCREMENT, `author_user_id` int(11) unsigned NOT NULL, `video_id`
int(11) unsigned NOT NULL, `text` text NOT NULL, `add_date` datetime
NOT NULL, PRIMARY KEY (`id`), KEY `for_fast_select1`
(`author_user_id`,`video_id`), KEY `add_date` (`add_date`) )
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `vii_votes` -- CREATE TABLE IF NOT
EXISTS `vii_votes` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title`
varchar(80) NOT NULL, `answers` text NOT NULL, `answer_num`
mediumint(8) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `vii_votes_result` -- CREATE TABLE IF
NOT EXISTS `vii_votes_result` ( `id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL, `vote_id` int(11) NOT NULL, `answer`
tinyint(3) NOT NULL, PRIMARY KEY (`id`), KEY `user_id` (`user_id`),
KEY `vote_id` (`vote_id`), KEY `answer` (`answer`) ) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `vii_wall` -- CREATE TABLE IF NOT EXISTS
`vii_wall` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`author_user_id` int(11) unsigned NOT NULL, `for_user_id` int(11)
unsigned NOT NULL, `text` text NOT NULL, `add_date` varchar(15) NOT
NULL, `fast_comm_id` int(11) unsigned NOT NULL, `fasts_num`
mediumint(8) unsigned NOT NULL, `likes_num` mediumint(8) unsigned NOT
NULL, `likes_users` text NOT NULL, `tell_uid` int(11) unsigned NOT
NULL, `tell_date` varchar(11) NOT NULL, `type` varchar(100) NOT NULL,
`public` tinyint(1) unsigned NOT NULL, `attach` text NOT NULL,
`tell_comm` text NOT NULL, PRIMARY KEY (`id`), KEY `for_fast_select1`
(`for_user_id`,`author_user_id`), KEY `fast_comm_id` (`fast_comm_id`),
KEY `tell_uid` (`tell_uid`,`tell_date`), KEY `add_date` (`add_date`) )
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `vii_wall_like` -- CREATE TABLE IF NOT
EXISTS `vii_wall_like` ( `rec_id` int(11) unsigned NOT NULL, `user_id`
int(11) unsigned NOT NULL, `date` varchar(15) NOT NULL, KEY
`for_fast_select1` (`rec_id`,`user_id`), KEY `date` (`date`) )
ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!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 */;
Онлайн: 2
Реклама