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 34 35 36 37 38 39
| CREATE TABLE IF NOT EXISTS `entreestock` (
`NUM_LIGNEBLF` int(11) NOT NULL AUTO_INCREMENT,
`CODE_PROD` varchar(25) NOT NULL,
`CODE_LIVRF` varchar(11) NOT NULL,
`QTE_RECUE` int(4) NOT NULL,
`SN_PRODESTOCK` varchar(25) NOT NULL,
`lot` int(11) NOT NULL,
PRIMARY KEY (`NUM_LIGNEBLF`),
KEY `UNELIGNEPARPRODUITLIVRPARFR_FK` (`CODE_PROD`),
KEY `LIVRFRCPORTEPLRSLIGNES_FK` (`CODE_LIVRF`),
KEY `CODE_LIVRF` (`lot`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7;
INSERT INTO `entreestock` (`NUM_LIGNEBLF`, `CODE_PROD`, `CODE_LIVRF`, `QTE_RECUE`, `SN_PRODESTOCK`, `lot`) VALUES
(1, 'hp49A', 'BLF131001', 10, ' ', 1001),
(2, 'HP121N', 'BLF131001', 14, ' ', 1001),
(3, 'HP121N', 'BLF131002', 6, ' ', 1002),
(4, 'hp1000', 'BLF131002', 2, 'SN1000/1001', 1002),
(5, 'hp49A', 'BLF131002', 3, ' ', 1002);
CREATE TABLE IF NOT EXISTS `sortiestock` (
`NUM_LIGNEBLC` int(9) NOT NULL AUTO_INCREMENT,
`CODE_PROD` varchar(25) NOT NULL,
`CODE_BLCLIENT` varchar(11) NOT NULL,
`QTE_LIVREE` int(4) NOT NULL,
`SN_ARTICLE` char(25) DEFAULT NULL,
`LOT` int(11) NOT NULL,
PRIMARY KEY (`NUM_LIGNEBLC`),
KEY `UNELIGNEPARPRODUITLIVRECL_FK` (`CODE_PROD`),
KEY `LIVRCLIENTCPORTEPLRSLIGNES_FK` (`CODE_BLCLIENT`),
KEY `LOT` (`LOT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
INSERT INTO `sortiestock` (`NUM_LIGNEBLC`, `CODE_PROD`, `CODE_BLCLIENT`, `QTE_LIVREE`, `SN_ARTICLE`, `LOT`) VALUES
(1, 'hp49A', 'BLC131001', 2, '', 1001);
ALTER TABLE `sortiestock`
ADD CONSTRAINT `sortiestock_ibfk_12` FOREIGN KEY (`CODE_BLCLIENT`) REFERENCES `livraisonclient` (`CODE_BLCLIENT`) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT `sortiestock_ibfk_13` FOREIGN KEY (`LOT`) REFERENCES `entreestock` (`lot`); |
Partager