1
edit
Calendar:Sql Calendar Schema: Difference between revisions
Jump to navigation
Jump to search
→Recurrence
(→Mostafa's comments:: Reply to TZ suggestion.) |
Adamcrow64 (talk | contribs) |
||
| Line 43: | Line 43: | ||
** 3 - monthly (recur_data determines which day of the month) | ** 3 - monthly (recur_data determines which day of the month) | ||
** 4 - yearly (recur_data indicates daymonth) | ** 4 - yearly (recur_data indicates daymonth) | ||
* `recur_interval` - every N (days/weeks/months/years) | ** 5 - hourly (recur_data determines minute(s) of the hour) | ||
** 6 - minute (recur_data determines second(s) of the minute) | |||
* `recur_interval` - every N (minutes/hours/days/weeks/months/years) | |||
* `recur_data` | * `recur_data` | ||
** if type 2: bitmask, 0-6 are Su M Tu W Th F S | ** if type 2: bitmask, 0-6 are Su M Tu W Th F S | ||
** if type 3: month number, 1-12 (0-11?) | ** if type 3: month number, 1-12 (0-11?) | ||
** if type 4: month (1-12), day (1-7), as (month | (day << 8)) | ** if type 4: month (1-12), day (1-7), as (month | (day << 8)) | ||
** if type 5: minute number 0 - 59 (64 bitmask value would be best) | |||
** if type 6: second number 0 - 59 (64 bitmask value would be best) | |||
* `recur_end`: NULL if forever, otherweise a datetime; we can calculate the remaining count from this | * `recur_end`: NULL if forever, otherweise a datetime; we can calculate the remaining count from this | ||
* `recur_flags`: 0x1: has exceptions (see `cal_event_recur_exceptions` table) | * `recur_flags`: 0x1: has exceptions (see `cal_event_recur_exceptions` table) | ||