phpBB

Development Wiki

Difference between revisions of "Table.phpbb user notifications"

From phpBB Development Wiki

(Created page with "coming soon")
 
Line 1: Line 1:
coming soon
+
 
 +
== Fields ==
 +
{|border="1" cellspacing="0" cellpadding="5"
 +
! 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 ==
 +
{|border="1" cellspacing="0" cellpadding="5"
 +
! name
 +
! fields
 +
|-
 +
|rowspan="1"| PRIMARY
 +
|notification_id
 +
|-
 +
|rowspan="2"| item_ident
 +
|notification_type_id
 +
|-
 +
|item_id
 +
|-
 +
|rowspan="2"| user
 +
|user_id
 +
|-
 +
|notification_read
 +
|}

Revision as of 16:56, 25 September 2015

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