Calendar database
(New page: 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/...) |
|||
| Line 1: | Line 1: | ||
| - | 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 | + | 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. |
| + | = Scripts = | ||
= Structure = | = Structure = | ||
== Tables & fields == | == Tables & fields == | ||
| + | |||
=== ALARM === | === ALARM === | ||
| - | === Id ==== | + | ==== Id ==== |
| - | === Trigger === | + | ==== Trigger ==== |
| - | === Repeat === | + | ==== Repeat ==== |
| - | === Duration === | + | ==== Duration ==== |
| - | === Action === | + | ==== Action ==== |
| - | === CookieId === | + | ==== CookieId ==== |
| - | === Attach === | + | ==== Attach ==== |
| - | == Birthdays == | + | |
| - | === Id === | + | === Birthdays === |
| - | === DayMonth === | + | ==== Id ==== |
| - | === Year === | + | ==== DayMonth ==== |
| - | == Calendars == | + | ==== Year ==== |
| - | === CalendarId === | + | |
| - | Name | + | === Calendars === |
| - | Colour | + | ==== CalendarId ==== |
| - | IsVisible | + | ==== Name ==== |
| - | IsReadonly | + | ==== Colour ==== |
| - | CalendarType | + | ==== IsVisible ==== |
| - | CalendarTune | + | ==== IsReadonly ==== |
| - | CalendarVersion | + | ==== CalendarType ==== |
| - | CalendarProfile | + | ==== CalendarTune ==== |
| - | == Componentdetails == | + | ==== CalendarVersion ==== |
| - | Id | + | ==== CalendarProfile ==== |
| - | ComponentType | + | |
| - | Class | + | === Componentdetails === |
| - | geo | + | ==== Id ==== |
| - | Priority | + | ==== ComponentType ==== |
| - | DateStamp | + | ==== Class ==== |
| - | Sequence | + | ==== geo ==== |
| - | Transparency | + | ==== Priority ==== |
| - | Uid | + | ==== DateStamp ==== |
| - | Url | + | ==== Sequence ==== |
| - | Attach | + | ==== Transparency ==== |
| - | Category | + | ==== Uid ==== |
| - | Comment | + | ==== Url ==== |
| - | Contact | + | ==== Attach ==== |
| - | Related | + | ==== Category ==== |
| - | Resources | + | ==== Comment ==== |
| - | Percent | + | ==== Contact ==== |
| - | Completed | + | ==== Related ==== |
| - | == Components == | + | ==== Resources ==== |
| - | Id | + | ==== Percent ==== |
| - | CalendarId | + | ==== Completed ==== |
| - | ComponentType | + | |
| - | Flags | + | === Components === |
| - | SateStart | + | ==== Id ==== |
| - | DateEnd | + | ==== CalendarId ==== |
| - | Summary | + | ==== ComponentType ==== |
| - | Location | + | ==== Flags ==== |
| - | Description | + | ==== SateStart ==== |
| - | Status | + | ==== DateEnd ==== |
| - | uid | + | ==== Summary ==== |
| - | Until | + | ==== Location ==== |
| - | AllDay | + | ==== Description ==== |
| - | CreatedTime | + | ==== Status ==== |
| - | ModifiedTime | + | ==== uid ==== |
| - | Tzid | + | ==== Until ==== |
| - | TzOffset | + | ==== AllDay ==== |
| - | == IDMAP == | + | ==== CreatedTime ==== |
| - | LocalId | + | ==== ModifiedTime ==== |
| - | ExternalId | + | ==== Tzid ==== |
| - | == Instances == | + | ==== TzOffset ==== |
| - | Id | + | |
| - | DateStart | + | === IDMAP === |
| - | DateEnd | + | ==== LocalId ==== |
| - | == Parameters == | + | ==== ExternalId ==== |
| - | ComponentId | + | |
| - | PropertyType | + | === Instances === |
| - | PropertyValue | + | ==== Id ==== |
| - | ParamName | + | ==== DateStart ==== |
| - | ParamValue | + | ==== DateEnd ==== |
| - | == RECURSIVE == | + | |
| - | Id | + | === Parameters === |
| - | Rrule | + | ==== ComponentId ==== |
| - | Rdates | + | ==== PropertyType ==== |
| - | Exdates | + | ==== PropertyValue ==== |
| - | Exrule | + | ==== ParamName ==== |
| - | RecurrenceId | + | ==== ParamValue ==== |
| - | Rtype | + | |
| - | == TIMEZONE == | + | === RECURSIVE === |
| - | Location | + | ==== Id ==== |
| - | Tzid | + | ==== Rrule ==== |
| - | DtStartStd | + | ==== Rdates ==== |
| - | DtStartDst | + | ==== Exdates ==== |
| - | TzOffsetStd | + | ==== Exrule ==== |
| - | TzOffsetDst | + | ==== RecurrenceId ==== |
| - | RRuleStd | + | ==== Rtype ==== |
| - | RRuleDst | + | |
| - | TzName | + | === TIMEZONE === |
| - | DSTFlag | + | ==== Location ==== |
| - | == Trash == | + | ==== Tzid ==== |
| - | ComponentId | + | ==== DtStartStd ==== |
| - | CalendarId | + | ==== DtStartDst ==== |
| - | ComponentType | + | ==== TzOffsetStd ==== |
| - | DeletedTime | + | ==== TzOffsetDst ==== |
| - | CreatedTime | + | ==== RRuleStd ==== |
| - | == XProperties == | + | ==== RRuleDst ==== |
| - | ComponentId | + | ==== TzName ==== |
| - | XPropertyName | + | ==== DSTFlag ==== |
| - | XPropertyValue | + | |
| - | == sqlite_sequence == | + | === Trash === |
| - | name | + | ==== ComponentId ==== |
| - | seq | + | ==== 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 === | ||
[[Category:Calendar]] | [[Category:Calendar]] | ||
Revision as of 00:03, 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.
Contents |