• 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 tasks.

Contents 1 Scripts 2 Structure 2.1 Tables & fields 2.1.1 ALARM 2.1.1.1 Id 2.1.1.2 Trigger 2.1.1.3 Repeat 2.1.1.4 Duration 2.1.1.5 Action 2.1.1.6 CookieId 2.1.1.7 Attach 2.1.2 Birthdays 2.1.2.1 Id 2.1.2.2 DayMonth 2.1.2.3 Year 2.1.3 Calendars 2.1.3.1 CalendarId 2.1.3.2 Name 2.1.3.3 Colour 2.1.3.4 IsVisible 2.1.3.5 IsReadonly 2.1.3.6 CalendarType 2.1.3.7 CalendarTune 2.1.3.8 CalendarVersion 2.1.3.9 CalendarProfile 2.1.4 Componentdetails 2.1.4.1 Id 2.1.4.2 ComponentType 2.1.4.3 Class 2.1.4.4 geo 2.1.4.5 Priority 2.1.4.6 DateStamp 2.1.4.7 Sequence 2.1.4.8 Transparency 2.1.4.9 Uid 2.1.4.10 Url 2.1.4.11 Attach 2.1.4.12 Category 2.1.4.13 Comment 2.1.4.14 Contact 2.1.4.15 Related 2.1.4.16 Resources 2.1.4.17 Percent 2.1.4.18 Completed 2.1.5 Components 2.1.5.1 Id 2.1.5.2 CalendarId 2.1.5.3 ComponentType 2.1.5.4 Flags 2.1.5.5 SateStart 2.1.5.6 DateEnd 2.1.5.7 Summary 2.1.5.8 Location 2.1.5.9 Description 2.1.5.10 Status 2.1.5.11 uid 2.1.5.12 Until 2.1.5.13 AllDay 2.1.5.14 CreatedTime 2.1.5.15 ModifiedTime 2.1.5.16 Tzid 2.1.5.17 TzOffset 2.1.6 IDMAP 2.1.6.1 LocalId 2.1.6.2 ExternalId 2.1.7 Instances 2.1.7.1 Id 2.1.7.2 DateStart 2.1.7.3 DateEnd 2.1.8 Parameters 2.1.8.1 ComponentId 2.1.8.2 PropertyType 2.1.8.3 PropertyValue 2.1.8.4 ParamName 2.1.8.5 ParamValue 2.1.9 RECURSIVE 2.1.9.1 Id 2.1.9.2 Rrule 2.1.9.3 Rdates 2.1.9.4 Exdates 2.1.9.5 Exrule 2.1.9.6 RecurrenceId 2.1.9.7 Rtype 2.1.10 TIMEZONE 2.1.10.1 Location 2.1.10.2 Tzid 2.1.10.3 DtStartStd 2.1.10.4 DtStartDst 2.1.10.5 TzOffsetStd 2.1.10.6 TzOffsetDst 2.1.10.7 RRuleStd 2.1.10.8 RRuleDst 2.1.10.9 TzName 2.1.10.10 DSTFlag 2.1.11 Trash 2.1.11.1 ComponentId 2.1.11.2 CalendarId 2.1.11.3 ComponentType 2.1.11.4 DeletedTime 2.1.11.5 CreatedTime 2.1.12 XProperties 2.1.12.1 ComponentId 2.1.12.2 XPropertyName 2.1.12.3 XPropertyValue 2.1.13 sqlite_sequence 2.1.13.1 name 2.1.13.2 seq 2.2 Indices 2.2.1 IDX_ALARM 2.2.2 IDX_BIRTHDAYS_DATE 2.2.3 IDX_BIRTHDAYS_IDS 2.2.4 IDX_CALENDAR 2.2.5 IDX_COMPONENT 2.2.6 IDX_DETAILS 2.2.7 IDX_INST 2.2.8 IDX_RECURSIVE 2.2.9 IDX_TIMEZONE 2.2.10 IDX_TRASH

Scripts

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

Indices

IDX_ALARM

IDX_BIRTHDAYS_DATE

IDX_BIRTHDAYS_IDS

IDX_CALENDAR

IDX_COMPONENT

IDX_DETAILS

IDX_INST

IDX_RECURSIVE

IDX_TIMEZONE

IDX_TRASH