ALTER TABLE `achats` ADD `vol_planeur` INT NULL COMMENT 'Vol planeur',
ADD `vol_avion` INT NULL COMMENT 'Vol avion',
ADD `mvt_pompe` INT NULL COMMENT 'Livraison essence';

UPDATE `achats` 
SET `vol_avion`= `vol`-1000000
WHERE `vol` > "1000000";

UPDATE `achats` 
SET `vol_planeur`= `vol`
WHERE `vol` < "1000000";

ALTER TABLE `achats` DROP `vol`;

ALTER TABLE `volsa` ADD `vahdeb` DECIMAL( 4, 2 ) NULL COMMENT 'Heure de décollage',
ADD `vahfin` DECIMAL( 4, 2 ) NULL COMMENT 'Heure d''atterrissage';

--
-- Structure de la table `ticket_type`
--

CREATE TABLE IF NOT EXISTS `type_ticket` (
  `id` int NOT NULL COMMENT 'Identifiant',
  `nom` varchar(64) CHARACTER SET utf8 NOT NULL COMMENT 'Nom',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Type de tickets';

INSERT INTO `gvv2`.`type_ticket` (`id`, `nom`) VALUES ('0', 'Remorqué'), ('1', 'Treuillé'), ('2', 'Repas');

