'query_first' => array('target', $convert->truncate_statement . POSTS_TABLE),

'execute_first' => '

$config["max_post_chars"] = 0;

$config["max_quote_depth"] = 0;

',

'execute_first' => '

$config["max_post_chars"] = 0;

$config["max_quote_depth"] = 0;

',

$result = $src_db->sql_query($sql);

$prune_enabled = (int) $src_db->sql_fetchfield('config_value');

$src_db->sql_freeresult($result);

// Insert categories

$sql = 'SELECT cat_id, cat_title

FROM ' . $convert->src_table_prefix . 'categories

'prune_freq' => (int) null_to_zero($row['prune_freq']),

'forum_flags' => phpbb_forum_flags(),

// Default values

'forum_desc_bitfield' => '',

{

// And now the moderators

// We make sure that they have at least standard access to the forums they moderate in addition to the moderating permissions

$mod_post_map = array(

'auth_announce' => 'f_announce',

'auth_sticky' => 'f_sticky'

);

foreach ($user_access as $forum_id => $access_map)

{

$forum_id = (int) $forum_id;

{

$message = preg_replace('/\[quote="(.*?)"\]/s', '[quote="\1"]', $message);

$message = preg_replace('/\[quote=\\\"(.*?)\\\"\]/s', '[quote="\1"]', $message);

// let's hope that this solves more problems than it causes. Deal with escaped quotes.

$message = str_replace('\"', '"', $message);

$message = str_replace('\"', '"', $message);

// parse($allow_bbcode, $allow_magic_url, $allow_smilies, $allow_img_bbcode = true, $allow_flash_bbcode = true, $allow_quote_bbcode = true, $allow_url_bbcode = true, $update_this_message = true, $mode = 'post')

$message_parser->parse($enable_bbcode, $enable_magic_url, $enable_smilies);

if (sizeof($message_parser->warn_msg))

{

$msg_id = isset($convert->row['post_id']) ? $convert->row['post_id'] : $convert->row['privmsgs_id'];

global $db, $convert, $user, $config, $cache, $phpbb_root_path;

$src_path = $convert->options['forum_path'] . '/' . phpbb_get_files_dir() . '/thumbs/';

if ($handle = @opendir($src_path))

{

while ($entry = readdir($handle))

$pos--;

continue;

}

$forum_auth = substr($forum_permissions, $pos, $auth_len);

$forum_id = base64_unpack($forum_auth);

$forum_ids[] = (int) $forum_id;

}

if (sizeof($forum_ids))

{

return attachment_forum_perms($forum_ids);

function phpbb_get_avatar_height($user_avatar)

{

global $convert_row;

if (empty($convert_row['user_avatar_type']))

{

return 0;

{

return 0;

}

return get_avatar_width($user_avatar, 'phpbb_avatar_type', $convert_row['user_avatar_type']);

}

case 'mysql':

$map_dbms = 'mysql_40';

break;

case 'mysql4':

if (version_compare($db->sql_server_info(true), '4.1.3', '>='))

{

$map_dbms = 'mysql_40';

}

break;

case 'mysqli':

$map_dbms = 'mysql_41';

break;

case 'mssql':

case 'mssql_odbc':

$map_dbms = 'mssql';

break;

default:

$map_dbms = $db->sql_layer;

break;

*

*/

// Enter any version to update from to test updates. The version within the db will not be updated.

$debug_from_version = false;

// Return if we "just include it" to find out for which version the database update is responsible for

if (defined('IN_PHPBB') && defined('IN_INSTALL'))

{

set_config('dbms_version', $db->sql_server_info(true));

}

// MySQL update from MySQL 3.x/4.x to > 4.1.x required?

if ($db->sql_layer == 'mysql' || $db->sql_layer == 'mysql4' || $db->sql_layer == 'mysqli')

{

echo '<h1>' . $lang['ERROR'] . '</h1><br />';

echo '<p>' . sprintf($lang['MYSQL_SCHEMA_UPDATE_REQUIRED'], $config['dbms_version'], $db->sql_server_info(true)) . '</p>';

exit_handler();

exit;

}

}

// If the latest version and the current version are 'unequal', we will update the version_update_from, else we do not update anything.

if ($inline_update)

{

// Now we purge the session table as well as all cache files

$cache->purge();

</div>

</div>

<span class="corners-bottom"><span></span></span>

</body>

</html>

}

/**

{

$errored = true;

$error_ary['sql'][] = $db->sql_error_sql;

}

$db->sql_return_on_error(false);

}

}

/****************************************************************************

* ADD YOUR DATABASE SCHEMA CHANGES HERE *

*****************************************************************************/

// No changes from 3.0.5-RC1 to 3.0.5

'3.0.5-RC1' => array(),

);

}

set_config('captcha_gd_wave', 0);

set_config('captcha_gd_3d_noise', 1);

set_config('captcha_gd_fonts', 1);

set_config('confirm_refresh', 1);

// Maximum number of keywords

WHERE bot_agent = 'ichiro/2'";

_sql($sql, $errored, $error_ary);

// Before we are able to add a unique key to auth_option, we need to remove duplicate entries

// We get duplicate entries first

// No changes from 3.0.5-RC1 to 3.0.5

case '3.0.5-RC1':

break;

}

}

}

$statements = array();

// Change columns?

if (!empty($schema_changes['change_columns']))

foreach ($columns as $column_name => $column_data)

