This shows you the differences between two versions of the page.
reference:calender_events [2013/02/20 11:07] – created paul | reference:calender_events [2013/02/20 11:07] (current) – removed paul | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ======Calendar.Events table====== | ||
- | The [[Calendar]].Events table contains a record of all the events in calendars managed by VPOP3. | ||
- | An ' | ||
- | |||
- | =====Columns===== | ||
- | * id - this is a [[http:// | ||
- | * calid - this is an integer which specifies which [[calendar_calendar|calendar]] this event is contained within | ||
- | * scopestart - this is a timestamp which indicates when the event starts. Note that if this is a recurring event, the ' | ||
- | * scopeend - this is a timestamp which indicates when the event ends. Note that if this is a recurring event, the ' | ||
- | * created - this is a timestamp indicating when the event was created - this is set automatically by a trigger | ||
- | * lastupdate - this is a timestamp indicating when the event was last updated - this is set automatically by a trigger | ||
- | * filename - this is the iCalendar ' | ||
- | * content - this is text containing the iCalendar event (VEVENT) description | ||
- | * recurrence - this is a boolean indicating whether the event is a recurring event (true) or a single event (false) | ||
- | |||
- | Note that the database does not directly contain most of the data about the event, such as description, | ||
- | |||
- | If you are looking for events occurring at a certain time, you can use the ' | ||
- | |||
- | To be able to do anything useful with this data, you will probably need to read and understand the [[http:// |