+// @todo Review this test and see if we can find out what it is which prevents PHP 4.2.x from even displaying the page with requirements on it

+if (version_compare(phpversion(), '4.3.0') < 0)

+{

+ die('You are running an unsupported PHP version. Please upgrade to PHP 4.3.3 or higher before trying to install phpBB 3.0');

+}

+

+ 'L_CHANGE' => $lang['CHANGE'],

+ 'L_SELECT_LANG' => $lang['SELECT_LANG'],

+ header('Cache-Control: private, no-cache="set-cookie"');

+ global $db, $template;

+ * Generate an HTTP/1.1 header to redirect the user to another page

+ * This is used during the installation when we do not have a database available to call the normal redirect function

+ * @param string $page The page to redirect to relative to the installer root path

+ function redirect($page)

+ $server_name = (!empty($_SERVER['SERVER_NAME'])) ? $_SERVER['SERVER_NAME'] : getenv('SERVER_NAME');

+ $server_port = (!empty($_SERVER['SERVER_PORT'])) ? (int) $_SERVER['SERVER_PORT'] : (int) getenv('SERVER_PORT');

+ $secure = (isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] == 'on') ? 1 : 0;

+

+ $script_name = (!empty($_SERVER['PHP_SELF'])) ? $_SERVER['PHP_SELF'] : getenv('PHP_SELF');

+ if (!$script_name)

+ {

+ $script_name = (!empty($_SERVER['REQUEST_URI'])) ? $_SERVER['REQUEST_URI'] : getenv('REQUEST_URI');

+ }

+

+ // Replace backslashes and doubled slashes (could happen on some proxy setups)

+ $script_name = str_replace(array('\\', '//'), '/', $script_name);

+ $script_path = trim(dirname($script_name));

+

+ $url = (($secure) ? 'https://' : 'http://') . $server_name;

+

+ if ($server_port && (($secure && $server_port <> 443) || (!$secure && $server_port <> 80)))

+ {

+ $url .= ':' . $server_port;

+ }

+

+ $url .= $script_path . '/' . $page;

+ header('Location: ' . $url);

+ exit;

+ global $lang, $template, $phpEx, $language;

+ $url = $this->module_url . "?mode=$cat&amp;language=$language";

+ $url = $this->module_url . '?mode=' . $this->mode . "&amp;sub=$option&amp;language=$language";

+ 'LEGEND' => $lang['INST_ERR'],

+ // Rollback if in transaction

+ if ($db->transaction)

+ {

+ $db->sql_transaction('rollback');

+ }

+

+ $tpl = '<textarea id="' . $name . '" name="' . $name . '" rows="' . $rows . '" cols="' . $cols . '">' . $value . '</textarea>';

+ $tpl = '<select id="' . $name . '" name="' . $name . '">' . $s_options . '</select>';

+

+ /**

+ * Generate the drop down of available language packs

+ */

+ function inst_language_select($default = '')

+ {

+ global $phpbb_root_path, $phpEx;

+

+ $dir = @opendir($phpbb_root_path . 'language');

+

+ while ($file = readdir($dir))

+ {

+ $path = $phpbb_root_path . 'language/' . $file;

+

+ if (is_file($path) || is_link($path) || $file == '.' || $file == '..' || $file == 'CVS')

+ {

+ continue;

+ }

+

+ if (file_exists($path . '/iso.txt'))

+ {

+ list($displayname) = @file($path . '/iso.txt');

+ $lang[$displayname] = $file;

+ }

+ }

+ @closedir($dir);

+

+ @asort($lang);

+ @reset($lang);

+

+ $user_select = '';

+ foreach ($lang as $displayname => $filename)

+ {

+ $selected = (strtolower($default) == strtolower($filename)) ? ' selected="selected"' : '';

+ $user_select .= '<option value="' . $filename . '"' . $selected . '>' . ucwords($displayname) . '</option>';

+ }

+

+ return $user_select;

+ }

+if ( !defined('IN_INSTALL') )

+{

+ // Someone has tried to access the file direct. This is not a good idea, so exit

+ exit;

+}

+

+ 'module_stages' => array('INTRO', 'REQUIREMENTS', 'DATABASE', 'ADMINISTRATOR', 'CONFIG_FILE', 'ADVANCED', 'CREATE_TABLE', 'FINAL'),

+ global $lang, $template, $language;

+ 'TITLE' => $lang['INSTALL_INTRO'],

+ 'BODY' => $lang['INSTALL_INTRO_BODY'],

+ 'L_SUBMIT' => $lang['NEXT'],

+ 'S_LANG_SELECT' => '<select id="language" name="language">' . $this->p_master->inst_language_select($language) . '</select>',

+ 'U_ACTION' => $this->p_master->module_url . "?mode=$mode&amp;sub=requirements&amp;language=$language",

+ case 'create_table':

+

+ break;

+

+ case 'final' :

+ $this->add_language($mode, $sub);

+ global $lang, $template, $phpbb_root_path, $phpEx, $language;

+ $exe = ((defined('PHP_OS')) && (preg_match('#^win#i', PHP_OS))) ? '.exe' : '';

+ $url = ($passed['php'] && $passed['db'] && $passed['files']) ? $this->p_master->module_url . "?mode=$mode&amp;sub=database&amp;language=$language" : $this->p_master->module_url . "?mode=$mode&amp;sub=requirements&amp;language=$language ";

+

+ $dbpasswd = html_entity_decode($dbpasswd);

+ $s_hidden_fields .= '<input type="hidden" name="language" value="' . $language . '" />';

+ $this->p_master->redirect("index?mode=install");

+ // Test against the default username rules

+ if ($admin_name != '' && strlen($admin_name) < 3)

+ {

+ $error[] = $lang['INST_ERR_USER_TOO_SHORT'];

+ }

+

+ if ($admin_name != '' && strlen($admin_name) > 20)

+ {

+ $error[] = $lang['INST_ERR_USER_TOO_LONG'];

+ }

+

+ $s_hidden_fields .= '<input type="hidden" name="language" value="' . $language . '" />';

+ $this->p_master->redirect("index?mode=install");

+ $s_hidden_fields .= '<input type="hidden" name="language" value="' . $language . '" />';

+ $dbpasswd = html_entity_decode($dbpasswd);

+

+ $this->p_master->redirect("index?mode=install");

+ $s_hidden_fields .= '<input type="hidden" name="language" value="' . $language . '" />';

+ $email_enable = ($email_enable !== '') ? $email_enable : true;

+ $server_protocol = ($server_protocol !== '') ? $server_protocol : ((isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] == 'on') ? 'https://' : 'http://');

+ $cookie_secure = ($cookie_secure !== '') ? $cookie_secure : ((isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] == 'on') ? true : false);

+ $url = $this->p_master->module_url . "?mode=$mode&amp;sub=create_table";

+ $this->page_title = $lang['STAGE_CREATE_TABLE'];

+

+ $this->p_master->redirect("index?mode=install");

+ $dbpasswd = html_entity_decode($dbpasswd);

+

+

+ break;

+

+ case 'mysqli':

+ // mysqli only works with MySQL > 4.1.3 so we'll just do a straight replace if using this DBMS

+ $sql_query = preg_replace('/^\);$/m', ') DEFAULT CHARACTER SET latin1;', $sql_query);

+

+ // Deal with any special comments and with MySQL < 4.1.2

+ VALUES ('default_lang', '" . $db->sql_escape($default_lang) . "')",

+ SET username = '" . $db->sql_escape($admin_name) . "', user_password='" . $db->sql_escape(md5($admin_pass1)) . "', user_lang = '" . $db->sql_escape($default_lang) . "', user_email='" . $db->sql_escape($board_email1) . "', user_dateformat='" . $db->sql_escape($lang['default_dateformat']) . "', user_email_hash = '" . (int) (crc32(strtolower($board_email1)) . strlen($board_email1)) . "'

+

+ foreach ($this->request_vars as $var)

+ {

+ $s_hidden_fields .= '<input type="hidden" name="' . $var . '" value="' . $$var . '" />';

+ }

+

+ $submit = $lang['NEXT_STEP'];

+

+ $url = $this->p_master->module_url . "?mode=$mode&amp;sub=final";

+

+ $template->assign_vars(array(

+ 'BODY' => $lang['STAGE_CREATE_TABLE_EXPLAIN'],

+ 'L_SUBMIT' => $submit,

+ 'S_HIDDEN' => $s_hidden_fields,

+ 'U_ACTION' => $url,

+ ));

+ $dbpasswd = html_entity_decode($dbpasswd);

+

+ // Load the appropriate database class if not already loaded

+ include($phpbb_root_path . 'includes/db/' . $dbms . '.' . $phpEx);

+

+ // Instantiate the database

+ $sql_db = 'dbal_' . $dbms;

+ $db = new $sql_db();

+ $db->sql_connect($dbhost, $dbuser, $dbpasswd, $dbname, $dbport, false);

+

+ // NOTE: trigger_error does not work here.

+ $db->return_on_error = true;

+

+ 'module_basename' => '',

+ 'module_basename' => '',

+ foreach ($module_info as $module_basename => $fileinfo)

+ if (!isset($categories[$cat_name]))

+ {

+ continue;

+ }

+ 'module_basename' => $module_basename,

+ // Move some of the modules around since the code above will put them in the wrong place

+ WHERE module_basename = 'main'

+ WHERE module_basename = 'permissions'

+

+ // Move manage users screen module 4 up...

+ $sql = 'SELECT *

+ FROM ' . MODULES_TABLE . "

+ WHERE module_basename = 'users'

+ AND module_class = 'acp'

+ AND module_mode = 'overview'";

+ $result = $db->sql_query($sql);

+ $row = $db->sql_fetchrow($result);

+ $db->sql_freeresult($result);

+ $_module->move_module_by($row, 'move_up', 4);

+ }

+

+ $sql = 'SELECT module_id, left_id, right_id

+ FROM ' . MODULES_TABLE . "

+ WHERE module_langname = '" . $db->sql_escape($cat_name) . "'

+ AND module_class = '" . $db->sql_escape($module_class) . "'";

+ $sql = 'SELECT *

+ FROM ' . MODULES_TABLE . "

+ WHERE module_langname = '" . $db->sql_escape($mod_name) . "'

+ AND module_class = '" . $db->sql_escape($module_class) . "'

+ AND module_basename <> ''";

+ $result = $db->sql_query_limit($sql, 1);

+ * Populate the language tables

+ */

+ function add_language($mode, $sub)

+ {

+ global $db, $lang, $phpbb_root_path, $phpEx;

+

+ $dir = @opendir($phpbb_root_path . 'language');

+ while (($file = readdir($dir)) !== false)

+ {

+ $path = $phpbb_root_path . 'language/' . $file;

+

+ if (is_dir($path) && !is_link($path) && file_exists($path . '/iso.txt'))

+ {

+ $lang_pack = file("{$phpbb_root_path}language/$path/iso.txt");

+ $sql_ary = array(

+ 'lang_iso' => basename($path),

+ 'lang_dir' => basename($path),

+ 'lang_english_name' => trim(htmlspecialchars($lang_pack[0])),

+ 'lang_local_name' => trim(htmlspecialchars($lang_pack[1])),

+ 'lang_author' => trim(htmlspecialchars($lang_pack[2])),

+ );

+

+ $db->sql_query('INSERT INTO ' . LANG_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ary));

+

+ if ($db->sql_error_triggered)

+ {

+ $error = $db->sql_error($db->sql_error_sql);

+ $this->p_master->db_error($error['message'], $db->sql_error_sql, __LINE__, __FILE__);

+ }

+ }

+ }

+ }

+

