From e5211f3d205f08a485f0e5bb828667bbc7876678 Mon Sep 17 00:00:00 2001 From: "Paul S. Owen" Date: Sun, 15 Jul 2001 15:45:09 +0000 Subject: Added editing information, no time limit at present git-svn-id: file:///svn/phpbb/trunk@673 89ea8834-ac86-4346-8a33-228a782c2dd0 --- phpBB/db/mysql_schema.sql | 2 ++ phpBB/db/postgres_schema.sql | 4 +++- 2 files changed, 5 insertions(+), 1 deletion(-) (limited to 'phpBB/db') 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); -- cgit v1.2.1