alter table `PAYMENT_CODE` add `OID_PERIOD` bigint unsigned, add index (OID_PERIOD);


-- Inserted at 2011-01-04T11:01:23.719Z

alter table `PARTY` add `FIRST_LANGUAGE` text;



-- Inserted at 2011-01-04T12:06:14.557Z

alter table `CANDIDACY` add `USER_GAVE_REFERENCES` tinyint(1);


-- Inserted at 2011-01-04T12:45:46.524Z

alter table `CANDIDATE_REGISTRATION_EMAIL_TEMPLATES` add `EMAIL_SUBJECT_WITH_PAYMENT_CODES` text, add `EMAIL_BODY_WITH_PAYMENT_CODES` text;


-- Inserted at 2011-01-04T16:16:30.547Z

alter table `QUALIFICATION` add `OBSERVATION` text;


-- Inserted at 2011-01-05T13:13:32.778Z

alter table `CANDIDACY` add `OID_JOB_CONTEXT` bigint unsigned;
alter table `GENERIC_FILE` add `OID_POOL` bigint unsigned, add index (OID_POOL);