+ /**

+ global $db, $lang, $phpbb_root_path, $phpEx, $config;

+ // Fill the config array - it is needed by those functions we call

+ $sql = 'SELECT *

+ FROM ' . CONFIG_TABLE;

+ $result = $db->sql_query($sql);

+

+ $config = array();

+ while ($row = $db->sql_fetchrow($result))

+ {

+ $config[$row['config_name']] = $row['config_value'];

+ }

+ $db->sql_freeresult($result);

+

+ 'user_lang' => $default_lang,

+ 'user_timezone' => 0,

+ // Check that we actually have a database name before going any further.....

+ if ($dbms != 'sqlite' && $dbname === '')

+ {

+ $error[] = $lang['INST_ERR_DB_NO_NAME'];

+ return false;

+ }

+

+ // Make sure we don't have a daft user who thinks having the SQLite database in the forum directory is a good idea

+ if ($dbms == 'sqlite' && stripos(phpbb_realpath($dbhost), phpbb_realpath('../')) === 0)

+ {

+ $error[] = $lang['INST_ERR_DB_FORUM_PATH'];

+ return false;

+ }

+

+ // Check the prefix length to ensure that index names are not too long

+ switch ($dbms)

+ {

+ case 'mysql':

+ case 'mysql4':

+ case 'mysqli':

+ case 'postgres':

+ $prefix_length = 36;

+

+ break;

+

+ case 'mssql':

+ case 'mssql_odbc':

+ $prefix_length = 90;

+

+ break;

+

+ case 'oracle':

+ case 'sqlite':

+ $prefix_length = 200;

+

+ break;

+

+ case 'firebird':

+ $prefix_length = 6;

+

+ break;

+ }

+

+ if (strlen($table_prefix) > $prefix_length)

+ {

+ $error[] = sprintf($lang['INST_ERR_PREFIX_TOO_LONG'], $prefix_length);

+ return false;

+ }

+

+ // Make sure that the user has selected a sensible DBAL for the DBMS actually installed

+ switch ($dbms)

+ {

+ case 'mysql4':

+ if (version_compare(mysql_get_server_info($db->db_connect_id), '4.0.0', '<'))

+ {

+ $error[] = $lang['INST_ERR_DB_NO_MYSQL4'];

+ }

+

+ break;

+

+ case 'mysqli':

+ if (version_compare(mysqli_get_server_info($db->db_connect_id), '4.1.3', '<'))

+ {

+ $error[] = $lang['INST_ERR_DB_NO_MYSQLI'];

+ }

+

+ break;

+ }

+

+ var $request_vars = array('language', 'dbms', 'dbhost', 'dbport', 'dbuser', 'dbpasswd', 'dbname', 'table_prefix', 'default_lang', 'admin_name', 'admin_pass1', 'admin_pass2', 'board_email1', 'board_email2', 'img_imagick', 'ftp_path', 'ftp_user', 'ftp_pass', 'email_enable', 'smtp_delivery', 'smtp_host', 'smtp_auth', 'smtp_user', 'smtp_pass', 'cookie_secure', 'force_server_vars', 'server_protocol', 'server_name', 'server_port');

+ 'default_lang' => array('lang' => 'DEFAULT_LANG', 'type' => 'select', 'options' => '$this->module->inst_language_select(\'{VALUE}\')', 'explain' => false),

+ 'admin_name' => array('lang' => 'ADMIN_USERNAME', 'type' => 'text:25:100', 'explain' => true),

+ 'LABEL' => 'PostgreSQL 7.x/8.x',

+if ( !defined('IN_INSTALL') )

+{

+ // Someone has tried to access the file direct. This is not a good idea, so exit

+ exit;

+}

+

+ global $lang, $template, $language;

+

+ 'S_LANG_SELECT' => '<select id="language" name="language">' . $this->p_master->inst_language_select($language) . '</select>',

+#

+

+

+# Emulation of STRLEN, might need to be checked out for FB 2.0

+DECLARE EXTERNAL FUNCTION STRLEN CSTRING(32767)

+RETURNS INTEGER BY VALUE

+ENTRY_POINT 'IB_UDF_strlen' MODULE_NAME 'ib_udf';;

+

+# Emulation of LOWER, might need to be checked out for FB 2.0

+DECLARE EXTERNAL FUNCTION LOWER CSTRING(80)

+RETURNS CSTRING(80) FREE_IT

+ENTRY_POINT 'IB_UDF_lower' MODULE_NAME 'ib_udf';;

+

+# Only used for insertion of binary strings as defaults

+DECLARE EXTERNAL FUNCTION ASCII_CHAR INTEGER

+RETURNS CSTRING(1) FREE_IT

+ENTRY_POINT 'IB_UDF_ascii_char' MODULE_NAME 'ib_udf';;

+# Table: 'phpbb_attachments'

+ attach_id INTEGER NOT NULL,

+ post_msg_id INTEGER DEFAULT 0 NOT NULL,

+ topic_id INTEGER DEFAULT 0 NOT NULL,

+ in_message INTEGER DEFAULT 0 NOT NULL,

+ poster_id INTEGER DEFAULT 0 NOT NULL,

+ physical_filename VARCHAR(255) DEFAULT '' NOT NULL,

+ real_filename VARCHAR(255) DEFAULT '' NOT NULL,

+ download_count INTEGER DEFAULT 0 NOT NULL,

+ attach_comment BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,

+ extension VARCHAR(100) DEFAULT '' NOT NULL,

+ mimetype VARCHAR(100) DEFAULT '' NOT NULL,

+ filesize INTEGER DEFAULT 0 NOT NULL,

+ filetime INTEGER DEFAULT 0 NOT NULL,

+ thumbnail INTEGER DEFAULT 0 NOT NULL

+CREATE INDEX phpbb_attachments_poster_id ON phpbb_attachments(poster_id);;

+CREATE INDEX phpbb_attachments_filesize ON phpbb_attachments(filesize);;

+CREATE TRIGGER t_phpbb_attachments FOR phpbb_attachments

+ NEW.attach_id = GEN_ID(phpbb_attachments_gen, 1);

+# Table: 'phpbb_acl_groups'

+ group_id INTEGER DEFAULT 0 NOT NULL,

+ forum_id INTEGER DEFAULT 0 NOT NULL,

+ auth_option_id INTEGER DEFAULT 0 NOT NULL,

+ auth_role_id INTEGER DEFAULT 0 NOT NULL,

+ auth_setting INTEGER DEFAULT 0 NOT NULL

+CREATE INDEX phpbb_acl_groups_auth_opt_id ON phpbb_acl_groups(auth_option_id);;

+# Table: 'phpbb_acl_options'

+ auth_option_id INTEGER NOT NULL,

+ auth_option VARCHAR(50) DEFAULT '' NOT NULL,

+ is_global INTEGER DEFAULT 0 NOT NULL,

+ is_local INTEGER DEFAULT 0 NOT NULL,

+ founder_only INTEGER DEFAULT 0 NOT NULL

+CREATE TRIGGER t_phpbb_acl_options FOR phpbb_acl_options

+ NEW.auth_option_id = GEN_ID(phpbb_acl_options_gen, 1);

+# Table: 'phpbb_acl_roles'

+ role_id INTEGER NOT NULL,

+ role_name VARCHAR(255) DEFAULT '' NOT NULL,

+ role_description BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,

+ role_type VARCHAR(10) DEFAULT '' NOT NULL,

+ role_order INTEGER DEFAULT 0 NOT NULL

+CREATE TRIGGER t_phpbb_acl_roles FOR phpbb_acl_roles

+ NEW.role_id = GEN_ID(phpbb_acl_roles_gen, 1);

+# Table: 'phpbb_acl_roles_data'

+ role_id INTEGER DEFAULT 0 NOT NULL,

+ auth_option_id INTEGER DEFAULT 0 NOT NULL,

+ auth_setting INTEGER DEFAULT 0 NOT NULL

+# Table: 'phpbb_acl_users'

+ user_id INTEGER DEFAULT 0 NOT NULL,

+ forum_id INTEGER DEFAULT 0 NOT NULL,

+ auth_option_id INTEGER DEFAULT 0 NOT NULL,

+ auth_role_id INTEGER DEFAULT 0 NOT NULL,

+ auth_setting INTEGER DEFAULT 0 NOT NULL

+CREATE INDEX phpbb_acl_users_auth_option_id ON phpbb_acl_users(auth_option_id);;

+# Table: 'phpbb_banlist'

+ ban_id INTEGER NOT NULL,

+ ban_userid INTEGER DEFAULT 0 NOT NULL,

+ ban_ip VARCHAR(40) DEFAULT '' NOT NULL,

+ ban_email VARCHAR(100) DEFAULT '' NOT NULL,

+ ban_start INTEGER DEFAULT 0 NOT NULL,

+ ban_end INTEGER DEFAULT 0 NOT NULL,

+ ban_exclude INTEGER DEFAULT 0 NOT NULL,

+ ban_reason BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,

+ ban_give_reason BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL

+CREATE INDEX phpbb_banlist_ban_end ON phpbb_banlist(ban_end);;

+CREATE INDEX phpbb_banlist_ban_user ON phpbb_banlist(ban_userid, ban_exclude);;

+CREATE INDEX phpbb_banlist_ban_email ON phpbb_banlist(ban_email, ban_exclude);;

+CREATE INDEX phpbb_banlist_ban_ip ON phpbb_banlist(ban_ip, ban_exclude);;

+

+CREATE TRIGGER t_phpbb_banlist FOR phpbb_banlist

+ NEW.ban_id = GEN_ID(phpbb_banlist_gen, 1);

+

+# Table: 'phpbb_bbcodes'

+ bbcode_id INTEGER DEFAULT 0 NOT NULL,

+ bbcode_tag VARCHAR(16) DEFAULT '' NOT NULL,

+ bbcode_helpline VARCHAR(255) DEFAULT '' NOT NULL,

+ display_on_posting INTEGER DEFAULT 0 NOT NULL,

+ bbcode_match BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,

+ bbcode_tpl BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,

+ first_pass_match BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,

+ first_pass_replace BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,

+ second_pass_match BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,

+ second_pass_replace BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL

+# Table: 'phpbb_bookmarks'

+ topic_id INTEGER DEFAULT 0 NOT NULL,

+ user_id INTEGER DEFAULT 0 NOT NULL,

+ order_id INTEGER DEFAULT 0 NOT NULL

+# Table: 'phpbb_bots'

+ bot_id INTEGER NOT NULL,

+ bot_active INTEGER DEFAULT 1 NOT NULL,

+ bot_name BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,

+ user_id INTEGER DEFAULT 0 NOT NULL,

+ bot_agent VARCHAR(255) DEFAULT '' NOT NULL,

+ bot_ip VARCHAR(255) DEFAULT '' NOT NULL

+CREATE TRIGGER t_phpbb_bots FOR phpbb_bots

+ NEW.bot_id = GEN_ID(phpbb_bots_gen, 1);

+# Table: 'phpbb_config'

+ config_name VARCHAR(252) DEFAULT '' NOT NULL,

+ config_value VARCHAR(255) DEFAULT '' NOT NULL,

+ is_dynamic INTEGER DEFAULT 0 NOT NULL

+# Table: 'phpbb_confirm'

+ confirm_id CHAR(32) DEFAULT '' NOT NULL,

+ session_id CHAR(32) DEFAULT '' NOT NULL,

+ confirm_type INTEGER DEFAULT 0 NOT NULL,

+ code VARCHAR(8) DEFAULT '' NOT NULL

+CREATE INDEX phpbb_confirm_confirm_type ON phpbb_confirm(confirm_type);;

+# Table: 'phpbb_disallow'

+ disallow_id INTEGER NOT NULL,

+ disallow_username VARCHAR(252) DEFAULT '' NOT NULL

+

+CREATE TRIGGER t_phpbb_disallow FOR phpbb_disallow

+ NEW.disallow_id = GEN_ID(phpbb_disallow_gen, 1);

+# Table: 'phpbb_drafts'

+ draft_id INTEGER NOT NULL,

+ user_id INTEGER DEFAULT 0 NOT NULL,

+ topic_id INTEGER DEFAULT 0 NOT NULL,

+ forum_id INTEGER DEFAULT 0 NOT NULL,

+ save_time INTEGER DEFAULT 0 NOT NULL,

+ draft_subject BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,

+ draft_message BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL

+CREATE TRIGGER t_phpbb_drafts FOR phpbb_drafts

+ NEW.draft_id = GEN_ID(phpbb_drafts_gen, 1);

+# Table: 'phpbb_extensions'

+ extension_id INTEGER NOT NULL,

+ group_id INTEGER DEFAULT 0 NOT NULL,

+ extension VARCHAR(100) DEFAULT '' NOT NULL

+

+CREATE TRIGGER t_phpbb_extensions FOR phpbb_extensions

+ NEW.extension_id = GEN_ID(phpbb_extensions_gen, 1);

+# Table: 'phpbb_extension_groups'

+ group_id INTEGER NOT NULL,

+ group_name VARCHAR(255) DEFAULT '' NOT NULL,

+ cat_id INTEGER DEFAULT 0 NOT NULL,

+ allow_group INTEGER DEFAULT 0 NOT NULL,

+ download_mode INTEGER DEFAULT 1 NOT NULL,

+ upload_icon VARCHAR(255) DEFAULT '' NOT NULL,

+ max_filesize INTEGER DEFAULT 0 NOT NULL,

+ allowed_forums BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,

+ allow_in_pm INTEGER DEFAULT 0 NOT NULL

+

+CREATE TRIGGER t_phpbb_extension_groups FOR phpbb_extension_groups

+ NEW.group_id = GEN_ID(phpbb_extension_groups_gen, 1);

+# Table: 'phpbb_forums'

+ forum_id INTEGER NOT NULL,

+ parent_id INTEGER DEFAULT 0 NOT NULL,

+ left_id INTEGER DEFAULT 0 NOT NULL,

+ right_id INTEGER DEFAULT 0 NOT NULL,

+ forum_parents BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,

+ forum_name BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,

+ forum_desc BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,

+ forum_desc_bitfield VARCHAR(252) DEFAULT '' NOT NULL,

+ forum_desc_options INTEGER DEFAULT 0 NOT NULL,

+ forum_desc_uid VARCHAR(5) DEFAULT '' NOT NULL,

+ forum_link VARCHAR(255) DEFAULT '' NOT NULL,

+ forum_password VARCHAR(40) DEFAULT '' NOT NULL,

+ forum_style INTEGER DEFAULT 0 NOT NULL,

+ forum_image VARCHAR(255) DEFAULT '' NOT NULL,

+ forum_rules BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,

+ forum_rules_link VARCHAR(255) DEFAULT '' NOT NULL,

+ forum_rules_bitfield VARCHAR(252) DEFAULT '' NOT NULL,

+ forum_rules_options INTEGER DEFAULT 0 NOT NULL,

+ forum_rules_uid VARCHAR(5) DEFAULT '' NOT NULL,

+ forum_topics_per_page INTEGER DEFAULT 0 NOT NULL,

+ forum_type INTEGER DEFAULT 0 NOT NULL,

+ forum_status INTEGER DEFAULT 0 NOT NULL,

+ forum_posts INTEGER DEFAULT 0 NOT NULL,

+ forum_topics INTEGER DEFAULT 0 NOT NULL,

+ forum_topics_real INTEGER DEFAULT 0 NOT NULL,

+ forum_last_post_id INTEGER DEFAULT 0 NOT NULL,

+ forum_last_poster_id INTEGER DEFAULT 0 NOT NULL,

+ forum_last_post_time INTEGER DEFAULT 0 NOT NULL,

+ forum_last_poster_name VARCHAR(255) DEFAULT '' NOT NULL,

+ forum_flags INTEGER DEFAULT 32 NOT NULL,

+ display_on_index INTEGER DEFAULT 1 NOT NULL,

+ enable_indexing INTEGER DEFAULT 1 NOT NULL,

+ enable_icons INTEGER DEFAULT 1 NOT NULL,

+ enable_prune INTEGER DEFAULT 0 NOT NULL,

+ prune_next INTEGER DEFAULT 0 NOT NULL,

+ prune_days INTEGER DEFAULT 0 NOT NULL,

+ prune_viewed INTEGER DEFAULT 0 NOT NULL,

+ prune_freq INTEGER DEFAULT 0 NOT NULL

+CREATE INDEX phpbb_forums_forum_lastpost_id ON phpbb_forums(forum_last_post_id);;

+CREATE TRIGGER t_phpbb_forums FOR phpbb_forums

+ NEW.forum_id = GEN_ID(phpbb_forums_gen, 1);

+# Table: 'phpbb_forums_access'

+ forum_id INTEGER DEFAULT 0 NOT NULL,

+ user_id INTEGER DEFAULT 0 NOT NULL,

+ session_id CHAR(32) DEFAULT '' NOT NULL

+# Table: 'phpbb_forums_track'

+ user_id INTEGER DEFAULT 0 NOT NULL,

+ forum_id INTEGER DEFAULT 0 NOT NULL,

+ mark_time INTEGER DEFAULT 0 NOT NULL

+# Table: 'phpbb_forums_watch'

+ forum_id INTEGER DEFAULT 0 NOT NULL,

+ user_id INTEGER DEFAULT 0 NOT NULL,

+ notify_status INTEGER DEFAULT 0 NOT NULL

+CREATE INDEX phpbb_forums_watch_notify_stat ON phpbb_forums_watch(notify_status);;

+# Table: 'phpbb_groups'

+ group_id INTEGER NOT NULL,

+ group_type INTEGER DEFAULT 1 NOT NULL,

+ group_name VARCHAR(252) DEFAULT '' NOT NULL,

+ group_desc BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,

+ group_desc_bitfield VARCHAR(252) DEFAULT '' NOT NULL,

+ group_desc_options INTEGER DEFAULT 0 NOT NULL,

+ group_desc_uid VARCHAR(5) DEFAULT '' NOT NULL,

+ group_display INTEGER DEFAULT 0 NOT NULL,

+ group_avatar VARCHAR(255) DEFAULT '' NOT NULL,

+ group_avatar_type INTEGER DEFAULT 0 NOT NULL,

+ group_avatar_width INTEGER DEFAULT 0 NOT NULL,

+ group_avatar_height INTEGER DEFAULT 0 NOT NULL,

+ group_rank INTEGER DEFAULT 0 NOT NULL,

+ group_colour VARCHAR(6) DEFAULT '' NOT NULL,

+ group_sig_chars INTEGER DEFAULT 0 NOT NULL,

+ group_receive_pm INTEGER DEFAULT 0 NOT NULL,

+ group_message_limit INTEGER DEFAULT 0 NOT NULL,

+ group_legend INTEGER DEFAULT 1 NOT NULL

+CREATE TRIGGER t_phpbb_groups FOR phpbb_groups

+ NEW.group_id = GEN_ID(phpbb_groups_gen, 1);

+# Table: 'phpbb_icons'

+ icons_id INTEGER NOT NULL,

+ icons_url VARCHAR(255) DEFAULT '' NOT NULL,

+ icons_width INTEGER DEFAULT 0 NOT NULL,

+ icons_height INTEGER DEFAULT 0 NOT NULL,

+ icons_order INTEGER DEFAULT 0 NOT NULL,

+ display_on_posting INTEGER DEFAULT 1 NOT NULL

+CREATE INDEX phpbb_icons_display_on_posting ON phpbb_icons(display_on_posting);;

+

+CREATE TRIGGER t_phpbb_icons FOR phpbb_icons

+ NEW.icons_id = GEN_ID(phpbb_icons_gen, 1);

+# Table: 'phpbb_lang'

+ lang_id INTEGER NOT NULL,

+ lang_iso VARCHAR(30) DEFAULT '' NOT NULL,

+ lang_dir VARCHAR(30) DEFAULT '' NOT NULL,

+ lang_english_name VARCHAR(100) DEFAULT '' NOT NULL,

+ lang_local_name VARCHAR(255) DEFAULT '' NOT NULL,

+ lang_author VARCHAR(255) DEFAULT '' NOT NULL

+CREATE INDEX phpbb_lang_lang_iso ON phpbb_lang(lang_iso);;

+

+CREATE TRIGGER t_phpbb_lang FOR phpbb_lang

+ NEW.lang_id = GEN_ID(phpbb_lang_gen, 1);

+# Table: 'phpbb_log'

+ log_id INTEGER NOT NULL,

+ log_type INTEGER DEFAULT 0 NOT NULL,

+ user_id INTEGER DEFAULT 0 NOT NULL,

+ forum_id INTEGER DEFAULT 0 NOT NULL,

+ topic_id INTEGER DEFAULT 0 NOT NULL,

+ reportee_id INTEGER DEFAULT 0 NOT NULL,

+ log_ip VARCHAR(40) DEFAULT '' NOT NULL,

+ log_time INTEGER DEFAULT 0 NOT NULL,

+ log_operation BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,

+ log_data BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL

+CREATE INDEX phpbb_log_forum_id ON phpbb_log(forum_id);;

+CREATE INDEX phpbb_log_reportee_id ON phpbb_log(reportee_id);;

+CREATE TRIGGER t_phpbb_log FOR phpbb_log

+ NEW.log_id = GEN_ID(phpbb_log_gen, 1);

+# Table: 'phpbb_moderator_cache'

+ forum_id INTEGER DEFAULT 0 NOT NULL,

+ user_id INTEGER DEFAULT 0 NOT NULL,

+ username VARCHAR(252) DEFAULT '' NOT NULL,

+ group_id INTEGER DEFAULT 0 NOT NULL,

+ group_name VARCHAR(255) DEFAULT '' NOT NULL,

+ display_on_index INTEGER DEFAULT 1 NOT NULL

+CREATE INDEX phpbb_moderator_cache_disp_idx ON phpbb_moderator_cache(display_on_index);;

+# Table: 'phpbb_modules'

+ module_id INTEGER NOT NULL,

+ module_enabled INTEGER DEFAULT 1 NOT NULL,

+ module_display INTEGER DEFAULT 1 NOT NULL,

+ module_basename VARCHAR(255) DEFAULT '' NOT NULL,

+ module_class VARCHAR(10) DEFAULT '' NOT NULL,

+ parent_id INTEGER DEFAULT 0 NOT NULL,

+ left_id INTEGER DEFAULT 0 NOT NULL,

+ right_id INTEGER DEFAULT 0 NOT NULL,

+ module_langname VARCHAR(255) DEFAULT '' NOT NULL,

+ module_mode VARCHAR(255) DEFAULT '' NOT NULL,

+ module_auth VARCHAR(255) DEFAULT '' NOT NULL

+CREATE INDEX phpbb_modules_module_enabled ON phpbb_modules(module_enabled);;

+CREATE TRIGGER t_phpbb_modules FOR phpbb_modules

+ NEW.module_id = GEN_ID(phpbb_modules_gen, 1);

+# Table: 'phpbb_poll_options'

+ poll_option_id INTEGER DEFAULT 0 NOT NULL,

+ topic_id INTEGER DEFAULT 0 NOT NULL,

+ poll_option_text BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,

+ poll_option_total INTEGER DEFAULT 0 NOT NULL

+# Table: 'phpbb_poll_votes'

+ topic_id INTEGER DEFAULT 0 NOT NULL,

+ poll_option_id INTEGER DEFAULT 0 NOT NULL,

+ vote_user_id INTEGER DEFAULT 0 NOT NULL,

+ vote_user_ip VARCHAR(40) DEFAULT '' NOT NULL

+CREATE INDEX phpbb_poll_votes_topic_id ON phpbb_poll_votes(topic_id);;

+# Table: 'phpbb_posts'

+ post_id INTEGER NOT NULL,

+ topic_id INTEGER DEFAULT 0 NOT NULL,

+ forum_id INTEGER DEFAULT 0 NOT NULL,

+ poster_id INTEGER DEFAULT 0 NOT NULL,

+ icon_id INTEGER DEFAULT 0 NOT NULL,

+ poster_ip VARCHAR(40) DEFAULT '' NOT NULL,

+ post_time INTEGER DEFAULT 0 NOT NULL,

+ post_approved INTEGER DEFAULT 1 NOT NULL,

+ post_reported INTEGER DEFAULT 0 NOT NULL,

+ enable_bbcode INTEGER DEFAULT 1 NOT NULL,

+ enable_smilies INTEGER DEFAULT 1 NOT NULL,

+ enable_magic_url INTEGER DEFAULT 1 NOT NULL,

+ enable_sig INTEGER DEFAULT 1 NOT NULL,

+ post_username VARCHAR(252) DEFAULT '' NOT NULL,

+ post_subject BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,

+ post_text BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,

+ post_checksum VARCHAR(32) DEFAULT '' NOT NULL,

+ post_encoding VARCHAR(20) DEFAULT 'iso-8859-1' NOT NULL,

+ post_attachment INTEGER DEFAULT 0 NOT NULL,

+ bbcode_bitfield VARCHAR(252) DEFAULT '' NOT NULL,

+ bbcode_uid VARCHAR(5) DEFAULT '' NOT NULL,

+ post_postcount INTEGER DEFAULT 1 NOT NULL,

+ post_edit_time INTEGER DEFAULT 0 NOT NULL,

+ post_edit_reason BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,

+ post_edit_user INTEGER DEFAULT 0 NOT NULL,

+ post_edit_count INTEGER DEFAULT 0 NOT NULL,

+ post_edit_locked INTEGER DEFAULT 0 NOT NULL

+CREATE INDEX phpbb_posts_topic_id ON phpbb_posts(topic_id);;

+CREATE INDEX phpbb_posts_poster_ip ON phpbb_posts(poster_ip);;

+CREATE INDEX phpbb_posts_poster_id ON phpbb_posts(poster_id);;

+CREATE INDEX phpbb_posts_post_postcount ON phpbb_posts(post_postcount);;

+CREATE TRIGGER t_phpbb_posts FOR phpbb_posts

+ NEW.post_id = GEN_ID(phpbb_posts_gen, 1);

+# Table: 'phpbb_privmsgs'

+ msg_id INTEGER NOT NULL,

+ root_level INTEGER DEFAULT 0 NOT NULL,

+ author_id INTEGER DEFAULT 0 NOT NULL,

+ icon_id INTEGER DEFAULT 0 NOT NULL,

+ author_ip VARCHAR(40) DEFAULT '' NOT NULL,

+ message_time INTEGER DEFAULT 0 NOT NULL,

+ enable_bbcode INTEGER DEFAULT 1 NOT NULL,

+ enable_smilies INTEGER DEFAULT 1 NOT NULL,

+ enable_magic_url INTEGER DEFAULT 1 NOT NULL,

+ enable_sig INTEGER DEFAULT 1 NOT NULL,

+ message_subject BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,

+ message_text BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,

+ message_edit_reason BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,

+ message_edit_user INTEGER DEFAULT 0 NOT NULL,

+ message_encoding VARCHAR(20) DEFAULT 'iso-8859-1' NOT NULL,

+ message_attachment INTEGER DEFAULT 0 NOT NULL,

+ bbcode_bitfield VARCHAR(252) DEFAULT '' NOT NULL,

+ bbcode_uid VARCHAR(5) DEFAULT '' NOT NULL,

+ message_edit_time INTEGER DEFAULT 0 NOT NULL,

+ message_edit_count INTEGER DEFAULT 0 NOT NULL,

+ to_address BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,

+ bcc_address BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL

+CREATE INDEX phpbb_privmsgs_author_id ON phpbb_privmsgs(author_id);;

+CREATE TRIGGER t_phpbb_privmsgs FOR phpbb_privmsgs

+ NEW.msg_id = GEN_ID(phpbb_privmsgs_gen, 1);

+# Table: 'phpbb_privmsgs_folder'

+ folder_id INTEGER NOT NULL,

+ user_id INTEGER DEFAULT 0 NOT NULL,

+ folder_name VARCHAR(255) DEFAULT '' NOT NULL,

+ pm_count INTEGER DEFAULT 0 NOT NULL

+CREATE TRIGGER t_phpbb_privmsgs_folder FOR phpbb_privmsgs_folder

+ NEW.folder_id = GEN_ID(phpbb_privmsgs_folder_gen, 1);

+# Table: 'phpbb_privmsgs_rules'

+ rule_id INTEGER NOT NULL,

+ user_id INTEGER DEFAULT 0 NOT NULL,

+ rule_check INTEGER DEFAULT 0 NOT NULL,

+ rule_connection INTEGER DEFAULT 0 NOT NULL,

+ rule_string VARCHAR(255) DEFAULT '' NOT NULL,

+ rule_user_id INTEGER DEFAULT 0 NOT NULL,

+ rule_group_id INTEGER DEFAULT 0 NOT NULL,

+ rule_action INTEGER DEFAULT 0 NOT NULL,

+ rule_folder_id INTEGER DEFAULT 0 NOT NULL

+CREATE INDEX phpbb_privmsgs_rules_user_id ON phpbb_privmsgs_rules(user_id);;

+

+CREATE TRIGGER t_phpbb_privmsgs_rules FOR phpbb_privmsgs_rules

+ NEW.rule_id = GEN_ID(phpbb_privmsgs_rules_gen, 1);

+# Table: 'phpbb_privmsgs_to'

+ msg_id INTEGER DEFAULT 0 NOT NULL,

+ user_id INTEGER DEFAULT 0 NOT NULL,

+ author_id INTEGER DEFAULT 0 NOT NULL,

+ pm_deleted INTEGER DEFAULT 0 NOT NULL,

+ pm_new INTEGER DEFAULT 1 NOT NULL,

+ pm_unread INTEGER DEFAULT 1 NOT NULL,

+ pm_replied INTEGER DEFAULT 0 NOT NULL,

+ pm_marked INTEGER DEFAULT 0 NOT NULL,

+ pm_forwarded INTEGER DEFAULT 0 NOT NULL,

+ folder_id INTEGER DEFAULT 0 NOT NULL

+CREATE INDEX phpbb_privmsgs_to_author_id ON phpbb_privmsgs_to(author_id);;

+CREATE INDEX phpbb_privmsgs_to_usr_flder_id ON phpbb_privmsgs_to(user_id, folder_id);;

+# Table: 'phpbb_profile_fields'

+ field_id INTEGER NOT NULL,

+ field_name VARCHAR(255) DEFAULT '' NOT NULL,

+ field_type INTEGER DEFAULT 0 NOT NULL,

+ field_ident VARCHAR(20) DEFAULT '' NOT NULL,

+ field_length VARCHAR(20) DEFAULT '' NOT NULL,

+ field_minlen VARCHAR(255) DEFAULT '' NOT NULL,

+ field_maxlen VARCHAR(255) DEFAULT '' NOT NULL,

+ field_novalue VARCHAR(255) DEFAULT '' NOT NULL,

+ field_default_value VARCHAR(255) DEFAULT '' NOT NULL,

+ field_validation VARCHAR(20) DEFAULT '' NOT NULL,

+ field_required INTEGER DEFAULT 0 NOT NULL,

+ field_show_on_reg INTEGER DEFAULT 0 NOT NULL,

+ field_hide INTEGER DEFAULT 0 NOT NULL,

+ field_no_view INTEGER DEFAULT 0 NOT NULL,

+ field_active INTEGER DEFAULT 0 NOT NULL,

+ field_order INTEGER DEFAULT 0 NOT NULL

+CREATE INDEX phpbb_profile_fields_fld_type ON phpbb_profile_fields(field_type);;

+CREATE INDEX phpbb_profile_fields_fld_ordr ON phpbb_profile_fields(field_order);;

+CREATE TRIGGER t_phpbb_profile_fields FOR phpbb_profile_fields

+ NEW.field_id = GEN_ID(phpbb_profile_fields_gen, 1);

+# Table: 'phpbb_profile_fields_data'

+ user_id INTEGER DEFAULT 0 NOT NULL

+# Table: 'phpbb_profile_fields_lang'

+ field_id INTEGER DEFAULT 0 NOT NULL,

+ lang_id INTEGER DEFAULT 0 NOT NULL,

+ option_id INTEGER DEFAULT 0 NOT NULL,

+ field_type INTEGER DEFAULT 0 NOT NULL,

+ lang_value VARCHAR(255) DEFAULT '' NOT NULL

+# Table: 'phpbb_profile_lang'

+ field_id INTEGER DEFAULT 0 NOT NULL,

+ lang_id INTEGER DEFAULT 0 NOT NULL,

+ lang_name VARCHAR(255) DEFAULT '' NOT NULL,

+ lang_explain BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,

+ lang_default_value VARCHAR(255) DEFAULT '' NOT NULL

+# Table: 'phpbb_ranks'

+ rank_id INTEGER NOT NULL,

+ rank_title VARCHAR(255) DEFAULT '' NOT NULL,

+ rank_min INTEGER DEFAULT 0 NOT NULL,

+ rank_special INTEGER DEFAULT 0 NOT NULL,

+ rank_image VARCHAR(255) DEFAULT '' NOT NULL

+

+CREATE TRIGGER t_phpbb_ranks FOR phpbb_ranks

+ NEW.rank_id = GEN_ID(phpbb_ranks_gen, 1);

+# Table: 'phpbb_reports'

+ report_id INTEGER NOT NULL,

+ reason_id INTEGER DEFAULT 0 NOT NULL,

+ post_id INTEGER DEFAULT 0 NOT NULL,

+ user_id INTEGER DEFAULT 0 NOT NULL,

+ user_notify INTEGER DEFAULT 0 NOT NULL,

+ report_closed INTEGER DEFAULT 0 NOT NULL,

+ report_time INTEGER DEFAULT 0 NOT NULL,

+ report_text BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL

+

+CREATE TRIGGER t_phpbb_reports FOR phpbb_reports

+ NEW.report_id = GEN_ID(phpbb_reports_gen, 1);

+# Table: 'phpbb_reports_reasons'

+ reason_id INTEGER NOT NULL,

+ reason_title VARCHAR(255) DEFAULT '' NOT NULL,

+ reason_description BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,

+ reason_order INTEGER DEFAULT 0 NOT NULL

+

+CREATE TRIGGER t_phpbb_reports_reasons FOR phpbb_reports_reasons

+ NEW.reason_id = GEN_ID(phpbb_reports_reasons_gen, 1);

+# Table: 'phpbb_search_results'

+ search_key VARCHAR(32) DEFAULT '' NOT NULL,

+ search_time INTEGER DEFAULT 0 NOT NULL,

+ search_keywords BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,

+ search_authors BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL

+# Table: 'phpbb_search_wordlist'

+ word_id INTEGER NOT NULL,

+ word_text VARCHAR(84) CHARACTER SET UNICODE_FSS DEFAULT '' NOT NULL,

+ word_common INTEGER DEFAULT 0 NOT NULL

+ALTER TABLE phpbb_search_wordlist ADD PRIMARY KEY (word_id);;

+CREATE UNIQUE INDEX phpbb_search_wordlist_wrd_txt ON phpbb_search_wordlist(word_text);;

+CREATE TRIGGER t_phpbb_search_wordlist FOR phpbb_search_wordlist

+ NEW.word_id = GEN_ID(phpbb_search_wordlist_gen, 1);

+# Table: 'phpbb_search_wordmatch'

+ post_id INTEGER DEFAULT 0 NOT NULL,

+ word_id INTEGER DEFAULT 0 NOT NULL,

+ title_match INTEGER DEFAULT 0 NOT NULL

+CREATE INDEX phpbb_search_wordmatch_post_id ON phpbb_search_wordmatch(post_id);;

+# Table: 'phpbb_sessions'

+ session_id CHAR(32) DEFAULT '' NOT NULL,

+ session_user_id INTEGER DEFAULT 0 NOT NULL,

+ session_last_visit INTEGER DEFAULT 0 NOT NULL,

+ session_start INTEGER DEFAULT 0 NOT NULL,

+ session_time INTEGER DEFAULT 0 NOT NULL,

+ session_ip VARCHAR(40) DEFAULT '' NOT NULL,

+ session_browser VARCHAR(150) DEFAULT '' NOT NULL,

+ session_page VARCHAR(255) DEFAULT '' NOT NULL,

+ session_viewonline INTEGER DEFAULT 1 NOT NULL,

+ session_autologin INTEGER DEFAULT 0 NOT NULL,

+ session_admin INTEGER DEFAULT 0 NOT NULL

+# Table: 'phpbb_sessions_keys'

+ key_id CHAR(32) DEFAULT '' NOT NULL,

+ user_id INTEGER DEFAULT 0 NOT NULL,

+ last_ip VARCHAR(40) DEFAULT '' NOT NULL,

+ last_login INTEGER DEFAULT 0 NOT NULL

+# Table: 'phpbb_sitelist'

+ site_id INTEGER NOT NULL,

+ site_ip VARCHAR(40) DEFAULT '' NOT NULL,

+ site_hostname VARCHAR(255) DEFAULT '' NOT NULL,

+ ip_exclude INTEGER DEFAULT 0 NOT NULL

+

+CREATE TRIGGER t_phpbb_sitelist FOR phpbb_sitelist

+ NEW.site_id = GEN_ID(phpbb_sitelist_gen, 1);

+# Table: 'phpbb_smilies'

+ smiley_id INTEGER NOT NULL,

+ code VARCHAR(50) DEFAULT '' NOT NULL,

+ emotion VARCHAR(50) DEFAULT '' NOT NULL,

+ smiley_url VARCHAR(50) DEFAULT '' NOT NULL,

+ smiley_width INTEGER DEFAULT 0 NOT NULL,

+ smiley_height INTEGER DEFAULT 0 NOT NULL,

+ smiley_order INTEGER DEFAULT 0 NOT NULL,

+ display_on_posting INTEGER DEFAULT 1 NOT NULL

+CREATE INDEX phpbb_smilies_display_on_post ON phpbb_smilies(display_on_posting);;

+

+CREATE TRIGGER t_phpbb_smilies FOR phpbb_smilies

+ NEW.smiley_id = GEN_ID(phpbb_smilies_gen, 1);

+# Table: 'phpbb_styles'

+ style_id INTEGER NOT NULL,

+ style_name VARCHAR(252) DEFAULT '' NOT NULL,

+ style_copyright VARCHAR(255) DEFAULT '' NOT NULL,

+ style_active INTEGER DEFAULT 1 NOT NULL,

+ template_id INTEGER DEFAULT 0 NOT NULL,

+ theme_id INTEGER DEFAULT 0 NOT NULL,

+ imageset_id INTEGER DEFAULT 0 NOT NULL

+ALTER TABLE phpbb_styles ADD PRIMARY KEY (style_id);;

+

+CREATE UNIQUE INDEX phpbb_styles_style_name ON phpbb_styles(style_name);;

+CREATE INDEX phpbb_styles_template_id ON phpbb_styles(template_id);;

+CREATE INDEX phpbb_styles_theme_id ON phpbb_styles(theme_id);;

+CREATE INDEX phpbb_styles_imageset_id ON phpbb_styles(imageset_id);;

+

+CREATE GENERATOR phpbb_styles_gen;;

+SET GENERATOR phpbb_styles_gen TO 0;;

+

+CREATE TRIGGER t_phpbb_styles FOR phpbb_styles

+BEFORE INSERT

+AS

+BEGIN

+ NEW.style_id = GEN_ID(phpbb_styles_gen, 1);

+END;;

+

+

+# Table: 'phpbb_styles_template'

+ template_id INTEGER NOT NULL,

+ template_name VARCHAR(252) DEFAULT '' NOT NULL,

+ template_copyright VARCHAR(255) DEFAULT '' NOT NULL,

+ template_path VARCHAR(100) DEFAULT '' NOT NULL,

+ bbcode_bitfield VARCHAR(252) DEFAULT 'kNg=' NOT NULL,

+ template_storedb INTEGER DEFAULT 0 NOT NULL

+CREATE GENERATOR phpbb_styles_template_gen;;

+SET GENERATOR phpbb_styles_template_gen TO 0;;

+CREATE TRIGGER t_phpbb_styles_template FOR phpbb_styles_template

+BEFORE INSERT

+AS

+BEGIN

+ NEW.template_id = GEN_ID(phpbb_styles_template_gen, 1);

+END;;

+

+

+# Table: 'phpbb_styles_template_data'

+ template_id INTEGER NOT NULL,

+ template_filename VARCHAR(100) DEFAULT '' NOT NULL,

+ template_included BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,

+ template_mtime INTEGER DEFAULT 0 NOT NULL,

+ template_data BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL

+CREATE INDEX phpbb_styles_template_data_tid ON phpbb_styles_template_data(template_id);;

+CREATE INDEX phpbb_styles_template_data_tfn ON phpbb_styles_template_data(template_filename);;

+CREATE GENERATOR phpbb_styles_template_data_gen;;

+SET GENERATOR phpbb_styles_template_data_gen TO 0;;

+CREATE TRIGGER t_phpbb_styles_template_data FOR phpbb_styles_template_data

+ NEW.template_id = GEN_ID(phpbb_styles_template_data_gen, 1);

+# Table: 'phpbb_styles_theme'

+ theme_id INTEGER NOT NULL,

+ theme_name VARCHAR(252) DEFAULT '' NOT NULL,

+ theme_copyright VARCHAR(255) DEFAULT '' NOT NULL,

+ theme_path VARCHAR(100) DEFAULT '' NOT NULL,

+ theme_storedb INTEGER DEFAULT 0 NOT NULL,

+ theme_mtime INTEGER DEFAULT 0 NOT NULL,

+ theme_data BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL

+CREATE TRIGGER t_phpbb_styles_theme FOR phpbb_styles_theme

+ NEW.theme_id = GEN_ID(phpbb_styles_theme_gen, 1);

+# Table: 'phpbb_styles_imageset'

+ imageset_id INTEGER NOT NULL,

+ imageset_name VARCHAR(252) DEFAULT '' NOT NULL,

+ imageset_copyright VARCHAR(255) DEFAULT '' NOT NULL,

+ imageset_path VARCHAR(100) DEFAULT '' NOT NULL,

+ site_logo VARCHAR(200) DEFAULT '' NOT NULL,

+ upload_bar VARCHAR(200) DEFAULT '' NOT NULL,

+ poll_left VARCHAR(200) DEFAULT '' NOT NULL,

+ poll_center VARCHAR(200) DEFAULT '' NOT NULL,

+ poll_right VARCHAR(200) DEFAULT '' NOT NULL,

+ icon_friend VARCHAR(200) DEFAULT '' NOT NULL,

+ icon_foe VARCHAR(200) DEFAULT '' NOT NULL,

+ forum_link VARCHAR(200) DEFAULT '' NOT NULL,

+ forum_read VARCHAR(200) DEFAULT '' NOT NULL,

+ forum_read_locked VARCHAR(200) DEFAULT '' NOT NULL,

+ forum_read_subforum VARCHAR(200) DEFAULT '' NOT NULL,

+ forum_unread VARCHAR(200) DEFAULT '' NOT NULL,

+ forum_unread_locked VARCHAR(200) DEFAULT '' NOT NULL,

+ forum_unread_subforum VARCHAR(200) DEFAULT '' NOT NULL,

+ topic_moved VARCHAR(200) DEFAULT '' NOT NULL,

+ topic_read VARCHAR(200) DEFAULT '' NOT NULL,

+ topic_read_mine VARCHAR(200) DEFAULT '' NOT NULL,

+ topic_read_hot VARCHAR(200) DEFAULT '' NOT NULL,

+ topic_read_hot_mine VARCHAR(200) DEFAULT '' NOT NULL,

+ topic_read_locked VARCHAR(200) DEFAULT '' NOT NULL,

+ topic_read_locked_mine VARCHAR(200) DEFAULT '' NOT NULL,

+ topic_unread VARCHAR(200) DEFAULT '' NOT NULL,

+ topic_unread_mine VARCHAR(200) DEFAULT '' NOT NULL,

+ topic_unread_hot VARCHAR(200) DEFAULT '' NOT NULL,

+ topic_unread_hot_mine VARCHAR(200) DEFAULT '' NOT NULL,

+ topic_unread_locked VARCHAR(200) DEFAULT '' NOT NULL,

+ topic_unread_locked_mine VARCHAR(200) DEFAULT '' NOT NULL,

+ sticky_read VARCHAR(200) DEFAULT '' NOT NULL,

+ sticky_read_mine VARCHAR(200) DEFAULT '' NOT NULL,

+ sticky_read_locked VARCHAR(200) DEFAULT '' NOT NULL,

+ sticky_read_locked_mine VARCHAR(200) DEFAULT '' NOT NULL,

+ sticky_unread VARCHAR(200) DEFAULT '' NOT NULL,

+ sticky_unread_mine VARCHAR(200) DEFAULT '' NOT NULL,

+ sticky_unread_locked VARCHAR(200) DEFAULT '' NOT NULL,

+ sticky_unread_locked_mine VARCHAR(200) DEFAULT '' NOT NULL,

+ announce_read VARCHAR(200) DEFAULT '' NOT NULL,

+ announce_read_mine VARCHAR(200) DEFAULT '' NOT NULL,

+ announce_read_locked VARCHAR(200) DEFAULT '' NOT NULL,

+ announce_read_locked_mine VARCHAR(200) DEFAULT '' NOT NULL,

+ announce_unread VARCHAR(200) DEFAULT '' NOT NULL,

+ announce_unread_mine VARCHAR(200) DEFAULT '' NOT NULL,

+ announce_unread_locked VARCHAR(200) DEFAULT '' NOT NULL,

+ announce_unread_locked_mine VARCHAR(200) DEFAULT '' NOT NULL,

+ global_read VARCHAR(200) DEFAULT '' NOT NULL,

+ global_read_mine VARCHAR(200) DEFAULT '' NOT NULL,

+ global_read_locked VARCHAR(200) DEFAULT '' NOT NULL,

+ global_read_locked_mine VARCHAR(200) DEFAULT '' NOT NULL,

+ global_unread VARCHAR(200) DEFAULT '' NOT NULL,

+ global_unread_mine VARCHAR(200) DEFAULT '' NOT NULL,

+ global_unread_locked VARCHAR(200) DEFAULT '' NOT NULL,

+ global_unread_locked_mine VARCHAR(200) DEFAULT '' NOT NULL,

+ pm_read VARCHAR(200) DEFAULT '' NOT NULL,

+ pm_unread VARCHAR(200) DEFAULT '' NOT NULL,

+ icon_contact_aim VARCHAR(200) DEFAULT '' NOT NULL,

+ icon_contact_email VARCHAR(200) DEFAULT '' NOT NULL,

+ icon_contact_icq VARCHAR(200) DEFAULT '' NOT NULL,

+ icon_contact_jabber VARCHAR(200) DEFAULT '' NOT NULL,

+ icon_contact_msnm VARCHAR(200) DEFAULT '' NOT NULL,

+ icon_contact_pm VARCHAR(200) DEFAULT '' NOT NULL,

+ icon_contact_yahoo VARCHAR(200) DEFAULT '' NOT NULL,

+ icon_contact_www VARCHAR(200) DEFAULT '' NOT NULL,

+ icon_post_delete VARCHAR(200) DEFAULT '' NOT NULL,

+ icon_post_edit VARCHAR(200) DEFAULT '' NOT NULL,

+ icon_post_info VARCHAR(200) DEFAULT '' NOT NULL,

+ icon_post_quote VARCHAR(200) DEFAULT '' NOT NULL,

+ icon_post_report VARCHAR(200) DEFAULT '' NOT NULL,

+ icon_post_target VARCHAR(200) DEFAULT '' NOT NULL,

+ icon_post_target_unread VARCHAR(200) DEFAULT '' NOT NULL,

+ icon_topic_attach VARCHAR(200) DEFAULT '' NOT NULL,

+ icon_topic_latest VARCHAR(200) DEFAULT '' NOT NULL,

+ icon_topic_newest VARCHAR(200) DEFAULT '' NOT NULL,

+ icon_topic_reported VARCHAR(200) DEFAULT '' NOT NULL,

+ icon_topic_unapproved VARCHAR(200) DEFAULT '' NOT NULL,

+ icon_user_online VARCHAR(200) DEFAULT '' NOT NULL,

+ icon_user_offline VARCHAR(200) DEFAULT '' NOT NULL,

+ icon_user_profile VARCHAR(200) DEFAULT '' NOT NULL,

+ icon_user_search VARCHAR(200) DEFAULT '' NOT NULL,

+ icon_user_warn VARCHAR(200) DEFAULT '' NOT NULL,

+ button_pm_forward VARCHAR(200) DEFAULT '' NOT NULL,

+ button_pm_new VARCHAR(200) DEFAULT '' NOT NULL,

+ button_pm_reply VARCHAR(200) DEFAULT '' NOT NULL,

+ button_topic_locked VARCHAR(200) DEFAULT '' NOT NULL,

+ button_topic_new VARCHAR(200) DEFAULT '' NOT NULL,

+ button_topic_reply VARCHAR(200) DEFAULT '' NOT NULL,

+ user_icon1 VARCHAR(200) DEFAULT '' NOT NULL,

+ user_icon2 VARCHAR(200) DEFAULT '' NOT NULL,

+ user_icon3 VARCHAR(200) DEFAULT '' NOT NULL,

+ user_icon4 VARCHAR(200) DEFAULT '' NOT NULL,

+ user_icon5 VARCHAR(200) DEFAULT '' NOT NULL,

+ user_icon6 VARCHAR(200) DEFAULT '' NOT NULL,

+ user_icon7 VARCHAR(200) DEFAULT '' NOT NULL,

+ user_icon8 VARCHAR(200) DEFAULT '' NOT NULL,

+ user_icon9 VARCHAR(200) DEFAULT '' NOT NULL,

+ user_icon10 VARCHAR(200) DEFAULT '' NOT NULL

+CREATE TRIGGER t_phpbb_styles_imageset FOR phpbb_styles_imageset

+ NEW.imageset_id = GEN_ID(phpbb_styles_imageset_gen, 1);

+

+# Table: 'phpbb_topics'

+ topic_id INTEGER NOT NULL,

+ forum_id INTEGER DEFAULT 0 NOT NULL,

+ icon_id INTEGER DEFAULT 0 NOT NULL,

+ topic_attachment INTEGER DEFAULT 0 NOT NULL,

+ topic_approved INTEGER DEFAULT 1 NOT NULL,

+ topic_reported INTEGER DEFAULT 0 NOT NULL,

+ topic_title BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,

+ topic_poster INTEGER DEFAULT 0 NOT NULL,

+ topic_time INTEGER DEFAULT 0 NOT NULL,

+ topic_time_limit INTEGER DEFAULT 0 NOT NULL,

+ topic_views INTEGER DEFAULT 0 NOT NULL,

+ topic_replies INTEGER DEFAULT 0 NOT NULL,

+ topic_replies_real INTEGER DEFAULT 0 NOT NULL,

+ topic_status INTEGER DEFAULT 0 NOT NULL,

+ topic_type INTEGER DEFAULT 0 NOT NULL,

+ topic_first_post_id INTEGER DEFAULT 0 NOT NULL,

+ topic_first_poster_name VARCHAR(255) DEFAULT '' NOT NULL,

+ topic_last_post_id INTEGER DEFAULT 0 NOT NULL,

+ topic_last_poster_id INTEGER DEFAULT 0 NOT NULL,

+ topic_last_poster_name VARCHAR(255) DEFAULT '' NOT NULL,

+ topic_last_post_time INTEGER DEFAULT 0 NOT NULL,

+ topic_last_view_time INTEGER DEFAULT 0 NOT NULL,

+ topic_moved_id INTEGER DEFAULT 0 NOT NULL,

+ topic_bumped INTEGER DEFAULT 0 NOT NULL,

+ topic_bumper INTEGER DEFAULT 0 NOT NULL,

+ poll_title BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,

+ poll_start INTEGER DEFAULT 0 NOT NULL,

+ poll_length INTEGER DEFAULT 0 NOT NULL,

+ poll_max_options INTEGER DEFAULT 1 NOT NULL,

+ poll_last_vote INTEGER DEFAULT 0 NOT NULL,

+ poll_vote_change INTEGER DEFAULT 0 NOT NULL

+CREATE INDEX phpbb_topics_last_post_time ON phpbb_topics(topic_last_post_time);;

+CREATE INDEX phpbb_topics_fid_time_moved ON phpbb_topics(forum_id, topic_last_post_time, topic_moved_id);;

+CREATE TRIGGER t_phpbb_topics FOR phpbb_topics

+ NEW.topic_id = GEN_ID(phpbb_topics_gen, 1);

+# Table: 'phpbb_topics_track'

+ user_id INTEGER DEFAULT 0 NOT NULL,

+ topic_id INTEGER DEFAULT 0 NOT NULL,

+ forum_id INTEGER DEFAULT 0 NOT NULL,

+ mark_time INTEGER DEFAULT 0 NOT NULL

+# Table: 'phpbb_topics_posted'

+ user_id INTEGER DEFAULT 0 NOT NULL,

+ topic_id INTEGER DEFAULT 0 NOT NULL,

+ topic_posted INTEGER DEFAULT 0 NOT NULL

+# Table: 'phpbb_topics_watch'

+ topic_id INTEGER DEFAULT 0 NOT NULL,

+ user_id INTEGER DEFAULT 0 NOT NULL,

+ notify_status INTEGER DEFAULT 0 NOT NULL

+CREATE INDEX phpbb_topics_watch_notify_stat ON phpbb_topics_watch(notify_status);;

+# Table: 'phpbb_user_group'

+ group_id INTEGER DEFAULT 0 NOT NULL,

+ user_id INTEGER DEFAULT 0 NOT NULL,

+ group_leader INTEGER DEFAULT 0 NOT NULL,

+ user_pending INTEGER DEFAULT 1 NOT NULL

+CREATE INDEX phpbb_user_group_group_leader ON phpbb_user_group(group_leader);;

+# Table: 'phpbb_users'

+ user_id INTEGER NOT NULL,

+ user_type INTEGER DEFAULT 0 NOT NULL,

+ group_id INTEGER DEFAULT 3 NOT NULL,

+ user_permissions BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,

+ user_perm_from INTEGER DEFAULT 0 NOT NULL,

+ user_ip VARCHAR(40) DEFAULT '' NOT NULL,

+ user_regdate INTEGER DEFAULT 0 NOT NULL,

+ username VARCHAR(252) DEFAULT '' NOT NULL,

+ user_password VARCHAR(40) DEFAULT '' NOT NULL,

+ user_passchg INTEGER DEFAULT 0 NOT NULL,

+ user_email VARCHAR(100) DEFAULT '' NOT NULL,

+ user_email_hash DOUBLE PRECISION DEFAULT 0 NOT NULL,

+ user_birthday VARCHAR(10) DEFAULT '' NOT NULL,

+ user_lastvisit INTEGER DEFAULT 0 NOT NULL,

+ user_lastmark INTEGER DEFAULT 0 NOT NULL,

+ user_lastpost_time INTEGER DEFAULT 0 NOT NULL,

+ user_lastpage VARCHAR(200) DEFAULT '' NOT NULL,

+ user_last_confirm_key VARCHAR(10) DEFAULT '' NOT NULL,

+ user_last_search INTEGER DEFAULT 0 NOT NULL,

+ user_warnings INTEGER DEFAULT 0 NOT NULL,

+ user_last_warning INTEGER DEFAULT 0 NOT NULL,

+ user_login_attempts INTEGER DEFAULT 0 NOT NULL,

+ user_posts INTEGER DEFAULT 0 NOT NULL,

+ user_lang VARCHAR(30) DEFAULT '' NOT NULL,

+ user_timezone DOUBLE PRECISION DEFAULT 0 NOT NULL,

+ user_dst INTEGER DEFAULT 0 NOT NULL,

+ user_dateformat VARCHAR(30) DEFAULT 'd M Y H:i' NOT NULL,

+ user_style INTEGER DEFAULT 0 NOT NULL,

+ user_rank INTEGER DEFAULT 0 NOT NULL,

+ user_colour VARCHAR(6) DEFAULT '' NOT NULL,

+ user_new_privmsg INTEGER DEFAULT 0 NOT NULL,

+ user_unread_privmsg INTEGER DEFAULT 0 NOT NULL,

+ user_last_privmsg INTEGER DEFAULT 0 NOT NULL,

+ user_message_rules INTEGER DEFAULT 0 NOT NULL,

+ user_full_folder INTEGER DEFAULT -3 NOT NULL,

+ user_emailtime INTEGER DEFAULT 0 NOT NULL,

+ user_topic_show_days INTEGER DEFAULT 0 NOT NULL,

+ user_topic_sortby_type VARCHAR(1) DEFAULT 't' NOT NULL,

+ user_topic_sortby_dir VARCHAR(1) DEFAULT 'd' NOT NULL,

+ user_post_show_days INTEGER DEFAULT 0 NOT NULL,

+ user_post_sortby_type VARCHAR(1) DEFAULT 't' NOT NULL,

+ user_post_sortby_dir VARCHAR(1) DEFAULT 'a' NOT NULL,

+ user_notify INTEGER DEFAULT 0 NOT NULL,

+ user_notify_pm INTEGER DEFAULT 1 NOT NULL,

+ user_notify_type INTEGER DEFAULT 0 NOT NULL,

+ user_allow_pm INTEGER DEFAULT 1 NOT NULL,

+ user_allow_email INTEGER DEFAULT 1 NOT NULL,

+ user_allow_viewonline INTEGER DEFAULT 1 NOT NULL,

+ user_allow_viewemail INTEGER DEFAULT 1 NOT NULL,

+ user_allow_massemail INTEGER DEFAULT 1 NOT NULL,

+ user_options INTEGER DEFAULT 893 NOT NULL,

+ user_avatar VARCHAR(255) DEFAULT '' NOT NULL,

+ user_avatar_type INTEGER DEFAULT 0 NOT NULL,

+ user_avatar_width INTEGER DEFAULT 0 NOT NULL,

+ user_avatar_height INTEGER DEFAULT 0 NOT NULL,

+ user_sig BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,

+ user_sig_bbcode_uid VARCHAR(5) DEFAULT '' NOT NULL,

+ user_sig_bbcode_bitfield VARCHAR(252) DEFAULT '' NOT NULL,

+ user_from VARCHAR(100) DEFAULT '' NOT NULL,

+ user_icq VARCHAR(15) DEFAULT '' NOT NULL,

+ user_aim VARCHAR(255) DEFAULT '' NOT NULL,

+ user_yim VARCHAR(255) DEFAULT '' NOT NULL,

+ user_msnm VARCHAR(255) DEFAULT '' NOT NULL,

+ user_jabber VARCHAR(255) DEFAULT '' NOT NULL,

+ user_website VARCHAR(200) DEFAULT '' NOT NULL,

+ user_occ VARCHAR(255) DEFAULT '' NOT NULL,

+ user_interests BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,

+ user_actkey VARCHAR(32) DEFAULT '' NOT NULL,

+ user_newpasswd VARCHAR(32) DEFAULT '' NOT NULL

+CREATE INDEX phpbb_users_user_type ON phpbb_users(user_type);;

+CREATE TRIGGER t_phpbb_users FOR phpbb_users

+ NEW.user_id = GEN_ID(phpbb_users_gen, 1);

+# Table: 'phpbb_warnings'

+ warning_id INTEGER NOT NULL,

+ user_id INTEGER DEFAULT 0 NOT NULL,

+ post_id INTEGER DEFAULT 0 NOT NULL,

+ log_id INTEGER DEFAULT 0 NOT NULL,

+ warning_time INTEGER DEFAULT 0 NOT NULL

+

+CREATE TRIGGER t_phpbb_warnings FOR phpbb_warnings

+ NEW.warning_id = GEN_ID(phpbb_warnings_gen, 1);

+# Table: 'phpbb_words'

+ word_id INTEGER NOT NULL,

+ word VARCHAR(255) DEFAULT '' NOT NULL,

+ replacement VARCHAR(255) DEFAULT '' NOT NULL

+

+CREATE TRIGGER t_phpbb_words FOR phpbb_words

+ NEW.word_id = GEN_ID(phpbb_words_gen, 1);

+# Table: 'phpbb_zebra'

+ user_id INTEGER DEFAULT 0 NOT NULL,

+ zebra_id INTEGER DEFAULT 0 NOT NULL,

+ friend INTEGER DEFAULT 0 NOT NULL,

+ foe INTEGER DEFAULT 0 NOT NULL

+ MSSQL Schema for phpBB 3.x - (c) phpBB Group, 2005

+ $Id$

+ Table: 'phpbb_attachments'

+ [post_msg_id] [int] DEFAULT (0) NOT NULL ,

+ [topic_id] [int] DEFAULT (0) NOT NULL ,

+ [in_message] [int] DEFAULT (0) NOT NULL ,

+ [poster_id] [int] DEFAULT (0) NOT NULL ,

+ [physical_filename] [varchar] (255) DEFAULT ('') NOT NULL ,

+ [real_filename] [varchar] (255) DEFAULT ('') NOT NULL ,

+ [download_count] [int] DEFAULT (0) NOT NULL ,

+ [attach_comment] [varchar] (8000) DEFAULT ('') NOT NULL ,

+ [extension] [varchar] (100) DEFAULT ('') NOT NULL ,

+ [mimetype] [varchar] (100) DEFAULT ('') NOT NULL ,

+ [filesize] [int] DEFAULT (0) NOT NULL ,

+ [filetime] [int] DEFAULT (0) NOT NULL ,

+ [thumbnail] [int] DEFAULT (0) NOT NULL

+ Table: 'phpbb_acl_groups'

+ [group_id] [int] DEFAULT (0) NOT NULL ,

+ [forum_id] [int] DEFAULT (0) NOT NULL ,

+ [auth_option_id] [int] DEFAULT (0) NOT NULL ,

+ [auth_role_id] [int] DEFAULT (0) NOT NULL ,

+ [auth_setting] [int] DEFAULT (0) NOT NULL

+CREATE INDEX [auth_opt_id] ON [phpbb_acl_groups]([auth_option_id]) ON [PRIMARY]

+ Table: 'phpbb_acl_options'

+ [auth_option] [varchar] (50) DEFAULT ('') NOT NULL ,

+ [is_global] [int] DEFAULT (0) NOT NULL ,

+ [is_local] [int] DEFAULT (0) NOT NULL ,

+ [founder_only] [int] DEFAULT (0) NOT NULL

+ Table: 'phpbb_acl_roles'

+ [role_name] [varchar] (255) DEFAULT ('') NOT NULL ,

+ [role_description] [varchar] (8000) DEFAULT ('') NOT NULL ,

+ [role_type] [varchar] (10) DEFAULT ('') NOT NULL ,

+ [role_order] [int] DEFAULT (0) NOT NULL

+ Table: 'phpbb_acl_roles_data'

+ [role_id] [int] DEFAULT (0) NOT NULL ,

+ [auth_option_id] [int] DEFAULT (0) NOT NULL ,

+ [auth_setting] [int] DEFAULT (0) NOT NULL

+ Table: 'phpbb_acl_users'

+ [user_id] [int] DEFAULT (0) NOT NULL ,

+ [forum_id] [int] DEFAULT (0) NOT NULL ,

+ [auth_option_id] [int] DEFAULT (0) NOT NULL ,

+ [auth_role_id] [int] DEFAULT (0) NOT NULL ,

+ [auth_setting] [int] DEFAULT (0) NOT NULL

+ Table: 'phpbb_banlist'

+ [ban_userid] [int] DEFAULT (0) NOT NULL ,

+ [ban_ip] [varchar] (40) DEFAULT ('') NOT NULL ,

+ [ban_email] [varchar] (100) DEFAULT ('') NOT NULL ,

+ [ban_start] [int] DEFAULT (0) NOT NULL ,

+ [ban_end] [int] DEFAULT (0) NOT NULL ,

+ [ban_exclude] [int] DEFAULT (0) NOT NULL ,

+ [ban_reason] [varchar] (3000) DEFAULT ('') NOT NULL ,

+ [ban_give_reason] [varchar] (3000) DEFAULT ('') NOT NULL

+CREATE INDEX [ban_end] ON [phpbb_banlist]([ban_end]) ON [PRIMARY]

+GO

+

+CREATE INDEX [ban_user] ON [phpbb_banlist]([ban_userid], [ban_exclude]) ON [PRIMARY]

+GO

+

+CREATE INDEX [ban_email] ON [phpbb_banlist]([ban_email], [ban_exclude]) ON [PRIMARY]

+GO

+

+CREATE INDEX [ban_ip] ON [phpbb_banlist]([ban_ip], [ban_exclude]) ON [PRIMARY]

+ Table: 'phpbb_bbcodes'

+ [bbcode_id] [int] DEFAULT (0) NOT NULL ,

+ [bbcode_tag] [varchar] (16) DEFAULT ('') NOT NULL ,

+ [bbcode_helpline] [varchar] (255) DEFAULT ('') NOT NULL ,

+ [display_on_posting] [int] DEFAULT (0) NOT NULL ,

+ [bbcode_match] [varchar] (8000) DEFAULT ('') NOT NULL ,

+ [bbcode_tpl] [text] DEFAULT ('') NOT NULL ,

+ [first_pass_match] [text] DEFAULT ('') NOT NULL ,

+ [first_pass_replace] [text] DEFAULT ('') NOT NULL ,

+ [second_pass_match] [text] DEFAULT ('') NOT NULL ,

+ [second_pass_replace] [text] DEFAULT ('') NOT NULL

+CREATE INDEX [display_on_post] ON [phpbb_bbcodes]([display_on_posting]) ON [PRIMARY]

+ Table: 'phpbb_bookmarks'

+ [topic_id] [int] DEFAULT (0) NOT NULL ,

+ [user_id] [int] DEFAULT (0) NOT NULL ,

+ [order_id] [int] DEFAULT (0) NOT NULL

+ Table: 'phpbb_bots'

+ [bot_active] [int] DEFAULT (1) NOT NULL ,

+ [bot_name] [varchar] (3000) DEFAULT ('') NOT NULL ,

+ [user_id] [int] DEFAULT (0) NOT NULL ,

+ [bot_agent] [varchar] (255) DEFAULT ('') NOT NULL ,

+ [bot_ip] [varchar] (255) DEFAULT ('') NOT NULL

+ Table: 'phpbb_config'

+ [config_name] [varchar] (252) DEFAULT ('') NOT NULL ,

+ [config_value] [varchar] (255) DEFAULT ('') NOT NULL ,

+ [is_dynamic] [int] DEFAULT (0) NOT NULL

+ Table: 'phpbb_confirm'

+ [confirm_id] [char] (32) DEFAULT ('') NOT NULL ,

+ [session_id] [char] (32) DEFAULT ('') NOT NULL ,

+ [confirm_type] [int] DEFAULT (0) NOT NULL ,

+ [code] [varchar] (8) DEFAULT ('') NOT NULL

+CREATE INDEX [confirm_type] ON [phpbb_confirm]([confirm_type]) ON [PRIMARY]

+ Table: 'phpbb_disallow'

+ [disallow_username] [varchar] (252) DEFAULT ('') NOT NULL

+ Table: 'phpbb_drafts'

+ [user_id] [int] DEFAULT (0) NOT NULL ,

+ [topic_id] [int] DEFAULT (0) NOT NULL ,

+ [forum_id] [int] DEFAULT (0) NOT NULL ,

+ [save_time] [int] DEFAULT (0) NOT NULL ,

+ [draft_subject] [varchar] (1000) DEFAULT ('') NOT NULL ,

+ [draft_message] [text] DEFAULT ('') NOT NULL

+ Table: 'phpbb_extensions'

+ [group_id] [int] DEFAULT (0) NOT NULL ,

+ [extension] [varchar] (100) DEFAULT ('') NOT NULL

+ Table: 'phpbb_extension_groups'

+ [group_name] [varchar] (255) DEFAULT ('') NOT NULL ,

+ [cat_id] [int] DEFAULT (0) NOT NULL ,

+ [allow_group] [int] DEFAULT (0) NOT NULL ,

+ [download_mode] [int] DEFAULT (1) NOT NULL ,

+ [upload_icon] [varchar] (255) DEFAULT ('') NOT NULL ,

+ [max_filesize] [int] DEFAULT (0) NOT NULL ,

+ [allowed_forums] [varchar] (8000) DEFAULT ('') NOT NULL ,

+ [allow_in_pm] [int] DEFAULT (0) NOT NULL

+) ON [PRIMARY]

+ Table: 'phpbb_forums'

+ [parent_id] [int] DEFAULT (0) NOT NULL ,

+ [left_id] [int] DEFAULT (0) NOT NULL ,

+ [right_id] [int] DEFAULT (0) NOT NULL ,

+ [forum_parents] [text] DEFAULT ('') NOT NULL ,

+ [forum_name] [varchar] (3000) DEFAULT ('') NOT NULL ,

+ [forum_desc] [varchar] (8000) DEFAULT ('') NOT NULL ,

+ [forum_desc_bitfield] [varchar] (252) DEFAULT ('') NOT NULL ,

+ [forum_desc_options] [int] DEFAULT (0) NOT NULL ,

+ [forum_desc_uid] [varchar] (5) DEFAULT ('') NOT NULL ,

+ [forum_link] [varchar] (255) DEFAULT ('') NOT NULL ,

+ [forum_password] [varchar] (40) DEFAULT ('') NOT NULL ,

+ [forum_style] [int] DEFAULT (0) NOT NULL ,

+ [forum_image] [varchar] (255) DEFAULT ('') NOT NULL ,

+ [forum_rules] [varchar] (8000) DEFAULT ('') NOT NULL ,

+ [forum_rules_link] [varchar] (255) DEFAULT ('') NOT NULL ,

+ [forum_rules_bitfield] [varchar] (252) DEFAULT ('') NOT NULL ,

+ [forum_rules_options] [int] DEFAULT (0) NOT NULL ,

+ [forum_rules_uid] [varchar] (5) DEFAULT ('') NOT NULL ,

+ [forum_topics_per_page] [int] DEFAULT (0) NOT NULL ,

+ [forum_type] [int] DEFAULT (0) NOT NULL ,

+ [forum_status] [int] DEFAULT (0) NOT NULL ,

+ [forum_posts] [int] DEFAULT (0) NOT NULL ,

+ [forum_topics] [int] DEFAULT (0) NOT NULL ,

+ [forum_topics_real] [int] DEFAULT (0) NOT NULL ,

+ [forum_last_post_id] [int] DEFAULT (0) NOT NULL ,

+ [forum_last_poster_id] [int] DEFAULT (0) NOT NULL ,

+ [forum_last_post_time] [int] DEFAULT (0) NOT NULL ,

+ [forum_last_poster_name] [varchar] (255) DEFAULT ('') NOT NULL ,

+ [forum_flags] [int] DEFAULT (32) NOT NULL ,

+ [display_on_index] [int] DEFAULT (1) NOT NULL ,

+ [enable_indexing] [int] DEFAULT (1) NOT NULL ,

+ [enable_icons] [int] DEFAULT (1) NOT NULL ,

+ [enable_prune] [int] DEFAULT (0) NOT NULL ,

+ [prune_next] [int] DEFAULT (0) NOT NULL ,

+ [prune_days] [int] DEFAULT (0) NOT NULL ,

+ [prune_viewed] [int] DEFAULT (0) NOT NULL ,

+ [prune_freq] [int] DEFAULT (0) NOT NULL

+CREATE INDEX [forum_lastpost_id] ON [phpbb_forums]([forum_last_post_id]) ON [PRIMARY]

+ Table: 'phpbb_forums_access'

+ [forum_id] [int] DEFAULT (0) NOT NULL ,

+ [user_id] [int] DEFAULT (0) NOT NULL ,

+ [session_id] [char] (32) DEFAULT ('') NOT NULL

+ Table: 'phpbb_forums_track'

+ [user_id] [int] DEFAULT (0) NOT NULL ,

+ [forum_id] [int] DEFAULT (0) NOT NULL ,

+ [mark_time] [int] DEFAULT (0) NOT NULL

+ Table: 'phpbb_forums_watch'

+ [forum_id] [int] DEFAULT (0) NOT NULL ,

+ [user_id] [int] DEFAULT (0) NOT NULL ,

+ [notify_status] [int] DEFAULT (0) NOT NULL

+CREATE INDEX [notify_stat] ON [phpbb_forums_watch]([notify_status]) ON [PRIMARY]

+ Table: 'phpbb_groups'

+ [group_type] [int] DEFAULT (1) NOT NULL ,

+ [group_name] [varchar] (252) DEFAULT ('') NOT NULL ,

+ [group_desc] [varchar] (8000) DEFAULT ('') NOT NULL ,

+ [group_desc_bitfield] [varchar] (252) DEFAULT ('') NOT NULL ,

+ [group_desc_options] [int] DEFAULT (0) NOT NULL ,

+ [group_desc_uid] [varchar] (5) DEFAULT ('') NOT NULL ,

+ [group_display] [int] DEFAULT (0) NOT NULL ,

+ [group_avatar] [varchar] (255) DEFAULT ('') NOT NULL ,

+ [group_avatar_type] [int] DEFAULT (0) NOT NULL ,

+ [group_avatar_width] [int] DEFAULT (0) NOT NULL ,

+ [group_avatar_height] [int] DEFAULT (0) NOT NULL ,

+ [group_rank] [int] DEFAULT (0) NOT NULL ,

+ [group_colour] [varchar] (6) DEFAULT ('') NOT NULL ,

+ [group_sig_chars] [int] DEFAULT (0) NOT NULL ,

+ [group_receive_pm] [int] DEFAULT (0) NOT NULL ,

+ [group_message_limit] [int] DEFAULT (0) NOT NULL ,

+ [group_legend] [int] DEFAULT (1) NOT NULL

+) ON [PRIMARY]

+ Table: 'phpbb_icons'

+ [icons_url] [varchar] (255) DEFAULT ('') NOT NULL ,

+ [icons_width] [int] DEFAULT (0) NOT NULL ,

+ [icons_height] [int] DEFAULT (0) NOT NULL ,

+ [icons_order] [int] DEFAULT (0) NOT NULL ,

+ [display_on_posting] [int] DEFAULT (1) NOT NULL

+CREATE INDEX [display_on_posting] ON [phpbb_icons]([display_on_posting]) ON [PRIMARY]

+ Table: 'phpbb_lang'

+ [lang_iso] [varchar] (30) DEFAULT ('') NOT NULL ,

+ [lang_dir] [varchar] (30) DEFAULT ('') NOT NULL ,

+ [lang_english_name] [varchar] (100) DEFAULT ('') NOT NULL ,

+ [lang_local_name] [varchar] (255) DEFAULT ('') NOT NULL ,

+ [lang_author] [varchar] (255) DEFAULT ('') NOT NULL

+CREATE INDEX [lang_iso] ON [phpbb_lang]([lang_iso]) ON [PRIMARY]

+GO

+

+ Table: 'phpbb_log'

+ [log_type] [int] DEFAULT (0) NOT NULL ,

+ [user_id] [int] DEFAULT (0) NOT NULL ,

+ [forum_id] [int] DEFAULT (0) NOT NULL ,

+ [topic_id] [int] DEFAULT (0) NOT NULL ,

+ [reportee_id] [int] DEFAULT (0) NOT NULL ,

+ [log_ip] [varchar] (40) DEFAULT ('') NOT NULL ,

+ [log_time] [int] DEFAULT (0) NOT NULL ,

+ [log_operation] [varchar] (8000) DEFAULT ('') NOT NULL ,

+ [log_data] [text] DEFAULT ('') NOT NULL

+ Table: 'phpbb_moderator_cache'

+ [forum_id] [int] DEFAULT (0) NOT NULL ,

+ [user_id] [int] DEFAULT (0) NOT NULL ,

+ [username] [varchar] (252) DEFAULT ('') NOT NULL ,

+ [group_id] [int] DEFAULT (0) NOT NULL ,

+ [group_name] [varchar] (255) DEFAULT ('') NOT NULL ,

+ [display_on_index] [int] DEFAULT (1) NOT NULL

+CREATE INDEX [disp_idx] ON [phpbb_moderator_cache]([display_on_index]) ON [PRIMARY]

+ Table: 'phpbb_modules'

+ [module_enabled] [int] DEFAULT (1) NOT NULL ,

+ [module_display] [int] DEFAULT (1) NOT NULL ,

+ [module_basename] [varchar] (255) DEFAULT ('') NOT NULL ,

+ [module_class] [varchar] (10) DEFAULT ('') NOT NULL ,

+ [parent_id] [int] DEFAULT (0) NOT NULL ,

+ [left_id] [int] DEFAULT (0) NOT NULL ,

+ [right_id] [int] DEFAULT (0) NOT NULL ,

+ [module_langname] [varchar] (255) DEFAULT ('') NOT NULL ,

+ [module_mode] [varchar] (255) DEFAULT ('') NOT NULL ,

+ [module_auth] [varchar] (255) DEFAULT ('') NOT NULL

+CREATE INDEX [left_right_id] ON [phpbb_modules]([left_id], [right_id]) ON [PRIMARY]

+CREATE INDEX [class_left_id] ON [phpbb_modules]([module_class], [left_id]) ON [PRIMARY]

+ Table: 'phpbb_poll_options'

+ [poll_option_id] [int] DEFAULT (0) NOT NULL ,

+ [topic_id] [int] DEFAULT (0) NOT NULL ,

+ [poll_option_text] [varchar] (8000) DEFAULT ('') NOT NULL ,

+ [poll_option_total] [int] DEFAULT (0) NOT NULL

+CREATE INDEX [poll_opt_id] ON [phpbb_poll_options]([poll_option_id]) ON [PRIMARY]

+ Table: 'phpbb_poll_votes'

+ [topic_id] [int] DEFAULT (0) NOT NULL ,

+ [poll_option_id] [int] DEFAULT (0) NOT NULL ,

+ [vote_user_id] [int] DEFAULT (0) NOT NULL ,

+ [vote_user_ip] [varchar] (40) DEFAULT ('') NOT NULL

+ Table: 'phpbb_posts'

+ [topic_id] [int] DEFAULT (0) NOT NULL ,

+ [forum_id] [int] DEFAULT (0) NOT NULL ,

+ [poster_id] [int] DEFAULT (0) NOT NULL ,

+ [icon_id] [int] DEFAULT (0) NOT NULL ,

+ [poster_ip] [varchar] (40) DEFAULT ('') NOT NULL ,

+ [post_time] [int] DEFAULT (0) NOT NULL ,

+ [post_approved] [int] DEFAULT (1) NOT NULL ,

+ [post_reported] [int] DEFAULT (0) NOT NULL ,

+ [enable_bbcode] [int] DEFAULT (1) NOT NULL ,

+ [enable_smilies] [int] DEFAULT (1) NOT NULL ,

+ [enable_magic_url] [int] DEFAULT (1) NOT NULL ,

+ [enable_sig] [int] DEFAULT (1) NOT NULL ,

+ [post_username] [varchar] (252) DEFAULT ('') NOT NULL ,

+ [post_subject] [varchar] (1000) DEFAULT ('') NOT NULL ,

+ [post_text] [text] DEFAULT ('') NOT NULL ,

+ [post_checksum] [varchar] (32) DEFAULT ('') NOT NULL ,

+ [post_encoding] [varchar] (20) DEFAULT ('iso-8859-1') NOT NULL ,

+ [post_attachment] [int] DEFAULT (0) NOT NULL ,

+ [bbcode_bitfield] [varchar] (252) DEFAULT ('') NOT NULL ,

+ [bbcode_uid] [varchar] (5) DEFAULT ('') NOT NULL ,

+ [post_postcount] [int] DEFAULT (1) NOT NULL ,

+ [post_edit_time] [int] DEFAULT (0) NOT NULL ,

+ [post_edit_reason] [varchar] (3000) DEFAULT ('') NOT NULL ,

+ [post_edit_user] [int] DEFAULT (0) NOT NULL ,

+ [post_edit_count] [int] DEFAULT (0) NOT NULL ,

+ [post_edit_locked] [int] DEFAULT (0) NOT NULL

+CREATE INDEX [post_postcount] ON [phpbb_posts]([post_postcount]) ON [PRIMARY]

+GO

+

+ Table: 'phpbb_privmsgs'

+ [root_level] [int] DEFAULT (0) NOT NULL ,

+ [author_id] [int] DEFAULT (0) NOT NULL ,

+ [icon_id] [int] DEFAULT (0) NOT NULL ,

+ [author_ip] [varchar] (40) DEFAULT ('') NOT NULL ,

+ [message_time] [int] DEFAULT (0) NOT NULL ,

+ [enable_bbcode] [int] DEFAULT (1) NOT NULL ,

+ [enable_smilies] [int] DEFAULT (1) NOT NULL ,

+ [enable_magic_url] [int] DEFAULT (1) NOT NULL ,

+ [enable_sig] [int] DEFAULT (1) NOT NULL ,

+ [message_subject] [varchar] (1000) DEFAULT ('') NOT NULL ,

+ [message_text] [text] DEFAULT ('') NOT NULL ,

+ [message_edit_reason] [varchar] (3000) DEFAULT ('') NOT NULL ,

+ [message_edit_user] [int] DEFAULT (0) NOT NULL ,

+ [message_encoding] [varchar] (20) DEFAULT ('iso-8859-1') NOT NULL ,

+ [message_attachment] [int] DEFAULT (0) NOT NULL ,

+ [bbcode_bitfield] [varchar] (252) DEFAULT ('') NOT NULL ,

+ [bbcode_uid] [varchar] (5) DEFAULT ('') NOT NULL ,

+ [message_edit_time] [int] DEFAULT (0) NOT NULL ,

+ [message_edit_count] [int] DEFAULT (0) NOT NULL ,

+ [to_address] [varchar] (8000) DEFAULT ('') NOT NULL ,

+ [bcc_address] [varchar] (8000) DEFAULT ('') NOT NULL

+ Table: 'phpbb_privmsgs_folder'

+ [user_id] [int] DEFAULT (0) NOT NULL ,

+ [folder_name] [varchar] (255) DEFAULT ('') NOT NULL ,

+ [pm_count] [int] DEFAULT (0) NOT NULL

+ Table: 'phpbb_privmsgs_rules'

+ [user_id] [int] DEFAULT (0) NOT NULL ,

+ [rule_check] [int] DEFAULT (0) NOT NULL ,

+ [rule_connection] [int] DEFAULT (0) NOT NULL ,

+ [rule_string] [varchar] (255) DEFAULT ('') NOT NULL ,

+ [rule_user_id] [int] DEFAULT (0) NOT NULL ,

+ [rule_group_id] [int] DEFAULT (0) NOT NULL ,

+ [rule_action] [int] DEFAULT (0) NOT NULL ,

+ [rule_folder_id] [int] DEFAULT (0) NOT NULL

+CREATE INDEX [user_id] ON [phpbb_privmsgs_rules]([user_id]) ON [PRIMARY]

+ Table: 'phpbb_privmsgs_to'

+ [msg_id] [int] DEFAULT (0) NOT NULL ,

+ [user_id] [int] DEFAULT (0) NOT NULL ,

+ [author_id] [int] DEFAULT (0) NOT NULL ,

+ [pm_deleted] [int] DEFAULT (0) NOT NULL ,

+ [pm_new] [int] DEFAULT (1) NOT NULL ,

+ [pm_unread] [int] DEFAULT (1) NOT NULL ,

+ [pm_replied] [int] DEFAULT (0) NOT NULL ,

+ [pm_marked] [int] DEFAULT (0) NOT NULL ,

+ [pm_forwarded] [int] DEFAULT (0) NOT NULL ,

+ [folder_id] [int] DEFAULT (0) NOT NULL

+CREATE INDEX [msg_id] ON [phpbb_privmsgs_to]([msg_id]) ON [PRIMARY]

+CREATE INDEX [author_id] ON [phpbb_privmsgs_to]([author_id]) ON [PRIMARY]

+CREATE INDEX [usr_flder_id] ON [phpbb_privmsgs_to]([user_id], [folder_id]) ON [PRIMARY]

+ Table: 'phpbb_profile_fields'

+ [field_name] [varchar] (255) DEFAULT ('') NOT NULL ,

+ [field_type] [int] DEFAULT (0) NOT NULL ,

+ [field_ident] [varchar] (20) DEFAULT ('') NOT NULL ,

+ [field_length] [varchar] (20) DEFAULT ('') NOT NULL ,

+ [field_minlen] [varchar] (255) DEFAULT ('') NOT NULL ,

+ [field_maxlen] [varchar] (255) DEFAULT ('') NOT NULL ,

+ [field_novalue] [varchar] (255) DEFAULT ('') NOT NULL ,

+ [field_default_value] [varchar] (255) DEFAULT ('') NOT NULL ,

+ [field_validation] [varchar] (20) DEFAULT ('') NOT NULL ,

+ [field_required] [int] DEFAULT (0) NOT NULL ,

+ [field_show_on_reg] [int] DEFAULT (0) NOT NULL ,

+ [field_hide] [int] DEFAULT (0) NOT NULL ,

+ [field_no_view] [int] DEFAULT (0) NOT NULL ,

+ [field_active] [int] DEFAULT (0) NOT NULL ,

+ [field_order] [int] DEFAULT (0) NOT NULL

+CREATE INDEX [fld_type] ON [phpbb_profile_fields]([field_type]) ON [PRIMARY]

+CREATE INDEX [fld_ordr] ON [phpbb_profile_fields]([field_order]) ON [PRIMARY]

+ Table: 'phpbb_profile_fields_data'

+ [user_id] [int] DEFAULT (0) NOT NULL

+ Table: 'phpbb_profile_fields_lang'

+ [field_id] [int] DEFAULT (0) NOT NULL ,

+ [lang_id] [int] DEFAULT (0) NOT NULL ,

+ [option_id] [int] DEFAULT (0) NOT NULL ,

+ [field_type] [int] DEFAULT (0) NOT NULL ,

+ [lang_value] [varchar] (255) DEFAULT ('') NOT NULL

+ Table: 'phpbb_profile_lang'

+ [field_id] [int] DEFAULT (0) NOT NULL ,

+ [lang_id] [int] DEFAULT (0) NOT NULL ,

+ [lang_name] [varchar] (255) DEFAULT ('') NOT NULL ,

+ [lang_explain] [varchar] (8000) DEFAULT ('') NOT NULL ,

+ [lang_default_value] [varchar] (255) DEFAULT ('') NOT NULL

+) ON [PRIMARY]

+ Table: 'phpbb_ranks'

+ [rank_title] [varchar] (255) DEFAULT ('') NOT NULL ,

+ [rank_min] [int] DEFAULT (0) NOT NULL ,

+ [rank_special] [int] DEFAULT (0) NOT NULL ,

+ [rank_image] [varchar] (255) DEFAULT ('') NOT NULL

+ Table: 'phpbb_reports'

+ [reason_id] [int] DEFAULT (0) NOT NULL ,

+ [post_id] [int] DEFAULT (0) NOT NULL ,

+ [user_id] [int] DEFAULT (0) NOT NULL ,

+ [user_notify] [int] DEFAULT (0) NOT NULL ,

+ [report_closed] [int] DEFAULT (0) NOT NULL ,

+ [report_time] [int] DEFAULT (0) NOT NULL ,

+ [report_text] [text] DEFAULT ('') NOT NULL

+ Table: 'phpbb_reports_reasons'

+ [reason_title] [varchar] (255) DEFAULT ('') NOT NULL ,

+ [reason_description] [text] DEFAULT ('') NOT NULL ,

+ [reason_order] [int] DEFAULT (0) NOT NULL

+) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

+ Table: 'phpbb_search_results'

+ [search_key] [varchar] (32) DEFAULT ('') NOT NULL ,

+ [search_time] [int] DEFAULT (0) NOT NULL ,

+ [search_keywords] [text] DEFAULT ('') NOT NULL ,

+ [search_authors] [text] DEFAULT ('') NOT NULL

+ Table: 'phpbb_search_wordlist'

+ [word_text] [nvarchar] (252) DEFAULT ('') NOT NULL ,

+ [word_common] [int] DEFAULT (0) NOT NULL

+ [word_id]

+CREATE UNIQUE INDEX [wrd_txt] ON [phpbb_search_wordlist]([word_text]) ON [PRIMARY]

+ Table: 'phpbb_search_wordmatch'

+ [post_id] [int] DEFAULT (0) NOT NULL ,

+ [word_id] [int] DEFAULT (0) NOT NULL ,

+ [title_match] [int] DEFAULT (0) NOT NULL

+CREATE INDEX [word_id] ON [phpbb_search_wordmatch]([word_id]) ON [PRIMARY]

+CREATE INDEX [post_id] ON [phpbb_search_wordmatch]([post_id]) ON [PRIMARY]

+ Table: 'phpbb_sessions'

+ [session_id] [char] (32) DEFAULT ('') NOT NULL ,

+ [session_user_id] [int] DEFAULT (0) NOT NULL ,

+ [session_last_visit] [int] DEFAULT (0) NOT NULL ,

+ [session_start] [int] DEFAULT (0) NOT NULL ,

+ [session_time] [int] DEFAULT (0) NOT NULL ,

+ [session_ip] [varchar] (40) DEFAULT ('') NOT NULL ,

+ [session_browser] [varchar] (150) DEFAULT ('') NOT NULL ,

+ [session_page] [varchar] (255) DEFAULT ('') NOT NULL ,

+ [session_viewonline] [int] DEFAULT (1) NOT NULL ,

+ [session_autologin] [int] DEFAULT (0) NOT NULL ,

+ [session_admin] [int] DEFAULT (0) NOT NULL

+ Table: 'phpbb_sessions_keys'

+ [key_id] [char] (32) DEFAULT ('') NOT NULL ,

+ [user_id] [int] DEFAULT (0) NOT NULL ,

+ [last_ip] [varchar] (40) DEFAULT ('') NOT NULL ,

+ [last_login] [int] DEFAULT (0) NOT NULL

+ Table: 'phpbb_sitelist'

+ [site_ip] [varchar] (40) DEFAULT ('') NOT NULL ,

+ [site_hostname] [varchar] (255) DEFAULT ('') NOT NULL ,

+ [ip_exclude] [int] DEFAULT (0) NOT NULL

+ Table: 'phpbb_smilies'

+ [code] [varchar] (50) DEFAULT ('') NOT NULL ,

+ [emotion] [varchar] (50) DEFAULT ('') NOT NULL ,

+ [smiley_url] [varchar] (50) DEFAULT ('') NOT NULL ,

+ [smiley_width] [int] DEFAULT (0) NOT NULL ,

+ [smiley_height] [int] DEFAULT (0) NOT NULL ,

+ [smiley_order] [int] DEFAULT (0) NOT NULL ,

+ [display_on_posting] [int] DEFAULT (1) NOT NULL

+CREATE INDEX [display_on_post] ON [phpbb_smilies]([display_on_posting]) ON [PRIMARY]

+ Table: 'phpbb_styles'

+ [style_name] [varchar] (252) DEFAULT ('') NOT NULL ,

+ [style_copyright] [varchar] (255) DEFAULT ('') NOT NULL ,

+ [style_active] [int] DEFAULT (1) NOT NULL ,

+ [template_id] [int] DEFAULT (0) NOT NULL ,

+ [theme_id] [int] DEFAULT (0) NOT NULL ,

+ [imageset_id] [int] DEFAULT (0) NOT NULL

+ Table: 'phpbb_styles_template'

+ [template_name] [varchar] (252) DEFAULT ('') NOT NULL ,

+ [template_copyright] [varchar] (255) DEFAULT ('') NOT NULL ,

+ [template_path] [varchar] (100) DEFAULT ('') NOT NULL ,

+ [bbcode_bitfield] [varchar] (252) DEFAULT ('kNg=') NOT NULL ,

+ [template_storedb] [int] DEFAULT (0) NOT NULL

+CREATE UNIQUE INDEX [tmplte_nm] ON [phpbb_styles_template]([template_name]) ON [PRIMARY]

+ Table: 'phpbb_styles_template_data'

+ [template_id] [int] IDENTITY (1, 1) NOT NULL ,

+ [template_filename] [varchar] (100) DEFAULT ('') NOT NULL ,

+ [template_included] [varchar] (8000) DEFAULT ('') NOT NULL ,

+ [template_mtime] [int] DEFAULT (0) NOT NULL ,

+ [template_data] [text] DEFAULT ('') NOT NULL

+CREATE INDEX [tid] ON [phpbb_styles_template_data]([template_id]) ON [PRIMARY]

+CREATE INDEX [tfn] ON [phpbb_styles_template_data]([template_filename]) ON [PRIMARY]

+ Table: 'phpbb_styles_theme'

+ [theme_name] [varchar] (252) DEFAULT ('') NOT NULL ,

+ [theme_copyright] [varchar] (255) DEFAULT ('') NOT NULL ,

+ [theme_path] [varchar] (100) DEFAULT ('') NOT NULL ,

+ [theme_storedb] [int] DEFAULT (0) NOT NULL ,

+ [theme_mtime] [int] DEFAULT (0) NOT NULL ,

+ [theme_data] [text] DEFAULT ('') NOT NULL

+

+ Table: 'phpbb_styles_imageset'

+ [imageset_name] [varchar] (252) DEFAULT ('') NOT NULL ,

+ [imageset_copyright] [varchar] (255) DEFAULT ('') NOT NULL ,

+ [imageset_path] [varchar] (100) DEFAULT ('') NOT NULL ,

+ [site_logo] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [upload_bar] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [poll_left] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [poll_center] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [poll_right] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [icon_friend] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [icon_foe] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [forum_link] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [forum_read] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [forum_read_locked] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [forum_read_subforum] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [forum_unread] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [forum_unread_locked] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [forum_unread_subforum] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [topic_moved] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [topic_read] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [topic_read_mine] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [topic_read_hot] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [topic_read_hot_mine] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [topic_read_locked] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [topic_read_locked_mine] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [topic_unread] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [topic_unread_mine] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [topic_unread_hot] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [topic_unread_hot_mine] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [topic_unread_locked] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [topic_unread_locked_mine] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [sticky_read] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [sticky_read_mine] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [sticky_read_locked] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [sticky_read_locked_mine] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [sticky_unread] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [sticky_unread_mine] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [sticky_unread_locked] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [sticky_unread_locked_mine] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [announce_read] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [announce_read_mine] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [announce_read_locked] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [announce_read_locked_mine] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [announce_unread] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [announce_unread_mine] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [announce_unread_locked] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [announce_unread_locked_mine] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [global_read] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [global_read_mine] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [global_read_locked] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [global_read_locked_mine] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [global_unread] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [global_unread_mine] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [global_unread_locked] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [global_unread_locked_mine] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [pm_read] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [pm_unread] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [icon_contact_aim] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [icon_contact_email] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [icon_contact_icq] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [icon_contact_jabber] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [icon_contact_msnm] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [icon_contact_pm] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [icon_contact_yahoo] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [icon_contact_www] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [icon_post_delete] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [icon_post_edit] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [icon_post_info] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [icon_post_quote] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [icon_post_report] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [icon_post_target] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [icon_post_target_unread] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [icon_topic_attach] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [icon_topic_latest] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [icon_topic_newest] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [icon_topic_reported] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [icon_topic_unapproved] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [icon_user_online] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [icon_user_offline] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [icon_user_profile] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [icon_user_search] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [icon_user_warn] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [button_pm_forward] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [button_pm_new] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [button_pm_reply] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [button_topic_locked] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [button_topic_new] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [button_topic_reply] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [user_icon1] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [user_icon2] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [user_icon3] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [user_icon4] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [user_icon5] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [user_icon6] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [user_icon7] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [user_icon8] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [user_icon9] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [user_icon10] [varchar] (200) DEFAULT ('') NOT NULL

+CREATE UNIQUE INDEX [imgset_nm] ON [phpbb_styles_imageset]([imageset_name]) ON [PRIMARY]

+ Table: 'phpbb_topics'

+ [forum_id] [int] DEFAULT (0) NOT NULL ,

+ [icon_id] [int] DEFAULT (0) NOT NULL ,

+ [topic_attachment] [int] DEFAULT (0) NOT NULL ,

+ [topic_approved] [int] DEFAULT (1) NOT NULL ,

+ [topic_reported] [int] DEFAULT (0) NOT NULL ,

+ [topic_title] [varchar] (1000) DEFAULT ('') NOT NULL ,

+ [topic_poster] [int] DEFAULT (0) NOT NULL ,

+ [topic_time] [int] DEFAULT (0) NOT NULL ,

+ [topic_time_limit] [int] DEFAULT (0) NOT NULL ,

+ [topic_views] [int] DEFAULT (0) NOT NULL ,

+ [topic_replies] [int] DEFAULT (0) NOT NULL ,

+ [topic_replies_real] [int] DEFAULT (0) NOT NULL ,

+ [topic_status] [int] DEFAULT (0) NOT NULL ,

+ [topic_type] [int] DEFAULT (0) NOT NULL ,

+ [topic_first_post_id] [int] DEFAULT (0) NOT NULL ,

+ [topic_first_poster_name] [varchar] (255) DEFAULT ('') NOT NULL ,

+ [topic_last_post_id] [int] DEFAULT (0) NOT NULL ,

+ [topic_last_poster_id] [int] DEFAULT (0) NOT NULL ,

+ [topic_last_poster_name] [varchar] (255) DEFAULT ('') NOT NULL ,

+ [topic_last_post_time] [int] DEFAULT (0) NOT NULL ,

+ [topic_last_view_time] [int] DEFAULT (0) NOT NULL ,

+ [topic_moved_id] [int] DEFAULT (0) NOT NULL ,

+ [topic_bumped] [int] DEFAULT (0) NOT NULL ,

+ [topic_bumper] [int] DEFAULT (0) NOT NULL ,

+ [poll_title] [varchar] (1000) DEFAULT ('') NOT NULL ,

+ [poll_start] [int] DEFAULT (0) NOT NULL ,

+ [poll_length] [int] DEFAULT (0) NOT NULL ,

+ [poll_max_options] [int] DEFAULT (1) NOT NULL ,

+ [poll_last_vote] [int] DEFAULT (0) NOT NULL ,

+ [poll_vote_change] [int] DEFAULT (0) NOT NULL

+CREATE INDEX [last_post_time] ON [phpbb_topics]([topic_last_post_time]) ON [PRIMARY]

+GO

+

+CREATE INDEX [fid_time_moved] ON [phpbb_topics]([forum_id], [topic_last_post_time], [topic_moved_id]) ON [PRIMARY]

+ Table: 'phpbb_topics_track'

+ [user_id] [int] DEFAULT (0) NOT NULL ,

+ [topic_id] [int] DEFAULT (0) NOT NULL ,

+ [forum_id] [int] DEFAULT (0) NOT NULL ,

+ [mark_time] [int] DEFAULT (0) NOT NULL

+ Table: 'phpbb_topics_posted'

+ [user_id] [int] DEFAULT (0) NOT NULL ,

+ [topic_id] [int] DEFAULT (0) NOT NULL ,

+ [topic_posted] [int] DEFAULT (0) NOT NULL

+ Table: 'phpbb_topics_watch'

+ [topic_id] [int] DEFAULT (0) NOT NULL ,

+ [user_id] [int] DEFAULT (0) NOT NULL ,

+ [notify_status] [int] DEFAULT (0) NOT NULL

+CREATE INDEX [notify_stat] ON [phpbb_topics_watch]([notify_status]) ON [PRIMARY]

+ Table: 'phpbb_user_group'

+ [group_id] [int] DEFAULT (0) NOT NULL ,

+ [user_id] [int] DEFAULT (0) NOT NULL ,

+ [group_leader] [int] DEFAULT (0) NOT NULL ,

+ [user_pending] [int] DEFAULT (1) NOT NULL

+ Table: 'phpbb_users'

+ [user_type] [int] DEFAULT (0) NOT NULL ,

+ [group_id] [int] DEFAULT (3) NOT NULL ,

+ [user_permissions] [text] DEFAULT ('') NOT NULL ,

+ [user_perm_from] [int] DEFAULT (0) NOT NULL ,

+ [user_ip] [varchar] (40) DEFAULT ('') NOT NULL ,

+ [user_regdate] [int] DEFAULT (0) NOT NULL ,

+ [username] [varchar] (252) DEFAULT ('') NOT NULL ,

+ [user_password] [varchar] (40) DEFAULT ('') NOT NULL ,

+ [user_passchg] [int] DEFAULT (0) NOT NULL ,

+ [user_email] [varchar] (100) DEFAULT ('') NOT NULL ,

+ [user_email_hash] [float] DEFAULT (0) NOT NULL ,

+ [user_birthday] [varchar] (10) DEFAULT ('') NOT NULL ,

+ [user_lastvisit] [int] DEFAULT (0) NOT NULL ,

+ [user_lastmark] [int] DEFAULT (0) NOT NULL ,

+ [user_lastpost_time] [int] DEFAULT (0) NOT NULL ,

+ [user_lastpage] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [user_last_confirm_key] [varchar] (10) DEFAULT ('') NOT NULL ,

+ [user_last_search] [int] DEFAULT (0) NOT NULL ,

+ [user_warnings] [int] DEFAULT (0) NOT NULL ,

+ [user_last_warning] [int] DEFAULT (0) NOT NULL ,

+ [user_login_attempts] [int] DEFAULT (0) NOT NULL ,

+ [user_posts] [int] DEFAULT (0) NOT NULL ,

+ [user_lang] [varchar] (30) DEFAULT ('') NOT NULL ,

+ [user_timezone] [float] DEFAULT (0) NOT NULL ,

+ [user_dst] [int] DEFAULT (0) NOT NULL ,

+ [user_dateformat] [varchar] (30) DEFAULT ('d M Y H:i') NOT NULL ,

+ [user_style] [int] DEFAULT (0) NOT NULL ,

+ [user_rank] [int] DEFAULT (0) NOT NULL ,

+ [user_colour] [varchar] (6) DEFAULT ('') NOT NULL ,

+ [user_new_privmsg] [int] DEFAULT (0) NOT NULL ,

+ [user_unread_privmsg] [int] DEFAULT (0) NOT NULL ,

+ [user_last_privmsg] [int] DEFAULT (0) NOT NULL ,

+ [user_message_rules] [int] DEFAULT (0) NOT NULL ,

+ [user_full_folder] [int] DEFAULT (-3) NOT NULL ,

+ [user_emailtime] [int] DEFAULT (0) NOT NULL ,

+ [user_topic_show_days] [int] DEFAULT (0) NOT NULL ,

+ [user_topic_sortby_type] [varchar] (1) DEFAULT ('t') NOT NULL ,

+ [user_topic_sortby_dir] [varchar] (1) DEFAULT ('d') NOT NULL ,

+ [user_post_show_days] [int] DEFAULT (0) NOT NULL ,

+ [user_post_sortby_type] [varchar] (1) DEFAULT ('t') NOT NULL ,

+ [user_post_sortby_dir] [varchar] (1) DEFAULT ('a') NOT NULL ,

+ [user_notify] [int] DEFAULT (0) NOT NULL ,

+ [user_notify_pm] [int] DEFAULT (1) NOT NULL ,

+ [user_notify_type] [int] DEFAULT (0) NOT NULL ,

+ [user_allow_pm] [int] DEFAULT (1) NOT NULL ,

+ [user_allow_email] [int] DEFAULT (1) NOT NULL ,

+ [user_allow_viewonline] [int] DEFAULT (1) NOT NULL ,

+ [user_allow_viewemail] [int] DEFAULT (1) NOT NULL ,

+ [user_allow_massemail] [int] DEFAULT (1) NOT NULL ,

+ [user_options] [int] DEFAULT (893) NOT NULL ,

+ [user_avatar] [varchar] (255) DEFAULT ('') NOT NULL ,

+ [user_avatar_type] [int] DEFAULT (0) NOT NULL ,

+ [user_avatar_width] [int] DEFAULT (0) NOT NULL ,

+ [user_avatar_height] [int] DEFAULT (0) NOT NULL ,

+ [user_sig] [text] DEFAULT ('') NOT NULL ,

+ [user_sig_bbcode_uid] [varchar] (5) DEFAULT ('') NOT NULL ,

+ [user_sig_bbcode_bitfield] [varchar] (252) DEFAULT ('') NOT NULL ,

+ [user_from] [varchar] (100) DEFAULT ('') NOT NULL ,

+ [user_icq] [varchar] (15) DEFAULT ('') NOT NULL ,

+ [user_aim] [varchar] (255) DEFAULT ('') NOT NULL ,

+ [user_yim] [varchar] (255) DEFAULT ('') NOT NULL ,

+ [user_msnm] [varchar] (255) DEFAULT ('') NOT NULL ,

+ [user_jabber] [varchar] (255) DEFAULT ('') NOT NULL ,

+ [user_website] [varchar] (200) DEFAULT ('') NOT NULL ,

+ [user_occ] [varchar] (255) DEFAULT ('') NOT NULL ,

+ [user_interests] [varchar] (8000) DEFAULT ('') NOT NULL ,

+ [user_actkey] [varchar] (32) DEFAULT ('') NOT NULL ,

+ [user_newpasswd] [varchar] (32) DEFAULT ('') NOT NULL

+CREATE INDEX [user_type] ON [phpbb_users]([user_type]) ON [PRIMARY]

+GO

+

+ Table: 'phpbb_warnings'

+ [user_id] [int] DEFAULT (0) NOT NULL ,

+ [post_id] [int] DEFAULT (0) NOT NULL ,

+ [log_id] [int] DEFAULT (0) NOT NULL ,

+ [warning_time] [int] DEFAULT (0) NOT NULL

+ Table: 'phpbb_words'

+ [word] [varchar] (255) DEFAULT ('') NOT NULL ,

+ [replacement] [varchar] (255) DEFAULT ('') NOT NULL

+ Table: 'phpbb_zebra'

+ [user_id] [int] DEFAULT (0) NOT NULL ,

+ [zebra_id] [int] DEFAULT (0) NOT NULL ,

+ [friend] [int] DEFAULT (0) NOT NULL ,

+ [foe] [int] DEFAULT (0) NOT NULL

+

+

+ attach_id mediumint(8) UNSIGNED NOT NULL auto_increment,

+ post_msg_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ in_message tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

+ poster_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ physical_filename varchar(255) DEFAULT '' NOT NULL,

+ real_filename varchar(255) DEFAULT '' NOT NULL,

+ download_count mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ attach_comment text DEFAULT '' NOT NULL,

+ extension varchar(100) DEFAULT '' NOT NULL,

+ mimetype varchar(100) DEFAULT '' NOT NULL,

+ filesize int(20) UNSIGNED DEFAULT '0' NOT NULL,

+ filetime int(11) UNSIGNED DEFAULT '0' NOT NULL,

+ thumbnail tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

+ PRIMARY KEY (attach_id),

+ KEY filetime (filetime),

+ KEY post_msg_id (post_msg_id),

+ KEY topic_id (topic_id),

+ KEY poster_id (poster_id),

+ KEY filesize (filesize)

+

+ group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ auth_option_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ auth_role_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ auth_setting tinyint(2) DEFAULT '0' NOT NULL,

+ KEY group_id (group_id),

+ KEY auth_opt_id (auth_option_id)

+

+ auth_option_id mediumint(8) UNSIGNED NOT NULL auto_increment,

+ auth_option varchar(50) DEFAULT '' NOT NULL,

+ is_global tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

+ is_local tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

+ founder_only tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

+ PRIMARY KEY (auth_option_id),

+ KEY auth_option (auth_option)

+

+ role_id mediumint(8) UNSIGNED NOT NULL auto_increment,

+ role_name varchar(255) DEFAULT '' NOT NULL,

+ role_description text DEFAULT '' NOT NULL,

+ role_type varchar(10) DEFAULT '' NOT NULL,

+ role_order smallint(4) UNSIGNED DEFAULT '0' NOT NULL,

+ PRIMARY KEY (role_id),

+ KEY role_type (role_type),

+ KEY role_order (role_order)

+

+ role_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ auth_option_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ auth_setting tinyint(2) DEFAULT '0' NOT NULL,

+ PRIMARY KEY (role_id, auth_option_id)

+

+ user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ auth_option_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ auth_role_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ auth_setting tinyint(2) DEFAULT '0' NOT NULL,

+ KEY user_id (user_id),

+ KEY auth_option_id (auth_option_id)

+

+ ban_id mediumint(8) UNSIGNED NOT NULL auto_increment,

+ ban_userid mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ ban_ip varchar(40) DEFAULT '' NOT NULL,

+ ban_email varchar(100) DEFAULT '' NOT NULL,

+ ban_start int(11) UNSIGNED DEFAULT '0' NOT NULL,

+ ban_end int(11) UNSIGNED DEFAULT '0' NOT NULL,

+ ban_exclude tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

+ ban_reason text DEFAULT '' NOT NULL,

+ ban_give_reason text DEFAULT '' NOT NULL,

+ PRIMARY KEY (ban_id),

+ KEY ban_end (ban_end),

+ KEY ban_user (ban_userid, ban_exclude),

+ KEY ban_email (ban_email, ban_exclude),

+ KEY ban_ip (ban_ip, ban_exclude)

+

+ bbcode_id tinyint(3) DEFAULT '0' NOT NULL,

+ bbcode_tag varchar(16) DEFAULT '' NOT NULL,

+ bbcode_helpline varchar(255) DEFAULT '' NOT NULL,

+ display_on_posting tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

+ bbcode_match text DEFAULT '' NOT NULL,

+ bbcode_tpl mediumtext DEFAULT '' NOT NULL,

+ first_pass_match mediumtext DEFAULT '' NOT NULL,

+ first_pass_replace mediumtext DEFAULT '' NOT NULL,

+ second_pass_match mediumtext DEFAULT '' NOT NULL,

+ second_pass_replace mediumtext DEFAULT '' NOT NULL,

+ PRIMARY KEY (bbcode_id),

+ KEY display_on_post (display_on_posting)

+

+ topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ order_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ KEY order_id (order_id),

+ KEY topic_user_id (topic_id, user_id)

+

+ bot_id mediumint(8) UNSIGNED NOT NULL auto_increment,

+ bot_active tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,

+ bot_name text DEFAULT '' NOT NULL,

+ user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ bot_agent varchar(255) DEFAULT '' NOT NULL,

+ bot_ip varchar(255) DEFAULT '' NOT NULL,

+ PRIMARY KEY (bot_id),

+ KEY bot_active (bot_active)

+

+ config_name varchar(252) DEFAULT '' NOT NULL,

+ config_value varchar(255) DEFAULT '' NOT NULL,

+ is_dynamic tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

+ PRIMARY KEY (config_name),

+ KEY is_dynamic (is_dynamic)

+

+ confirm_id char(32) DEFAULT '' NOT NULL,

+ session_id char(32) DEFAULT '' NOT NULL,

+ confirm_type tinyint(3) DEFAULT '0' NOT NULL,

+ code varchar(8) DEFAULT '' NOT NULL,

+ PRIMARY KEY (session_id, confirm_id),

+ KEY confirm_type (confirm_type)

+

+ disallow_id mediumint(8) UNSIGNED NOT NULL auto_increment,

+ disallow_username varchar(252) DEFAULT '' NOT NULL,

+ PRIMARY KEY (disallow_id)

+

+ draft_id mediumint(8) UNSIGNED NOT NULL auto_increment,

+ user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ save_time int(11) UNSIGNED DEFAULT '0' NOT NULL,

+ draft_subject text DEFAULT '' NOT NULL,

+ draft_message mediumtext DEFAULT '' NOT NULL,

+ PRIMARY KEY (draft_id),

+ KEY save_time (save_time)

+

+ extension_id mediumint(8) UNSIGNED NOT NULL auto_increment,

+ group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ extension varchar(100) DEFAULT '' NOT NULL,

+ PRIMARY KEY (extension_id)

+

+ group_id mediumint(8) UNSIGNED NOT NULL auto_increment,

+ group_name varchar(255) DEFAULT '' NOT NULL,

+ cat_id tinyint(2) DEFAULT '0' NOT NULL,

+ allow_group tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

+ download_mode tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,

+ upload_icon varchar(255) DEFAULT '' NOT NULL,

+ max_filesize int(20) UNSIGNED DEFAULT '0' NOT NULL,

+ allowed_forums text DEFAULT '' NOT NULL,

+ allow_in_pm tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

+ PRIMARY KEY (group_id)

+

+ forum_id mediumint(8) UNSIGNED NOT NULL auto_increment,

+ parent_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ left_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ right_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ forum_parents mediumtext DEFAULT '' NOT NULL,

+ forum_name text DEFAULT '' NOT NULL,

+ forum_desc text DEFAULT '' NOT NULL,

+ forum_desc_bitfield varchar(252) DEFAULT '' NOT NULL,

+ forum_desc_options int(11) UNSIGNED DEFAULT '0' NOT NULL,

+ forum_desc_uid varchar(5) DEFAULT '' NOT NULL,

+ forum_link varchar(255) DEFAULT '' NOT NULL,

+ forum_password varchar(40) DEFAULT '' NOT NULL,

+ forum_style tinyint(4) DEFAULT '0' NOT NULL,

+ forum_image varchar(255) DEFAULT '' NOT NULL,

+ forum_rules text DEFAULT '' NOT NULL,

+ forum_rules_link varchar(255) DEFAULT '' NOT NULL,

+ forum_rules_bitfield varchar(252) DEFAULT '' NOT NULL,

+ forum_rules_options int(11) UNSIGNED DEFAULT '0' NOT NULL,

+ forum_rules_uid varchar(5) DEFAULT '' NOT NULL,

+ forum_topics_per_page tinyint(4) DEFAULT '0' NOT NULL,

+ forum_type tinyint(4) DEFAULT '0' NOT NULL,

+ forum_status tinyint(4) DEFAULT '0' NOT NULL,

+ forum_posts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ forum_topics mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ forum_topics_real mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ forum_last_post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ forum_last_poster_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ forum_last_post_time int(11) UNSIGNED DEFAULT '0' NOT NULL,

+ forum_last_poster_name varchar(255) DEFAULT '' NOT NULL,

+ forum_flags tinyint(4) DEFAULT '32' NOT NULL,

+ display_on_index tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,

+ enable_indexing tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,

+ enable_icons tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,

+ enable_prune tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

+ prune_next int(11) UNSIGNED DEFAULT '0' NOT NULL,

+ prune_days tinyint(4) DEFAULT '0' NOT NULL,

+ prune_viewed tinyint(4) DEFAULT '0' NOT NULL,

+ prune_freq tinyint(4) DEFAULT '0' NOT NULL,

+ PRIMARY KEY (forum_id),

+ KEY left_right_id (left_id, right_id),

+ KEY forum_lastpost_id (forum_last_post_id)

+

+ forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ session_id char(32) DEFAULT '' NOT NULL,

+ PRIMARY KEY (forum_id, user_id, session_id)

+

+ user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ mark_time int(11) UNSIGNED DEFAULT '0' NOT NULL,

+ PRIMARY KEY (user_id, forum_id)

+

+ forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ notify_status tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

+ KEY forum_id (forum_id),

+ KEY user_id (user_id),

+ KEY notify_stat (notify_status)

+

+ group_id mediumint(8) UNSIGNED NOT NULL auto_increment,

+ group_type tinyint(4) DEFAULT '1' NOT NULL,

+ group_name varchar(252) DEFAULT '' NOT NULL,

+ group_desc text DEFAULT '' NOT NULL,

+ group_desc_bitfield varchar(252) DEFAULT '' NOT NULL,

+ group_desc_options int(11) UNSIGNED DEFAULT '0' NOT NULL,

+ group_desc_uid varchar(5) DEFAULT '' NOT NULL,

+ group_display tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

+ group_avatar varchar(255) DEFAULT '' NOT NULL,

+ group_avatar_type tinyint(4) DEFAULT '0' NOT NULL,

+ group_avatar_width tinyint(4) DEFAULT '0' NOT NULL,

+ group_avatar_height tinyint(4) DEFAULT '0' NOT NULL,

+ group_rank mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ group_colour varchar(6) DEFAULT '' NOT NULL,

+ group_sig_chars mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ group_receive_pm tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

+ group_message_limit mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ group_legend tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,

+ PRIMARY KEY (group_id),

+ KEY group_legend (group_legend)

+

+ icons_id mediumint(8) UNSIGNED NOT NULL auto_increment,

+ icons_url varchar(255) DEFAULT '' NOT NULL,

+ icons_width tinyint(4) DEFAULT '0' NOT NULL,

+ icons_height tinyint(4) DEFAULT '0' NOT NULL,

+ icons_order mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ display_on_posting tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,

+ PRIMARY KEY (icons_id),

+ KEY display_on_posting (display_on_posting)

+

+ lang_id tinyint(4) NOT NULL auto_increment,

+ lang_iso varchar(30) DEFAULT '' NOT NULL,

+ lang_dir varchar(30) DEFAULT '' NOT NULL,

+ lang_english_name varchar(100) DEFAULT '' NOT NULL,

+ lang_local_name varchar(255) DEFAULT '' NOT NULL,

+ lang_author varchar(255) DEFAULT '' NOT NULL,

+ PRIMARY KEY (lang_id),

+ KEY lang_iso (lang_iso)

+

+ log_id mediumint(8) UNSIGNED NOT NULL auto_increment,

+ log_type tinyint(4) DEFAULT '0' NOT NULL,

+ user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ reportee_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ log_ip varchar(40) DEFAULT '' NOT NULL,

+ log_time int(11) UNSIGNED DEFAULT '0' NOT NULL,

+ log_operation text DEFAULT '' NOT NULL,

+ log_data mediumtext DEFAULT '' NOT NULL,

+ PRIMARY KEY (log_id),

+ KEY log_type (log_type),

+ KEY forum_id (forum_id),

+ KEY topic_id (topic_id),

+ KEY reportee_id (reportee_id),

+ KEY user_id (user_id)

+

+ forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ username varchar(252) DEFAULT '' NOT NULL,

+ group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ group_name varchar(255) DEFAULT '' NOT NULL,

+ display_on_index tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,

+ KEY disp_idx (display_on_index),

+ KEY forum_id (forum_id)

+

+ module_id mediumint(8) UNSIGNED NOT NULL auto_increment,

+ module_enabled tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,

+ module_display tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,

+ module_basename varchar(255) DEFAULT '' NOT NULL,

+ module_class varchar(10) DEFAULT '' NOT NULL,

+ parent_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ left_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ right_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ module_langname varchar(255) DEFAULT '' NOT NULL,

+ module_mode varchar(255) DEFAULT '' NOT NULL,

+ module_auth varchar(255) DEFAULT '' NOT NULL,

+ PRIMARY KEY (module_id),

+ KEY left_right_id (left_id, right_id),

+ KEY module_enabled (module_enabled),

+ KEY class_left_id (module_class, left_id)

+

+ poll_option_id tinyint(4) DEFAULT '0' NOT NULL,

+ topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ poll_option_text text DEFAULT '' NOT NULL,

+ poll_option_total mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ KEY poll_opt_id (poll_option_id),

+ KEY topic_id (topic_id)

+

+ topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ poll_option_id tinyint(4) DEFAULT '0' NOT NULL,

+ vote_user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ vote_user_ip varchar(40) DEFAULT '' NOT NULL,

+ KEY topic_id (topic_id),

+ KEY vote_user_id (vote_user_id),

+ KEY vote_user_ip (vote_user_ip)

+

+ post_id mediumint(8) UNSIGNED NOT NULL auto_increment,

+ topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ poster_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ icon_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ poster_ip varchar(40) DEFAULT '' NOT NULL,

+ post_time int(11) UNSIGNED DEFAULT '0' NOT NULL,

+ post_approved tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,

+ post_reported tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

+ enable_bbcode tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,

+ enable_smilies tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,

+ enable_magic_url tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,

+ enable_sig tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,

+ post_username varchar(252) DEFAULT '' NOT NULL,

+ post_subject text DEFAULT '' NOT NULL,

+ post_text mediumtext DEFAULT '' NOT NULL,

+ post_checksum varchar(32) DEFAULT '' NOT NULL,

+ post_encoding varchar(20) DEFAULT 'iso-8859-1' NOT NULL,

+ post_attachment tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

+ bbcode_bitfield varchar(252) DEFAULT '' NOT NULL,

+ bbcode_uid varchar(5) DEFAULT '' NOT NULL,

+ post_postcount tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,

+ post_edit_time int(11) UNSIGNED DEFAULT '0' NOT NULL,

+ post_edit_reason text DEFAULT '' NOT NULL,

+ post_edit_user mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ post_edit_count smallint(4) UNSIGNED DEFAULT '0' NOT NULL,

+ post_edit_locked tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

+ PRIMARY KEY (post_id),

+ KEY forum_id (forum_id),

+ KEY topic_id (topic_id),

+ KEY poster_ip (poster_ip),

+ KEY poster_id (poster_id),

+ KEY post_approved (post_approved),

+ KEY post_postcount (post_postcount),

+ KEY post_time (post_time)

+

+ msg_id mediumint(8) UNSIGNED NOT NULL auto_increment,

+ root_level mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ author_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ icon_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ author_ip varchar(40) DEFAULT '' NOT NULL,

+ message_time int(11) UNSIGNED DEFAULT '0' NOT NULL,

+ enable_bbcode tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,

+ enable_smilies tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,

+ enable_magic_url tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,

+ enable_sig tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,

+ message_subject text DEFAULT '' NOT NULL,

+ message_text mediumtext DEFAULT '' NOT NULL,

+ message_edit_reason text DEFAULT '' NOT NULL,

+ message_edit_user mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ message_encoding varchar(20) DEFAULT 'iso-8859-1' NOT NULL,

+ message_attachment tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

+ bbcode_bitfield varchar(252) DEFAULT '' NOT NULL,

+ bbcode_uid varchar(5) DEFAULT '' NOT NULL,

+ message_edit_time int(11) UNSIGNED DEFAULT '0' NOT NULL,

+ message_edit_count smallint(4) UNSIGNED DEFAULT '0' NOT NULL,

+ to_address text DEFAULT '' NOT NULL,

+ bcc_address text DEFAULT '' NOT NULL,

+ PRIMARY KEY (msg_id),

+ KEY author_ip (author_ip),

+ KEY message_time (message_time),

+ KEY author_id (author_id),

+ KEY root_level (root_level)

+

+ folder_id mediumint(8) UNSIGNED NOT NULL auto_increment,

+ user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ folder_name varchar(255) DEFAULT '' NOT NULL,

+ pm_count mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ PRIMARY KEY (folder_id),

+ KEY user_id (user_id)

+

+ rule_id mediumint(8) UNSIGNED NOT NULL auto_increment,

+ user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ rule_check mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ rule_connection mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ rule_string varchar(255) DEFAULT '' NOT NULL,

+ rule_user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ rule_group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ rule_action mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ rule_folder_id int(4) DEFAULT '0' NOT NULL,

+ PRIMARY KEY (rule_id),

+ KEY user_id (user_id)

+

+ msg_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ author_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ pm_deleted tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

+ pm_new tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,

+ pm_unread tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,

+ pm_replied tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

+ pm_marked tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

+ pm_forwarded tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

+ folder_id int(4) DEFAULT '0' NOT NULL,

+ KEY msg_id (msg_id),

+ KEY author_id (author_id),

+ KEY usr_flder_id (user_id, folder_id)

+

+ field_id mediumint(8) UNSIGNED NOT NULL auto_increment,

+ field_name varchar(255) DEFAULT '' NOT NULL,

+ field_type tinyint(4) DEFAULT '0' NOT NULL,

+ field_ident varchar(20) DEFAULT '' NOT NULL,

+ field_length varchar(20) DEFAULT '' NOT NULL,

+ field_minlen varchar(255) DEFAULT '' NOT NULL,

+ field_maxlen varchar(255) DEFAULT '' NOT NULL,

+ field_novalue varchar(255) DEFAULT '' NOT NULL,

+ field_default_value varchar(255) DEFAULT '' NOT NULL,

+ field_validation varchar(20) DEFAULT '' NOT NULL,

+ field_required tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

+ field_show_on_reg tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

+ field_hide tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

+ field_no_view tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

+ field_active tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

+ field_order mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ PRIMARY KEY (field_id),

+ KEY fld_type (field_type),

+ KEY fld_ordr (field_order)

+

+ user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ PRIMARY KEY (user_id)

+

+ field_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ lang_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ option_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ field_type tinyint(4) DEFAULT '0' NOT NULL,

+ lang_value varchar(255) DEFAULT '' NOT NULL,

+ PRIMARY KEY (field_id, lang_id, option_id)

+

+ field_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ lang_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ lang_name varchar(255) DEFAULT '' NOT NULL,

+ lang_explain text DEFAULT '' NOT NULL,

+ lang_default_value varchar(255) DEFAULT '' NOT NULL,

+ PRIMARY KEY (field_id, lang_id)

+

+ rank_id mediumint(8) UNSIGNED NOT NULL auto_increment,

+ rank_title varchar(255) DEFAULT '' NOT NULL,

+ rank_min mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ rank_special tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

+ rank_image varchar(255) DEFAULT '' NOT NULL,

+ PRIMARY KEY (rank_id)

+

+ report_id mediumint(8) UNSIGNED NOT NULL auto_increment,

+ reason_id smallint(4) UNSIGNED DEFAULT '0' NOT NULL,

+ post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ user_notify tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

+ report_closed tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

+ report_time int(11) UNSIGNED DEFAULT '0' NOT NULL,

+ report_text mediumtext DEFAULT '' NOT NULL,

+ PRIMARY KEY (report_id)

+

+ reason_id smallint(4) UNSIGNED NOT NULL auto_increment,

+ reason_title varchar(255) DEFAULT '' NOT NULL,

+ reason_description mediumtext DEFAULT '' NOT NULL,

+ reason_order smallint(4) UNSIGNED DEFAULT '0' NOT NULL,

+ PRIMARY KEY (reason_id)

+

+ search_key varchar(32) DEFAULT '' NOT NULL,

+ search_time int(11) UNSIGNED DEFAULT '0' NOT NULL,

+ search_keywords mediumtext DEFAULT '' NOT NULL,

+ search_authors mediumtext DEFAULT '' NOT NULL,

+ PRIMARY KEY (search_key)

+

+ word_id mediumint(8) UNSIGNED NOT NULL auto_increment,

+ word_text varchar(252) /*!40101 CHARACTER SET utf8 */ BINARY DEFAULT '' NOT NULL,

