diff options
Diffstat (limited to 'phpBB/install/schemas/sqlite_schema.sql')
-rw-r--r-- | phpBB/install/schemas/sqlite_schema.sql | 1408 |
1 files changed, 811 insertions, 597 deletions
diff --git a/phpBB/install/schemas/sqlite_schema.sql b/phpBB/install/schemas/sqlite_schema.sql index c0385261c2..090d8427dd 100644 --- a/phpBB/install/schemas/sqlite_schema.sql +++ b/phpBB/install/schemas/sqlite_schema.sql @@ -1,716 +1,930 @@ --- --- phpbb - Firebird schema --- --- $Id$ --- +# +# SQLite Schema for phpBB 3.x - (c) phpBB Group, 2005 +# +# $Id$ +# --- Table: phpbb_attachments +BEGIN TRANSACTION; + +# Table: phpbb_attachments CREATE TABLE phpbb_attachments ( - attach_id INTEGER DEFAULT 0 NOT NULL, - post_id INTEGER DEFAULT 0 NOT NULL, - privmsgs_id INTEGER DEFAULT 0 NOT NULL, - user_id_from INTEGER NOT NULL, - user_id_to INTEGER NOT NULL -); - -CREATE INDEX attach_id ON phpbb_attachments (attach_id); - --- Table: phpbb_attach_desc -CREATE TABLE phpbb_attach_desc ( - attach_id INTEGER NOT NULL, - physical_filename VARCHAR(255) NOT NULL, - real_filename VARCHAR(255) NOT NULL, - download_count INTEGER DEFAULT 0 NOT NULL, - comment VARCHAR(255) DEFAULT '', - extension VARCHAR(100), - mimetype VARCHAR(100), - filesize INTEGER NOT NULL, - filetime INTEGER DEFAULT 0 NOT NULL, - thumbnail INTEGER DEFAULT 0 NOT NULL, - PRIMARY KEY (attach_id) -); - -CREATE INDEX filetime ON phpbb_attach_desc (filetime); -CREATE INDEX physical_filename ON phpbb_attach_desc (physical_filename); -CREATE INDEX filesize ON phpbb_attach_desc (filesize); - --- Table: phpbb_auth_groups + attach_id INTEGER PRIMARY KEY NOT NULL, + post_msg_id mediumint(8) NOT NULL DEFAULT '0', + topic_id mediumint(8) NOT NULL DEFAULT '0', + in_message tinyint(1) NOT NULL DEFAULT '0', + poster_id mediumint(8) NOT NULL DEFAULT '0', + physical_filename varchar(255) NOT NULL, + real_filename varchar(255) NOT NULL, + download_count mediumint(8) NOT NULL DEFAULT '0', + comment varchar(255), + extension varchar(100), + mimetype varchar(100), + filesize int(20) NOT NULL, + filetime int(11) NOT NULL DEFAULT '0', + thumbnail tinyint(1) NOT NULL DEFAULT '0' +); + +CREATE INDEX filetime_phpbb_attachments on phpbb_attachments (filetime); +CREATE INDEX post_msg_id_phpbb_attachments on phpbb_attachments (post_msg_id); +CREATE INDEX topic_id_phpbb_attachments on phpbb_attachments (topic_id); +CREATE INDEX poster_id_phpbb_attachments on phpbb_attachments (poster_id); +CREATE INDEX physical_filename_phpbb_attach on phpbb_attachments (physical_filename); +CREATE INDEX filesize_phpbb_attachments on phpbb_attachments (filesize); + +# Table: phpbb_auth_groups CREATE TABLE phpbb_auth_groups ( - group_id INTEGER DEFAULT 0 NOT NULL, - forum_id INTEGER DEFAULT 0 NOT NULL, - auth_option_id INTEGER DEFAULT 0 NOT NULL, - auth_setting INTEGER DEFAULT 0 NOT NULL + group_id mediumint(8) NOT NULL DEFAULT '0', + forum_id mediumint(8) NOT NULL DEFAULT '0', + auth_option_id smallint(5) NOT NULL DEFAULT '0', + auth_setting tinyint(4) NOT NULL DEFAULT '0' ); -CREATE INDEX group_id ON phpbb_auth_groups (group_id); -CREATE INDEX auth_option_id ON phpbb_auth_groups (auth_option_id); +CREATE INDEX group_id_phpbb_auth_groups on phpbb_auth_groups (group_id); +CREATE INDEX auth_option_id_phpbb_auth_grou on phpbb_auth_groups (auth_option_id); --- Table: phpbb_auth_options +# Table: phpbb_auth_options CREATE TABLE phpbb_auth_options ( - auth_option_id INTEGER NOT NULL, - auth_option CHAR(20) NOT NULL, - is_global INTEGER DEFAULT 0 NOT NULL, - is_local INTEGER DEFAULT 0 NOT NULL, - founder_only INTEGER DEFAULT 0 NOT NULL, - PRIMARY KEY (auth_option_id) + auth_option_id INTEGER PRIMARY KEY NOT NULL, + auth_option char(20) NOT NULL, + is_global tinyint(1) NOT NULL DEFAULT '0', + is_local tinyint(1) NOT NULL DEFAULT '0', + founder_only tinyint(1) NOT NULL DEFAULT '0' ); -CREATE INDEX auth_option ON phpbb_auth_options (auth_option); +CREATE INDEX auth_option_phpbb_auth_options on phpbb_auth_options (auth_option); --- Table: phpbb_auth_presets +# Table: phpbb_auth_presets CREATE TABLE phpbb_auth_presets ( - preset_id INTEGER NOT NULL, - preset_name VARCHAR(50) NOT NULL, - preset_user_id INTEGER NOT NULL, - preset_type VARCHAR(2) NOT NULL, - preset_data TEXT, - PRIMARY KEY (preset_id) + preset_id INTEGER PRIMARY KEY NOT NULL, + preset_name varchar(50) NOT NULL DEFAULT '', + preset_user_id mediumint(5) NOT NULL DEFAULT '0', + preset_type varchar(2) NOT NULL DEFAULT '', + preset_data text(65535) NOT NULL DEFAULT '' ); -CREATE INDEX preset_type ON phpbb_auth_presets (preset_type); +CREATE INDEX preset_type_phpbb_auth_presets on phpbb_auth_presets (preset_type); --- Table: phpbb_auth_users +# Table: phpbb_auth_users CREATE TABLE phpbb_auth_users ( - user_id INTEGER DEFAULT 0 NOT NULL, - forum_id INTEGER DEFAULT 0 NOT NULL, - auth_option_id INTEGER DEFAULT 0 NOT NULL, - auth_setting INTEGER DEFAULT 0 NOT NULL + user_id mediumint(8) NOT NULL DEFAULT '0', + forum_id mediumint(8) NOT NULL DEFAULT '0', + auth_option_id smallint(5) NOT NULL DEFAULT '0', + auth_setting tinyint(4) NOT NULL DEFAULT '0' ); -CREATE INDEX user_id ON phpbb_auth_users (user_id); -CREATE INDEX auth_option_id2 ON phpbb_auth_users (auth_option_id); +CREATE INDEX user_id_phpbb_auth_users on phpbb_auth_users (user_id); +CREATE INDEX auth_option_id_phpbb_auth_user on phpbb_auth_users (auth_option_id); --- Table: 'phpbb_banlist' +# Table: phpbb_banlist CREATE TABLE phpbb_banlist ( - ban_id INTEGER NOT NULL, - ban_userid INTEGER DEFAULT 0 NOT NULL, - ban_ip VARCHAR(40) DEFAULT '' NOT NULL, - ban_email VARCHAR(50) DEFAULT '' NOT NULL, - ban_start INTEGER DEFAULT 0 NOT NULL, - ban_end INTEGER DEFAULT 0 NOT NULL, - ban_exclude INTEGER DEFAULT 0 NOT NULL, - ban_reason VARCHAR(255), - ban_give_reason VARCHAR(255) DEFAULT '' NOT NULL, - PRIMARY KEY (ban_id) -); - --- Table: 'phpbb_cache' + ban_id INTEGER PRIMARY KEY NOT NULL, + ban_userid mediumint(8) NOT NULL DEFAULT '0', + ban_ip varchar(40) NOT NULL DEFAULT '', + ban_email varchar(50) NOT NULL DEFAULT '', + ban_start int(11) NOT NULL DEFAULT '0', + ban_end int(11) NOT NULL DEFAULT '0', + ban_exclude tinyint(1) NOT NULL DEFAULT '0', + ban_reason varchar(255) NOT NULL DEFAULT '', + ban_give_reason varchar(255) NOT NULL DEFAULT '' +); + +# Table: phpbb_bbcodes +CREATE TABLE phpbb_bbcodes ( + bbcode_id INTEGER PRIMARY KEY NOT NULL DEFAULT '0', + bbcode_tag varchar(16) NOT NULL DEFAULT '', + bbcode_match varchar(255) NOT NULL DEFAULT '', + bbcode_tpl text(65535) NOT NULL DEFAULT '', + first_pass_match varchar(255) NOT NULL DEFAULT '', + first_pass_replace varchar(255) NOT NULL DEFAULT '', + second_pass_match varchar(255) NOT NULL DEFAULT '', + second_pass_replace text(65535) NOT NULL DEFAULT '' +); + +# Table: phpbb_bookmarks +CREATE TABLE phpbb_bookmarks ( + topic_id mediumint(8) NOT NULL DEFAULT '0', + user_id mediumint(8) NOT NULL DEFAULT '0', + order_id mediumint(8) NOT NULL DEFAULT '0' +); + +CREATE INDEX order_id_phpbb_bookmarks on phpbb_bookmarks (order_id); +CREATE INDEX topic_user_id_phpbb_bookmarks on phpbb_bookmarks (topic_id, user_id); + +# Table: phpbb_bots +CREATE TABLE phpbb_bots ( + bot_id INTEGER PRIMARY KEY NOT NULL, + bot_active tinyint(1) NOT NULL DEFAULT '1', + bot_name varchar(255) NOT NULL DEFAULT '', + user_id mediumint(8) NOT NULL DEFAULT '0', + bot_agent varchar(255) NOT NULL DEFAULT '', + bot_ip varchar(255) NOT NULL DEFAULT '' +); + +CREATE INDEX bot_active_phpbb_bots on phpbb_bots (bot_active); + +# Table: phpbb_cache CREATE TABLE phpbb_cache ( - var_name VARCHAR(255) NOT NULL, - var_ts INTEGER DEFAULT 0 NOT NULL, - var_data TEXT DEFAULT '' NOT NULL, - PRIMARY KEY (var_name) + var_name varchar(255) NOT NULL DEFAULT '', + var_expires int(10) NOT NULL DEFAULT '0', + var_data mediumtext(16777215) NOT NULL, + PRIMARY KEY (var_name) ); --- Table: 'phpbb_config' +# Table: phpbb_config CREATE TABLE phpbb_config ( - config_name VARCHAR(50) NOT NULL, - config_value VARCHAR(255) NOT NULL, - is_dynamic INTEGER DEFAULT 0 NOT NULL, - PRIMARY KEY (config_name) + config_name varchar(255) NOT NULL, + config_value varchar(255) NOT NULL, + is_dynamic tinyint(1) NOT NULL DEFAULT '0', + PRIMARY KEY (config_name) ); -CREATE INDEX is_dynamic ON phpbb_config (is_dynamic); +CREATE INDEX is_dynamic_phpbb_config on phpbb_config (is_dynamic); --- Table: 'phpbb_confirm' +# Table: phpbb_confirm CREATE TABLE phpbb_confirm ( - confirm_id CHAR(32) DEFAULT '' NOT NULL, - session_id CHAR(32) DEFAULT '' NOT NULL, - code CHAR(6) DEFAULT '' NOT NULL, - PRIMARY KEY (session_id, confirm_id) + confirm_id char(32) NOT NULL DEFAULT '', + session_id char(32) NOT NULL DEFAULT '', + code char(6) NOT NULL DEFAULT '', + PRIMARY KEY (session_id, confirm_id) ); --- Table: 'phpbb_disallow' +# Table: phpbb_disallow CREATE TABLE phpbb_disallow ( - disallow_id INTEGER NOT NULL, - disallow_username VARCHAR(30), - PRIMARY KEY (disallow_id) + disallow_id INTEGER PRIMARY KEY NOT NULL, + disallow_username varchar(30) NOT NULL DEFAULT '' ); --- Table: 'phpbb_extensions' -CREATE TABLE phpbb_extensions ( - extension_id INTEGER NOT NULL, - group_id INTEGER DEFAULT 0 NOT NULL, - extension VARCHAR(100) DEFAULT '' NOT NULL, - comment VARCHAR(100) DEFAULT '' NOT NULL, - PRIMARY KEY (extension_id) +# Table: phpbb_drafts +CREATE TABLE phpbb_drafts ( + draft_id INTEGER PRIMARY KEY NOT NULL, + user_id mediumint(8) NOT NULL DEFAULT '0', + topic_id mediumint(8) NOT NULL DEFAULT '0', + forum_id mediumint(8) NOT NULL DEFAULT '0', + save_time int(11) NOT NULL DEFAULT '0', + draft_subject varchar(60), + draft_message mediumtext(16777215) NOT NULL DEFAULT '' ); --- Table: 'phpbb_extension_groups' -CREATE TABLE phpbb_extension_groups ( - group_id INTEGER NOT NULL, - group_name VARCHAR(20) DEFAULT '' NOT NULL, - cat_id INTEGER DEFAULT 0 NOT NULL, - allow_group INTEGER DEFAULT 0 NOT NULL, - download_mode INTEGER DEFAULT 1 NOT NULL, - upload_icon VARCHAR(100) DEFAULT '' NOT NULL, - max_filesize INTEGER DEFAULT 0 NOT NULL, - PRIMARY KEY (group_id) +CREATE INDEX save_time_phpbb_drafts on phpbb_drafts (save_time); + +# Table: phpbb_extensions +CREATE TABLE phpbb_extensions ( + extension_id INTEGER PRIMARY KEY NOT NULL, + group_id mediumint(8) NOT NULL DEFAULT '0', + extension varchar(100) NOT NULL DEFAULT '' ); --- Table: 'phpbb_forums' +# Table: phpbb_extension_groups +CREATE TABLE phpbb_extension_groups ( + group_id INTEGER PRIMARY KEY NOT NULL, + group_name char(20) NOT NULL, + cat_id tinyint(2) NOT NULL DEFAULT '0', + allow_group tinyint(1) NOT NULL DEFAULT '0', + download_mode tinyint(1) NOT NULL DEFAULT '1', + upload_icon varchar(100) NOT NULL DEFAULT '', + max_filesize int(20) NOT NULL DEFAULT '0', + allowed_forums text(65535) NOT NULL, + allow_in_pm tinyint(1) NOT NULL DEFAULT '0' +); + +# Table: phpbb_forums CREATE TABLE phpbb_forums ( - forum_id INTEGER NOT NULL, - parent_id INTEGER NOT NULL, - left_id INTEGER NOT NULL, - right_id INTEGER NOT NULL, - forum_parents TEXT, - forum_name VARCHAR(150) NOT NULL, - forum_desc TEXT, - forum_link VARCHAR(200) DEFAULT '' NOT NULL, - forum_password VARCHAR(32) DEFAULT '' NOT NULL, - forum_style INTEGER DEFAULT 0 NOT NULL, - forum_image VARCHAR(50) DEFAULT '' NOT NULL, - forum_topics_per_page INTEGER DEFAULT 0 NOT NULL, - forum_type INTEGER DEFAULT 0 NOT NULL, - forum_status INTEGER DEFAULT 0 NOT NULL, - forum_posts INTEGER DEFAULT 0 NOT NULL, - forum_topics INTEGER DEFAULT 0 NOT NULL, - forum_topics_real INTEGER DEFAULT 0 NOT NULL, - forum_last_post_id INTEGER DEFAULT 0 NOT NULL, - forum_last_poster_id INTEGER DEFAULT 0 NOT NULL, - forum_last_post_time INTEGER DEFAULT 0 NOT NULL, - forum_last_poster_name VARCHAR(30) DEFAULT '' NOT NULL, - forum_flags INTEGER DEFAULT 0 NOT NULL, - display_on_index INTEGER DEFAULT 1 NOT NULL, - enable_icons INTEGER DEFAULT 1 NOT NULL, - enable_prune INTEGER DEFAULT 0 NOT NULL, - prune_next INTEGER DEFAULT 0 NOT NULL, - prune_days INTEGER DEFAULT 0 NOT NULL, - prune_freq INTEGER DEFAULT 0 NOT NULL, - PRIMARY KEY (forum_id) -); - -CREATE INDEX left_id ON phpbb_forums (left_id); -CREATE INDEX forum_last_post_id ON phpbb_forums (forum_last_post_id); - --- Table: phpbb_forum_access + forum_id INTEGER PRIMARY KEY NOT NULL, + parent_id smallint(5) NOT NULL, + left_id smallint(5) NOT NULL, + right_id smallint(5) NOT NULL, + forum_parents text(65535), + forum_name varchar(150) NOT NULL, + forum_desc text(65535), + forum_link varchar(200) NOT NULL DEFAULT '', + forum_password varchar(32) NOT NULL DEFAULT '', + forum_style tinyint(4), + forum_image varchar(50) NOT NULL DEFAULT '', + forum_rules text(65535) NOT NULL DEFAULT '', + forum_rules_link varchar(200) NOT NULL DEFAULT '', + forum_rules_flags tinyint(4) NOT NULL DEFAULT '0', + forum_rules_bbcode_bitfield int(11) NOT NULL DEFAULT '0', + forum_rules_bbcode_uid varchar(5) NOT NULL DEFAULT '', + forum_topics_per_page tinyint(4) NOT NULL DEFAULT '0', + forum_type tinyint(4) NOT NULL DEFAULT '0', + forum_status tinyint(4) NOT NULL DEFAULT '0', + forum_posts mediumint(8) NOT NULL DEFAULT '0', + forum_topics mediumint(8) NOT NULL DEFAULT '0', + forum_topics_real mediumint(8) NOT NULL DEFAULT '0', + forum_last_post_id mediumint(8) NOT NULL DEFAULT '0', + forum_last_poster_id mediumint(8) NOT NULL DEFAULT '0', + forum_last_post_time int(11) NOT NULL DEFAULT '0', + forum_last_poster_name varchar(30), + forum_flags tinyint(4) NOT NULL DEFAULT '0', + display_on_index tinyint(1) NOT NULL DEFAULT '1', + enable_indexing tinyint(1) NOT NULL DEFAULT '1', + enable_icons tinyint(1) NOT NULL DEFAULT '1', + enable_prune tinyint(1) NOT NULL DEFAULT '0', + prune_next int(11), + prune_days tinyint(4) NOT NULL, + prune_viewed tinyint(4) NOT NULL, + prune_freq tinyint(4) NOT NULL DEFAULT '0' +); + +CREATE INDEX left_right_id_phpbb_forums on phpbb_forums (left_id, right_id); +CREATE INDEX forum_last_post_id_phpbb_forum on phpbb_forums (forum_last_post_id); + +# Table: phpbb_forum_access CREATE TABLE phpbb_forum_access ( - forum_id INTEGER DEFAULT 0 NOT NULL, - user_id INTEGER DEFAULT 0 NOT NULL, - session_id CHAR(32) DEFAULT '' NOT NULL, - PRIMARY KEY (forum_id,user_id,session_id) + forum_id mediumint(8) NOT NULL DEFAULT '0', + user_id mediumint(8) NOT NULL DEFAULT '0', + session_id char(32) NOT NULL DEFAULT '', + PRIMARY KEY (forum_id, user_id, session_id) ); --- Table: 'phpbb_forums_marking' +# Table: phpbb_forums_marking CREATE TABLE phpbb_forums_marking ( - user_id INTEGER DEFAULT 0 NOT NULL, - forum_id INTEGER DEFAULT 0 NOT NULL, - mark_time INTEGER DEFAULT 0 NOT NULL, - PRIMARY KEY (user_id, forum_id) + user_id mediumint(9) NOT NULL DEFAULT '0', + forum_id mediumint(9) NOT NULL DEFAULT '0', + mark_time int(11) NOT NULL DEFAULT '0', + PRIMARY KEY (user_id, forum_id) ); --- Table: 'phpbb_forums_watch' +# Table: phpbb_forums_watch CREATE TABLE phpbb_forums_watch ( - forum_id INTEGER DEFAULT 0 NOT NULL, - user_id INTEGER DEFAULT 0 NOT NULL, - notify_status INTEGER DEFAULT 0 NOT NULL + forum_id smallint(5) NOT NULL DEFAULT '0', + user_id mediumint(8) NOT NULL DEFAULT '0', + notify_status tinyint(1) NOT NULL DEFAULT '0' ); -CREATE INDEX forum_id ON phpbb_forums_watch (forum_id); -CREATE INDEX user_id2 ON phpbb_forums_watch (user_id); -CREATE INDEX notify_status ON phpbb_forums_watch (notify_status); +CREATE INDEX forum_id_phpbb_forums_watch on phpbb_forums_watch (forum_id); +CREATE INDEX user_id_phpbb_forums_watch on phpbb_forums_watch (user_id); +CREATE INDEX notify_status_phpbb_forums_wat on phpbb_forums_watch (notify_status); --- Table: 'phpbb_groups' +# Table: phpbb_groups CREATE TABLE phpbb_groups ( - group_id INTEGER NOT NULL, - group_type INTEGER DEFAULT 1 NOT NULL, - group_name VARCHAR(40) DEFAULT '' NOT NULL, - group_display INTEGER DEFAULT 0 NOT NULL, - group_avatar VARCHAR(100) DEFAULT '' NOT NULL, - group_avatar_type INTEGER DEFAULT 0 NOT NULL, - group_rank INTEGER DEFAULT 0 NOT NULL, - group_colour VARCHAR(6) DEFAULT '' NOT NULL, - group_description VARCHAR(255) DEFAULT '' NOT NULL, - PRIMARY KEY (group_id) -); - --- Table: 'phpbb_groups_moderator' -CREATE TABLE phpbb_groups_moderator ( - group_id INTEGER NOT NULL, - user_id INTEGER NOT NULL -); - --- Table: 'phpbb_icons' + group_id INTEGER PRIMARY KEY NOT NULL, + group_type tinyint(4) NOT NULL DEFAULT '1', + group_name varchar(40) NOT NULL DEFAULT '', + group_display tinyint(1) NOT NULL DEFAULT '0', + group_avatar varchar(100) NOT NULL DEFAULT '', + group_avatar_type tinyint(4) NOT NULL DEFAULT '0', + group_avatar_width tinyint(4) NOT NULL DEFAULT '0', + group_avatar_height tinyint(4) NOT NULL DEFAULT '0', + group_rank smallint(5) NOT NULL DEFAULT '-1', + group_colour varchar(6) NOT NULL DEFAULT '', + group_sig_chars mediumint(8) NOT NULL DEFAULT '0', + group_receive_pm tinyint(1) NOT NULL DEFAULT '0', + group_message_limit mediumint(8) NOT NULL DEFAULT '0', + group_chgpass smallint(6) NOT NULL DEFAULT '0', + group_description varchar(255) NOT NULL DEFAULT '', + group_legend tinyint(1) NOT NULL DEFAULT '1' +); + +CREATE INDEX group_legend_phpbb_groups on phpbb_groups (group_legend); + +# Table: phpbb_icons CREATE TABLE phpbb_icons ( - icons_id INTEGER NOT NULL, - icons_url VARCHAR(50), - icons_width INTEGER NOT NULL, - icons_height INTEGER NOT NULL, - icons_order INTEGER NOT NULL, - display_on_posting INTEGER DEFAULT 1 NOT NULL, - PRIMARY KEY (icons_id) + icons_id INTEGER PRIMARY KEY NOT NULL, + icons_url varchar(50), + icons_width tinyint(4) NOT NULL, + icons_height tinyint(4) NOT NULL, + icons_order tinyint(4) NOT NULL, + display_on_posting tinyint(1) NOT NULL DEFAULT '1' ); --- Table: 'phpbb_lang' +# Table: phpbb_lang CREATE TABLE phpbb_lang ( - lang_id INTEGER NOT NULL, - lang_iso VARCHAR(5) NOT NULL, - lang_dir VARCHAR(30) NOT NULL, - lang_english_name VARCHAR(30), - lang_local_name VARCHAR(100), - lang_author VARCHAR(100), - PRIMARY KEY (lang_id) + lang_id INTEGER PRIMARY KEY NOT NULL, + lang_iso varchar(5) NOT NULL, + lang_dir varchar(30) NOT NULL, + lang_english_name varchar(30), + lang_local_name varchar(100), + lang_author varchar(100) ); --- Table: 'phpbb_log' +# Table: phpbb_log CREATE TABLE phpbb_log ( - log_id INTEGER DEFAULT 0 NOT NULL, - log_type INTEGER DEFAULT 0 NOT NULL, - user_id INTEGER DEFAULT 0 NOT NULL, - forum_id INTEGER DEFAULT 0 NOT NULL, - topic_id INTEGER DEFAULT 0 NOT NULL, - log_ip VARCHAR(40) NOT NULL, - log_time INTEGER NOT NULL, - log_operation TEXT, - log_data TEXT, - PRIMARY KEY (log_id) -); - -CREATE INDEX log_type ON phpbb_log (log_type); -CREATE INDEX forum_id2 ON phpbb_log (forum_id); -CREATE INDEX topic_id ON phpbb_log (topic_id); -CREATE INDEX user_id3 ON phpbb_log (user_id); - --- Table: 'phpbb_moderator_cache' + log_id INTEGER PRIMARY KEY NOT NULL, + log_type tinyint(4) NOT NULL DEFAULT '0', + user_id mediumint(8) NOT NULL DEFAULT '0', + forum_id mediumint(8) NOT NULL DEFAULT '0', + topic_id mediumint(8) NOT NULL DEFAULT '0', + reportee_id mediumint(8) NOT NULL DEFAULT '0', + log_ip varchar(40) NOT NULL, + log_time int(11) NOT NULL, + log_operation text(65535), + log_data text(65535) +); + +CREATE INDEX log_type_phpbb_log on phpbb_log (log_type); +CREATE INDEX forum_id_phpbb_log on phpbb_log (forum_id); +CREATE INDEX topic_id_phpbb_log on phpbb_log (topic_id); +CREATE INDEX reportee_id_phpbb_log on phpbb_log (reportee_id); +CREATE INDEX user_id_phpbb_log on phpbb_log (user_id); + +# Table: phpbb_moderator_cache CREATE TABLE phpbb_moderator_cache ( - forum_id INTEGER NOT NULL, - user_id INTEGER, - username CHAR(30), - group_id INTEGER, - groupname CHAR(30), - display_on_index INTEGER DEFAULT 1 NOT NULL + forum_id mediumint(8) NOT NULL, + user_id mediumint(8) NOT NULL DEFAULT '0', + username char(30) NOT NULL DEFAULT '', + group_id mediumint(8) NOT NULL DEFAULT '0', + groupname char(30) NOT NULL DEFAULT '', + display_on_index tinyint(1) NOT NULL DEFAULT '1' ); -CREATE INDEX display_on_index ON phpbb_moderator_cache (display_on_index); -CREATE INDEX forum_id3 ON phpbb_moderator_cache (forum_id); +CREATE INDEX display_on_index_phpbb_moderat on phpbb_moderator_cache (display_on_index); +CREATE INDEX forum_id_phpbb_moderator_cache on phpbb_moderator_cache (forum_id); --- Table: 'phpbb_poll_results' +# Table: phpbb_modules +CREATE TABLE phpbb_modules ( + module_id INTEGER PRIMARY KEY NOT NULL, + module_type char(3) NOT NULL DEFAULT '', + module_title varchar(50) NOT NULL DEFAULT '', + module_filename varchar(50) NOT NULL DEFAULT '', + module_order mediumint(4) NOT NULL DEFAULT '0', + module_enabled tinyint(1) NOT NULL DEFAULT '1', + module_subs text(65535) NOT NULL, + module_acl varchar(255) NOT NULL DEFAULT '' +); + +CREATE INDEX module_type_phpbb_modules on phpbb_modules (module_type, module_enabled); + +# Table: phpbb_poll_results CREATE TABLE phpbb_poll_results ( - poll_option_id INTEGER DEFAULT 0 NOT NULL, - topic_id INTEGER DEFAULT 0 NOT NULL, - poll_option_text VARCHAR(255) DEFAULT '' NOT NULL, - poll_option_total INTEGER DEFAULT 0 NOT NULL + poll_option_id tinyint(4) NOT NULL DEFAULT '0', + topic_id mediumint(8) NOT NULL, + poll_option_text varchar(255) NOT NULL, + poll_option_total mediumint(8) NOT NULL DEFAULT '0' ); -CREATE INDEX poll_option_id ON phpbb_poll_results (poll_option_id); -CREATE INDEX topic_id3 ON phpbb_poll_results (topic_id); +CREATE INDEX poll_option_id_phpbb_poll_resu on phpbb_poll_results (poll_option_id); +CREATE INDEX topic_id_phpbb_poll_results on phpbb_poll_results (topic_id); --- Table: 'phpbb_poll_voters' +# Table: phpbb_poll_voters CREATE TABLE phpbb_poll_voters ( - topic_id INTEGER DEFAULT 0 NOT NULL, - poll_option_id INTEGER DEFAULT 0 NOT NULL, - vote_user_id INTEGER DEFAULT 0 NOT NULL, - vote_user_ip VARCHAR(40) DEFAULT '' NOT NULL + topic_id mediumint(8) NOT NULL DEFAULT '0', + poll_option_id tinyint(4) NOT NULL DEFAULT '0', + vote_user_id mediumint(8) NOT NULL DEFAULT '0', + vote_user_ip varchar(40) NOT NULL ); -CREATE INDEX topic_id4 ON phpbb_poll_voters (topic_id); -CREATE INDEX vote_user_id ON phpbb_poll_voters (vote_user_id); -CREATE INDEX vote_user_ip ON phpbb_poll_voters (vote_user_ip); +CREATE INDEX topic_id_phpbb_poll_voters on phpbb_poll_voters (topic_id); +CREATE INDEX vote_user_id_phpbb_poll_voters on phpbb_poll_voters (vote_user_id); +CREATE INDEX vote_user_ip_phpbb_poll_voters on phpbb_poll_voters (vote_user_ip); --- Table: 'phpbb_posts' +# Table: phpbb_posts CREATE TABLE phpbb_posts ( - post_id INTEGER NOT NULL, - topic_id INTEGER DEFAULT 0 NOT NULL, - forum_id INTEGER DEFAULT 0 NOT NULL, - poster_id INTEGER DEFAULT 0 NOT NULL, - icon_id INTEGER DEFAULT 1 NOT NULL, - poster_ip VARCHAR(40) DEFAULT '' NOT NULL, - post_time INTEGER DEFAULT 0 NOT NULL, - post_approved INTEGER DEFAULT 1 NOT NULL, - post_reported INTEGER DEFAULT 0 NOT NULL, - enable_bbcode INTEGER DEFAULT 1 NOT NULL, - enable_html INTEGER DEFAULT 0 NOT NULL, - enable_smilies INTEGER DEFAULT 1 NOT NULL, - enable_magic_url INTEGER DEFAULT 1 NOT NULL, - enable_sig INTEGER DEFAULT 1 NOT NULL, - post_username VARCHAR(30) DEFAULT '', - post_subject VARCHAR(60) DEFAULT '', - post_text TEXT DEFAULT '' NOT NULL, - post_checksum VARCHAR(32) DEFAULT '' NOT NULL, - post_encoding VARCHAR(11) DEFAULT 'iso-8859-15' NOT NULL, - post_attachment INTEGER DEFAULT 0 NOT NULL, - bbcode_bitfield INTEGER DEFAULT 0 NOT NULL, - bbcode_uid VARCHAR(10) DEFAULT '' NOT NULL, - post_edit_time INTEGER DEFAULT 0 NOT NULL, - post_edit_count INTEGER DEFAULT 0 NOT NULL, - post_edit_locked INTEGER DEFAULT 0 NOT NULL, - PRIMARY KEY (post_id) -); - -CREATE INDEX forum_id4 ON phpbb_posts (forum_id); -CREATE INDEX topic_id5 ON phpbb_posts (topic_id); -CREATE INDEX poster_ip ON phpbb_posts (poster_ip); -CREATE INDEX poster_id ON phpbb_posts (poster_id); -CREATE INDEX post_approved ON phpbb_posts (post_approved); - --- Table: 'phpbb_privmsgs' + post_id INTEGER PRIMARY KEY NOT NULL, + topic_id mediumint(8) NOT NULL DEFAULT '0', + forum_id smallint(5) NOT NULL DEFAULT '0', + poster_id mediumint(8) NOT NULL DEFAULT '0', + icon_id tinyint(4) NOT NULL DEFAULT '1', + poster_ip varchar(40) NOT NULL, + post_time int(11) NOT NULL DEFAULT '0', + post_approved tinyint(1) NOT NULL DEFAULT '1', + post_reported tinyint(1) NOT NULL DEFAULT '0', + enable_bbcode tinyint(1) NOT NULL DEFAULT '1', + enable_html tinyint(1) NOT NULL DEFAULT '0', + enable_smilies tinyint(1) NOT NULL DEFAULT '1', + enable_magic_url tinyint(1) NOT NULL DEFAULT '1', + enable_sig tinyint(1) NOT NULL DEFAULT '1', + post_username varchar(30), + post_subject varchar(60), + post_text mediumtext(16777215), + post_checksum varchar(32) NOT NULL, + post_encoding varchar(11) NOT NULL DEFAULT 'iso-8859-15', + post_attachment tinyint(1) NOT NULL DEFAULT '0', + bbcode_bitfield int(11) NOT NULL DEFAULT '0', + bbcode_uid varchar(5) NOT NULL DEFAULT '', + post_edit_time int(11) NOT NULL DEFAULT '0', + post_edit_reason varchar(100), + post_edit_user mediumint(8) NOT NULL DEFAULT '0', + post_edit_count smallint(5) NOT NULL DEFAULT '0', + post_edit_locked tinyint(1) NOT NULL DEFAULT '0' +); + +CREATE INDEX forum_id_phpbb_posts on phpbb_posts (forum_id); +CREATE INDEX topic_id_phpbb_posts on phpbb_posts (topic_id); +CREATE INDEX poster_ip_phpbb_posts on phpbb_posts (poster_ip); +CREATE INDEX poster_id_phpbb_posts on phpbb_posts (poster_id); +CREATE INDEX post_approved_phpbb_posts on phpbb_posts (post_approved); +CREATE INDEX post_time_phpbb_posts on phpbb_posts (post_time); + +# Table: phpbb_privmsgs CREATE TABLE phpbb_privmsgs ( - privmsgs_id INTEGER NOT NULL, - privmsgs_attachment INTEGER DEFAULT 0 NOT NULL, - privmsgs_type INTEGER DEFAULT 0 NOT NULL, - privmsgs_subject VARCHAR(60) DEFAULT 0 NOT NULL, - privmsgs_from_userid INTEGER DEFAULT 0 NOT NULL, - privmsgs_to_userid INTEGER DEFAULT 0 NOT NULL, - privmsgs_date INTEGER DEFAULT 0 NOT NULL, - privmsgs_ip VARCHAR(40) NOT NULL, - privmsgs_enable_bbcode INTEGER DEFAULT 1 NOT NULL, - privmsgs_enable_html INTEGER DEFAULT 0 NOT NULL, - privmsgs_enable_smilies INTEGER DEFAULT 1 NOT NULL, - privmsgs_attach_sig INTEGER DEFAULT 1 NOT NULL, - privmsgs_text TEXT, - privmsgs_bbcode_uid VARCHAR(10) DEFAULT 0 NOT NULL, - PRIMARY KEY (privmsgs_id) -); - -CREATE INDEX privmsgs_from_userid ON phpbb_privmsgs (privmsgs_from_userid); -CREATE INDEX privmsgs_to_userid ON phpbb_privmsgs (privmsgs_to_userid); - --- Table: 'phpbb_ranks' + msg_id INTEGER PRIMARY KEY NOT NULL, + root_level mediumint(8) NOT NULL DEFAULT '0', + author_id mediumint(8) NOT NULL DEFAULT '0', + icon_id tinyint(4) NOT NULL DEFAULT '1', + author_ip varchar(40) NOT NULL DEFAULT '', + message_time int(11) NOT NULL DEFAULT '0', + message_reported tinyint(1) NOT NULL DEFAULT '0', + enable_bbcode tinyint(1) NOT NULL DEFAULT '1', + enable_html tinyint(1) NOT NULL DEFAULT '0', + enable_smilies tinyint(1) NOT NULL DEFAULT '1', + enable_magic_url tinyint(1) NOT NULL DEFAULT '1', + enable_sig tinyint(1) NOT NULL DEFAULT '1', + message_subject varchar(60), + message_text mediumtext(16777215), + message_edit_reason varchar(100), + message_edit_user mediumint(8) NOT NULL DEFAULT '0', + message_checksum varchar(32) NOT NULL DEFAULT '', + message_encoding varchar(11) NOT NULL DEFAULT 'iso-8859-15', + message_attachment tinyint(1) NOT NULL DEFAULT '0', + bbcode_bitfield int(11) NOT NULL DEFAULT '0', + bbcode_uid varchar(5) NOT NULL DEFAULT '', + message_edit_time int(11) NOT NULL DEFAULT '0', + message_edit_count smallint(5) NOT NULL DEFAULT '0', + to_address text(65535), + bcc_address text(65535) +); + +CREATE INDEX author_ip_phpbb_privmsgs on phpbb_privmsgs (author_ip); +CREATE INDEX message_time_phpbb_privmsgs on phpbb_privmsgs (message_time); +CREATE INDEX author_id_phpbb_privmsgs on phpbb_privmsgs (author_id); +CREATE INDEX root_level_phpbb_privmsgs on phpbb_privmsgs (root_level); + +# Table: phpbb_privmsgs_folder +CREATE TABLE phpbb_privmsgs_folder ( + folder_id INTEGER PRIMARY KEY NOT NULL, + user_id mediumint(8) NOT NULL DEFAULT '0', + folder_name varchar(40) NOT NULL DEFAULT '', + pm_count mediumint(8) NOT NULL DEFAULT '0' +); + +CREATE INDEX user_id_phpbb_privmsgs_folder on phpbb_privmsgs_folder (user_id); + +# Table: phpbb_privmsgs_rules +CREATE TABLE phpbb_privmsgs_rules ( + rule_id INTEGER PRIMARY KEY NOT NULL, + user_id mediumint(8) NOT NULL DEFAULT '0', + rule_check mediumint(4) NOT NULL DEFAULT '0', + rule_connection mediumint(4) NOT NULL DEFAULT '0', + rule_string varchar(255) NOT NULL DEFAULT '', + rule_user_id mediumint(8) NOT NULL DEFAULT '0', + rule_group_id mediumint(8) NOT NULL DEFAULT '0', + rule_action mediumint(4) NOT NULL DEFAULT '0', + rule_folder_id mediumint(8) NOT NULL DEFAULT '0' +); + +# Table: phpbb_privmsgs_to +CREATE TABLE phpbb_privmsgs_to ( + msg_id mediumint(8) NOT NULL DEFAULT '0', + user_id mediumint(8) NOT NULL DEFAULT '0', + author_id mediumint(8) NOT NULL DEFAULT '0', + deleted tinyint(1) NOT NULL DEFAULT '0', + new tinyint(1) NOT NULL DEFAULT '1', + unread tinyint(1) NOT NULL DEFAULT '1', + replied tinyint(1) NOT NULL DEFAULT '0', + marked tinyint(1) NOT NULL DEFAULT '0', + forwarded tinyint(1) NOT NULL DEFAULT '0', + folder_id int(10) NOT NULL DEFAULT '0' +); + +CREATE INDEX msg_id_phpbb_privmsgs_to on phpbb_privmsgs_to (msg_id); +CREATE INDEX user_id_phpbb_privmsgs_to on phpbb_privmsgs_to (user_id, folder_id); + +# Table: phpbb_profile_fields +CREATE TABLE phpbb_profile_fields ( + field_id INTEGER PRIMARY KEY NOT NULL, + field_name varchar(50) NOT NULL DEFAULT '', + field_desc varchar(255) NOT NULL DEFAULT '', + field_type mediumint(8) NOT NULL, + field_ident varchar(20) NOT NULL DEFAULT '', + field_length varchar(20) NOT NULL DEFAULT '', + field_minlen varchar(255) NOT NULL DEFAULT '', + field_maxlen varchar(255) NOT NULL DEFAULT '', + field_novalue varchar(255) NOT NULL DEFAULT '', + field_default_value varchar(255) NOT NULL DEFAULT '0', + field_validation varchar(20) NOT NULL DEFAULT '', + field_required tinyint(1) NOT NULL DEFAULT '0', + field_show_on_reg tinyint(1) NOT NULL DEFAULT '0', + field_hide tinyint(1) NOT NULL DEFAULT '0', + field_no_view tinyint(1) NOT NULL DEFAULT '0', + field_active tinyint(1) NOT NULL DEFAULT '0', + field_order tinyint(4) NOT NULL DEFAULT '0' +); + +CREATE INDEX field_type_phpbb_profile_field on phpbb_profile_fields (field_type); +CREATE INDEX field_order_phpbb_profile_fiel on phpbb_profile_fields (field_order); + +# Table: phpbb_profile_fields_data +CREATE TABLE phpbb_profile_fields_data ( + user_id INTEGER PRIMARY KEY NOT NULL DEFAULT '0' +); + +# Table: phpbb_profile_fields_lang +CREATE TABLE phpbb_profile_fields_lang ( + field_id mediumint(8) NOT NULL DEFAULT '0', + lang_id mediumint(8) NOT NULL DEFAULT '0', + option_id mediumint(8) NOT NULL DEFAULT '0', + field_type tinyint(4) NOT NULL DEFAULT '0', + value varchar(255) NOT NULL DEFAULT '', + PRIMARY KEY (field_id, lang_id, option_id) +); + +# Table: phpbb_profile_lang +CREATE TABLE phpbb_profile_lang ( + field_id mediumint(8) NOT NULL DEFAULT '0', + lang_id tinyint(4) NOT NULL DEFAULT '0', + lang_name varchar(255) NOT NULL DEFAULT '', + lang_explain text(65535) NOT NULL, + lang_default_value varchar(255) NOT NULL DEFAULT '', + PRIMARY KEY (field_id, lang_id) +); + +# Table: phpbb_ranks CREATE TABLE phpbb_ranks ( - rank_id INTEGER NOT NULL, - rank_title VARCHAR(50) NOT NULL, - rank_min INTEGER DEFAULT 0 NOT NULL, - rank_special INTEGER DEFAULT 0, - rank_image VARCHAR(100), - PRIMARY KEY (rank_id) + rank_id INTEGER PRIMARY KEY NOT NULL, + rank_title varchar(50) NOT NULL, + rank_min mediumint(8) NOT NULL DEFAULT '0', + rank_special tinyint(1) DEFAULT '0', + rank_image varchar(100) ); --- Table: 'phpbb_reports_reasons' +# Table: phpbb_reports_reasons CREATE TABLE phpbb_reports_reasons ( - reason_id INTEGER NOT NULL, - reason_priority INTEGER DEFAULT 0 NOT NULL, - reason_name VARCHAR(255) DEFAULT '' NOT NULL, - reason_description TEXT NOT NULL, - PRIMARY KEY (reason_id) + reason_id INTEGER PRIMARY KEY NOT NULL, + reason_priority tinyint(4) NOT NULL DEFAULT '0', + reason_name varchar(255) NOT NULL DEFAULT '', + reason_description text(65535) NOT NULL ); --- Table: 'phpbb_reports' +# Table: phpbb_reports CREATE TABLE phpbb_reports ( - report_id INTEGER NOT NULL, - reason_id INTEGER DEFAULT 0 NOT NULL, - post_id INTEGER DEFAULT 0 NOT NULL, - user_id INTEGER DEFAULT 0 NOT NULL, - user_notify INTEGER DEFAULT 0 NOT NULL, - report_time INTEGER DEFAULT 0 NOT NULL, - report_text TEXT NOT NULL, - PRIMARY KEY (report_id) + report_id INTEGER PRIMARY KEY NOT NULL, + reason_id smallint(5) NOT NULL DEFAULT '0', + post_id mediumint(8) NOT NULL DEFAULT '0', + msg_id mediumint(8) NOT NULL DEFAULT '0', + user_id mediumint(8) NOT NULL DEFAULT '0', + user_notify tinyint(1) NOT NULL DEFAULT '0', + report_time int(10) NOT NULL DEFAULT '0', + report_text text(65535) NOT NULL ); --- Table: phpbb_search_results +# Table: phpbb_search_results CREATE TABLE phpbb_search_results ( - search_id INTEGER DEFAULT 0 NOT NULL, - session_id VARCHAR(32) DEFAULT '' NOT NULL, - search_array TEXT NOT NULL, - PRIMARY KEY (search_id) + search_id INTEGER PRIMARY KEY NOT NULL DEFAULT '0', + session_id varchar(32) NOT NULL DEFAULT '', + search_time int(11) NOT NULL DEFAULT '0', + search_array mediumtext(16777215) NOT NULL ); -CREATE INDEX session_id ON phpbb_search_results (session_id); +CREATE INDEX session_id_phpbb_search_result on phpbb_search_results (session_id); --- Table: phpbb_search_wordlist +# Table: phpbb_search_wordlist CREATE TABLE phpbb_search_wordlist ( - word_id INTEGER NOT NULL, - word_text VARCHAR(50) DEFAULT '' NOT NULL, - word_common INTEGER DEFAULT 0 NOT NULL, - PRIMARY KEY (word_id) + word_text varchar(50) NOT NULL DEFAULT '', + word_id mediumint NOT NULL, + word_common tinyint(1) NOT NULL DEFAULT '0', + PRIMARY KEY (word_text) ); -CREATE INDEX word_id ON phpbb_search_wordlist (word_id); +CREATE INDEX word_id_phpbb_search_wordlist on phpbb_search_wordlist (word_id); --- Table: phpbb_search_wordmatch +# Table: phpbb_search_wordmatch CREATE TABLE phpbb_search_wordmatch ( - post_id INTEGER DEFAULT 0 NOT NULL, - word_id INTEGER DEFAULT 0 NOT NULL, - title_match INTEGER DEFAULT 0 NOT NULL + post_id mediumint(8) NOT NULL DEFAULT '0', + word_id mediumint(8) NOT NULL DEFAULT '0', + title_match tinyint(1) NOT NULL DEFAULT '0' ); -CREATE INDEX word_id2 ON phpbb_search_wordmatch (word_id); +CREATE INDEX word_id_phpbb_search_wordmatch on phpbb_search_wordmatch (word_id); --- Table: 'phpbb_sessions' +# Table: phpbb_sessions CREATE TABLE phpbb_sessions ( - session_id VARCHAR(32) DEFAULT '' NOT NULL, - session_user_id INTEGER DEFAULT 0 NOT NULL, - session_last_visit INTEGER DEFAULT 0 NOT NULL, - session_start INTEGER DEFAULT 0 NOT NULL, - session_time INTEGER DEFAULT 0 NOT NULL, - session_ip VARCHAR(40) DEFAULT 0 NOT NULL, - session_browser VARCHAR(100) DEFAULT '' NOT NULL, - session_page VARCHAR(100) DEFAULT 0 NOT NULL, - session_allow_viewonline INTEGER DEFAULT 1 NOT NULL, - PRIMARY KEY (session_id) + session_id varchar(32) NOT NULL DEFAULT '', + session_user_id mediumint(8) NOT NULL DEFAULT '0', + session_last_visit int(11) NOT NULL DEFAULT '0', + session_start int(11) NOT NULL DEFAULT '0', + session_time int(11) NOT NULL DEFAULT '0', + session_ip varchar(40) NOT NULL DEFAULT '0', + session_browser varchar(100) NOT NULL DEFAULT '', + session_page varchar(100) NOT NULL DEFAULT '', + session_viewonline tinyint(1) NOT NULL DEFAULT '1', + session_admin tinyint(1) NOT NULL DEFAULT '0', + PRIMARY KEY (session_id) +); + +CREATE INDEX session_time_phpbb_sessions on phpbb_sessions (session_time); +CREATE INDEX session_user_id_phpbb_sessions on phpbb_sessions (session_user_id); + +# Table: phpbb_sitelist +CREATE TABLE phpbb_sitelist ( + site_id INTEGER PRIMARY KEY NOT NULL, + site_ip varchar(40) NOT NULL DEFAULT '', + site_hostname varchar(255) NOT NULL DEFAULT '', + ip_exclude tinyint(1) NOT NULL DEFAULT '0' +); + +# Table: phpbb_smilies +CREATE TABLE phpbb_smilies ( + smiley_id INTEGER PRIMARY KEY NOT NULL, + code char(10), + emotion char(50), + smiley_url char(50), + smiley_width tinyint(4) NOT NULL, + smiley_height tinyint(4) NOT NULL, + smiley_order tinyint(4) NOT NULL, + display_on_posting tinyint(1) NOT NULL DEFAULT '1' ); -CREATE INDEX session_time ON phpbb_sessions (session_time); - --- Table: 'phpbb_smilies' -CREATE TABLE phpbb_smilies ( - smile_id INTEGER NOT NULL, - code CHAR(10) DEFAULT '' NOT NULL, - emoticon CHAR(50) DEFAULT '' NOT NULL, - smile_url CHAR(50) DEFAULT '' NOT NULL, - smile_width INTEGER DEFAULT 0 NOT NULL, - smile_height INTEGER DEFAULT 0 NOT NULL, - smile_order INTEGER DEFAULT 1 NOT NULL, - display_on_posting INTEGER DEFAULT 1 NOT NULL, - PRIMARY KEY (smile_id) -); - --- Table: 'phpbb_styles' +# Table: phpbb_styles CREATE TABLE phpbb_styles ( - style_id INTEGER NOT NULL, - template_id CHAR(50) DEFAULT '' NOT NULL, - theme_id INTEGER DEFAULT 0 NOT NULL, - imageset_id INTEGER DEFAULT 0 NOT NULL, - style_name CHAR(30) DEFAULT '' NOT NULL, - PRIMARY KEY (style_id) + style_id INTEGER PRIMARY KEY NOT NULL, + style_name varchar(30) NOT NULL DEFAULT '', + style_copyright varchar(50) NOT NULL DEFAULT '', + style_active tinyint(1) NOT NULL DEFAULT '1', + template_id tinyint(4) NOT NULL, + theme_id tinyint(4) NOT NULL, + imageset_id tinyint(4) NOT NULL ); -CREATE INDEX template_id ON phpbb_styles (template_id); -CREATE INDEX theme_id ON phpbb_styles (theme_id); -CREATE INDEX imageset_id ON phpbb_styles (imageset_id); +CREATE INDEX B_phpbb_styles on phpbb_styles (template_id); +CREATE INDEX C_phpbb_styles on phpbb_styles (theme_id); +CREATE INDEX D_phpbb_styles on phpbb_styles (imageset_id); +CREATE UNIQUE INDEX style_name_phpbb_styles on phpbb_styles (style_name); --- Table: 'phpbb_styles_template' +# Table: phpbb_styles_template CREATE TABLE phpbb_styles_template ( - template_id INTEGER NOT NULL, - template_name CHAR(30) DEFAULT '' NOT NULL, - template_path CHAR(50) DEFAULT '' NOT NULL, - poll_length INTEGER DEFAULT 0 NOT NULL, - pm_box_length INTEGER DEFAULT 0 NOT NULL, - bbcode_bitfield INT DEFAULT 0 NOT NULL, - PRIMARY KEY (template_id) + template_id INTEGER PRIMARY KEY NOT NULL, + template_name varchar(30) NOT NULL, + template_copyright varchar(50) NOT NULL, + template_path varchar(30) NOT NULL, + bbcode_bitfield int(11) NOT NULL DEFAULT '0', + template_storedb tinyint(1) NOT NULL DEFAULT '0' ); --- Table: 'phpbb_styles_theme' +CREATE UNIQUE INDEX template_name_phpbb_styles_tem on phpbb_styles_template (template_name); + +# Table: phpbb_styles_template_data +CREATE TABLE phpbb_styles_template_data ( + template_id tinyint(4) NOT NULL, + template_filename varchar(50) NOT NULL DEFAULT '', + template_included text(65535) NOT NULL, + template_mtime int(11) NOT NULL DEFAULT '0', + template_data mediumtext(16777215) +); + +CREATE INDEX B_phpbb_styles_template_data on phpbb_styles_template_data (template_id); +CREATE INDEX C_phpbb_styles_template_data on phpbb_styles_template_data (template_filename); + +# Table: phpbb_styles_theme CREATE TABLE phpbb_styles_theme ( - theme_id INTEGER NOT NULL, - theme_name CHAR(60) DEFAULT '' NOT NULL, - css_external CHAR(100) DEFAULT '' NOT NULL, - css_data TEXT, - PRIMARY KEY (theme_id) + theme_id INTEGER PRIMARY KEY NOT NULL, + theme_name varchar(30) NOT NULL DEFAULT '', + theme_copyright varchar(50) NOT NULL DEFAULT '', + theme_path varchar(30) NOT NULL DEFAULT '', + theme_storedb tinyint(1) NOT NULL DEFAULT '0', + theme_mtime int(11) NOT NULL DEFAULT '0', + theme_data mediumtext(16777215) NOT NULL DEFAULT '' ); --- Table: 'phpbb_styles_imageset' +CREATE UNIQUE INDEX theme_name_phpbb_styles_theme on phpbb_styles_theme (theme_name); + +# Table: phpbb_styles_imageset CREATE TABLE phpbb_styles_imageset ( - imageset_id INTEGER NOT NULL, - imageset_name CHAR(100), - imageset_path CHAR(30), - btn_post CHAR(200) DEFAULT '' NOT NULL, - btn_post_pm CHAR(200) DEFAULT '' NOT NULL, - btn_reply CHAR(200) DEFAULT '' NOT NULL, - btn_reply_pm CHAR(200) DEFAULT '' NOT NULL, - btn_locked CHAR(200) DEFAULT '' NOT NULL, - btn_profile CHAR(200) DEFAULT '' NOT NULL, - btn_pm CHAR(200) DEFAULT '' NOT NULL, - btn_delete CHAR(200) DEFAULT '' NOT NULL, - btn_ip CHAR(200) DEFAULT '' NOT NULL, - btn_quote CHAR(200) DEFAULT '' NOT NULL, - btn_search CHAR(200) DEFAULT '' NOT NULL, - btn_edit CHAR(200) DEFAULT '' NOT NULL, - btn_report CHAR(200) DEFAULT '' NOT NULL, - btn_email CHAR(200) DEFAULT '' NOT NULL, - btn_www CHAR(200) DEFAULT '' NOT NULL, - btn_icq CHAR(200) DEFAULT '' NOT NULL, - btn_aim CHAR(200) DEFAULT '' NOT NULL, - btn_yim CHAR(200) DEFAULT '' NOT NULL, - btn_msnm CHAR(200) DEFAULT '' NOT NULL, - btn_jabber CHAR(200) DEFAULT '' NOT NULL, - btn_online CHAR(200) DEFAULT '' NOT NULL, - btn_offline CHAR(200) DEFAULT '' NOT NULL, - btn_topic_watch CHAR(200) DEFAULT '' NOT NULL, - btn_topic_unwatch CHAR(200) DEFAULT '' NOT NULL, - icon_unapproved CHAR(200) DEFAULT '' NOT NULL, - icon_reported CHAR(200) DEFAULT '' NOT NULL, - icon_attach CHAR(200) DEFAULT '' NOT NULL, - icon_post CHAR(200) DEFAULT '' NOT NULL, - icon_post_new CHAR(200) DEFAULT '' NOT NULL, - icon_post_latest CHAR(200) DEFAULT '' NOT NULL, - icon_post_newest CHAR(200) DEFAULT '' NOT NULL, - forum CHAR(200) DEFAULT '' NOT NULL, - forum_new CHAR(200) DEFAULT '' NOT NULL, - forum_locked CHAR(200) DEFAULT '' NOT NULL, - forum_link CHAR(200) DEFAULT '' NOT NULL, - sub_forum CHAR(200) DEFAULT '' NOT NULL, - sub_forum_new CHAR(200) DEFAULT '' NOT NULL, - folder CHAR(200) DEFAULT '' NOT NULL, - folder_posted CHAR(200) DEFAULT '' NOT NULL, - folder_new CHAR(200) DEFAULT '' NOT NULL, - folder_new_posted CHAR(200) DEFAULT '' NOT NULL, - folder_hot CHAR(200) DEFAULT '' NOT NULL, - folder_hot_posted CHAR(200) DEFAULT '' NOT NULL, - folder_hot_new CHAR(200) DEFAULT '' NOT NULL, - folder_hot_new_posted CHAR(200) DEFAULT '' NOT NULL, - folder_locked CHAR(200) DEFAULT '' NOT NULL, - folder_locked_posted CHAR(200) DEFAULT '' NOT NULL, - folder_locked_new CHAR(200) DEFAULT '' NOT NULL, - folder_locked_new_posted CHAR(200) DEFAULT '' NOT NULL, - folder_sticky CHAR(200) DEFAULT '' NOT NULL, - folder_sticky_posted CHAR(200) DEFAULT '' NOT NULL, - folder_sticky_new CHAR(200) DEFAULT '' NOT NULL, - folder_sticky_new_posted CHAR(200) DEFAULT '' NOT NULL, - folder_announce CHAR(200) DEFAULT '' NOT NULL, - folder_announce_posted CHAR(200) DEFAULT '' NOT NULL, - folder_announce_new CHAR(200) DEFAULT '' NOT NULL, - folder_announce_new_posted CHAR(200) DEFAULT '' NOT NULL, - poll_left CHAR(200) DEFAULT '' NOT NULL, - poll_center CHAR(200) DEFAULT '' NOT NULL, - poll_right CHAR(200) DEFAULT '' NOT NULL, - PRIMARY KEY (imageset_id) -); - --- Table: 'phpbb_topics' + imageset_id INTEGER PRIMARY KEY NOT NULL, + imageset_name varchar(30) NOT NULL DEFAULT '', + imageset_copyright varchar(50) NOT NULL DEFAULT '', + imageset_path varchar(30) NOT NULL DEFAULT '', + site_logo varchar(200) NOT NULL DEFAULT '', + btn_post varchar(200) NOT NULL DEFAULT '', + btn_post_pm varchar(200) NOT NULL DEFAULT '', + btn_reply varchar(200) NOT NULL DEFAULT '', + btn_reply_pm varchar(200) NOT NULL DEFAULT '', + btn_locked varchar(200) NOT NULL DEFAULT '', + btn_profile varchar(200) NOT NULL DEFAULT '', + btn_pm varchar(200) NOT NULL DEFAULT '', + btn_delete varchar(200) NOT NULL DEFAULT '', + btn_info varchar(200) NOT NULL DEFAULT '', + btn_quote varchar(200) NOT NULL DEFAULT '', + btn_search varchar(200) NOT NULL DEFAULT '', + btn_edit varchar(200) NOT NULL DEFAULT '', + btn_report varchar(200) NOT NULL DEFAULT '', + btn_email varchar(200) NOT NULL DEFAULT '', + btn_www varchar(200) NOT NULL DEFAULT '', + btn_icq varchar(200) NOT NULL DEFAULT '', + btn_aim varchar(200) NOT NULL DEFAULT '', + btn_yim varchar(200) NOT NULL DEFAULT '', + btn_msnm varchar(200) NOT NULL DEFAULT '', + btn_jabber varchar(200) NOT NULL DEFAULT '', + btn_online varchar(200) NOT NULL DEFAULT '', + btn_offline varchar(200) NOT NULL DEFAULT '', + btn_friend varchar(200) NOT NULL DEFAULT '', + btn_foe varchar(200) NOT NULL DEFAULT '', + icon_unapproved varchar(200) NOT NULL DEFAULT '', + icon_reported varchar(200) NOT NULL DEFAULT '', + icon_attach varchar(200) NOT NULL DEFAULT '', + icon_post varchar(200) NOT NULL DEFAULT '', + icon_post_new varchar(200) NOT NULL DEFAULT '', + icon_post_latest varchar(200) NOT NULL DEFAULT '', + icon_post_newest varchar(200) NOT NULL DEFAULT '', + forum varchar(200) NOT NULL DEFAULT '', + forum_new varchar(200) NOT NULL DEFAULT '', + forum_locked varchar(200) NOT NULL DEFAULT '', + forum_link varchar(200) NOT NULL DEFAULT '', + sub_forum varchar(200) NOT NULL DEFAULT '', + sub_forum_new varchar(200) NOT NULL DEFAULT '', + folder varchar(200) NOT NULL DEFAULT '', + folder_moved varchar(200) NOT NULL DEFAULT '', + folder_posted varchar(200) NOT NULL DEFAULT '', + folder_new varchar(200) NOT NULL DEFAULT '', + folder_new_posted varchar(200) NOT NULL DEFAULT '', + folder_hot varchar(200) NOT NULL DEFAULT '', + folder_hot_posted varchar(200) NOT NULL DEFAULT '', + folder_hot_new varchar(200) NOT NULL DEFAULT '', + folder_hot_new_posted varchar(200) NOT NULL DEFAULT '', + folder_locked varchar(200) NOT NULL DEFAULT '', + folder_locked_posted varchar(200) NOT NULL DEFAULT '', + folder_locked_new varchar(200) NOT NULL DEFAULT '', + folder_locked_new_posted varchar(200) NOT NULL DEFAULT '', + folder_sticky varchar(200) NOT NULL DEFAULT '', + folder_sticky_posted varchar(200) NOT NULL DEFAULT '', + folder_sticky_new varchar(200) NOT NULL DEFAULT '', + folder_sticky_new_posted varchar(200) NOT NULL DEFAULT '', + folder_announce varchar(200) NOT NULL DEFAULT '', + folder_announce_posted varchar(200) NOT NULL DEFAULT '', + folder_announce_new varchar(200) NOT NULL DEFAULT '', + folder_announce_new_posted varchar(200) NOT NULL DEFAULT '', + folder_global varchar(200) NOT NULL DEFAULT '', + folder_global_posted varchar(200) NOT NULL DEFAULT '', + folder_global_new varchar(200) NOT NULL DEFAULT '', + folder_global_new_posted varchar(200) NOT NULL DEFAULT '', + poll_left varchar(200) NOT NULL DEFAULT '', + poll_center varchar(200) NOT NULL DEFAULT '', + poll_right varchar(200) NOT NULL DEFAULT '', + attach_progress_bar varchar(200) NOT NULL DEFAULT '', + user_icon1 varchar(200) NOT NULL DEFAULT '', + user_icon2 varchar(200) NOT NULL DEFAULT '', + user_icon3 varchar(200) NOT NULL DEFAULT '', + user_icon4 varchar(200) NOT NULL DEFAULT '', + user_icon5 varchar(200) NOT NULL DEFAULT '', + user_icon6 varchar(200) NOT NULL DEFAULT '', + user_icon7 varchar(200) NOT NULL DEFAULT '', + user_icon8 varchar(200) NOT NULL DEFAULT '', + user_icon9 varchar(200) NOT NULL DEFAULT '', + user_icon10 varchar(200) NOT NULL DEFAULT '' +); + +CREATE UNIQUE INDEX imageset_name_phpbb_styles_ima on phpbb_styles_imageset (imageset_name); + +# Table: phpbb_topics CREATE TABLE phpbb_topics ( - topic_id INTEGER NOT NULL, - forum_id INTEGER DEFAULT 0 NOT NULL, - icon_id INTEGER DEFAULT 1 NOT NULL, - topic_attachment INTEGER DEFAULT 0 NOT NULL, - topic_approved INTEGER DEFAULT 1 NOT NULL, - topic_reported INTEGER DEFAULT 0 NOT NULL, - topic_title VARCHAR(60) NOT NULL, - topic_poster INTEGER DEFAULT 0 NOT NULL, - topic_time INTEGER DEFAULT 0 NOT NULL, - topic_views INTEGER DEFAULT 0 NOT NULL, - topic_replies INTEGER DEFAULT 0 NOT NULL, - topic_replies_real INTEGER DEFAULT 0 NOT NULL, - topic_status INTEGER DEFAULT 0 NOT NULL, - topic_type INTEGER DEFAULT 0 NOT NULL, - topic_first_post_id INTEGER DEFAULT 0 NOT NULL, - topic_first_poster_name VARCHAR(30), - topic_last_post_id INTEGER DEFAULT 0 NOT NULL, - topic_last_poster_id INTEGER DEFAULT 0 NOT NULL, - topic_last_poster_name VARCHAR(30), - topic_last_post_time INTEGER DEFAULT 0 NOT NULL, - topic_last_view_time INTEGER DEFAULT 0 NOT NULL, - topic_moved_id INTEGER DEFAULT 0 NOT NULL, - poll_title VARCHAR(255) DEFAULT '' NOT NULL, - poll_start INTEGER DEFAULT 0 NOT NULL, - poll_length INTEGER DEFAULT 0 NOT NULL, - poll_max_options INTEGER DEFAULT 1 NOT NULL, - poll_last_vote INTEGER, - PRIMARY KEY (topic_id) -); - -CREATE INDEX forum_id5 ON phpbb_topics (forum_id); -CREATE INDEX forum_id_type ON phpbb_topics (forum_id, topic_type); -CREATE INDEX topic_last_post_time ON phpbb_topics (topic_last_post_time); - --- Table: 'phpbb_topic_marking' + topic_id INTEGER PRIMARY KEY NOT NULL, + forum_id smallint(8) NOT NULL DEFAULT '0', + icon_id tinyint(4) NOT NULL DEFAULT '1', + topic_attachment tinyint(1) NOT NULL DEFAULT '0', + topic_approved tinyint(1) NOT NULL DEFAULT '1', + topic_reported tinyint(1) NOT NULL DEFAULT '0', + topic_title varchar(60) NOT NULL, + topic_poster mediumint(8) NOT NULL DEFAULT '0', + topic_time int(11) NOT NULL DEFAULT '0', + topic_time_limit int(11) NOT NULL DEFAULT '0', + topic_views mediumint(8) NOT NULL DEFAULT '0', + topic_replies mediumint(8) NOT NULL DEFAULT '0', + topic_replies_real mediumint(8) NOT NULL DEFAULT '0', + topic_status tinyint(3) NOT NULL DEFAULT '0', + topic_type tinyint(3) NOT NULL DEFAULT '0', + topic_first_post_id mediumint(8) NOT NULL DEFAULT '0', + topic_first_poster_name varchar(30), + topic_last_post_id mediumint(8) NOT NULL DEFAULT '0', + topic_last_poster_id mediumint(8) NOT NULL DEFAULT '0', + topic_last_poster_name varchar(30), + topic_last_post_time int(11) NOT NULL DEFAULT '0', + topic_last_view_time int(11) NOT NULL DEFAULT '0', + topic_moved_id mediumint(8) NOT NULL DEFAULT '0', + topic_bumped tinyint(1) NOT NULL DEFAULT '0', + topic_bumper mediumint(8) NOT NULL DEFAULT '0', + poll_title varchar(255) NOT NULL, + poll_start int(11) NOT NULL DEFAULT '0', + poll_length int(11) NOT NULL DEFAULT '0', + poll_max_options tinyint(4) NOT NULL DEFAULT '1', + poll_last_vote int(11) DEFAULT '0', + poll_vote_change tinyint(1) NOT NULL DEFAULT '0' +); + +CREATE INDEX forum_id_phpbb_topics on phpbb_topics (forum_id); +CREATE INDEX forum_id_type_phpbb_topics on phpbb_topics (forum_id, topic_type); +CREATE INDEX topic_last_post_time_phpbb_top on phpbb_topics (topic_last_post_time); + +# Table: phpbb_topics_marking CREATE TABLE phpbb_topics_marking ( - user_id INTEGER DEFAULT 0 NOT NULL, - topic_id INTEGER DEFAULT 0 NOT NULL, - mark_type INTEGER DEFAULT 0 NOT NULL, - mark_time INTEGER DEFAULT 0 NOT NULL, - PRIMARY KEY (user_id, topic_id) + user_id mediumint(8) NOT NULL DEFAULT '0', + topic_id mediumint(8) NOT NULL DEFAULT '0', + forum_id mediumint(8) NOT NULL DEFAULT '0', + mark_type tinyint(4) NOT NULL DEFAULT '0', + mark_time int(11) NOT NULL DEFAULT '0', + PRIMARY KEY (user_id, topic_id) ); --- Table: 'phpbb_topics_watch' +# Table: phpbb_topics_watch CREATE TABLE phpbb_topics_watch ( - topic_id INTEGER DEFAULT 0 NOT NULL, - user_id INTEGER DEFAULT 0 NOT NULL, - notify_status INTEGER DEFAULT 0 NOT NULL + topic_id mediumint(8) NOT NULL DEFAULT '0', + user_id mediumint(8) NOT NULL DEFAULT '0', + notify_status tinyint(1) NOT NULL DEFAULT '0' ); -CREATE INDEX topic_id6 ON phpbb_topics_watch (topic_id); -CREATE INDEX user_id5 ON phpbb_topics_watch (user_id); -CREATE INDEX notify_status2 ON phpbb_topics_watch (notify_status); +CREATE INDEX topic_id_phpbb_topics_watch on phpbb_topics_watch (topic_id); +CREATE INDEX user_id_phpbb_topics_watch on phpbb_topics_watch (user_id); +CREATE INDEX notify_status_phpbb_topics_wat on phpbb_topics_watch (notify_status); --- Table: 'phpbb_ucp_modules' -CREATE TABLE phpbb_ucp_modules ( - module_id INTEGER DEFAULT 0 NOT NULL, - module_title VARCHAR(50) DEFAULT '' NOT NULL, - module_filename VARCHAR(50) DEFAULT '' NOT NULL, - module_order INTEGER DEFAULT 0 NOT NULL, - PRIMARY KEY (module_id) -); - --- Table: 'phpbb_user_group' +# Table: phpbb_user_group CREATE TABLE phpbb_user_group ( - group_id INTEGER DEFAULT 0 NOT NULL, - user_id INTEGER DEFAULT 0 NOT NULL, - user_pending INTEGER + group_id mediumint(8) NOT NULL DEFAULT '0', + user_id mediumint(8) NOT NULL DEFAULT '0', + group_leader tinyint(1) NOT NULL DEFAULT '0', + user_pending tinyint(1) ); -CREATE INDEX group_id2 ON phpbb_user_group (group_id); -CREATE INDEX user_id6 ON phpbb_user_group (user_id); +CREATE INDEX group_id_phpbb_user_group on phpbb_user_group (group_id); +CREATE INDEX user_id_phpbb_user_group on phpbb_user_group (user_id); +CREATE INDEX group_leader_phpbb_user_group on phpbb_user_group (group_leader); --- Table: 'phpbb_users' +# Table: phpbb_users CREATE TABLE phpbb_users ( - user_id INTEGER NOT NULL, - user_active INTEGER DEFAULT 1 NOT NULL, - user_founder INTEGER DEFAULT 0 NOT NULL, - group_id INTEGER DEFAULT 0 NOT NULL, - user_permissions TEXT DEFAULT '', - user_ip VARCHAR(40), - user_regdate INTEGER DEFAULT 0 NOT NULL, - username VARCHAR(30) NOT NULL, - user_password VARCHAR(32) NOT NULL, - user_email VARCHAR(60), - user_birthday VARCHAR(10) DEFAULT '' NOT NULL, - user_lastvisit INTEGER DEFAULT 0 NOT NULL, - user_lastpage VARCHAR(100) DEFAULT '' NOT NULL, - user_karma INTEGER DEFAULT '3' NOT NULL, - user_min_karma INTEGER DEFAULT '-5' NOT NULL, - user_startpage VARCHAR(100) DEFAULT '', - user_colour VARCHAR(6) DEFAULT '' NOT NULL, - user_posts INTEGER DEFAULT 0 NOT NULL, - user_lang VARCHAR(30) DEFAULT '' NOT NULL, - user_timezone decimal(5,2) DEFAULT 0 NOT NULL, - user_dst INTEGER DEFAULT 0 NOT NULL, - user_dateformat VARCHAR(15) DEFAULT 'd M Y H:i' NOT NULL, - user_style INTEGER DEFAULT 1 NOT NULL, - user_rank INTEGER DEFAULT 0 NOT NULL, - user_new_privmsg INTEGER DEFAULT 0 NOT NULL, - user_unread_privmsg INTEGER DEFAULT 0 NOT NULL, - user_last_privmsg INTEGER DEFAULT 0 NOT NULL, - user_emailtime INTEGER, - user_sortby_type VARCHAR(1) DEFAULT '' NOT NULL, - user_sortby_dir VARCHAR(1) DEFAULT '' NOT NULL, - user_show_days INTEGER DEFAULT 0 NOT NULL, - user_viewimg INTEGER DEFAULT 1 NOT NULL, - user_notify INTEGER DEFAULT 0 NOT NULL, - user_notify_pm INTEGER DEFAULT 1 NOT NULL, - user_popup_pm INTEGER DEFAULT 0 NOT NULL, - user_viewflash INTEGER DEFAULT 1 NOT NULL, - user_viewsmilies INTEGER DEFAULT 1 NOT NULL, - user_viewsigs INTEGER DEFAULT 1 NOT NULL, - user_viewavatars INTEGER DEFAULT 1 NOT NULL, - user_viewcensors INTEGER DEFAULT 1 NOT NULL, - user_attachsig INTEGER DEFAULT 1 NOT NULL, - user_allowhtml INTEGER DEFAULT 1 NOT NULL, - user_allowbbcode INTEGER DEFAULT 1 NOT NULL, - user_allowsmile INTEGER DEFAULT 1 NOT NULL, - user_allowavatar INTEGER DEFAULT 1 NOT NULL, - user_allow_pm INTEGER DEFAULT 1 NOT NULL, - user_allow_email INTEGER DEFAULT 1 NOT NULL, - user_allow_viewonline INTEGER DEFAULT 1 NOT NULL, - user_allow_viewemail INTEGER DEFAULT 1 NOT NULL, - user_allow_massemail INTEGER DEFAULT 1 NOT NULL, - user_avatar VARCHAR(100) DEFAULT '' NOT NULL, - user_avatar_type INTEGER DEFAULT 0 NOT NULL, - user_avatar_width INTEGER DEFAULT 0 NOT NULL, - user_avatar_height INTEGER DEFAULT 0 NOT NULL, - user_sig TEXT, - user_sig_bbcode_uid VARCHAR(5) DEFAULT '' NOT NULL, - user_sig_bbcode_bitfield INTEGER DEFAULT 0 NOT NULL, - user_from VARCHAR(100) DEFAULT '' NOT NULL, - user_icq VARCHAR(15) DEFAULT '' NOT NULL, - user_aim VARCHAR(255) DEFAULT '' NOT NULL, - user_yim VARCHAR(255) DEFAULT '' NOT NULL, - user_msnm VARCHAR(255) DEFAULT '' NOT NULL, - user_jabber VARCHAR(255) DEFAULT '' NOT NULL, - user_website VARCHAR(100) DEFAULT '' NOT NULL, - user_actkey VARCHAR(32) DEFAULT '' NOT NULL, - user_newpasswd VARCHAR(32) DEFAULT '' NOT NULL, - user_occ VARCHAR(255) DEFAULT '' NOT NULL, - user_interests VARCHAR(255) DEFAULT '' NOT NULL, - PRIMARY KEY (user_id) -); - -CREATE INDEX user_birthday ON phpbb_users (user_birthday); - --- Table: 'phpbb_words' + user_id INTEGER PRIMARY KEY NOT NULL, + user_type tinyint(1) NOT NULL DEFAULT '0', + group_id mediumint(8) NOT NULL DEFAULT '3', + user_permissions text(65535) NOT NULL DEFAULT '', + user_ip varchar(40) NOT NULL DEFAULT '', + user_regdate int(11) NOT NULL DEFAULT '0', + username varchar(30) NOT NULL DEFAULT '', + user_password varchar(32) NOT NULL DEFAULT '', + user_passchg int(11) NOT NULL DEFAULT '0', + user_email varchar(60) NOT NULL DEFAULT '', + user_email_hash bigint(20) NOT NULL DEFAULT '0', + user_birthday varchar(10) NOT NULL DEFAULT '', + user_lastvisit int(11) NOT NULL DEFAULT '0', + user_lastpost_time int(11) NOT NULL DEFAULT '0', + user_lastpage varchar(100) NOT NULL DEFAULT '', + user_last_confirm_key varchar(10) NOT NULL DEFAULT '', + user_warnings tinyint(4) NOT NULL DEFAULT '0', + user_posts mediumint(8) NOT NULL DEFAULT '0', + user_lang varchar(30) NOT NULL DEFAULT '', + user_timezone decimal(5,2) NOT NULL DEFAULT '0.0', + user_dst tinyint(1) NOT NULL DEFAULT '0', + user_dateformat varchar(15) NOT NULL DEFAULT 'd M Y H:i', + user_style tinyint(4) NOT NULL DEFAULT '0', + user_rank int(11) DEFAULT '0', + user_colour varchar(6) NOT NULL DEFAULT '', + user_new_privmsg tinyint(4) NOT NULL DEFAULT '0', + user_unread_privmsg tinyint(4) NOT NULL DEFAULT '0', + user_last_privmsg int(11) NOT NULL DEFAULT '0', + user_message_rules tinyint(1) NOT NULL DEFAULT '0', + user_full_folder int(11) NOT NULL DEFAULT '-3', + user_emailtime int(11) NOT NULL DEFAULT '0', + user_topic_show_days smallint(4) NOT NULL DEFAULT '0', + user_topic_sortby_type varchar(1) NOT NULL DEFAULT '', + user_topic_sortby_dir varchar(1) NOT NULL DEFAULT '', + user_post_show_days smallint(4) NOT NULL DEFAULT '0', + user_post_sortby_type varchar(1) NOT NULL DEFAULT '', + user_post_sortby_dir varchar(1) NOT NULL DEFAULT '', + user_notify tinyint(1) NOT NULL DEFAULT '0', + user_notify_pm tinyint(1) NOT NULL DEFAULT '1', + user_notify_type tinyint(4) NOT NULL DEFAULT '0', + user_allow_pm tinyint(1) NOT NULL DEFAULT '1', + user_allow_email tinyint(1) NOT NULL DEFAULT '1', + user_allow_viewonline tinyint(1) NOT NULL DEFAULT '1', + user_allow_viewemail tinyint(1) NOT NULL DEFAULT '1', + user_allow_massemail tinyint(1) NOT NULL DEFAULT '1', + user_options int(11) NOT NULL DEFAULT '893', + user_avatar varchar(100) NOT NULL DEFAULT '', + user_avatar_type tinyint(2) NOT NULL DEFAULT '0', + user_avatar_width tinyint(4) NOT NULL DEFAULT '0', + user_avatar_height tinyint(4) NOT NULL DEFAULT '0', + user_sig text(65535) NOT NULL DEFAULT '', + user_sig_bbcode_uid varchar(5) NOT NULL DEFAULT '', + user_sig_bbcode_bitfield int(11) NOT NULL DEFAULT '0', + user_from varchar(100) NOT NULL DEFAULT '', + user_icq varchar(15) NOT NULL DEFAULT '', + user_aim varchar(255) NOT NULL DEFAULT '', + user_yim varchar(255) NOT NULL DEFAULT '', + user_msnm varchar(255) NOT NULL DEFAULT '', + user_jabber varchar(255) NOT NULL DEFAULT '', + user_website varchar(100) NOT NULL DEFAULT '', + user_occ varchar(255) NOT NULL DEFAULT '', + user_interests varchar(255) NOT NULL DEFAULT '', + user_actkey varchar(32) NOT NULL DEFAULT '', + user_newpasswd varchar(32) NOT NULL DEFAULT '' +); + +CREATE INDEX user_birthday_phpbb_users on phpbb_users (user_birthday); +CREATE INDEX user_email_hash_phpbb_users on phpbb_users (user_email_hash); +CREATE INDEX username_phpbb_users on phpbb_users (username); + +# Table: phpbb_words CREATE TABLE phpbb_words ( - word_id INTEGER NOT NULL, - word CHAR(100) DEFAULT '' NOT NULL, - replacement CHAR(100) DEFAULT '' NOT NULL, - PRIMARY KEY (word_id) + word_id INTEGER PRIMARY KEY NOT NULL, + word char(100) NOT NULL, + replacement char(100) NOT NULL +); + +# Table: phpbb_zebra +CREATE TABLE phpbb_zebra ( + user_id mediumint(8) NOT NULL DEFAULT '0', + zebra_id mediumint(8) NOT NULL DEFAULT '0', + friend tinyint(1) NOT NULL DEFAULT '0', + foe tinyint(1) NOT NULL DEFAULT '0' ); + +CREATE INDEX user_id_phpbb_zebra on phpbb_zebra (user_id); +CREATE INDEX zebra_id_phpbb_zebra on phpbb_zebra (zebra_id); + +COMMIT; |