3 files changed, 13 insertions, 1 deletions
diff --git a/phpBB/install/schemas/mysql_basic.sql b/phpBB/install/schemas/mysql_basic.sql
index ad778d1082..2e471522f1 100644
--- a/phpBB/install/schemas/mysql_basic.sql
+++ b/phpBB/install/schemas/mysql_basic.sql
@@ -78,6 +78,7 @@ INSERT INTO phpbb_config (config_name, config_value) VALUES ('auth_method','db')
 INSERT INTO phpbb_config (config_name, config_value) VALUES ('ldap_server', '');
 INSERT INTO phpbb_config (config_name, config_value) VALUES ('ldap_base_dn', '');
 INSERT INTO phpbb_config (config_name, config_value) VALUES ('ldap_uid', '');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('lastread', '432000');
 INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('record_online_users', '0', 1);
 INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('record_online_date', '0', 1);
 INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('newest_user_id', '2', 1);
diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql
index 7946b723a9..26b756b2db 100644
--- a/phpBB/install/schemas/mysql_schema.sql
+++ b/phpBB/install/schemas/mysql_schema.sql
@@ -191,6 +191,18 @@ CREATE TABLE phpbb_icons (
    PRIMARY KEY (icons_id)
 );
 
+# --------------------------------------------------------
+#
+# Table structure for table 'phpbb_lastread'
+#
+CREATE TABLE phpbb_lastread (
+   user_id mediumint(9) NOT NULL default '0',
+   lastread_type tinyint(4) NOT NULL default '0',
+   forum_id smallint(6) NOT NULL default '0',
+   topic_id mediumint(9) NOT NULL default '0',
+   lastread_time int(4) NOT NULL default '0',
+   PRIMARY KEY  (user_id,topic_id)
+);
 
 # --------------------------------------------------------
 #
diff --git a/phpBB/install/schemas/oracle_schema.sql b/phpBB/install/schemas/oracle_schema.sql
index d27300067d..1d1cd35bdd 100644
--- a/phpBB/install/schemas/oracle_schema.sql
+++ b/phpBB/install/schemas/oracle_schema.sql
@@ -415,7 +415,6 @@ CREATE TABLE phpbb_topics_watch (
 );
 CREATE  INDEX phpbb_topics_watch_index ON phpbb_topics_watch (topic_id, user_id);
 
-
 /* --------------------------------------------------------
   Table structure for table phpbb_user_group
 -------------------------------------------------------- */