+ word_common tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

+ PRIMARY KEY (word_id),

+ UNIQUE wrd_txt (word_text)

+

+ post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ word_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ title_match tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

+ KEY word_id (word_id),

+ KEY post_id (post_id)

+

+ session_id char(32) DEFAULT '' NOT NULL,

+ session_user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ session_last_visit int(11) UNSIGNED DEFAULT '0' NOT NULL,

+ session_start int(11) UNSIGNED DEFAULT '0' NOT NULL,

+ session_time int(11) UNSIGNED DEFAULT '0' NOT NULL,

+ session_ip varchar(40) DEFAULT '' NOT NULL,

+ session_browser varchar(150) DEFAULT '' NOT NULL,

+ session_page varchar(255) DEFAULT '' NOT NULL,

+ session_viewonline tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,

+ session_autologin tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

+ session_admin tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

+ PRIMARY KEY (session_id),

+ KEY session_time (session_time),

+ KEY session_user_id (session_user_id)

+

+ key_id char(32) DEFAULT '' NOT NULL,

+ user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ last_ip varchar(40) DEFAULT '' NOT NULL,

+ last_login int(11) UNSIGNED DEFAULT '0' NOT NULL,

+ PRIMARY KEY (key_id, user_id),

+ KEY last_login (last_login)

