aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/db
diff options
context:
space:
mode:
authorPaul S. Owen <psotfx@users.sourceforge.net>2001-07-15 15:45:09 +0000
committerPaul S. Owen <psotfx@users.sourceforge.net>2001-07-15 15:45:09 +0000
commite5211f3d205f08a485f0e5bb828667bbc7876678 (patch)
treef4a837f54a96c97451b230ffcd6cc54aaa46ffb0 /phpBB/db
parent2878b8bad53b62ff2c9157d75f5f578ec4543435 (diff)
downloadforums-e5211f3d205f08a485f0e5bb828667bbc7876678.tar
forums-e5211f3d205f08a485f0e5bb828667bbc7876678.tar.gz
forums-e5211f3d205f08a485f0e5bb828667bbc7876678.tar.bz2
forums-e5211f3d205f08a485f0e5bb828667bbc7876678.tar.xz
forums-e5211f3d205f08a485f0e5bb828667bbc7876678.zip
Added editing information, no time limit at present
git-svn-id: file:///svn/phpbb/trunk@673 89ea8834-ac86-4346-8a33-228a782c2dd0
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);