-- Rev number (Mandatory)
SET @revNum = 505;
SET @issue = "issue-31-en";

START TRANSACTION;
-- ------------------------------------------------
-- Begin SQL
-- ------------------------------------------------
-- COTE SITES WEB en SEULEMENT !!!!!
UPDATE vz_participant_resa SET assurance = "0" WHERE assurance = "-1";
UPDATE vz_participant_resa SET assurance = "0" WHERE assurance = "";
UPDATE vz_participant_resa SET assurance = "-1" WHERE assurance = "Non merci";
UPDATE vz_participant_resa SET assurance = "15" WHERE assurance = "Annulation_COV";
UPDATE vz_participant_resa SET assurance = "1" WHERE assurance = "Etendue";
UPDATE vz_participant_resa SET assurance = "14" WHERE assurance = "Multi_COV";
UPDATE vz_participant_resa SET assurance = "12" WHERE assurance = "Premium";
UPDATE vz_participant_resa SET assurance = "13" WHERE assurance = "Premium_CB";
UPDATE vz_participant_resa SET assurance = "16" WHERE assurance = "Rapatriement_COV";

ALTER TABLE vz_participant_resa MODIFY COLUMN assurance SMALLINT DEFAULT 0 NOT NULL;

-- ------------------------------------------------
-- End SQL
-- ------------------------------------------------

INSERT INTO `db_version` (`uid`, `major_version`, `minor_version`, `revision`, `Comment`, `date`)
 VALUES (NULL, '1', '1', @revNum, @issue, CURRENT_TIME());
COMMIT;
