Developers of Sympa

[Olivier Salaün <address@concealed>]

Hi Olivier, Tien Lan,

I've added some documentation regarding the Sympa DB logs in the Sympa 
documentation : 
https://www.sympa.org/wiki/manual/database#sympa_logs_in_the_database

I hope it will help.

Olivier Berger a écrit :
> Tien Lan PHUNG a écrit :
> > > [...]
> > Do you have any reference on docs about activating those logs in the DB,
> > and the table name/format ?
> >
> >     
> Responding to myself (use the source, Luke ;) ) : 
> 5.3a.8		6 September 2006
>
>    New features :
>
>
> 	[Adrien Brard] DB logs : each operations that changes the status of messages/subscriptions/list 
> 	config is now logged in a structured DB entry. Both listmasters and listowners can search this events
>         DB using the Sympa web interface.
>
> The table is like this (MySQL) :
> CREATE TABLE logs_table (
>         id_logs                 bigint(20) NOT NULL,
>         date_logs               int(11) NOT NULL,
>         robot_logs              varchar(80),
>         list_logs               varchar(50),
>         action_logs             varchar(50) NOT NULL,
>         parameters_logs         varchar(100),
>         target_email_logs       varchar(100),
>         user_email_logs         varchar(100),
>         msg_id_logs             varchar(255),
>         status_logs             varchar(10) NOT NULL,
>         error_type_logs         varchar(150),
>         client_logs             varchar(100),
>         daemon_logs             varchar(10) NOT NULL,
>         PRIMARY KEY (id_logs)                                     
> );
>
> As you can see, it only appeared since sympa 5.3.
>