Roundcubemail

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
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