<?php

/*
=================================================================
Bullet Energy - by White-Master 
-----------------------------------------------------------------
http://white-master.ru/
-----------------------------------------------------------------
Copyright (c) 2011 White-Master
=================================================================
Данный код защищен авторскими правами
=================================================================
Файл: sql.php
-----------------------------------------------------------------
Назначение: Формирование массива sql запросов для инсталяции.
=================================================================
*/
$tableSchema = array();
$tableSchema[] = "DROP TABLE IF EXISTS " . PREFIX . "_be_advertising";
$tableSchema[] = "DROP TABLE IF EXISTS " . PREFIX . "_be_attachment";
$tableSchema[] = "DROP TABLE IF EXISTS " . PREFIX . "_be_complaint";
$tableSchema[] = "DROP TABLE IF EXISTS " . PREFIX . "_be_feed";
$tableSchema[] = "DROP TABLE IF EXISTS " . PREFIX . "_be_complaint";
$tableSchema[] = "DROP TABLE IF EXISTS " . PREFIX . "_be_feed";
$tableSchema[] = "DROP TABLE IF EXISTS " . PREFIX . "_be_groups";
$tableSchema[] = "DROP TABLE IF EXISTS " . PREFIX . "_be_honor";
$tableSchema[] = "DROP TABLE IF EXISTS " . PREFIX . "_be_message";
$tableSchema[] = "DROP TABLE IF EXISTS " . PREFIX . "_be_moderator";
$tableSchema[] = "DROP TABLE IF EXISTS " . PREFIX . "_be_poll";
$tableSchema[] = "DROP TABLE IF EXISTS " . PREFIX . "_be_poll_answers";
$tableSchema[] = "DROP TABLE IF EXISTS " . PREFIX . "_be_poll_log";
$tableSchema[] = "DROP TABLE IF EXISTS " . PREFIX . "_be_question";
$tableSchema[] = "DROP TABLE IF EXISTS " . PREFIX . "_be_read_topic";
$tableSchema[] = "DROP TABLE IF EXISTS " . PREFIX . "_be_read_tree";
$tableSchema[] = "DROP TABLE IF EXISTS " . PREFIX . "_be_session";
$tableSchema[] = "DROP TABLE IF EXISTS " . PREFIX . "_be_thanks";
$tableSchema[] = "DROP TABLE IF EXISTS " . PREFIX . "_be_topic";
$tableSchema[] = "DROP TABLE IF EXISTS " . PREFIX . "_be_topic_log";
$tableSchema[] = "DROP TABLE IF EXISTS " . PREFIX . "_be_tree";
$tableSchema[] = "DROP TABLE IF EXISTS " . PREFIX . "_be_user_title";
$tableSchema[] = "DROP TABLE IF EXISTS " . PREFIX . "_be_user_warning";
$tableSchema[] = "DROP TABLE IF EXISTS " . PREFIX . "_be_sub_template";
/**/
$tableSchema[] = "CREATE TABLE " . PREFIX . "_be_advertising  (
  `advertising_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `advertising_name` varchar(255) NOT NULL,
  `advertising_group` mediumblob NOT NULL COMMENT 'serialize array group view advertising',
  `advertising_tree` mediumblob NOT NULL COMMENT 'serialize array tree view advertising',
  `advertising_topic` enum('none','top','footer','random') NOT NULL DEFAULT 'none',
  `advertising_tree_display` enum('none','top','footer','random') NOT NULL DEFAULT 'none',
  `advertising_display` enum('none','display') NOT NULL DEFAULT 'none',
  `advertising_content` mediumblob NOT NULL,
  PRIMARY KEY (`advertising_id`),
  KEY `advertising_display` (`advertising_display`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=" . COLLATE . " AUTO_INCREMENT = 1";
/**/
$tableSchema[] = "CREATE TABLE " . PREFIX . "_be_attachment  (
  `attachment_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `attachment_date` int(10) unsigned NOT NULL,
  `attachment_type` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `attachment_name` varchar(255) NOT NULL DEFAULT '',
  `attachment_user_name` varchar(40) NOT NULL DEFAULT '',
  `attachment_user_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `attachment_content_id` int(11) unsigned NOT NULL DEFAULT '0',
  `attachment_count` smallint(5) unsigned NOT NULL DEFAULT '0',
  `size` int(11) unsigned NOT NULL DEFAULT '0',
  `topic_id` int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`attachment_id`),
  KEY `attachment_content_id` (`attachment_content_id`),
  KEY `topic_id` (`topic_id`),
  KEY `attachment_count` (`attachment_count`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=" . COLLATE . " AUTO_INCREMENT = 1";
/**/
$tableSchema[] = "CREATE TABLE " . PREFIX . "_be_complaint  (
  `ct_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `ct_msg_id` int(10) unsigned NOT NULL DEFAULT '0',
  `ct_date` int(10) unsigned NOT NULL,
  `ct_text` text NOT NULL,
  `ct_from` varchar(40) NOT NULL DEFAULT '',
  PRIMARY KEY (`ct_id`),
  KEY `ct_msg_id` (`ct_msg_id`),
  KEY `ct_date` (`ct_date`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=" . COLLATE . " AUTO_INCREMENT = 1";
/**/
$tableSchema[] = "CREATE TABLE " . PREFIX . "_be_feed  (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `id_user` int(11) unsigned NOT NULL DEFAULT '0',
  `id_topic` int(11) unsigned NOT NULL DEFAULT '0',
  `id_tree` int(10) unsigned NOT NULL DEFAULT '0',
  `date` int(10) unsigned NOT NULL DEFAULT '0',
  `is_mail` enum('no','yes') NOT NULL DEFAULT 'no',
  PRIMARY KEY (`id`),
  KEY `id_user` (`id_user`),
  KEY `id_topic` (`id_topic`),
  KEY `id_tree` (`id_tree`),
  KEY `is_mail` (`is_mail`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=" . COLLATE . " AUTO_INCREMENT = 1";
/**/
$tableSchema[] = "CREATE TABLE " . PREFIX . "_be_groups  (
  `be_groups_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `be_style_name_css` varchar(255) NOT NULL DEFAULT '',
  `be_style_group_css` varchar(255) NOT NULL DEFAULT '',
  `be_access_view_forum` tinyint(1) NOT NULL DEFAULT '0',
  `be_access_view_forum_off` tinyint(1) NOT NULL DEFAULT '0',
  `be_access_flood_check_none` tinyint(1) NOT NULL DEFAULT '0',
  `be_access_thanks` tinyint(1) NOT NULL DEFAULT '0',
  `be_upload` tinyint(1) NOT NULL DEFAULT '0',
  `be_upload_img` tinyint(1) NOT NULL DEFAULT '0',
  `be_access_topic_new_private` tinyint(1) NOT NULL DEFAULT '0',
  `be_access_search` tinyint(1) NOT NULL DEFAULT '0',
  `be_access_del_my_post` tinyint(1) NOT NULL DEFAULT '0',
  `be_access_edit_my_post` tinyint(1) NOT NULL DEFAULT '0',
  `be_access_del_my_topic` tinyint(1) NOT NULL DEFAULT '0',
  `be_access_hide` tinyint(1) NOT NULL DEFAULT '0',
  `be_access_download` tinyint(1) NOT NULL DEFAULT '0',
  `be_access_mat_check` tinyint(1) NOT NULL DEFAULT '0',
  `be_moder_topic_wanted` tinyint(1) NOT NULL DEFAULT '0',
  `be_moder_topic_moder_param` tinyint(1) NOT NULL DEFAULT '0',
  `be_moder_edit_message_user` tinyint(1) NOT NULL DEFAULT '0',
  `be_moder_del_message_user` tinyint(1) NOT NULL DEFAULT '0',
  `be_moder_moder_access` tinyint(1) NOT NULL DEFAULT '0',
  `be_moder_moder_view` tinyint(1) NOT NULL DEFAULT '0',
  `be_moder_del_user_topic` tinyint(1) NOT NULL DEFAULT '0',
  `be_moder_close_to_open_topic` tinyint(1) NOT NULL DEFAULT '0',
  `be_moder_ip_view` tinyint(1) NOT NULL DEFAULT '0',
  `be_moder_top_rename` tinyint(1) NOT NULL DEFAULT '0',
  `be_moder_top_view_private` tinyint(1) NOT NULL DEFAULT '0',
  `be_complaint` tinyint(1) NOT NULL DEFAULT '0',
  `be_status` tinyint(1) NOT NULL DEFAULT '0',
  `be_time_step_msg` smallint(5) NOT NULL DEFAULT '0',
  `be_captha_status` tinyint(1) NOT NULL DEFAULT '0',
  `be_fix` tinyint(1) NOT NULL DEFAULT '0',
  `be_replic_is_cloze` tinyint(1) NOT NULL DEFAULT '0',
  `be_create_vote` tinyint(1) NOT NULL DEFAULT '0',
  `be_replic_vote` tinyint(1) NOT NULL DEFAULT '0',
  `be_preview_topic` tinyint(1) NOT NULL DEFAULT '0',
  `be_load_ajax_topic` tinyint(1) NOT NULL DEFAULT '0',
  `be_sort` tinyint(1) NOT NULL DEFAULT '0',
  `be_warning` tinyint(1) NOT NULL DEFAULT '0',
  `be_warning_delete` tinyint(1) NOT NULL DEFAULT '0',
  `be_view_warning_log` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`be_groups_id`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=" . COLLATE . " AUTO_INCREMENT = 6";
/**/
$tableSchema[] = "CREATE TABLE " . PREFIX . "_be_message  (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `id_topic` int(11) unsigned NOT NULL DEFAULT '0',
  `autors_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `message_autor` varchar(40) NOT NULL DEFAULT '',
  `message_autor_ip` int(11) NOT NULL DEFAULT '0',
  `message_date` int(10) unsigned NOT NULL,
  `message_text` text NOT NULL,
  `message_approve` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `tree_id` int(10) unsigned NOT NULL DEFAULT '0',
  `parent_msg` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `fixap_msg` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `msg_edit_date` int(10) unsigned NOT NULL DEFAULT '0',
  `edit_autor` varchar(40) NOT NULL DEFAULT '',
  `edit_quote` varchar(255) NOT NULL DEFAULT '',
  `user_thanks` mediumblob NOT NULL COMMENT 'serialize array 3 user like',
  `thanks` int(11) unsigned NOT NULL DEFAULT '0',
  `attachment` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `is_warning_id` int(11) unsigned DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `id_topic` (`id_topic`),
  KEY `autors_id` (`autors_id`),
  KEY `message_autor` (`message_autor`),
  KEY `message_date` (`message_date`),
  KEY `parent_msg` (`parent_msg`),
  KEY `fixap_msg` (`fixap_msg`),
  KEY `tree_id` (`tree_id`),
  KEY `thanks` (`thanks`),
  FULLTEXT KEY `message_text` (`message_text`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=" . COLLATE . " AUTO_INCREMENT = 1";
/**/
$tableSchema[] = "CREATE TABLE " . PREFIX . "_be_moderator  (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `moderator_id` int(10) unsigned NOT NULL DEFAULT '0',
  `moderator_name` varchar(40) NOT NULL DEFAULT '',
  `moderator_super` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `moderator_tree_id` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `moderator_id` (`moderator_id`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=" . COLLATE . " AUTO_INCREMENT = 1";
/**/
$tableSchema[] = "CREATE TABLE " . PREFIX . "_be_poll  (
  `vote_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `vote_topic_id` int(11) unsigned NOT NULL,
  `vote_question` varchar(255) NOT NULL,
  `answers` mediumblob NOT NULL,
  `vote_count` int(10) unsigned NOT NULL DEFAULT '0',
  `multi` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `visible_vote_user` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `close_date` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`vote_id`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=" . COLLATE . " AUTO_INCREMENT = 1";
/**/
$tableSchema[] = "CREATE TABLE " . PREFIX . "_be_poll_answers  (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `vote_id` int(10) unsigned NOT NULL,
  `answers` varchar(100) NOT NULL,
  `answers_count` int(10) unsigned NOT NULL DEFAULT '0',
  `user_vote` mediumblob NOT NULL,
  PRIMARY KEY (`id`),
  KEY `vote_id` (`vote_id`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=" . COLLATE . " AUTO_INCREMENT = 1";
/**/
$tableSchema[] = "CREATE TABLE " . PREFIX . "_be_poll_log  (
  `user_id` int(10) unsigned NOT NULL,
  `answers_id` int(10) unsigned NOT NULL,
  `vote_id` int(10) unsigned NOT NULL,
  `vote_date` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`answers_id`,`user_id`),
  KEY `pid` (`vote_id`,`user_id`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=" . COLLATE . " AUTO_INCREMENT = 1";
/**/
$tableSchema[] = "CREATE TABLE " . PREFIX . "_be_question  (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `question` varchar(255) NOT NULL,
  `answers` mediumblob COMMENT 'serialize array answers to questions',
  `is_active` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `is_active` (`is_active`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=" . COLLATE . " AUTO_INCREMENT = 7";
/**/
$tableSchema[] = "CREATE TABLE " . PREFIX . "_be_read_topic  (
  `ber_read_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ber_user_id` int(10) unsigned NOT NULL,
  `ber_topic_id` int(10) unsigned NOT NULL,
  `ber_tree_id` int(10) unsigned NOT NULL,
  `ber_read_date` int(10) unsigned NOT NULL,
  PRIMARY KEY (`ber_read_id`),
  UNIQUE KEY `ber_ut_id` (`ber_user_id`,`ber_topic_id`),
  KEY `ber_read_date` (`ber_read_date`),
  KEY `ber_tree_id` (`ber_tree_id`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=" . COLLATE . " AUTO_INCREMENT = 1";
/**/
$tableSchema[] = "CREATE TABLE " . PREFIX . "_be_read_tree  (
  `bert_read_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `bert_user_id` int(10) unsigned NOT NULL,
  `bert_tree_id` int(10) unsigned NOT NULL,
  `bert_read_date` int(10) unsigned NOT NULL,
  PRIMARY KEY (`bert_read_id`),
  UNIQUE KEY `bert_user_tree` (`bert_user_id`,`bert_tree_id`),
  KEY `tree_read_date` (`bert_read_date`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=" . COLLATE . " AUTO_INCREMENT = 1";
/**/
$tableSchema[] = "CREATE TABLE " . PREFIX . "_be_session  (
  `session_id` varchar(32) NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `key` int(10) NOT NULL DEFAULT '0',
  `ip` int(10) NOT NULL DEFAULT '0',
  `date` int(10) unsigned NOT NULL,
  `user_group` int(11) unsigned NOT NULL DEFAULT '5',
  `info_type` int(10) unsigned NOT NULL,
  `param_state` mediumblob COMMENT 'serialize info view tree',
  PRIMARY KEY (`user_id`,`key`),
  KEY `date` (`date`),
  KEY `user_id` (`user_id`),
  KEY `info_type` (`info_type`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=" . COLLATE . " AUTO_INCREMENT = 1";
/**/
$tableSchema[] = "CREATE TABLE " . PREFIX . "_be_thanks  (
  `thanks_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `thanks_msg_id` int(11) unsigned NOT NULL,
  `thanks_id_user` int(10) unsigned NOT NULL,
  `thanks_date` int(10) unsigned NOT NULL,
  `thanks_msg_id_user` int(10) unsigned NOT NULL,
  PRIMARY KEY (`thanks_id`),
  UNIQUE KEY `msg_id_user` (`thanks_msg_id`,`thanks_id_user`),
  KEY `user_msg_id_date` (`thanks_msg_id_user`,`thanks_date`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=" . COLLATE . " AUTO_INCREMENT = 1";
/**/
$tableSchema[] = "CREATE TABLE " . PREFIX . "_be_topic  (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `id_parent` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `title` varchar(255) NOT NULL DEFAULT '',
  `reply_count` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `view_count` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `autor_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `autor` varchar(40) NOT NULL DEFAULT '',
  `post_date` int(10) unsigned NOT NULL,
  `last_reply_date` int(10) unsigned NOT NULL,
  `last_reply_info` mediumblob COMMENT 'serialize info last post info',
  `rating` smallint(5) NOT NULL DEFAULT '0',
  `topic_fixed` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `topic_type` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `topic_private_user` mediumblob COMMENT 'serialize user is topic private',
  `topic_descr_site` varchar(255) NOT NULL DEFAULT '',
  `topic_approve` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `topic_meta` mediumblob NOT NULL,
  `vote_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `is_fixed_count` smallint(5) unsigned NOT NULL DEFAULT '0',
  `post_id` int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `id_parent` (`id_parent`),
  KEY `autor` (`autor`),
  KEY `autor_id` (`autor_id`),
  KEY `topic_fixed` (`topic_fixed`),
  KEY `topic_approve` (`topic_approve`),
  KEY `post_date` (`post_date`),
  KEY `last_reply_date` (`last_reply_date`),
  KEY `reply_count` (`reply_count`),
  KEY `rating` (`rating`),
  KEY `view_count` (`view_count`),
  FULLTEXT KEY `title` (`title`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=" . COLLATE . " AUTO_INCREMENT = 1";
/**/
$tableSchema[] = "CREATE TABLE " . PREFIX . "_be_topic_log  (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `topic_id` int(10) unsigned NOT NULL DEFAULT '0',
  `user` varchar(40) NOT NULL DEFAULT '',
  `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `user_ip` int(11) NOT NULL DEFAULT '0',
  `stack` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `is_vote` (`topic_id`,`user_id`),
  KEY `topic_id` (`topic_id`),
  KEY `user_id` (`user_id`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=" . COLLATE . " AUTO_INCREMENT = 1";
/**/
$tableSchema[] = "CREATE TABLE " . PREFIX . "_be_tree  (
  `tree_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `tree_title` varchar(255) NOT NULL,
  `tree_description` text NOT NULL,
  `tree_parent_id` int(10) unsigned NOT NULL DEFAULT '0',
  `tree_display` int(10) unsigned NOT NULL DEFAULT '1',
  `tree_type` tinyint(5) unsigned NOT NULL DEFAULT '0',
  `tree_type_sub` varchar(255) NOT NULL,
  `tree_approve` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `tree_count` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `tree_pass` mediumblob COMMENT 'is pass',
  `tree_info_titl` varchar(255) NOT NULL,
  `tree_info_text` text NOT NULL,
  `tree_last_date` int(10) unsigned NOT NULL DEFAULT '0',
  `tree_last_info` mediumblob NOT NULL,
  `tree_topic` int(10) unsigned NOT NULL DEFAULT '0',
  `tree_answer` int(10) unsigned NOT NULL DEFAULT '0',
  `tree_access_topic_new` varchar(255) NOT NULL,
  `tree_access_topic_read` varchar(255) NOT NULL,
  `tree_access_topic_replic` varchar(255) NOT NULL,
  `tree_access_view` varchar(255) NOT NULL,
  `tree_is_pass_no` varchar(255) NOT NULL,
  PRIMARY KEY (`tree_id`),
  KEY `tree_parent_id` (`tree_parent_id`),
  KEY `tree_display` (`tree_display`),
  KEY `tree_approve` (`tree_approve`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=" . COLLATE . " AUTO_INCREMENT = 1";
/**/
$tableSchema[] = "CREATE TABLE " . PREFIX . "_be_user_title  (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `bals` int(10) unsigned NOT NULL DEFAULT '0',
  `title` varchar(250) NOT NULL,
  PRIMARY KEY (`id`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=" . COLLATE . " AUTO_INCREMENT = 1";
/**/
$tableSchema[] = "CREATE TABLE " . PREFIX . "_be_user_warning  (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `moderator_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `post_id` int(10) unsigned NOT NULL DEFAULT '0',
  `date` int(10) unsigned NOT NULL DEFAULT '0',
  `description` tinytext NOT NULL,
  `id_user` int(11) unsigned DEFAULT '0',
  `date_out` int(10) unsigned DEFAULT '0',
  `action` enum('up','down') NOT NULL DEFAULT 'down',
  `type` enum('comment','message') NOT NULL DEFAULT 'message',
  `ball` mediumint(8) unsigned DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `moderator_id` (`moderator_id`),
  KEY `post_id` (`post_id`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=" . COLLATE . " AUTO_INCREMENT = 1";
/**/
$tableSchema[] = "CREATE TABLE " . PREFIX . "_be_honor  (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `bals` int(10) unsigned NOT NULL DEFAULT '0',
  `criteria` mediumblob NOT NULL,
  PRIMARY KEY (`id`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=" . COLLATE . " AUTO_INCREMENT = 1";
/**/
$tableSchema[] = "CREATE TABLE " . PREFIX . "_be_sub_template  (
  `action` enum('discussion','rules') NOT NULL DEFAULT 'discussion',
  `param` mediumblob NOT NULL
  ) ENGINE=MyISAM  DEFAULT CHARSET=" . COLLATE . " AUTO_INCREMENT = 1";
/**/
$tableSchema[] = "ALTER TABLE " . PREFIX . "_users ADD forum_post_count smallint(5) DEFAULT '0'";
$tableSchema[] = "ALTER TABLE " . PREFIX . "_users ADD forum_topic_count smallint(5) DEFAULT '0'";
$tableSchema[] = "ALTER TABLE " . PREFIX . "_users ADD forum_thanks_count mediumint(7) DEFAULT '0'";
$tableSchema[] = "ALTER TABLE " . PREFIX . "_users ADD forum_warning smallint(5) DEFAULT '0'";
$tableSchema[] = "ALTER TABLE " . PREFIX . "_users ADD forum_inseption mediumblob COMMENT 'array honor,title and other info'";
/**/
$tableSchema[] = "INSERT INTO " . PREFIX . "_be_groups (`be_groups_id`, `be_style_name_css`, `be_style_group_css`, `be_access_view_forum`, `be_access_view_forum_off`, `be_access_flood_check_none`, `be_access_thanks`, `be_upload`, `be_upload_img`, `be_access_topic_new_private`, `be_access_search`, `be_access_del_my_post`, `be_access_edit_my_post`, `be_access_del_my_topic`, `be_access_hide`, `be_access_download`, `be_access_mat_check`, `be_moder_topic_wanted`, `be_moder_topic_moder_param`, `be_moder_edit_message_user`, `be_moder_del_message_user`, `be_moder_moder_access`, `be_moder_moder_view`, `be_moder_del_user_topic`, `be_moder_close_to_open_topic`, `be_moder_ip_view`, `be_moder_top_rename`, `be_moder_top_view_private`, `be_complaint`, `be_status`, `be_time_step_msg`, `be_captha_status`, `be_fix`, `be_replic_is_cloze`, `be_create_vote`, `be_replic_vote`, `be_preview_topic`, `be_load_ajax_topic`, `be_sort`, `be_warning`, `be_warning_delete`, `be_view_warning_log`) VALUES
(4, 'visitors-name', 'visitors', 1, 0, 0, 1, 1, 1, 0, 1, 0, 1, 0, 1, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 1, 0, 5, 0, 0, 0, 1, 1, 1, 1, 0, 0, 0, 0),
(5, 'guest-name', 'guest', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(3, 'journalist-name', 'journalist', 1, 0, 0, 1, 1, 1, 0, 1, 0, 1, 0, 1, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 1, 0, 20, 0, 0, 0, 1, 1, 1, 1, 0, 0, 0, 0),
(2, 'editors-name', 'editors', 1, 0, 0, 1, 1, 1, 0, 1, 0, 1, 0, 1, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 1, 0, 10, 0, 0, 0, 1, 1, 1, 1, 0, 0, 0, 0),
(1, 'administrator-name', 'administrator', 1, 1, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 1)";
/**/
$tableSchema[] = "INSERT INTO " . PREFIX . "_be_question (`id`, `question`, `answers`, `is_active`) VALUES
(1, 'Имя первого космонавта?', 0xdef0e8e93c7365703edef0e0, 1),
(2, 'Как называется наша планета?', 0xc7e5ecebff, 1),
(3, 'Что светит в небе?', 0xd1eeebedf6e53c7365703eebf3ede0, 1),
(4, '2+2=', 0x343c7365703ef7e5f2fbf0e5, 1),
(5, '8+8=', 0x31363c7365703ef8e5f1f2ede0e4f6e0f2fc, 1),
(6, 'Самая большая страна мира по площади?', 0xd0eef1f1e8ff, 1)";
/**/
$tableSchema[] = "INSERT INTO " . PREFIX . "_be_sub_template (`action`, `param`) VALUES
('discussion', 0x613a333a7b733a363a22707265666978223b733a31333a22cee1f1f3e6e4e5ede8e5202d20223b733a373a22636f6e74656e74223b733a36333a22c220e4e0ededeee920f2e5ece520eee1f1f3e6e4e0e5f2f1ff20f1f2e0f2fcff207b7469746c657d2c20eeeff3e1ebe8eaeee2e0edede0ff207b646174657d223b733a343a2274726565223b693a323b7d);";
/**/
$tableSchema[] = "ALTER TABLE " . PREFIX . "_post ADD topic_id int(11) unsigned DEFAULT '0'";

?>