Hi folks,

As we all know, our DDL scripts are completely broken at the moment.  To
fix this I've been working on MH-8335, which enables DDL script
generation with indexes.  I #propose that we add this to the 1.3 release
because it will fix the bad DDL scripts and hopefully solve the issue in
the long term.

This patch, unfortunately, still needs testing.  I can test on mysql,
but since I wrote it I'm unlikely to run into issues which others might
face.  Ideally we could get someone testing on each of the three major
databases:  mysql, postgres and oracle.  If you have a machine setup
with one or more of these databases and are willing to test please let
us know!

This patch will also be problematic for those hoping to migrate their
databases from 1.2 to 1.3.  Nearly all of the column names have changed,
and many have gotten bigger (none have gotten smaller).  This means that
there is a need for a migration script, or organizations adopting 1.3
must be prepared to drop their databases and restart.  Unfortunately we
do not have the manpower to get this kind of script done (see the very
delayed 1.3 release) so anyone who feels the need for this upgrade
script should be prepared to pitch in and help out!

Thanks,
G
_______________________________________________
Matterhorn-users mailing list
[email protected]
http://lists.opencastproject.org/mailman/listinfo/matterhorn-users

Reply via email to