ALTER TABLE PublicTrainingEvent ADD COLUMN ChapterID INT(11) DEFAULT NULL AFTER Venue;
ALTER TABLE PublicTrainingEvent ADD KEY ChapterID (ChapterID);
-- You may need to update existing rows to set ChapterID for historical data.