-- Rev number (Mandatory)
SET @revNum = 509;
SET @issue = "issue-32";

START TRANSACTION;
-- ------------------------------------------------
-- Begin SQL
-- ------------------------------------------------
ALTER TABLE vz_orders_resa MODIFY COLUMN supp_titres text CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '';
ALTER TABLE vz_orders_resa MODIFY COLUMN supp_prix text CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '';
ALTER TABLE vz_orders_resa MODIFY COLUMN supp_unites text CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '';
ALTER TABLE vz_orders_resa MODIFY COLUMN supp_totaux text CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '';
ALTER TABLE vz_orders_resa MODIFY COLUMN MAC_r_acompte varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' NOT NULL;
ALTER TABLE vz_orders_resa MODIFY COLUMN MAC_r_solde varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' NOT NULL;
ALTER TABLE vz_orders_resa MODIFY COLUMN prix_unit decimal(11,2) DEFAULT 0.00 NULL;

ALTER TABLE vz_participant_resa
  ADD IF NOT EXISTS question_rp TEXT NOT NULL DEFAULT '',
  ADD IF NOT EXISTS question_rh TEXT NOT NULL DEFAULT '',
  ADD IF NOT EXISTS question_sf TEXT NOT NULL DEFAULT '';

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

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