diff options
| author | Meik Sievertsen <acydburn@phpbb.com> | 2003-10-12 09:02:11 +0000 |
|---|---|---|
| committer | Meik Sievertsen <acydburn@phpbb.com> | 2003-10-12 09:02:11 +0000 |
| commit | c6c56a9c07f92fc5c7af75a9455c40d6a8238cd4 (patch) | |
| tree | c4eb470d6f68e049563ce1d3c28bb14f0a62e422 | |
| parent | 1123227ad9b0fa188d1f4703e272c35762d87a70 (diff) | |
| download | forums-c6c56a9c07f92fc5c7af75a9455c40d6a8238cd4.tar forums-c6c56a9c07f92fc5c7af75a9455c40d6a8238cd4.tar.gz forums-c6c56a9c07f92fc5c7af75a9455c40d6a8238cd4.tar.bz2 forums-c6c56a9c07f92fc5c7af75a9455c40d6a8238cd4.tar.xz forums-c6c56a9c07f92fc5c7af75a9455c40d6a8238cd4.zip | |
enable pruning by Post Viewed time on auto_prune.
two changes to improve posting speed.
git-svn-id: file:///svn/phpbb/trunk@4568 89ea8834-ac86-4346-8a33-228a782c2dd0
| -rw-r--r-- | phpBB/install/schemas/mysql_schema.sql | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql index c2b399b6e2..69c4de32a6 100644 --- a/phpBB/install/schemas/mysql_schema.sql +++ b/phpBB/install/schemas/mysql_schema.sql @@ -196,6 +196,7 @@ CREATE TABLE phpbb_forums ( enable_prune tinyint(1) DEFAULT '0' NOT NULL, prune_next int(11) UNSIGNED, prune_days tinyint(4) UNSIGNED NOT NULL, + prune_viewed tinyint(4) UNSIGNED NOT NULL, prune_freq tinyint(4) UNSIGNED DEFAULT '0' NOT NULL, PRIMARY KEY (forum_id), KEY left_id (left_id), @@ -361,7 +362,8 @@ CREATE TABLE phpbb_posts ( KEY topic_id (topic_id), KEY poster_ip (poster_ip), KEY poster_id (poster_id), - KEY post_approved (post_approved) + KEY post_approved (post_approved), + KEY post_time (post_time) ); # Table: 'phpbb_privmsgs' @@ -691,6 +693,7 @@ CREATE TABLE phpbb_users ( user_email varchar(60) DEFAULT '' NOT NULL, user_birthday varchar(10) DEFAULT '' NOT NULL, user_lastvisit int(11) DEFAULT '0' NOT NULL, + user_lastpost_time int(11) DEFAULT '0' NOT NULL, user_lastpage varchar(100) DEFAULT '' NOT NULL, user_karma tinyint(1) DEFAULT '0' NOT NULL, user_min_karma tinyint(1) DEFAULT '-5' NOT NULL, |