/*

 $Id: postgres_schema.sql 9129 2008-11-27 13:44:24Z acydburn $

*/

BEGIN;

/*

	Domain definition

*/

CREATE DOMAIN varchar_ci AS varchar(255) NOT NULL DEFAULT ''::character varying;

/*

	Operation Functions

*/

CREATE FUNCTION _varchar_ci_equal(varchar_ci, varchar_ci) RETURNS boolean AS 'SELECT LOWER($1) = LOWER($2)' LANGUAGE SQL STRICT;

CREATE FUNCTION _varchar_ci_not_equal(varchar_ci, varchar_ci) RETURNS boolean AS 'SELECT LOWER($1) != LOWER($2)' LANGUAGE SQL STRICT;

CREATE FUNCTION _varchar_ci_less_than(varchar_ci, varchar_ci) RETURNS boolean AS 'SELECT LOWER($1) < LOWER($2)' LANGUAGE SQL STRICT;

CREATE FUNCTION _varchar_ci_less_equal(varchar_ci, varchar_ci) RETURNS boolean AS 'SELECT LOWER($1) <= LOWER($2)' LANGUAGE SQL STRICT;

CREATE FUNCTION _varchar_ci_greater_than(varchar_ci, varchar_ci) RETURNS boolean AS 'SELECT LOWER($1) > LOWER($2)' LANGUAGE SQL STRICT;

CREATE FUNCTION _varchar_ci_greater_equals(varchar_ci, varchar_ci) RETURNS boolean AS 'SELECT LOWER($1) >= LOWER($2)' LANGUAGE SQL STRICT;

/*

	Operators

*/

CREATE OPERATOR <(

  PROCEDURE = _varchar_ci_less_than,

  LEFTARG = varchar_ci,

  RIGHTARG = varchar_ci,

  COMMUTATOR = >,

  NEGATOR = >=,

  RESTRICT = scalarltsel,

  JOIN = scalarltjoinsel);

CREATE OPERATOR <=(

  PROCEDURE = _varchar_ci_less_equal,

  LEFTARG = varchar_ci,

  RIGHTARG = varchar_ci,

  COMMUTATOR = >=,

  NEGATOR = >,

  RESTRICT = scalarltsel,

  JOIN = scalarltjoinsel);

CREATE OPERATOR >(

  PROCEDURE = _varchar_ci_greater_than,

  LEFTARG = varchar_ci,

  RIGHTARG = varchar_ci,

  COMMUTATOR = <,

  NEGATOR = <=,

  RESTRICT = scalargtsel,

  JOIN = scalargtjoinsel);

CREATE OPERATOR >=(

  PROCEDURE = _varchar_ci_greater_equals,

  LEFTARG = varchar_ci,

  RIGHTARG = varchar_ci,

  COMMUTATOR = <=,

  NEGATOR = <,

  RESTRICT = scalargtsel,

  JOIN = scalargtjoinsel);

CREATE OPERATOR <>(

  PROCEDURE = _varchar_ci_not_equal,

  LEFTARG = varchar_ci,

  RIGHTARG = varchar_ci,

  COMMUTATOR = <>,

  NEGATOR = =,

  RESTRICT = neqsel,

  JOIN = neqjoinsel);

CREATE OPERATOR =(

  PROCEDURE = _varchar_ci_equal,

  LEFTARG = varchar_ci,

  RIGHTARG = varchar_ci,

  COMMUTATOR = =,

  NEGATOR = <>,

  RESTRICT = eqsel,

  JOIN = eqjoinsel,

  HASHES,

  MERGES,

  SORT1= <);

/*

	Table: 'phpbb_attachments'

*/

CREATE SEQUENCE phpbb_attachments_seq;

