diff options
| author | the_systech <the_systech@users.sourceforge.net> | 2001-06-19 17:38:00 +0000 |
|---|---|---|
| committer | the_systech <the_systech@users.sourceforge.net> | 2001-06-19 17:38:00 +0000 |
| commit | bc5c16ae8275c2ac79ecd260c6dbb56aa2a8948c (patch) | |
| tree | f63000a1477dfe67c526f08f80558e5ed3e6db00 /phpBB/db | |
| parent | 7d6c996092ec92c1081f05626af0d284dc94bb8a (diff) | |
| download | forums-bc5c16ae8275c2ac79ecd260c6dbb56aa2a8948c.tar forums-bc5c16ae8275c2ac79ecd260c6dbb56aa2a8948c.tar.gz forums-bc5c16ae8275c2ac79ecd260c6dbb56aa2a8948c.tar.bz2 forums-bc5c16ae8275c2ac79ecd260c6dbb56aa2a8948c.tar.xz forums-bc5c16ae8275c2ac79ecd260c6dbb56aa2a8948c.zip | |
added auto_prune
git-svn-id: file:///svn/phpbb/trunk@516 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/db')
| -rw-r--r-- | phpBB/db/mysql_schema.sql | 20 |
1 files changed, 18 insertions, 2 deletions
diff --git a/phpBB/db/mysql_schema.sql b/phpBB/db/mysql_schema.sql index 7a977429ae..a3c3addef8 100644 --- a/phpBB/db/mysql_schema.sql +++ b/phpBB/db/mysql_schema.sql @@ -114,7 +114,8 @@ CREATE TABLE phpbb_config ( default_dateformat varchar(14) DEFAULT 'd M Y H:i' NOT NULL, system_timezone int(11) DEFAULT '0' NOT NULL, sys_template varchar(100) DEFAULT 'Default' NOT NULL, - PRIMARY KEY (config_id), + prune_enable tinyint(1) DEFAULT '1' NOT NULL, + PRIMARY KEY (config_id), UNIQUE selected (selected) ); @@ -145,6 +146,19 @@ CREATE TABLE phpbb_forum_access ( PRIMARY KEY (forum_id, user_id) ); +# -------------------------------------------------------- +# +# Table structure for table 'phpbb_forum_prune' +# +DROP TABLE IF EXISTS phpbb_forum_prune; + +CREATE TABLE phpbb_forum_prune ( + prune_id int(10) NOT NULL auto_increment, + forum_id int(11) NOT NULL, + prune_days int(3) NOT NULL, + prune_freq int(3) NOT NULL, + PRIMARY KEY(prune_id) +); # -------------------------------------------------------- # @@ -174,7 +188,9 @@ CREATE TABLE phpbb_forums ( auth_votecreate tinyint(4) DEFAULT '0' NOT NULL, auth_vote tinyint(4) DEFAULT '0' NOT NULL, auth_attachments tinyint(4) DEFAULT '0' NOT NULL, - PRIMARY KEY (forum_id), + prune_next int(11), + prune_enable tinyint(1) DEFAULT '1' NOT NULL, + PRIMARY KEY (forum_id), KEY forum_id (forum_id), KEY forums_order (forum_order), KEY cat_id (cat_id) |