+

+ site_id mediumint(8) UNSIGNED NOT NULL auto_increment,

+ site_ip varchar(40) DEFAULT '' NOT NULL,

+ site_hostname varchar(255) DEFAULT '' NOT NULL,

+ ip_exclude tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

+ PRIMARY KEY (site_id)

+

+ smiley_id mediumint(8) UNSIGNED NOT NULL auto_increment,

+ code varchar(50) DEFAULT '' NOT NULL,

+ emotion varchar(50) DEFAULT '' NOT NULL,

+ smiley_url varchar(50) DEFAULT '' NOT NULL,

+ smiley_width tinyint(4) DEFAULT '0' NOT NULL,

+ smiley_height tinyint(4) DEFAULT '0' NOT NULL,

+ smiley_order mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ display_on_posting tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,

+ PRIMARY KEY (smiley_id),

+ KEY display_on_post (display_on_posting)

+

+ style_id tinyint(4) NOT NULL auto_increment,

+ style_name varchar(252) DEFAULT '' NOT NULL,

+ style_copyright varchar(255) DEFAULT '' NOT NULL,

+ style_active tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,

+ template_id tinyint(4) DEFAULT '0' NOT NULL,

+ theme_id tinyint(4) DEFAULT '0' NOT NULL,

+ imageset_id tinyint(4) DEFAULT '0' NOT NULL,

