1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
| DROP TABLE IF EXISTS `bord`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `bord` (
`bo_code_pk` int(11) NOT NULL auto_increment,
`bo_numero` int(11) default NULL,
`bo_mode` enum('ESP','CHQ','MAN','VIR') NOT NULL,
`bo_montant` decimal(11,3) NOT NULL default '0.000',
`bo_dateval` date default NULL,
`bo_remise` date default NULL,
`bo_annee` date NOT NULL,
`bo_user_fk` int(11) NOT NULL,
`bo_created` date default NULL,
`bo_updated` date default NULL,
PRIMARY KEY (`bo_code_pk`),
KEY `index_bord_user_fk` USING BTREE (`bo_user_fk`),
CONSTRAINT `bord_user_fk` FOREIGN KEY (`bo_user_fk`) REFERENCES `utilisateur` (`UT_CODE_PK`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=100009 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client; |
Partager