Difference between revisions of "Roundcubemail"

From SPGC Document Wiki
Jump to: navigation, search
(→‎cache_index)
Line 49: Line 49:
 
{| class="wikitable" \
 
{| class="wikitable" \
 
!colspan="7" | cache_index
 
!colspan="7" | cache_index
 +
|-
 +
! style="text-align:left;" | 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==
 +
{| class="wikitable" \
 +
!colspan="7" | cache_messages
 
|-
 
|-
 
! style="text-align:left;" | Column Name
 
! style="text-align:left;" | Column Name

Revision as of 11:11, 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
expires datetime 0 No Yes No
valid tinyint 1 No Yes No
data longtext 0 No Yes No
Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=Roundcubemail&oldid=2574"