diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2002-05-21 14:25:52 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2002-05-21 14:25:52 +0000 |
| commit | d75291c5d248310d6f768d2ee4004d29f3afd48a (patch) | |
| tree | 723e9fe06175a6715e14fee9d6f4e46a79af1bc5 /phpBB | |
| parent | 9f0f335812f195c912131a9e62f6ff30a0a7c0ef (diff) | |
| download | forums-d75291c5d248310d6f768d2ee4004d29f3afd48a.tar forums-d75291c5d248310d6f768d2ee4004d29f3afd48a.tar.gz forums-d75291c5d248310d6f768d2ee4004d29f3afd48a.tar.bz2 forums-d75291c5d248310d6f768d2ee4004d29f3afd48a.tar.xz forums-d75291c5d248310d6f768d2ee4004d29f3afd48a.zip | |
Add fields for forum/topic post count incrementing and topic moderation
git-svn-id: file:///svn/phpbb/trunk@2612 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB')
| -rw-r--r-- | phpBB/db/schemas/mysql_schema.sql | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/phpBB/db/schemas/mysql_schema.sql b/phpBB/db/schemas/mysql_schema.sql index 4fa594a0bf..94b6a09f97 100644 --- a/phpBB/db/schemas/mysql_schema.sql +++ b/phpBB/db/schemas/mysql_schema.sql @@ -129,7 +129,8 @@ CREATE TABLE phpbb_forums ( forum_order mediumint(8) UNSIGNED DEFAULT '1' NOT NULL, forum_posts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, forum_topics mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - forum_last_post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, + forum_last_post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, + increment_post_count tinyint(1) DEFAULT '1' NOT NULL, prune_next int(11), prune_enable tinyint(1) DEFAULT '0' NOT NULL, auth_view tinyint(2) DEFAULT '0' NOT NULL, @@ -434,9 +435,11 @@ CREATE TABLE phpbb_topics ( topic_time int(11) DEFAULT '0' NOT NULL, topic_views mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, topic_replies mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, + topic_approved tinyint(1) DEFAULT '1' NOT NULL, topic_status tinyint(3) DEFAULT '0' NOT NULL, topic_vote tinyint(1) DEFAULT '0' NOT NULL, topic_type tinyint(3) DEFAULT '0' NOT NULL, + increment_post_count tinyint(1) DEFAULT '1' NOT NULL, topic_first_post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, topic_last_post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, topic_moved_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, @@ -462,6 +465,7 @@ CREATE TABLE phpbb_topics_watch ( ); + # -------------------------------------------------------- # # Table structure for table 'phpbb_users' |