Difference between revisions of "Roundcubemail"

From SPGC Document Wiki
Jump to: navigation, search
 
(22 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 +
[[Main_Page | Main Page]] > [[Application_Development_Team | Application Development Team]] > [[DB_Specs | DB Specs]] > [[202.2.2.52 | 202.2.2.52]]
 +
 
==cache==
 
==cache==
 
{| class="wikitable" \
 
{| class="wikitable" \
Line 75: Line 77:
 
|0
 
|0
 
|No
 
|No
−
|Yes
+
|No
 
|No
 
|No
 
|-
 
|-
Line 356: Line 358:
 
|varchar
 
|varchar
 
|128
 
|128
 +
|No
 
|Yes
 
|Yes
−
|Yes
+
|No
−
|Yes
+
 
|-
 
|-
 
|surname
 
|surname
Line 445: Line 447:
 
|No
 
|No
 
|Yes
 
|Yes
−
|No
+
|Yes
 
|-
 
|-
 
|changed
 
|changed
Line 471: Line 473:
 
|varchar
 
|varchar
 
|128
 
|128
 +
|No
 
|Yes
 
|Yes
−
|Yes
+
|No
−
|Yes
+
 
|-
 
|-
 
|organization
 
|organization
Line 486: Line 488:
 
|128
 
|128
 
|No
 
|No
−
|No
+
|Yes
 
|No
 
|No
 
|-
 
|-
Line 493: Line 495:
 
|128
 
|128
 
|No
 
|No
−
|No
+
|Yes
 
|No
 
|No
 
|-
 
|-
Line 501: Line 503:
 
|No
 
|No
 
|Yes
 
|Yes
−
|Yes
+
|No
 
|-
 
|-
 
|signature
 
|signature
Line 541: Line 543:
 
|No
 
|No
 
|Yes
 
|Yes
−
|No
+
|Yes
 
|-
 
|-
 
|del
 
|del
Line 567: Line 569:
 
|int
 
|int
 
|11
 
|11
−
|Yes
+
|No
 
|Yes
 
|Yes
 
|Yes
 
|Yes
Line 576: Line 578:
 
|No
 
|No
 
|Yes
 
|Yes
−
|No
+
|Yes
 
|-
 
|-
 
|subject
 
|subject
Line 582: Line 584:
 
|255
 
|255
 
|No
 
|No
−
|No
+
|Yes
 
|No
 
|No
 
|-
 
|-
Line 589: Line 591:
 
|255
 
|255
 
|No
 
|No
−
|No
+
|Yes
 
|No
 
|No
 
|-
 
|-
Line 597: Line 599:
 
|No
 
|No
 
|Yes
 
|Yes
−
|Yes
+
|No
 
|-
 
|-
 
|cc
 
|cc
Line 603: Line 605:
 
|255
 
|255
 
|No
 
|No
−
|No
+
|Yes
 
|No
 
|No
 
|-
 
|-
Line 618: Line 620:
 
|No
 
|No
 
|Yes
 
|Yes
−
|No
+
|Yes
 
|-
 
|-
 
|headers
 
|headers
Line 646: Line 648:
 
! Auto Increment
 
! Auto Increment
 
|-
 
|-
−
|contactgroup_id
+
|search_id
 
|int
 
|int
 
|10
 
|10
Line 659: Line 661:
 
|Yes
 
|Yes
 
|Yes
 
|Yes
 +
|-
 +
|type
 +
|int
 +
|3
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|name
 +
|varchar
 +
|128
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|data
 +
|text
 +
|0
 +
|No
 +
|No
 +
|No
 +
|}
 +
 +
==session==
 +
{| class="wikitable" \
 +
!colspan="7" | session
 +
|-
 +
! style="text-align:left;" | 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
 
|changed
Line 667: Line 716:
 
|No
 
|No
 
|-
 
|-
−
|del
+
|ip
−
|tinyint
+
|varchar
−
|1
+
|40
 
|No
 
|No
 
|Yes
 
|Yes
 
|No
 
|No
 +
|-
 +
|vars
 +
|mediumtext
 +
|0
 +
|No
 +
|Yes
 +
|No
 +
|}
 +
 +
==system==
 +
{| class="wikitable" \
 +
!colspan="7" | system
 +
|-
 +
! style="text-align:left;" | Column Name
 +
! Data Type
 +
! Length
 +
! Is PrimaryKey
 +
! Is Not Null
 +
! Auto Increment
 
|-
 
|-
 
|name
 
|name
 +
|varchar
 +
|64
 +
|Yes
 +
|Yes
 +
|No
 +
|-
 +
|value
 +
|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
 +
|-
 +
|user_id
 +
|int
 +
|10
 +
|Yes
 +
|Yes
 +
|Yes
 +
|-
 +
|username
 
|varchar
 
|varchar
 
|128
 
|128
 
|No
 
|No
 
|Yes
 
|Yes
 +
|No
 +
|-
 +
|mail_host
 +
|varchar
 +
|128
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|alias
 +
|varchar
 +
|128
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|created
 +
|datetime
 +
|0
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|last_login
 +
|datetime
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|language
 +
|varchar
 +
|5
 +
|No
 +
|No
 +
|No
 +
|-
 +
|preferences
 +
|text
 +
|0
 +
|No
 +
|No
 
|No
 
|No
 
|}
 
|}
 +
 +
[[Main_Page | Main Page]] > [[Application_Development_Team | Application Development Team]] > [[DB_Specs | DB Specs]] > [[202.2.2.52 | 202.2.2.52]]

Latest revision as of 09:21, 1 September 2016

Main Page > Application Development Team > DB Specs > 202.2.2.52

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 No 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 No Yes No
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 Yes
changed datetime 0 No Yes No
del tinyint 1 No Yes No
standard tinyint 1 No Yes No
name varchar 128 No Yes No
organization varchar 128 No Yes No
email varchar 128 No Yes No
reply-to varchar 128 No Yes No
bcc varchar 128 No Yes No
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 Yes
del tinyint 1 No Yes No
cache_key varchar 128 No Yes No
created datetime 0 No Yes No
idx int 11 No Yes Yes
uid int 11 No Yes Yes
subject varchar 255 No Yes No
from varchar 255 No Yes No
to varchar 255 No Yes No
cc varchar 255 No Yes No
date datetime 0 No Yes No
size int 11 No Yes Yes
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 Yes
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
user_id int 10 Yes Yes Yes
username varchar 128 No Yes No
mail_host varchar 128 No Yes No
alias varchar 128 No Yes No
created datetime 0 No Yes No
last_login datetime 0 No No No
language varchar 5 No No No
preferences text 0 No No No

Main Page > Application Development Team > DB Specs > 202.2.2.52

Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=Roundcubemail&oldid=3955"