Difference between revisions of "Roundcubemail"

From SPGC Document Wiki
Jump to: navigation, search
(→‎system)
Line 749: Line 749:
 
|value
 
|value
 
|mediumtext
 
|mediumtext
 +
|0
 +
|No
 +
|No
 +
|No
 +
|}
 +
 +
==users==
 +
{| class="wikitable" \
 +
!colspan="7" | users
 +
|-
 +
! style="text-align:left;" | Column Name
 +
! Data Type
 +
! Length
 +
! Is PrimaryKey
 +
! Is Not Null
 +
! Auto Increment
 +
|-
 +
|message_id
 +
|int
 +
|11
 +
|Yes
 +
|Yes
 +
|Yes
 +
|-
 +
|user_id
 +
|int
 +
|10
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|del
 +
|tinyint
 +
|1
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|cache_key
 +
|varchar
 +
|128
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|created
 +
|datetime
 +
|0
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|idx
 +
|int
 +
|11
 +
|Yes
 +
|Yes
 +
|Yes
 +
|-
 +
|uid
 +
|int
 +
|11
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|subject
 +
|varchar
 +
|255
 +
|No
 +
|No
 +
|No
 +
|-
 +
|from
 +
|varchar
 +
|255
 +
|No
 +
|No
 +
|No
 +
|-
 +
|to
 +
|varchar
 +
|255
 +
|No
 +
|Yes
 +
|Yes
 +
|-
 +
|cc
 +
|varchar
 +
|255
 +
|No
 +
|No
 +
|No
 +
|-
 +
|date
 +
|datetime
 +
|0
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|size
 +
|int
 +
|11
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|headers
 +
|text
 +
|0
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|structure
 +
|text
 
|0
 
|0
 
|No
 
|No

Revision as of 15:18, 5 August 2016

cache

cache
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
cache_id int 10 Yes Yes Yes
cache_key varchar 128 No Yes No
created datetime 0 No Yes No
data longtext 0 No Yes No
user_id int 10 No Yes Yes

cache_index

cache_index
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
user_id int 10 Yes Yes Yes
mailbox varchar 255 Yes Yes No
expires datetime 0 No Yes No
valid tinyint 1 No Yes No
data longtext 0 No Yes No

cache_messages

cache_messages
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
user_id int 10 Yes Yes Yes
mailbox varchar 255 Yes Yes No
uid int 11 Yes Yes Yes
expires datetime 0 No No No
data longtext 0 No Yes No
flags int 11 No Yes No

cache_shared

cache_shared
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
cache_key varchar 255 No Yes No
created datetime 0 No Yes No
expires datetime 0 No No No
data longtext 0 No Yes No

cache_thread

cache_thread
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
user_id int 10 Yes Yes Yes
mailbox varchar 255 Yes Yes No
expires datetime 0 No No No
data longtext 0 No Yes No

contactgroupmembers

contactgroupmembers
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
contactgroup_id int 10 Yes Yes Yes
contact_id int 10 Yes Yes Yes
created datetime 0 No Yes No

contactgroups

contactgroups
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
contactgroup_id int 10 Yes Yes Yes
user_id int 10 No Yes Yes
changed datetime 0 No Yes No
del tinyint 1 No Yes No
name varchar 128 No Yes No

contacts

contacts
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
contact_id int 10 Yes Yes Yes
changed datetime 0 No Yes No
del tinyint 1 No Yes No
name varchar 128 No Yes No
email varchar 255 No Yes No
firstname varchar 128 Yes Yes Yes
surname varchar 128 No Yes No
vcard longtext 0 No No No
words text 0 No No No
user_id int 10 No Yes Yes

dictionary

dictionary
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
user_id int 10 No No Yes
language varchar 5 No Yes No
data longtext 0 No Yes No

identities

identities
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
identity_id int 10 Yes Yes Yes
user_id int 10 No Yes No
changed datetime 0 No Yes No
del tinyint 1 No Yes No
standard tinyint 1 No Yes No
name varchar 128 Yes Yes Yes
organization varchar 128 No Yes No
email varchar 128 No No No
reply-to varchar 128 No No No
bcc varchar 128 No Yes Yes
signature text 0 No No No
html_signature tinyint 1 No Yes No

messages

messages
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
message_id int 11 Yes Yes Yes
user_id int 10 No Yes No
del tinyint 1 No Yes No
cache_key varchar 128 No Yes No
created datetime 0 No Yes No
idx int 11 Yes Yes Yes
uid int 11 No Yes No
subject varchar 255 No No No
from varchar 255 No No No
to varchar 255 No Yes Yes
cc varchar 255 No No No
date datetime 0 No Yes No
size int 11 No Yes No
headers text 0 No Yes No
structure text 0 No No No

searches

searches
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
search_id int 10 Yes Yes Yes
user_id int 10 No Yes No
type int 3 No Yes No
name varchar 128 No Yes No
data text 0 No No No

session

session
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
sess_id varchar 40 Yes Yes No
created datetime 0 No Yes No
changed datetime 0 No Yes No
ip varchar 40 No Yes No
vars mediumtext 0 No Yes No

system

system
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
name varchar 64 Yes Yes No
value mediumtext 0 No No No

users

users
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
message_id int 11 Yes Yes Yes
user_id int 10 No Yes No
del tinyint 1 No Yes No
cache_key varchar 128 No Yes No
created datetime 0 No Yes No
idx int 11 Yes Yes Yes
uid int 11 No Yes No
subject varchar 255 No No No
from varchar 255 No No No
to varchar 255 No Yes Yes
cc varchar 255 No No No
date datetime 0 No Yes No
size int 11 No Yes No
headers text 0 No Yes No
structure text 0 No No No
Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=Roundcubemail&oldid=2607"