[Building Sakai] Description of table SAKAI_EVENT

[Steve Swinsburg]

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/34878975/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 2437 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20090310/34878975/attachment.bin