phpBB

Development Wiki

Table.phpbb user notifications

From phpBB Development Wiki

Revision as of 16:23, 16 October 2015 by 3di (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Fields

column type (MySQL) content default
notification_id int(10) unsigned primary key auto_increment
notification_type_id smallint(4) unsigned tbd 0
item_id mediumint(8) unsigned tbd 0
item_parent_id mediumint(8) unsigned tbd 0
user_id mediumint(8) unsigned tbd 0
notification_read tinyint(1) unsigned tbd 0
notification_time int(11) unsigned tbd 1
notification_data text tbd  


Keys

name fields
PRIMARY notification_id
item_ident notification_type_id
item_id
user user_id
notification_read