I agree with jondolar. For events calendar I’ve got two tables:
- first with event_id, name, place … startDay, endDay, recurringType, recurringDays … commonDescription … (one record per event)
- second with event_id, occurDay, startTime, endTime, individualDescription (count of records for event = count of occurences)
Admin selects type and days of recurring (each Monday till Friday, second Thursday of month etc.), script generates all days and creates records.
When update is needed, admin can change type and days of recurring (which are stored in first table), script deletes old records in second table and creates new.
For each day in calendar, list of actions is simple SELECT “… WHERE occurDay = …” Queries for whole month or week are simple, too.