[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