.\" Automatically generated by Pod::Man 4.14 (Pod::Simple 3.40) .\" .\" Standard preamble: .\" ======================================================================== .de Sp \" Vertical space (when we can't use .PP) .if t .sp .5v .if n .sp .. .de Vb \" Begin verbatim text .ft CW .nf .ne \\$1 .. .de Ve \" End verbatim text .ft R .fi .. .\" Set up some character translations and predefined strings. \*(-- will .\" give an unbreakable dash, \*(PI will give pi, \*(L" will give a left .\" double quote, and \*(R" will give a right double quote. \*(C+ will .\" give a nicer C++. Capital omega is used to do unbreakable dashes and .\" therefore won't be available. \*(C` and \*(C' expand to `' in nroff, .\" nothing in troff, for use with C<>. .tr \(*W- .ds C+ C\v'-.1v'\h'-1p'\s-2+\h'-1p'+\s0\v'.1v'\h'-1p' .ie n \{\ . ds -- \(*W- . ds PI pi . if (\n(.H=4u)&(1m=24u) .ds -- \(*W\h'-12u'\(*W\h'-12u'-\" diablo 10 pitch . if (\n(.H=4u)&(1m=20u) .ds -- \(*W\h'-12u'\(*W\h'-8u'-\" diablo 12 pitch . ds L" "" . ds R" "" . ds C` "" . ds C' "" 'br\} .el\{\ . ds -- \|\(em\| . ds PI \(*p . ds L" `` . ds R" '' . ds C` . ds C' 'br\} .\" .\" Escape single quotes in literal strings from groff's Unicode transform. .ie \n(.g .ds Aq \(aq .el .ds Aq ' .\" .\" If the F register is >0, we'll generate index entries on stderr for .\" titles (.TH), headers (.SH), subsections (.SS), items (.Ip), and index .\" entries marked with X<> in POD. Of course, you'll have to process the .\" output yourself in some meaningful fashion. .\" .\" Avoid warning from groff about undefined register 'F'. .de IX .. .nr rF 0 .if \n(.g .if rF .nr rF 1 .if (\n(rF:(\n(.g==0)) \{\ . if \nF \{\ . de IX . tm Index:\\$1\t\\n%\t"\\$2" .. . if !\nF==2 \{\ . nr % 0 . nr F 2 . \} . \} .\} .rr rF .\" .\" Accent mark definitions (@(#)ms.acc 1.5 88/02/08 SMI; from UCB 4.2). .\" Fear. Run. Save yourself. No user-serviceable parts. . \" fudge factors for nroff and troff .if n \{\ . ds #H 0 . ds #V .8m . ds #F .3m . ds #[ \f1 . ds #] \fP .\} .if t \{\ . ds #H ((1u-(\\\\n(.fu%2u))*.13m) . ds #V .6m . ds #F 0 . ds #[ \& . ds #] \& .\} . \" simple accents for nroff and troff .if n \{\ . ds ' \& . ds ` \& . ds ^ \& . ds , \& . ds ~ ~ . ds / .\} .if t \{\ . ds ' \\k:\h'-(\\n(.wu*8/10-\*(#H)'\'\h"|\\n:u" . ds ` \\k:\h'-(\\n(.wu*8/10-\*(#H)'\`\h'|\\n:u' . ds ^ \\k:\h'-(\\n(.wu*10/11-\*(#H)'^\h'|\\n:u' . ds , \\k:\h'-(\\n(.wu*8/10)',\h'|\\n:u' . ds ~ \\k:\h'-(\\n(.wu-\*(#H-.1m)'~\h'|\\n:u' . ds / \\k:\h'-(\\n(.wu*8/10-\*(#H)'\z\(sl\h'|\\n:u' .\} . \" troff and (daisy-wheel) nroff accents .ds : \\k:\h'-(\\n(.wu*8/10-\*(#H+.1m+\*(#F)'\v'-\*(#V'\z.\h'.2m+\*(#F'.\h'|\\n:u'\v'\*(#V' .ds 8 \h'\*(#H'\(*b\h'-\*(#H' .ds o \\k:\h'-(\\n(.wu+\w'\(de'u-\*(#H)/2u'\v'-.3n'\*(#[\z\(de\v'.3n'\h'|\\n:u'\*(#] .ds d- \h'\*(#H'\(pd\h'-\w'~'u'\v'-.25m'\f2\(hy\fP\v'.25m'\h'-\*(#H' .ds D- D\\k:\h'-\w'D'u'\v'-.11m'\z\(hy\v'.11m'\h'|\\n:u' .ds th \*(#[\v'.3m'\s+1I\s-1\v'-.3m'\h'-(\w'I'u*2/3)'\s-1o\s+1\*(#] .ds Th \*(#[\s+2I\s-2\h'-\w'I'u*3/5'\v'-.3m'o\v'.3m'\*(#] .ds ae a\h'-(\w'a'u*4/10)'e .ds Ae A\h'-(\w'A'u*4/10)'E . \" corrections for vroff .if v .ds ~ \\k:\h'-(\\n(.wu*9/10-\*(#H)'\s-2\u~\d\s+2\h'|\\n:u' .if v .ds ^ \\k:\h'-(\\n(.wu*10/11-\*(#H)'\v'-.4m'^\v'.4m'\h'|\\n:u' . \" for low resolution devices (crt and lpr) .if \n(.H>23 .if \n(.V>19 \ \{\ . ds : e . ds 8 ss . ds o a . ds d- d\h'-1'\(ga . ds D- D\h'-1'\(hy . ds th \o'bp' . ds Th \o'LP' . ds ae ae . ds Ae AE .\} .rm #[ #] #H #V #F C .\" ======================================================================== .\" .IX Title "SYMPA_DATABASE 5" .TH SYMPA_DATABASE 5 "2022-11-25" "6.2.70" "sympa 6.2.70" .\" For nroff, turn off justification. Always turn off hyphenation; it makes .\" way too many mistakes in technical documents. .if n .ad l .nh .SH "NAME" sympa_database \- Structure of Sympa core database .SH "DECRIPTION" .IX Header "DECRIPTION" Core database of Sympa is based on \s-1SQL.\s0 In following list of tables and indexes, data types are based on MySQL/MariaDB. Corresponding types are used by other platforms (PostgreSQL, SQLite, ...). .SS "Tables" .IX Subsection "Tables" \fIsubscriber_table\fR .IX Subsection "subscriber_table" .PP This table store subscription, subscription option etc. .PP Fields: .IP "user_subscriber varchar(100)" 4 .IX Item "user_subscriber varchar(100)" (Primary key) .Sp email of subscriber .IP "list_subscriber varchar(50)" 4 .IX Item "list_subscriber varchar(50)" (Primary key) .Sp list name of a subscription .IP "robot_subscriber varchar(80)" 4 .IX Item "robot_subscriber varchar(80)" (Primary key) .Sp robot (domain) of the list .IP "reception_subscriber varchar(20)" 4 .IX Item "reception_subscriber varchar(20)" reception format option of subscriber (digest, summary, etc.) .IP "suspend_subscriber \fBint\fR\|(1)" 4 .IX Item "suspend_subscriber int" boolean set to 1 if subscription is suspended .IP "suspend_start_date_subscriber int(11)" 4 .IX Item "suspend_start_date_subscriber int(11)" the Unix time when message reception is suspended .IP "suspend_end_date_subscriber int(11)" 4 .IX Item "suspend_end_date_subscriber int(11)" the Unix time when message reception should be restored .IP "bounce_subscriber varchar(35)" 4 .IX Item "bounce_subscriber varchar(35)" \&\s-1FIXME\s0 .IP "bounce_score_subscriber \fBsmallint\fR\|(6)" 4 .IX Item "bounce_score_subscriber smallint" \&\s-1FIXME\s0 .IP "bounce_address_subscriber varchar(100)" 4 .IX Item "bounce_address_subscriber varchar(100)" \&\s-1FIXME\s0 .IP "date_epoch_subscriber int(11) not null" 4 .IX Item "date_epoch_subscriber int(11) not null" date of subscription .IP "update_epoch_subscriber int(11)" 4 .IX Item "update_epoch_subscriber int(11)" the last time when subscription is confirmed by subscriber .IP "inclusion_subscriber int(11)" 4 .IX Item "inclusion_subscriber int(11)" the last time when list user is synchronized with data source .IP "inclusion_ext_subscriber int(11)" 4 .IX Item "inclusion_ext_subscriber int(11)" the last time when list user is synchronized with external data source .IP "inclusion_label_subscriber varchar(50)" 4 .IX Item "inclusion_label_subscriber varchar(50)" name of data source .IP "comment_subscriber varchar(150)" 4 .IX Item "comment_subscriber varchar(150)" free form name .IP "number_messages_subscriber \fBint\fR\|(5) not null" 4 .IX Item "number_messages_subscriber int not null" the number of message the subscriber sent .IP "visibility_subscriber varchar(20)" 4 .IX Item "visibility_subscriber varchar(20)" \&\s-1FIXME\s0 .IP "topics_subscriber varchar(200)" 4 .IX Item "topics_subscriber varchar(200)" topic subscription specification .IP "subscribed_subscriber \fBint\fR\|(1)" 4 .IX Item "subscribed_subscriber int" boolean set to 1 if subscriber comes from \s-1ADD\s0 or \s-1SUB\s0 .IP "custom_attribute_subscriber text" 4 .IX Item "custom_attribute_subscriber text" \&\s-1FIXME\s0 .PP Indexes: .IP "subscriber_user_index" 4 .IX Item "subscriber_user_index" user_subscriber .PP \fIuser_table\fR .IX Subsection "user_table" .PP The user_table is mainly used to manage login from web interface. A subscriber may not appear in the user_table if they never log through the web interface. .PP Fields: .IP "email_user varchar(100)" 4 .IX Item "email_user varchar(100)" (Primary key) .Sp email of user .IP "password_user varchar(64)" 4 .IX Item "password_user varchar(64)" password are stored as finger print .IP "gecos_user varchar(150)" 4 .IX Item "gecos_user varchar(150)" display name of user .IP "last_login_date_user int(11)" 4 .IX Item "last_login_date_user int(11)" Unix time of last login, printed in login result for security purpose .IP "last_login_host_user varchar(60)" 4 .IX Item "last_login_host_user varchar(60)" host of last login, printed in login result for security purpose .IP "wrong_login_count_user int(11)" 4 .IX Item "wrong_login_count_user int(11)" login attempt count, used to prevent brute force attack .IP "last_active_date_user int(11)" 4 .IX Item "last_active_date_user int(11)" the last Unix time when this user was confirmed their activity by purge_user_table task .IP "cookie_delay_user int(11)" 4 .IX Item "cookie_delay_user int(11)" \&\s-1FIXME\s0 .IP "lang_user varchar(10)" 4 .IX Item "lang_user varchar(10)" user language preference .IP "attributes_user text" 4 .IX Item "attributes_user text" \&\s-1FIXME\s0 .IP "data_user text" 4 .IX Item "data_user text" \&\s-1FIXME\s0 .PP \fIinclusion_table\fR .IX Subsection "inclusion_table" .PP Inclusion table is used in order to manage lists included from / including subscribers of other lists. .PP Fields: .IP "target_inclusion varchar(131)" 4 .IX Item "target_inclusion varchar(131)" (Primary key) .Sp list \s-1ID\s0 of including list .IP "role_inclusion enum('member','owner','editor')" 4 .IX Item "role_inclusion enum('member','owner','editor')" (Primary key) .Sp role of included user .IP "source_inclusion varchar(131)" 4 .IX Item "source_inclusion varchar(131)" (Primary key) .Sp list \s-1ID\s0 of included list .IP "update_epoch_inclusion int(11)" 4 .IX Item "update_epoch_inclusion int(11)" the date this entry was created or updated .PP \fIexclusion_table\fR .IX Subsection "exclusion_table" .PP Exclusion table is used in order to manage unsubscription for subscriber included from an external data source. .PP Fields: .IP "list_exclusion varchar(57)" 4 .IX Item "list_exclusion varchar(57)" (Primary key) .Sp \&\s-1FIXME\s0 .IP "robot_exclusion varchar(80)" 4 .IX Item "robot_exclusion varchar(80)" (Primary key) .Sp \&\s-1FIXME\s0 .IP "user_exclusion varchar(100)" 4 .IX Item "user_exclusion varchar(100)" (Primary key) .Sp \&\s-1FIXME\s0 .IP "family_exclusion varchar(50)" 4 .IX Item "family_exclusion varchar(50)" (Primary key) .Sp \&\s-1FIXME\s0 .IP "date_exclusion int(11)" 4 .IX Item "date_exclusion int(11)" \&\s-1FIXME\s0 .PP \fIsession_table\fR .IX Subsection "session_table" .PP Management of \s-1HTTP\s0 session. .PP Fields: .IP "id_session varchar(30)" 4 .IX Item "id_session varchar(30)" (Primary key) .Sp the identifier of the database record .IP "prev_id_session varchar(30)" 4 .IX Item "prev_id_session varchar(30)" previous identifier of the database record .IP "start_date_session int(11) not null" 4 .IX Item "start_date_session int(11) not null" the date when the session was created .IP "date_session int(11) not null" 4 .IX Item "date_session int(11) not null" Unix time of the last use of this session. It is used in order to expire old sessions .IP "refresh_date_session int(11)" 4 .IX Item "refresh_date_session int(11)" Unix time of the last refresh of this session. It is used in order to refresh available sessions .IP "remote_addr_session varchar(60)" 4 .IX Item "remote_addr_session varchar(60)" the \s-1IP\s0 address of the computer from which the session was created .IP "robot_session varchar(80)" 4 .IX Item "robot_session varchar(80)" the virtual host in which the session was created .IP "email_session varchar(100)" 4 .IX Item "email_session varchar(100)" the email associated to this session .IP "hit_session int(11)" 4 .IX Item "hit_session int(11)" the number of hit performed during this session. Used to detect crawlers .IP "data_session text" 4 .IX Item "data_session text" parameters attached to this session that don't have a dedicated column in the database .PP Indexes: .IP "session_prev_id_index" 4 .IX Item "session_prev_id_index" prev_id_session .PP \fIone_time_ticket_table\fR .IX Subsection "one_time_ticket_table" .PP One time ticket are random value used for authentication challenge. A ticket is associated with a context which look like a session. .PP Fields: .IP "ticket_one_time_ticket varchar(30)" 4 .IX Item "ticket_one_time_ticket varchar(30)" (Primary key) .Sp \&\s-1FIXME\s0 .IP "email_one_time_ticket varchar(100)" 4 .IX Item "email_one_time_ticket varchar(100)" \&\s-1FIXME\s0 .IP "robot_one_time_ticket varchar(80)" 4 .IX Item "robot_one_time_ticket varchar(80)" \&\s-1FIXME\s0 .IP "date_one_time_ticket int(11)" 4 .IX Item "date_one_time_ticket int(11)" \&\s-1FIXME\s0 .IP "data_one_time_ticket varchar(200)" 4 .IX Item "data_one_time_ticket varchar(200)" \&\s-1FIXME\s0 .IP "remote_addr_one_time_ticket varchar(60)" 4 .IX Item "remote_addr_one_time_ticket varchar(60)" \&\s-1FIXME\s0 .IP "status_one_time_ticket varchar(60)" 4 .IX Item "status_one_time_ticket varchar(60)" \&\s-1FIXME\s0 .PP \fInotification_table\fR .IX Subsection "notification_table" .PP Used for message tracking feature. If the list is configured for tracking, outgoing messages include a delivery status notification request and optionally a message disposition notification request. When \s-1DSN\s0 and \s-1MDN\s0 are received by Sympa, they are stored in this table in relation with the related list and message \s-1ID.\s0 .PP Fields: .IP "pk_notification bigint(20) auto_increment" 4 .IX Item "pk_notification bigint(20) auto_increment" (Primary key) .Sp autoincrement key .IP "message_id_notification varchar(100)" 4 .IX Item "message_id_notification varchar(100)" initial message-id. This field is used to search \s-1DSN\s0 and \s-1MDN\s0 related to a particular message .IP "recipient_notification varchar(100)" 4 .IX Item "recipient_notification varchar(100)" email address of recipient for which a \s-1DSN\s0 or \s-1MDN\s0 was received .IP "reception_option_notification varchar(20)" 4 .IX Item "reception_option_notification varchar(20)" the subscription option of the subscriber when the related message was sent to the list. Useful because some recipient may have option such as //digest// or //nomail// .IP "status_notification varchar(100)" 4 .IX Item "status_notification varchar(100)" value of notification .IP "arrival_date_notification varchar(80)" 4 .IX Item "arrival_date_notification varchar(80)" reception date of latest \s-1DSN\s0 or \s-1MDN\s0 .IP "arrival_epoch_notification int(11)" 4 .IX Item "arrival_epoch_notification int(11)" reception date of latest \s-1DSN\s0 or \s-1MDN\s0 .IP "type_notification enum('\s-1DSN\s0', '\s-1MDN\s0')" 4 .IX Item "type_notification enum('DSN', 'MDN')" type of the notification (\s-1DSN\s0 or \s-1MDN\s0) .IP "list_notification varchar(50)" 4 .IX Item "list_notification varchar(50)" the listname the message was issued for .IP "robot_notification varchar(80)" 4 .IX Item "robot_notification varchar(80)" the robot the message is related to .IP "date_notification int(11) not null" 4 .IX Item "date_notification int(11) not null" \&\s-1FIXME\s0 .PP \fIlogs_table\fR .IX Subsection "logs_table" .PP Each important event is stored in this table. List owners and listmaster can search entries in this table using web interface. .PP Fields: .IP "user_email_logs varchar(100)" 4 .IX Item "user_email_logs varchar(100)" e\-mail address of the message sender or email of identified web interface user (or soap user) .IP "date_logs int(11) not null" 4 .IX Item "date_logs int(11) not null" date when the action was executed .IP "usec_logs \fBint\fR\|(6)" 4 .IX Item "usec_logs int" subsecond in microsecond when the action was executed .IP "robot_logs varchar(80)" 4 .IX Item "robot_logs varchar(80)" name of the robot in which context the action was executed .IP "list_logs varchar(50)" 4 .IX Item "list_logs varchar(50)" name of the mailing-list in which context the action was executed .IP "action_logs varchar(50) not null" 4 .IX Item "action_logs varchar(50) not null" name of the Sympa subroutine which initiated the log .IP "parameters_logs varchar(100)" 4 .IX Item "parameters_logs varchar(100)" comma-separated list of parameters. The amount and type of parameters can differ from an action to another .IP "target_email_logs varchar(100)" 4 .IX Item "target_email_logs varchar(100)" e\-mail address (if any) targeted by the message .IP "msg_id_logs varchar(255)" 4 .IX Item "msg_id_logs varchar(255)" identifier of the message which triggered the action .IP "status_logs varchar(10) not null" 4 .IX Item "status_logs varchar(10) not null" exit status of the action. If it was an error, it is likely that the error_type_logs field will contain a description of this error .IP "error_type_logs varchar(150)" 4 .IX Item "error_type_logs varchar(150)" name of the error string \- if any \- issued by the subroutine .IP "client_logs varchar(100)" 4 .IX Item "client_logs varchar(100)" \&\s-1IP\s0 address of the client machine from which the message was sent .IP "daemon_logs varchar(10) not null" 4 .IX Item "daemon_logs varchar(10) not null" name of the Sympa daemon which ran the action .PP \fIstat_table\fR .IX Subsection "stat_table" .PP Statistics item are stored in this table, Sum average and so on are stored in stat_counter_table. .PP Fields: .IP "date_stat int(11) not null" 4 .IX Item "date_stat int(11) not null" \&\s-1FIXME\s0 .IP "email_stat varchar(100)" 4 .IX Item "email_stat varchar(100)" \&\s-1FIXME\s0 .IP "operation_stat varchar(50) not null" 4 .IX Item "operation_stat varchar(50) not null" \&\s-1FIXME\s0 .IP "list_stat varchar(50)" 4 .IX Item "list_stat varchar(50)" \&\s-1FIXME\s0 .IP "daemon_stat varchar(20)" 4 .IX Item "daemon_stat varchar(20)" \&\s-1FIXME\s0 .IP "user_ip_stat varchar(100)" 4 .IX Item "user_ip_stat varchar(100)" \&\s-1FIXME\s0 .IP "robot_stat varchar(80) not null" 4 .IX Item "robot_stat varchar(80) not null" \&\s-1FIXME\s0 .IP "parameter_stat varchar(50)" 4 .IX Item "parameter_stat varchar(50)" \&\s-1FIXME\s0 .IP "read_stat \fBtinyint\fR\|(1) not null" 4 .IX Item "read_stat tinyint not null" \&\s-1FIXME\s0 .PP Indexes: .IP "stats_user_index" 4 .IX Item "stats_user_index" email_stat .PP \fIstat_counter_table\fR .IX Subsection "stat_counter_table" .PP Used in conjunction with stat_table for users statistics. .PP Fields: .IP "end_date_counter int(11)" 4 .IX Item "end_date_counter int(11)" \&\s-1FIXME\s0 .IP "beginning_date_counter int(11) not null" 4 .IX Item "beginning_date_counter int(11) not null" \&\s-1FIXME\s0 .IP "data_counter varchar(50) not null" 4 .IX Item "data_counter varchar(50) not null" \&\s-1FIXME\s0 .IP "robot_counter varchar(80) not null" 4 .IX Item "robot_counter varchar(80) not null" \&\s-1FIXME\s0 .IP "list_counter varchar(50)" 4 .IX Item "list_counter varchar(50)" \&\s-1FIXME\s0 .IP "count_counter int" 4 .IX Item "count_counter int" \&\s-1FIXME\s0 .PP \fIadmin_table\fR .IX Subsection "admin_table" .PP This table is an internal cash where list admin roles are stored. It is just a cash and it does not need to be saved. You may remove its content if needed. It will just make next Sympa startup slower. .PP Fields: .IP "user_admin varchar(100)" 4 .IX Item "user_admin varchar(100)" (Primary key) .Sp list admin email .IP "list_admin varchar(50)" 4 .IX Item "list_admin varchar(50)" (Primary key) .Sp list name .IP "robot_admin varchar(80)" 4 .IX Item "robot_admin varchar(80)" (Primary key) .Sp list domain .IP "role_admin enum('listmaster','owner','editor')" 4 .IX Item "role_admin enum('listmaster','owner','editor')" (Primary key) .Sp a role of this user for this list (editor, owner or listmaster which a kind of list owner too) .IP "profile_admin enum('privileged','normal')" 4 .IX Item "profile_admin enum('privileged','normal')" privilege level for this owner, value //normal// or //privileged//. The related privilege are listed in edit_list.conf. .IP "date_epoch_admin int(11) not null" 4 .IX Item "date_epoch_admin int(11) not null" date this user become a list admin .IP "update_epoch_admin int(11)" 4 .IX Item "update_epoch_admin int(11)" last update time .IP "inclusion_admin int(11)" 4 .IX Item "inclusion_admin int(11)" the last time when list user is synchronized with data source .IP "inclusion_ext_admin int(11)" 4 .IX Item "inclusion_ext_admin int(11)" the last time when list user is synchronized with external data source .IP "inclusion_label_admin varchar(50)" 4 .IX Item "inclusion_label_admin varchar(50)" name of data source .IP "reception_admin varchar(20)" 4 .IX Item "reception_admin varchar(20)" email reception option for list management messages .IP "visibility_admin varchar(20)" 4 .IX Item "visibility_admin varchar(20)" admin user email can be hidden in the list web page description .IP "comment_admin varchar(150)" 4 .IX Item "comment_admin varchar(150)" \&\s-1FIXME\s0 .IP "subscribed_admin \fBint\fR\|(1)" 4 .IX Item "subscribed_admin int" set to 1 if user is list admin by definition in list config file .IP "info_admin varchar(150)" 4 .IX Item "info_admin varchar(150)" private information usually dedicated to listmasters who needs some additional information about list owners .PP Indexes: .IP "admin_user_index" 4 .IX Item "admin_user_index" user_admin .PP \fInetidmap_table\fR .IX Subsection "netidmap_table" .PP \&\s-1FIXME\s0 .PP Fields: .IP "netid_netidmap varchar(100)" 4 .IX Item "netid_netidmap varchar(100)" (Primary key) .Sp \&\s-1FIXME\s0 .IP "serviceid_netidmap varchar(100)" 4 .IX Item "serviceid_netidmap varchar(100)" (Primary key) .Sp \&\s-1FIXME\s0 .IP "robot_netidmap varchar(80)" 4 .IX Item "robot_netidmap varchar(80)" (Primary key) .Sp \&\s-1FIXME\s0 .IP "email_netidmap varchar(100)" 4 .IX Item "email_netidmap varchar(100)" \&\s-1FIXME\s0 .PP \fIconf_table\fR .IX Subsection "conf_table" .PP \&\s-1FIXME\s0 .PP Fields: .IP "robot_conf varchar(80)" 4 .IX Item "robot_conf varchar(80)" (Primary key) .Sp \&\s-1FIXME\s0 .IP "label_conf varchar(80)" 4 .IX Item "label_conf varchar(80)" (Primary key) .Sp \&\s-1FIXME\s0 .IP "value_conf varchar(300)" 4 .IX Item "value_conf varchar(300)" the value of parameter //label_conf// of robot //robot_conf//. .PP \fIlist_table\fR .IX Subsection "list_table" .PP The list_table holds cached list config and some items to help searching lists. .PP Fields: .IP "name_list varchar(50)" 4 .IX Item "name_list varchar(50)" (Primary key) .Sp name of the list .IP "robot_list varchar(80)" 4 .IX Item "robot_list varchar(80)" (Primary key) .Sp name of the robot (domain) the list belongs to .IP "family_list varchar(50)" 4 .IX Item "family_list varchar(50)" name of the family the list belongs to .IP "status_list enum('open','closed','pending','error_config','family_closed')" 4 .IX Item "status_list enum('open','closed','pending','error_config','family_closed')" status of the list .IP "creation_email_list varchar(100)" 4 .IX Item "creation_email_list varchar(100)" email of user who created the list .IP "creation_epoch_list int(11)" 4 .IX Item "creation_epoch_list int(11)" \&\s-1UNIX\s0 time when the list was created .IP "update_email_list varchar(100)" 4 .IX Item "update_email_list varchar(100)" email of user who updated the list .IP "update_epoch_list int(11)" 4 .IX Item "update_epoch_list int(11)" \&\s-1UNIX\s0 time when the list was updated .IP "searchkey_list varchar(255)" 4 .IX Item "searchkey_list varchar(255)" case-folded list subject to help searching .IP "web_archive_list \fBtinyint\fR\|(1)" 4 .IX Item "web_archive_list tinyint" if the list has archives .IP "topics_list varchar(255)" 4 .IX Item "topics_list varchar(255)" topics of the list, separated and enclosed by commas .IP "total_list \fBint\fR\|(7)" 4 .IX Item "total_list int" estimated number of subscribers .SH "SEE ALSO" .IX Header "SEE ALSO" \&\fISympa Administration Manual\fR. .