CREATE TABLE phpbb_attachments (

	attach_id INT4 DEFAULT nextval('phpbb_attachments_seq'),

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

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

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

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

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

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

	attach_comment varchar(4000) DEFAULT '' NOT NULL,

	extension varchar(100) DEFAULT '' NOT NULL,

	mimetype varchar(100) DEFAULT '' NOT NULL,

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

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

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

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

/*

	Table: 'phpbb_acl_groups'

*/

CREATE TABLE phpbb_acl_groups (

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

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

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

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

	auth_setting INT2 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 SEQUENCE phpbb_acl_options_seq;

CREATE TABLE phpbb_acl_options (

	auth_option_id INT4 DEFAULT nextval('phpbb_acl_options_seq'),

	auth_option varchar(50) DEFAULT '' NOT NULL,

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

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

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

	PRIMARY KEY (auth_option_id)

);

CREATE INDEX phpbb_acl_options_auth_option ON phpbb_acl_options (auth_option);

/*

	Table: 'phpbb_acl_roles'

*/

CREATE SEQUENCE phpbb_acl_roles_seq;

CREATE TABLE phpbb_acl_roles (

	role_id INT4 DEFAULT nextval('phpbb_acl_roles_seq'),

	role_name varchar(255) DEFAULT '' NOT NULL,

	role_description varchar(4000) 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)

);

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

/*

	Table: 'phpbb_acl_roles_data'

*/

CREATE TABLE phpbb_acl_roles_data (

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

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

	auth_setting INT2 DEFAULT '0' NOT NULL,

	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 INT4 DEFAULT '0' NOT NULL CHECK (user_id >= 0),

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

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

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

	auth_setting INT2 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 SEQUENCE phpbb_banlist_seq;

CREATE TABLE phpbb_banlist (

	ban_id INT4 DEFAULT nextval('phpbb_banlist_seq'),

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

	ban_ip varchar(40) DEFAULT '' NOT NULL,

	ban_email varchar(100) DEFAULT '' NOT NULL,

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

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

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

	ban_reason varchar(255) DEFAULT '' NOT NULL,

	ban_give_reason varchar(255) DEFAULT '' NOT NULL,

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

/*

	Table: 'phpbb_bbcodes'

*/

CREATE TABLE phpbb_bbcodes (

	bbcode_id INT2 DEFAULT '0' NOT NULL,

	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_match varchar(4000) DEFAULT '' NOT NULL,

	bbcode_tpl TEXT DEFAULT '' NOT NULL,

	first_pass_match TEXT DEFAULT '' NOT NULL,

	first_pass_replace TEXT DEFAULT '' NOT NULL,

	second_pass_match TEXT DEFAULT '' NOT NULL,

	second_pass_replace TEXT DEFAULT '' NOT NULL,

	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 INT4 DEFAULT '0' NOT NULL CHECK (topic_id >= 0),

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

	PRIMARY KEY (topic_id, user_id)

);

/*

	Table: 'phpbb_bots'

*/

CREATE SEQUENCE phpbb_bots_seq;

CREATE TABLE phpbb_bots (

	bot_id INT4 DEFAULT nextval('phpbb_bots_seq'),

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

	bot_name varchar(255) DEFAULT '' NOT NULL,

	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,

	PRIMARY KEY (bot_id)

);

CREATE INDEX phpbb_bots_bot_active ON phpbb_bots (bot_active);

/*

	Table: 'phpbb_config'

*/

CREATE TABLE phpbb_config (

	config_name varchar(255) DEFAULT '' NOT NULL,

	config_value varchar(255) DEFAULT '' NOT NULL,

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

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

	session_id char(32) DEFAULT '' NOT NULL,

	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)

);

CREATE INDEX phpbb_confirm_confirm_type ON phpbb_confirm (confirm_type);

/*

	Table: 'phpbb_disallow'

*/

CREATE SEQUENCE phpbb_disallow_seq;

CREATE TABLE phpbb_disallow (

	disallow_id INT4 DEFAULT nextval('phpbb_disallow_seq'),

	disallow_username varchar(255) DEFAULT '' NOT NULL,

	PRIMARY KEY (disallow_id)

);

/*

	Table: 'phpbb_drafts'

*/

CREATE SEQUENCE phpbb_drafts_seq;

CREATE TABLE phpbb_drafts (

	draft_id INT4 DEFAULT nextval('phpbb_drafts_seq'),

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

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

	draft_message TEXT DEFAULT '' NOT NULL,

	PRIMARY KEY (draft_id)

);

CREATE INDEX phpbb_drafts_save_time ON phpbb_drafts (save_time);

/*

	Table: 'phpbb_extensions'

*/

CREATE SEQUENCE phpbb_extensions_seq;

CREATE TABLE phpbb_extensions (

	extension_id INT4 DEFAULT nextval('phpbb_extensions_seq'),

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

	extension varchar(100) DEFAULT '' NOT NULL,

	PRIMARY KEY (extension_id)

);

/*

	Table: 'phpbb_extension_groups'

*/

CREATE SEQUENCE phpbb_extension_groups_seq;

CREATE TABLE phpbb_extension_groups (

	group_id INT4 DEFAULT nextval('phpbb_extension_groups_seq'),

	group_name varchar(255) DEFAULT '' NOT NULL,

	cat_id INT2 DEFAULT '0' NOT NULL,

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

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

	upload_icon varchar(255) DEFAULT '' NOT NULL,

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

	allowed_forums varchar(8000) DEFAULT '' NOT NULL,

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

	PRIMARY KEY (group_id)

);

/*

	Table: 'phpbb_forums'

*/

CREATE SEQUENCE phpbb_forums_seq;

CREATE TABLE phpbb_forums (

	forum_id INT4 DEFAULT nextval('phpbb_forums_seq'),

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

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

	forum_desc varchar(4000) DEFAULT '' NOT NULL,

	forum_desc_bitfield varchar(255) DEFAULT '' NOT NULL,

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

	forum_desc_uid varchar(8) DEFAULT '' NOT NULL,

	forum_link varchar(255) DEFAULT '' NOT NULL,

	forum_password varchar(40) DEFAULT '' NOT NULL,

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

	forum_image varchar(255) DEFAULT '' NOT NULL,

	forum_rules varchar(4000) DEFAULT '' NOT NULL,

	forum_rules_link varchar(255) DEFAULT '' NOT NULL,

	forum_rules_bitfield varchar(255) DEFAULT '' NOT NULL,

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

	forum_rules_uid varchar(8) DEFAULT '' NOT NULL,

	forum_topics_per_page INT2 DEFAULT '0' NOT NULL,

	forum_type INT2 DEFAULT '0' NOT NULL,

	forum_status INT2 DEFAULT '0' NOT NULL,

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

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

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

	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,

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

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

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

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

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

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

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

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

/*

	Table: 'phpbb_forums_access'

*/

CREATE TABLE phpbb_forums_access (

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

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

	session_id char(32) DEFAULT '' NOT NULL,

	PRIMARY KEY (forum_id, user_id, session_id)

);

/*

	Table: 'phpbb_forums_track'

*/

CREATE TABLE phpbb_forums_track (

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

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

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

	PRIMARY KEY (user_id, forum_id)

);

/*

	Table: 'phpbb_forums_watch'

*/

CREATE TABLE phpbb_forums_watch (

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

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

	notify_status INT2 DEFAULT '0' NOT NULL CHECK (notify_status >= 0)

);

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 SEQUENCE phpbb_groups_seq;

CREATE TABLE phpbb_groups (

	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,

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

	group_desc_uid varchar(8) DEFAULT '' NOT NULL,

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

	group_avatar varchar(255) DEFAULT '' NOT NULL,

	group_avatar_type INT2 DEFAULT '0' NOT NULL,

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

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

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

	group_colour varchar(6) DEFAULT '' NOT NULL,

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

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

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

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

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

	PRIMARY KEY (group_id)

);

CREATE INDEX phpbb_groups_group_legend_name ON phpbb_groups (group_legend, group_name);

/*

	Table: 'phpbb_icons'

*/

CREATE SEQUENCE phpbb_icons_seq;

CREATE TABLE phpbb_icons (

	icons_id INT4 DEFAULT nextval('phpbb_icons_seq'),

	icons_url varchar(255) DEFAULT '' NOT NULL,

	icons_width INT2 DEFAULT '0' NOT NULL,

	icons_height INT2 DEFAULT '0' NOT NULL,

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

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

	PRIMARY KEY (icons_id)

);

CREATE INDEX phpbb_icons_display_on_posting ON phpbb_icons (display_on_posting);

/*

	Table: 'phpbb_lang'

*/

CREATE SEQUENCE phpbb_lang_seq;

CREATE TABLE phpbb_lang (

	lang_id INT2 DEFAULT nextval('phpbb_lang_seq'),

	lang_iso varchar(30) DEFAULT '' NOT NULL,

	lang_dir varchar(30) DEFAULT '' NOT NULL,

	lang_english_name varchar(100) DEFAULT '' NOT NULL,

	lang_local_name varchar(255) DEFAULT '' NOT NULL,

	lang_author varchar(255) DEFAULT '' NOT NULL,

	PRIMARY KEY (lang_id)

);

CREATE INDEX phpbb_lang_lang_iso ON phpbb_lang (lang_iso);

/*

	Table: 'phpbb_log'

*/

CREATE SEQUENCE phpbb_log_seq;

CREATE TABLE phpbb_log (

	log_id INT4 DEFAULT nextval('phpbb_log_seq'),

	log_type INT2 DEFAULT '0' NOT NULL,

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

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

	topic_id INT4 DEFAULT '0' NOT NULL CHECK (topic_id >= 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_operation varchar(4000) DEFAULT '' NOT NULL,

	log_data TEXT DEFAULT '' NOT NULL,

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

/*

	Table: 'phpbb_moderator_cache'

*/

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

	username varchar(255) DEFAULT '' NOT NULL,

	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 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 SEQUENCE phpbb_modules_seq;

CREATE TABLE phpbb_modules (

	module_id INT4 DEFAULT nextval('phpbb_modules_seq'),

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

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

	module_basename varchar(255) DEFAULT '' NOT NULL,

	module_class varchar(10) DEFAULT '' NOT NULL,

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

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

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

	module_langname varchar(255) DEFAULT '' NOT NULL,

	module_mode varchar(255) DEFAULT '' NOT NULL,

	module_auth varchar(255) DEFAULT '' NOT NULL,

	PRIMARY KEY (module_id)

);

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

/*

	Table: 'phpbb_poll_options'

*/

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_text varchar(4000) DEFAULT '' NOT NULL,

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

);

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 INT4 DEFAULT '0' NOT NULL CHECK (topic_id >= 0),

	poll_option_id INT2 DEFAULT '0' NOT NULL,

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

	vote_user_ip varchar(40) 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 SEQUENCE phpbb_posts_seq;

CREATE TABLE phpbb_posts (

	post_id INT4 DEFAULT nextval('phpbb_posts_seq'),

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

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

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

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

	poster_ip varchar(40) DEFAULT '' NOT NULL,

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

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

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

	enable_bbcode INT2 DEFAULT '1' NOT NULL CHECK (enable_bbcode >= 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_username varchar(255) DEFAULT '' NOT NULL,

	post_subject varchar(255) DEFAULT '' NOT NULL,

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

	bbcode_uid varchar(8) 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_reason varchar(255) DEFAULT '' NOT NULL,

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

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

/*

	Table: 'phpbb_privmsgs'

*/

CREATE SEQUENCE phpbb_privmsgs_seq;

CREATE TABLE phpbb_privmsgs (

	msg_id INT4 DEFAULT nextval('phpbb_privmsgs_seq'),

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

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

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

	author_ip varchar(40) DEFAULT '' NOT NULL,

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

	enable_bbcode INT2 DEFAULT '1' NOT NULL CHECK (enable_bbcode >= 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),

	message_subject varchar(255) DEFAULT '' NOT NULL,

	message_text TEXT DEFAULT '' NOT NULL,

	message_edit_reason varchar(255) 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_bitfield varchar(255) DEFAULT '' NOT NULL,

	bbcode_uid varchar(8) 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),

	to_address varchar(4000) DEFAULT '' NOT NULL,

	bcc_address varchar(4000) DEFAULT '' NOT NULL,

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

/*

	Table: 'phpbb_privmsgs_folder'

*/

CREATE SEQUENCE phpbb_privmsgs_folder_seq;

CREATE TABLE phpbb_privmsgs_folder (

	folder_id INT4 DEFAULT nextval('phpbb_privmsgs_folder_seq'),

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

	folder_name varchar(255) DEFAULT '' NOT NULL,

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

	PRIMARY KEY (folder_id)

);

CREATE INDEX phpbb_privmsgs_folder_user_id ON phpbb_privmsgs_folder (user_id);

/*

	Table: 'phpbb_privmsgs_rules'

*/

CREATE SEQUENCE phpbb_privmsgs_rules_seq;

CREATE TABLE phpbb_privmsgs_rules (

	rule_id INT4 DEFAULT nextval('phpbb_privmsgs_rules_seq'),

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

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

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

	rule_string varchar(255) DEFAULT '' NOT NULL,

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

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

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

	rule_folder_id INT4 DEFAULT '0' NOT NULL,

	PRIMARY KEY (rule_id)

);

CREATE INDEX phpbb_privmsgs_rules_user_id ON phpbb_privmsgs_rules (user_id);

/*

	Table: 'phpbb_privmsgs_to'

*/

CREATE TABLE phpbb_privmsgs_to (

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

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

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

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

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

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

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

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

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

	folder_id INT4 DEFAULT '0' NOT NULL

);

CREATE INDEX phpbb_privmsgs_to_msg_id ON phpbb_privmsgs_to (msg_id);