diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2002-10-30 23:50:50 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2002-10-30 23:50:50 +0000 |
| commit | 282e7ec58ada14f42bc16c3a6f55eb049ea0f68c (patch) | |
| tree | 38b810d4184d6edbafd06cbc21f0a56bbecb6e04 /phpBB | |
| parent | 5abbc58deb02802fcb6b0f75ff141fe9fc050514 (diff) | |
| download | forums-282e7ec58ada14f42bc16c3a6f55eb049ea0f68c.tar forums-282e7ec58ada14f42bc16c3a6f55eb049ea0f68c.tar.gz forums-282e7ec58ada14f42bc16c3a6f55eb049ea0f68c.tar.bz2 forums-282e7ec58ada14f42bc16c3a6f55eb049ea0f68c.tar.xz forums-282e7ec58ada14f42bc16c3a6f55eb049ea0f68c.zip | |
Couple further updates
git-svn-id: file:///svn/phpbb/trunk@2990 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB')
| -rw-r--r-- | phpBB/install/schemas/mysql_basic.sql | 4 | ||||
| -rw-r--r-- | phpBB/install/schemas/mysql_schema.sql | 3 |
2 files changed, 5 insertions, 2 deletions
diff --git a/phpBB/install/schemas/mysql_basic.sql b/phpBB/install/schemas/mysql_basic.sql index a097af29d9..0cf0c34fb9 100644 --- a/phpBB/install/schemas/mysql_basic.sql +++ b/phpBB/install/schemas/mysql_basic.sql @@ -47,8 +47,9 @@ INSERT INTO phpbb_config (config_name, config_value) VALUES ('script_path', ''); INSERT INTO phpbb_config (config_name, config_value) VALUES ('limit_load', '2.0'); INSERT INTO phpbb_config (config_name, config_value) VALUES ('active_sessions', '0'); INSERT INTO phpbb_config (config_name, config_value) VALUES ('session_gc', '3600'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('search_gc', '7200'); INSERT INTO phpbb_config (config_name, config_value) VALUES ('ip_check', '4'); -INSERT INTO phpbb_config (config_name, config_value) VALUES ('version', '2.1.0 [20021004]'); +INSERT INTO phpbb_config (config_name, config_value) VALUES ('version', '2.1.0 [20021030]'); INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_post_chars', '0'); INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_post_smilies', '0'); INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_sig_chars','255'); @@ -85,6 +86,7 @@ INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('num_us INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('num_posts', '1', 1); INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('num_topics', '1', 1); INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('session_last_gc', '0', 1); +INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('search_last_gc', '0', 1); # -- auth options INSERT INTO phpbb_auth_options (auth_value, is_local) VALUES ('f_', 1); diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql index 9c2363f3d4..c5d663b60a 100644 --- a/phpBB/install/schemas/mysql_schema.sql +++ b/phpBB/install/schemas/mysql_schema.sql @@ -397,7 +397,8 @@ CREATE TABLE phpbb_sessions ( session_ip varchar(40) DEFAULT '0' NOT NULL, session_browser varchar(100) DEFAULT '' NULL, session_page varchar(50) DEFAULT '0' NOT NULL, - PRIMARY KEY (session_id) + PRIMARY KEY (session_id), + KEY session_time (session_time) ); |