alter table ACADEMIC_CALENDAR_ENTRY add column SEASON_TYPE varchar(100) default NULL;

alter table ACADEMIC_CALENDAR_ENTRY add column KEY_BASED_ENTRY int(11) default NULL;
alter table ACADEMIC_CALENDAR_ENTRY add column KEY_TEMPLATE_ENTRY int(11) default NULL;

alter table ACADEMIC_CALENDAR_ENTRY add KEY KEY_BASED_ENTRY (KEY_BASED_ENTRY);
alter table ACADEMIC_CALENDAR_ENTRY add KEY KEY_TEMPLATE_ENTRY (KEY_TEMPLATE_ENTRY);