-- Rev number (Mandatory)
SET @revNum = 507;
SET @issue = "modifs-add-assur-min-achat";

START TRANSACTION;
-- ------------------------------------------------
-- Begin SQL
-- ------------------------------------------------
ALTER TABLE vz_assurance_produits ADD
  `min_achat` FLOAT COMMENT 'EURO, minimum prix d achat' AFTER taux_achat;


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

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