--  BIP V3 - V3.31 --
--

-- Version du serveur: 5.6.12-log
-- Version de PHP: 5.4.12

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

--
-- TICKET
--
ALTER TABLE  `ticket` CHANGE  `commentaire_facturation`  `observation_facturation` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ;

ALTER TABLE  `rel_ticket_materiel` CHANGE  `p_vente`  `p_vente` DECIMAL( 10, 5 ) NOT NULL DEFAULT  '0';

ALTER TABLE  `rel_ticket_materiel` ADD  `reference_libre` varchar(255) NOT NULL AFTER  `fk_materiel` ;
ALTER TABLE  `rel_ticket_materiel` ADD  `designation` varchar(255) DEFAULT NULL AFTER  `reference_libre` ;
ALTER TABLE  `rel_ticket_materiel` ADD  `p_achat` decimal(10,5) NOT NULL DEFAULT '0.00000' AFTER  `quantite` ;

ALTER TABLE  `ticket` CHANGE  `inter_fk_pays`  `inter_fk_pays` INT( 11 ) UNSIGNED NULL DEFAULT  '0';
