[Building Sakai] Description of table SAKAI_EVENT

[Luiz Antonio Falaguasta Barbosa]

Thanks Steve!

2009/3/10 Steve Swinsburg <s.swinsburg at lancaster.ac.uk>

> NULL in the REF field is because the event has occurred in a place that
> doesn't need/have a location. ie user.login and user.logout
> The ~localhost~admin in the SESSION_ID field I'm not sure of. Presume it's
> events being triggered by the admin user. Seems inconsistent though.
>
>
> cheers,
> Steve
>
> ---
> Steve Swinsburg
> Portal Systems Developer
> Centre for e-Science
> Lancaster University
> Lancaster
> LA1 4YT
>
> email: s.swinsburg at lancaster.ac.uk
> phone: +44 (0) 1524 594870
>
>
>
>
>
>
>
> On 10 Mar 2009, at 13:41, Luiz Antonio Falaguasta Barbosa wrote:
>
> Thanks for the help, guys!
>
> But, I have other doubts:
>
> - Why, in field ref, sometimes occurr value NULL?
> - Why, in field session_id, somtimes occurr value ~localhost~admin?
>
> Thanks in advance!
>
> Regards,
>
> Luiz
>
> 2009/3/10 DAVID ROLDAN MARTINEZ <darolmar at upvnet.upv.es>
>
>> Hi Luiz,
>>
>> ref is a reference to the site_id.
>> session_id references to sakai_session.session_id
>>
>> I also don't know what 'm' at event_code means. I've never used it.
>>
>> Hope this helps.
>>
>> David
>> ________________________________________
>> De: sakai-dev-bounces at collab.sakaiproject.org [
>> sakai-dev-bounces at collab.sakaiproject.org] En nombre de Luiz Antonio
>> Falaguasta Barbosa [lafbarbosa at gmail.com]
>> Enviado el: martes, 10 de marzo de 2009 14:13
>> Para: sakai-dev at collab.sakaiproject.org
>> Asunto: [Building Sakai] Description of table SAKAI_EVENT
>>
>> Hi people,
>>
>> Please, does anybody know what is the meaning of each field in the
>> SAKAI_EVENT table (Sakai version 2.4) ?
>>
>> What I could undestand is:
>>
>> EVENT_ID: autoincrement id
>> EVENT_DATE: timestamp for each event recorded in database
>> EVENT: <tool>.<event>
>> REF: THIS FIELD, I DIDN'T UNDERSTAND
>> SESSION_ID: I believe it's an ID session in hexadecimal, where substrings
>> values to be nothing to do with user identification
>> EVENT_CODE: I DON'T KNOW WHAT IS IT. I FOUND VALUES m AND a FOR THIS
>> FIELD.
>>
>> Please, what is right and what is wrong and what should be to that I
>> described in a wrong way?
>>
>> Thanks in advance!
>>
>> Regards,
>>
>> Luiz
>>
>
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to
> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
> "unsubscribe"
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20090310/eed8c1e1/attachment-0001.html