+ PRIMARY KEY (style_id),

+ UNIQUE style_name (style_name),

+ KEY template_id (template_id),

+ KEY theme_id (theme_id),

+ KEY imageset_id (imageset_id)

+

+ template_id tinyint(4) NOT NULL auto_increment,

+ template_name varchar(252) DEFAULT '' NOT NULL,

+ template_copyright varchar(255) DEFAULT '' NOT NULL,

+ template_path varchar(100) DEFAULT '' NOT NULL,

+ bbcode_bitfield varchar(252) DEFAULT 'kNg=' NOT NULL,

+ template_storedb tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

+ PRIMARY KEY (template_id),

+ UNIQUE tmplte_nm (template_name)

+

+ template_id tinyint(4) NOT NULL auto_increment,

+ template_filename varchar(100) DEFAULT '' NOT NULL,

+ template_included text DEFAULT '' NOT NULL,

+ template_mtime int(11) UNSIGNED DEFAULT '0' NOT NULL,

+ template_data mediumtext DEFAULT '' NOT NULL,

+ KEY tid (template_id),

+ KEY tfn (template_filename)

+

+ theme_id tinyint(4) NOT NULL auto_increment,

+ theme_name varchar(252) DEFAULT '' NOT NULL,

+ theme_copyright varchar(255) DEFAULT '' NOT NULL,

