Просмотр архива MODROTORCMS

--
-- Структура таблицы `admlog`
--
CREATE TABLE IF NOT
EXISTS `admlog` (
  `admlog_id` int(11) unsigned NOT NULL auto_increment,
 
`admlog_user` varchar(20) NOT NULL,
  `admlog_request` varchar(255) NOT
NULL default '',
  `admlog_referer` varchar(255) NOT NULL default '',
 
`admlog_ip` varchar(20) NOT NULL default '',
  `admlog_brow` varchar(25)
NOT NULL default '',
  `admlog_time` int(11) unsigned NOT NULL default
'0',
  PRIMARY KEY  (`admlog_id`)
) ENGINE=MyISAM  DEFAULT
CHARSET=utf8;

--
-- Структура таблицы `advert`
--
CREATE
TABLE IF NOT EXISTS `advert` (
  `adv_id` int(11) unsigned NOT NULL
auto_increment,
  `adv_url` varchar(100) NOT NULL,
  `adv_title`
varchar(100) NOT NULL,
  `adv_color` varchar(10) NOT NULL default '',
 
`adv_user` varchar(20) NOT NULL,
  PRIMARY KEY  (`adv_id`)
) ENGINE=MyISAM 
DEFAULT CHARSET=utf8;

--
-- Структура таблицы
`antimat`
--
CREATE TABLE IF NOT EXISTS `antimat` (
  `mat_id` int(11)
unsigned NOT NULL auto_increment,
  `mat_string` varchar(100) NOT NULL,
 
PRIMARY KEY  (`mat_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
--
Структура таблицы `avatars`
--
CREATE TABLE IF NOT EXISTS
`avatars` (
  `avatars_id` int(11) unsigned NOT NULL auto_increment,
 
`avatars_cats` smallint(4) unsigned NOT NULL,
  `avatars_name` varchar(20)
NOT NULL,
  PRIMARY KEY  (`avatars_id`),
  KEY `avatars_cats`
(`avatars_cats`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
--
Структура таблицы `ban`
--
CREATE TABLE IF NOT EXISTS `ban`
(
  `ban_id` int(11) unsigned NOT NULL auto_increment,
  `ban_ip`
varchar(20) NOT NULL,
  `ban_user` varchar(20) NOT NULL default '',
 
`ban_time` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY 
(`ban_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Структура
таблицы `bank`
--
CREATE TABLE IF NOT EXISTS `bank` (
  `bank_id`
int(11) unsigned NOT NULL auto_increment,
  `bank_user` varchar(20) NOT
NULL,
  `bank_sum` int(11) unsigned NOT NULL default '0',
  `bank_oper`
int(11) unsigned NOT NULL default '0',
  `bank_time` int(11) unsigned NOT
NULL default '0',
  PRIMARY KEY  (`bank_id`),
  UNIQUE KEY `bank_user`
(`bank_user`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
--
Структура таблицы `blacklogin`
--
CREATE TABLE IF NOT
EXISTS `blacklogin` (
  `black_id` int(11) unsigned NOT NULL
auto_increment,
  `black_login` varchar(20) NOT NULL,
  `black_user`
varchar(20) NOT NULL default '',
  `black_time` int(11) unsigned NOT NULL
default '0',
  PRIMARY KEY  (`black_id`),
  KEY `black_login`
(`black_login`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
--
Структура таблицы `blackmail`
--
CREATE TABLE IF NOT EXISTS
`blackmail` (
  `black_id` int(11) unsigned NOT NULL auto_increment,
 
`black_mail` varchar(50) NOT NULL,
  `black_user` varchar(20) NOT NULL
default '',
  `black_time` int(11) unsigned NOT NULL default '0',
  PRIMARY
KEY  (`black_id`),
  KEY `black_mail` (`black_mail`)
) ENGINE=MyISAM 
DEFAULT CHARSET=utf8;

--
-- Структура таблицы
`blogs`
--
CREATE TABLE IF NOT EXISTS `blogs` (
  `blogs_id` int(11)
unsigned NOT NULL auto_increment,
  `blogs_cats_id` smallint(4) unsigned
NOT NULL default '0',
  `blogs_user` varchar(20) NOT NULL,
  `blogs_title`
varchar(50) NOT NULL,
  `blogs_text` text NOT NULL,
  `blogs_tags`
varchar(100) NOT NULL,
  `blogs_rating` mediumint(8) NOT NULL default '0',

 `blogs_read` int(11) unsigned NOT NULL default '0',
  `blogs_comments`
mediumint(8) unsigned NOT NULL default '0',
  `blogs_time` int(11) unsigned
NOT NULL,
  PRIMARY KEY  (`blogs_id`),
  KEY `blogs_user` (`blogs_user`),
 
KEY `blogs_time` (`blogs_time`),
  KEY `blogs_cats_id` (`blogs_cats_id`)
)
ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Структура
таблицы `cats`
--
CREATE TABLE IF NOT EXISTS `cats` (
  `cats_id`
smallint(4) unsigned NOT NULL auto_increment,
  `cats_order` smallint(4)
unsigned NOT NULL default '0',
  `cats_parent` smallint(4) unsigned NOT
NULL default '0',
  `cats_name` varchar(100) NOT NULL,
  `cats_count`
mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY (`cats_id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Структура
таблицы `catsblog`
--
CREATE TABLE IF NOT EXISTS `catsblog` (
 
`cats_id` smallint(4) unsigned NOT NULL auto_increment,
  `cats_order`
smallint(4) unsigned NOT NULL default '0',
  `cats_name` varchar(100) NOT
NULL,
  `cats_count` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY
KEY  (`cats_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
--
Структура таблицы `chat`
--
CREATE TABLE IF NOT EXISTS
`chat` (
  `chat_id` int(11) unsigned NOT NULL auto_increment,
 
`chat_user` varchar(20) NOT NULL,
  `chat_text` text NOT NULL,
  `chat_ip`
varchar(20) NOT NULL,
  `chat_brow` varchar(25) NOT NULL,
  `chat_time`
int(11) unsigned NOT NULL,
  `chat_edit` varchar(20) NOT NULL default '',
 
`chat_edit_time` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY 
(`chat_id`),
  KEY `chat_time` (`chat_time`)
) ENGINE=MyISAM  DEFAULT
CHARSET=utf8;

--
-- Структура таблицы `commblog`
--
CREATE
TABLE IF NOT EXISTS `commblog` (
  `commblog_id` int(11) unsigned NOT NULL
auto_increment,
  `commblog_cats` smallint(4) unsigned NOT NULL,
 
`commblog_blog` int(11) unsigned NOT NULL,
  `commblog_text` text NOT
NULL,
  `commblog_author` varchar(20) NOT NULL,
  `commblog_time` int(11)
unsigned NOT NULL default '0',
  `commblog_ip` varchar(20) NOT NULL,
 
`commblog_brow` varchar(25) NOT NULL,
  PRIMARY KEY  (`commblog_id`),
  KEY
`commblog_blog` (`commblog_blog`),
  KEY `commblog_time`
(`commblog_time`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
--
Структура таблицы `commload`
--
CREATE TABLE IF NOT EXISTS
`commload` (
  `commload_id` int(11) unsigned NOT NULL auto_increment,
 
`commload_cats` smallint(4) unsigned NOT NULL,
  `commload_down`
mediumint(8) unsigned NOT NULL,
  `commload_text` text NOT NULL,
 
`commload_author` varchar(20) NOT NULL,
  `commload_time` int(11) unsigned
NOT NULL default '0',
  `commload_ip` varchar(20) NOT NULL,
 
`commload_brow` varchar(25) NOT NULL,
  PRIMARY KEY (`commload_id`),
  KEY
`commload_down` (`commload_down`),
  KEY `commload_time`
(`commload_time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
--
Структура таблицы `commnews`
--
CREATE TABLE IF NOT EXISTS
`commnews` (
  `commnews_id` int(11) unsigned NOT NULL auto_increment,
 
`commnews_news_id` mediumint(8) unsigned NOT NULL,
  `commnews_text` text
NOT NULL,
  `commnews_author` varchar(20) NOT NULL,
  `commnews_time`
int(11) unsigned NOT NULL,
  `commnews_ip` varchar(20) NOT NULL,
 
`commnews_brow` varchar(25) NOT NULL,
  PRIMARY KEY  (`commnews_id`),
  KEY
`commnews_news_id` (`commnews_news_id`),
  KEY `commnews_time`
(`commnews_time`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
--
Структура таблицы `commphoto`
--
CREATE TABLE IF NOT EXISTS
`commphoto` (
  `commphoto_id` int(11) unsigned NOT NULL auto_increment,
 
`commphoto_gid` mediumint(8) unsigned NOT NULL,
  `commphoto_text` text NOT
NULL,
  `commphoto_user` varchar(20) NOT NULL,
  `commphoto_time` int(11)
unsigned NOT NULL default '0',
  `commphoto_ip` varchar(20) NOT NULL,
 
`commphoto_brow` varchar(25) NOT NULL,
  PRIMARY KEY  (`commphoto_id`),
 
KEY `commphoto_gid` (`commphoto_gid`),
  KEY `commphoto_time`
(`commphoto_time`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
--
Структура таблицы `contact`
--
CREATE TABLE IF NOT EXISTS
`contact` (
  `contact_id` int(11) unsigned NOT NULL auto_increment,
 
`contact_user` varchar(20) NOT NULL,
  `contact_name` varchar(20) NOT
NULL,
  `contact_text` text NOT NULL,
  `contact_time` int(11) unsigned NOT
NULL,
  PRIMARY KEY  (`contact_id`),
  KEY `contact_user`
(`contact_user`),
  KEY `contact_time` (`contact_time`)
) ENGINE=MyISAM 
DEFAULT CHARSET=utf8;

--
-- Структура таблицы
`counter`
--
CREATE TABLE IF NOT EXISTS `counter` (
  `count_id` tinyint(1)
unsigned NOT NULL auto_increment,
  `count_hours` mediumint(8) unsigned NOT
NULL,
  `count_days` mediumint(8) unsigned NOT NULL,
  `count_allhosts`
int(11) unsigned NOT NULL,
  `count_allhits` int(11) unsigned NOT NULL,
 
`count_dayhosts` mediumint(8) unsigned NOT NULL,
  `count_dayhits`
mediumint(8) unsigned NOT NULL,
  `count_hosts24` mediumint(8) unsigned NOT
NULL,
  `count_hits24` mediumint(8) unsigned NOT NULL,
  PRIMARY KEY 
(`count_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
--
Структура таблицы `counter24`
--
CREATE TABLE IF NOT EXISTS
`counter24` (
  `count_id` mediumint(8) unsigned NOT NULL auto_increment,
 
`count_hour` mediumint(8) unsigned NOT NULL,
  `count_hosts` mediumint(8)
unsigned NOT NULL,
  `count_hits` mediumint(8) unsigned NOT NULL,
  PRIMARY
KEY  (`count_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
--
Структура таблицы `counter31`
--
CREATE TABLE IF NOT EXISTS
`counter31` (
  `count_id` mediumint(8) unsigned NOT NULL auto_increment,
 
`count_days` mediumint(8) unsigned NOT NULL,
  `count_hosts` mediumint(8)
unsigned NOT NULL,
  `count_hits` mediumint(8) unsigned NOT NULL,
  PRIMARY
KEY  (`count_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
--
Структура таблицы `downs`
--
CREATE TABLE IF NOT EXISTS
`downs` (
  `downs_id` mediumint(8) unsigned NOT NULL auto_increment,
 
`downs_cats_id` smallint(4) unsigned NOT NULL default '0',
  `downs_title`
varchar(100) NOT NULL,
  `downs_text` text NOT NULL,
  `downs_link`
varchar(50) NOT NULL,
  `downs_user` varchar(20) NOT NULL,
  `downs_author`
varchar(50) NOT NULL,
  `downs_site` varchar(50) NOT NULL default'',
 
`downs_screen` varchar(50) NOT NULL default'',
  `downs_time` int(11)
unsigned NOT NULL default '0',
  `downs_comments` mediumint(8) unsigned NOT
NULL default '0',
  `downs_raiting` mediumint(8) unsigned NOT NULL default
'0',
  `downs_rated` mediumint(8) unsigned NOT NULL default '0',
 
`downs_load` mediumint(8) unsigned NOT NULL default '0',
 
`downs_last_load` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY
(`downs_id`),
  KEY `downs_cats_id` (`downs_cats_id`),
  KEY `downs_time`
(`downs_time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
--
Структура таблицы `error`
--
CREATE TABLE IF NOT EXISTS
`error` (
  `error_id` int(11) unsigned NOT NULL auto_increment,
 
`error_num` smallint(4) unsigned NOT NULL,
  `error_request` varchar(255)
NOT NULL default '',
  `error_referer` varchar(255) NOT NULL default '',
 
`error_username` varchar(20) NOT NULL default '',
  `error_ip` varchar(20)
NOT NULL default '',
  `error_brow` varchar(25) NOT NULL default '',
 
`error_time` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY 
(`error_id`),
  KEY `error_num` (`error_num`)
) ENGINE=MyISAM  DEFAULT
CHARSET=utf8;

--
-- Структура таблицы `flood`
--
CREATE
TABLE IF NOT EXISTS `flood` (
  `flood_id` int(11) unsigned NOT NULL
auto_increment,
  `flood_user` varchar(20) NOT NULL,
  `flood_page`
varchar(30) NOT NULL,
  `flood_time` int(11) unsigned NOT NULL,
  PRIMARY
KEY  (`flood_id`),
  KEY `flood_user` (`flood_user`)
) ENGINE=MyISAM 
DEFAULT CHARSET=utf8;

--
-- Структура таблицы
`forums`
--
CREATE TABLE IF NOT EXISTS `forums` (
  `forums_id` smallint(4)
unsigned NOT NULL auto_increment,
  `forums_order` smallint(4) unsigned NOT
NULL default '0',
  `forums_parent` smallint(4) unsigned NOT NULL default
'0',
  `forums_title` varchar(100) NOT NULL,
  `forums_topics` int(11)
unsigned NOT NULL default '0',
  `forums_posts` int(11) unsigned NOT NULL
default '0',
  `forums_last_id` int(11) unsigned NOT NULL default '0',
 
`forums_last_themes` varchar(100) NOT NULL default '',
  `forums_last_user`
varchar(20) NOT NULL default '',
  `forums_last_time` int(11) unsigned NOT
NULL default '0',
  PRIMARY KEY  (`forums_id`)
) ENGINE=MyISAM  DEFAULT
CHARSET=utf8;

--
-- Структура таблицы `guest`
--
CREATE
TABLE IF NOT EXISTS `guest` (
  `guest_id` int(11) unsigned NOT NULL
auto_increment,
  `guest_user` varchar(20) NOT NULL,
  `guest_text` text
NOT NULL,
  `guest_ip` varchar(20) NOT NULL,
  `guest_brow` varchar(25) NOT
NULL,
  `guest_time` int(11) unsigned NOT NULL,
  `guest_reply` text NOT
NULL,
  `guest_edit` varchar(20) NOT NULL default '',
  `guest_edit_time`
int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`guest_id`),
  KEY
`guest_time` (`guest_time`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
--
Структура таблицы `headers`
--
CREATE TABLE IF NOT EXISTS
`headers` (
  `head_id` int(11) unsigned NOT NULL auto_increment,
 
`head_url` varchar(100) NOT NULL,
  `head_title` varchar(100) NOT NULL,
 
PRIMARY KEY  (`head_id`),
  KEY `head_url` (`head_url`)
) ENGINE=MyISAM 
DEFAULT CHARSET=utf8;

--
-- Структура таблицы
`ignore`
--
CREATE TABLE IF NOT EXISTS `ignore` (
  `ignore_id` int(11)
unsigned NOT NULL auto_increment,
  `ignore_user` varchar(20) NOT NULL,
 
`ignore_name` varchar(20) NOT NULL,
  `ignore_text` text NOT NULL,
 
`ignore_time` int(11) unsigned NOT NULL,
  PRIMARY KEY  (`ignore_id`),
 
KEY `ignore_user` (`ignore_user`),
  KEY `ignore_time` (`ignore_time`)
)
ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Структура
таблицы `inbox`
--
CREATE TABLE IF NOT EXISTS `inbox` (
  `inbox_id`
int(11) unsigned NOT NULL auto_increment,
  `inbox_user` varchar(20) NOT
NULL,
  `inbox_author` varchar(20) NOT NULL,
  `inbox_text` text NOT NULL,

 `inbox_time` int(11) unsigned NOT NULL,
  PRIMARY KEY  (`inbox_id`),
  KEY
`inbox_user` (`inbox_user`),
  KEY `inbox_time` (`inbox_time`)
)
ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Структура
таблицы `loads`
--
CREATE TABLE IF NOT EXISTS `loads` (
  `loads_id`
int(11) unsigned NOT NULL auto_increment,
  `loads_down` mediumint(8)
unsigned NOT NULL,
  `loads_ip` varchar(20) NOT NULL,
  `loads_time`
int(11) unsigned NOT NULL,
  PRIMARY KEY (`loads_id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8;

--
-- Структура таблицы
`lotinfo`
--
CREATE TABLE IF NOT EXISTS `lotinfo` (
  `lot_id` int(11)
unsigned NOT NULL auto_increment,
  `lot_date` smallint(4) unsigned NOT
NULL,
  `lot_sum` int(11) unsigned NOT NULL default '0',
  `lot_newnum`
smallint(4) unsigned NOT NULL default '0',
  `lot_oldnum` smallint(4)
unsigned NOT NULL default '0',
  `lot_winners` varchar(255) NOT NULL
default '',
  PRIMARY KEY  (`lot_id`)
) ENGINE=MyISAM  DEFAULT
CHARSET=utf8;

--
-- Структура таблицы `lotusers`
--
CREATE
TABLE IF NOT EXISTS `lotusers` (
  `lot_id` int(11) unsigned NOT NULL
auto_increment,
  `lot_user` varchar(20) NOT NULL,
  `lot_num` smallint(4)
unsigned NOT NULL default '0',
  `lot_time` int(11) unsigned NOT NULL
default '0',
  PRIMARY KEY  (`lot_id`)
) ENGINE=MyISAM  DEFAULT
CHARSET=utf8;

--
-- Структура таблицы
`navigation`
--
CREATE TABLE IF NOT EXISTS `navigation` (
  `nav_id`
int(11) unsigned NOT NULL auto_increment,
  `nav_url` varchar(100) NOT
NULL,
  `nav_title` varchar(100) NOT NULL,
  `nav_order` smallint(4)
unsigned NOT NULL default '0',
  PRIMARY KEY  (`nav_id`)
) ENGINE=MyISAM 
DEFAULT CHARSET=utf8;

--
-- Структура таблицы
`news`
--
CREATE TABLE IF NOT EXISTS `news` (
  `news_id` mediumint(8)
unsigned NOT NULL auto_increment,
  `news_title` varchar(100) NOT NULL,
 
`news_text` text NOT NULL,
  `news_author` varchar(20) NOT NULL,
 
`news_time` int(11) unsigned NOT NULL default '0',
  `news_comments`
mediumint(8) unsigned NOT NULL default '0',
  `news_closed` tinyint(1)
unsigned NOT NULL default '0',
  PRIMARY KEY  (`news_id`),
  KEY
`news_time` (`news_time`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
--
Структура таблицы `notebook`
--
CREATE TABLE IF NOT EXISTS
`notebook` (
  `note_id` int(11) unsigned NOT NULL auto_increment,
 
`note_user` varchar(20) NOT NULL,
  `note_text` text NOT NULL,
 
`note_time` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY 
(`note_id`),
  UNIQUE KEY `note_user` (`note_user`)
) ENGINE=MyISAM 
DEFAULT CHARSET=utf8;

--
-- Структура таблицы
`online`
--
CREATE TABLE IF NOT EXISTS `online` (
  `online_id` bigint(20)
unsigned NOT NULL auto_increment,
  `online_ip` varchar(20) NOT NULL,
 
`online_brow` varchar(25) NOT NULL,
  `online_time` int(11) unsigned NOT
NULL,
  `online_user` varchar(20) NOT NULL default '',
  PRIMARY KEY 
(`online_id`),
  KEY `online_ip` (`online_ip`)
) ENGINE=MyISAM  DEFAULT
CHARSET=utf8;

--
-- Структура таблицы `outbox`
--
CREATE
TABLE IF NOT EXISTS `outbox` (
  `outbox_id` int(11) unsigned NOT NULL
auto_increment,
  `outbox_user` varchar(20) NOT NULL,
  `outbox_author`
varchar(20) NOT NULL,
  `outbox_text` text NOT NULL,
  `outbox_time`
int(11) unsigned NOT NULL,
  PRIMARY KEY  (`outbox_id`),
  KEY
`outbox_user` (`outbox_user`),
  KEY `outbox_time` (`outbox_time`)
)
ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Структура
таблицы `person`
--
CREATE TABLE IF NOT EXISTS `person` (
 
`pers_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `pers_user`
varchar(20) NOT NULL,
  `pers_level` smallint(4) unsigned NOT NULL DEFAULT
'0',
  `pers_health` smallint(4) unsigned NOT NULL DEFAULT '100',
 
`pers_stamina` smallint(4) unsigned NOT NULL DEFAULT '0',
  `pers_force`
smallint(4) unsigned NOT NULL DEFAULT '0',
  `pers_arms1` smallint(4)
unsigned NOT NULL DEFAULT '0',
  `pers_arms2` smallint(4) unsigned NOT NULL
DEFAULT '0',
  `pers_arms3` smallint(4) unsigned NOT NULL DEFAULT '0',
 
`pers_arms4` smallint(4) unsigned NOT NULL DEFAULT '0',
 
`pers_arms1_level` smallint(4) unsigned NOT NULL DEFAULT '0',
 
`pers_arms2_level` smallint(4) unsigned NOT NULL DEFAULT '0',
 
`pers_arms3_level` smallint(4) unsigned NOT NULL DEFAULT '0',
 
`pers_arms4_level` smallint(4) unsigned NOT NULL DEFAULT '0',
 
`pers_arms1_cond` smallint(4) unsigned NOT NULL DEFAULT '0',
 
`pers_arms2_cond` smallint(4) unsigned NOT NULL DEFAULT '0',
 
`pers_arms3_cond` smallint(4) unsigned NOT NULL DEFAULT '0',
 
`pers_arms4_cond` smallint(4) unsigned NOT NULL DEFAULT '0',
 
`pers_totalwins` smallint(4) unsigned NOT NULL DEFAULT '0',
 
`pers_totalbattl` smallint(4) unsigned NOT NULL DEFAULT '0',
 
`pers_time_userparam` int(11) unsigned NOT NULL DEFAULT '0',
 
`pers_time_armsparam` int(11) unsigned NOT NULL DEFAULT '0',
 
`pers_time_creation` int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY
(`pers_id`),
  UNIQUE KEY `pers_user` (`pers_user`)
) ENGINE=MyISAM 
DEFAULT CHARSET=utf8;

--
-- Структура таблицы
`photo`
--
CREATE TABLE IF NOT EXISTS `photo` (
  `photo_id` mediumint(8)
unsigned NOT NULL auto_increment,
  `photo_user` varchar(20) NOT NULL,
 
`photo_title` varchar(50) NOT NULL,
  `photo_text` text NOT NULL,
 
`photo_link` varchar(50) NOT NULL,
  `photo_time` int(11) unsigned NOT
NULL,
  `photo_rating` mediumint(8) NOT NULL default '0',
  `photo_closed`
tinyint(1) unsigned NOT NULL default '0',
  `photo_comments` int(11)
unsigned NOT NULL default '0',
  PRIMARY KEY  (`photo_id`),
  KEY
`photo_user` (`photo_user`),
  KEY `photo_time` (`photo_time`)
)
ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Структура
таблицы `posts`
--
CREATE TABLE IF NOT EXISTS `posts` (
  `posts_id`
int(11) unsigned NOT NULL auto_increment,
  `posts_forums_id` smallint(4)
unsigned NOT NULL,
  `posts_topics_id` mediumint(8) unsigned NOT NULL,
 
`posts_user` varchar(20) NOT NULL,
  `posts_text` text NOT NULL,
 
`posts_time` int(11) unsigned NOT NULL,
  `posts_ip` varchar(20) NOT NULL,

 `posts_brow` varchar(25) NOT NULL,
  `posts_edit` varchar(20) NOT NULL
default '',
  `posts_edit_time` int(11) unsigned NOT NULL default '0',
 
PRIMARY KEY  (`posts_id`),
  KEY `posts_topics_id` (`posts_topics_id`),
 
KEY `posts_time` (`posts_time`)
) ENGINE=MyISAM  DEFAULT
CHARSET=utf8;

--
-- Структура таблицы `pyramid`
--
CREATE
TABLE IF NOT EXISTS `pyramid` (
  `pyramid_id` int(11) unsigned NOT NULL
auto_increment,
  `pyramid_link` varchar(50) NOT NULL,
  `pyramid_name`
varchar(50) NOT NULL,
  `pyramid_user` varchar(20) NOT NULL,
  PRIMARY KEY 
(`pyramid_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
--
Структура таблицы `ratedblog`
--
CREATE TABLE IF NOT EXISTS
`ratedblog` (
  `rated_id` int(11) unsigned NOT NULL auto_increment,
 
`rated_blog` int(11) unsigned NOT NULL,
  `rated_user` varchar(20) NOT
NULL,
  `rated_time` int(11) unsigned NOT NULL,
  PRIMARY KEY 
(`rated_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
--
Структура таблицы `rateddown`
--
CREATE TABLE IF NOT EXISTS
`rateddown` (
  `rated_id` int(11) unsigned NOT NULL auto_increment,
 
`rated_down` mediumint(8) unsigned NOT NULL,
  `rated_user` varchar(20) NOT
NULL,
  `rated_time` int(11) unsigned NOT NULL,
  PRIMARY KEY
(`rated_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
--
Структура таблицы `ratedphoto`
--
CREATE TABLE IF NOT
EXISTS `ratedphoto` (
  `rated_id` int(11) unsigned NOT NULL
auto_increment,
  `rated_photo` int(11) unsigned NOT NULL,
  `rated_user`
varchar(20) NOT NULL,
  `rated_time` int(11) unsigned NOT NULL,
  PRIMARY
KEY  (`rated_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
--
Структура таблицы `rating`
--
CREATE TABLE IF NOT EXISTS
`rating` (
  `rating_id` int(11) unsigned NOT NULL auto_increment,
 
`rating_user` varchar(20) NOT NULL,
  `rating_login` varchar(20) NOT NULL,

 `rating_vote` tinyint(1) unsigned NOT NULL,
  `rating_time` int(11)
unsigned NOT NULL default '0',
  PRIMARY KEY  (`rating_id`),
  KEY
`rating_user` (`rating_user`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
--
Структура таблицы `readblog`
--
CREATE TABLE IF NOT EXISTS
`readblog` (
  `read_id` int(11) unsigned NOT NULL auto_increment,
 
`read_blog` int(11) unsigned NOT NULL,
  `read_ip` varchar(20) NOT NULL,
 
`read_time` int(11) unsigned NOT NULL,
  PRIMARY KEY  (`read_id`)
)
ENGINE=MyISAM  DEFAULT CHARSET=utf8;


--
-- Структура
таблицы `rekuser`
--
CREATE TABLE IF NOT EXISTS `rekuser` (
 
`rek_id` int(11) unsigned NOT NULL auto_increment,
  `rek_site` varchar(50)
NOT NULL,
  `rek_name` varchar(50) NOT NULL,
  `rek_color` varchar(10) NOT
NULL default '',
  `rek_bold` tinyint(1) unsigned NOT NULL default '0',
 
`rek_user` varchar(20) NOT NULL,
  `rek_time` int(11) unsigned NOT NULL,
 
PRIMARY KEY  (`rek_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
--
Структура таблицы `rules`
--
CREATE TABLE IF NOT EXISTS
`rules` (
  `rules_id` tinyint(1) unsigned NOT NULL AUTO_INCREMENT,
 
`rules_text` text NOT NULL,
  `rules_time` int(11) unsigned NOT NULL
DEFAULT '0',
  PRIMARY KEY (`rules_id`)
) ENGINE=MyISAM  DEFAULT
CHARSET=utf8;

--
-- Структура таблицы `setting`
--
CREATE
TABLE IF NOT EXISTS `setting` (
  `setting_name` varchar(25) NOT NULL,
 
`setting_value` varchar(255) NOT NULL,
  PRIMARY KEY  (`setting_name`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Структура
таблицы `smiles`
--
CREATE TABLE IF NOT EXISTS `smiles` (
 
`smiles_id` int(11) unsigned NOT NULL auto_increment,
  `smiles_cats`
smallint(4) unsigned NOT NULL,
  `smiles_name` varchar(20) NOT NULL,
 
`smiles_code` varchar(20) NOT NULL,
  PRIMARY KEY  (`smiles_id`),
  KEY
`smiles_cats` (`smiles_cats`),
  KEY `smiles_code` (`smiles_code`)
)
ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Структура
таблицы `spam`
--
CREATE TABLE IF NOT EXISTS `spam` (
  `spam_id`
int(11) unsigned NOT NULL auto_increment,
  `spam_key` tinyint(1) unsigned
NOT NULL,
  `spam_idnum` int(11) unsigned NOT NULL,
  `spam_user`
varchar(20) NOT NULL,
  `spam_login` varchar(20) NOT NULL,
  `spam_text`
text NOT NULL,
  `spam_time` int(11) unsigned NOT NULL,
  `spam_addtime`
int(11) unsigned NOT NULL,
  `spam_link` varchar(100) NOT NULL,
  PRIMARY
KEY  (`spam_id`),
  KEY `spam_key` (`spam_key`),
  KEY `spam_time`
(`spam_time`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
--
Структура таблицы `status`
--
CREATE TABLE IF NOT EXISTS
`status` (
  `status_id` int(11) unsigned NOT NULL auto_increment,
 
`status_topoint` mediumint(8) unsigned NOT NULL,
  `status_point`
mediumint(8) unsigned NOT NULL,
  `status_name` varchar(50) NOT NULL,
 
`status_color` varchar(10) NOT NULL default '',
  PRIMARY KEY 
(`status_id`),
  KEY `status_topoint` (`status_topoint`),
  KEY
`status_point` (`status_point`)
) ENGINE=MyISAM  DEFAULT
CHARSET=utf8;

--
-- Структура таблицы `topics`
--
CREATE
TABLE IF NOT EXISTS `topics` (
  `topics_id` mediumint(8) unsigned NOT NULL
auto_increment,
  `topics_forums_id` smallint(4) unsigned NOT NULL,
 
`topics_title` varchar(100) NOT NULL,
  `topics_author` varchar(20) NOT
NULL,
  `topics_closed` tinyint(1) unsigned NOT NULL default '0',
 
`topics_locked` tinyint(1) unsigned NOT NULL default '0',
  `topics_posts`
int(11) unsigned NOT NULL default '0',
  `topics_last_user` varchar(20) NOT
NULL default '',
  `topics_last_time` int(11) unsigned NOT NULL default
'0',
  `topics_mod` varchar(255) NOT NULL default '',
  PRIMARY KEY 
(`topics_id`),
  KEY `topics_forums_id` (`topics_forums_id`),
  KEY
`topics_locked` (`topics_locked`),
  KEY `topics_last_time`
(`topics_last_time`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
--
Структура таблицы `trash`
--
CREATE TABLE IF NOT EXISTS
`trash` (
  `trash_id` int(11) unsigned NOT NULL auto_increment,
 
`trash_user` varchar(20) NOT NULL,
  `trash_author` varchar(20) NOT NULL,
 
`trash_text` text NOT NULL,
  `trash_time` int(11) unsigned NOT NULL,
 
`trash_del` int(11) unsigned NOT NULL,
  PRIMARY KEY  (`trash_id`),
  KEY
`trash_user` (`trash_user`),
  KEY `trash_time` (`trash_time`)
)
ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Структура
таблицы `users`
--
CREATE TABLE IF NOT EXISTS `users` (
  `users_id`
int(11) unsigned NOT NULL auto_increment,
  `users_login` varchar(20)
character set utf8 collate utf8_bin NOT NULL,
  `users_pass` varchar(40)
NOT NULL,
  `users_email` varchar(50) NOT NULL,
  `users_joined` int(11)
unsigned NOT NULL,
  `users_level` smallint(4) unsigned NOT NULL default
'107',
  `users_nickname` varchar(20) NOT NULL default '',
  `users_name`
varchar(20) NOT NULL default '',
  `users_country` varchar(30) NOT NULL
default '',
  `users_city` varchar(50) NOT NULL default '',
  `users_info`
text NOT NULL,
  `users_note` text NOT NULL,
  `users_site` varchar(50) NOT
NULL default '',
  `users_icq` int(10) unsigned NOT NULL default '0',
 
`users_jabber` varchar(50) NOT NULL default '',
  `users_gender` varchar(1)
NOT NULL default '',
  `users_birthday` varchar(10) NOT NULL default '',
 
`users_visits` int(11) unsigned NOT NULL default '0',
  `users_newprivat`
smallint(4) unsigned NOT NULL default '0',
  `users_newwall` smallint(4)
unsigned NOT NULL default '0',
  `users_allforum` int(11) unsigned NOT NULL
default '0',
  `users_allguest` int(11) unsigned NOT NULL default '0',
 
`users_allcomments` int(11) unsigned NOT NULL default '0',
  `users_themes`
varchar(20) NOT NULL default '',
  `users_postguest` smallint(4) unsigned
NOT NULL default '0',
  `users_postnews` smallint(4) unsigned NOT NULL
default '0',
  `users_postprivat` smallint(4) unsigned NOT NULL default
'0',
  `users_postforum` smallint(4) unsigned NOT NULL default '0',
 
`users_themesforum` smallint(4) unsigned NOT NULL default '0',
 
`users_postboard` smallint(4) unsigned NOT NULL default '0',
 
`users_timezone` varchar(3) NOT NULL default '0',
  `users_showtime`
tinyint(1) unsigned NOT NULL default '0',
  `users_bbpanel` tinyint(1)
unsigned NOT NULL default '0',
  `users_point` int(11) unsigned NOT NULL
default '0',
  `users_money` int(11) unsigned NOT NULL default '0',
 
`users_ban` tinyint(1) unsigned NOT NULL default '0',
  `users_timeban`
int(11) unsigned NOT NULL default '0',
  `users_timelastban` int(11)
unsigned NOT NULL default '0',
  `users_reasonban` text NOT NULL,
 
`users_loginsendban` varchar(20) NOT NULL default '',
  `users_totalban`
tinyint(2) unsigned NOT NULL default '0',
  `users_explainban` tinyint(1)
unsigned NOT NULL default '0',
  `users_status` varchar(50) NOT NULL
default '',
  `users_avatar` varchar(50) NOT NULL default '',
 
`users_picture` varchar(50) NOT NULL default '',
  `users_rating`
mediumint(8) NOT NULL default '0',
  `users_posrating` mediumint(8)
unsigned NOT NULL default '0',
  `users_negrating` mediumint(8) unsigned
NOT NULL default '0',
  `users_keypasswd` varchar(20) NOT NULL default '',

 `users_timepasswd` int(11) unsigned NOT NULL default '0',
 
`users_timelastlogin` int(11) unsigned NOT NULL default '0',
 
`users_confirmreg` tinyint(1) unsigned NOT NULL default '0',
 
`users_confirmregkey` varchar(30) NOT NULL default '',
  `users_secquest`
varchar(50) NOT NULL default '',
  `users_secanswer` varchar(40) NOT NULL
default '',
  `users_sumcredit` int(11) unsigned NOT NULL default '0',
 
`users_timecredit` int(11) unsigned NOT NULL default '0',
 
`users_timeaddlist` int(11) unsigned NOT NULL default '0',
 
`users_timenickname` int(11) unsigned NOT NULL default '0',
 
`users_ipbinding` tinyint(1) unsigned NOT NULL default '0',
 
`users_navigation` tinyint(1) unsigned NOT NULL default '0',
 
`users_person` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY 
(`users_id`),
  UNIQUE KEY `users_login` (`users_login`),
  KEY
`users_level` (`users_level`),
  KEY `users_email` (`users_email`),
  KEY
`users_nickname` (`users_nickname`),
  KEY `users_themes`
(`users_themes`),
  KEY `users_point` (`users_point`),
  KEY `users_money`
(`users_money`),
  KEY `users_rating` (`users_rating`)
) ENGINE=MyISAM 
DEFAULT CHARSET=utf8;

--
-- Структура таблицы
`visit`
--
CREATE TABLE IF NOT EXISTS `visit` (
  `visit_id` int(11)
unsigned NOT NULL auto_increment,
  `visit_user` varchar(20) NOT NULL,
 
`visit_self` varchar(255) NOT NULL default '',
  `visit_ip` varchar(20) NOT
NULL default '',
  `visit_count` int(11) unsigned NOT NULL default '0',
 
`visit_allcount` int(11) unsigned NOT NULL default '0',
  `visit_nowtime`
int(11) unsigned NOT NULL default '0',
  `visit_alltime` int(11) unsigned
NOT NULL default '0',
  PRIMARY KEY  (`visit_id`),
  UNIQUE KEY
`visit_user` (`visit_user`),
  KEY `visit_nowtime` (`visit_nowtime`),
  KEY
`visit_alltime` (`visit_alltime`)
) ENGINE=MyISAM  DEFAULT
CHARSET=utf8;

--
-- Структура таблицы `vote`
--
CREATE
TABLE IF NOT EXISTS `vote` (
  `vote_id` smallint(4) unsigned NOT NULL
auto_increment,
  `vote_title` varchar(100) NOT NULL,
  `vote_count`
smallint(4) unsigned NOT NULL default '0',
  `vote_closed` tinyint(1)
unsigned NOT NULL default '0',
  `vote_time` int(11) unsigned NOT NULL
default '0',
  PRIMARY KEY  (`vote_id`)
) ENGINE=MyISAM  DEFAULT
CHARSET=utf8;

--
-- Структура таблицы
`voteanswer`
--
CREATE TABLE IF NOT EXISTS `voteanswer` (
  `answer_id`
mediumint(8) unsigned NOT NULL auto_increment,
  `answer_vote_id`
smallint(4) unsigned NOT NULL,
  `answer_option` varchar(50) NOT NULL,
 
`answer_result` smallint(4) unsigned NOT NULL default '0',
  PRIMARY KEY 
(`answer_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
--
Структура таблицы `votepoll`
--
CREATE TABLE IF NOT EXISTS
`votepoll` (
  `poll_id` int(11) unsigned NOT NULL auto_increment,
 
`poll_vote_id` smallint(4) unsigned NOT NULL,
  `poll_user` varchar(20) NOT
NULL,
  PRIMARY KEY  (`poll_id`)
) ENGINE=MyISAM  DEFAULT
CHARSET=utf8;

--
-- Структура таблицы `wall`
--
CREATE
TABLE IF NOT EXISTS `wall` (
  `wall_id` int(11) unsigned NOT NULL
auto_increment,
  `wall_user` varchar(20) NOT NULL,
  `wall_login`
varchar(20) NOT NULL,
  `wall_text` text NOT NULL,
  `wall_time` int(11)
unsigned NOT NULL,
  PRIMARY KEY  (`wall_id`),
  KEY `wall_user`
(`wall_user`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;