schema change - admissions

[David Burke]

Changed FK to M2M

CREATE TABLE `admissions_applicationdecisionoption_level` (

    `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,

    `applicationdecisionoption_id` integer NOT NULL,

    `admissionlevel_id` integer NOT NULL,

    UNIQUE (`applicationdecisionoption_id`, `admissionlevel_id`)

)

;

insert into admissions_applicationdecisionoption_level (applicationdecisionoption_id, admissionlevel_id) select id, level_id from admissions_applicationdecisionoption where level_id is not null;