|
 |
4c79b5 |
#
|
|
|
4c79b5 |
# $Id: mysql_41_schema.sql 9129 2008-11-27 13:44:24Z acydburn $
|
|
|
4c79b5 |
#
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_attachments'
|
|
|
4c79b5 |
CREATE TABLE phpbb_attachments (
|
|
|
4c79b5 |
attach_id mediumint(8) UNSIGNED NOT NULL auto_increment,
|
|
|
4c79b5 |
post_msg_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
in_message tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
poster_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
is_orphan tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
|
|
|
4c79b5 |
physical_filename varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
real_filename varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
download_count mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
attach_comment text NOT NULL,
|
|
|
4c79b5 |
extension varchar(100) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
mimetype varchar(100) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
filesize int(20) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
filetime int(11) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
thumbnail tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
PRIMARY KEY (attach_id),
|
|
|
4c79b5 |
KEY filetime (filetime),
|
|
|
4c79b5 |
KEY post_msg_id (post_msg_id),
|
|
|
4c79b5 |
KEY topic_id (topic_id),
|
|
|
4c79b5 |
KEY poster_id (poster_id),
|
|
|
4c79b5 |
KEY is_orphan (is_orphan)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_acl_groups'
|
|
|
4c79b5 |
CREATE TABLE phpbb_acl_groups (
|
|
|
4c79b5 |
group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
auth_option_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
auth_role_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
auth_setting tinyint(2) DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
KEY group_id (group_id),
|
|
|
4c79b5 |
KEY auth_opt_id (auth_option_id),
|
|
|
4c79b5 |
KEY auth_role_id (auth_role_id)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_acl_options'
|
|
|
4c79b5 |
CREATE TABLE phpbb_acl_options (
|
|
|
4c79b5 |
auth_option_id mediumint(8) UNSIGNED NOT NULL auto_increment,
|
|
|
4c79b5 |
auth_option varchar(50) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
is_global tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
is_local tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
founder_only tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
PRIMARY KEY (auth_option_id),
|
|
|
4c79b5 |
KEY auth_option (auth_option)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_acl_roles'
|
|
|
4c79b5 |
CREATE TABLE phpbb_acl_roles (
|
|
|
4c79b5 |
role_id mediumint(8) UNSIGNED NOT NULL auto_increment,
|
|
|
4c79b5 |
role_name varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
role_description text NOT NULL,
|
|
|
4c79b5 |
role_type varchar(10) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
role_order smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
PRIMARY KEY (role_id),
|
|
|
4c79b5 |
KEY role_type (role_type),
|
|
|
4c79b5 |
KEY role_order (role_order)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_acl_roles_data'
|
|
|
4c79b5 |
CREATE TABLE phpbb_acl_roles_data (
|
|
|
4c79b5 |
role_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
auth_option_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
auth_setting tinyint(2) DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
PRIMARY KEY (role_id, auth_option_id),
|
|
|
4c79b5 |
KEY ath_op_id (auth_option_id)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_acl_users'
|
|
|
4c79b5 |
CREATE TABLE phpbb_acl_users (
|
|
|
4c79b5 |
user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
auth_option_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
auth_role_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
auth_setting tinyint(2) DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
KEY user_id (user_id),
|
|
|
4c79b5 |
KEY auth_option_id (auth_option_id),
|
|
|
4c79b5 |
KEY auth_role_id (auth_role_id)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_banlist'
|
|
|
4c79b5 |
CREATE TABLE phpbb_banlist (
|
|
|
4c79b5 |
ban_id mediumint(8) UNSIGNED NOT NULL auto_increment,
|
|
|
4c79b5 |
ban_userid mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
ban_ip varchar(40) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
ban_email varchar(100) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
ban_start int(11) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
ban_end int(11) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
ban_exclude tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
ban_reason varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
ban_give_reason varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
PRIMARY KEY (ban_id),
|
|
|
4c79b5 |
KEY ban_end (ban_end),
|
|
|
4c79b5 |
KEY ban_user (ban_userid, ban_exclude),
|
|
|
4c79b5 |
KEY ban_email (ban_email, ban_exclude),
|
|
|
4c79b5 |
KEY ban_ip (ban_ip, ban_exclude)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_bbcodes'
|
|
|
4c79b5 |
CREATE TABLE phpbb_bbcodes (
|
|
|
4c79b5 |
bbcode_id tinyint(3) DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
bbcode_tag varchar(16) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
bbcode_helpline varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
display_on_posting tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
bbcode_match text NOT NULL,
|
|
|
4c79b5 |
bbcode_tpl mediumtext NOT NULL,
|
|
|
4c79b5 |
first_pass_match mediumtext NOT NULL,
|
|
|
4c79b5 |
first_pass_replace mediumtext NOT NULL,
|
|
|
4c79b5 |
second_pass_match mediumtext NOT NULL,
|
|
|
4c79b5 |
second_pass_replace mediumtext NOT NULL,
|
|
|
4c79b5 |
PRIMARY KEY (bbcode_id),
|
|
|
4c79b5 |
KEY display_on_post (display_on_posting)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_bookmarks'
|
|
|
4c79b5 |
CREATE TABLE phpbb_bookmarks (
|
|
|
4c79b5 |
topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
PRIMARY KEY (topic_id, user_id)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_bots'
|
|
|
4c79b5 |
CREATE TABLE phpbb_bots (
|
|
|
4c79b5 |
bot_id mediumint(8) UNSIGNED NOT NULL auto_increment,
|
|
|
4c79b5 |
bot_active tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
|
|
|
4c79b5 |
bot_name varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
bot_agent varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
bot_ip varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
PRIMARY KEY (bot_id),
|
|
|
4c79b5 |
KEY bot_active (bot_active)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_config'
|
|
|
4c79b5 |
CREATE TABLE phpbb_config (
|
|
|
4c79b5 |
config_name varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
config_value varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
is_dynamic tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
PRIMARY KEY (config_name),
|
|
|
4c79b5 |
KEY is_dynamic (is_dynamic)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_confirm'
|
|
|
4c79b5 |
CREATE TABLE phpbb_confirm (
|
|
|
4c79b5 |
confirm_id char(32) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
session_id char(32) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
confirm_type tinyint(3) DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
code varchar(8) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
seed int(10) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
PRIMARY KEY (session_id, confirm_id),
|
|
|
4c79b5 |
KEY confirm_type (confirm_type)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_disallow'
|
|
|
4c79b5 |
CREATE TABLE phpbb_disallow (
|
|
|
4c79b5 |
disallow_id mediumint(8) UNSIGNED NOT NULL auto_increment,
|
|
|
4c79b5 |
disallow_username varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
PRIMARY KEY (disallow_id)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_drafts'
|
|
|
4c79b5 |
CREATE TABLE phpbb_drafts (
|
|
|
4c79b5 |
draft_id mediumint(8) UNSIGNED NOT NULL auto_increment,
|
|
|
4c79b5 |
user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
save_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
draft_subject varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
draft_message mediumtext NOT NULL,
|
|
|
4c79b5 |
PRIMARY KEY (draft_id),
|
|
|
4c79b5 |
KEY save_time (save_time)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_extensions'
|
|
|
4c79b5 |
CREATE TABLE phpbb_extensions (
|
|
|
4c79b5 |
extension_id mediumint(8) UNSIGNED NOT NULL auto_increment,
|
|
|
4c79b5 |
group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
extension varchar(100) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
PRIMARY KEY (extension_id)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_extension_groups'
|
|
|
4c79b5 |
CREATE TABLE phpbb_extension_groups (
|
|
|
4c79b5 |
group_id mediumint(8) UNSIGNED NOT NULL auto_increment,
|
|
|
4c79b5 |
group_name varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
cat_id tinyint(2) DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
allow_group tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
download_mode tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
|
|
|
4c79b5 |
upload_icon varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
max_filesize int(20) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
allowed_forums text NOT NULL,
|
|
|
4c79b5 |
allow_in_pm tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
PRIMARY KEY (group_id)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_forums'
|
|
|
4c79b5 |
CREATE TABLE phpbb_forums (
|
|
|
4c79b5 |
forum_id mediumint(8) UNSIGNED NOT NULL auto_increment,
|
|
|
4c79b5 |
parent_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
left_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
right_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
forum_parents mediumtext NOT NULL,
|
|
|
4c79b5 |
forum_name varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
forum_desc text NOT NULL,
|
|
|
4c79b5 |
forum_desc_bitfield varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
forum_desc_options int(11) UNSIGNED DEFAULT '7' NOT NULL,
|
|
|
4c79b5 |
forum_desc_uid varchar(8) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
forum_link varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
forum_password varchar(40) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
forum_style mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
forum_image varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
forum_rules text NOT NULL,
|
|
|
4c79b5 |
forum_rules_link varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
forum_rules_bitfield varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
forum_rules_options int(11) UNSIGNED DEFAULT '7' NOT NULL,
|
|
|
4c79b5 |
forum_rules_uid varchar(8) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
forum_topics_per_page tinyint(4) DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
forum_type tinyint(4) DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
forum_status tinyint(4) DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
forum_posts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
forum_topics mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
forum_topics_real mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
forum_last_post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
forum_last_poster_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
forum_last_post_subject varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
forum_last_post_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
forum_last_poster_name varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
forum_last_poster_colour varchar(6) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
forum_flags tinyint(4) DEFAULT '32' NOT NULL,
|
|
|
4c79b5 |
display_subforum_list tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
|
|
|
4c79b5 |
display_on_index tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
|
|
|
4c79b5 |
enable_indexing tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
|
|
|
4c79b5 |
enable_icons tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
|
|
|
4c79b5 |
enable_prune tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
prune_next int(11) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
prune_days mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
prune_viewed mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
prune_freq mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
PRIMARY KEY (forum_id),
|
|
|
4c79b5 |
KEY left_right_id (left_id, right_id),
|
|
|
4c79b5 |
KEY forum_lastpost_id (forum_last_post_id)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_forums_access'
|
|
|
4c79b5 |
CREATE TABLE phpbb_forums_access (
|
|
|
4c79b5 |
forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
session_id char(32) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
PRIMARY KEY (forum_id, user_id, session_id)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_forums_track'
|
|
|
4c79b5 |
CREATE TABLE phpbb_forums_track (
|
|
|
4c79b5 |
user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
mark_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
PRIMARY KEY (user_id, forum_id)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_forums_watch'
|
|
|
4c79b5 |
CREATE TABLE phpbb_forums_watch (
|
|
|
4c79b5 |
forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
notify_status tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
KEY forum_id (forum_id),
|
|
|
4c79b5 |
KEY user_id (user_id),
|
|
|
4c79b5 |
KEY notify_stat (notify_status)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_groups'
|
|
|
4c79b5 |
CREATE TABLE phpbb_groups (
|
|
|
4c79b5 |
group_id mediumint(8) UNSIGNED NOT NULL auto_increment,
|
|
|
4c79b5 |
group_type tinyint(4) DEFAULT '1' NOT NULL,
|
|
|
4c79b5 |
group_founder_manage tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
group_name varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
group_desc text NOT NULL,
|
|
|
4c79b5 |
group_desc_bitfield varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
group_desc_options int(11) UNSIGNED DEFAULT '7' NOT NULL,
|
|
|
4c79b5 |
group_desc_uid varchar(8) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
group_display tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
group_avatar varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
group_avatar_type tinyint(2) DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
group_avatar_width smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
group_avatar_height smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
group_rank mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
group_colour varchar(6) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
group_sig_chars mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
group_receive_pm tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
group_message_limit mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
group_max_recipients mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
group_legend tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
|
|
|
4c79b5 |
PRIMARY KEY (group_id),
|
|
|
4c79b5 |
KEY group_legend_name (group_legend, group_name)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_icons'
|
|
|
4c79b5 |
CREATE TABLE phpbb_icons (
|
|
|
4c79b5 |
icons_id mediumint(8) UNSIGNED NOT NULL auto_increment,
|
|
|
4c79b5 |
icons_url varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
icons_width tinyint(4) DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
icons_height tinyint(4) DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
icons_order mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
display_on_posting tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
|
|
|
4c79b5 |
PRIMARY KEY (icons_id),
|
|
|
4c79b5 |
KEY display_on_posting (display_on_posting)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_lang'
|
|
|
4c79b5 |
CREATE TABLE phpbb_lang (
|
|
|
4c79b5 |
lang_id tinyint(4) NOT NULL auto_increment,
|
|
|
4c79b5 |
lang_iso varchar(30) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
lang_dir varchar(30) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
lang_english_name varchar(100) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
lang_local_name varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
lang_author varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
PRIMARY KEY (lang_id),
|
|
|
4c79b5 |
KEY lang_iso (lang_iso)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_log'
|
|
|
4c79b5 |
CREATE TABLE phpbb_log (
|
|
|
4c79b5 |
log_id mediumint(8) UNSIGNED NOT NULL auto_increment,
|
|
|
4c79b5 |
log_type tinyint(4) DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
reportee_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
log_ip varchar(40) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
log_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
log_operation text NOT NULL,
|
|
|
4c79b5 |
log_data mediumtext NOT NULL,
|
|
|
4c79b5 |
PRIMARY KEY (log_id),
|
|
|
4c79b5 |
KEY log_type (log_type),
|
|
|
4c79b5 |
KEY forum_id (forum_id),
|
|
|
4c79b5 |
KEY topic_id (topic_id),
|
|
|
4c79b5 |
KEY reportee_id (reportee_id),
|
|
|
4c79b5 |
KEY user_id (user_id)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_moderator_cache'
|
|
|
4c79b5 |
CREATE TABLE phpbb_moderator_cache (
|
|
|
4c79b5 |
forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
username varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
group_name varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
display_on_index tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
|
|
|
4c79b5 |
KEY disp_idx (display_on_index),
|
|
|
4c79b5 |
KEY forum_id (forum_id)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_modules'
|
|
|
4c79b5 |
CREATE TABLE phpbb_modules (
|
|
|
4c79b5 |
module_id mediumint(8) UNSIGNED NOT NULL auto_increment,
|
|
|
4c79b5 |
module_enabled tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
|
|
|
4c79b5 |
module_display tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
|
|
|
4c79b5 |
module_basename varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
module_class varchar(10) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
parent_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
left_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
right_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
module_langname varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
module_mode varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
module_auth varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
PRIMARY KEY (module_id),
|
|
|
4c79b5 |
KEY left_right_id (left_id, right_id),
|
|
|
4c79b5 |
KEY module_enabled (module_enabled),
|
|
|
4c79b5 |
KEY class_left_id (module_class, left_id)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_poll_options'
|
|
|
4c79b5 |
CREATE TABLE phpbb_poll_options (
|
|
|
4c79b5 |
poll_option_id tinyint(4) DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
poll_option_text text NOT NULL,
|
|
|
4c79b5 |
poll_option_total mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
KEY poll_opt_id (poll_option_id),
|
|
|
4c79b5 |
KEY topic_id (topic_id)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_poll_votes'
|
|
|
4c79b5 |
CREATE TABLE phpbb_poll_votes (
|
|
|
4c79b5 |
topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
poll_option_id tinyint(4) DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
vote_user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
vote_user_ip varchar(40) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
KEY topic_id (topic_id),
|
|
|
4c79b5 |
KEY vote_user_id (vote_user_id),
|
|
|
4c79b5 |
KEY vote_user_ip (vote_user_ip)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_posts'
|
|
|
4c79b5 |
CREATE TABLE phpbb_posts (
|
|
|
4c79b5 |
post_id mediumint(8) UNSIGNED NOT NULL auto_increment,
|
|
|
4c79b5 |
topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
poster_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
icon_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
poster_ip varchar(40) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
post_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
post_approved tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
|
|
|
4c79b5 |
post_reported tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
enable_bbcode tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
|
|
|
4c79b5 |
enable_smilies tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
|
|
|
4c79b5 |
enable_magic_url tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
|
|
|
4c79b5 |
enable_sig tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
|
|
|
4c79b5 |
post_username varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
post_subject varchar(255) DEFAULT '' NOT NULL COLLATE utf8_unicode_ci,
|
|
|
4c79b5 |
post_text mediumtext NOT NULL,
|
|
|
4c79b5 |
post_checksum varchar(32) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
post_attachment tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
bbcode_bitfield varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
bbcode_uid varchar(8) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
post_postcount tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
|
|
|
4c79b5 |
post_edit_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
post_edit_reason varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
post_edit_user mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
post_edit_count smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
post_edit_locked tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
PRIMARY KEY (post_id),
|
|
|
4c79b5 |
KEY forum_id (forum_id),
|
|
|
4c79b5 |
KEY topic_id (topic_id),
|
|
|
4c79b5 |
KEY poster_ip (poster_ip),
|
|
|
4c79b5 |
KEY poster_id (poster_id),
|
|
|
4c79b5 |
KEY post_approved (post_approved),
|
|
|
4c79b5 |
KEY tid_post_time (topic_id, post_time)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_privmsgs'
|
|
|
4c79b5 |
CREATE TABLE phpbb_privmsgs (
|
|
|
4c79b5 |
msg_id mediumint(8) UNSIGNED NOT NULL auto_increment,
|
|
|
4c79b5 |
root_level mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
author_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
icon_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
author_ip varchar(40) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
message_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
enable_bbcode tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
|
|
|
4c79b5 |
enable_smilies tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
|
|
|
4c79b5 |
enable_magic_url tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
|
|
|
4c79b5 |
enable_sig tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
|
|
|
4c79b5 |
message_subject varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
message_text mediumtext NOT NULL,
|
|
|
4c79b5 |
message_edit_reason varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
message_edit_user mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
message_attachment tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
bbcode_bitfield varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
bbcode_uid varchar(8) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
message_edit_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
message_edit_count smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
to_address text NOT NULL,
|
|
|
4c79b5 |
bcc_address text NOT NULL,
|
|
|
4c79b5 |
PRIMARY KEY (msg_id),
|
|
|
4c79b5 |
KEY author_ip (author_ip),
|
|
|
4c79b5 |
KEY message_time (message_time),
|
|
|
4c79b5 |
KEY author_id (author_id),
|
|
|
4c79b5 |
KEY root_level (root_level)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_privmsgs_folder'
|
|
|
4c79b5 |
CREATE TABLE phpbb_privmsgs_folder (
|
|
|
4c79b5 |
folder_id mediumint(8) UNSIGNED NOT NULL auto_increment,
|
|
|
4c79b5 |
user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
folder_name varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
pm_count mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
PRIMARY KEY (folder_id),
|
|
|
4c79b5 |
KEY user_id (user_id)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_privmsgs_rules'
|
|
|
4c79b5 |
CREATE TABLE phpbb_privmsgs_rules (
|
|
|
4c79b5 |
rule_id mediumint(8) UNSIGNED NOT NULL auto_increment,
|
|
|
4c79b5 |
user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
rule_check mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
rule_connection mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
rule_string varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
rule_user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
rule_group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
rule_action mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
rule_folder_id int(11) DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
PRIMARY KEY (rule_id),
|
|
|
4c79b5 |
KEY user_id (user_id)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_privmsgs_to'
|
|
|
4c79b5 |
CREATE TABLE phpbb_privmsgs_to (
|
|
|
4c79b5 |
msg_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
author_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
pm_deleted tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
pm_new tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
|
|
|
4c79b5 |
pm_unread tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
|
|
|
4c79b5 |
pm_replied tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
pm_marked tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
pm_forwarded tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
folder_id int(11) DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
KEY msg_id (msg_id),
|
|
|
4c79b5 |
KEY author_id (author_id),
|
|
|
4c79b5 |
KEY usr_flder_id (user_id, folder_id)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_profile_fields'
|
|
|
4c79b5 |
CREATE TABLE phpbb_profile_fields (
|
|
|
4c79b5 |
field_id mediumint(8) UNSIGNED NOT NULL auto_increment,
|
|
|
4c79b5 |
field_name varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
field_type tinyint(4) DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
field_ident varchar(20) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
field_length varchar(20) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
field_minlen varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
field_maxlen varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
field_novalue varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
field_default_value varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
field_validation varchar(20) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
field_required tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
field_show_on_reg tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
field_show_profile tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
field_hide tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
field_no_view tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
field_active tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
field_order mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
PRIMARY KEY (field_id),
|
|
|
4c79b5 |
KEY fld_type (field_type),
|
|
|
4c79b5 |
KEY fld_ordr (field_order)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_profile_fields_data'
|
|
|
4c79b5 |
CREATE TABLE phpbb_profile_fields_data (
|
|
|
4c79b5 |
user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
PRIMARY KEY (user_id)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_profile_fields_lang'
|
|
|
4c79b5 |
CREATE TABLE phpbb_profile_fields_lang (
|
|
|
4c79b5 |
field_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
lang_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
option_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
field_type tinyint(4) DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
lang_value varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
PRIMARY KEY (field_id, lang_id, option_id)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_profile_lang'
|
|
|
4c79b5 |
CREATE TABLE phpbb_profile_lang (
|
|
|
4c79b5 |
field_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
lang_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
lang_name varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
lang_explain text NOT NULL,
|
|
|
4c79b5 |
lang_default_value varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
PRIMARY KEY (field_id, lang_id)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_ranks'
|
|
|
4c79b5 |
CREATE TABLE phpbb_ranks (
|
|
|
4c79b5 |
rank_id mediumint(8) UNSIGNED NOT NULL auto_increment,
|
|
|
4c79b5 |
rank_title varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
rank_min mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
rank_special tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
rank_image varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
PRIMARY KEY (rank_id)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_reports'
|
|
|
4c79b5 |
CREATE TABLE phpbb_reports (
|
|
|
4c79b5 |
report_id mediumint(8) UNSIGNED NOT NULL auto_increment,
|
|
|
4c79b5 |
reason_id smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
user_notify tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
report_closed tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
report_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
report_text mediumtext NOT NULL,
|
|
|
4c79b5 |
PRIMARY KEY (report_id)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_reports_reasons'
|
|
|
4c79b5 |
CREATE TABLE phpbb_reports_reasons (
|
|
|
4c79b5 |
reason_id smallint(4) UNSIGNED NOT NULL auto_increment,
|
|
|
4c79b5 |
reason_title varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
reason_description mediumtext NOT NULL,
|
|
|
4c79b5 |
reason_order smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
PRIMARY KEY (reason_id)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_search_results'
|
|
|
4c79b5 |
CREATE TABLE phpbb_search_results (
|
|
|
4c79b5 |
search_key varchar(32) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
search_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
search_keywords mediumtext NOT NULL,
|
|
|
4c79b5 |
search_authors mediumtext NOT NULL,
|
|
|
4c79b5 |
PRIMARY KEY (search_key)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_search_wordlist'
|
|
|
4c79b5 |
CREATE TABLE phpbb_search_wordlist (
|
|
|
4c79b5 |
word_id mediumint(8) UNSIGNED NOT NULL auto_increment,
|
|
|
4c79b5 |
word_text varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
word_common tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
word_count mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
PRIMARY KEY (word_id),
|
|
|
4c79b5 |
UNIQUE wrd_txt (word_text),
|
|
|
4c79b5 |
KEY wrd_cnt (word_count)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_search_wordmatch'
|
|
|
4c79b5 |
CREATE TABLE phpbb_search_wordmatch (
|
|
|
4c79b5 |
post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
word_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
title_match tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
UNIQUE unq_mtch (word_id, post_id, title_match),
|
|
|
4c79b5 |
KEY word_id (word_id),
|
|
|
4c79b5 |
KEY post_id (post_id)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_sessions'
|
|
|
4c79b5 |
CREATE TABLE phpbb_sessions (
|
|
|
4c79b5 |
session_id char(32) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
session_user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
session_forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
session_last_visit int(11) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
session_start int(11) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
session_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
session_ip varchar(40) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
session_browser varchar(150) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
session_forwarded_for varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
session_page varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
session_viewonline tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
|
|
|
4c79b5 |
session_autologin tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
session_admin tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
PRIMARY KEY (session_id),
|
|
|
4c79b5 |
KEY session_time (session_time),
|
|
|
4c79b5 |
KEY session_user_id (session_user_id),
|
|
|
4c79b5 |
KEY session_fid (session_forum_id)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_sessions_keys'
|
|
|
4c79b5 |
CREATE TABLE phpbb_sessions_keys (
|
|
|
4c79b5 |
key_id char(32) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
last_ip varchar(40) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
last_login int(11) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
PRIMARY KEY (key_id, user_id),
|
|
|
4c79b5 |
KEY last_login (last_login)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_sitelist'
|
|
|
4c79b5 |
CREATE TABLE phpbb_sitelist (
|
|
|
4c79b5 |
site_id mediumint(8) UNSIGNED NOT NULL auto_increment,
|
|
|
4c79b5 |
site_ip varchar(40) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
site_hostname varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
ip_exclude tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
PRIMARY KEY (site_id)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_smilies'
|
|
|
4c79b5 |
CREATE TABLE phpbb_smilies (
|
|
|
4c79b5 |
smiley_id mediumint(8) UNSIGNED NOT NULL auto_increment,
|
|
|
4c79b5 |
code varchar(50) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
emotion varchar(50) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
smiley_url varchar(50) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
smiley_width smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
smiley_height smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
smiley_order mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
display_on_posting tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
|
|
|
4c79b5 |
PRIMARY KEY (smiley_id),
|
|
|
4c79b5 |
KEY display_on_post (display_on_posting)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_styles'
|
|
|
4c79b5 |
CREATE TABLE phpbb_styles (
|
|
|
4c79b5 |
style_id mediumint(8) UNSIGNED NOT NULL auto_increment,
|
|
|
4c79b5 |
style_name varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
style_copyright varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
style_active tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
|
|
|
4c79b5 |
template_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
theme_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
imageset_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
PRIMARY KEY (style_id),
|
|
|
4c79b5 |
UNIQUE style_name (style_name),
|
|
|
4c79b5 |
KEY template_id (template_id),
|
|
|
4c79b5 |
KEY theme_id (theme_id),
|
|
|
4c79b5 |
KEY imageset_id (imageset_id)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_styles_template'
|
|
|
4c79b5 |
CREATE TABLE phpbb_styles_template (
|
|
|
4c79b5 |
template_id mediumint(8) UNSIGNED NOT NULL auto_increment,
|
|
|
4c79b5 |
template_name varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
template_copyright varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
template_path varchar(100) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
bbcode_bitfield varchar(255) DEFAULT 'kNg=' NOT NULL,
|
|
|
4c79b5 |
template_storedb tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
template_inherits_id int(4) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
template_inherit_path varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
PRIMARY KEY (template_id),
|
|
|
4c79b5 |
UNIQUE tmplte_nm (template_name)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_styles_template_data'
|
|
|
4c79b5 |
CREATE TABLE phpbb_styles_template_data (
|
|
|
4c79b5 |
template_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
template_filename varchar(100) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
template_included text NOT NULL,
|
|
|
4c79b5 |
template_mtime int(11) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
template_data mediumtext NOT NULL,
|
|
|
4c79b5 |
KEY tid (template_id),
|
|
|
4c79b5 |
KEY tfn (template_filename)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_styles_theme'
|
|
|
4c79b5 |
CREATE TABLE phpbb_styles_theme (
|
|
|
4c79b5 |
theme_id mediumint(8) UNSIGNED NOT NULL auto_increment,
|
|
|
4c79b5 |
theme_name varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
theme_copyright varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
theme_path varchar(100) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
theme_storedb tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
theme_mtime int(11) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
theme_data mediumtext NOT NULL,
|
|
|
4c79b5 |
PRIMARY KEY (theme_id),
|
|
|
4c79b5 |
UNIQUE theme_name (theme_name)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_styles_imageset'
|
|
|
4c79b5 |
CREATE TABLE phpbb_styles_imageset (
|
|
|
4c79b5 |
imageset_id mediumint(8) UNSIGNED NOT NULL auto_increment,
|
|
|
4c79b5 |
imageset_name varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
imageset_copyright varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
imageset_path varchar(100) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
PRIMARY KEY (imageset_id),
|
|
|
4c79b5 |
UNIQUE imgset_nm (imageset_name)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_styles_imageset_data'
|
|
|
4c79b5 |
CREATE TABLE phpbb_styles_imageset_data (
|
|
|
4c79b5 |
image_id mediumint(8) UNSIGNED NOT NULL auto_increment,
|
|
|
4c79b5 |
image_name varchar(200) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
image_filename varchar(200) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
image_lang varchar(30) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
image_height smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
image_width smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
imageset_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
PRIMARY KEY (image_id),
|
|
|
4c79b5 |
KEY i_d (imageset_id)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_topics'
|
|
|
4c79b5 |
CREATE TABLE phpbb_topics (
|
|
|
4c79b5 |
topic_id mediumint(8) UNSIGNED NOT NULL auto_increment,
|
|
|
4c79b5 |
forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
icon_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
topic_attachment tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
topic_approved tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
|
|
|
4c79b5 |
topic_reported tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
topic_title varchar(255) DEFAULT '' NOT NULL COLLATE utf8_unicode_ci,
|
|
|
4c79b5 |
topic_poster mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
topic_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
topic_time_limit int(11) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
topic_views mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
topic_replies mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
topic_replies_real mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
topic_status tinyint(3) DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
topic_type tinyint(3) DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
topic_first_post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
topic_first_poster_name varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
topic_first_poster_colour varchar(6) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
topic_last_post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
topic_last_poster_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
topic_last_poster_name varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
topic_last_poster_colour varchar(6) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
topic_last_post_subject varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
topic_last_post_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
topic_last_view_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
topic_moved_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
topic_bumped tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
topic_bumper mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
poll_title varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
poll_start int(11) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
poll_length int(11) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
poll_max_options tinyint(4) DEFAULT '1' NOT NULL,
|
|
|
4c79b5 |
poll_last_vote int(11) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
poll_vote_change tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
PRIMARY KEY (topic_id),
|
|
|
4c79b5 |
KEY forum_id (forum_id),
|
|
|
4c79b5 |
KEY forum_id_type (forum_id, topic_type),
|
|
|
4c79b5 |
KEY last_post_time (topic_last_post_time),
|
|
|
4c79b5 |
KEY topic_approved (topic_approved),
|
|
|
4c79b5 |
KEY forum_appr_last (forum_id, topic_approved, topic_last_post_id),
|
|
|
4c79b5 |
KEY fid_time_moved (forum_id, topic_last_post_time, topic_moved_id)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_topics_track'
|
|
|
4c79b5 |
CREATE TABLE phpbb_topics_track (
|
|
|
4c79b5 |
user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
mark_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
PRIMARY KEY (user_id, topic_id),
|
|
|
4c79b5 |
KEY forum_id (forum_id)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_topics_posted'
|
|
|
4c79b5 |
CREATE TABLE phpbb_topics_posted (
|
|
|
4c79b5 |
user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
topic_posted tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
PRIMARY KEY (user_id, topic_id)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_topics_watch'
|
|
|
4c79b5 |
CREATE TABLE phpbb_topics_watch (
|
|
|
4c79b5 |
topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
notify_status tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
KEY topic_id (topic_id),
|
|
|
4c79b5 |
KEY user_id (user_id),
|
|
|
4c79b5 |
KEY notify_stat (notify_status)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_user_group'
|
|
|
4c79b5 |
CREATE TABLE phpbb_user_group (
|
|
|
4c79b5 |
group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
group_leader tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
user_pending tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
|
|
|
4c79b5 |
KEY group_id (group_id),
|
|
|
4c79b5 |
KEY user_id (user_id),
|
|
|
4c79b5 |
KEY group_leader (group_leader)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_users'
|
|
|
4c79b5 |
CREATE TABLE phpbb_users (
|
|
|
4c79b5 |
user_id mediumint(8) UNSIGNED NOT NULL auto_increment,
|
|
|
4c79b5 |
user_type tinyint(2) DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
group_id mediumint(8) UNSIGNED DEFAULT '3' NOT NULL,
|
|
|
4c79b5 |
user_permissions mediumtext NOT NULL,
|
|
|
4c79b5 |
user_perm_from mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
user_ip varchar(40) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
user_regdate int(11) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
username varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
username_clean varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
user_password varchar(40) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
user_passchg int(11) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
user_pass_convert tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
user_email varchar(100) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
user_email_hash bigint(20) DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
user_birthday varchar(10) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
user_lastvisit int(11) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
user_lastmark int(11) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
user_lastpost_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
user_lastpage varchar(200) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
user_last_confirm_key varchar(10) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
user_last_search int(11) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
user_warnings tinyint(4) DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
user_last_warning int(11) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
user_login_attempts tinyint(4) DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
user_inactive_reason tinyint(2) DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
user_inactive_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
user_posts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
user_lang varchar(30) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
user_timezone decimal(5,2) DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
user_dst tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
user_dateformat varchar(30) DEFAULT 'd M Y H:i' NOT NULL,
|
|
|
4c79b5 |
user_style mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
user_rank mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
user_colour varchar(6) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
user_new_privmsg int(4) DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
user_unread_privmsg int(4) DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
user_last_privmsg int(11) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
user_message_rules tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
user_full_folder int(11) DEFAULT '-3' NOT NULL,
|
|
|
4c79b5 |
user_emailtime int(11) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
user_topic_show_days smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
user_topic_sortby_type varchar(1) DEFAULT 't' NOT NULL,
|
|
|
4c79b5 |
user_topic_sortby_dir varchar(1) DEFAULT 'd' NOT NULL,
|
|
|
4c79b5 |
user_post_show_days smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
user_post_sortby_type varchar(1) DEFAULT 't' NOT NULL,
|
|
|
4c79b5 |
user_post_sortby_dir varchar(1) DEFAULT 'a' NOT NULL,
|
|
|
4c79b5 |
user_notify tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
user_notify_pm tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
|
|
|
4c79b5 |
user_notify_type tinyint(4) DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
user_allow_pm tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
|
|
|
4c79b5 |
user_allow_viewonline tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
|
|
|
4c79b5 |
user_allow_viewemail tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
|
|
|
4c79b5 |
user_allow_massemail tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
|
|
|
4c79b5 |
user_options int(11) UNSIGNED DEFAULT '895' NOT NULL,
|
|
|
4c79b5 |
user_avatar varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
user_avatar_type tinyint(2) DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
user_avatar_width smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
user_avatar_height smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
user_sig mediumtext NOT NULL,
|
|
|
4c79b5 |
user_sig_bbcode_uid varchar(8) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
user_sig_bbcode_bitfield varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
user_from varchar(100) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
user_icq varchar(15) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
user_aim varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
user_yim varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
user_msnm varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
user_jabber varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
user_website varchar(200) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
user_occ text NOT NULL,
|
|
|
4c79b5 |
user_interests text NOT NULL,
|
|
|
4c79b5 |
user_actkey varchar(32) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
user_newpasswd varchar(40) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
user_form_salt varchar(32) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
PRIMARY KEY (user_id),
|
|
|
4c79b5 |
KEY user_birthday (user_birthday),
|
|
|
4c79b5 |
KEY user_email_hash (user_email_hash),
|
|
|
4c79b5 |
KEY user_type (user_type),
|
|
|
4c79b5 |
UNIQUE username_clean (username_clean)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_warnings'
|
|
|
4c79b5 |
CREATE TABLE phpbb_warnings (
|
|
|
4c79b5 |
warning_id mediumint(8) UNSIGNED NOT NULL auto_increment,
|
|
|
4c79b5 |
user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
log_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
warning_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
PRIMARY KEY (warning_id)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_words'
|
|
|
4c79b5 |
CREATE TABLE phpbb_words (
|
|
|
4c79b5 |
word_id mediumint(8) UNSIGNED NOT NULL auto_increment,
|
|
|
4c79b5 |
word varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
replacement varchar(255) DEFAULT '' NOT NULL,
|
|
|
4c79b5 |
PRIMARY KEY (word_id)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|
|
|
4c79b5 |
# Table: 'phpbb_zebra'
|
|
|
4c79b5 |
CREATE TABLE phpbb_zebra (
|
|
|
4c79b5 |
user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
zebra_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
friend tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
foe tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
|
|
|
4c79b5 |
PRIMARY KEY (user_id, zebra_id)
|
|
|
4c79b5 |
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
|
|
|
4c79b5 |
|
|
|
4c79b5 |
|