 alter table EVAL_ASSIGN_USER add (COMPLETED_DATE datetime);
 create index eval_asgnuser_completedDate on EVAL_ASSIGN_USER (COMPLETED_DATE);
 
+

	
insert into EVAL_CONFIG (LAST_MODIFIED, NAME, VALUE) VALUES (CURRENT_TIMESTAMP(),'CONSOLIDATED_EMAIL_NOTIFY_AVAILABLE',true);

alter table eval_evaluation add (AVAILABLE_EMAIL_SENT bit);

alter table EVAL_EVALUATION add (INSTRUCTOR_VIEW_ALL_RESULTS bit);
alter table EVAL_EVALUATION add (ALL_ROLES_PARTICIPATE bit);

-- MySQL conversion script - 1.3 to 1.4 
alter table EVAL_EVALUATION add (LOCAL_SELECTOR varchar(255));

update EVAL_EMAIL_TEMPLATE set template_type='ConsolidatedAvailable' where template_type='SingleEmailAvailable';
update EVAL_EMAIL_TEMPLATE set template_type='ConsolidatedReminder' where template_type='SingleEmailReminder';

create table EVAL_EMAIL_PROCESSING_QUEUE 
(
