Hello

In my process to create an equivalent for the calltrack android application, I have found a good way to extract call events with the following query:
sqlite3 ~user/.rtcom-eventlogger/el-v1.db
select event_type_id, datetime(start_time,'unixepoch','localtime'), time(end_time-start_time,'unixepoch','localtime') as duration, events.remote_uid, remotes.remote_name from events, remotes where remotes.remote_uid=events.remote_uid and service_id=1 order by id desc limit 5;

Now I would like to add calendar entries, but I don't know what are the mandatory columns in the components table from ~user/.calendar/calendardb that seems to list events. Can I just add the type, start, end, description?

I wouldn't want to create a damaged entry since I'm actively using the N900 calendar, so before taking that risk I'm wondering if anyone tried to add event to the calender by sql yet.

My end goal is to have a trigger in the eventlogger database to add calendar events if possible.

Guylhem