3PLpjsnJ

1CREATE 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	
48UPDATE `LISTE_PROMOTION` SET `etat_promo` = 'T' WHERE `id_list_prom` = 9460;