9tWK7Y9V

1
2CREATE TABLE IF NOT EXISTS `stock_fa` (
3  `idstock_fa` int(11) NOT NULL AUTO_INCREMENT,
4  `d_min` int(11) NOT NULL DEFAULT '0',
5  `d_moy` int(11) NOT NULL DEFAULT '0',
6  `d_max` int(11) NOT NULL DEFAULT '0',
7  `pos_h` int(11) NOT NULL DEFAULT '0',
8  `pos_z` int(11) NOT NULL DEFAULT '0',
9  `date_entre` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
10  `date_sortie` timestamp NULL DEFAULT NULL,
11  `etat` varchar(10) NOT NULL DEFAULT 'OK',
12  `lot` varchar(45) DEFAULT NULL,
13  `peremption` timestamp NULL DEFAULT NULL,
14  `is_mal_introduit` tinyint(1) NOT NULL DEFAULT '0',
15  `last_pos_known` varchar(45) DEFAULT NULL,
16  `ididentifiant` int(11) DEFAULT NULL,
17  `idrail_virtuel` int(11) DEFAULT NULL,
18  `idtapis` int(11) DEFAULT NULL,
19  `idrebut` int(11) DEFAULT NULL,
20  `idprehenseur` int(11) DEFAULT NULL,
21  `idrail` char(7) DEFAULT NULL,
22  PRIMARY KEY (`idstock_fa`),
23  KEY `fk_stock_fa_rail_virtuel1_idx` (`idrail_virtuel`),
24  KEY `fk_stock_fa_tapis1_idx` (`idtapis`),
25  KEY `fk_stock_fa_rebut1_idx` (`idrebut`),
26  KEY `fk_stock_fa_table11_idx` (`idprehenseur`),
27  KEY `fk_stock_fa_rail1_idx` (`idrail`),
28  KEY `fk_stock_fa_identifiant1_idx` (`ididentifiant`)
29) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=72439 ;