From b0b5cc368d9fbd461d23c7ad3e5181612d5d9268 Mon Sep 17 00:00:00 2001 From: "Paul S. Owen" Date: Sat, 16 Jun 2001 18:31:58 +0000 Subject: Added a profile preference for recieving notification on new PMs git-svn-id: file:///svn/phpbb/trunk@504 89ea8834-ac86-4346-8a33-228a782c2dd0 --- phpBB/db/mysql_schema.sql | 4 +++- phpBB/db/postgres_schema.sql | 8 +++++--- 2 files changed, 8 insertions(+), 4 deletions(-) (limited to 'phpBB/db') diff --git a/phpBB/db/mysql_schema.sql b/phpBB/db/mysql_schema.sql index 599b9e263a..dd6e6811a8 100644 --- a/phpBB/db/mysql_schema.sql +++ b/phpBB/db/mysql_schema.sql @@ -467,7 +467,9 @@ CREATE TABLE phpbb_users ( user_attachsig tinyint(1), user_allowhtml tinyint(1), user_allowbbcode tinyint(1), - user_allowsmile tinyint(1), + user_allowsmile tinyint(1), + user_allow_pm tinyint(1) DEFAULT '1' NOT NULL, + user_notify_pm tinyint(1) DEFAULT '1' NOT NULL, user_regdate int(11) DEFAULT '0' NOT NULL, user_rank int(11) DEFAULT '0', user_avatar varchar(100), diff --git a/phpBB/db/postgres_schema.sql b/phpBB/db/postgres_schema.sql index e657fdfb51..081e9f20ad 100644 --- a/phpBB/db/postgres_schema.sql +++ b/phpBB/db/postgres_schema.sql @@ -452,6 +452,7 @@ CREATE TABLE phpbb_user_groups ( -------------------------------------------------------- */ CREATE TABLE phpbb_users ( user_id int4 DEFAULT nextval('phpbb_users_id_seq'::text) NOT NULL, + user_active int2, username varchar(40) DEFAULT '' NOT NULL, user_regdate int4 DEFAULT '0' NOT NULL, user_password varchar(32) DEFAULT '' NOT NULL, @@ -473,17 +474,18 @@ CREATE TABLE phpbb_users ( user_allowhtml int2, user_allowbbcode int2, user_allowsmile int2, + user_allow_pm int2 DEFAULT '1' NOT NULL, user_rank int4 DEFAULT '0', user_avatar varchar(100), user_level int4 DEFAULT '1', user_lang varchar(255), + user_template varchar(50), user_timezone int4 DEFAULT '0' NOT NULL, user_dateformat varchar(14) DEFAULT 'd M Y H:m' NOT NULL, + user_notify_pm int2 DEFAULT '1' NOT NULL, + user_notify int2, user_actkey varchar(32), user_newpasswd varchar(32), - user_notify int2, - user_active int2, - user_template varchar(50), CONSTRAINT phpbb_users_pkey PRIMARY KEY (user_id) ); -- cgit v1.2.1