Difference between revisions of "Roundcubemail"

From SPGC Document Wiki
Jump to: navigation, search
(→‎identities)
Line 433: Line 433:
 
! Auto Increment
 
! Auto Increment
 
|-
 
|-
−
|contact_id
+
|identity_id
 
|int
 
|int
 
|10
 
|10
Line 439: Line 439:
 
|Yes
 
|Yes
 
|Yes
 
|Yes
 +
|-
 +
|user_id
 +
|int
 +
|10
 +
|No
 +
|Yes
 +
|No
 
|-
 
|-
 
|changed
 
|changed
Line 454: Line 461:
 
|No
 
|No
 
|-
 
|-
−
|name
+
|standard
−
|varchar
+
|tinyint
−
|128
+
|1
 
|No
 
|No
 
|Yes
 
|Yes
 
|No
 
|No
 
|-
 
|-
−
|email
+
|name
−
|varchar
+
−
|255
+
−
|No
+
−
|Yes
+
−
|No
+
−
|-
+
−
|firstname
+
 
|varchar
 
|varchar
 
|128
 
|128
Line 475: Line 475:
 
|Yes
 
|Yes
 
|-
 
|-
−
|surname
+
|organization
 
|varchar
 
|varchar
 
|128
 
|128
Line 482: Line 482:
 
|No
 
|No
 
|-
 
|-
−
|vcard
+
|email
−
|longtext
+
|varchar
−
|0
+
|128
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|-
 
|-
−
|words
+
|reply-to
 +
|varchar
 +
|128
 +
|No
 +
|No
 +
|No
 +
|-
 +
|bcc
 +
|varchar
 +
|128
 +
|No
 +
|Yes
 +
|Yes
 +
|-
 +
|signature
 
|text
 
|text
 
|0
 
|0
Line 496: Line 510:
 
|No
 
|No
 
|-
 
|-
−
|user_id
+
|html_signature
−
|int
+
|tinyint
−
|10
+
|1
 
|No
 
|No
 
|Yes
 
|Yes
−
|Yes
+
|No
 
|}
 
|}

Revision as of 14:15, 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
Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=Roundcubemail&oldid=2590"