[Contrib: Evaluation System] Mismatch in SQL migration scripts?

Daniel Merino daniel.merino at unavarra.es
Thu Feb 28 05:41:05 PST 2013


Hi everybody.

I'm currently starting to test Evalsys 1.4.1 upgrading it from 1.3.0.

Looking for SQL migration scripts, I think that there is a mismatch in 
impl/src/ddl/conversion/mysql/eval-1-3_to_eval-1-4.sql :

alter table EVAL_ASSIGN_GROUP add column AVAILABLE_EMAIL_SENT datetime 
DEFAULT NULL;
alter table EVAL_ASSIGN_GROUP add column REMINDER_EMAIL_SENT datetime 
DEFAULT NULL;
create index ASSIGN_USER_AES_IDX on EVAL_ASSIGN_USER (AVAILABLE_EMAIL_SENT);
create index ASSIGN_USER_RES_IDX on EVAL_ASSIGN_USER (REMINDER_EMAIL_SENT);

I think that these two indexes must be referred to EVAL_ASSIGN_GROUP and 
not to EVAL_ASSIGN_USER, as this second table is created in the previous 
script (eval-1-2_to_eval-1-3.sql) and AVAILABLE_EMAIL_SENT doesn't exist 
in it, neither REMINDER_EMAIL_SENT.

Hope it helps.
Best regards.
-- 
Daniel Merino Echeverría
daniel.merino at unavarra.es
Gestor de teleformación - Centro Superior de Innovación Educativa.
Tfno: 948-168489 - Universidad Pública de Navarra.


More information about the evaluation mailing list