Repeat schedule rule generator http://jakubroztocil.github.io/rrule/
CREATE TABLE `schedule_info` (
`schedule_id` char(32) NOT NULL COMMENT '',
`group_id` char(32) DEFAULT NULL COMMENT '',
`calendar_id` char(32) NOT NULL COMMENT '',
`schedule_summary` varchar(255) DEFAULT NULL COMMENT '',
`schedule_desc` varchar(500) DEFAULT NULL COMMENT '',
`location` varchar(255) DEFAULT NULL COMMENT '',
`start_time` datetime DEFAULT NULL COMMENT '',
`end_time` datetime DEFAULT NULL COMMENT '',
`rule` varchar(255) DEFAULT NULL COMMENT '',
`timezone` tinyint(2) DEFAULT '8' COMMENT '',
`attendee_authority` char(2) DEFAULT '02' COMMENT ' ',
`is_all_day` bit(1) DEFAULT b'0' COMMENT '',
`repeat_type` char(2) DEFAULT NULL COMMENT '',
`organizer` varchar(64) DEFAULT NULL COMMENT '',
`organizer_name` varchar(32) DEFAULT NULL COMMENT ''
PRIMARY KEY (`schedule_id`),
KEY `IDX_GROUP_ID` (`group_id`),
KEY `IDX_CALENDAR_ID` (`calendar_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='';
INSERT INTO `schedule_info` (`schedule_id`, `group_id`, `calendar_id`, `schedule_summary`, `schedule_desc`, `location`, `start_time`, `end_time`, `rule`, `timezone`, `attendee_authority`, `is_all_day`, `repeat_type`, `organizer`, `organizer_name`) VALUES ('1d540f5027c3a5eac63c9b6bdf8933bf', '59b7df9486a84b5b99adeba77f840b7d', '29a75744a7cda6800f36a0dbca08ac6e', 'Test schedule', 'Schedule description', 'Place', '2021-09-03 12:00:00', '2021-09-03 12:30:00', 'DTSTART:20210903T023000Z\nRRULE:FREQ=DAILY', 8, '02', b'0', '01');
I am searching for a long time on net. But no use. Please help or try to give some ideas how to achieve this.