diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-06-13 19:30:27 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-06-13 19:30:27 +0000 |
| commit | fc9163db62c4a28f59c2d7f97835185a492c7163 (patch) | |
| tree | c35d322b12bdc10cd3b52ce81a3ff4fd47393eca /phpBB/db | |
| parent | f9b181e0ce92fbc2d91d64a0570a74e73156c5fe (diff) | |
| download | forums-fc9163db62c4a28f59c2d7f97835185a492c7163.tar forums-fc9163db62c4a28f59c2d7f97835185a492c7163.tar.gz forums-fc9163db62c4a28f59c2d7f97835185a492c7163.tar.bz2 forums-fc9163db62c4a28f59c2d7f97835185a492c7163.tar.xz forums-fc9163db62c4a28f59c2d7f97835185a492c7163.zip | |
Basic posting of messages, no reply, quote or edit yet
git-svn-id: file:///svn/phpbb/trunk@488 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/db')
| -rw-r--r-- | phpBB/db/mysql_schema.sql | 24 | ||||
| -rw-r--r-- | phpBB/db/postgres_schema.sql | 8 |
2 files changed, 8 insertions, 24 deletions
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); /* -------------------------------------------------------- |