+ theme_path varchar(100) DEFAULT '' NOT NULL,

+ theme_storedb tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

+ theme_mtime int(11) UNSIGNED DEFAULT '0' NOT NULL,

+ theme_data mediumtext DEFAULT '' NOT NULL,

+ PRIMARY KEY (theme_id),

+ UNIQUE theme_name (theme_name)

+

+ imageset_id tinyint(4) NOT NULL auto_increment,

+ imageset_name varchar(252) DEFAULT '' NOT NULL,

+ imageset_copyright varchar(255) DEFAULT '' NOT NULL,

+ imageset_path varchar(100) DEFAULT '' NOT NULL,

+ site_logo varchar(200) DEFAULT '' NOT NULL,

+ upload_bar varchar(200) DEFAULT '' NOT NULL,

+ poll_left varchar(200) DEFAULT '' NOT NULL,

+ poll_center varchar(200) DEFAULT '' NOT NULL,

+ poll_right varchar(200) DEFAULT '' NOT NULL,

+ icon_friend varchar(200) DEFAULT '' NOT NULL,

+ icon_foe varchar(200) DEFAULT '' NOT NULL,

+ forum_link varchar(200) DEFAULT '' NOT NULL,

+ forum_read varchar(200) DEFAULT '' NOT NULL,

