aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/install/schemas/mysql_schema.sql
diff options
context:
space:
mode:
Diffstat (limited to 'phpBB/install/schemas/mysql_schema.sql')
-rw-r--r--phpBB/install/schemas/mysql_schema.sql13
1 files changed, 13 insertions, 0 deletions
diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql
index 685d76a8fd..1ed3f7d5e4 100644
--- a/phpBB/install/schemas/mysql_schema.sql
+++ b/phpBB/install/schemas/mysql_schema.sql
@@ -211,6 +211,7 @@ CREATE TABLE phpbb_forums (
forum_password varchar(32) DEFAULT '' NOT NULL,
forum_style tinyint(4) UNSIGNED,
forum_image varchar(50) DEFAULT '' NOT NULL,
+ forum_topics_per_page tinyint(4) UNSIGNED DEFAULT '0' NOT NULL,
forum_type tinyint(4) DEFAULT '0' NOT NULL,
forum_status tinyint(4) DEFAULT '0' NOT NULL,
forum_posts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
@@ -234,6 +235,18 @@ CREATE TABLE phpbb_forums (
# --------------------------------------------------------
#
+# Table structure for table `phpbb_forum_access`
+#
+CREATE TABLE phpbb_forum_access (
+ forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
+ user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
+ session_id char(32) DEFAULT '' NOT NULL,
+ PRIMARY KEY (forum_id,user_id,session_id)
+)
+
+
+# --------------------------------------------------------
+#
# Table structure for table 'phpbb_forums_marking'
#
CREATE TABLE phpbb_forums_marking (