Tables: Config

Config

Contains (key, values) string pairs that contain configuration information. Keys can be repeated with different values for different configurations names.

> Columns

conf_key: varchar(100) not null
The name of the parameter.
value: varchar(2000)
The value of the parameter.
conf_name: varchar(100)
The name of the configuration to which the pair (key,value) applies. A null value means that this is the default configuration.

> Size

Usually no more than a few hundred entries.

> Examples

Set a default value for the attachments directory, and add a different value that will taken when using the 'winconf' configuration.

INSERT INTO config(conf_key,value,conf_name) VALUES('attachments_directory',
 '/var/tmp/manitou, null);
INSERT INTO config(conf_key,value,conf_name) VALUES('attachments_directory',
 'c:\\tmp, 'winconf');

> Configuration keys

Key Type Scope Value
last_n Integer User interface Number of messages to retrieve for the command 'Last N messages from the sender'

display_threads Integer (1 or 0) User interface Show threads as a tree of messages (value=1) or flattened (value=0)

body_clickable_urls Integer (1 or 0) User interface When true, web URLs are recognized in bodies and displayed as browser-like clickable links. An external browser is used to display web pages. When false, web URLs are not recognized and displayed as any other piece of text.

forward_subject_prefix String User interface A string that will be prepended to the subject line when forwarding a message

forward_start_quote String User interface A string that will be added at the start of the original body when forwarding a message

forward_end_quote String User interface A string that will be appended at the end of the original body (just before the signature) when forwarding a message

reply_attribution_string String User interface A string that will be inserted before the quoted part of the original body, when replying to a message. If it contains a %F, it will be replaced dynamically by the sender of the original message.

show_headers_level Integer (0,1 or 2) User interface How much of the headers are shown above the message body: 0=none, 1=the most useful, 2=all

sender_displayed_as string User interface If the value is 'name' (without the quotes), display the name of the sender in the messages lists. If it's 'email', display the mail address instead

reply_copy_tags integer (0 or 1) User interface When set (value=1), the tags assigned to a message will be automatically assigned to the reply to the message as well

show_tags integer (0 or 1) User interface When set (value=1), the tags panel at the left of every message window will be displayed, else it will be hidden

attachments_directory string User interface Path of the directory where attachments files are created when they need to be viewed by the user interface

max_messages_retrieved integer User interface Set the default limit of messages that can be fetched by a query. This allows for not waiting too long or abusing the network resources when a query should return many messages (several tens of thousands or more)

date_format string User interface Set the format of the date displayed in the messages list. Current possibles values are 'DD/MM/YYYY HH:MI' (european style) and 'YYYY/MM/DD HH:MI' (US style), without the quotes.

msg_window_pages integer User interface The number of pages that can be kept simultaneously in memory by a window. It defaults to 5

Key	Type	Scope	Value
last_n	Integer	User interface	Number of messages to retrieve for the command 'Last N messages from the sender'
display_threads	Integer (1 or 0)	User interface	Show threads as a tree of messages (value=1) or flattened (value=0)
body_clickable_urls	Integer (1 or 0)	User interface	When true, web URLs are recognized in bodies and displayed as browser-like clickable links. An external browser is used to display web pages. When false, web URLs are not recognized and displayed as any other piece of text.
forward_subject_prefix	String	User interface	A string that will be prepended to the subject line when forwarding a message
forward_start_quote	String	User interface	A string that will be added at the start of the original body when forwarding a message
forward_end_quote	String	User interface	A string that will be appended at the end of the original body (just before the signature) when forwarding a message
reply_attribution_string	String	User interface	A string that will be inserted before the quoted part of the original body, when replying to a message. If it contains a %F, it will be replaced dynamically by the sender of the original message.
show_headers_level	Integer (0,1 or 2)	User interface	How much of the headers are shown above the message body: 0=none, 1=the most useful, 2=all
sender_displayed_as	string	User interface	If the value is 'name' (without the quotes), display the name of the sender in the messages lists. If it's 'email', display the mail address instead
reply_copy_tags	integer (0 or 1)	User interface	When set (value=1), the tags assigned to a message will be automatically assigned to the reply to the message as well
show_tags	integer (0 or 1)	User interface	When set (value=1), the tags panel at the left of every message window will be displayed, else it will be hidden
attachments_directory	string	User interface	Path of the directory where attachments files are created when they need to be viewed by the user interface
max_messages_retrieved	integer	User interface	Set the default limit of messages that can be fetched by a query. This allows for not waiting too long or abusing the network resources when a query should return many messages (several tens of thousands or more)
date_format	string	User interface	Set the format of the date displayed in the messages list. Current possibles values are 'DD/MM/YYYY HH:MI' (european style) and 'YYYY/MM/DD HH:MI' (US style), without the quotes.
msg_window_pages	integer	User interface	The number of pages that can be kept simultaneously in memory by a window. It defaults to 5