Uploaded image for project: 'Opencast'
  1. MH-9561

Definition for mh_job_mh_service_registration missing in DDL script

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Blocker
    • Resolution: Fixed and reviewed
    • Affects versions: 1.4.0
    • Fix versions: 1.4.0
    • Components: Backend Software
    • Labels:
      None
    • Severity:
      Incorrectly Functioning With Workaround
    • Steps to reproduce:
      Hide
      Startign up with an empty database leads to the following table being created:

      mh_job_mh_service_registration

      CREATE TABLE `mh_job_mh_service_registration` (
        `Job_id` bigint(20) NOT NULL,
        `servicesRegistration_id` bigint(20) NOT NULL,
        PRIMARY KEY (`Job_id`,`servicesRegistration_id`),
        KEY `mhjobmhservice_registrationservicesRegistration_id` (`servicesRegistration_id`),
        CONSTRAINT `FK_mh_job_mh_service_registration_Job_id` FOREIGN KEY (`Job_id`) REFERENCES `mh_job` (`id`),
        CONSTRAINT `mhjobmhservice_registrationservicesRegistration_id` FOREIGN KEY (`servicesRegistration_id`) REFERENCES `mh_service_registration` (`id`)
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8

      The table is not in scripts/ddl in trunk or the 1.4 branch so is created without indexes on mysql
      Show
      Startign up with an empty database leads to the following table being created: mh_job_mh_service_registration CREATE TABLE `mh_job_mh_service_registration` (   `Job_id` bigint(20) NOT NULL,   `servicesRegistration_id` bigint(20) NOT NULL,   PRIMARY KEY (`Job_id`,`servicesRegistration_id`),   KEY `mhjobmhservice_registrationservicesRegistration_id` (`servicesRegistration_id`),   CONSTRAINT `FK_mh_job_mh_service_registration_Job_id` FOREIGN KEY (`Job_id`) REFERENCES `mh_job` (`id`),   CONSTRAINT `mhjobmhservice_registrationservicesRegistration_id` FOREIGN KEY (`servicesRegistration_id`) REFERENCES `mh_service_registration` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 The table is not in scripts/ddl in trunk or the 1.4 branch so is created without indexes on mysql

      TestRail: Results

        Attachments

          Issue links

            Activity

              People

              • Assignee:
                dhorwitz David Horwitz
                Reporter:
                dhorwitz David Horwitz
              • Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  TestRail: Cases