diff options
Diffstat (limited to 'phpBB/db/mysql_schema.sql')
| -rw-r--r-- | phpBB/db/mysql_schema.sql | 68 |
1 files changed, 39 insertions, 29 deletions
diff --git a/phpBB/db/mysql_schema.sql b/phpBB/db/mysql_schema.sql index 00b7140716..5a45db6617 100644 --- a/phpBB/db/mysql_schema.sql +++ b/phpBB/db/mysql_schema.sql @@ -43,7 +43,7 @@ CREATE TABLE phpbb_user_group ( DROP TABLE IF EXISTS phpbb_groups; CREATE TABLE phpbb_groups ( group_id int(11) NOT NULL auto_increment, - group_type tinyint(4) DEFAULT '1' NOT NULL, + group_type tinyint(4) DEFAULT '1' NOT NULL, group_name varchar(40) NOT NULL, group_description varchar(255) NOT NULL, group_moderator int(11) DEFAULT '0' NOT NULL, @@ -85,46 +85,46 @@ CREATE TABLE phpbb_categories ( DROP TABLE IF EXISTS phpbb_config; CREATE TABLE phpbb_config ( config_id int(10) NOT NULL auto_increment, - board_disable tinyint(1) DEFAULT '0' NOT NULL, - board_startdate int(11), + board_disable tinyint(1) DEFAULT '0' NOT NULL, + board_startdate int(11), sitename varchar(100), cookie_name char(20), cookie_path char(25), - cookie_domain char(50), - cookie_secure tinyint(1), - session_length int(11), + cookie_domain char(50), + cookie_secure tinyint(1), + session_length int(11), allow_html tinyint(1), - allow_html_tags char(255) DEFAULT 'b,u,i,pre,font color' NOT NULL, + allow_html_tags char(255) DEFAULT 'b,u,i,pre,font color' NOT NULL, allow_bbcode tinyint(1), allow_smilies tinyint(1), allow_sig tinyint(1), allow_namechange tinyint(1), allow_theme_create tinyint(1), - allow_avatar_local tinyint(1) DEFAULT '0' NOT NULL, - allow_avatar_remote tinyint(1) DEFAULT '0' NOT NULL, + allow_avatar_local tinyint(1) DEFAULT '0' NOT NULL, + allow_avatar_remote tinyint(1) DEFAULT '0' NOT NULL, allow_avatar_upload tinyint(1) DEFAULT '0' NOT NULL, override_themes tinyint(3), posts_per_page int(10), topics_per_page int(10), hot_threshold int(10), email_sig varchar(255), - email_from varchar(100), - smtp_delivery smallint(1) DEFAULT '0' NOT NULL, - smtp_host varchar(50), - require_activation tinyint(1) DEFAULT '0' NOT NULL, + email_from varchar(100), + smtp_delivery smallint(1) DEFAULT '0' NOT NULL, + smtp_host varchar(50), + require_activation tinyint(1) DEFAULT '0' NOT NULL, flood_interval int(4) NOT NULL, avatar_filesize int(11) DEFAULT '6144' NOT NULL, - avatar_max_width smallint(6) DEFAULT '70' NOT NULL, - avatar_max_height smallint(6) DEFAULT '70' NOT NULL, + avatar_max_width smallint(6) DEFAULT '70' NOT NULL, + avatar_max_height smallint(6) DEFAULT '70' NOT NULL, avatar_path varchar(255) DEFAULT 'images/avatars' NOT NULL, - smilies_path char(100) DEFAULT 'images/smiles' NOT NULL, + smilies_path char(100) DEFAULT 'images/smiles' NOT NULL, default_theme int(11) DEFAULT '1' NOT NULL, default_lang varchar(255), default_dateformat varchar(14) DEFAULT 'd M Y H:i' NOT NULL, system_timezone int(11) DEFAULT '0' NOT NULL, sys_template varchar(100) DEFAULT 'Default' NOT NULL, - prune_enable tinyint(1) DEFAULT '1' NOT NULL, - gzip_compress tinyint(1) DEFAULT '0' NOT NULL, + prune_enable tinyint(1) DEFAULT '1' NOT NULL, + gzip_compress tinyint(1) DEFAULT '0' NOT NULL, PRIMARY KEY (config_id) ); @@ -164,7 +164,7 @@ CREATE TABLE phpbb_forums ( cat_id int(10) NOT NULL, forum_name varchar(150), forum_desc text, - forum_status tinyint(4) DEFAULT '0' NOT NULL, + forum_status tinyint(4) DEFAULT '0' NOT NULL, forum_order int(11) DEFAULT '1' NOT NULL, forum_posts int(11) DEFAULT '0' NOT NULL, forum_topics tinyint(4) DEFAULT '0' NOT NULL, @@ -201,8 +201,8 @@ CREATE TABLE phpbb_posts ( forum_id int(10) DEFAULT '0' NOT NULL, poster_id int(10) DEFAULT '0' NOT NULL, post_time int(10) DEFAULT '0' NOT NULL, - poster_ip char(8) NOT NULL, - post_username varchar(30), + poster_ip char(8) NOT NULL, + post_username varchar(30), enable_bbcode smallint(1) DEFAULT '1' NOT NULL, enable_html smallint(1) DEFAULT '0' NOT NULL, enable_smilies smallint(1) DEFAULT '1' NOT NULL, @@ -286,6 +286,17 @@ CREATE TABLE phpbb_ranks ( # # Table structure for table 'phpbb_session' # +# Note that if you're running 3.23.x you may want to make +# this table a type HEAP. This type of table is stored +# within system memory and therefore for big busy boards +# is likely to be noticeably faster than continually +# writing to disk ... +# +# I must admit I read about this type on vB's board. +# Hey, I never said you cannot get basic ideas from +# competing boards, just that I find it's best not to +# look at any code ... ! +# DROP TABLE IF EXISTS phpbb_session; CREATE TABLE phpbb_session ( session_id char(32) DEFAULT '' NOT NULL, @@ -416,8 +427,7 @@ CREATE TABLE phpbb_topics ( topic_status tinyint(3) DEFAULT '0' NOT NULL, topic_type tinyint(3) DEFAULT '0' NOT NULL, topic_last_post_id int(11) DEFAULT '0' NOT NULL, - topic_moved_id int(10), - topic_notify tinyint(1) DEFAULT '0' NOT NULL, + topic_notify tinyint(1) DEFAULT '0' NOT NULL, PRIMARY KEY (topic_id), KEY forum_id (forum_id), KEY topic_id (topic_id) @@ -433,7 +443,7 @@ CREATE TABLE phpbb_topics_watch ( topic_id int(11) NOT NULL DEFAULT '0', user_id int(11) NOT NULL DEFAULT '0', notify_status tinyint(1) NOT NULL default '0', - PRIMARY KEY (topic_id), + KEY topic_id (topic_id), KEY user_id (user_id) ); @@ -459,11 +469,11 @@ CREATE TABLE phpbb_users ( user_attachsig tinyint(1), user_allowhtml tinyint(1), user_allowbbcode tinyint(1), - user_allowsmile tinyint(1), - user_allowavatar tinyint(1) DEFAULT '1' NOT NULL, - user_allow_pm tinyint(1) DEFAULT '1' NOT NULL, - user_allow_viewonline tinyint(1) DEFAULT '1' NOT NULL, - user_notify_pm tinyint(1) DEFAULT '1' NOT NULL, + user_allowsmile tinyint(1), + user_allowavatar tinyint(1) DEFAULT '1' NOT NULL, + user_allow_pm tinyint(1) DEFAULT '1' NOT NULL, + user_allow_viewonline tinyint(1) DEFAULT '1' NOT NULL, + user_notify_pm tinyint(1) DEFAULT '1' NOT NULL, user_regdate int(11) DEFAULT '0' NOT NULL, user_rank int(11) DEFAULT '0', user_avatar varchar(100), |