Where are calendars stored?

[Lennart Bonnevier]

When I "Create" a team calendar in Confluence, where are data stored? In the local space or in some global "calendar-space"? Or somewhere else?

[Jonas Andersson · Accepted solution]

Hi Lennart,

They are stored in a TC_EVENTS table in the mysql database, and can be queried like this;

select
        SUMMARY,
        DESCRIPTION,
        FROM_UNIXTIME(SUBSTRING(START, 1, 10)) AS Start,
        FROM_UNIXTIME(SUBSTRING(END, 1, 10)) AS End,
        ALL_DAY
    from AO_<HEXNUMBER>_TC_EVENTS where SUB_CALENDAR_ID="<UNIQUE.ID.OF.CALENDER>"
    order by start;

I do the FROM_UNIXTIME transformation to get somewhat readable dates out of it..

Not sure if this is a path you want/can walk, but it's something..

Mvh

Jonas