phpBB

Development Wiki

Difference between revisions of "Table.phpbb privmsgs to"

From phpBB Development Wiki

(Fields)
(Fields)
 
Line 15: Line 15:
 
| user_id
 
| user_id
 
| mediumint(8) unsigned
 
| mediumint(8) unsigned
| user_id of recepient
+
| user_id of recipient
 
| 0
 
| 0
 
|-
 
|-
 
| author_id
 
| author_id
 
| mediumint(8) unsigned
 
| mediumint(8) unsigned
| user_id of sender
+
| user_id of sender when in inbox or in no_box
 +
user_id of recipient when in outbox
 
| 0
 
| 0
 
|-
 
|-

Latest revision as of 00:23, 11 January 2012

description goes here

Fields

column type (MySQL) content default
msg_id mediumint(8) unsigned tbd 0
user_id mediumint(8) unsigned user_id of recipient 0
author_id mediumint(8) unsigned user_id of sender when in inbox or in no_box

user_id of recipient when in outbox

0
pm_deleted tinyint(1) unsigned tbd 0
pm_new tinyint(1) unsigned new = 1

not_new = 0

1
pm_unread tinyint(1) unsigned unread = 1

read = 0

1
pm_replied tinyint(1) unsigned replied = 1

not replied = 0

0
pm_marked tinyint(1) unsigned tbd 0
pm_forwarded tinyint(1) unsigned tbd 0
folder_id int(4) tbd 0

Keys

name fields
msg_id msg_id
author_id author_id
usr_flder_id user_id
folder_id