diff options
| author | Joas Schilling <nickvergessen@gmx.de> | 2012-10-21 22:33:28 +0200 |
|---|---|---|
| committer | Joas Schilling <nickvergessen@gmx.de> | 2012-10-21 22:33:28 +0200 |
| commit | 9c5482317ecf749012fc76e925b9fe1a07a1963b (patch) | |
| tree | 85c3988107d93a7c99e41fa3f24b973f1a53e8c0 /phpBB/install/schemas/oracle_schema.sql | |
| parent | e7a137820bf6ca341df5c0c503e2767451f57c5e (diff) | |
| download | forums-9c5482317ecf749012fc76e925b9fe1a07a1963b.tar forums-9c5482317ecf749012fc76e925b9fe1a07a1963b.tar.gz forums-9c5482317ecf749012fc76e925b9fe1a07a1963b.tar.bz2 forums-9c5482317ecf749012fc76e925b9fe1a07a1963b.tar.xz forums-9c5482317ecf749012fc76e925b9fe1a07a1963b.zip | |
[feature/soft-delete] Add new fields for topic/post counts for softdelete
We can not use the replies vs replies_real anymore, as we need to be able to
determinate whether the posts are unapproved or softdeleted. So we need to add
a new field and there by change the second one for consistency.
We also add the posts_* fields for forums, which are a missing feature.
PHPBB3-9567
Diffstat (limited to 'phpBB/install/schemas/oracle_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/oracle_schema.sql | 10 |
1 files changed, 7 insertions, 3 deletions
diff --git a/phpBB/install/schemas/oracle_schema.sql b/phpBB/install/schemas/oracle_schema.sql index 1730a42701..3a4525734f 100644 --- a/phpBB/install/schemas/oracle_schema.sql +++ b/phpBB/install/schemas/oracle_schema.sql @@ -510,8 +510,11 @@ CREATE TABLE phpbb_forums ( forum_type number(4) DEFAULT '0' NOT NULL, forum_status number(4) DEFAULT '0' NOT NULL, forum_posts number(8) DEFAULT '0' NOT NULL, + forum_posts_unapproved number(8) DEFAULT '0' NOT NULL, + forum_posts_softdeleted number(8) DEFAULT '0' NOT NULL, forum_topics number(8) DEFAULT '0' NOT NULL, - forum_topics_real number(8) DEFAULT '0' NOT NULL, + forum_topics_unapproved number(8) DEFAULT '0' NOT NULL, + forum_topics_softdeleted number(8) DEFAULT '0' NOT NULL, forum_last_post_id number(8) DEFAULT '0' NOT NULL, forum_last_poster_id number(8) DEFAULT '0' NOT NULL, forum_last_post_subject varchar2(765) DEFAULT '' , @@ -1490,8 +1493,9 @@ CREATE TABLE phpbb_topics ( topic_time number(11) DEFAULT '0' NOT NULL, topic_time_limit number(11) DEFAULT '0' NOT NULL, topic_views number(8) DEFAULT '0' NOT NULL, - topic_replies number(8) DEFAULT '0' NOT NULL, - topic_replies_real number(8) DEFAULT '0' NOT NULL, + topic_posts number(8) DEFAULT '0' NOT NULL, + topic_posts_unapproved number(8) DEFAULT '0' NOT NULL, + topic_posts_softdeleted number(8) DEFAULT '0' NOT NULL, topic_status number(3) DEFAULT '0' NOT NULL, topic_type number(3) DEFAULT '0' NOT NULL, topic_first_post_id number(8) DEFAULT '0' NOT NULL, |