* If you overwrite the original schema files please make sure you save the file with UNIX linefeeds.

*/

set_time_limit(0);

'VCHAR:' => 'varchar(%d)',

'CHAR:' => 'char(%d)',

'XSTEXT' => 'text',

'STEXT' => 'text',

'TEXT' => 'text',

'TEXT_UNI' => 'text',

'MTEXT' => 'mediumtext',

'DECIMAL' => 'decimal(5,2)',

'VCHAR_UNI' => 'varchar(255)',

'VCHAR_UNI:'=> 'varchar(%d)',

'VARBINARY' => 'varbinary(255)',

),

'TINT:' => 'INTEGER',

'USINT' => 'INTEGER',

'BOOL' => 'INTEGER',

'TIMESTAMP' => 'INTEGER',

'DECIMAL' => 'DOUBLE PRECISION',

),

'mssql' => array(

'STEXT' => '[varchar] (3000)',

'TEXT' => '[varchar] (8000)',

'MTEXT' => '[text]',

'MTEXT_UNI' => '[text]',

'TIMESTAMP' => '[int]',

'DECIMAL' => '[float]',

'VCHAR_UNI' => '[varchar] (255)',

'VCHAR_UNI:'=> '[varchar] (%d)',

'VARBINARY' => '[varchar] (255)',

),

'STEXT' => 'varchar2(3000)',

'TEXT' => 'clob',

'MTEXT' => 'clob',

'TEXT_UNI' => 'clob',

'MTEXT_UNI' => 'clob',

'TIMESTAMP' => 'number(11)',

'DECIMAL' => 'number(5, 2)',

'VARBINARY' => 'raw(255)',

),

'DECIMAL' => 'decimal(5,2)',

'VCHAR_UNI' => 'varchar(255)',

'VCHAR_UNI:'=> 'varchar(%d)',

'VARBINARY' => 'blob',

),

'STEXT' => 'varchar(3000)',

'TEXT' => 'varchar(8000)',

'MTEXT' => 'TEXT',

'MTEXT_UNI' => 'TEXT',

'TIMESTAMP' => 'INT4', // unsigned

'DECIMAL' => 'decimal(5,2)',

break;

}

// Write columns one by one...

foreach ($table_data['COLUMNS'] as $column_name => $column_data)

