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.sql18
1 files changed, 17 insertions, 1 deletions
diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql
index a1272438f2..f421aef2ac 100644
--- a/phpBB/install/schemas/mysql_schema.sql
+++ b/phpBB/install/schemas/mysql_schema.sql
@@ -226,6 +226,22 @@ CREATE TABLE phpbb_log_admin (
# --------------------------------------------------------
#
+# Table structure for table 'phpbb_moderator_cache'
+#
+CREATE TABLE phpbb_moderator_cache (
+ forum_id mediumint(8) unsigned NOT NULL,
+ user_id mediumint(8) unsigned default NULL,
+ username char(30) default NULL,
+ group_id mediumint(8) unsigned default NULL,
+ groupname char(30) default NULL,
+ display_on_index tinyint(4) NOT NULL default '1',
+ KEY display_on_index (display_on_index),
+ KEY forum_id (forum_id)
+)
+
+
+# --------------------------------------------------------
+#
# Table structure for table 'phpbb_vote_results'
#
CREATE TABLE phpbb_poll_results (
@@ -397,7 +413,7 @@ CREATE TABLE phpbb_sessions (
session_time int(11) DEFAULT '0' NOT NULL,
session_ip varchar(40) DEFAULT '0' NOT NULL,
session_browser varchar(100) DEFAULT '' NULL,
- session_page varchar(50) DEFAULT '0' NOT NULL,
+ session_page varchar(100) DEFAULT '0' NOT NULL,
PRIMARY KEY (session_id),
KEY session_time (session_time)
);