Calendar database

(DateStart)
Line 156: Line 156:
::{| class="wikitable"
::{| class="wikitable"
|-
|-
-
| <INTEGER> || <date start>
+
| <INTEGER> || <start date>
|-
|-
|}
|}

Revision as of 01:50, 20 September 2010

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.

If you want to help editing this wiki and writing useful informations on fields or new scripts, feel free to copy your own database on your computer and analyze it with some tools like "SQLite Database Browser" (Linux/Debian).

Contents

Scripts

Structure

Tables & fields

ALARM

Id

Trigger

Repeat

Duration

Action

CookieId

Attach

Birthdays

Id

DayMonth

Year

Calendars

CalendarId

Name

Colour

Type
INTEGER
Description
Colour of a calendar
Mappings
0 Dark Blue
1 Green
2 Dark Pink
3 Orange
4 Purple
5 Yellow
6 White
7 Light Blue
8 Light Pink
9 Yellow-Green

IsVisible

Type
INTEGER
Description
Mappings
0 not visible
1 visible

IsReadonly

Type
INTEGER
Description
Indicates if the calendar is writeable or not.
Mappings
0 writeable
1 not writeable

CalendarType

Type
INTEGER
Description
Mappings
0 local
1 intelligent
2
3 private
4 synchronized

CalendarTune

CalendarVersion

CalendarProfile

ComponentDetails

Id

ComponentType

Type
INTEGER
Description
Defines the type of a calendar component.
Mappings
1 Event
2 Task
3 Note
4 Birthday

Class

Geo

Priority

DateStamp

Sequence

Transparency

Uid

Url

Attach

Category

Comment

Contact

Related

Resources

Percent

Completed

Components

Id

CalendarId

ComponentType

Flags

DateStart

Type
INTEGER
Description
Start date of a component in the Unix Time Format (number of seconds since 01/01/1970).
Mappings
<INTEGER> <start date>

DateEnd

Type
INTEGER
Description
End date of a component in the Unix Time Format (number of seconds since 01/01/1970).
Mappings
-1 undefined
<INTEGER> <end date>

Summary

Type
TEXT
Description
Title of a component

Location

Type
TEXT
Description
Location of a component

Description

Type
TEXT
Description
Comments of a component

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