alter table `OUTBOUND_MOBILITY_CANDIDACY_SUBMISSION` add `CONFIRMED_PLACEMENT` tinyint(1);
create table `OUTBOUND_MOBILITY_CANDIDACY_PERIOD_CONFIRMATION_OPTION` (`OID` bigint unsigned, `OPTION_VALUE` text, `OID_ROOT_DOMAIN_OBJECT` bigint unsigned, `OID_OUTBOUND_MOBILITY_CANDIDACY_PERIOD` bigint unsigned, `ID_INTERNAL` int(11) NOT NULL auto_increment, primary key (ID_INTERNAL), index (OID), index (OID_ROOT_DOMAIN_OBJECT), index (OID_OUTBOUND_MOBILITY_CANDIDACY_PERIOD)) ENGINE=InnoDB, character set utf8;
create table `CONTEST_GROUP_PERIOD_SELECTION_RESULT_NOTIFICATION` (`OID_OUTBOUND_MOBILITY_CANDIDACY_CONTEST_GROUP` bigint unsigned, `OID_OUTBOUND_MOBILITY_CANDIDACY_PERIOD` bigint unsigned, primary key (OID_OUTBOUND_MOBILITY_CANDIDACY_CONTEST_GROUP, OID_OUTBOUND_MOBILITY_CANDIDACY_PERIOD), index (OID_OUTBOUND_MOBILITY_CANDIDACY_CONTEST_GROUP), index (OID_OUTBOUND_MOBILITY_CANDIDACY_PERIOD)) ENGINE=InnoDB, character set utf8;
create table `CONTEST_GROUP_PERIOD_CANDIDACY_SELECTION_CONCLUSION` (`OID_OUTBOUND_MOBILITY_CANDIDACY_CONTEST_GROUP` bigint unsigned, `OID_OUTBOUND_MOBILITY_CANDIDACY_PERIOD` bigint unsigned, primary key (OID_OUTBOUND_MOBILITY_CANDIDACY_CONTEST_GROUP, OID_OUTBOUND_MOBILITY_CANDIDACY_PERIOD), index (OID_OUTBOUND_MOBILITY_CANDIDACY_CONTEST_GROUP), index (OID_OUTBOUND_MOBILITY_CANDIDACY_PERIOD)) ENGINE=InnoDB, character set utf8;
alter table `CANDIDACY_PERIOD` add `OPTION_INTRODUCTORY_DESTRIPTION` text;
alter table `OUTBOUND_MOBILITY_CANDIDACY_SUBMISSION` add `OID_CONFIRMATION_OPTION` bigint unsigned, add index (OID_CONFIRMATION_OPTION);
