• Intro
• Downloads
• Community
• Development
• News
• TALK

Calendar database

The calendar database can be found in /home/user/.calendar/calendardb. The goal of this wiki is to provide enough information on the calendar database in order to implement mass modifying/adding/deleting events verifying some criterias (string match in title, locations, comments for example). It could be easy then to write a small shell script using zenity and sqlite3 to perform this kind of tasks.

Contents 1 Structure 1.1 Tables & fields 1.1.1 ALARM 1.1.2 Id = 1.1.3 Trigger 1.1.4 Repeat 1.1.5 Duration 1.1.6 Action 1.1.7 CookieId 1.1.8 Attach 1.2 Birthdays 1.2.1 Id 1.2.2 DayMonth 1.2.3 Year 1.3 Calendars 1.3.1 CalendarId 1.4 Componentdetails 1.5 Components 1.6 IDMAP 1.7 Instances 1.8 Parameters 1.9 RECURSIVE 1.10 TIMEZONE 1.11 Trash 1.12 XProperties 1.13 sqlite_sequence

Structure

Tables & fields

ALARM

Id =

Trigger

Repeat

Duration

Action

CookieId

Attach

Birthdays

Id

DayMonth

Year

Calendars

CalendarId

Name Colour IsVisible IsReadonly CalendarType CalendarTune CalendarVersion CalendarProfile

Componentdetails

Id ComponentType Class geo Priority DateStamp Sequence Transparency Uid Url Attach Category Comment Contact Related Resources Percent Completed

Components

Id CalendarId ComponentType Flags SateStart DateEnd Summary Location Description Status uid Until AllDay CreatedTime ModifiedTime Tzid TzOffset

IDMAP

LocalId ExternalId

Instances

Id DateStart DateEnd

Parameters

ComponentId PropertyType PropertyValue ParamName ParamValue

RECURSIVE

Id Rrule Rdates Exdates Exrule RecurrenceId Rtype

TIMEZONE

Location Tzid DtStartStd DtStartDst TzOffsetStd TzOffsetDst RRuleStd RRuleDst TzName DSTFlag

Trash

ComponentId CalendarId ComponentType DeletedTime CreatedTime

XProperties

ComponentId XPropertyName XPropertyValue

sqlite_sequence

name seq