INSERT INTO `prestations` (`prestation`)
VALUES ('Vente de pellet');


INSERT INTO `prestations_tarif` (`id_tarif`, `id_prestation_fk`, `designation`, `prix`, `promo`, `prix_promo`, `commentaire`, `commentaire_promo`, `extra`) VALUES
(18, 6, 'Vente de pellet', '322', 0, NULL, '<div class=\"row text-center\">\r\n\r\n            <div class=\"col-lg-6 col-md-6 col-sm-6\">\r\n                <h2><i class=\"fa fa-euro\"></i> Offre tarifaire</h2>\r\n                <hr>\r\n                <div class=\"well\">\r\n                <p><strong>332,10€ TTC la tonne livrée</strong>.</p>\r\n                <p>Une palette de 70 sacs, soit 1 tonne et (50 kg OFFERT).</p>\r\n                </div>\r\n            </div>\r\n\r\n            <div class=\"col-lg-6 col-md-6 col-sm-6\">\r\n              <h2><i class=\"fa fa-truck\"></i> Livraison</h2>\r\n              <hr>\r\n              <div class=\"well\">\r\n              <p>Nous livrons <u>uniquement</u> dans le 59 et 62.</p>\r\n              <p><strong>Paiement à la livraison</strong>.</p>\r\n            </div>\r\n           </div>\r\n\r\n</div>', NULL, 0);


-- Ajout d'un champ email dans la table prestations_tarif
ALTER TABLE `prestations_tarif` ADD `email` VARCHAR(80) NULL DEFAULT 'pge59000@gmail.com' AFTER `extra`;
