diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2002-11-18 18:56:27 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2002-11-18 18:56:27 +0000 |
| commit | ce40939e608a2b2f36fa2c9b7f47ab52d1b02a42 (patch) | |
| tree | 4e120d5cf0d8d2f4dd6061d32deee05d4ce29c0b /phpBB/install | |
| parent | 68d4dcf0d34ed66136b006df7e6a0f56677f38a5 (diff) | |
| download | forums-ce40939e608a2b2f36fa2c9b7f47ab52d1b02a42.tar forums-ce40939e608a2b2f36fa2c9b7f47ab52d1b02a42.tar.gz forums-ce40939e608a2b2f36fa2c9b7f47ab52d1b02a42.tar.bz2 forums-ce40939e608a2b2f36fa2c9b7f47ab52d1b02a42.tar.xz forums-ce40939e608a2b2f36fa2c9b7f47ab52d1b02a42.zip | |
Cache moderator names?
git-svn-id: file:///svn/phpbb/trunk@3060 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/install')
| -rw-r--r-- | phpBB/install/schemas/mysql_schema.sql | 18 |
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) ); |