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
| CREATE TABLE `report_tete` (
`id_report` smallint(5) unsigned NOT NULL auto_increment,
`id_util` tinyint(3) unsigned NOT NULL default '0',
`id_mag` smallint(5) unsigned NOT NULL default '0',
`date_visite` date NOT NULL default '0000-00-00',
`semaine` tinyint(3) unsigned NOT NULL default '0',
`date_saisie` date NOT NULL default '0000-00-00',
`heure_saisie` time NOT NULL default '00:00:00',
`etat` char(1) NOT NULL default '',
PRIMARY KEY (`id_report`),
KEY `id_util` (`id_util`),
KEY `id_mag` (`id_mag`),
KEY `etat` (`etat`),
KEY `date_visite` (`date_visite`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1909 ;
--
-- Contenu de la table `report_tete`
--
INSERT INTO `report_tete` VALUES (1, 6, 509, '2008-05-26', 22, '2008-05-26', '18:20:48', 'C');
INSERT INTO `report_tete` VALUES (3, 6, 1147, '2008-05-26', 22, '2008-05-26', '18:49:11', 'D');
INSERT INTO `report_tete` VALUES (4, 6, 508, '2008-05-26', 22, '2008-05-26', '19:15:00', 'C');
INSERT INTO `report_tete` VALUES (5, 6, 1146, '2008-05-26', 22, '2008-05-26', '19:39:10', 'C');
INSERT INTO `report_tete` VALUES (6, 6, 734, '2008-05-26', 22, '2008-05-26', '19:48:34', 'C');
INSERT INTO `report_tete` VALUES (7, 4, 451, '2008-05-26', 22, '2008-05-26', '20:18:28', 'D');
INSERT INTO `report_tete` VALUES (8, 4, 1981, '2008-05-26', 22, '2008-05-26', '21:01:10', 'D');
INSERT INTO `report_tete` VALUES (9, 4, 450, '2008-05-26', 22, '2008-05-26', '21:21:14', 'D');
INSERT INTO `report_tete` VALUES (10, 4, 1064, '2008-05-26', 22, '2008-05-26', '21:43:37', 'D');
INSERT INTO `report_tete` VALUES (11, 4, 845, '2008-05-26', 22, '2008-05-26', '22:15:15', 'D'); |
Partager