Calendar database
m (→CalendarType) |
m (→ComponentType) |
||
| Line 107: | Line 107: | ||
==== Id ==== | ==== Id ==== | ||
==== ComponentType ==== | ==== ComponentType ==== | ||
| + | :''Type'' | ||
| + | ::INTEGER | ||
| + | :''Description'' | ||
| + | :: Defines the type of a calendar component. | ||
| + | :''Mappings'' | ||
| + | ::{| class="wikitable" | ||
| + | |- | ||
| + | | 1 || Event | ||
| + | |- | ||
| + | | 2 || Task | ||
| + | |- | ||
| + | | 3 || Note | ||
| + | |- | ||
| + | | 4 || Birthday | ||
| + | |- | ||
| + | |} | ||
| + | |||
==== Class ==== | ==== Class ==== | ||
==== Geo ==== | ==== Geo ==== | ||
Revision as of 01:14, 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
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