phpBB

Development Wiki

Difference between revisions of "Table.phpbb privmsgs to"

From phpBB Development Wiki

m (Reverted edits by OrsitDardr (Talk); changed back to last version by LEW21)
(Fields)
 
(3 intermediate revisions by 2 users not shown)
Line 15: Line 15:
 
| user_id
 
| user_id
 
| mediumint(8) unsigned
 
| mediumint(8) unsigned
| tbd
+
| user_id of recipient
 
| 0
 
| 0
 
|-
 
|-
 
| author_id
 
| author_id
 
| mediumint(8) unsigned
 
| mediumint(8) unsigned
| tbd
+
| user_id of sender when in inbox or in no_box
 +
user_id of recipient when in outbox
 
| 0
 
| 0
 
|-
 
|-
Line 30: Line 31:
 
| pm_new
 
| pm_new
 
| tinyint(1) unsigned
 
| tinyint(1) unsigned
| tbd
+
| new = 1
 +
not_new = 0
 
| 1
 
| 1
 
|-
 
|-
 
| pm_unread
 
| pm_unread
 
| tinyint(1) unsigned
 
| tinyint(1) unsigned
| tbd
+
| unread = 1
 +
read = 0
 
| 1
 
| 1
 
|-
 
|-
 
| pm_replied
 
| pm_replied
 
| tinyint(1) unsigned
 
| tinyint(1) unsigned
| tbd
+
| replied = 1
 +
not replied = 0
 
| 0
 
| 0
 
|-
 
|-
Line 58: Line 62:
 
| 0
 
| 0
 
|}
 
|}
 
  
 
== Keys ==
 
== Keys ==
Line 77: Line 80:
 
|}
 
|}
 
{{table-stub}}
 
{{table-stub}}
 +
[[Category:Database Tables]]

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