+ forum_read_locked varchar(200) DEFAULT '' NOT NULL,

+ forum_read_subforum varchar(200) DEFAULT '' NOT NULL,

+ forum_unread varchar(200) DEFAULT '' NOT NULL,

+ forum_unread_locked varchar(200) DEFAULT '' NOT NULL,

+ forum_unread_subforum varchar(200) DEFAULT '' NOT NULL,

+ topic_moved varchar(200) DEFAULT '' NOT NULL,

+ topic_read varchar(200) DEFAULT '' NOT NULL,

+ topic_read_mine varchar(200) DEFAULT '' NOT NULL,

+ topic_read_hot varchar(200) DEFAULT '' NOT NULL,

+ topic_read_hot_mine varchar(200) DEFAULT '' NOT NULL,

+ topic_read_locked varchar(200) DEFAULT '' NOT NULL,

+ topic_read_locked_mine varchar(200) DEFAULT '' NOT NULL,

+ topic_unread varchar(200) DEFAULT '' NOT NULL,

+ topic_unread_mine varchar(200) DEFAULT '' NOT NULL,

+ topic_unread_hot varchar(200) DEFAULT '' NOT NULL,

+ topic_unread_hot_mine varchar(200) DEFAULT '' NOT NULL,

+ topic_unread_locked varchar(200) DEFAULT '' NOT NULL,

