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.
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).
Scripts
Structure
Tables & fields
ALARM
Id
Trigger
Repeat
Duration
Action
CookieId
Attach
Birthdays
Id
DayMonth
Year
Calendars
CalendarId
Name
Colour
| INTEGER | Colour
|
| 0 | Dark Blue
|
| 1 | Green
|
| 2 | Dark Pink
|
| 3 | Orange
|
| 4 | Purple
|
| 5 | Yellow
|
| 6 | White
|
| 7 | Light Blue
|
| 8 | Light Pink
|
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
DateStart
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
