aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/install/schemas
diff options
context:
space:
mode:
authorPaul S. Owen <psotfx@users.sourceforge.net>2002-10-28 00:08:18 +0000
committerPaul S. Owen <psotfx@users.sourceforge.net>2002-10-28 00:08:18 +0000
commit595a39122f1564207f73e4c260a7c65fbad2305e (patch)
tree655f574b52701d409c373fd0f13698d36ca88912 /phpBB/install/schemas
parent7cc1dbf6b0b3034da72d3dbca9adfacf8f19638b (diff)
downloadforums-595a39122f1564207f73e4c260a7c65fbad2305e.tar
forums-595a39122f1564207f73e4c260a7c65fbad2305e.tar.gz
forums-595a39122f1564207f73e4c260a7c65fbad2305e.tar.bz2
forums-595a39122f1564207f73e4c260a7c65fbad2305e.tar.xz
forums-595a39122f1564207f73e4c260a7c65fbad2305e.zip
Posting and acl option updates
git-svn-id: file:///svn/phpbb/trunk@2972 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/install/schemas')
-rw-r--r--phpBB/install/schemas/mysql_basic.sql3
-rw-r--r--phpBB/install/schemas/mysql_schema.sql2
2 files changed, 3 insertions, 2 deletions
diff --git a/phpBB/install/schemas/mysql_basic.sql b/phpBB/install/schemas/mysql_basic.sql
index 3c1d3fe8cf..17b0ea8961 100644
--- a/phpBB/install/schemas/mysql_basic.sql
+++ b/phpBB/install/schemas/mysql_basic.sql
@@ -54,9 +54,10 @@ INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_post_smilies',
INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_sig_chars','255');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_poll_options','10');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('min_search_chars','3');
-INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_search_chars','20');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_search_chars','10');
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 ('smtp_delivery','0');
diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql
index cc28ace201..3cb6b330e5 100644
--- a/phpBB/install/schemas/mysql_schema.sql
+++ b/phpBB/install/schemas/mysql_schema.sql
@@ -531,6 +531,7 @@ CREATE TABLE phpbb_styles_imageset (
CREATE TABLE phpbb_topics (
topic_id mediumint(8) UNSIGNED NOT NULL auto_increment,
forum_id smallint(8) UNSIGNED DEFAULT '0' NOT NULL,
+ topic_approved tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
topic_title varchar(60) NOT NULL,
topic_poster mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
topic_time int(11) DEFAULT '0' NOT NULL,
@@ -547,7 +548,6 @@ CREATE TABLE phpbb_topics (
topic_last_poster_name varchar(30),
topic_last_post_time int(11) DEFAULT '0' NOT NULL,
topic_moved_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- post_count_inc tinyint(1) DEFAULT '1' NOT NULL,
poll_title varchar(255) NOT NULL,
poll_start int(11) NOT NULL DEFAULT '0',
poll_length int(11) NOT NULL DEFAULT '0',