· 6 years ago · Jan 31, 2020, 01:40 PM
1CREATE TABLE IF NOT EXISTS `entree` (
2 `Date` varchar(20) NOT NULL,
3 `Incident` varchar(10) NOT NULL,
4 `Horaire` varchar(10) NOT NULL,
5 `Materiel` varchar(1000) NOT NULL,
6 `Matricule` varchar(11) NOT NULL,
7 `Etat` varchar(30) NOT NULL,
8 `Trigramme` varchar(10) NOT NULL,
9 `Commentaire` varchar(1000) NOT NULL,
10 `Repentree` int(11) NOT NULL auto_increment,
11 `Statut` varchar(20) NOT NULL,
12 PRIMARY KEY (`Repentree`)
13) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=0 ;
14
15--
16-- Contenu de la table `entree`
17--
18
19INSERT IGNORE INTO `entree` (`Date`, `Incident`, `Materiel`, `Etat`, `Trigramme`, `Commentaire`, `Repentree`, `Statut`) VALUES
20('29/03/2018 13:50', '537368', ' DELL 360 - 2009/000948 ', 'Spare', 'ADA', '', 20780, 'Traité;'),
21('29/03/2018 15:03', '537569', ' LEXMARK MX410 - 2015/001576 ', 'Spare', 'LAS', '', 20781, 'Traité;'),