This shows you the differences between two versions of the page.
Previous revision | |||
— | reference:calendar_events [2018/11/14 10:45] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
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:// |