aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/install/schemas/sqlite_schema.sql
diff options
context:
space:
mode:
Diffstat (limited to 'phpBB/install/schemas/sqlite_schema.sql')
-rw-r--r--phpBB/install/schemas/sqlite_schema.sql1408
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;