-- Rev number (Mandatory)
SET @revNum = 2000;
SET @issue = "issue-itdb";

START TRANSACTION;
-- ------------------------------------------------
-- Begin SQL
-- ------------------------------------------------
ALTER TABLE vz_cat_hebergement ADD IF NOT EXISTS libelle_it varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT '' NOT NULL;
ALTER TABLE vz_prestations ADD IF NOT EXISTS libelle_presta_it varchar(256) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT '' NULL AFTER libelle_presta_en;
ALTER TABLE vz_prestations ADD IF NOT EXISTS commentaire_presta_it text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL NULL AFTER commentaire_presta_en;
ALTER TABLE mf_countries ADD IF NOT EXISTS cn_short_it varchar(256) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL AFTER cn_short_en;

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

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