#

# $Id: firebird_schema.sql 9127 2008-11-26 19:58:35Z acydburn $

#

# Table: 'phpbb_attachments'

CREATE TABLE phpbb_attachments (

	attach_id INTEGER NOT NULL,

	post_msg_id INTEGER DEFAULT 0 NOT NULL,

	topic_id INTEGER DEFAULT 0 NOT NULL,

	in_message INTEGER DEFAULT 0 NOT NULL,

	poster_id INTEGER DEFAULT 0 NOT NULL,

	is_orphan INTEGER DEFAULT 1 NOT NULL,

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

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

	download_count INTEGER DEFAULT 0 NOT NULL,

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

	extension VARCHAR(100) CHARACTER SET NONE DEFAULT '' NOT NULL,

	mimetype VARCHAR(100) CHARACTER SET NONE DEFAULT '' NOT NULL,

	filesize INTEGER DEFAULT 0 NOT NULL,

	filetime INTEGER DEFAULT 0 NOT NULL,

	thumbnail INTEGER DEFAULT 0 NOT NULL

);;

ALTER TABLE phpbb_attachments ADD PRIMARY KEY (attach_id);;

CREATE INDEX phpbb_attachments_filetime ON phpbb_attachments(filetime);;

CREATE INDEX phpbb_attachments_post_msg_id ON phpbb_attachments(post_msg_id);;

CREATE INDEX phpbb_attachments_topic_id ON phpbb_attachments(topic_id);;

CREATE INDEX phpbb_attachments_poster_id ON phpbb_attachments(poster_id);;

CREATE INDEX phpbb_attachments_is_orphan ON phpbb_attachments(is_orphan);;

CREATE GENERATOR phpbb_attachments_gen;;

SET GENERATOR phpbb_attachments_gen TO 0;;

CREATE TRIGGER t_phpbb_attachments FOR phpbb_attachments

BEFORE INSERT

AS

BEGIN

	NEW.attach_id = GEN_ID(phpbb_attachments_gen, 1);

END;;

# Table: 'phpbb_acl_groups'

CREATE TABLE phpbb_acl_groups (

	group_id INTEGER DEFAULT 0 NOT NULL,

	forum_id INTEGER DEFAULT 0 NOT NULL,

	auth_option_id INTEGER DEFAULT 0 NOT NULL,

	auth_role_id INTEGER DEFAULT 0 NOT NULL,

	auth_setting INTEGER DEFAULT 0 NOT NULL

);;

CREATE INDEX phpbb_acl_groups_group_id ON phpbb_acl_groups(group_id);;

CREATE INDEX phpbb_acl_groups_auth_opt_id ON phpbb_acl_groups(auth_option_id);;

CREATE INDEX phpbb_acl_groups_auth_role_id ON phpbb_acl_groups(auth_role_id);;

# Table: 'phpbb_acl_options'

CREATE TABLE phpbb_acl_options (

	auth_option_id INTEGER NOT NULL,

	auth_option VARCHAR(50) CHARACTER SET NONE DEFAULT '' NOT NULL,

	is_global INTEGER DEFAULT 0 NOT NULL,

	is_local INTEGER DEFAULT 0 NOT NULL,

	founder_only INTEGER DEFAULT 0 NOT NULL

);;

ALTER TABLE phpbb_acl_options ADD PRIMARY KEY (auth_option_id);;

CREATE INDEX phpbb_acl_options_auth_option ON phpbb_acl_options(auth_option);;

CREATE GENERATOR phpbb_acl_options_gen;;

SET GENERATOR phpbb_acl_options_gen TO 0;;

CREATE TRIGGER t_phpbb_acl_options FOR phpbb_acl_options

BEFORE INSERT

AS

BEGIN

	NEW.auth_option_id = GEN_ID(phpbb_acl_options_gen, 1);

END;;

# Table: 'phpbb_acl_roles'

CREATE TABLE phpbb_acl_roles (

	role_id INTEGER NOT NULL,

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

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

	role_type VARCHAR(10) CHARACTER SET NONE DEFAULT '' NOT NULL,

	role_order INTEGER DEFAULT 0 NOT NULL

);;

ALTER TABLE phpbb_acl_roles ADD PRIMARY KEY (role_id);;

