aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/db
diff options
context:
space:
mode:
Diffstat (limited to 'phpBB/db')
-rw-r--r--phpBB/db/mysql_schema.sql2
-rw-r--r--phpBB/db/postgres_schema.sql4
2 files changed, 5 insertions, 1 deletions
diff --git a/phpBB/db/mysql_schema.sql b/phpBB/db/mysql_schema.sql
index d475bdd816..fd25d3cebb 100644
--- a/phpBB/db/mysql_schema.sql
+++ b/phpBB/db/mysql_schema.sql
@@ -204,6 +204,8 @@ CREATE TABLE phpbb_posts (
poster_ip char(8) NOT NULL,
post_username varchar(30),
bbcode_uid varchar(10) NOT NULL,
+ post_edit_time int(11),
+ post_edit_count smallint(4) DEFAULT '0' NOT NULL,
PRIMARY KEY (post_id),
KEY forum_id (forum_id),
KEY topic_id (topic_id),
diff --git a/phpBB/db/postgres_schema.sql b/phpBB/db/postgres_schema.sql
index bad7d810a8..c7427531d1 100644
--- a/phpBB/db/postgres_schema.sql
+++ b/phpBB/db/postgres_schema.sql
@@ -199,7 +199,9 @@ CREATE TABLE phpbb_posts (
post_time int4 DEFAULT '0' NOT NULL,
post_username varchar(30),
poster_ip char(8) DEFAULT '' NOT NULL,
- bbcode_uid varchar(10) DEFAULT '' NOT NULL,
+ bbcode_uid varchar(10) DEFAULT '' NOT NULL,
+ post_edit_time int4,
+ post_edit_count int2 DEFAULT '0' NOT NULL,
CONSTRAINT phpbb_posts_pkey PRIMARY KEY (post_id)
);
CREATE INDEX forum_id_phpbb_posts_index ON phpbb_posts (forum_id);