{

if ($column_length > $dbms_type_map[$dbms][$orig_column_type . ':']['limit'][2])

{

$column_type = $dbms_type_map[$dbms][$orig_column_type . ':']['limit'][3];

}

else

{

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

}

if (isset($column_data[2]) && $column_data[2] == 'auto_increment')

{

case 'mysql_41':

$line .= ($key_data[0] == 'INDEX') ? "\tKEY" : '';

$line .= ($key_data[0] == 'UNIQUE') ? "\tUNIQUE" : '';

$line .= ' ' . $key_name . ' (' . implode(', ', $key_data[1]) . "),\n";

break;

* VCHAR:x => varchar(x)

* TIMESTAMP => int(11) UNSIGNED

* DECIMAL => decimal number (5,2)

* VCHAR_CI => varchar_ci for postgresql, others VCHAR

*/

function get_schema_struct()

$schema_data['phpbb_config'] = array(

'COLUMNS' => array(

'config_value' => array('VCHAR', ''),

'is_dynamic' => array('BOOL', 0),

),

$schema_data['phpbb_disallow'] = array(

'COLUMNS' => array(

'disallow_id' => array('UINT', NULL, 'auto_increment'),

),

'PRIMARY_KEY' => 'disallow_id',

);

'forum_parents' => array('MTEXT', ''),

'forum_name' => array('STEXT_UNI', ''),

'forum_desc' => array('TEXT_UNI', ''),

'forum_desc_options' => array('UINT:11', 7),

'forum_desc_uid' => array('VCHAR:5', ''),

'forum_link' => array('VCHAR_UNI', ''),

'forum_image' => array('VCHAR', ''),

'forum_rules' => array('TEXT_UNI', ''),

'forum_rules_link' => array('VCHAR_UNI', ''),

'forum_rules_options' => array('UINT:11', 7),

'forum_rules_uid' => array('VCHAR:5', ''),

'forum_topics_per_page' => array('TINT:4', 0),

'group_type' => array('TINT:4', 1),

'group_name' => array('VCHAR_CI', ''),

'group_desc' => array('TEXT_UNI', ''),

'group_desc_options' => array('UINT:11', 7),

'group_desc_uid' => array('VCHAR:5', ''),

'group_display' => array('BOOL', 0),

'COLUMNS' => array(

'forum_id' => array('UINT', 0),

'user_id' => array('UINT', 0),

'group_id' => array('UINT', 0),

'group_name' => array('VCHAR_UNI', ''),

'display_on_index' => array('BOOL', 1),

'enable_smilies' => array('BOOL', 1),

'enable_magic_url' => array('BOOL', 1),

'enable_sig' => array('BOOL', 1),

'post_subject' => array('XSTEXT_UNI', ''),

'post_text' => array('MTEXT_UNI', ''),

'post_checksum' => array('VCHAR:32', ''),

'post_attachment' => array('BOOL', 0),

'bbcode_uid' => array('VCHAR:5', ''),

'post_postcount' => array('BOOL', 1),

'post_edit_time' => array('TIMESTAMP', 0),

'message_edit_reason' => array('STEXT_UNI', ''),

'message_edit_user' => array('UINT', 0),

'message_attachment' => array('BOOL', 0),

'bbcode_uid' => array('VCHAR:5', ''),

'message_edit_time' => array('TIMESTAMP', 0),

'message_edit_count' => array('USINT', 0),

$schema_data['phpbb_styles'] = array(

'COLUMNS' => array(

'style_id' => array('TINT:4', NULL, 'auto_increment'),

'style_copyright' => array('VCHAR_UNI', ''),

'style_active' => array('BOOL', 1),

'template_id' => array('TINT:4', 0),

$schema_data['phpbb_styles_template'] = array(

'COLUMNS' => array(

'template_id' => array('TINT:4', NULL, 'auto_increment'),

'template_copyright' => array('VCHAR_UNI', ''),

'template_path' => array('VCHAR:100', ''),

'template_storedb' => array('BOOL', 0),

),

'PRIMARY_KEY' => 'template_id',

$schema_data['phpbb_styles_theme'] = array(

'COLUMNS' => array(

'theme_id' => array('TINT:4', NULL, 'auto_increment'),

'theme_copyright' => array('VCHAR_UNI', ''),

'theme_path' => array('VCHAR:100', ''),

'theme_storedb' => array('BOOL', 0),

$schema_data['phpbb_styles_imageset'] = array(

'COLUMNS' => array(

'imageset_id' => array('TINT:4', NULL, 'auto_increment'),

'imageset_copyright' => array('VCHAR_UNI', ''),

'imageset_path' => array('VCHAR:100', ''),

'user_avatar_height' => array('USINT', 0),

'user_sig' => array('MTEXT_UNI', ''),

'user_sig_bbcode_uid' => array('VCHAR:5', ''),

'user_from' => array('VCHAR_UNI:100', ''),

'user_icq' => array('VCHAR:15', ''),

'user_aim' => array('VCHAR_UNI', ''),

/*

Domain definition

*/

/*

Operation Functions

EOF;

break;

}

return '';

$sql = 'SELECT user_id, bot_agent, bot_ip

FROM ' . BOTS_TABLE . '

WHERE bot_active = 1

break;

// LENGTH supported by MySQL, IBM DB2 and Oracle for sure...

/**

* Firebird/Interbase Database Abstraction Layer

* @package dbal

*/

class dbal_firebird extends dbal

}

else

{

}

}

* Return number of rows

* Not used within core code

*/

{

global $cache;

return $cache->sql_numrows($query_id);

}

return false;

}

$this->sql_report('start', $query);

}

$this->last_query_text = $query;

$this->query_result = ($cache_ttl && method_exists($cache, 'sql_load')) ? $cache->sql_load($query) : false;

$this->sql_add_num_queries($this->query_result);

WHERE poster_id = ' . $userdata['user_id'] . "

AND post_postcount = 1

$forum_sql

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

$active_f_row = $db->sql_fetchrow($result);

$db->sql_freeresult($result);

WHERE poster_id = ' . $userdata['user_id'] . "

AND post_postcount = 1

$forum_sql

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

$active_t_row = $db->sql_fetchrow($result);

$db->sql_freeresult($result);

// but the extra size is only valuable if there are persons having more than a thousands posts.

// This is better left to the really really big forums.

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

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

case 'firebird':

$sql = 'SELECT *

FROM ' . SMILIES_TABLE . '

break;

// LENGTH supported by MySQL, IBM DB2, Oracle and Access for sure...

while (isset($word[0]))

{

|| !isset($word[$isset_min]))

{

/**

* changed whenever we change the length of search_wordlist.word_text

*

* Words shorter than $isset_min bytes are ignored, too

// These are fields required in the config table

return array(

'tpl' => $tpl,

);

}

}

/**

* UTF-8 aware alternative to strrpos

* Find position of last occurrence of a char in a string

*

* @author Harry Fuecks

* @param string haystack

* @param integer (optional) offset (from left)

* @return mixed integer position or FALSE on failure

*/

{

{

// Emulate behaviour of strrpos rather than raising warning

if (empty($str))

return mb_strrpos($str, $search);

}

{

{

}

}

}

'VCHAR:' => 'varchar(%d)',

'CHAR:' => 'char(%d)',

'XSTEXT' => 'text',

'STEXT' => 'text',

'TEXT' => 'text',

'TEXT_UNI' => 'text',

'MTEXT' => 'mediumtext',

'DECIMAL' => 'decimal(5,2)',

'VCHAR_UNI' => 'varchar(255)',

'VCHAR_UNI:'=> 'varchar(%d)',

'VARBINARY' => 'varbinary(255)',

),

'MTEXT_UNI' => 'mediumtext',

'TIMESTAMP' => 'int(11) UNSIGNED',

'DECIMAL' => 'decimal(5,2)',

'VCHAR_UNI:'=> array('varchar(%d)', 'limit' => array('mult', 3, 255, 'text')),

'VARBINARY' => 'varbinary(255)',

),

'TINT:' => 'INTEGER',

'USINT' => 'INTEGER',

'BOOL' => 'INTEGER',

'TIMESTAMP' => 'INTEGER',

'DECIMAL' => 'DOUBLE PRECISION',

),

'mssql' => array(

'STEXT' => '[varchar] (3000)',

'TEXT' => '[varchar] (8000)',

'MTEXT' => '[text]',

'TIMESTAMP' => '[int]',

'DECIMAL' => '[float]',

),

'oracle' => array(

'STEXT' => 'varchar2(3000)',

'TEXT' => 'clob',

'MTEXT' => 'clob',

'TEXT_UNI' => 'clob',

'MTEXT_UNI' => 'clob',

'TIMESTAMP' => 'number(11)',

'DECIMAL' => 'number(5, 2)',

'VARBINARY' => 'raw(255)',

),

'DECIMAL' => 'decimal(5,2)',

'VCHAR_UNI' => 'varchar(255)',

'VCHAR_UNI:'=> 'varchar(%d)',

'VARBINARY' => 'blob',

),

'STEXT' => 'varchar(3000)',

'TEXT' => 'varchar(8000)',

'MTEXT' => 'TEXT',

'MTEXT_UNI' => 'TEXT',

'TIMESTAMP' => 'INT4', // unsigned

'DECIMAL' => 'decimal(5,2)',

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

}

break;

case 'mssql':

{

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

}

break;

case 'mysqli':

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

}

break;

case 'oracle':

$sql = "SELECT *

#

# Table: 'phpbb_attachments'

CREATE TABLE phpbb_attachments (

attach_id INTEGER NOT NULL,

in_message INTEGER DEFAULT 0 NOT NULL,

poster_id INTEGER DEFAULT 0 NOT NULL,

is_orphan INTEGER DEFAULT 1 NOT NULL,

download_count INTEGER DEFAULT 0 NOT NULL,

filesize INTEGER DEFAULT 0 NOT NULL,

filetime INTEGER DEFAULT 0 NOT NULL,

thumbnail INTEGER DEFAULT 0 NOT NULL

# Table: 'phpbb_acl_options'

CREATE TABLE phpbb_acl_options (

auth_option_id INTEGER NOT NULL,

is_global INTEGER DEFAULT 0 NOT NULL,

is_local INTEGER DEFAULT 0 NOT NULL,

founder_only INTEGER DEFAULT 0 NOT NULL

# Table: 'phpbb_acl_roles'

CREATE TABLE phpbb_acl_roles (

role_id INTEGER NOT NULL,

role_order INTEGER DEFAULT 0 NOT NULL

);;

CREATE TABLE phpbb_banlist (

ban_id INTEGER NOT NULL,

ban_userid INTEGER DEFAULT 0 NOT NULL,

ban_start INTEGER DEFAULT 0 NOT NULL,

ban_end INTEGER DEFAULT 0 NOT NULL,

ban_exclude INTEGER DEFAULT 0 NOT NULL,

);;

ALTER TABLE phpbb_banlist ADD PRIMARY KEY (ban_id);;

# Table: 'phpbb_bbcodes'

CREATE TABLE phpbb_bbcodes (

bbcode_id INTEGER DEFAULT 0 NOT NULL,

display_on_posting INTEGER DEFAULT 0 NOT NULL,

);;

ALTER TABLE phpbb_bbcodes ADD PRIMARY KEY (bbcode_id);;

CREATE TABLE phpbb_bots (

bot_id INTEGER NOT NULL,

bot_active INTEGER DEFAULT 1 NOT NULL,

user_id INTEGER DEFAULT 0 NOT NULL,

);;

ALTER TABLE phpbb_bots ADD PRIMARY KEY (bot_id);;

# Table: 'phpbb_config'

CREATE TABLE phpbb_config (

is_dynamic INTEGER DEFAULT 0 NOT NULL

);;

# Table: 'phpbb_confirm'

CREATE TABLE phpbb_confirm (

confirm_type INTEGER DEFAULT 0 NOT NULL,

);;

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

# Table: 'phpbb_disallow'

CREATE TABLE phpbb_disallow (

disallow_id INTEGER NOT NULL,

);;

ALTER TABLE phpbb_disallow ADD PRIMARY KEY (disallow_id);;

topic_id INTEGER DEFAULT 0 NOT NULL,

forum_id INTEGER DEFAULT 0 NOT NULL,

save_time INTEGER DEFAULT 0 NOT NULL,

);;

ALTER TABLE phpbb_drafts ADD PRIMARY KEY (draft_id);;

CREATE TABLE phpbb_extensions (

extension_id INTEGER NOT NULL,

group_id INTEGER DEFAULT 0 NOT NULL,

);;

ALTER TABLE phpbb_extensions ADD PRIMARY KEY (extension_id);;

# Table: 'phpbb_extension_groups'

CREATE TABLE phpbb_extension_groups (

group_id INTEGER NOT NULL,

cat_id INTEGER DEFAULT 0 NOT NULL,

allow_group INTEGER DEFAULT 0 NOT NULL,

download_mode INTEGER DEFAULT 1 NOT NULL,

max_filesize INTEGER DEFAULT 0 NOT NULL,

allow_in_pm INTEGER DEFAULT 0 NOT NULL

);;

parent_id INTEGER DEFAULT 0 NOT NULL,

left_id INTEGER DEFAULT 0 NOT NULL,

right_id INTEGER DEFAULT 0 NOT NULL,

forum_desc_options INTEGER DEFAULT 7 NOT NULL,

forum_style INTEGER DEFAULT 0 NOT NULL,

forum_rules_options INTEGER DEFAULT 7 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_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_flags INTEGER DEFAULT 32 NOT NULL,

display_on_index INTEGER DEFAULT 1 NOT NULL,

enable_indexing INTEGER DEFAULT 1 NOT NULL,

CREATE TABLE phpbb_forums_access (

forum_id INTEGER DEFAULT 0 NOT NULL,

user_id INTEGER DEFAULT 0 NOT NULL,

);;

ALTER TABLE phpbb_forums_access ADD PRIMARY KEY (forum_id, user_id, session_id);;

CREATE TABLE phpbb_groups (

group_id INTEGER NOT NULL,

group_type INTEGER DEFAULT 1 NOT NULL,

group_desc_options INTEGER DEFAULT 7 NOT NULL,

group_display INTEGER DEFAULT 0 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_sig_chars INTEGER DEFAULT 0 NOT NULL,

group_receive_pm INTEGER DEFAULT 0 NOT NULL,

group_message_limit INTEGER DEFAULT 0 NOT NULL,

# Table: 'phpbb_icons'

CREATE TABLE phpbb_icons (

icons_id INTEGER NOT NULL,

icons_width INTEGER DEFAULT 0 NOT NULL,

icons_height INTEGER DEFAULT 0 NOT NULL,

icons_order INTEGER DEFAULT 0 NOT NULL,

# Table: 'phpbb_lang'

CREATE TABLE phpbb_lang (

lang_id INTEGER NOT NULL,

);;

ALTER TABLE phpbb_lang ADD PRIMARY KEY (lang_id);;

forum_id INTEGER DEFAULT 0 NOT NULL,

topic_id INTEGER DEFAULT 0 NOT NULL,

reportee_id INTEGER DEFAULT 0 NOT NULL,

log_time INTEGER DEFAULT 0 NOT NULL,

);;

ALTER TABLE phpbb_log ADD PRIMARY KEY (log_id);;

CREATE TABLE phpbb_moderator_cache (

forum_id INTEGER DEFAULT 0 NOT NULL,

user_id INTEGER DEFAULT 0 NOT NULL,

group_id INTEGER DEFAULT 0 NOT NULL,

display_on_index INTEGER DEFAULT 1 NOT NULL

);;

module_id INTEGER NOT NULL,

module_enabled INTEGER DEFAULT 1 NOT NULL,

module_display INTEGER DEFAULT 1 NOT NULL,

parent_id INTEGER DEFAULT 0 NOT NULL,

left_id INTEGER DEFAULT 0 NOT NULL,

right_id INTEGER DEFAULT 0 NOT NULL,

);;

ALTER TABLE phpbb_modules ADD PRIMARY KEY (module_id);;

CREATE TABLE phpbb_poll_options (

poll_option_id INTEGER DEFAULT 0 NOT NULL,

topic_id INTEGER DEFAULT 0 NOT NULL,

poll_option_total INTEGER DEFAULT 0 NOT NULL

);;

topic_id INTEGER DEFAULT 0 NOT NULL,

poll_option_id INTEGER DEFAULT 0 NOT NULL,

vote_user_id INTEGER DEFAULT 0 NOT NULL,

);;

CREATE INDEX phpbb_poll_votes_topic_id ON phpbb_poll_votes(topic_id);;

forum_id INTEGER DEFAULT 0 NOT NULL,

poster_id INTEGER DEFAULT 0 NOT NULL,

icon_id INTEGER DEFAULT 0 NOT NULL,

post_time INTEGER DEFAULT 0 NOT NULL,

post_approved INTEGER DEFAULT 1 NOT NULL,

post_reported INTEGER DEFAULT 0 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_attachment INTEGER DEFAULT 0 NOT NULL,

post_postcount INTEGER DEFAULT 1 NOT NULL,

post_edit_time INTEGER DEFAULT 0 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_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 GENERATOR phpbb_posts_gen;;

SET GENERATOR phpbb_posts_gen TO 0;;

root_level INTEGER DEFAULT 0 NOT NULL,

author_id INTEGER DEFAULT 0 NOT NULL,

icon_id INTEGER DEFAULT 0 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_edit_user INTEGER DEFAULT 0 NOT NULL,

message_attachment INTEGER DEFAULT 0 NOT NULL,

message_edit_time INTEGER DEFAULT 0 NOT NULL,

message_edit_count INTEGER DEFAULT 0 NOT NULL,

);;

ALTER TABLE phpbb_privmsgs ADD PRIMARY KEY (msg_id);;

CREATE TABLE phpbb_privmsgs_folder (

folder_id INTEGER NOT NULL,

user_id INTEGER DEFAULT 0 NOT NULL,

pm_count INTEGER DEFAULT 0 NOT NULL

);;

user_id INTEGER DEFAULT 0 NOT NULL,

rule_check INTEGER DEFAULT 0 NOT NULL,

rule_connection INTEGER DEFAULT 0 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,

# Table: 'phpbb_profile_fields'

CREATE TABLE phpbb_profile_fields (

field_id INTEGER NOT NULL,

field_type INTEGER DEFAULT 0 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,

lang_id INTEGER DEFAULT 0 NOT NULL,

option_id INTEGER DEFAULT 0 NOT NULL,

field_type INTEGER DEFAULT 0 NOT NULL,

);;

ALTER TABLE phpbb_profile_fields_lang ADD PRIMARY KEY (field_id, lang_id, option_id);;

CREATE TABLE phpbb_profile_lang (

field_id INTEGER DEFAULT 0 NOT NULL,

lang_id INTEGER DEFAULT 0 NOT NULL,

);;

ALTER TABLE phpbb_profile_lang ADD PRIMARY KEY (field_id, lang_id);;

# Table: 'phpbb_ranks'

CREATE TABLE phpbb_ranks (

rank_id INTEGER NOT NULL,

rank_min INTEGER DEFAULT 0 NOT NULL,

rank_special INTEGER DEFAULT 0 NOT NULL,

);;

ALTER TABLE phpbb_ranks ADD PRIMARY KEY (rank_id);;

user_notify INTEGER DEFAULT 0 NOT NULL,

report_closed INTEGER DEFAULT 0 NOT NULL,

report_time INTEGER DEFAULT 0 NOT NULL,

);;