CREATE INDEX phpbb_acl_roles_role_type ON phpbb_acl_roles(role_type);;

CREATE INDEX phpbb_acl_roles_role_order ON phpbb_acl_roles(role_order);;

CREATE GENERATOR phpbb_acl_roles_gen;;

SET GENERATOR phpbb_acl_roles_gen TO 0;;

CREATE TRIGGER t_phpbb_acl_roles FOR phpbb_acl_roles

BEFORE INSERT

AS

BEGIN

	NEW.role_id = GEN_ID(phpbb_acl_roles_gen, 1);

END;;

# Table: 'phpbb_acl_roles_data'

CREATE TABLE phpbb_acl_roles_data (

	role_id INTEGER DEFAULT 0 NOT NULL,

	auth_option_id INTEGER DEFAULT 0 NOT NULL,

	auth_setting INTEGER DEFAULT 0 NOT NULL

);;

ALTER TABLE phpbb_acl_roles_data ADD PRIMARY KEY (role_id, auth_option_id);;

CREATE INDEX phpbb_acl_roles_data_ath_op_id ON phpbb_acl_roles_data(auth_option_id);;

# Table: 'phpbb_acl_users'

CREATE TABLE phpbb_acl_users (

	user_id INTEGER DEFAULT 0 NOT NULL,

	forum_id INTEGER DEFAULT 0 NOT NULL,

	auth_option_id INTEGER DEFAULT 0 NOT NULL,

	auth_role_id INTEGER DEFAULT 0 NOT NULL,

	auth_setting INTEGER DEFAULT 0 NOT NULL

);;

CREATE INDEX phpbb_acl_users_user_id ON phpbb_acl_users(user_id);;

CREATE INDEX phpbb_acl_users_auth_option_id ON phpbb_acl_users(auth_option_id);;

CREATE INDEX phpbb_acl_users_auth_role_id ON phpbb_acl_users(auth_role_id);;

# Table: 'phpbb_banlist'

CREATE TABLE phpbb_banlist (

	ban_id INTEGER NOT NULL,

	ban_userid INTEGER DEFAULT 0 NOT NULL,

	ban_ip VARCHAR(40) CHARACTER SET NONE DEFAULT '' NOT NULL,

	ban_email VARCHAR(100) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,

	ban_start INTEGER DEFAULT 0 NOT NULL,

	ban_end INTEGER DEFAULT 0 NOT NULL,

	ban_exclude INTEGER DEFAULT 0 NOT NULL,

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

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

);;

ALTER TABLE phpbb_banlist ADD PRIMARY KEY (ban_id);;

CREATE INDEX phpbb_banlist_ban_end ON phpbb_banlist(ban_end);;

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

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

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

CREATE GENERATOR phpbb_banlist_gen;;

SET GENERATOR phpbb_banlist_gen TO 0;;

CREATE TRIGGER t_phpbb_banlist FOR phpbb_banlist

BEFORE INSERT

AS

BEGIN

	NEW.ban_id = GEN_ID(phpbb_banlist_gen, 1);

END;;

# Table: 'phpbb_bbcodes'

CREATE TABLE phpbb_bbcodes (

	bbcode_id INTEGER DEFAULT 0 NOT NULL,

	bbcode_tag VARCHAR(16) CHARACTER SET NONE DEFAULT '' NOT NULL,

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

	display_on_posting INTEGER DEFAULT 0 NOT NULL,

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

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

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

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

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

	second_pass_replace BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL

);;

ALTER TABLE phpbb_bbcodes ADD PRIMARY KEY (bbcode_id);;

CREATE INDEX phpbb_bbcodes_display_on_post ON phpbb_bbcodes(display_on_posting);;

# Table: 'phpbb_bookmarks'

CREATE TABLE phpbb_bookmarks (

	topic_id INTEGER DEFAULT 0 NOT NULL,

	user_id INTEGER DEFAULT 0 NOT NULL

);;

ALTER TABLE phpbb_bookmarks ADD PRIMARY KEY (topic_id, user_id);;

# Table: 'phpbb_bots'