{

// If the column exists we change it, else we add it ;)

{

}

else

{

}

{

$statements = array_merge($statements, $result);

}

{

foreach ($columns as $column_name => $column_data)

{

{

}

else

{

}

{

$statements = array_merge($statements, $result);

}

// Only remove the column if it exists...

if ($this->sql_column_exists($table, $column))

{

{

$statements = array_merge($statements, $result);

}

{

foreach ($schema_changes['add_primary_keys'] as $table => $columns)

{

{

$statements = array_merge($statements, $result);

}

}

}

if ($this->return_statements)

{

return $statements;

case 'oracle':

$sql = "SELECT column_name

FROM user_tab_columns

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

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

{

case 'firebird':

$sql = "SELECT RDB\$FIELD_NAME as FNAME

FROM RDB\$RELATION_FIELDS

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

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

{

{

case 'firebird':

$sql .= " {$column_type} ";

if (!is_null($column_data[1]))

{

$sql .= 'DEFAULT ' . ((is_numeric($column_data[1])) ? $column_data[1] : "'{$column_data[1]}'") . ' ';

}

$sql .= 'NOT NULL';

/**

* Add new column

*/

{

$column_data = $this->sql_prepare_column_data($table_name, $column_name, $column_data);

$statements = array();

switch ($this->sql_layer)

{

case 'firebird':

$statements[] = 'ALTER TABLE ' . $table_name . ' ADD "' . strtoupper($column_name) . '" ' . $column_data['column_type_sql'];

break;

case 'mssql':

$statements[] = 'ALTER TABLE [' . $table_name . '] ADD [' . $column_name . '] ' . $column_data['column_type_sql_default'];

break;

case 'mysql_40':

case 'mysql_41':

break;

case 'oracle':

$statements[] = 'ALTER TABLE ' . $table_name . ' ADD ' . $column_name . ' ' . $column_data['column_type_sql'];

break;

case 'postgres':

$statements[] = 'ALTER TABLE ' . $table_name . ' ADD COLUMN "' . $column_name . '" ' . $column_data['column_type_sql'];

break;

case 'sqlite':

if (version_compare(sqlite_libversion(), '3.0') == -1)

{

$sql = "SELECT sql

/**

* Drop column

*/

{

$statements = array();

break;

case 'sqlite':

if (version_compare(sqlite_libversion(), '3.0') == -1)

{

$sql = "SELECT sql

/**

* Add primary key

*/

{

$statements = array();

break;

case 'sqlite':

$sql = "SELECT sql

FROM sqlite_master

WHERE type = 'table'

/**

* Change column type (not name!)

*/

{

$column_data = $this->sql_prepare_column_data($table_name, $column_name, $column_data);

$statements = array();

{

case 'firebird':

// Change type...

break;

case 'mssql':

case 'sqlite':

$sql = "SELECT sql

FROM sqlite_master

WHERE type = 'table'

// Set correct format ... guess full xx_yy form

$accept_lang = substr($accept_lang, 0, 2) . '_' . substr($accept_lang, 3, 2);

{

$language = $accept_lang;

break;

{

// No match on xx_yy so try xx

$accept_lang = substr($accept_lang, 0, 2);

{

$language = $accept_lang;

break;

closedir($dir);

}

{

die('No language found!');

}

$config['max_quote_depth'] = 0;

// @todo Need to confirm that max post length in source is <= max post length in destination or there may be interesting formatting issues

// Set up a user as well. We _should_ have enough of a database here at this point to do this

// and it helps for any core code we call

$config['max_quote_depth'] = 0;

// @todo Need to confirm that max post length in source is <= max post length in destination or there may be interesting formatting issues

}

$template->assign_block_vars('checks', array(

*/

function finish_conversion()

{

$db->sql_query('DELETE FROM ' . CONFIG_TABLE . "

WHERE config_name = 'convert_progress'

OR config_name = 'convert_db_user'");

$db->sql_query('DELETE FROM ' . SESSIONS_TABLE);

cache_moderators();

// And finally, add a note to the log

WHERE config_name = 'avatar_salt'",

'UPDATE ' . $data['table_prefix'] . "users

WHERE username = 'Admin'",

'UPDATE ' . $data['table_prefix'] . "moderator_cache

if (@extension_loaded('gd') || can_load_dll('gd'))

{

$sql_ary[] = 'UPDATE ' . $data['table_prefix'] . "config

SET config_value = '1'

WHERE config_name = 'captcha_gd'";

}

'TITLE' => $lang['INSTALL_CONGRATS'],

'BODY' => sprintf($lang['INSTALL_CONGRATS_EXPLAIN'], $config['version'], append_sid($phpbb_root_path . 'install/index.' . $phpEx, 'mode=convert&amp;language=' . $data['language']), '../docs/README.html'),

'L_SUBMIT' => $lang['INSTALL_LOGIN'],

));

}

),

'ACP_FORUM_BASED_PERMISSIONS' => array(

'ACP_FORUM_PERMISSIONS',

'ACP_FORUM_MODERATORS',

'ACP_USERS_FORUM_PERMISSIONS',

'ACP_GROUPS_FORUM_PERMISSIONS',

}

// What about the language file? Got it updated?

{

$lang = array();

// only add new keys to user's language in english

$new_keys = array_diff(array_keys($lang), array_keys($user->lang));

foreach ($new_keys as $i => $new_key)

// Now init the connection

if ($update_mode == 'download')

{

if ($use_method == '.zip')

{

$compress = new compress_zip('w', $phpbb_root_path . 'store/' . $archive_filename . $use_method);

if ($info === false)

{

$update_info = array();

$info = (empty($update_info) || !is_array($update_info)) ? false : $update_info;

if ($info !== false)

global $phpbb_root_path, $phpEx;

$update_info = array();

$info = (empty($update_info) || !is_array($update_info)) ? false : $update_info;

$errstr = ($info === false) ? $user->lang['WRONG_INFO_FILE_FORMAT'] : '';

if ($info !== false)

{

// Adjust the update info file to hold some specific style-related information

$info['custom'] = array();

/*

session_id CHAR(32) CHARACTER SET NONE DEFAULT '' NOT NULL,

confirm_type INTEGER DEFAULT 0 NOT NULL,

code VARCHAR(8) CHARACTER SET NONE DEFAULT '' NOT NULL,

);;

ALTER TABLE phpbb_confirm ADD PRIMARY KEY (session_id, confirm_id);;

forum_last_poster_name VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,

forum_last_poster_colour VARCHAR(6) CHARACTER SET NONE DEFAULT '' NOT NULL,

forum_flags INTEGER DEFAULT 32 NOT NULL,

display_subforum_list INTEGER DEFAULT 1 NOT NULL,

display_on_index INTEGER DEFAULT 1 NOT NULL,

enable_indexing INTEGER DEFAULT 1 NOT NULL,

group_id INTEGER NOT NULL,

group_type INTEGER DEFAULT 1 NOT NULL,

group_founder_manage INTEGER DEFAULT 0 NOT NULL,

group_name VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,

group_desc BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL,

group_desc_bitfield VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL,

ALTER TABLE phpbb_log ADD PRIMARY KEY (log_id);;

CREATE INDEX phpbb_log_log_type ON phpbb_log(log_type);;

CREATE INDEX phpbb_log_forum_id ON phpbb_log(forum_id);;

CREATE INDEX phpbb_log_topic_id ON phpbb_log(topic_id);;

CREATE INDEX phpbb_log_reportee_id ON phpbb_log(reportee_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_approved ON phpbb_posts(post_approved);;

CREATE INDEX phpbb_posts_tid_post_time ON phpbb_posts(topic_id, post_time);;

CREATE GENERATOR phpbb_posts_gen;;

message_edit_time INTEGER DEFAULT 0 NOT NULL,

message_edit_count INTEGER DEFAULT 0 NOT NULL,

to_address BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL,

);;

ALTER TABLE phpbb_privmsgs ADD PRIMARY KEY (msg_id);;

field_validation VARCHAR(20) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,

field_required INTEGER DEFAULT 0 NOT NULL,

field_show_on_reg INTEGER DEFAULT 0 NOT NULL,

field_show_profile INTEGER DEFAULT 0 NOT NULL,

field_hide INTEGER DEFAULT 0 NOT NULL,

field_no_view INTEGER DEFAULT 0 NOT NULL,

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,

ALTER TABLE phpbb_reports ADD PRIMARY KEY (report_id);;

CREATE GENERATOR phpbb_reports_gen;;

SET GENERATOR phpbb_reports_gen TO 0;;

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_avatar VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL,

user_avatar_type INTEGER DEFAULT 0 NOT NULL,

user_avatar_width INTEGER DEFAULT 0 NOT NULL,

user_interests BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL,

user_actkey VARCHAR(32) CHARACTER SET NONE DEFAULT '' NOT NULL,

user_newpasswd VARCHAR(40) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,

);;

ALTER TABLE phpbb_users ADD PRIMARY KEY (user_id);;

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

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

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

) ON [PRIMARY]

GO

(

[attach_id]

GO

CREATE INDEX [filetime] ON [phpbb_attachments]([filetime]) ON [PRIMARY]

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

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

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

) ON [PRIMARY]

GO

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

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

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

) ON [PRIMARY]

GO

(

[auth_option_id]

GO

CREATE UNIQUE INDEX [auth_option] ON [phpbb_acl_options]([auth_option]) ON [PRIMARY]

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

[role_description] [varchar] (4000) DEFAULT ('') NOT NULL ,

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

) ON [PRIMARY]

GO

(

[role_id]

GO

CREATE INDEX [role_type] ON [phpbb_acl_roles]([role_type]) ON [PRIMARY]

CREATE TABLE [phpbb_acl_roles_data] (

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

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

) ON [PRIMARY]

GO

(

[role_id],

[auth_option_id]

GO

CREATE INDEX [ath_op_id] ON [phpbb_acl_roles_data]([auth_option_id]) ON [PRIMARY]

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

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

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

) ON [PRIMARY]

GO

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

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

[ban_reason] [varchar] (255) DEFAULT ('') NOT NULL ,

) ON [PRIMARY]

GO

(

[ban_id]

GO

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

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

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

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

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

(

[bbcode_id]

GO

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

*/

CREATE TABLE [phpbb_bookmarks] (

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

) ON [PRIMARY]

GO

(

[topic_id],

[user_id]

GO

[bot_name] [varchar] (255) DEFAULT ('') NOT NULL ,

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

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

) ON [PRIMARY]

GO

(

[bot_id]

GO

CREATE INDEX [bot_active] ON [phpbb_bots]([bot_active]) ON [PRIMARY]

CREATE TABLE [phpbb_config] (

[config_name] [varchar] (255) DEFAULT ('') NOT NULL ,

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

) ON [PRIMARY]

GO

(

[config_name]

GO

CREATE INDEX [is_dynamic] ON [phpbb_config]([is_dynamic]) ON [PRIMARY]

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

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

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

) ON [PRIMARY]

GO

(

[session_id],

[confirm_id]

GO

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

*/

CREATE TABLE [phpbb_disallow] (

[disallow_id] [int] IDENTITY (1, 1) NOT NULL ,

) ON [PRIMARY]

GO

(

[disallow_id]

GO

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

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

[draft_subject] [varchar] (255) DEFAULT ('') NOT NULL ,

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

(

[draft_id]

GO

CREATE INDEX [save_time] ON [phpbb_drafts]([save_time]) ON [PRIMARY]

CREATE TABLE [phpbb_extensions] (

[extension_id] [int] IDENTITY (1, 1) NOT NULL ,

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

) ON [PRIMARY]

GO

(

[extension_id]

GO

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

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

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

) ON [PRIMARY]

GO

(

[group_id]

GO

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

[forum_last_poster_colour] [varchar] (6) DEFAULT ('') NOT NULL ,

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

[display_subforum_list] [int] DEFAULT (1) NOT NULL ,

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

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

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

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

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

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

(

[forum_id]

GO

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

CREATE TABLE [phpbb_forums_access] (

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

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

) ON [PRIMARY]

GO

(

[forum_id],

[user_id],

[session_id]

GO

CREATE TABLE [phpbb_forums_track] (

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

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

) ON [PRIMARY]

GO

(

[user_id],

[forum_id]

GO

CREATE TABLE [phpbb_forums_watch] (

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

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

) ON [PRIMARY]

GO

[group_id] [int] IDENTITY (1, 1) NOT NULL ,

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

[group_founder_manage] [int] DEFAULT (0) NOT NULL ,

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

[group_desc] [varchar] (4000) DEFAULT ('') NOT NULL ,

[group_desc_bitfield] [varchar] (255) DEFAULT ('') NOT NULL ,

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

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

[group_max_recipients] [int] DEFAULT (0) NOT NULL ,

) ON [PRIMARY]

GO

(

[group_id]

GO

CREATE INDEX [group_legend_name] ON [phpbb_groups]([group_legend], [group_name]) ON [PRIMARY]

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

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

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

) ON [PRIMARY]

GO

(

[icons_id]

GO

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

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

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

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

) ON [PRIMARY]

GO

(

[lang_id]

GO

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

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

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

[log_operation] [varchar] (4000) DEFAULT ('') NOT NULL ,

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

(

[log_id]

GO

CREATE INDEX [log_type] ON [phpbb_log]([log_type]) ON [PRIMARY]

GO

CREATE INDEX [forum_id] ON [phpbb_log]([forum_id]) ON [PRIMARY]

GO

[username] [varchar] (255) DEFAULT ('') NOT NULL ,

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

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

) ON [PRIMARY]

GO

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

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

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

) ON [PRIMARY]

GO

(

[module_id]

GO

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

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

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

[poll_option_text] [varchar] (4000) DEFAULT ('') NOT NULL ,

) ON [PRIMARY]

GO

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

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

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

) ON [PRIMARY]

GO

[post_edit_reason] [varchar] (255) DEFAULT ('') NOT NULL ,

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

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

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

(

[post_id]

GO

CREATE INDEX [forum_id] ON [phpbb_posts]([forum_id]) ON [PRIMARY]

CREATE INDEX [post_approved] ON [phpbb_posts]([post_approved]) ON [PRIMARY]

GO

CREATE INDEX [tid_post_time] ON [phpbb_posts]([topic_id], [post_time]) ON [PRIMARY]

GO

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

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

[to_address] [varchar] (4000) DEFAULT ('') NOT NULL ,

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

(

[msg_id]

GO

CREATE INDEX [author_ip] ON [phpbb_privmsgs]([author_ip]) ON [PRIMARY]

[folder_id] [int] IDENTITY (1, 1) NOT NULL ,

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

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

) ON [PRIMARY]

GO

(

[folder_id]

GO

CREATE INDEX [user_id] ON [phpbb_privmsgs_folder]([user_id]) ON [PRIMARY]

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

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

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

) ON [PRIMARY]

GO

(

[rule_id]

GO

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

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

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

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

) ON [PRIMARY]

GO

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

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

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

[field_show_profile] [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 ,

) ON [PRIMARY]

GO

(

[field_id]

GO

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

Table: 'phpbb_profile_fields_data'

*/

CREATE TABLE [phpbb_profile_fields_data] (

) ON [PRIMARY]

GO

(

[user_id]

GO

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

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

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

) ON [PRIMARY]

GO

(

[field_id],

[lang_id],

[option_id]

GO

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

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

[lang_explain] [varchar] (4000) DEFAULT ('') NOT NULL ,

) ON [PRIMARY]

GO

(

[field_id],

[lang_id]

GO

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

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

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

) ON [PRIMARY]

GO

(

[rank_id]

GO

[report_id] [int] IDENTITY (1, 1) NOT NULL ,

[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 ,

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

(

[report_id]

GO

[reason_id] [int] IDENTITY (1, 1) NOT NULL ,

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

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

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

(

[reason_id]

GO

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

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

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

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

(

[search_key]

GO

[word_id] [int] IDENTITY (1, 1) NOT NULL ,

[word_text] [varchar] (255) DEFAULT ('') NOT NULL ,

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

) ON [PRIMARY]

GO

(

[word_id]

GO

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

CREATE TABLE [phpbb_search_wordmatch] (

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

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

) ON [PRIMARY]

GO

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

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

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

) ON [PRIMARY]

GO

(

[session_id]

GO

CREATE INDEX [session_time] ON [phpbb_sessions]([session_time]) ON [PRIMARY]

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

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

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

) ON [PRIMARY]

GO

(

[key_id],

[user_id]

GO

CREATE INDEX [last_login] ON [phpbb_sessions_keys]([last_login]) ON [PRIMARY]

[site_id] [int] IDENTITY (1, 1) NOT NULL ,

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

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

) ON [PRIMARY]

GO

(

[site_id]

GO

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

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

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

) ON [PRIMARY]

GO

(

[smiley_id]

GO

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

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

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

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

) ON [PRIMARY]

GO

(

[style_id]

GO

CREATE UNIQUE INDEX [style_name] ON [phpbb_styles]([style_name]) ON [PRIMARY]

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

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

[template_inherits_id] [int] DEFAULT (0) NOT NULL ,

) ON [PRIMARY]

GO

(

[template_id]

GO

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

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

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

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

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

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

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

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

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

(

[theme_id]

GO

CREATE UNIQUE INDEX [theme_name] ON [phpbb_styles_theme]([theme_name]) ON [PRIMARY]

[imageset_id] [int] IDENTITY (1, 1) NOT NULL ,

[imageset_name] [varchar] (255) DEFAULT ('') NOT NULL ,

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

) ON [PRIMARY]

GO

(

[imageset_id]

GO

CREATE UNIQUE INDEX [imgset_nm] ON [phpbb_styles_imageset]([imageset_name]) ON [PRIMARY]

[image_lang] [varchar] (30) DEFAULT ('') NOT NULL ,

[image_height] [int] DEFAULT (0) NOT NULL ,

[image_width] [int] DEFAULT (0) NOT NULL ,

) ON [PRIMARY]

GO

(

[image_id]

GO

CREATE INDEX [i_d] ON [phpbb_styles_imageset_data]([imageset_id]) ON [PRIMARY]

[poll_length] [int] DEFAULT (0) NOT NULL ,

[poll_max_options] [int] DEFAULT (1) NOT NULL ,

[poll_last_vote] [int] DEFAULT (0) NOT NULL ,

) ON [PRIMARY]

GO

(

[topic_id]

GO

CREATE INDEX [forum_id] ON [phpbb_topics]([forum_id]) ON [PRIMARY]

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

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

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

) ON [PRIMARY]

GO

(

[user_id],

[topic_id]

GO

CREATE INDEX [forum_id] ON [phpbb_topics_track]([forum_id]) ON [PRIMARY]

CREATE TABLE [phpbb_topics_posted] (

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

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

) ON [PRIMARY]

GO

(

[user_id],

[topic_id]

GO

CREATE TABLE [phpbb_topics_watch] (

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

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

) ON [PRIMARY]

GO

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

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

[group_leader] [int] DEFAULT (0) NOT NULL ,

) ON [PRIMARY]

GO

[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_avatar] [varchar] (255) DEFAULT ('') NOT NULL ,

[user_avatar_type] [int] DEFAULT (0) NOT NULL ,

[user_avatar_width] [int] DEFAULT (0) NOT NULL ,

[user_interests] [varchar] (4000) DEFAULT ('') NOT NULL ,

[user_actkey] [varchar] (32) DEFAULT ('') NOT NULL ,

[user_newpasswd] [varchar] (40) DEFAULT ('') NOT NULL ,

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

(

[user_id]

GO

CREATE INDEX [user_birthday] ON [phpbb_users]([user_birthday]) ON [PRIMARY]

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

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

[log_id] [int] DEFAULT (0) NOT NULL ,

) ON [PRIMARY]

GO

(

[warning_id]

GO

CREATE TABLE [phpbb_words] (

[word_id] [int] IDENTITY (1, 1) NOT NULL ,

[word] [varchar] (255) DEFAULT ('') NOT NULL ,

) ON [PRIMARY]

GO

(

[word_id]

GO

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

[zebra_id] [int] DEFAULT (0) NOT NULL ,

[friend] [int] DEFAULT (0) NOT NULL ,

) ON [PRIMARY]

GO

(

[user_id],

[zebra_id]

GO

confirm_type tinyint(3) DEFAULT '0' NOT NULL,

code varbinary(8) DEFAULT '' NOT NULL,

seed int(10) UNSIGNED DEFAULT '0' NOT NULL,

PRIMARY KEY (session_id, confirm_id),

KEY confirm_type (confirm_type)

);

forum_last_poster_name blob NOT NULL,

forum_last_poster_colour varbinary(6) DEFAULT '' NOT NULL,

forum_flags tinyint(4) DEFAULT '32' NOT NULL,

display_subforum_list tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,

display_on_index tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,

enable_indexing tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,

group_id mediumint(8) UNSIGNED NOT NULL auto_increment,

group_type tinyint(4) DEFAULT '1' NOT NULL,

group_founder_manage tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

group_name blob NOT NULL,

group_desc blob NOT NULL,

group_desc_bitfield varbinary(255) DEFAULT '' NOT NULL,

log_data mediumblob 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 poster_ip (poster_ip),

KEY poster_id (poster_id),

KEY post_approved (post_approved),

KEY tid_post_time (topic_id, post_time)

);

message_edit_count smallint(4) UNSIGNED DEFAULT '0' NOT NULL,

to_address blob NOT NULL,

bcc_address blob NOT NULL,

PRIMARY KEY (msg_id),

KEY author_ip (author_ip),

KEY message_time (message_time),

field_validation varbinary(60) DEFAULT '' NOT NULL,

field_required tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

field_show_on_reg tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

field_show_profile 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,

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 mediumblob NOT NULL,

);

user_allow_viewonline tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,

user_allow_viewemail tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,

user_allow_massemail tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,

user_avatar varbinary(255) DEFAULT '' NOT NULL,

user_avatar_type tinyint(2) DEFAULT '0' NOT NULL,

user_avatar_width smallint(4) UNSIGNED DEFAULT '0' NOT NULL,

user_actkey varbinary(32) DEFAULT '' NOT NULL,

user_newpasswd varbinary(120) DEFAULT '' NOT NULL,

user_form_salt varbinary(96) DEFAULT '' NOT NULL,

PRIMARY KEY (user_id),

KEY user_birthday (user_birthday),

KEY user_email_hash (user_email_hash),

confirm_type tinyint(3) DEFAULT '0' NOT NULL,

code varchar(8) DEFAULT '' NOT NULL,

seed int(10) UNSIGNED DEFAULT '0' NOT NULL,

PRIMARY KEY (session_id, confirm_id),

KEY confirm_type (confirm_type)

) CHARACTER SET `utf8` COLLATE `utf8_bin`;

forum_last_poster_name varchar(255) DEFAULT '' NOT NULL,

forum_last_poster_colour varchar(6) DEFAULT '' NOT NULL,

forum_flags tinyint(4) DEFAULT '32' NOT NULL,

display_subforum_list tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,

display_on_index tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,

enable_indexing tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,

group_id mediumint(8) UNSIGNED NOT NULL auto_increment,

group_type tinyint(4) DEFAULT '1' NOT NULL,

group_founder_manage tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

group_name varchar(255) DEFAULT '' NOT NULL,

group_desc text NOT NULL,

group_desc_bitfield varchar(255) DEFAULT '' NOT NULL,

log_data mediumtext 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 poster_ip (poster_ip),

KEY poster_id (poster_id),

KEY post_approved (post_approved),

KEY tid_post_time (topic_id, post_time)

) CHARACTER SET `utf8` COLLATE `utf8_bin`;

message_edit_count smallint(4) UNSIGNED DEFAULT '0' NOT NULL,

to_address text NOT NULL,

bcc_address text NOT NULL,

PRIMARY KEY (msg_id),

KEY author_ip (author_ip),

KEY message_time (message_time),

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_show_profile 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,

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 NOT NULL,

) CHARACTER SET `utf8` COLLATE `utf8_bin`;

user_allow_viewonline tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,

user_allow_viewemail tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,

user_allow_massemail tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,

user_avatar varchar(255) DEFAULT '' NOT NULL,

user_avatar_type tinyint(2) DEFAULT '0' NOT NULL,

user_avatar_width smallint(4) UNSIGNED DEFAULT '0' NOT NULL,

user_actkey varchar(32) DEFAULT '' NOT NULL,

user_newpasswd varchar(40) DEFAULT '' NOT NULL,

user_form_salt varchar(32) DEFAULT '' NOT NULL,

PRIMARY KEY (user_id),

KEY user_birthday (user_birthday),

KEY user_email_hash (user_email_hash),

confirm_type number(3) DEFAULT '0' NOT NULL,

code varchar2(8) DEFAULT '' ,

seed number(10) DEFAULT '0' NOT NULL,

CONSTRAINT pk_phpbb_confirm PRIMARY KEY (session_id, confirm_id)

)

/

forum_last_poster_name varchar2(765) DEFAULT '' ,

forum_last_poster_colour varchar2(6) DEFAULT '' ,

forum_flags number(4) DEFAULT '32' NOT NULL,

display_subforum_list number(1) DEFAULT '1' NOT NULL,

display_on_index number(1) DEFAULT '1' NOT NULL,

enable_indexing number(1) DEFAULT '1' NOT NULL,

group_id number(8) NOT NULL,

group_type number(4) DEFAULT '1' NOT NULL,

group_founder_manage number(1) DEFAULT '0' NOT NULL,

group_name varchar2(255) DEFAULT '' ,

group_desc clob DEFAULT '' ,

group_desc_bitfield varchar2(255) DEFAULT '' ,

CREATE INDEX phpbb_log_log_type ON phpbb_log (log_type)

/

CREATE INDEX phpbb_log_forum_id ON phpbb_log (forum_id)

/

CREATE INDEX phpbb_log_topic_id ON phpbb_log (topic_id)

topic_id number(8) DEFAULT '0' NOT NULL,

poll_option_id number(4) DEFAULT '0' NOT NULL,

vote_user_id number(8) DEFAULT '0' NOT NULL,

)

/

/

CREATE INDEX phpbb_posts_post_approved ON phpbb_posts (post_approved)

/

CREATE INDEX phpbb_posts_tid_post_time ON phpbb_posts (topic_id, post_time)

/

message_edit_count number(4) DEFAULT '0' NOT NULL,

to_address clob DEFAULT '' ,

bcc_address clob DEFAULT '' ,

CONSTRAINT pk_phpbb_privmsgs PRIMARY KEY (msg_id)

)

/

field_validation varchar2(60) DEFAULT '' ,

field_required number(1) DEFAULT '0' NOT NULL,

field_show_on_reg number(1) DEFAULT '0' NOT NULL,

field_show_profile number(1) DEFAULT '0' NOT NULL,

field_hide number(1) DEFAULT '0' NOT NULL,

field_no_view number(1) DEFAULT '0' NOT NULL,

report_id number(8) NOT NULL,

reason_id number(4) DEFAULT '0' NOT NULL,

post_id number(8) DEFAULT '0' NOT NULL,

user_id number(8) DEFAULT '0' NOT NULL,

user_notify number(1) DEFAULT '0' NOT NULL,

report_closed number(1) DEFAULT '0' NOT NULL,

)

/

CREATE SEQUENCE phpbb_reports_seq

/

template_filename varchar2(100) DEFAULT '' ,

template_included clob DEFAULT '' ,

template_mtime number(11) DEFAULT '0' NOT NULL,

)

/

user_allow_viewonline number(1) DEFAULT '1' NOT NULL,

user_allow_viewemail number(1) DEFAULT '1' NOT NULL,

user_allow_massemail number(1) DEFAULT '1' NOT NULL,

user_avatar varchar2(255) DEFAULT '' ,

user_avatar_type number(2) DEFAULT '0' NOT NULL,

user_avatar_width number(4) DEFAULT '0' NOT NULL,

user_actkey varchar2(32) DEFAULT '' ,

user_newpasswd varchar2(120) DEFAULT '' ,

user_form_salt varchar2(96) DEFAULT '' ,

CONSTRAINT pk_phpbb_users PRIMARY KEY (user_id),

CONSTRAINT u_phpbb_username_clean UNIQUE (username_clean)

)

confirm_type INT2 DEFAULT '0' NOT NULL,

code varchar(8) DEFAULT '' NOT NULL,

seed INT4 DEFAULT '0' NOT NULL CHECK (seed >= 0),

PRIMARY KEY (session_id, confirm_id)

);

forum_last_poster_name varchar(255) DEFAULT '' NOT NULL,

forum_last_poster_colour varchar(6) DEFAULT '' NOT NULL,

forum_flags INT2 DEFAULT '32' NOT NULL,

display_subforum_list INT2 DEFAULT '1' NOT NULL CHECK (display_subforum_list >= 0),

display_on_index INT2 DEFAULT '1' NOT NULL CHECK (display_on_index >= 0),

enable_indexing INT2 DEFAULT '1' NOT NULL CHECK (enable_indexing >= 0),

group_id INT4 DEFAULT nextval('phpbb_groups_seq'),

group_type INT2 DEFAULT '1' NOT NULL,

group_founder_manage INT2 DEFAULT '0' NOT NULL CHECK (group_founder_manage >= 0),

group_name varchar_ci DEFAULT '' NOT NULL,

group_desc varchar(4000) DEFAULT '' NOT NULL,

group_desc_bitfield varchar(255) DEFAULT '' NOT NULL,

);

CREATE INDEX phpbb_log_log_type ON phpbb_log (log_type);

CREATE INDEX phpbb_log_forum_id ON phpbb_log (forum_id);

CREATE INDEX phpbb_log_topic_id ON phpbb_log (topic_id);

CREATE INDEX phpbb_log_reportee_id ON phpbb_log (reportee_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_approved ON phpbb_posts (post_approved);

CREATE INDEX phpbb_posts_tid_post_time ON phpbb_posts (topic_id, post_time);

/*

message_edit_count INT2 DEFAULT '0' NOT NULL CHECK (message_edit_count >= 0),

to_address varchar(4000) DEFAULT '' NOT NULL,

bcc_address varchar(4000) DEFAULT '' NOT NULL,

PRIMARY KEY (msg_id)

);

field_validation varchar(20) DEFAULT '' NOT NULL,

field_required INT2 DEFAULT '0' NOT NULL CHECK (field_required >= 0),

field_show_on_reg INT2 DEFAULT '0' NOT NULL CHECK (field_show_on_reg >= 0),

field_show_profile INT2 DEFAULT '0' NOT NULL CHECK (field_show_profile >= 0),

field_hide INT2 DEFAULT '0' NOT NULL CHECK (field_hide >= 0),

field_no_view INT2 DEFAULT '0' NOT NULL CHECK (field_no_view >= 0),

report_id INT4 DEFAULT nextval('phpbb_reports_seq'),

reason_id INT2 DEFAULT '0' NOT NULL CHECK (reason_id >= 0),

post_id INT4 DEFAULT '0' NOT NULL CHECK (post_id >= 0),

user_id INT4 DEFAULT '0' NOT NULL CHECK (user_id >= 0),

user_notify INT2 DEFAULT '0' NOT NULL CHECK (user_notify >= 0),

report_closed INT2 DEFAULT '0' NOT NULL CHECK (report_closed >= 0),

PRIMARY KEY (report_id)

);

/*

Table: 'phpbb_reports_reasons'

user_allow_viewonline INT2 DEFAULT '1' NOT NULL CHECK (user_allow_viewonline >= 0),

user_allow_viewemail INT2 DEFAULT '1' NOT NULL CHECK (user_allow_viewemail >= 0),

user_allow_massemail INT2 DEFAULT '1' NOT NULL CHECK (user_allow_massemail >= 0),

user_avatar varchar(255) DEFAULT '' NOT NULL,

user_avatar_type INT2 DEFAULT '0' NOT NULL,

user_avatar_width INT2 DEFAULT '0' NOT NULL CHECK (user_avatar_width >= 0),

user_actkey varchar(32) DEFAULT '' NOT NULL,

user_newpasswd varchar(40) DEFAULT '' NOT NULL,

user_form_salt varchar(32) DEFAULT '' NOT NULL,

PRIMARY KEY (user_id)

);

INSERT INTO phpbb_config (config_name, config_value) VALUES ('active_sessions', '0');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_attachments', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_autologin', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_local', '0');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_remote', '0');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_upload', '0');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_bbcode', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_birthdays', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_bookmarks', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_namechange', '0');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_nocensors', '0');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_pm_attach', '0');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_post_flash', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_post_links', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_privmsg', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_sig', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_sig_bbcode', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_sig_flash', '0');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('bump_interval', '10');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('bump_type', 'd');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('cache_gc', '7200');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('captcha_gd', '0');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('captcha_gd_foreground_noise', '0');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('captcha_gd_x_grid', '25');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('display_last_edited', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('display_order', '0');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('edit_time', '0');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('email_check_mx', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('email_enable', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('email_function_name', 'mail');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('enable_confirm', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('enable_pm_icons', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('enable_post_confirm', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('flood_interval', '15');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('force_server_vars', '0');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('form_token_lifetime', '7200');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_login_attempts', '3');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_name_chars', '20');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_num_search_keywords', '10');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_poll_options', '10');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_post_chars', '60000');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_post_font_size', '200');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_sig_urls', '5');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('min_name_chars', '3');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('min_pass_chars', '6');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('min_search_author_chars', '3');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('mime_triggers', 'body|head|html|img|plaintext|a href|pre|script|table|title');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('override_user_style', '0');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('pass_complex', 'PASS_TYPE_ANY');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('pm_edit_time', '0');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('posts_per_page', '10');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('print_pm', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('queue_interval', '600');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('ranks_path', 'images/ranks');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('require_activation', '0');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('referer_validation', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('site_desc', '{L_CONFIG_SITE_DESC}');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('sitename', '{L_CONFIG_SITENAME}');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('smilies_path', 'images/smilies');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_auth_method', 'PLAIN');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_delivery', '0');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_host', '');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('tpl_allow_php', '0');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('upload_icons_path', 'images/upload_icons');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('upload_path', 'files');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('warnings_expire_days', '90');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('warnings_gc', '14400');

INSERT INTO phpbb_acl_roles (role_name, role_description, role_type, role_order) VALUES ('ROLE_FORUM_POLLS', 'ROLE_DESCRIPTION_FORUM_POLLS', 'f_', 6);

INSERT INTO phpbb_acl_roles (role_name, role_description, role_type, role_order) VALUES ('ROLE_FORUM_LIMITED_POLLS', 'ROLE_DESCRIPTION_FORUM_LIMITED_POLLS', 'f_', 4);

# -- phpbb_styles

INSERT INTO phpbb_styles (style_name, style_copyright, style_active, template_id, theme_id, imageset_id) VALUES ('prosilver', '&copy; phpBB Group', 1, 1, 1, 1);

INSERT INTO phpbb_groups (group_name, group_type, group_founder_manage, group_colour, group_legend, group_avatar, group_desc, group_desc_uid, group_max_recipients) VALUES ('GLOBAL_MODERATORS', 3, 0, '00AA00', 1, '', '', '', 0);

INSERT INTO phpbb_groups (group_name, group_type, group_founder_manage, group_colour, group_legend, group_avatar, group_desc, group_desc_uid, group_max_recipients) VALUES ('ADMINISTRATORS', 3, 1, 'AA0000', 1, '', '', '', 0);

INSERT INTO phpbb_groups (group_name, group_type, group_founder_manage, group_colour, group_legend, group_avatar, group_desc, group_desc_uid, group_max_recipients) VALUES ('BOTS', 3, 0, '9E8DA7', 0, '', '', '', 5);

# -- User -> Group

INSERT INTO phpbb_user_group (group_id, user_id, user_pending, group_leader) VALUES (1, 1, 0, 0);

# Limited Access + Polls (f_)

INSERT INTO phpbb_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 22, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'f_%' AND auth_option NOT IN ('f_announce', 'f_attach', 'f_bump', 'f_delete', 'f_flash', 'f_icons', 'f_ignoreflood', 'f_sticky', 'f_user_lock', 'f_votechg');

# Permissions

# GUESTS - u_download and u_search ability

# Bots having bot access

INSERT INTO phpbb_acl_groups (group_id, forum_id, auth_option_id, auth_role_id, auth_setting) VALUES (6, 2, 0, 19, 0);

# -- Demo Topic

INSERT INTO phpbb_topics (topic_title, topic_poster, topic_time, topic_views, topic_replies, topic_replies_real, forum_id, topic_status, topic_type, topic_first_post_id, topic_first_poster_name, topic_first_poster_colour, topic_last_post_id, topic_last_poster_id, topic_last_poster_name, topic_last_poster_colour, topic_last_post_subject, topic_last_post_time, topic_last_view_time, poll_title) VALUES ('{L_TOPICS_TOPIC_TITLE}', 2, 972086460, 0, 0, 0, 2, 0, 0, 1, 'Admin', 'AA0000', 1, 2, 'Admin', 'AA0000', '{L_TOPICS_TOPIC_TITLE}', 972086460, 972086460, '');

confirm_type tinyint(3) NOT NULL DEFAULT '0',

code varchar(8) NOT NULL DEFAULT '',

seed INTEGER UNSIGNED NOT NULL DEFAULT '0',

PRIMARY KEY (session_id, confirm_id)

);

forum_last_poster_name varchar(255) NOT NULL DEFAULT '',

forum_last_poster_colour varchar(6) NOT NULL DEFAULT '',

forum_flags tinyint(4) NOT NULL DEFAULT '32',

display_subforum_list INTEGER UNSIGNED NOT NULL DEFAULT '1',

display_on_index INTEGER UNSIGNED NOT NULL DEFAULT '1',

enable_indexing INTEGER UNSIGNED NOT NULL DEFAULT '1',

group_id INTEGER PRIMARY KEY NOT NULL ,

group_type tinyint(4) NOT NULL DEFAULT '1',

group_founder_manage INTEGER UNSIGNED NOT NULL DEFAULT '0',

group_name varchar(255) NOT NULL DEFAULT '',

group_desc text(65535) NOT NULL DEFAULT '',

group_desc_bitfield varchar(255) NOT NULL DEFAULT '',

);

CREATE INDEX phpbb_log_log_type ON phpbb_log (log_type);

CREATE INDEX phpbb_log_forum_id ON phpbb_log (forum_id);

CREATE INDEX phpbb_log_topic_id ON phpbb_log (topic_id);

CREATE INDEX phpbb_log_reportee_id ON phpbb_log (reportee_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_approved ON phpbb_posts (post_approved);

CREATE INDEX phpbb_posts_tid_post_time ON phpbb_posts (topic_id, post_time);

# Table: 'phpbb_privmsgs'

message_edit_time INTEGER UNSIGNED NOT NULL DEFAULT '0',

message_edit_count INTEGER UNSIGNED NOT NULL DEFAULT '0',

to_address text(65535) NOT NULL DEFAULT '',

);

CREATE INDEX phpbb_privmsgs_author_ip ON phpbb_privmsgs (author_ip);

field_validation varchar(20) NOT NULL DEFAULT '',

field_required INTEGER UNSIGNED NOT NULL DEFAULT '0',

field_show_on_reg INTEGER UNSIGNED NOT NULL DEFAULT '0',

field_show_profile INTEGER UNSIGNED NOT NULL DEFAULT '0',

field_hide INTEGER UNSIGNED NOT NULL DEFAULT '0',

field_no_view INTEGER UNSIGNED NOT NULL DEFAULT '0',

report_id INTEGER PRIMARY KEY NOT NULL ,

reason_id INTEGER UNSIGNED NOT NULL DEFAULT '0',

post_id INTEGER UNSIGNED NOT NULL DEFAULT '0',

user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',

user_notify INTEGER UNSIGNED NOT NULL DEFAULT '0',

report_closed INTEGER UNSIGNED NOT NULL DEFAULT '0',

report_text mediumtext(16777215) NOT NULL DEFAULT ''

);

# Table: 'phpbb_reports_reasons'

CREATE TABLE phpbb_reports_reasons (

user_allow_viewonline INTEGER UNSIGNED NOT NULL DEFAULT '1',

user_allow_viewemail INTEGER UNSIGNED NOT NULL DEFAULT '1',

user_allow_massemail INTEGER UNSIGNED NOT NULL DEFAULT '1',

user_avatar varchar(255) NOT NULL DEFAULT '',

user_avatar_type tinyint(2) NOT NULL DEFAULT '0',

user_avatar_width INTEGER UNSIGNED NOT NULL DEFAULT '0',

user_interests text(65535) NOT NULL DEFAULT '',

user_actkey varchar(32) NOT NULL DEFAULT '',

user_newpasswd varchar(40) NOT NULL DEFAULT '',

);

CREATE INDEX phpbb_users_user_birthday ON phpbb_users (user_birthday);