Blame Identity/Webenv/phpBB/3.0.4/install/schemas/sqlite_schema.sql

ef5584
#
ef5584
# $Id: sqlite_schema.sql 9129 2008-11-27 13:44:24Z acydburn $
ef5584
#
ef5584
ef5584
BEGIN TRANSACTION;
ef5584
ef5584
# Table: 'phpbb_attachments'
ef5584
CREATE TABLE phpbb_attachments (
ef5584
	attach_id INTEGER PRIMARY KEY NOT NULL ,
ef5584
	post_msg_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	topic_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	in_message INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	poster_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	is_orphan INTEGER UNSIGNED NOT NULL DEFAULT '1',
ef5584
	physical_filename varchar(255) NOT NULL DEFAULT '',
ef5584
	real_filename varchar(255) NOT NULL DEFAULT '',
ef5584
	download_count INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	attach_comment text(65535) NOT NULL DEFAULT '',
ef5584
	extension varchar(100) NOT NULL DEFAULT '',
ef5584
	mimetype varchar(100) NOT NULL DEFAULT '',
ef5584
	filesize INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	filetime INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	thumbnail INTEGER UNSIGNED NOT NULL DEFAULT '0'
ef5584
);
ef5584
ef5584
CREATE INDEX phpbb_attachments_filetime ON phpbb_attachments (filetime);
ef5584
CREATE INDEX phpbb_attachments_post_msg_id ON phpbb_attachments (post_msg_id);
ef5584
CREATE INDEX phpbb_attachments_topic_id ON phpbb_attachments (topic_id);
ef5584
CREATE INDEX phpbb_attachments_poster_id ON phpbb_attachments (poster_id);
ef5584
CREATE INDEX phpbb_attachments_is_orphan ON phpbb_attachments (is_orphan);
ef5584
ef5584
# Table: 'phpbb_acl_groups'
ef5584
CREATE TABLE phpbb_acl_groups (
ef5584
	group_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	forum_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	auth_option_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	auth_role_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	auth_setting tinyint(2) NOT NULL DEFAULT '0'
ef5584
);
ef5584
ef5584
CREATE INDEX phpbb_acl_groups_group_id ON phpbb_acl_groups (group_id);
ef5584
CREATE INDEX phpbb_acl_groups_auth_opt_id ON phpbb_acl_groups (auth_option_id);
ef5584
CREATE INDEX phpbb_acl_groups_auth_role_id ON phpbb_acl_groups (auth_role_id);
ef5584
ef5584
# Table: 'phpbb_acl_options'
ef5584
CREATE TABLE phpbb_acl_options (
ef5584
	auth_option_id INTEGER PRIMARY KEY NOT NULL ,
ef5584
	auth_option varchar(50) NOT NULL DEFAULT '',
ef5584
	is_global INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	is_local INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	founder_only INTEGER UNSIGNED NOT NULL DEFAULT '0'
ef5584
);
ef5584
ef5584
CREATE INDEX phpbb_acl_options_auth_option ON phpbb_acl_options (auth_option);
ef5584
ef5584
# Table: 'phpbb_acl_roles'
ef5584
CREATE TABLE phpbb_acl_roles (
ef5584
	role_id INTEGER PRIMARY KEY NOT NULL ,
ef5584
	role_name varchar(255) NOT NULL DEFAULT '',
ef5584
	role_description text(65535) NOT NULL DEFAULT '',
ef5584
	role_type varchar(10) NOT NULL DEFAULT '',
ef5584
	role_order INTEGER UNSIGNED NOT NULL DEFAULT '0'
ef5584
);
ef5584
ef5584
CREATE INDEX phpbb_acl_roles_role_type ON phpbb_acl_roles (role_type);
ef5584
CREATE INDEX phpbb_acl_roles_role_order ON phpbb_acl_roles (role_order);
ef5584
ef5584
# Table: 'phpbb_acl_roles_data'
ef5584
CREATE TABLE phpbb_acl_roles_data (
ef5584
	role_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	auth_option_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	auth_setting tinyint(2) NOT NULL DEFAULT '0',
ef5584
	PRIMARY KEY (role_id, auth_option_id)
ef5584
);
ef5584
ef5584
CREATE INDEX phpbb_acl_roles_data_ath_op_id ON phpbb_acl_roles_data (auth_option_id);
ef5584
ef5584
# Table: 'phpbb_acl_users'
ef5584
CREATE TABLE phpbb_acl_users (
ef5584
	user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	forum_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	auth_option_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	auth_role_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	auth_setting tinyint(2) NOT NULL DEFAULT '0'
ef5584
);
ef5584
ef5584
CREATE INDEX phpbb_acl_users_user_id ON phpbb_acl_users (user_id);
ef5584
CREATE INDEX phpbb_acl_users_auth_option_id ON phpbb_acl_users (auth_option_id);
ef5584
CREATE INDEX phpbb_acl_users_auth_role_id ON phpbb_acl_users (auth_role_id);
ef5584
ef5584
# Table: 'phpbb_banlist'
ef5584
CREATE TABLE phpbb_banlist (
ef5584
	ban_id INTEGER PRIMARY KEY NOT NULL ,
ef5584
	ban_userid INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	ban_ip varchar(40) NOT NULL DEFAULT '',
ef5584
	ban_email varchar(100) NOT NULL DEFAULT '',
ef5584
	ban_start INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	ban_end INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	ban_exclude INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	ban_reason varchar(255) NOT NULL DEFAULT '',
ef5584
	ban_give_reason varchar(255) NOT NULL DEFAULT ''
ef5584
);
ef5584
ef5584
CREATE INDEX phpbb_banlist_ban_end ON phpbb_banlist (ban_end);
ef5584
CREATE INDEX phpbb_banlist_ban_user ON phpbb_banlist (ban_userid, ban_exclude);
ef5584
CREATE INDEX phpbb_banlist_ban_email ON phpbb_banlist (ban_email, ban_exclude);
ef5584
CREATE INDEX phpbb_banlist_ban_ip ON phpbb_banlist (ban_ip, ban_exclude);
ef5584
ef5584
# Table: 'phpbb_bbcodes'
ef5584
CREATE TABLE phpbb_bbcodes (
ef5584
	bbcode_id tinyint(3) NOT NULL DEFAULT '0',
ef5584
	bbcode_tag varchar(16) NOT NULL DEFAULT '',
ef5584
	bbcode_helpline varchar(255) NOT NULL DEFAULT '',
ef5584
	display_on_posting INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	bbcode_match text(65535) NOT NULL DEFAULT '',
ef5584
	bbcode_tpl mediumtext(16777215) NOT NULL DEFAULT '',
ef5584
	first_pass_match mediumtext(16777215) NOT NULL DEFAULT '',
ef5584
	first_pass_replace mediumtext(16777215) NOT NULL DEFAULT '',
ef5584
	second_pass_match mediumtext(16777215) NOT NULL DEFAULT '',
ef5584
	second_pass_replace mediumtext(16777215) NOT NULL DEFAULT '',
ef5584
	PRIMARY KEY (bbcode_id)
ef5584
);
ef5584
ef5584
CREATE INDEX phpbb_bbcodes_display_on_post ON phpbb_bbcodes (display_on_posting);
ef5584
ef5584
# Table: 'phpbb_bookmarks'
ef5584
CREATE TABLE phpbb_bookmarks (
ef5584
	topic_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	PRIMARY KEY (topic_id, user_id)
ef5584
);
ef5584
ef5584
ef5584
# Table: 'phpbb_bots'
ef5584
CREATE TABLE phpbb_bots (
ef5584
	bot_id INTEGER PRIMARY KEY NOT NULL ,
ef5584
	bot_active INTEGER UNSIGNED NOT NULL DEFAULT '1',
ef5584
	bot_name text(65535) NOT NULL DEFAULT '',
ef5584
	user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	bot_agent varchar(255) NOT NULL DEFAULT '',
ef5584
	bot_ip varchar(255) NOT NULL DEFAULT ''
ef5584
);
ef5584
ef5584
CREATE INDEX phpbb_bots_bot_active ON phpbb_bots (bot_active);
ef5584
ef5584
# Table: 'phpbb_config'
ef5584
CREATE TABLE phpbb_config (
ef5584
	config_name varchar(255) NOT NULL DEFAULT '',
ef5584
	config_value varchar(255) NOT NULL DEFAULT '',
ef5584
	is_dynamic INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	PRIMARY KEY (config_name)
ef5584
);
ef5584
ef5584
CREATE INDEX phpbb_config_is_dynamic ON phpbb_config (is_dynamic);
ef5584
ef5584
# Table: 'phpbb_confirm'
ef5584
CREATE TABLE phpbb_confirm (
ef5584
	confirm_id char(32) NOT NULL DEFAULT '',
ef5584
	session_id char(32) NOT NULL DEFAULT '',
ef5584
	confirm_type tinyint(3) NOT NULL DEFAULT '0',
ef5584
	code varchar(8) NOT NULL DEFAULT '',
ef5584
	seed INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	PRIMARY KEY (session_id, confirm_id)
ef5584
);
ef5584
ef5584
CREATE INDEX phpbb_confirm_confirm_type ON phpbb_confirm (confirm_type);
ef5584
ef5584
# Table: 'phpbb_disallow'
ef5584
CREATE TABLE phpbb_disallow (
ef5584
	disallow_id INTEGER PRIMARY KEY NOT NULL ,
ef5584
	disallow_username varchar(255) NOT NULL DEFAULT ''
ef5584
);
ef5584
ef5584
ef5584
# Table: 'phpbb_drafts'
ef5584
CREATE TABLE phpbb_drafts (
ef5584
	draft_id INTEGER PRIMARY KEY NOT NULL ,
ef5584
	user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	topic_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	forum_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	save_time INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	draft_subject text(65535) NOT NULL DEFAULT '',
ef5584
	draft_message mediumtext(16777215) NOT NULL DEFAULT ''
ef5584
);
ef5584
ef5584
CREATE INDEX phpbb_drafts_save_time ON phpbb_drafts (save_time);
ef5584
ef5584
# Table: 'phpbb_extensions'
ef5584
CREATE TABLE phpbb_extensions (
ef5584
	extension_id INTEGER PRIMARY KEY NOT NULL ,
ef5584
	group_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	extension varchar(100) NOT NULL DEFAULT ''
ef5584
);
ef5584
ef5584
ef5584
# Table: 'phpbb_extension_groups'
ef5584
CREATE TABLE phpbb_extension_groups (
ef5584
	group_id INTEGER PRIMARY KEY NOT NULL ,
ef5584
	group_name varchar(255) NOT NULL DEFAULT '',
ef5584
	cat_id tinyint(2) NOT NULL DEFAULT '0',
ef5584
	allow_group INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	download_mode INTEGER UNSIGNED NOT NULL DEFAULT '1',
ef5584
	upload_icon varchar(255) NOT NULL DEFAULT '',
ef5584
	max_filesize INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	allowed_forums text(65535) NOT NULL DEFAULT '',
ef5584
	allow_in_pm INTEGER UNSIGNED NOT NULL DEFAULT '0'
ef5584
);
ef5584
ef5584
ef5584
# Table: 'phpbb_forums'
ef5584
CREATE TABLE phpbb_forums (
ef5584
	forum_id INTEGER PRIMARY KEY NOT NULL ,
ef5584
	parent_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	left_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	right_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	forum_parents mediumtext(16777215) NOT NULL DEFAULT '',
ef5584
	forum_name text(65535) NOT NULL DEFAULT '',
ef5584
	forum_desc text(65535) NOT NULL DEFAULT '',
ef5584
	forum_desc_bitfield varchar(255) NOT NULL DEFAULT '',
ef5584
	forum_desc_options INTEGER UNSIGNED NOT NULL DEFAULT '7',
ef5584
	forum_desc_uid varchar(8) NOT NULL DEFAULT '',
ef5584
	forum_link varchar(255) NOT NULL DEFAULT '',
ef5584
	forum_password varchar(40) NOT NULL DEFAULT '',
ef5584
	forum_style INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	forum_image varchar(255) NOT NULL DEFAULT '',
ef5584
	forum_rules text(65535) NOT NULL DEFAULT '',
ef5584
	forum_rules_link varchar(255) NOT NULL DEFAULT '',
ef5584
	forum_rules_bitfield varchar(255) NOT NULL DEFAULT '',
ef5584
	forum_rules_options INTEGER UNSIGNED NOT NULL DEFAULT '7',
ef5584
	forum_rules_uid varchar(8) NOT NULL DEFAULT '',
ef5584
	forum_topics_per_page tinyint(4) NOT NULL DEFAULT '0',
ef5584
	forum_type tinyint(4) NOT NULL DEFAULT '0',
ef5584
	forum_status tinyint(4) NOT NULL DEFAULT '0',
ef5584
	forum_posts INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	forum_topics INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	forum_topics_real INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	forum_last_post_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	forum_last_poster_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	forum_last_post_subject text(65535) NOT NULL DEFAULT '',
ef5584
	forum_last_post_time INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	forum_last_poster_name varchar(255) NOT NULL DEFAULT '',
ef5584
	forum_last_poster_colour varchar(6) NOT NULL DEFAULT '',
ef5584
	forum_flags tinyint(4) NOT NULL DEFAULT '32',
ef5584
	display_subforum_list INTEGER UNSIGNED NOT NULL DEFAULT '1',
ef5584
	display_on_index INTEGER UNSIGNED NOT NULL DEFAULT '1',
ef5584
	enable_indexing INTEGER UNSIGNED NOT NULL DEFAULT '1',
ef5584
	enable_icons INTEGER UNSIGNED NOT NULL DEFAULT '1',
ef5584
	enable_prune INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	prune_next INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	prune_days INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	prune_viewed INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	prune_freq INTEGER UNSIGNED NOT NULL DEFAULT '0'
ef5584
);
ef5584
ef5584
CREATE INDEX phpbb_forums_left_right_id ON phpbb_forums (left_id, right_id);
ef5584
CREATE INDEX phpbb_forums_forum_lastpost_id ON phpbb_forums (forum_last_post_id);
ef5584
ef5584
# Table: 'phpbb_forums_access'
ef5584
CREATE TABLE phpbb_forums_access (
ef5584
	forum_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	session_id char(32) NOT NULL DEFAULT '',
ef5584
	PRIMARY KEY (forum_id, user_id, session_id)
ef5584
);
ef5584
ef5584
ef5584
# Table: 'phpbb_forums_track'
ef5584
CREATE TABLE phpbb_forums_track (
ef5584
	user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	forum_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	mark_time INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	PRIMARY KEY (user_id, forum_id)
ef5584
);
ef5584
ef5584
ef5584
# Table: 'phpbb_forums_watch'
ef5584
CREATE TABLE phpbb_forums_watch (
ef5584
	forum_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	notify_status INTEGER UNSIGNED NOT NULL DEFAULT '0'
ef5584
);
ef5584
ef5584
CREATE INDEX phpbb_forums_watch_forum_id ON phpbb_forums_watch (forum_id);
ef5584
CREATE INDEX phpbb_forums_watch_user_id ON phpbb_forums_watch (user_id);
ef5584
CREATE INDEX phpbb_forums_watch_notify_stat ON phpbb_forums_watch (notify_status);
ef5584
ef5584
# Table: 'phpbb_groups'
ef5584
CREATE TABLE phpbb_groups (
ef5584
	group_id INTEGER PRIMARY KEY NOT NULL ,
ef5584
	group_type tinyint(4) NOT NULL DEFAULT '1',
ef5584
	group_founder_manage INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	group_name varchar(255) NOT NULL DEFAULT '',
ef5584
	group_desc text(65535) NOT NULL DEFAULT '',
ef5584
	group_desc_bitfield varchar(255) NOT NULL DEFAULT '',
ef5584
	group_desc_options INTEGER UNSIGNED NOT NULL DEFAULT '7',
ef5584
	group_desc_uid varchar(8) NOT NULL DEFAULT '',
ef5584
	group_display INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	group_avatar varchar(255) NOT NULL DEFAULT '',
ef5584
	group_avatar_type tinyint(2) NOT NULL DEFAULT '0',
ef5584
	group_avatar_width INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	group_avatar_height INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	group_rank INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	group_colour varchar(6) NOT NULL DEFAULT '',
ef5584
	group_sig_chars INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	group_receive_pm INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	group_message_limit INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	group_max_recipients INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	group_legend INTEGER UNSIGNED NOT NULL DEFAULT '1'
ef5584
);
ef5584
ef5584
CREATE INDEX phpbb_groups_group_legend_name ON phpbb_groups (group_legend, group_name);
ef5584
ef5584
# Table: 'phpbb_icons'
ef5584
CREATE TABLE phpbb_icons (
ef5584
	icons_id INTEGER PRIMARY KEY NOT NULL ,
ef5584
	icons_url varchar(255) NOT NULL DEFAULT '',
ef5584
	icons_width tinyint(4) NOT NULL DEFAULT '0',
ef5584
	icons_height tinyint(4) NOT NULL DEFAULT '0',
ef5584
	icons_order INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	display_on_posting INTEGER UNSIGNED NOT NULL DEFAULT '1'
ef5584
);
ef5584
ef5584
CREATE INDEX phpbb_icons_display_on_posting ON phpbb_icons (display_on_posting);
ef5584
ef5584
# Table: 'phpbb_lang'
ef5584
CREATE TABLE phpbb_lang (
ef5584
	lang_id INTEGER PRIMARY KEY NOT NULL ,
ef5584
	lang_iso varchar(30) NOT NULL DEFAULT '',
ef5584
	lang_dir varchar(30) NOT NULL DEFAULT '',
ef5584
	lang_english_name varchar(100) NOT NULL DEFAULT '',
ef5584
	lang_local_name varchar(255) NOT NULL DEFAULT '',
ef5584
	lang_author varchar(255) NOT NULL DEFAULT ''
ef5584
);
ef5584
ef5584
CREATE INDEX phpbb_lang_lang_iso ON phpbb_lang (lang_iso);
ef5584
ef5584
# Table: 'phpbb_log'
ef5584
CREATE TABLE phpbb_log (
ef5584
	log_id INTEGER PRIMARY KEY NOT NULL ,
ef5584
	log_type tinyint(4) NOT NULL DEFAULT '0',
ef5584
	user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	forum_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	topic_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	reportee_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	log_ip varchar(40) NOT NULL DEFAULT '',
ef5584
	log_time INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	log_operation text(65535) NOT NULL DEFAULT '',
ef5584
	log_data mediumtext(16777215) NOT NULL DEFAULT ''
ef5584
);
ef5584
ef5584
CREATE INDEX phpbb_log_log_type ON phpbb_log (log_type);
ef5584
CREATE INDEX phpbb_log_forum_id ON phpbb_log (forum_id);
ef5584
CREATE INDEX phpbb_log_topic_id ON phpbb_log (topic_id);
ef5584
CREATE INDEX phpbb_log_reportee_id ON phpbb_log (reportee_id);
ef5584
CREATE INDEX phpbb_log_user_id ON phpbb_log (user_id);
ef5584
ef5584
# Table: 'phpbb_moderator_cache'
ef5584
CREATE TABLE phpbb_moderator_cache (
ef5584
	forum_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	username varchar(255) NOT NULL DEFAULT '',
ef5584
	group_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	group_name varchar(255) NOT NULL DEFAULT '',
ef5584
	display_on_index INTEGER UNSIGNED NOT NULL DEFAULT '1'
ef5584
);
ef5584
ef5584
CREATE INDEX phpbb_moderator_cache_disp_idx ON phpbb_moderator_cache (display_on_index);
ef5584
CREATE INDEX phpbb_moderator_cache_forum_id ON phpbb_moderator_cache (forum_id);
ef5584
ef5584
# Table: 'phpbb_modules'
ef5584
CREATE TABLE phpbb_modules (
ef5584
	module_id INTEGER PRIMARY KEY NOT NULL ,
ef5584
	module_enabled INTEGER UNSIGNED NOT NULL DEFAULT '1',
ef5584
	module_display INTEGER UNSIGNED NOT NULL DEFAULT '1',
ef5584
	module_basename varchar(255) NOT NULL DEFAULT '',
ef5584
	module_class varchar(10) NOT NULL DEFAULT '',
ef5584
	parent_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	left_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	right_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	module_langname varchar(255) NOT NULL DEFAULT '',
ef5584
	module_mode varchar(255) NOT NULL DEFAULT '',
ef5584
	module_auth varchar(255) NOT NULL DEFAULT ''
ef5584
);
ef5584
ef5584
CREATE INDEX phpbb_modules_left_right_id ON phpbb_modules (left_id, right_id);
ef5584
CREATE INDEX phpbb_modules_module_enabled ON phpbb_modules (module_enabled);
ef5584
CREATE INDEX phpbb_modules_class_left_id ON phpbb_modules (module_class, left_id);
ef5584
ef5584
# Table: 'phpbb_poll_options'
ef5584
CREATE TABLE phpbb_poll_options (
ef5584
	poll_option_id tinyint(4) NOT NULL DEFAULT '0',
ef5584
	topic_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	poll_option_text text(65535) NOT NULL DEFAULT '',
ef5584
	poll_option_total INTEGER UNSIGNED NOT NULL DEFAULT '0'
ef5584
);
ef5584
ef5584
CREATE INDEX phpbb_poll_options_poll_opt_id ON phpbb_poll_options (poll_option_id);
ef5584
CREATE INDEX phpbb_poll_options_topic_id ON phpbb_poll_options (topic_id);
ef5584
ef5584
# Table: 'phpbb_poll_votes'
ef5584
CREATE TABLE phpbb_poll_votes (
ef5584
	topic_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	poll_option_id tinyint(4) NOT NULL DEFAULT '0',
ef5584
	vote_user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	vote_user_ip varchar(40) NOT NULL DEFAULT ''
ef5584
);
ef5584
ef5584
CREATE INDEX phpbb_poll_votes_topic_id ON phpbb_poll_votes (topic_id);
ef5584
CREATE INDEX phpbb_poll_votes_vote_user_id ON phpbb_poll_votes (vote_user_id);
ef5584
CREATE INDEX phpbb_poll_votes_vote_user_ip ON phpbb_poll_votes (vote_user_ip);
ef5584
ef5584
# Table: 'phpbb_posts'
ef5584
CREATE TABLE phpbb_posts (
ef5584
	post_id INTEGER PRIMARY KEY NOT NULL ,
ef5584
	topic_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	forum_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	poster_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	icon_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	poster_ip varchar(40) NOT NULL DEFAULT '',
ef5584
	post_time INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	post_approved INTEGER UNSIGNED NOT NULL DEFAULT '1',
ef5584
	post_reported INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	enable_bbcode INTEGER UNSIGNED NOT NULL DEFAULT '1',
ef5584
	enable_smilies INTEGER UNSIGNED NOT NULL DEFAULT '1',
ef5584
	enable_magic_url INTEGER UNSIGNED NOT NULL DEFAULT '1',
ef5584
	enable_sig INTEGER UNSIGNED NOT NULL DEFAULT '1',
ef5584
	post_username varchar(255) NOT NULL DEFAULT '',
ef5584
	post_subject text(65535) NOT NULL DEFAULT '',
ef5584
	post_text mediumtext(16777215) NOT NULL DEFAULT '',
ef5584
	post_checksum varchar(32) NOT NULL DEFAULT '',
ef5584
	post_attachment INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	bbcode_bitfield varchar(255) NOT NULL DEFAULT '',
ef5584
	bbcode_uid varchar(8) NOT NULL DEFAULT '',
ef5584
	post_postcount INTEGER UNSIGNED NOT NULL DEFAULT '1',
ef5584
	post_edit_time INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	post_edit_reason text(65535) NOT NULL DEFAULT '',
ef5584
	post_edit_user INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	post_edit_count INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	post_edit_locked INTEGER UNSIGNED NOT NULL DEFAULT '0'
ef5584
);
ef5584
ef5584
CREATE INDEX phpbb_posts_forum_id ON phpbb_posts (forum_id);
ef5584
CREATE INDEX phpbb_posts_topic_id ON phpbb_posts (topic_id);
ef5584
CREATE INDEX phpbb_posts_poster_ip ON phpbb_posts (poster_ip);
ef5584
CREATE INDEX phpbb_posts_poster_id ON phpbb_posts (poster_id);
ef5584
CREATE INDEX phpbb_posts_post_approved ON phpbb_posts (post_approved);
ef5584
CREATE INDEX phpbb_posts_tid_post_time ON phpbb_posts (topic_id, post_time);
ef5584
ef5584
# Table: 'phpbb_privmsgs'
ef5584
CREATE TABLE phpbb_privmsgs (
ef5584
	msg_id INTEGER PRIMARY KEY NOT NULL ,
ef5584
	root_level INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	author_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	icon_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	author_ip varchar(40) NOT NULL DEFAULT '',
ef5584
	message_time INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	enable_bbcode INTEGER UNSIGNED NOT NULL DEFAULT '1',
ef5584
	enable_smilies INTEGER UNSIGNED NOT NULL DEFAULT '1',
ef5584
	enable_magic_url INTEGER UNSIGNED NOT NULL DEFAULT '1',
ef5584
	enable_sig INTEGER UNSIGNED NOT NULL DEFAULT '1',
ef5584
	message_subject text(65535) NOT NULL DEFAULT '',
ef5584
	message_text mediumtext(16777215) NOT NULL DEFAULT '',
ef5584
	message_edit_reason text(65535) NOT NULL DEFAULT '',
ef5584
	message_edit_user INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	message_attachment INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	bbcode_bitfield varchar(255) NOT NULL DEFAULT '',
ef5584
	bbcode_uid varchar(8) NOT NULL DEFAULT '',
ef5584
	message_edit_time INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	message_edit_count INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	to_address text(65535) NOT NULL DEFAULT '',
ef5584
	bcc_address text(65535) NOT NULL DEFAULT ''
ef5584
);
ef5584
ef5584
CREATE INDEX phpbb_privmsgs_author_ip ON phpbb_privmsgs (author_ip);
ef5584
CREATE INDEX phpbb_privmsgs_message_time ON phpbb_privmsgs (message_time);
ef5584
CREATE INDEX phpbb_privmsgs_author_id ON phpbb_privmsgs (author_id);
ef5584
CREATE INDEX phpbb_privmsgs_root_level ON phpbb_privmsgs (root_level);
ef5584
ef5584
# Table: 'phpbb_privmsgs_folder'
ef5584
CREATE TABLE phpbb_privmsgs_folder (
ef5584
	folder_id INTEGER PRIMARY KEY NOT NULL ,
ef5584
	user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	folder_name varchar(255) NOT NULL DEFAULT '',
ef5584
	pm_count INTEGER UNSIGNED NOT NULL DEFAULT '0'
ef5584
);
ef5584
ef5584
CREATE INDEX phpbb_privmsgs_folder_user_id ON phpbb_privmsgs_folder (user_id);
ef5584
ef5584
# Table: 'phpbb_privmsgs_rules'
ef5584
CREATE TABLE phpbb_privmsgs_rules (
ef5584
	rule_id INTEGER PRIMARY KEY NOT NULL ,
ef5584
	user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	rule_check INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	rule_connection INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	rule_string varchar(255) NOT NULL DEFAULT '',
ef5584
	rule_user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	rule_group_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	rule_action INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	rule_folder_id int(11) NOT NULL DEFAULT '0'
ef5584
);
ef5584
ef5584
CREATE INDEX phpbb_privmsgs_rules_user_id ON phpbb_privmsgs_rules (user_id);
ef5584
ef5584
# Table: 'phpbb_privmsgs_to'
ef5584
CREATE TABLE phpbb_privmsgs_to (
ef5584
	msg_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	author_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	pm_deleted INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	pm_new INTEGER UNSIGNED NOT NULL DEFAULT '1',
ef5584
	pm_unread INTEGER UNSIGNED NOT NULL DEFAULT '1',
ef5584
	pm_replied INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	pm_marked INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	pm_forwarded INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	folder_id int(11) NOT NULL DEFAULT '0'
ef5584
);
ef5584
ef5584
CREATE INDEX phpbb_privmsgs_to_msg_id ON phpbb_privmsgs_to (msg_id);
ef5584
CREATE INDEX phpbb_privmsgs_to_author_id ON phpbb_privmsgs_to (author_id);
ef5584
CREATE INDEX phpbb_privmsgs_to_usr_flder_id ON phpbb_privmsgs_to (user_id, folder_id);
ef5584
ef5584
# Table: 'phpbb_profile_fields'
ef5584
CREATE TABLE phpbb_profile_fields (
ef5584
	field_id INTEGER PRIMARY KEY NOT NULL ,
ef5584
	field_name varchar(255) NOT NULL DEFAULT '',
ef5584
	field_type tinyint(4) NOT NULL DEFAULT '0',
ef5584
	field_ident varchar(20) NOT NULL DEFAULT '',
ef5584
	field_length varchar(20) NOT NULL DEFAULT '',
ef5584
	field_minlen varchar(255) NOT NULL DEFAULT '',
ef5584
	field_maxlen varchar(255) NOT NULL DEFAULT '',
ef5584
	field_novalue varchar(255) NOT NULL DEFAULT '',
ef5584
	field_default_value varchar(255) NOT NULL DEFAULT '',
ef5584
	field_validation varchar(20) NOT NULL DEFAULT '',
ef5584
	field_required INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	field_show_on_reg INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	field_show_profile INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	field_hide INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	field_no_view INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	field_active INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	field_order INTEGER UNSIGNED NOT NULL DEFAULT '0'
ef5584
);
ef5584
ef5584
CREATE INDEX phpbb_profile_fields_fld_type ON phpbb_profile_fields (field_type);
ef5584
CREATE INDEX phpbb_profile_fields_fld_ordr ON phpbb_profile_fields (field_order);
ef5584
ef5584
# Table: 'phpbb_profile_fields_data'
ef5584
CREATE TABLE phpbb_profile_fields_data (
ef5584
	user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	PRIMARY KEY (user_id)
ef5584
);
ef5584
ef5584
ef5584
# Table: 'phpbb_profile_fields_lang'
ef5584
CREATE TABLE phpbb_profile_fields_lang (
ef5584
	field_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	lang_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	option_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	field_type tinyint(4) NOT NULL DEFAULT '0',
ef5584
	lang_value varchar(255) NOT NULL DEFAULT '',
ef5584
	PRIMARY KEY (field_id, lang_id, option_id)
ef5584
);
ef5584
ef5584
ef5584
# Table: 'phpbb_profile_lang'
ef5584
CREATE TABLE phpbb_profile_lang (
ef5584
	field_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	lang_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	lang_name varchar(255) NOT NULL DEFAULT '',
ef5584
	lang_explain text(65535) NOT NULL DEFAULT '',
ef5584
	lang_default_value varchar(255) NOT NULL DEFAULT '',
ef5584
	PRIMARY KEY (field_id, lang_id)
ef5584
);
ef5584
ef5584
ef5584
# Table: 'phpbb_ranks'
ef5584
CREATE TABLE phpbb_ranks (
ef5584
	rank_id INTEGER PRIMARY KEY NOT NULL ,
ef5584
	rank_title varchar(255) NOT NULL DEFAULT '',
ef5584
	rank_min INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	rank_special INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	rank_image varchar(255) NOT NULL DEFAULT ''
ef5584
);
ef5584
ef5584
ef5584
# Table: 'phpbb_reports'
ef5584
CREATE TABLE phpbb_reports (
ef5584
	report_id INTEGER PRIMARY KEY NOT NULL ,
ef5584
	reason_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	post_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	user_notify INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	report_closed INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	report_time INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	report_text mediumtext(16777215) NOT NULL DEFAULT ''
ef5584
);
ef5584
ef5584
ef5584
# Table: 'phpbb_reports_reasons'
ef5584
CREATE TABLE phpbb_reports_reasons (
ef5584
	reason_id INTEGER PRIMARY KEY NOT NULL ,
ef5584
	reason_title varchar(255) NOT NULL DEFAULT '',
ef5584
	reason_description mediumtext(16777215) NOT NULL DEFAULT '',
ef5584
	reason_order INTEGER UNSIGNED NOT NULL DEFAULT '0'
ef5584
);
ef5584
ef5584
ef5584
# Table: 'phpbb_search_results'
ef5584
CREATE TABLE phpbb_search_results (
ef5584
	search_key varchar(32) NOT NULL DEFAULT '',
ef5584
	search_time INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	search_keywords mediumtext(16777215) NOT NULL DEFAULT '',
ef5584
	search_authors mediumtext(16777215) NOT NULL DEFAULT '',
ef5584
	PRIMARY KEY (search_key)
ef5584
);
ef5584
ef5584
ef5584
# Table: 'phpbb_search_wordlist'
ef5584
CREATE TABLE phpbb_search_wordlist (
ef5584
	word_id INTEGER PRIMARY KEY NOT NULL ,
ef5584
	word_text varchar(255) NOT NULL DEFAULT '',
ef5584
	word_common INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	word_count INTEGER UNSIGNED NOT NULL DEFAULT '0'
ef5584
);
ef5584
ef5584
CREATE UNIQUE INDEX phpbb_search_wordlist_wrd_txt ON phpbb_search_wordlist (word_text);
ef5584
CREATE INDEX phpbb_search_wordlist_wrd_cnt ON phpbb_search_wordlist (word_count);
ef5584
ef5584
# Table: 'phpbb_search_wordmatch'
ef5584
CREATE TABLE phpbb_search_wordmatch (
ef5584
	post_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	word_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	title_match INTEGER UNSIGNED NOT NULL DEFAULT '0'
ef5584
);
ef5584
ef5584
CREATE UNIQUE INDEX phpbb_search_wordmatch_unq_mtch ON phpbb_search_wordmatch (word_id, post_id, title_match);
ef5584
CREATE INDEX phpbb_search_wordmatch_word_id ON phpbb_search_wordmatch (word_id);
ef5584
CREATE INDEX phpbb_search_wordmatch_post_id ON phpbb_search_wordmatch (post_id);
ef5584
ef5584
# Table: 'phpbb_sessions'
ef5584
CREATE TABLE phpbb_sessions (
ef5584
	session_id char(32) NOT NULL DEFAULT '',
ef5584
	session_user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	session_forum_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	session_last_visit INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	session_start INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	session_time INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	session_ip varchar(40) NOT NULL DEFAULT '',
ef5584
	session_browser varchar(150) NOT NULL DEFAULT '',
ef5584
	session_forwarded_for varchar(255) NOT NULL DEFAULT '',
ef5584
	session_page varchar(255) NOT NULL DEFAULT '',
ef5584
	session_viewonline INTEGER UNSIGNED NOT NULL DEFAULT '1',
ef5584
	session_autologin INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	session_admin INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	PRIMARY KEY (session_id)
ef5584
);
ef5584
ef5584
CREATE INDEX phpbb_sessions_session_time ON phpbb_sessions (session_time);
ef5584
CREATE INDEX phpbb_sessions_session_user_id ON phpbb_sessions (session_user_id);
ef5584
CREATE INDEX phpbb_sessions_session_fid ON phpbb_sessions (session_forum_id);
ef5584
ef5584
# Table: 'phpbb_sessions_keys'
ef5584
CREATE TABLE phpbb_sessions_keys (
ef5584
	key_id char(32) NOT NULL DEFAULT '',
ef5584
	user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	last_ip varchar(40) NOT NULL DEFAULT '',
ef5584
	last_login INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	PRIMARY KEY (key_id, user_id)
ef5584
);
ef5584
ef5584
CREATE INDEX phpbb_sessions_keys_last_login ON phpbb_sessions_keys (last_login);
ef5584
ef5584
# Table: 'phpbb_sitelist'
ef5584
CREATE TABLE phpbb_sitelist (
ef5584
	site_id INTEGER PRIMARY KEY NOT NULL ,
ef5584
	site_ip varchar(40) NOT NULL DEFAULT '',
ef5584
	site_hostname varchar(255) NOT NULL DEFAULT '',
ef5584
	ip_exclude INTEGER UNSIGNED NOT NULL DEFAULT '0'
ef5584
);
ef5584
ef5584
ef5584
# Table: 'phpbb_smilies'
ef5584
CREATE TABLE phpbb_smilies (
ef5584
	smiley_id INTEGER PRIMARY KEY NOT NULL ,
ef5584
	code varchar(50) NOT NULL DEFAULT '',
ef5584
	emotion varchar(50) NOT NULL DEFAULT '',
ef5584
	smiley_url varchar(50) NOT NULL DEFAULT '',
ef5584
	smiley_width INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	smiley_height INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	smiley_order INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	display_on_posting INTEGER UNSIGNED NOT NULL DEFAULT '1'
ef5584
);
ef5584
ef5584
CREATE INDEX phpbb_smilies_display_on_post ON phpbb_smilies (display_on_posting);
ef5584
ef5584
# Table: 'phpbb_styles'
ef5584
CREATE TABLE phpbb_styles (
ef5584
	style_id INTEGER PRIMARY KEY NOT NULL ,
ef5584
	style_name varchar(255) NOT NULL DEFAULT '',
ef5584
	style_copyright varchar(255) NOT NULL DEFAULT '',
ef5584
	style_active INTEGER UNSIGNED NOT NULL DEFAULT '1',
ef5584
	template_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	theme_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	imageset_id INTEGER UNSIGNED NOT NULL DEFAULT '0'
ef5584
);
ef5584
ef5584
CREATE UNIQUE INDEX phpbb_styles_style_name ON phpbb_styles (style_name);
ef5584
CREATE INDEX phpbb_styles_template_id ON phpbb_styles (template_id);
ef5584
CREATE INDEX phpbb_styles_theme_id ON phpbb_styles (theme_id);
ef5584
CREATE INDEX phpbb_styles_imageset_id ON phpbb_styles (imageset_id);
ef5584
ef5584
# Table: 'phpbb_styles_template'
ef5584
CREATE TABLE phpbb_styles_template (
ef5584
	template_id INTEGER PRIMARY KEY NOT NULL ,
ef5584
	template_name varchar(255) NOT NULL DEFAULT '',
ef5584
	template_copyright varchar(255) NOT NULL DEFAULT '',
ef5584
	template_path varchar(100) NOT NULL DEFAULT '',
ef5584
	bbcode_bitfield varchar(255) NOT NULL DEFAULT 'kNg=',
ef5584
	template_storedb INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	template_inherits_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	template_inherit_path varchar(255) NOT NULL DEFAULT ''
ef5584
);
ef5584
ef5584
CREATE UNIQUE INDEX phpbb_styles_template_tmplte_nm ON phpbb_styles_template (template_name);
ef5584
ef5584
# Table: 'phpbb_styles_template_data'
ef5584
CREATE TABLE phpbb_styles_template_data (
ef5584
	template_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	template_filename varchar(100) NOT NULL DEFAULT '',
ef5584
	template_included text(65535) NOT NULL DEFAULT '',
ef5584
	template_mtime INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	template_data mediumtext(16777215) NOT NULL DEFAULT ''
ef5584
);
ef5584
ef5584
CREATE INDEX phpbb_styles_template_data_tid ON phpbb_styles_template_data (template_id);
ef5584
CREATE INDEX phpbb_styles_template_data_tfn ON phpbb_styles_template_data (template_filename);
ef5584
ef5584
# Table: 'phpbb_styles_theme'
ef5584
CREATE TABLE phpbb_styles_theme (
ef5584
	theme_id INTEGER PRIMARY KEY NOT NULL ,
ef5584
	theme_name varchar(255) NOT NULL DEFAULT '',
ef5584
	theme_copyright varchar(255) NOT NULL DEFAULT '',
ef5584
	theme_path varchar(100) NOT NULL DEFAULT '',
ef5584
	theme_storedb INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	theme_mtime INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	theme_data mediumtext(16777215) NOT NULL DEFAULT ''
ef5584
);
ef5584
ef5584
CREATE UNIQUE INDEX phpbb_styles_theme_theme_name ON phpbb_styles_theme (theme_name);
ef5584
ef5584
# Table: 'phpbb_styles_imageset'
ef5584
CREATE TABLE phpbb_styles_imageset (
ef5584
	imageset_id INTEGER PRIMARY KEY NOT NULL ,
ef5584
	imageset_name varchar(255) NOT NULL DEFAULT '',
ef5584
	imageset_copyright varchar(255) NOT NULL DEFAULT '',
ef5584
	imageset_path varchar(100) NOT NULL DEFAULT ''
ef5584
);
ef5584
ef5584
CREATE UNIQUE INDEX phpbb_styles_imageset_imgset_nm ON phpbb_styles_imageset (imageset_name);
ef5584
ef5584
# Table: 'phpbb_styles_imageset_data'
ef5584
CREATE TABLE phpbb_styles_imageset_data (
ef5584
	image_id INTEGER PRIMARY KEY NOT NULL ,
ef5584
	image_name varchar(200) NOT NULL DEFAULT '',
ef5584
	image_filename varchar(200) NOT NULL DEFAULT '',
ef5584
	image_lang varchar(30) NOT NULL DEFAULT '',
ef5584
	image_height INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	image_width INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	imageset_id INTEGER UNSIGNED NOT NULL DEFAULT '0'
ef5584
);
ef5584
ef5584
CREATE INDEX phpbb_styles_imageset_data_i_d ON phpbb_styles_imageset_data (imageset_id);
ef5584
ef5584
# Table: 'phpbb_topics'
ef5584
CREATE TABLE phpbb_topics (
ef5584
	topic_id INTEGER PRIMARY KEY NOT NULL ,
ef5584
	forum_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	icon_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	topic_attachment INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	topic_approved INTEGER UNSIGNED NOT NULL DEFAULT '1',
ef5584
	topic_reported INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	topic_title text(65535) NOT NULL DEFAULT '',
ef5584
	topic_poster INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	topic_time INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	topic_time_limit INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	topic_views INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	topic_replies INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	topic_replies_real INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	topic_status tinyint(3) NOT NULL DEFAULT '0',
ef5584
	topic_type tinyint(3) NOT NULL DEFAULT '0',
ef5584
	topic_first_post_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	topic_first_poster_name varchar(255) NOT NULL DEFAULT '',
ef5584
	topic_first_poster_colour varchar(6) NOT NULL DEFAULT '',
ef5584
	topic_last_post_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	topic_last_poster_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	topic_last_poster_name varchar(255) NOT NULL DEFAULT '',
ef5584
	topic_last_poster_colour varchar(6) NOT NULL DEFAULT '',
ef5584
	topic_last_post_subject text(65535) NOT NULL DEFAULT '',
ef5584
	topic_last_post_time INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	topic_last_view_time INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	topic_moved_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	topic_bumped INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	topic_bumper INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	poll_title text(65535) NOT NULL DEFAULT '',
ef5584
	poll_start INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	poll_length INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	poll_max_options tinyint(4) NOT NULL DEFAULT '1',
ef5584
	poll_last_vote INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	poll_vote_change INTEGER UNSIGNED NOT NULL DEFAULT '0'
ef5584
);
ef5584
ef5584
CREATE INDEX phpbb_topics_forum_id ON phpbb_topics (forum_id);
ef5584
CREATE INDEX phpbb_topics_forum_id_type ON phpbb_topics (forum_id, topic_type);
ef5584
CREATE INDEX phpbb_topics_last_post_time ON phpbb_topics (topic_last_post_time);
ef5584
CREATE INDEX phpbb_topics_topic_approved ON phpbb_topics (topic_approved);
ef5584
CREATE INDEX phpbb_topics_forum_appr_last ON phpbb_topics (forum_id, topic_approved, topic_last_post_id);
ef5584
CREATE INDEX phpbb_topics_fid_time_moved ON phpbb_topics (forum_id, topic_last_post_time, topic_moved_id);
ef5584
ef5584
# Table: 'phpbb_topics_track'
ef5584
CREATE TABLE phpbb_topics_track (
ef5584
	user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	topic_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	forum_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	mark_time INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	PRIMARY KEY (user_id, topic_id)
ef5584
);
ef5584
ef5584
CREATE INDEX phpbb_topics_track_forum_id ON phpbb_topics_track (forum_id);
ef5584
ef5584
# Table: 'phpbb_topics_posted'
ef5584
CREATE TABLE phpbb_topics_posted (
ef5584
	user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	topic_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	topic_posted INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	PRIMARY KEY (user_id, topic_id)
ef5584
);
ef5584
ef5584
ef5584
# Table: 'phpbb_topics_watch'
ef5584
CREATE TABLE phpbb_topics_watch (
ef5584
	topic_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	notify_status INTEGER UNSIGNED NOT NULL DEFAULT '0'
ef5584
);
ef5584
ef5584
CREATE INDEX phpbb_topics_watch_topic_id ON phpbb_topics_watch (topic_id);
ef5584
CREATE INDEX phpbb_topics_watch_user_id ON phpbb_topics_watch (user_id);
ef5584
CREATE INDEX phpbb_topics_watch_notify_stat ON phpbb_topics_watch (notify_status);
ef5584
ef5584
# Table: 'phpbb_user_group'
ef5584
CREATE TABLE phpbb_user_group (
ef5584
	group_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	group_leader INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	user_pending INTEGER UNSIGNED NOT NULL DEFAULT '1'
ef5584
);
ef5584
ef5584
CREATE INDEX phpbb_user_group_group_id ON phpbb_user_group (group_id);
ef5584
CREATE INDEX phpbb_user_group_user_id ON phpbb_user_group (user_id);
ef5584
CREATE INDEX phpbb_user_group_group_leader ON phpbb_user_group (group_leader);
ef5584
ef5584
# Table: 'phpbb_users'
ef5584
CREATE TABLE phpbb_users (
ef5584
	user_id INTEGER PRIMARY KEY NOT NULL ,
ef5584
	user_type tinyint(2) NOT NULL DEFAULT '0',
ef5584
	group_id INTEGER UNSIGNED NOT NULL DEFAULT '3',
ef5584
	user_permissions mediumtext(16777215) NOT NULL DEFAULT '',
ef5584
	user_perm_from INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	user_ip varchar(40) NOT NULL DEFAULT '',
ef5584
	user_regdate INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	username varchar(255) NOT NULL DEFAULT '',
ef5584
	username_clean varchar(255) NOT NULL DEFAULT '',
ef5584
	user_password varchar(40) NOT NULL DEFAULT '',
ef5584
	user_passchg INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	user_pass_convert INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	user_email varchar(100) NOT NULL DEFAULT '',
ef5584
	user_email_hash bigint(20) NOT NULL DEFAULT '0',
ef5584
	user_birthday varchar(10) NOT NULL DEFAULT '',
ef5584
	user_lastvisit INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	user_lastmark INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	user_lastpost_time INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	user_lastpage varchar(200) NOT NULL DEFAULT '',
ef5584
	user_last_confirm_key varchar(10) NOT NULL DEFAULT '',
ef5584
	user_last_search INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	user_warnings tinyint(4) NOT NULL DEFAULT '0',
ef5584
	user_last_warning INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	user_login_attempts tinyint(4) NOT NULL DEFAULT '0',
ef5584
	user_inactive_reason tinyint(2) NOT NULL DEFAULT '0',
ef5584
	user_inactive_time INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	user_posts INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	user_lang varchar(30) NOT NULL DEFAULT '',
ef5584
	user_timezone decimal(5,2) NOT NULL DEFAULT '0',
ef5584
	user_dst INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	user_dateformat varchar(30) NOT NULL DEFAULT 'd M Y H:i',
ef5584
	user_style INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	user_rank INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	user_colour varchar(6) NOT NULL DEFAULT '',
ef5584
	user_new_privmsg int(4) NOT NULL DEFAULT '0',
ef5584
	user_unread_privmsg int(4) NOT NULL DEFAULT '0',
ef5584
	user_last_privmsg INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	user_message_rules INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	user_full_folder int(11) NOT NULL DEFAULT '-3',
ef5584
	user_emailtime INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	user_topic_show_days INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	user_topic_sortby_type varchar(1) NOT NULL DEFAULT 't',
ef5584
	user_topic_sortby_dir varchar(1) NOT NULL DEFAULT 'd',
ef5584
	user_post_show_days INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	user_post_sortby_type varchar(1) NOT NULL DEFAULT 't',
ef5584
	user_post_sortby_dir varchar(1) NOT NULL DEFAULT 'a',
ef5584
	user_notify INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	user_notify_pm INTEGER UNSIGNED NOT NULL DEFAULT '1',
ef5584
	user_notify_type tinyint(4) NOT NULL DEFAULT '0',
ef5584
	user_allow_pm INTEGER UNSIGNED NOT NULL DEFAULT '1',
ef5584
	user_allow_viewonline INTEGER UNSIGNED NOT NULL DEFAULT '1',
ef5584
	user_allow_viewemail INTEGER UNSIGNED NOT NULL DEFAULT '1',
ef5584
	user_allow_massemail INTEGER UNSIGNED NOT NULL DEFAULT '1',
ef5584
	user_options INTEGER UNSIGNED NOT NULL DEFAULT '895',
ef5584
	user_avatar varchar(255) NOT NULL DEFAULT '',
ef5584
	user_avatar_type tinyint(2) NOT NULL DEFAULT '0',
ef5584
	user_avatar_width INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	user_avatar_height INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	user_sig mediumtext(16777215) NOT NULL DEFAULT '',
ef5584
	user_sig_bbcode_uid varchar(8) NOT NULL DEFAULT '',
ef5584
	user_sig_bbcode_bitfield varchar(255) NOT NULL DEFAULT '',
ef5584
	user_from varchar(100) NOT NULL DEFAULT '',
ef5584
	user_icq varchar(15) NOT NULL DEFAULT '',
ef5584
	user_aim varchar(255) NOT NULL DEFAULT '',
ef5584
	user_yim varchar(255) NOT NULL DEFAULT '',
ef5584
	user_msnm varchar(255) NOT NULL DEFAULT '',
ef5584
	user_jabber varchar(255) NOT NULL DEFAULT '',
ef5584
	user_website varchar(200) NOT NULL DEFAULT '',
ef5584
	user_occ text(65535) NOT NULL DEFAULT '',
ef5584
	user_interests text(65535) NOT NULL DEFAULT '',
ef5584
	user_actkey varchar(32) NOT NULL DEFAULT '',
ef5584
	user_newpasswd varchar(40) NOT NULL DEFAULT '',
ef5584
	user_form_salt varchar(32) NOT NULL DEFAULT ''
ef5584
);
ef5584
ef5584
CREATE INDEX phpbb_users_user_birthday ON phpbb_users (user_birthday);
ef5584
CREATE INDEX phpbb_users_user_email_hash ON phpbb_users (user_email_hash);
ef5584
CREATE INDEX phpbb_users_user_type ON phpbb_users (user_type);
ef5584
CREATE UNIQUE INDEX phpbb_users_username_clean ON phpbb_users (username_clean);
ef5584
ef5584
# Table: 'phpbb_warnings'
ef5584
CREATE TABLE phpbb_warnings (
ef5584
	warning_id INTEGER PRIMARY KEY NOT NULL ,
ef5584
	user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	post_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	log_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	warning_time INTEGER UNSIGNED NOT NULL DEFAULT '0'
ef5584
);
ef5584
ef5584
ef5584
# Table: 'phpbb_words'
ef5584
CREATE TABLE phpbb_words (
ef5584
	word_id INTEGER PRIMARY KEY NOT NULL ,
ef5584
	word varchar(255) NOT NULL DEFAULT '',
ef5584
	replacement varchar(255) NOT NULL DEFAULT ''
ef5584
);
ef5584
ef5584
ef5584
# Table: 'phpbb_zebra'
ef5584
CREATE TABLE phpbb_zebra (
ef5584
	user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	zebra_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	friend INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	foe INTEGER UNSIGNED NOT NULL DEFAULT '0',
ef5584
	PRIMARY KEY (user_id, zebra_id)
ef5584
);
ef5584
ef5584
ef5584
ef5584
COMMIT;