Guest User

Untitled

a guest
Jun 20th, 2018
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.75 KB | None | 0 0
  1. CREATE TABLE IF NOT EXISTS `LISTE_PROMOTION3` (
  2. `id_list_prom` int(11) NOT NULL AUTO_INCREMENT,
  3. `id_hotel` int(11) NOT NULL,
  4. `id_marche` int(11) NOT NULL,
  5. `lib_promo` varchar(250) NOT NULL,
  6. `etat_promo` enum('T','F') NOT NULL DEFAULT 'T',
  7. `type_promo` varchar(250) NOT NULL,
  8. `debut_vente` date NOT NULL,
  9. `fin_vente` date NOT NULL,
  10. `debut_sejour` date NOT NULL,
  11. `fin_sejour` date NOT NULL,
  12. `min_sty` int(11) NOT NULL,
  13. `max_sty` int(11) NOT NULL,
  14. `free_night` int(11) NOT NULL,
  15. `type_free_night` varchar(250) NOT NULL,
  16. `priorite_promo` int(11) NOT NULL,
  17. `typ_prom` varchar(250) NOT NULL,
  18. `pourcent_red_lpd` float NOT NULL,
  19. `pourcent_red_dp` float NOT NULL,
  20. `pourcent_red_dpplus` float NOT NULL,
  21. `pourcent_red_pc` float NOT NULL,
  22. `pourcent_red_pcplus` float NOT NULL,
  23. `pourcent_red_aisoft` float NOT NULL,
  24. `pourcent_red_allin` float NOT NULL,
  25. `pourcent_red_ultraai` float NOT NULL,
  26. `montant_red_lpd` float NOT NULL,
  27. `montant_red_dp` float NOT NULL,
  28. `montant_red_dpplus` float NOT NULL,
  29. `montant_red_pc` float NOT NULL,
  30. `montant_red_pcplus` float NOT NULL,
  31. `montant_red_aisoft` float NOT NULL,
  32. `montant_red_allin` float NOT NULL,
  33. `montant_red_ultraai` float NOT NULL,
  34. `id_agent` int(11) NOT NULL,
  35. `date_insertion` datetime NOT NULL,
  36. `date_modif` datetime NOT NULL,
  37. `id_agent_modif` int(11) NOT NULL,
  38. `typ_app_prom` varchar(250) NOT NULL,
  39. `sur_tarif` varchar(250) NOT NULL,
  40. `pourcent_red_ls` float NOT NULL,
  41. `montant_red_ls` float NOT NULL,
  42. PRIMARY KEY (`id_list_prom`),
  43. KEY `id_hotel` (`id_hotel`),
  44. KEY `etat_promo` (`etat_promo`),
  45. KEY `fin_vente` (`fin_vente`)
  46. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=9480 ;
  47.  
  48. UPDATE `LISTE_PROMOTION` SET `etat_promo` = 'T' WHERE `id_list_prom` = 9460;
Add Comment
Please, Sign In to add comment