ALTER TABLE phpbb_reports ADD PRIMARY KEY (report_id);;

# Table: 'phpbb_reports_reasons'

CREATE TABLE phpbb_reports_reasons (

reason_id INTEGER NOT NULL,

reason_order INTEGER DEFAULT 0 NOT NULL

);;

# Table: 'phpbb_search_results'

CREATE TABLE phpbb_search_results (

search_time INTEGER DEFAULT 0 NOT NULL,

);;

ALTER TABLE phpbb_search_results ADD PRIMARY KEY (search_key);;

# Table: 'phpbb_search_wordlist'

CREATE TABLE phpbb_search_wordlist (

word_id INTEGER NOT NULL,

word_common INTEGER DEFAULT 0 NOT NULL

);;

# Table: 'phpbb_sessions'

CREATE TABLE phpbb_sessions (

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_viewonline INTEGER DEFAULT 1 NOT NULL,

session_autologin INTEGER DEFAULT 0 NOT NULL,

session_admin INTEGER DEFAULT 0 NOT NULL

# Table: 'phpbb_sessions_keys'

CREATE TABLE phpbb_sessions_keys (

user_id INTEGER DEFAULT 0 NOT NULL,

last_login INTEGER DEFAULT 0 NOT NULL

);;

# Table: 'phpbb_sitelist'

CREATE TABLE phpbb_sitelist (

site_id INTEGER NOT NULL,

ip_exclude INTEGER DEFAULT 0 NOT NULL

);;

# Table: 'phpbb_smilies'

CREATE TABLE phpbb_smilies (

smiley_id INTEGER NOT NULL,

smiley_width INTEGER DEFAULT 0 NOT NULL,

smiley_height INTEGER DEFAULT 0 NOT NULL,

smiley_order INTEGER DEFAULT 0 NOT NULL,

# Table: 'phpbb_styles'

CREATE TABLE phpbb_styles (

style_id INTEGER NOT NULL,

style_active INTEGER DEFAULT 1 NOT NULL,

template_id INTEGER DEFAULT 0 NOT NULL,

theme_id INTEGER DEFAULT 0 NOT NULL,

# Table: 'phpbb_styles_template'

CREATE TABLE phpbb_styles_template (

template_id INTEGER NOT NULL,

template_storedb INTEGER DEFAULT 0 NOT NULL

);;

# Table: 'phpbb_styles_template_data'

CREATE TABLE phpbb_styles_template_data (

template_id INTEGER NOT NULL,

template_mtime INTEGER DEFAULT 0 NOT NULL,

);;

CREATE INDEX phpbb_styles_template_data_tid ON phpbb_styles_template_data(template_id);;

# Table: 'phpbb_styles_theme'

CREATE TABLE phpbb_styles_theme (

theme_id INTEGER NOT NULL,

theme_storedb INTEGER DEFAULT 0 NOT NULL,

theme_mtime INTEGER DEFAULT 0 NOT NULL,

);;

ALTER TABLE phpbb_styles_theme ADD PRIMARY KEY (theme_id);;

# Table: 'phpbb_styles_imageset'

CREATE TABLE phpbb_styles_imageset (

imageset_id INTEGER NOT NULL,

);;

ALTER TABLE phpbb_styles_imageset ADD PRIMARY KEY (imageset_id);;

topic_attachment INTEGER DEFAULT 0 NOT NULL,

topic_approved INTEGER DEFAULT 1 NOT NULL,

topic_reported INTEGER DEFAULT 0 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_status INTEGER DEFAULT 0 NOT NULL,

topic_type INTEGER DEFAULT 0 NOT NULL,

topic_first_post_id INTEGER DEFAULT 0 NOT NULL,

topic_last_post_id INTEGER DEFAULT 0 NOT NULL,

topic_last_poster_id INTEGER DEFAULT 0 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_start INTEGER DEFAULT 0 NOT NULL,

poll_length INTEGER DEFAULT 0 NOT NULL,

poll_max_options INTEGER DEFAULT 1 NOT NULL,

CREATE INDEX phpbb_topics_forum_id ON phpbb_topics(forum_id);;

CREATE INDEX phpbb_topics_forum_id_type ON phpbb_topics(forum_id, topic_type);;

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 GENERATOR phpbb_topics_gen;;

user_id INTEGER NOT NULL,

user_type INTEGER DEFAULT 0 NOT NULL,

group_id INTEGER DEFAULT 3 NOT NULL,

user_perm_from INTEGER DEFAULT 0 NOT NULL,

user_regdate INTEGER DEFAULT 0 NOT NULL,

user_passchg INTEGER DEFAULT 0 NOT NULL,

user_email_hash DOUBLE PRECISION DEFAULT 0 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_last_search INTEGER DEFAULT 0 NOT NULL,

user_warnings INTEGER DEFAULT 0 NOT NULL,

user_last_warning INTEGER DEFAULT 0 NOT NULL,

user_inactive_reason INTEGER DEFAULT 0 NOT NULL,

user_inactive_time INTEGER DEFAULT 0 NOT NULL,

user_posts INTEGER DEFAULT 0 NOT NULL,

user_timezone DOUBLE PRECISION DEFAULT 0 NOT NULL,

user_dst INTEGER DEFAULT 0 NOT NULL,

user_style INTEGER DEFAULT 0 NOT NULL,

user_rank INTEGER DEFAULT 0 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_full_folder INTEGER DEFAULT -3 NOT NULL,

user_emailtime INTEGER DEFAULT 0 NOT NULL,

user_topic_show_days INTEGER DEFAULT 0 NOT NULL,

user_post_show_days INTEGER DEFAULT 0 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_viewemail INTEGER DEFAULT 1 NOT NULL,

user_allow_massemail INTEGER DEFAULT 1 NOT NULL,

user_options INTEGER DEFAULT 893 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,

);;

ALTER TABLE phpbb_users ADD PRIMARY KEY (user_id);;

# Table: 'phpbb_words'

CREATE TABLE phpbb_words (

word_id INTEGER NOT NULL,

);;

ALTER TABLE phpbb_words ADD PRIMARY KEY (word_id);;

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

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

[download_count] [int] DEFAULT (0) 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

GO

ALTER TABLE [phpbb_attachments] WITH NOCHECK ADD

CREATE TABLE [phpbb_acl_roles] (

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

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

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

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

GO

ALTER TABLE [phpbb_acl_roles] WITH NOCHECK ADD

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

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

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

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

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

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

CREATE TABLE [phpbb_bots] (

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

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

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

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

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

GO

ALTER TABLE [phpbb_bots] WITH NOCHECK ADD

Table: 'phpbb_config'

*/

CREATE TABLE [phpbb_config] (

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

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

) ON [PRIMARY]

*/

CREATE TABLE [phpbb_disallow] (

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

) ON [PRIMARY]

GO

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

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

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

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

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

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

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

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

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

[forum_rules_options] [int] DEFAULT (7) NOT NULL ,

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

[forum_topics_per_page] [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_last_poster_colour] [varchar] (6) DEFAULT ('') NOT NULL ,

CREATE TABLE [phpbb_groups] (

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

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

[group_desc_options] [int] DEFAULT (7) NOT NULL ,

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

[group_display] [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

GO

ALTER TABLE [phpbb_groups] WITH NOCHECK ADD

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

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

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

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

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

CREATE TABLE [phpbb_moderator_cache] (

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

[user_id] [int] DEFAULT (0) 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 TABLE [phpbb_poll_options] (

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

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

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

GO

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

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

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

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

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

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

[post_attachment] [int] DEFAULT (0) 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_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_approved] ON [phpbb_posts]([post_approved]) ON [PRIMARY]

GO

GO

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

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

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

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

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

[message_attachment] [int] DEFAULT (0) 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 ,

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

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

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

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

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

GO

ALTER TABLE [phpbb_profile_lang] WITH NOCHECK ADD

*/

CREATE TABLE [phpbb_styles] (

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

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

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

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

*/

CREATE TABLE [phpbb_styles_template] (

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

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

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

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

) ON [PRIMARY]

GO

*/

CREATE TABLE [phpbb_styles_theme] (

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

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

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

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

*/

CREATE TABLE [phpbb_styles_imageset] (

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

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

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

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

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

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

[topic_reported] [int] DEFAULT (0) 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_last_poster_id] [int] DEFAULT (0) NOT NULL ,

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

[topic_last_poster_colour] [varchar] (6) 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_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

GO

ALTER TABLE [phpbb_topics] WITH NOCHECK ADD

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]

GO

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

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

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

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

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

[user_email] [varchar] (100) DEFAULT ('') 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_from] [varchar] (100) DEFAULT ('') NOT NULL ,

[user_icq] [varchar] (15) DEFAULT ('') NOT NULL ,

[user_aim] [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_actkey] [varchar] (32) DEFAULT ('') NOT NULL ,

[user_newpasswd] [varchar] (32) DEFAULT ('') NOT NULL

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

PRIMARY KEY (ban_id),

KEY ban_end (ban_end),

KEY ban_user (ban_userid, ban_exclude),

KEY ban_ip (ban_ip, ban_exclude)

);

# Table: 'phpbb_config'

CREATE TABLE phpbb_config (

config_value varchar(255) DEFAULT '' NOT NULL,

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

PRIMARY KEY (config_name),

forum_parents mediumtext DEFAULT '' NOT NULL,

forum_name text DEFAULT '' NOT NULL,

forum_desc text DEFAULT '' NOT NULL,

forum_desc_options int(11) UNSIGNED DEFAULT '7' NOT NULL,

forum_desc_uid varchar(5) DEFAULT '' NOT NULL,

forum_link text DEFAULT '' NOT NULL,

forum_image varchar(255) DEFAULT '' NOT NULL,

forum_rules text DEFAULT '' NOT NULL,

forum_rules_link text DEFAULT '' NOT NULL,

forum_rules_options int(11) UNSIGNED DEFAULT '7' NOT NULL,

forum_rules_uid varchar(5) DEFAULT '' NOT NULL,

forum_topics_per_page tinyint(4) DEFAULT '0' NOT NULL,

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

group_name text DEFAULT '' NOT NULL,

group_desc text DEFAULT '' NOT NULL,

group_desc_options int(11) UNSIGNED DEFAULT '7' NOT NULL,

group_desc_uid varchar(5) DEFAULT '' NOT NULL,

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

post_text mediumtext DEFAULT '' NOT NULL,

post_checksum varchar(32) DEFAULT '' NOT NULL,

post_attachment tinyint(1) UNSIGNED DEFAULT '0' 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,

KEY poster_ip (poster_ip),

KEY poster_id (poster_id),

KEY post_approved (post_approved),

);

message_edit_reason text DEFAULT '' NOT NULL,

message_edit_user mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

message_attachment tinyint(1) UNSIGNED DEFAULT '0' 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,

theme_id tinyint(4) DEFAULT '0' NOT NULL,

imageset_id tinyint(4) DEFAULT '0' NOT NULL,

PRIMARY KEY (style_id),

KEY template_id (template_id),

KEY theme_id (theme_id),

KEY imageset_id (imageset_id)

template_name text DEFAULT '' NOT NULL,

template_copyright text DEFAULT '' NOT NULL,

template_path varchar(100) DEFAULT '' NOT NULL,

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

PRIMARY KEY (template_id),

);

theme_mtime int(11) UNSIGNED DEFAULT '0' NOT NULL,

theme_data mediumtext DEFAULT '' NOT NULL,

PRIMARY KEY (theme_id),

);

user_icon9 varchar(200) DEFAULT '' NOT NULL,

user_icon10 varchar(200) DEFAULT '' NOT NULL,

PRIMARY KEY (imageset_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_avatar_height smallint(4) UNSIGNED DEFAULT '0' NOT NULL,

user_sig mediumtext DEFAULT '' NOT NULL,

user_sig_bbcode_uid varchar(5) DEFAULT '' NOT NULL,

user_from text DEFAULT '' NOT NULL,

user_icq varchar(15) DEFAULT '' NOT NULL,

user_aim text DEFAULT '' NOT NULL,

CREATE TABLE phpbb_bots (

bot_id mediumint(8) UNSIGNED NOT NULL auto_increment,

bot_active tinyint(1) UNSIGNED DEFAULT '1' 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,

# Table: 'phpbb_config'

CREATE TABLE phpbb_config (

config_value varchar(255) DEFAULT '' NOT NULL,

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

PRIMARY KEY (config_name),

# Table: 'phpbb_disallow'

CREATE TABLE phpbb_disallow (

disallow_id mediumint(8) UNSIGNED NOT NULL auto_increment,

PRIMARY KEY (disallow_id)

) CHARACTER SET `utf8` COLLATE `utf8_general_ci`;

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_message mediumtext DEFAULT '' NOT NULL,

PRIMARY KEY (draft_id),

KEY save_time (save_time)

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_desc text DEFAULT '' NOT NULL,

forum_desc_options int(11) UNSIGNED DEFAULT '7' NOT NULL,

forum_desc_uid varchar(5) DEFAULT '' NOT NULL,

forum_link varchar(255) DEFAULT '' 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_options int(11) UNSIGNED DEFAULT '7' NOT NULL,

forum_rules_uid varchar(5) DEFAULT '' NOT NULL,

forum_topics_per_page tinyint(4) 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_last_poster_colour varchar(6) DEFAULT '' NOT NULL,

CREATE TABLE phpbb_groups (

group_id mediumint(8) UNSIGNED NOT NULL auto_increment,

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

group_desc text DEFAULT '' NOT NULL,

group_desc_options int(11) UNSIGNED DEFAULT '7' NOT NULL,

group_desc_uid varchar(5) DEFAULT '' NOT NULL,

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

CREATE TABLE phpbb_moderator_cache (

forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

user_id mediumint(8) UNSIGNED DEFAULT '0' 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,

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_text mediumtext DEFAULT '' NOT NULL,

post_checksum varchar(32) DEFAULT '' NOT NULL,

post_attachment tinyint(1) UNSIGNED DEFAULT '0' 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_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,

KEY poster_ip (poster_ip),

KEY poster_id (poster_id),

KEY post_approved (post_approved),

) CHARACTER SET `utf8` COLLATE `utf8_general_ci`;

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_text mediumtext DEFAULT '' NOT NULL,

message_edit_user mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

message_attachment tinyint(1) UNSIGNED DEFAULT '0' 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,

# Table: 'phpbb_styles'

CREATE TABLE phpbb_styles (

style_id tinyint(4) NOT NULL auto_increment,

style_copyright varchar(255) DEFAULT '' NOT NULL,

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

template_id tinyint(4) DEFAULT '0' NOT NULL,

# Table: 'phpbb_styles_template'

CREATE TABLE phpbb_styles_template (

template_id tinyint(4) NOT NULL auto_increment,

template_copyright varchar(255) DEFAULT '' NOT NULL,

template_path varchar(100) DEFAULT '' NOT NULL,

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

PRIMARY KEY (template_id),

UNIQUE tmplte_nm (template_name)

# Table: 'phpbb_styles_theme'

CREATE TABLE phpbb_styles_theme (

theme_id tinyint(4) NOT NULL auto_increment,

theme_copyright varchar(255) DEFAULT '' NOT NULL,

theme_path varchar(100) DEFAULT '' NOT NULL,

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

# Table: 'phpbb_styles_imageset'

CREATE TABLE phpbb_styles_imageset (

imageset_id tinyint(4) NOT NULL auto_increment,

imageset_copyright varchar(255) DEFAULT '' NOT NULL,

imageset_path varchar(100) DEFAULT '' NOT NULL,

site_logo varchar(200) DEFAULT '' 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_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_last_poster_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

topic_last_poster_name varchar(255) DEFAULT '' NOT NULL,

topic_last_poster_colour varchar(6) 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_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,

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)

) CHARACTER SET `utf8` COLLATE `utf8_general_ci`;

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,

user_password varchar(40) DEFAULT '' NOT NULL,

user_passchg int(11) UNSIGNED DEFAULT '0' NOT NULL,

user_email varchar(100) DEFAULT '' NOT NULL,

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

user_sig mediumtext DEFAULT '' NOT NULL,

user_sig_bbcode_uid varchar(5) DEFAULT '' NOT NULL,

user_from varchar(100) DEFAULT '' NOT NULL,

user_icq varchar(15) DEFAULT '' NOT NULL,

user_aim varchar(255) DEFAULT '' NOT NULL,

*/

CREATE TABLE phpbb_acl_roles (

role_id number(8) NOT NULL,

role_description clob DEFAULT '' ,

role_type varchar2(10) DEFAULT '' ,

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

ban_id number(8) NOT NULL,

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

ban_ip varchar2(40) DEFAULT '' ,

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

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

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

CREATE TABLE phpbb_bots (

bot_id number(8) NOT NULL,

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

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

bot_agent varchar2(255) DEFAULT '' ,

bot_ip varchar2(255) DEFAULT '' ,

Table: 'phpbb_config'

*/

CREATE TABLE phpbb_config (

config_value varchar2(255) DEFAULT '' ,

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

CONSTRAINT pk_phpbb_config PRIMARY KEY (config_name)

*/

CREATE TABLE phpbb_disallow (

disallow_id number(8) NOT NULL,

CONSTRAINT pk_phpbb_disallow PRIMARY KEY (disallow_id)

)

/

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

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

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

draft_message clob DEFAULT '' ,

CONSTRAINT pk_phpbb_drafts PRIMARY KEY (draft_id)

)

*/

CREATE TABLE phpbb_extension_groups (

group_id number(8) NOT NULL,

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

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

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

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

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

forum_parents clob DEFAULT '' ,

forum_desc clob DEFAULT '' ,

forum_desc_options number(11) DEFAULT '7' NOT NULL,

forum_desc_uid varchar2(5) DEFAULT '' ,

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

forum_image varchar2(255) DEFAULT '' ,

forum_rules clob DEFAULT '' ,

forum_rules_options number(11) DEFAULT '7' NOT NULL,

forum_rules_uid varchar2(5) DEFAULT '' ,

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

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

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

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

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

forum_last_poster_colour varchar2(6) DEFAULT '' ,

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

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

CREATE TABLE phpbb_groups (

group_id number(8) NOT NULL,

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

group_desc clob DEFAULT '' ,

group_desc_options number(11) DEFAULT '7' NOT NULL,

group_desc_uid varchar2(5) DEFAULT '' ,

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

lang_id number(4) NOT NULL,

lang_iso varchar2(30) DEFAULT '' ,

lang_dir varchar2(30) DEFAULT '' ,

CONSTRAINT pk_phpbb_lang PRIMARY KEY (lang_id)

)

/

CREATE TABLE phpbb_moderator_cache (

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

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

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

display_on_index number(1) DEFAULT '1' NOT NULL

)

/

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

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

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

post_text clob DEFAULT '' ,

post_checksum varchar2(32) DEFAULT '' ,

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

bbcode_uid varchar2(5) DEFAULT '' ,

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

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

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

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

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

/

CREATE INDEX phpbb_posts_post_approved ON phpbb_posts (post_approved)

/

/

CREATE SEQUENCE phpbb_posts_seq

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

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

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

message_text clob DEFAULT '' ,

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

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

bbcode_uid varchar2(5) DEFAULT '' ,

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

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

CREATE TABLE phpbb_privmsgs_folder (

folder_id number(8) NOT NULL,

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

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

CONSTRAINT pk_phpbb_privmsgs_folder PRIMARY KEY (folder_id)

)

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

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

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

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

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

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

*/

CREATE TABLE phpbb_profile_fields (

field_id number(8) NOT NULL,

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

field_ident varchar2(20) DEFAULT '' ,

field_length varchar2(20) DEFAULT '' ,

field_minlen varchar2(255) DEFAULT '' ,

field_maxlen varchar2(255) DEFAULT '' ,

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

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

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

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

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

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

CONSTRAINT pk_phpbb_profile_fields_lang PRIMARY KEY (field_id, lang_id, option_id)

)

/

CREATE TABLE phpbb_profile_lang (

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

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

lang_explain clob DEFAULT '' ,

CONSTRAINT pk_phpbb_profile_lang PRIMARY KEY (field_id, lang_id)

)

/

*/

CREATE TABLE phpbb_ranks (

rank_id number(8) NOT NULL,

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

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

rank_image varchar2(255) DEFAULT '' ,

*/

CREATE TABLE phpbb_reports_reasons (

reason_id number(4) NOT NULL,

reason_description clob DEFAULT '' ,

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

CONSTRAINT pk_phpbb_reports_reasons PRIMARY KEY (reason_id)

*/

CREATE TABLE phpbb_search_wordlist (

word_id number(8) NOT NULL,

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

CONSTRAINT pk_phpbb_search_wordlist PRIMARY KEY (word_id),

CONSTRAINT u_phpbb_wrd_txt UNIQUE (word_text)

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

session_ip varchar2(40) DEFAULT '' ,

session_browser varchar2(150) DEFAULT '' ,

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

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

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

*/

CREATE TABLE phpbb_smilies (

smiley_id number(8) NOT NULL,

smiley_url varchar2(50) DEFAULT '' ,

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

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

*/

CREATE TABLE phpbb_styles (

style_id number(4) NOT NULL,

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

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

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

*/

CREATE TABLE phpbb_styles_template (

template_id number(4) NOT NULL,

template_path varchar2(100) DEFAULT '' ,

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

CONSTRAINT pk_phpbb_styles_template PRIMARY KEY (template_id),

CONSTRAINT u_phpbb_tmplte_nm UNIQUE (template_name)

*/

CREATE TABLE phpbb_styles_theme (

theme_id number(4) NOT NULL,

theme_path varchar2(100) DEFAULT '' ,

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

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

*/

CREATE TABLE phpbb_styles_imageset (

imageset_id number(4) NOT NULL,

imageset_path varchar2(100) DEFAULT '' ,

site_logo varchar2(200) DEFAULT '' ,

upload_bar varchar2(200) DEFAULT '' ,

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

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

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

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

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

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

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

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

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

topic_first_poster_colour varchar2(6) DEFAULT '' ,

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

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

topic_last_poster_colour varchar2(6) DEFAULT '' ,

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

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

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

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

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

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

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

poll_max_options number(4) DEFAULT '1' 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)

/

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

user_ip varchar2(40) DEFAULT '' ,

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

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

user_email_hash number(20) DEFAULT '0' NOT NULL,

user_birthday varchar2(10) DEFAULT '' ,

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

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

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

user_last_confirm_key varchar2(10) DEFAULT '' ,

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

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

user_lang varchar2(30) DEFAULT '' ,

user_timezone number(5, 2) DEFAULT '0' NOT NULL,

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

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

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

user_colour varchar2(6) DEFAULT '' ,

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

user_sig clob DEFAULT '' ,

user_sig_bbcode_uid varchar2(5) DEFAULT '' ,

user_icq varchar2(15) DEFAULT '' ,

user_interests clob DEFAULT '' ,

user_actkey varchar2(32) DEFAULT '' ,

CONSTRAINT pk_phpbb_users PRIMARY KEY (user_id)

)

/

*/

CREATE TABLE phpbb_words (

word_id number(8) NOT NULL,

CONSTRAINT pk_phpbb_words PRIMARY KEY (word_id)

)

/

/*

Domain definition

*/

/*

Operation Functions

physical_filename varchar(255) DEFAULT '' NOT NULL,

real_filename varchar(255) DEFAULT '' NOT NULL,

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

extension varchar(100) DEFAULT '' NOT NULL,

mimetype varchar(100) DEFAULT '' NOT NULL,

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

CREATE TABLE phpbb_acl_roles (

role_id INT4 DEFAULT nextval('phpbb_acl_roles_seq'),

role_name varchar(255) DEFAULT '' NOT NULL,

role_type varchar(10) DEFAULT '' NOT NULL,

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

PRIMARY KEY (role_id)

bbcode_tag varchar(16) DEFAULT '' NOT NULL,

bbcode_helpline varchar(255) DEFAULT '' NOT NULL,

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

bbcode_tpl TEXT DEFAULT '' NOT NULL,

first_pass_match TEXT DEFAULT '' NOT NULL,

first_pass_replace TEXT DEFAULT '' NOT NULL,

CREATE TABLE phpbb_bots (

bot_id INT4 DEFAULT nextval('phpbb_bots_seq'),

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

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

bot_agent varchar(255) DEFAULT '' NOT NULL,

bot_ip varchar(255) DEFAULT '' NOT NULL,

Table: 'phpbb_config'

*/

CREATE TABLE phpbb_config (

config_value varchar(255) DEFAULT '' NOT NULL,

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

PRIMARY KEY (config_name)

CREATE TABLE phpbb_disallow (

disallow_id INT4 DEFAULT nextval('phpbb_disallow_seq'),

PRIMARY KEY (disallow_id)

);

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

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

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

draft_message TEXT DEFAULT '' NOT NULL,

PRIMARY KEY (draft_id)

);

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

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

forum_parents TEXT DEFAULT '' NOT NULL,

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

forum_desc_uid varchar(5) DEFAULT '' NOT NULL,

forum_link varchar(255) DEFAULT '' NOT NULL,

forum_password varchar(40) DEFAULT '' NOT NULL,

forum_style INT2 DEFAULT '0' NOT NULL,

forum_image varchar(255) DEFAULT '' NOT NULL,

forum_rules_link varchar(255) DEFAULT '' NOT NULL,

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

forum_rules_uid varchar(5) DEFAULT '' NOT NULL,

forum_topics_per_page INT2 DEFAULT '0' NOT NULL,

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

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

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

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

forum_last_poster_name varchar(255) DEFAULT '' NOT NULL,

forum_last_poster_colour varchar(6) DEFAULT '' NOT NULL,

group_id INT4 DEFAULT nextval('phpbb_groups_seq'),

group_type INT2 DEFAULT '1' NOT NULL,

group_name varchar_ci DEFAULT '' NOT NULL,

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

group_desc_uid varchar(5) DEFAULT '' NOT NULL,

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

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

log_ip varchar(40) DEFAULT '' NOT NULL,

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

log_data TEXT DEFAULT '' NOT NULL,

PRIMARY KEY (log_id)

);

CREATE TABLE phpbb_moderator_cache (

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

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

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

group_name varchar(255) DEFAULT '' NOT NULL,

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

CREATE TABLE phpbb_poll_options (

poll_option_id INT2 DEFAULT '0' NOT NULL,

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

poll_option_total INT4 DEFAULT '0' NOT NULL CHECK (poll_option_total >= 0)

);

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

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

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

post_text TEXT DEFAULT '' NOT NULL,

post_checksum varchar(32) DEFAULT '' NOT NULL,

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

bbcode_uid varchar(5) DEFAULT '' NOT NULL,

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

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

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

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

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

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);

/*

Table: 'phpbb_privmsgs'

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

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

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

message_text TEXT DEFAULT '' NOT NULL,

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

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

bbcode_uid varchar(5) DEFAULT '' NOT NULL,

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

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

PRIMARY KEY (msg_id)

);

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

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

lang_name varchar(255) DEFAULT '' NOT NULL,

lang_default_value varchar(255) DEFAULT '' NOT NULL,

PRIMARY KEY (field_id, lang_id)

);

CREATE TABLE phpbb_styles (

style_id INT2 DEFAULT nextval('phpbb_styles_seq'),

style_copyright varchar(255) DEFAULT '' NOT NULL,

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

template_id INT2 DEFAULT '0' NOT NULL,

CREATE TABLE phpbb_styles_template (

template_id INT2 DEFAULT nextval('phpbb_styles_template_seq'),

template_copyright varchar(255) DEFAULT '' NOT NULL,

template_path varchar(100) DEFAULT '' NOT NULL,

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

PRIMARY KEY (template_id)

);

CREATE TABLE phpbb_styles_theme (

theme_id INT2 DEFAULT nextval('phpbb_styles_theme_seq'),

theme_copyright varchar(255) DEFAULT '' NOT NULL,

theme_path varchar(100) DEFAULT '' NOT NULL,

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

CREATE TABLE phpbb_styles_imageset (

imageset_id INT2 DEFAULT nextval('phpbb_styles_imageset_seq'),

imageset_copyright varchar(255) DEFAULT '' NOT NULL,

imageset_path varchar(100) DEFAULT '' NOT NULL,

site_logo varchar(200) DEFAULT '' NOT NULL,

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

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

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

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

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

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

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

topic_last_poster_name varchar(255) DEFAULT '' NOT NULL,

topic_last_poster_colour varchar(6) DEFAULT '' NOT NULL,

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

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

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

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

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

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

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

poll_max_options INT2 DEFAULT '1' NOT NULL,

CREATE INDEX phpbb_topics_forum_id ON phpbb_topics (forum_id);

CREATE INDEX phpbb_topics_forum_id_type ON phpbb_topics (forum_id, topic_type);

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);

/*

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

user_sig TEXT DEFAULT '' NOT NULL,

user_sig_bbcode_uid varchar(5) 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_jabber varchar(255) DEFAULT '' NOT NULL,

user_website varchar(200) DEFAULT '' NOT NULL,

user_occ varchar(255) DEFAULT '' NOT NULL,

user_actkey varchar(32) DEFAULT '' NOT NULL,

user_newpasswd varchar(32) DEFAULT '' NOT NULL,

PRIMARY KEY (user_id)

# Table: 'phpbb_config'

CREATE TABLE phpbb_config (

config_value varchar(255) NOT NULL DEFAULT '',

is_dynamic INTEGER UNSIGNED NOT NULL DEFAULT '0',

PRIMARY KEY (config_name)

# Table: 'phpbb_disallow'

CREATE TABLE phpbb_disallow (

disallow_id INTEGER PRIMARY KEY NOT NULL ,

);

forum_parents mediumtext(16777215) NOT NULL DEFAULT '',

forum_name text(65535) NOT NULL DEFAULT '',

forum_desc text(65535) NOT NULL DEFAULT '',

forum_desc_options INTEGER UNSIGNED NOT NULL DEFAULT '7',

forum_desc_uid varchar(5) NOT NULL DEFAULT '',

forum_link varchar(255) NOT NULL DEFAULT '',

forum_image varchar(255) NOT NULL DEFAULT '',

forum_rules text(65535) NOT NULL DEFAULT '',

forum_rules_link varchar(255) NOT NULL DEFAULT '',

forum_rules_options INTEGER UNSIGNED NOT NULL DEFAULT '7',

forum_rules_uid varchar(5) NOT NULL DEFAULT '',

forum_topics_per_page tinyint(4) NOT NULL DEFAULT '0',

CREATE TABLE phpbb_groups (

group_id INTEGER PRIMARY KEY NOT NULL ,

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

group_desc text(65535) NOT NULL DEFAULT '',

group_desc_options INTEGER UNSIGNED NOT NULL DEFAULT '7',

group_desc_uid varchar(5) NOT NULL DEFAULT '',

group_display INTEGER UNSIGNED NOT NULL DEFAULT '0',

CREATE TABLE phpbb_moderator_cache (

forum_id INTEGER UNSIGNED NOT NULL DEFAULT '0',

user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',

group_id INTEGER UNSIGNED NOT NULL DEFAULT '0',

group_name varchar(255) NOT NULL DEFAULT '',

display_on_index INTEGER UNSIGNED NOT NULL DEFAULT '1'

enable_smilies INTEGER UNSIGNED NOT NULL DEFAULT '1',

enable_magic_url INTEGER UNSIGNED NOT NULL DEFAULT '1',

enable_sig INTEGER UNSIGNED NOT NULL DEFAULT '1',

post_subject text(65535) NOT NULL DEFAULT '',

post_text mediumtext(16777215) NOT NULL DEFAULT '',

post_checksum varchar(32) NOT NULL DEFAULT '',

post_attachment INTEGER UNSIGNED NOT NULL DEFAULT '0',

bbcode_uid varchar(5) NOT NULL DEFAULT '',

post_postcount INTEGER UNSIGNED NOT NULL DEFAULT '1',

post_edit_time INTEGER UNSIGNED NOT NULL DEFAULT '0',

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);

# Table: 'phpbb_privmsgs'

CREATE TABLE phpbb_privmsgs (

message_edit_reason text(65535) NOT NULL DEFAULT '',

message_edit_user INTEGER UNSIGNED NOT NULL DEFAULT '0',

message_attachment INTEGER UNSIGNED NOT NULL DEFAULT '0',

bbcode_uid varchar(5) NOT NULL DEFAULT '',

message_edit_time INTEGER UNSIGNED NOT NULL DEFAULT '0',

message_edit_count INTEGER UNSIGNED NOT NULL DEFAULT '0',

# Table: 'phpbb_styles'

CREATE TABLE phpbb_styles (

style_id INTEGER PRIMARY KEY NOT NULL ,

style_copyright varchar(255) NOT NULL DEFAULT '',

style_active INTEGER UNSIGNED NOT NULL DEFAULT '1',

template_id tinyint(4) NOT NULL DEFAULT '0',

# Table: 'phpbb_styles_template'

CREATE TABLE phpbb_styles_template (

template_id INTEGER PRIMARY KEY NOT NULL ,

template_copyright varchar(255) NOT NULL DEFAULT '',

template_path varchar(100) NOT NULL DEFAULT '',

template_storedb INTEGER UNSIGNED NOT NULL DEFAULT '0'

);

# Table: 'phpbb_styles_theme'

CREATE TABLE phpbb_styles_theme (

theme_id INTEGER PRIMARY KEY NOT NULL ,

theme_copyright varchar(255) NOT NULL DEFAULT '',

theme_path varchar(100) NOT NULL DEFAULT '',

theme_storedb INTEGER UNSIGNED NOT NULL DEFAULT '0',

# Table: 'phpbb_styles_imageset'

CREATE TABLE phpbb_styles_imageset (

imageset_id INTEGER PRIMARY KEY NOT NULL ,

imageset_copyright varchar(255) NOT NULL DEFAULT '',

imageset_path varchar(100) NOT NULL DEFAULT '',

site_logo varchar(200) NOT NULL DEFAULT '',

CREATE INDEX phpbb_topics_forum_id ON phpbb_topics (forum_id);

CREATE INDEX phpbb_topics_forum_id_type ON phpbb_topics (forum_id, topic_type);

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);

# Table: 'phpbb_topics_track'

user_perm_from INTEGER UNSIGNED NOT NULL DEFAULT '0',

user_ip varchar(40) NOT NULL DEFAULT '',

user_regdate INTEGER UNSIGNED NOT NULL DEFAULT '0',

user_password varchar(40) NOT NULL DEFAULT '',

user_passchg INTEGER UNSIGNED NOT NULL DEFAULT '0',

user_email varchar(100) NOT NULL DEFAULT '',

user_avatar_height INTEGER UNSIGNED NOT NULL DEFAULT '0',

user_sig mediumtext(16777215) NOT NULL DEFAULT '',

user_sig_bbcode_uid varchar(5) NOT NULL DEFAULT '',

user_from varchar(100) NOT NULL DEFAULT '',

user_icq varchar(15) NOT NULL DEFAULT '',

user_aim varchar(255) NOT NULL DEFAULT '',

'INST_ERR_DB_NO_MYSQL4' => 'The version of MySQL installed on this machine is incompatible with the “MySQL 4.x/5.x” option you have selected. Please try the “MySQL 3.23.x/4.x” option instead.',

'INST_ERR_DB_NO_MYSQLI' => 'The version of MySQL installed on this machine is incompatible with the “MySQL 4.1.x/5.x with MySQLi Extension” option you have selected. Please try the “MySQL 3.23.x/4.x” option instead.',

'INST_ERR_DB_NO_ORACLE' => 'The version of Oracle installed on this machine requires you to set the <var>NLS_CHARACTERSET</var> parameter to <var>UTF8</var>. Either upgrade your installation to 9.2+ or change the parameter.',

'INST_ERR_DB_NO_POSTGRES' => 'The database you have selected was not created in <var>UNICODE</var> or <var>UTF8</var> encoding. Try installing with a database in <var>UNICODE</var> or <var>UTF8</var> encoding',

'INST_ERR_DB_NO_NAME' => 'No database name specified',

'INST_ERR_EMAIL_INVALID' => 'The email address you entered is invalid',