CREATE TABLE phpbb_bots (

	bot_id INTEGER NOT NULL,

	bot_active INTEGER DEFAULT 1 NOT NULL,

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

	user_id INTEGER DEFAULT 0 NOT NULL,

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

	bot_ip VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL

);;

ALTER TABLE phpbb_bots ADD PRIMARY KEY (bot_id);;

CREATE INDEX phpbb_bots_bot_active ON phpbb_bots(bot_active);;

CREATE GENERATOR phpbb_bots_gen;;

SET GENERATOR phpbb_bots_gen TO 0;;

CREATE TRIGGER t_phpbb_bots FOR phpbb_bots

BEFORE INSERT

AS

BEGIN

	NEW.bot_id = GEN_ID(phpbb_bots_gen, 1);

END;;

# Table: 'phpbb_config'

CREATE TABLE phpbb_config (

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

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

	is_dynamic INTEGER DEFAULT 0 NOT NULL

);;

ALTER TABLE phpbb_config ADD PRIMARY KEY (config_name);;

CREATE INDEX phpbb_config_is_dynamic ON phpbb_config(is_dynamic);;

# Table: 'phpbb_confirm'

CREATE TABLE phpbb_confirm (

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

	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,

	seed INTEGER DEFAULT 0 NOT NULL

);;

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

CREATE INDEX phpbb_confirm_confirm_type ON phpbb_confirm(confirm_type);;

# Table: 'phpbb_disallow'

CREATE TABLE phpbb_disallow (

	disallow_id INTEGER NOT NULL,

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

);;

ALTER TABLE phpbb_disallow ADD PRIMARY KEY (disallow_id);;

CREATE GENERATOR phpbb_disallow_gen;;

SET GENERATOR phpbb_disallow_gen TO 0;;

CREATE TRIGGER t_phpbb_disallow FOR phpbb_disallow

BEFORE INSERT

AS

BEGIN

	NEW.disallow_id = GEN_ID(phpbb_disallow_gen, 1);

END;;

# Table: 'phpbb_drafts'

CREATE TABLE phpbb_drafts (

	draft_id INTEGER NOT NULL,

	user_id INTEGER DEFAULT 0 NOT NULL,

	topic_id INTEGER DEFAULT 0 NOT NULL,

	forum_id INTEGER DEFAULT 0 NOT NULL,

	save_time INTEGER DEFAULT 0 NOT NULL,

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

	draft_message BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL

);;

ALTER TABLE phpbb_drafts ADD PRIMARY KEY (draft_id);;

CREATE INDEX phpbb_drafts_save_time ON phpbb_drafts(save_time);;

CREATE GENERATOR phpbb_drafts_gen;;

SET GENERATOR phpbb_drafts_gen TO 0;;

CREATE TRIGGER t_phpbb_drafts FOR phpbb_drafts

BEFORE INSERT

AS

BEGIN

	NEW.draft_id = GEN_ID(phpbb_drafts_gen, 1);

END;;

# Table: 'phpbb_extensions'

CREATE TABLE phpbb_extensions (

	extension_id INTEGER NOT NULL,

	group_id INTEGER DEFAULT 0 NOT NULL,

	extension VARCHAR(100) CHARACTER SET NONE DEFAULT '' NOT NULL

);;

ALTER TABLE phpbb_extensions ADD PRIMARY KEY (extension_id);;

CREATE GENERATOR phpbb_extensions_gen;;

SET GENERATOR phpbb_extensions_gen TO 0;;

CREATE TRIGGER t_phpbb_extensions FOR phpbb_extensions

BEFORE INSERT

AS

BEGIN

	NEW.extension_id = GEN_ID(phpbb_extensions_gen, 1);

END;;

# Table: 'phpbb_extension_groups'

CREATE TABLE phpbb_extension_groups (

	group_id INTEGER NOT NULL,

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

	cat_id INTEGER DEFAULT 0 NOT NULL,

	allow_group INTEGER DEFAULT 0 NOT NULL,

	download_mode INTEGER DEFAULT 1 NOT NULL,

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

	max_filesize INTEGER DEFAULT 0 NOT NULL,

	allowed_forums BLOB SUB_TYPE TEXT CHARACTER SET NONE DEFAULT '' NOT NULL,

	allow_in_pm INTEGER DEFAULT 0 NOT NULL

);;

