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', '© 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);