+ topic_unread_locked_mine varchar(200) DEFAULT '' NOT NULL,

+ sticky_read varchar(200) DEFAULT '' NOT NULL,

+ sticky_read_mine varchar(200) DEFAULT '' NOT NULL,

+ sticky_read_locked varchar(200) DEFAULT '' NOT NULL,

+ sticky_read_locked_mine varchar(200) DEFAULT '' NOT NULL,

+ sticky_unread varchar(200) DEFAULT '' NOT NULL,

+ sticky_unread_mine varchar(200) DEFAULT '' NOT NULL,

+ sticky_unread_locked varchar(200) DEFAULT '' NOT NULL,

+ sticky_unread_locked_mine varchar(200) DEFAULT '' NOT NULL,

+ announce_read varchar(200) DEFAULT '' NOT NULL,

+ announce_read_mine varchar(200) DEFAULT '' NOT NULL,

+ announce_read_locked varchar(200) DEFAULT '' NOT NULL,

+ announce_read_locked_mine varchar(200) DEFAULT '' NOT NULL,

+ announce_unread varchar(200) DEFAULT '' NOT NULL,

+ announce_unread_mine varchar(200) DEFAULT '' NOT NULL,

+ announce_unread_locked varchar(200) DEFAULT '' NOT NULL,

+ announce_unread_locked_mine varchar(200) DEFAULT '' NOT NULL,

+ global_read varchar(200) DEFAULT '' NOT NULL,

+ global_read_mine varchar(200) DEFAULT '' NOT NULL,

+ global_read_locked varchar(200) DEFAULT '' NOT NULL,

+ global_read_locked_mine varchar(200) DEFAULT '' NOT NULL,

+ global_unread varchar(200) DEFAULT '' NOT NULL,

+ global_unread_mine varchar(200) DEFAULT '' NOT NULL,

+ global_unread_locked varchar(200) DEFAULT '' NOT NULL,

+ global_unread_locked_mine varchar(200) DEFAULT '' NOT NULL,

+ pm_read varchar(200) DEFAULT '' NOT NULL,

+ pm_unread varchar(200) DEFAULT '' NOT NULL,

+ icon_contact_aim varchar(200) DEFAULT '' NOT NULL,

+ icon_contact_email varchar(200) DEFAULT '' NOT NULL,

+ icon_contact_icq varchar(200) DEFAULT '' NOT NULL,

+ icon_contact_jabber varchar(200) DEFAULT '' NOT NULL,

+ icon_contact_msnm varchar(200) DEFAULT '' NOT NULL,

+ icon_contact_pm varchar(200) DEFAULT '' NOT NULL,

+ icon_contact_yahoo varchar(200) DEFAULT '' NOT NULL,

+ icon_contact_www varchar(200) DEFAULT '' NOT NULL,

+ icon_post_delete varchar(200) DEFAULT '' NOT NULL,

+ icon_post_edit varchar(200) DEFAULT '' NOT NULL,

+ icon_post_info varchar(200) DEFAULT '' NOT NULL,

+ icon_post_quote varchar(200) DEFAULT '' NOT NULL,

+ icon_post_report varchar(200) DEFAULT '' NOT NULL,

+ icon_post_target varchar(200) DEFAULT '' NOT NULL,

+ icon_post_target_unread varchar(200) DEFAULT '' NOT NULL,

+ icon_topic_attach varchar(200) DEFAULT '' NOT NULL,

+ icon_topic_latest varchar(200) DEFAULT '' NOT NULL,

+ icon_topic_newest varchar(200) DEFAULT '' NOT NULL,

+ icon_topic_reported varchar(200) DEFAULT '' NOT NULL,

+ icon_topic_unapproved varchar(200) DEFAULT '' NOT NULL,

+ icon_user_online varchar(200) DEFAULT '' NOT NULL,

+ icon_user_offline varchar(200) DEFAULT '' NOT NULL,

+ icon_user_profile varchar(200) DEFAULT '' NOT NULL,

+ icon_user_search varchar(200) DEFAULT '' NOT NULL,

+ icon_user_warn varchar(200) DEFAULT '' NOT NULL,

+ button_pm_forward varchar(200) DEFAULT '' NOT NULL,

+ button_pm_new varchar(200) DEFAULT '' NOT NULL,

+ button_pm_reply varchar(200) DEFAULT '' NOT NULL,

+ button_topic_locked varchar(200) DEFAULT '' NOT NULL,

+ button_topic_new varchar(200) DEFAULT '' NOT NULL,

+ button_topic_reply varchar(200) DEFAULT '' NOT NULL,

+ user_icon1 varchar(200) DEFAULT '' NOT NULL,

+ user_icon2 varchar(200) DEFAULT '' NOT NULL,

+ user_icon3 varchar(200) DEFAULT '' NOT NULL,

+ user_icon4 varchar(200) DEFAULT '' NOT NULL,

+ user_icon5 varchar(200) DEFAULT '' NOT NULL,

+ user_icon6 varchar(200) DEFAULT '' NOT NULL,

+ user_icon7 varchar(200) DEFAULT '' NOT NULL,

+ user_icon8 varchar(200) DEFAULT '' NOT NULL,

+ user_icon9 varchar(200) DEFAULT '' NOT NULL,

+ user_icon10 varchar(200) DEFAULT '' NOT NULL,

+ PRIMARY KEY (imageset_id),

+ UNIQUE imgset_nm (imageset_name)

+

+ topic_id mediumint(8) UNSIGNED NOT NULL auto_increment,

+ forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ icon_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ topic_attachment tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

+ topic_approved tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,

+ topic_reported tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

+ topic_title text DEFAULT '' NOT NULL,

+ topic_poster mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ topic_time int(11) UNSIGNED DEFAULT '0' NOT NULL,

+ topic_time_limit int(11) UNSIGNED DEFAULT '0' NOT NULL,

+ topic_views mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ topic_replies mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ topic_replies_real mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ topic_status tinyint(3) DEFAULT '0' NOT NULL,

+ topic_type tinyint(3) DEFAULT '0' NOT NULL,

+ topic_first_post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ topic_first_poster_name varchar(255) DEFAULT '' NOT NULL,

+ topic_last_post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ topic_last_poster_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ topic_last_poster_name varchar(255) DEFAULT '' NOT NULL,

+ topic_last_post_time int(11) UNSIGNED DEFAULT '0' NOT NULL,

+ topic_last_view_time int(11) UNSIGNED DEFAULT '0' NOT NULL,

+ topic_moved_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ topic_bumped tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

+ topic_bumper mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ poll_title text DEFAULT '' NOT NULL,

+ poll_start int(11) UNSIGNED DEFAULT '0' NOT NULL,

+ poll_length int(11) UNSIGNED DEFAULT '0' NOT NULL,

+ poll_max_options tinyint(4) DEFAULT '1' NOT NULL,

+ poll_last_vote int(11) UNSIGNED DEFAULT '0' NOT NULL,

+ poll_vote_change tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

+ PRIMARY KEY (topic_id),

+ KEY forum_id (forum_id),

+ KEY forum_id_type (forum_id, topic_type),

+ KEY last_post_time (topic_last_post_time),

+ KEY fid_time_moved (forum_id, topic_last_post_time, topic_moved_id)

+

+ user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ mark_time int(11) UNSIGNED DEFAULT '0' NOT NULL,

+ PRIMARY KEY (user_id, topic_id),

+ KEY forum_id (forum_id)

+

+# Table: 'phpbb_topics_posted'

+ user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ topic_posted tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

+ PRIMARY KEY (user_id, topic_id)

+

+ topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ notify_status tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

+ KEY topic_id (topic_id),

+ KEY user_id (user_id),

+ KEY notify_stat (notify_status)

+

+ group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ group_leader tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

+ user_pending tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,

+ KEY group_id (group_id),

+ KEY user_id (user_id),

+ KEY group_leader (group_leader)

+

+ user_id mediumint(8) UNSIGNED NOT NULL auto_increment,

+ user_type tinyint(2) DEFAULT '0' NOT NULL,

+ group_id mediumint(8) UNSIGNED DEFAULT '3' NOT NULL,

+ user_permissions mediumtext DEFAULT '' NOT NULL,

+ user_perm_from mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

+ user_ip varchar(40) DEFAULT '' NOT NULL,

+ user_regdate int(11) UNSIGNED DEFAULT '0' NOT NULL,

+ username varchar(252) DEFAULT '' NOT NULL,

+ user_password varchar(40) DEFAULT '' NOT NULL,

+ user_passchg int(11) UNSIGNED DEFAULT '0' NOT NULL,

+ user_email varchar(100) DEFAULT '' NOT NULL,

+ user_email_hash bigint(20) DEFAULT '0' NOT NULL,

+ user_birthday varchar(10) DEFAULT '' NOT NULL,

+ user_lastvisit int(11) UNSIGNED DEFAULT '0' NOT NULL,

+ user_lastmark int(11) UNSIGNED DEFAULT '0' NOT NULL,

+ user_lastpost_time int(11) UNSIGNED DEFAULT '0' NOT NULL,