ALTER TABLE phpbb_extension_groups ADD PRIMARY KEY (group_id);;

CREATE GENERATOR phpbb_extension_groups_gen;;

SET GENERATOR phpbb_extension_groups_gen TO 0;;

CREATE TRIGGER t_phpbb_extension_groups FOR phpbb_extension_groups

BEFORE INSERT

AS

BEGIN

	NEW.group_id = GEN_ID(phpbb_extension_groups_gen, 1);

END;;

# Table: 'phpbb_forums'

CREATE TABLE phpbb_forums (

	forum_id INTEGER NOT NULL,

	parent_id INTEGER DEFAULT 0 NOT NULL,

	left_id INTEGER DEFAULT 0 NOT NULL,

	right_id INTEGER DEFAULT 0 NOT NULL,

	forum_parents BLOB SUB_TYPE TEXT CHARACTER SET NONE DEFAULT '' NOT NULL,

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

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

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

	forum_desc_options INTEGER DEFAULT 7 NOT NULL,

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

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

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

	forum_style INTEGER DEFAULT 0 NOT NULL,

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

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

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

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

	forum_rules_options INTEGER DEFAULT 7 NOT NULL,

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

	forum_topics_per_page INTEGER DEFAULT 0 NOT NULL,

	forum_type INTEGER DEFAULT 0 NOT NULL,

	forum_status INTEGER DEFAULT 0 NOT NULL,

	forum_posts INTEGER DEFAULT 0 NOT NULL,

	forum_topics INTEGER DEFAULT 0 NOT NULL,

	forum_topics_real INTEGER DEFAULT 0 NOT NULL,

	forum_last_post_id INTEGER DEFAULT 0 NOT NULL,

	forum_last_poster_id INTEGER DEFAULT 0 NOT NULL,

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

	forum_last_post_time INTEGER DEFAULT 0 NOT NULL,

	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,

	enable_icons INTEGER DEFAULT 1 NOT NULL,

	enable_prune INTEGER DEFAULT 0 NOT NULL,

	prune_next INTEGER DEFAULT 0 NOT NULL,

	prune_days INTEGER DEFAULT 0 NOT NULL,

	prune_viewed INTEGER DEFAULT 0 NOT NULL,

	prune_freq INTEGER DEFAULT 0 NOT NULL

);;

ALTER TABLE phpbb_forums ADD PRIMARY KEY (forum_id);;

CREATE INDEX phpbb_forums_left_right_id ON phpbb_forums(left_id, right_id);;

CREATE INDEX phpbb_forums_forum_lastpost_id ON phpbb_forums(forum_last_post_id);;

CREATE GENERATOR phpbb_forums_gen;;

SET GENERATOR phpbb_forums_gen TO 0;;

CREATE TRIGGER t_phpbb_forums FOR phpbb_forums

BEFORE INSERT

AS

BEGIN

	NEW.forum_id = GEN_ID(phpbb_forums_gen, 1);

END;;

# Table: 'phpbb_forums_access'

CREATE TABLE phpbb_forums_access (

	forum_id INTEGER DEFAULT 0 NOT NULL,

	user_id INTEGER DEFAULT 0 NOT NULL,

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

);;

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

# Table: 'phpbb_forums_track'

CREATE TABLE phpbb_forums_track (

	user_id INTEGER DEFAULT 0 NOT NULL,

	forum_id INTEGER DEFAULT 0 NOT NULL,

	mark_time INTEGER DEFAULT 0 NOT NULL

);;

ALTER TABLE phpbb_forums_track ADD PRIMARY KEY (user_id, forum_id);;

# Table: 'phpbb_forums_watch'

CREATE TABLE phpbb_forums_watch (

	forum_id INTEGER DEFAULT 0 NOT NULL,

	user_id INTEGER DEFAULT 0 NOT NULL,

	notify_status INTEGER DEFAULT 0 NOT NULL

);;

CREATE INDEX phpbb_forums_watch_forum_id ON phpbb_forums_watch(forum_id);;

CREATE INDEX phpbb_forums_watch_user_id ON phpbb_forums_watch(user_id);;

CREATE INDEX phpbb_forums_watch_notify_stat ON phpbb_forums_watch(notify_status);;

