Difference between revisions of "Roundcubemail"

From SPGC Document Wiki
Jump to: navigation, search
(cache_index)
Line 57: Line 57:
 
! Auto Increment
 
! Auto Increment
 
|-
 
|-
|cache_id
+
|user_id
 
|int
 
|int
 
|10
 
|10
Line 64: Line 64:
 
|Yes
 
|Yes
 
|-
 
|-
|cache_key
+
|mailbox
 
|varchar
 
|varchar
|128
+
|255
|No
+
|Yes
 
|Yes
 
|Yes
 
|No
 
|No
 
|-
 
|-
|created
+
|expires
 
|datetime
 
|datetime
 
|0
 
|0
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|valid
 +
|tinyint
 +
|1
 
|No
 
|No
 
|Yes
 
|Yes
Line 84: Line 91:
 
|Yes
 
|Yes
 
|No
 
|No
|-
 
|user_id
 
|int
 
|10
 
|No
 
|Yes
 
|Yes
 
 
|}
 
|}

Revision as of 11:09, 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