From fc9163db62c4a28f59c2d7f97835185a492c7163 Mon Sep 17 00:00:00 2001 From: "Paul S. Owen" Date: Wed, 13 Jun 2001 19:30:27 +0000 Subject: Basic posting of messages, no reply, quote or edit yet git-svn-id: file:///svn/phpbb/trunk@488 89ea8834-ac86-4346-8a33-228a782c2dd0 --- phpBB/db/mysql_schema.sql | 24 ++++-------------------- phpBB/db/postgres_schema.sql | 8 ++++---- 2 files changed, 8 insertions(+), 24 deletions(-) (limited to 'phpBB/db') diff --git a/phpBB/db/mysql_schema.sql b/phpBB/db/mysql_schema.sql index ed4be29726..9b07973b97 100644 --- a/phpBB/db/mysql_schema.sql +++ b/phpBB/db/mysql_schema.sql @@ -248,14 +248,14 @@ CREATE TABLE phpbb_privmsgs ( privmsgs_id int(11) NOT NULL auto_increment, privmsgs_type tinyint(4) DEFAULT '0' NOT NULL, privmsgs_subject varchar(255) DEFAULT '0' NOT NULL, - privmsgs_from_groupid int(11) DEFAULT '0' NOT NULL, - privmsgs_to_groupid int(11) DEFAULT '0' NOT NULL, + privmsgs_from_userid int(11) DEFAULT '0' NOT NULL, + privmsgs_to_userid int(11) DEFAULT '0' NOT NULL, privmsgs_date int(11) DEFAULT '0' NOT NULL, privmsgs_ip varchar(8) NOT NULL, privmsgs_bbcode_uid int(11) DEFAULT '0' NOT NULL, PRIMARY KEY (privmsgs_id), - KEY privmsgs_from_groupid (privmsgs_from_groupid), - KEY privmsgs_to_groupid (privmsgs_to_groupid) + KEY privmsgs_from_userid (privmsgs_from_userid), + KEY privmsgs_to_userid (privmsgs_to_userid) ); @@ -501,19 +501,3 @@ CREATE TABLE phpbb_words ( replacement varchar(100) NOT NULL, PRIMARY KEY (word_id) ); - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_auto_prune' -# -DROP TABLE IF EXISTS phpbb_auto_prune; - -CREATE TABLE phpbb_auto_prune ( - prune_id int(10) NOT NULL auto_increment, - forum_id int(11) NOT NULL, - prune_days int(3) NOT NULL, - last_pruned int(11), - admin_id int(11) NOT NULL, - PRIMARY KEY (prune_id) -); - diff --git a/phpBB/db/postgres_schema.sql b/phpBB/db/postgres_schema.sql index 075756cfc0..41ddce0a67 100644 --- a/phpBB/db/postgres_schema.sql +++ b/phpBB/db/postgres_schema.sql @@ -266,15 +266,15 @@ CREATE TABLE phpbb_privmsgs ( privmsgs_id int4 DEFAULT nextval('phpbb_privmsgs_id_seq'::text) NOT NULL, privmsgs_type int2 DEFAULT '0' NOT NULL, privmsgs_subject varchar(255) DEFAULT '0' NOT NULL, - privmsgs_from_groupid int4 DEFAULT '0' NOT NULL, - privmsgs_to_groupid int4 DEFAULT '0' NOT NULL, + privmsgs_from_userid int4 DEFAULT '0' NOT NULL, + privmsgs_to_userid int4 DEFAULT '0' NOT NULL, privmsgs_date int4 DEFAULT '0' NOT NULL, privmsgs_ip varchar(8) NOT NULL, privmsgs_bbcode_uid int4 DEFAULT '0' NOT NULL, CONSTRAINT phpbb_privmsgs_pkey PRIMARY KEY (privmsgs_id) ); -CREATE INDEX privmsgs_from_groupid_index ON phpbb_privmsgs (privmsgs_from_groupid); -CREATE INDEX privmsgs_to_groupid_index ON phpbb_privmsgs (privmsgs_to_groupid); +CREATE INDEX privmsgs_from_userid_index ON phpbb_privmsgs (privmsgs_from_userid); +CREATE INDEX privmsgs_to_userid_index ON phpbb_privmsgs (privmsgs_to_userid); /* -------------------------------------------------------- -- cgit v1.2.1