# Table: 'phpbb_groups'

CREATE TABLE phpbb_groups (

	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,

	group_desc_options INTEGER DEFAULT 7 NOT NULL,

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

	group_display INTEGER DEFAULT 0 NOT NULL,

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

	group_avatar_type INTEGER DEFAULT 0 NOT NULL,

	group_avatar_width INTEGER DEFAULT 0 NOT NULL,

	group_avatar_height INTEGER DEFAULT 0 NOT NULL,

	group_rank INTEGER DEFAULT 0 NOT NULL,

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

	group_sig_chars INTEGER DEFAULT 0 NOT NULL,

	group_receive_pm INTEGER DEFAULT 0 NOT NULL,

	group_message_limit INTEGER DEFAULT 0 NOT NULL,

	group_max_recipients INTEGER DEFAULT 0 NOT NULL,

	group_legend INTEGER DEFAULT 1 NOT NULL

);;

ALTER TABLE phpbb_groups ADD PRIMARY KEY (group_id);;

CREATE INDEX phpbb_groups_group_legend_name ON phpbb_groups(group_legend, group_name);;

CREATE GENERATOR phpbb_groups_gen;;

SET GENERATOR phpbb_groups_gen TO 0;;

CREATE TRIGGER t_phpbb_groups FOR phpbb_groups

BEFORE INSERT

AS

BEGIN

	NEW.group_id = GEN_ID(phpbb_groups_gen, 1);

END;;

# Table: 'phpbb_icons'

CREATE TABLE phpbb_icons (

	icons_id INTEGER NOT NULL,

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

	icons_width INTEGER DEFAULT 0 NOT NULL,

	icons_height INTEGER DEFAULT 0 NOT NULL,

	icons_order INTEGER DEFAULT 0 NOT NULL,

	display_on_posting INTEGER DEFAULT 1 NOT NULL

);;

ALTER TABLE phpbb_icons ADD PRIMARY KEY (icons_id);;

CREATE INDEX phpbb_icons_display_on_posting ON phpbb_icons(display_on_posting);;

CREATE GENERATOR phpbb_icons_gen;;

SET GENERATOR phpbb_icons_gen TO 0;;

CREATE TRIGGER t_phpbb_icons FOR phpbb_icons

BEFORE INSERT

AS

BEGIN

	NEW.icons_id = GEN_ID(phpbb_icons_gen, 1);

END;;

# Table: 'phpbb_lang'

CREATE TABLE phpbb_lang (

	lang_id INTEGER NOT NULL,

	lang_iso VARCHAR(30) CHARACTER SET NONE DEFAULT '' NOT NULL,

	lang_dir VARCHAR(30) CHARACTER SET NONE DEFAULT '' NOT NULL,

	lang_english_name VARCHAR(100) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,

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

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

);;

ALTER TABLE phpbb_lang ADD PRIMARY KEY (lang_id);;

CREATE INDEX phpbb_lang_lang_iso ON phpbb_lang(lang_iso);;

CREATE GENERATOR phpbb_lang_gen;;

SET GENERATOR phpbb_lang_gen TO 0;;

CREATE TRIGGER t_phpbb_lang FOR phpbb_lang

BEFORE INSERT

AS

BEGIN

	NEW.lang_id = GEN_ID(phpbb_lang_gen, 1);

END;;

# Table: 'phpbb_log'

