diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2003-03-24 19:03:16 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2003-03-24 19:03:16 +0000 |
| commit | 12f21fee97c61059c4ed7b0d57eb40d40cc2a4b5 (patch) | |
| tree | f7dfb6342e98a1880cea3b6b9dfcf78b494a1730 /phpBB/install | |
| parent | d1494cfd8cb7e11360bf4dd816511cf239069237 (diff) | |
| download | forums-12f21fee97c61059c4ed7b0d57eb40d40cc2a4b5.tar forums-12f21fee97c61059c4ed7b0d57eb40d40cc2a4b5.tar.gz forums-12f21fee97c61059c4ed7b0d57eb40d40cc2a4b5.tar.bz2 forums-12f21fee97c61059c4ed7b0d57eb40d40cc2a4b5.tar.xz forums-12f21fee97c61059c4ed7b0d57eb40d40cc2a4b5.zip | |
Capitalisation, additional of one or two new options, removal of global prune option, addition of stats reset on admin index page
git-svn-id: file:///svn/phpbb/trunk@3708 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/install')
| -rw-r--r-- | phpBB/install/schemas/mysql_basic.sql | 5 | ||||
| -rw-r--r-- | phpBB/install/schemas/mysql_schema.sql | 47 |
2 files changed, 41 insertions, 11 deletions
diff --git a/phpBB/install/schemas/mysql_basic.sql b/phpBB/install/schemas/mysql_basic.sql index ada475b27a..c76239cf17 100644 --- a/phpBB/install/schemas/mysql_basic.sql +++ b/phpBB/install/schemas/mysql_basic.sql @@ -29,6 +29,7 @@ INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_uploa INSERT INTO phpbb_config (config_name, config_value) VALUES ('default_style','1'); INSERT INTO phpbb_config (config_name, config_value) VALUES ('default_dateformat','D M d, Y g:i a'); INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_timezone','0'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_dst','0'); INSERT INTO phpbb_config (config_name, config_value) VALUES ('override_user_style','0'); INSERT INTO phpbb_config (config_name, config_value) VALUES ('posts_per_page','10'); INSERT INTO phpbb_config (config_name, config_value) VALUES ('topics_per_page','30'); @@ -38,7 +39,6 @@ INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_path','imag INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_gallery_path','images/avatars/gallery'); INSERT INTO phpbb_config (config_name, config_value) VALUES ('smilies_path','images/smiles'); INSERT INTO phpbb_config (config_name, config_value) VALUES ('icons_path','images/icons'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('prune_enable','1'); INSERT INTO phpbb_config (config_name, config_value) VALUES ('email_enable','1'); INSERT INTO phpbb_config (config_name, config_value) VALUES ('privmsg_disable','0'); INSERT INTO phpbb_config (config_name, config_value) VALUES ('gzip_compress','0'); @@ -61,7 +61,8 @@ INSERT INTO phpbb_config (config_name, config_value) VALUES ('pm_max_boxes','4') INSERT INTO phpbb_config (config_name, config_value) VALUES ('pm_max_msgs','50'); INSERT INTO phpbb_config (config_name, config_value) VALUES ('edit_time','0'); INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_email_sig','Thanks, The Management'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_email','youraddress@yourdomain.com'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_email','address@yourdomain.com'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_contact','contact@yourdomain.com'); INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_delivery','0'); INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_host',''); INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_port','25'); diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql index 936daff77d..07868231dd 100644 --- a/phpBB/install/schemas/mysql_schema.sql +++ b/phpBB/install/schemas/mysql_schema.sql @@ -42,6 +42,17 @@ CREATE TABLE phpbb_attach_desc ( # -------------------------------------------------------- # +# Table structure for table `phpbb_auth_dependencies` +# +CREATE TABLE phpbb_auth_dependencies ( + auth_option_id smallint(5) unsigned NOT NULL default '0', + auth_depend text, + PRIMARY KEY (auth_option_id) +); + + +# -------------------------------------------------------- +# # Table structure for table `phpbb_auth_groups` # CREATE TABLE phpbb_auth_groups ( @@ -204,19 +215,19 @@ CREATE TABLE phpbb_forums ( forum_parents text, forum_name varchar(150) NOT NULL, forum_desc text, + forum_password varchar(32) DEFAULT '' NOT NULL, forum_style tinyint(4) UNSIGNED, forum_image varchar(50), forum_status tinyint(4) DEFAULT '0' NOT NULL, forum_postable tinyint(4) DEFAULT '0' NOT NULL, forum_posts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, forum_topics mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, + forum_last_topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, forum_last_post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, forum_last_poster_id mediumint(8) DEFAULT '0' NOT NULL, forum_last_post_time int(11) DEFAULT '0' NOT NULL, forum_last_poster_name varchar(30), display_on_index tinyint(1) DEFAULT '1' NOT NULL, - enable_post_count tinyint(1) DEFAULT '1' NOT NULL, - enable_moderate tinyint(1) DEFAULT '0' NOT NULL, enable_icons tinyint(1) DEFAULT '1' NOT NULL, enable_prune tinyint(1) DEFAULT '0' NOT NULL, prune_next int(11) UNSIGNED, @@ -249,6 +260,7 @@ CREATE TABLE phpbb_groups ( group_id mediumint(8) NOT NULL auto_increment, group_type tinyint(4) DEFAULT '1' NOT NULL, group_name varchar(40) NOT NULL, + group_display tinyint(1) DEFAULT '0' NOT NULL, group_avatar varchar(100), group_avatar_type tinyint(4), group_rank int(11) DEFAULT '0', @@ -283,6 +295,22 @@ CREATE TABLE phpbb_icons ( PRIMARY KEY (icons_id) ); + +# -------------------------------------------------------- +# +# Table structure for table 'phpbb_lang' +# +CREATE TABLE phpbb_lang ( + lang_id tinyint(4) UNSIGNED NOT NULL auto_increment, + 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) +); + + # -------------------------------------------------------- # # Table structure for table 'phpbb_lastread' @@ -296,6 +324,7 @@ CREATE TABLE phpbb_lastread ( PRIMARY KEY (user_id,topic_id) ); + # -------------------------------------------------------- # # Table structure for table 'phpbb_log_moderator' @@ -311,7 +340,7 @@ CREATE TABLE phpbb_log_moderator ( log_data text, PRIMARY KEY (log_id), KEY forum_id (forum_id), - KEY topic_id (forum_id), + KEY topic_id (topic_id), KEY user_id (user_id) ); @@ -460,8 +489,8 @@ CREATE TABLE phpbb_ranks ( CREATE TABLE phpbb_ratings ( post_id mediumint(8) UNSIGNED NOT NULL DEFAULT '0', user_id tinyint(4) UNSIGNED UNSIGNED NOT NULL DEFAULT '0', - rating tinyint(4) NOT NULL, - KEY post_id (post_id), + rating tinyint(4) NOT NULL, + PRIMARY KEY (post_id, user_id), KEY user_id (user_id) ); @@ -595,7 +624,7 @@ CREATE TABLE phpbb_styles_template ( template_path varchar(50) NOT NULL, poll_length smallint(5) UNSIGNED NOT NULL, pm_box_length smallint(5) UNSIGNED NOT NULL, - compile_crc text, + compile_crc text, PRIMARY KEY (template_id) ); @@ -787,7 +816,7 @@ CREATE TABLE phpbb_users ( user_startpage varchar(100) DEFAULT '', user_colour varchar(6) DEFAULT '' NOT NULL, user_posts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - user_lang varchar(50), + user_lang varchar(30), user_timezone decimal(5,2) DEFAULT '0' NOT NULL, user_dst tinyint(1) DEFAULT '0' NOT NULL, user_dateformat varchar(15) DEFAULT 'd M Y H:i' NOT NULL, @@ -827,10 +856,10 @@ CREATE TABLE phpbb_users ( user_yim varchar(255), user_msnm varchar(255), user_website varchar(100), - user_occ varchar(100), - user_interests varchar(255), user_actkey varchar(32), user_newpasswd varchar(32), + user_occ varchar(100), + user_interests varchar(255), PRIMARY KEY (user_id) ); |