diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-06-16 18:31:58 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-06-16 18:31:58 +0000 |
| commit | b0b5cc368d9fbd461d23c7ad3e5181612d5d9268 (patch) | |
| tree | df12b8fd47ba67b2f174d559931cf517504980aa /phpBB/db | |
| parent | 3479343882bd0e9e767723ad6cbd8bc17c156568 (diff) | |
| download | forums-b0b5cc368d9fbd461d23c7ad3e5181612d5d9268.tar forums-b0b5cc368d9fbd461d23c7ad3e5181612d5d9268.tar.gz forums-b0b5cc368d9fbd461d23c7ad3e5181612d5d9268.tar.bz2 forums-b0b5cc368d9fbd461d23c7ad3e5181612d5d9268.tar.xz forums-b0b5cc368d9fbd461d23c7ad3e5181612d5d9268.zip | |
Added a profile preference for recieving notification on new PMs
git-svn-id: file:///svn/phpbb/trunk@504 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/db')
| -rw-r--r-- | phpBB/db/mysql_schema.sql | 4 | ||||
| -rw-r--r-- | phpBB/db/postgres_schema.sql | 8 |
2 files changed, 8 insertions, 4 deletions
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) ); |