1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
|
CREATE TABLE `demande_materiel` (
`id_demande_materiel` int(11) NOT NULL auto_increment,
`id_demandeur_materiel` int(11) NOT NULL default '0',
`id_beneficiaire_materiel` int(11) NOT NULL default '0',
`date_demande_materiel` date NOT NULL default '0000-00-00',
`date_statut_materiel` date default NULL,
`statut_materiel` int(11) default NULL,
`date_solde_materiel` date default NULL,
`objet_demande` longtext NOT NULL,
`lieu_utilisation` longtext NOT NULL,
`commentaire` longtext,
`id_type_materiel` varchar(11) NOT NULL default '0',
`id_materiel` int(11) default NULL,
`date_debut_reservation` date NOT NULL default '0000-00-00',
`creneau_debut_reservation` int(11) NOT NULL default '0',
`date_fin_reservation` date NOT NULL default '0000-00-00',
`creneau_fin_reservation` int(11) NOT NULL default '0',
`date_debut_demandeur` date NOT NULL default '0000-00-00',
`heure_debut_demandeur` time NOT NULL default '00:00:00',
`date_fin_demandeur` date NOT NULL default '0000-00-00',
`heure_fin_demandeur` time NOT NULL default '00:00:00',
`id_realisateur_materiel` int(11) default NULL,
`retour_materiel` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`id_demande_materiel`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
--
-- Contenu de la table `demande_materiel`
--
INSERT INTO `demande_materiel` (`id_demande_materiel`, `id_demandeur_materiel`, `id_beneficiaire_materiel`, `date_demande_materiel`, `date_statut_materiel`, `statut_materiel`, `date_solde_materiel`, `objet_demande`, `lieu_utilisation`, `commentaire`, `id_type_materiel`, `id_materiel`, `date_debut_reservation`, `creneau_debut_reservation`, `date_fin_reservation`, `creneau_fin_reservation`, `date_debut_demandeur`, `heure_debut_demandeur`, `date_fin_demandeur`, `heure_fin_demandeur`, `id_realisateur_materiel`, `retour_materiel`) VALUES (1, 51538488, 51538488, '2006-04-26', '2006-04-26', 2, NULL, 'grosse présentation...ça va être chaud', 'le stade de france', '', '25', 2, '2006-05-12', 2, '2006-05-16', 1, '2006-05-15', '08:00:00', '2006-05-15', '18:00:00', NULL, 0);
INSERT INTO `demande_materiel` (`id_demande_materiel`, `id_demandeur_materiel`, `id_beneficiaire_materiel`, `date_demande_materiel`, `date_statut_materiel`, `statut_materiel`, `date_solde_materiel`, `objet_demande`, `lieu_utilisation`, `commentaire`, `id_type_materiel`, `id_materiel`, `date_debut_reservation`, `creneau_debut_reservation`, `date_fin_reservation`, `creneau_fin_reservation`, `date_debut_demandeur`, `heure_debut_demandeur`, `date_fin_demandeur`, `heure_fin_demandeur`, `id_realisateur_materiel`, `retour_materiel`) VALUES (2, 51538488, 51538488, '2006-04-26', '2006-04-27', 1, '2006-04-27', 'vggggg', 'fggggggggggg', '', '25', 2, '2006-05-12', 2, '2006-05-12', 2, '2006-05-12', '15:00:00', '2006-05-12', '17:00:00', NULL, 0);
INSERT INTO `demande_materiel` (`id_demande_materiel`, `id_demandeur_materiel`, `id_beneficiaire_materiel`, `date_demande_materiel`, `date_statut_materiel`, `statut_materiel`, `date_solde_materiel`, `objet_demande`, `lieu_utilisation`, `commentaire`, `id_type_materiel`, `id_materiel`, `date_debut_reservation`, `creneau_debut_reservation`, `date_fin_reservation`, `creneau_fin_reservation`, `date_debut_demandeur`, `heure_debut_demandeur`, `date_fin_demandeur`, `heure_fin_demandeur`, `id_realisateur_materiel`, `retour_materiel`) VALUES (3, 51524494, 51524494, '2006-04-27', NULL, NULL, NULL, 'ffffffff', 'ffffffffffffffffffff', 'fffffff', '26', NULL, '2006-04-28', 1, '2006-05-01', 1, '2006-04-29', '10:10:00', '2006-04-30', '10:00:00', NULL, 0);
INSERT INTO `demande_materiel` (`id_demande_materiel`, `id_demandeur_materiel`, `id_beneficiaire_materiel`, `date_demande_materiel`, `date_statut_materiel`, `statut_materiel`, `date_solde_materiel`, `objet_demande`, `lieu_utilisation`, `commentaire`, `id_type_materiel`, `id_materiel`, `date_debut_reservation`, `creneau_debut_reservation`, `date_fin_reservation`, `creneau_fin_reservation`, `date_debut_demandeur`, `heure_debut_demandeur`, `date_fin_demandeur`, `heure_fin_demandeur`, `id_realisateur_materiel`, `retour_materiel`) VALUES (4, 51538488, 51538488, '2006-04-27', '2006-04-27', 2, NULL, 'bv', 'vchvc', 'vcbcvb', '32', 9, '2006-04-28', 1, '2006-05-01', 1, '2006-04-30', '10:00:00', '2006-04-30', '11:00:00', NULL, 0); |
Partager