Просмотр архива Vii Engine

--
-- Структура таблицы `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;