CREATE TABLE phpbb_log (

	log_id INTEGER NOT NULL,

	log_type INTEGER DEFAULT 0 NOT NULL,

	user_id INTEGER DEFAULT 0 NOT NULL,

	forum_id INTEGER DEFAULT 0 NOT NULL,

	topic_id INTEGER DEFAULT 0 NOT NULL,

	reportee_id INTEGER DEFAULT 0 NOT NULL,

	log_ip VARCHAR(40) CHARACTER SET NONE DEFAULT '' NOT NULL,

	log_time INTEGER DEFAULT 0 NOT NULL,

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

	log_data BLOB SUB_TYPE TEXT CHARACTER SET UTF8 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_log_user_id ON phpbb_log(user_id);;

CREATE GENERATOR phpbb_log_gen;;

SET GENERATOR phpbb_log_gen TO 0;;

CREATE TRIGGER t_phpbb_log FOR phpbb_log

BEFORE INSERT

AS

BEGIN

	NEW.log_id = GEN_ID(phpbb_log_gen, 1);

END;;

# Table: 'phpbb_moderator_cache'

CREATE TABLE phpbb_moderator_cache (

	forum_id INTEGER DEFAULT 0 NOT NULL,

	user_id INTEGER DEFAULT 0 NOT NULL,

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

	group_id INTEGER DEFAULT 0 NOT NULL,

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

	display_on_index INTEGER DEFAULT 1 NOT NULL

);;

CREATE INDEX phpbb_moderator_cache_disp_idx ON phpbb_moderator_cache(display_on_index);;

CREATE INDEX phpbb_moderator_cache_forum_id ON phpbb_moderator_cache(forum_id);;

# Table: 'phpbb_modules'

CREATE TABLE phpbb_modules (

	module_id INTEGER NOT NULL,

	module_enabled INTEGER DEFAULT 1 NOT NULL,

	module_display INTEGER DEFAULT 1 NOT NULL,

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

	module_class VARCHAR(10) CHARACTER SET NONE DEFAULT '' NOT NULL,

	parent_id INTEGER DEFAULT 0 NOT NULL,

	left_id INTEGER DEFAULT 0 NOT NULL,

	right_id INTEGER DEFAULT 0 NOT NULL,

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

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

	module_auth VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL

);;

ALTER TABLE phpbb_modules ADD PRIMARY KEY (module_id);;

CREATE INDEX phpbb_modules_left_right_id ON phpbb_modules(left_id, right_id);;

CREATE INDEX phpbb_modules_module_enabled ON phpbb_modules(module_enabled);;

CREATE INDEX phpbb_modules_class_left_id ON phpbb_modules(module_class, left_id);;

CREATE GENERATOR phpbb_modules_gen;;

SET GENERATOR phpbb_modules_gen TO 0;;

CREATE TRIGGER t_phpbb_modules FOR phpbb_modules

BEFORE INSERT

AS

BEGIN

	NEW.module_id = GEN_ID(phpbb_modules_gen, 1);

END;;

# Table: 'phpbb_poll_options'

CREATE TABLE phpbb_poll_options (

	poll_option_id INTEGER DEFAULT 0 NOT NULL,

	topic_id INTEGER DEFAULT 0 NOT NULL,

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

	poll_option_total INTEGER DEFAULT 0 NOT NULL

);;

CREATE INDEX phpbb_poll_options_poll_opt_id ON phpbb_poll_options(poll_option_id);;

CREATE INDEX phpbb_poll_options_topic_id ON phpbb_poll_options(topic_id);;

# Table: 'phpbb_poll_votes'

CREATE TABLE phpbb_poll_votes (

	topic_id INTEGER DEFAULT 0 NOT NULL,

	poll_option_id INTEGER DEFAULT 0 NOT NULL,

	vote_user_id INTEGER DEFAULT 0 NOT NULL,

	vote_user_ip VARCHAR(40) CHARACTER SET NONE DEFAULT '' NOT NULL

);;

CREATE INDEX phpbb_poll_votes_topic_id ON phpbb_poll_votes(topic_id);;

CREATE INDEX phpbb_poll_votes_vote_user_id ON phpbb_poll_votes(vote_user_id);;

CREATE INDEX phpbb_poll_votes_vote_user_ip ON phpbb_poll_votes(vote_user_ip);;

# Table: 'phpbb_posts'

CREATE TABLE phpbb_posts (

	post_id INTEGER NOT NULL,

	topic_id INTEGER DEFAULT 0 NOT NULL,

	forum_id INTEGER DEFAULT 0 NOT NULL,

	poster_id INTEGER DEFAULT 0 NOT NULL,

	icon_id INTEGER DEFAULT 0 NOT NULL,

	poster_ip VARCHAR(40) CHARACTER SET NONE DEFAULT '' NOT NULL,

	post_time INTEGER DEFAULT 0 NOT NULL,

	post_approved INTEGER DEFAULT 1 NOT NULL,

	post_reported INTEGER DEFAULT 0 NOT NULL,

	enable_bbcode INTEGER DEFAULT 1 NOT NULL,

	enable_smilies INTEGER DEFAULT 1 NOT NULL,

	enable_magic_url INTEGER DEFAULT 1 NOT NULL,

	enable_sig INTEGER DEFAULT 1 NOT NULL,

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

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

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

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

	post_attachment INTEGER DEFAULT 0 NOT NULL,

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

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

	post_postcount INTEGER DEFAULT 1 NOT NULL,

	post_edit_time INTEGER DEFAULT 0 NOT NULL,

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

	post_edit_user INTEGER DEFAULT 0 NOT NULL,

	post_edit_count INTEGER DEFAULT 0 NOT NULL,

	post_edit_locked INTEGER DEFAULT 0 NOT NULL

);;

ALTER TABLE phpbb_posts ADD PRIMARY KEY (post_id);;

CREATE INDEX phpbb_posts_forum_id ON phpbb_posts(forum_id);;

CREATE INDEX phpbb_posts_topic_id ON phpbb_posts(topic_id);;

CREATE INDEX phpbb_posts_poster_ip ON phpbb_posts(poster_ip);;

CREATE INDEX phpbb_posts_poster_id ON phpbb_posts(poster_id);;

CREATE INDEX phpbb_posts_post_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;;

SET GENERATOR phpbb_posts_gen TO 0;;

CREATE TRIGGER t_phpbb_posts FOR phpbb_posts

BEFORE INSERT

AS

BEGIN

	NEW.post_id = GEN_ID(phpbb_posts_gen, 1);

END;;

# Table: 'phpbb_privmsgs'

CREATE TABLE phpbb_privmsgs (

	msg_id INTEGER NOT NULL,

	root_level INTEGER DEFAULT 0 NOT NULL,

	author_id INTEGER DEFAULT 0 NOT NULL,

	icon_id INTEGER DEFAULT 0 NOT NULL,

	author_ip VARCHAR(40) CHARACTER SET NONE DEFAULT '' NOT NULL,

	message_time INTEGER DEFAULT 0 NOT NULL,

	enable_bbcode INTEGER DEFAULT 1 NOT NULL,

	enable_smilies INTEGER DEFAULT 1 NOT NULL,

	enable_magic_url INTEGER DEFAULT 1 NOT NULL,

	enable_sig INTEGER DEFAULT 1 NOT NULL,

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

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

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

	message_edit_user INTEGER DEFAULT 0 NOT NULL,

	message_attachment INTEGER DEFAULT 0 NOT NULL,

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

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

	message_edit_time INTEGER DEFAULT 0 NOT NULL,

	message_edit_count INTEGER DEFAULT 0 NOT NULL,

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

	bcc_address BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL

);;

ALTER TABLE phpbb_privmsgs ADD PRIMARY KEY (msg_id);;

CREATE INDEX phpbb_privmsgs_author_ip ON phpbb_privmsgs(author_ip);;

CREATE INDEX phpbb_privmsgs_message_time ON phpbb_privmsgs(message_time);;

CREATE INDEX phpbb_privmsgs_author_id ON phpbb_privmsgs(author_id);;

CREATE INDEX phpbb_privmsgs_root_level ON phpbb_privmsgs(root_level);;

CREATE GENERATOR phpbb_privmsgs_gen;;

SET GENERATOR phpbb_privmsgs_gen TO 0;;

CREATE TRIGGER t_phpbb_privmsgs FOR phpbb_privmsgs

BEFORE INSERT

AS

BEGIN

	NEW.msg_id = GEN_ID(phpbb_privmsgs_gen, 1);

END;;

# Table: 'phpbb_privmsgs_folder'

CREATE TABLE phpbb_privmsgs_folder (

	folder_id INTEGER NOT NULL,

	user_id INTEGER DEFAULT 0 NOT NULL,

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

	pm_count INTEGER DEFAULT 0 NOT NULL

);;

ALTER TABLE phpbb_privmsgs_folder ADD PRIMARY KEY (folder_id);;

CREATE INDEX phpbb_privmsgs_folder_user_id ON phpbb_privmsgs_folder(user_id);;

CREATE GENERATOR phpbb_privmsgs_folder_gen;;