{'Guid': 'VARCHAR(64) NOT NULL PRIMARY KEY', 'Package': "VARCHAR(255) NOT NULL DEFAULT ''", 'GoogleEventId': 'VARCHAR(255)', 'EventDate': 'DATE', 'StartTime': 'VARCHAR(8)', 'DayName': 'VARCHAR(4)', 'Summary': 'VARCHAR(512)', 'Notes': 'VARCHAR(512)', 'Location': 'VARCHAR(512)', 'SyncTime': 'DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP', 'CreateTime': 'DATETIME DEFAULT CURRENT_TIMESTAMP', 'Module': 'VARCHAR(255)'}
INSERT INTO data_calendar_event
(Guid, Package, GoogleEventId, EventDate,
StartTime, DayName, Summary, Notes,
Location, Module)
VALUES
('{guid}', '{package}', '{event_id}',
'{event_date}', '{start_time}',
'{day_name}', '{summary}', '{notes}',
'{location}', 'ObjServiceCalendar')
ON DUPLICATE KEY UPDATE
EventDate = VALUES(EventDate),
StartTime = VALUES(StartTime),
DayName = VALUES(DayName),
Summary = VALUES(Summary),
Notes = VALUES(Notes),
Location = VALUES(Location),
SyncTime = CURRENT_TIMESTAMP
SELECT EventDate, DayName, Summary, Notes, Location FROM data_calendar_event WHERE Package = '{package}'
AND EventDate >= CURDATE()
ORDER BY EventDate, StartTime LIMIT {limit}