Steps to reproduce:
Do a upgrade from 1.5.0 to 1.6.0 with data in database
Seemes to work but error occurs
ERROR 1050 (42S01): Table 'mh_job_mh_service_registration' already exists
@Lukas, you wrote the update script. Can you have a look at this?
I don't think there is a problem in the script. The table has already been existing as the ERROR describes.
This can be the case if you used auto ddl in earlier times.
Or if you use the reqular ddl scripts which makes this a problem:
[lars@lkiesow]~/dev/opencast-matterhorn/docs/upgrade% grep -r mh_job_mh_service_registration *
1.3_to_1.4/mysql5.sql:CREATE TABLE mh_job_mh_service_registration (
1.3_to_1.4/mysql5.sql: CONSTRAINT `FK_mh_job_mh_service_registration_Job_id` FOREIGN KEY (`Job_id`) REFERENCES `mh_job` (`id`),
1.5_to_1.6/mysql5.sql:CREATE TABLE mh_job_mh_service_registration (
1.5_to_1.6/mysql5.sql: CONSTRAINT FK_mh_job_mh_service_registration_Job_id FOREIGN KEY (Job_id) REFERENCES mh_job (id) ON DELETE CASCADE,
Hi Lars the table mh_job_mh_service_registration has been removed in version 1.5 and added back in version 1.6. Therefore the update script itself is right, but the update script from 1.4 to 1.5 doesn't remove it. So I will add a check if table is already existing and only add it if not.
@Lars: I think you are the one to review. It is working now without errors. Nice.