1 2 3 4 5 6 7 8 9 10 11 12
| CREATE TABLE `reservation` (
`id_reservation` int(11) NOT NULL auto_increment,
`id_ressource` int(11) NOT NULL default '0',
`id_typeress` int(11) NOT NULL default '0',
`id_util` varchar(20) NOT NULL default '',
`debut_reservation` datetime NOT NULL default '0000-00-00 00:00:00',
`fin_reservation` datetime NOT NULL default '0000-00-00 00:00:00',
`com1_reservation` text,
`com2_reservation` text,
`statut_reservation` char(1) NOT NULL default 'A',
PRIMARY KEY (`id_reservation`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=23 ; |
Partager