3bn9E8xg

1CREATE TABLE IF NOT EXISTS `GGC`.`User` (
2  `IdUser` INT NOT NULL,
3  `LibUser` VARCHAR(50) NULL,
4  PRIMARY KEY (`IdUser`))
5ENGINE = InnoDB;
6
7CREATE TABLE IF NOT EXISTS `GGC`.`Caisse` (
8  `IdCais` INT NOT NULL AUTO_INCREMENT,
9  `LibCais` VARCHAR(50) NULL,
10  `RefCais` VARCHAR(50) NULL,
11  `MontantCais` FLOAT NULL,
12  `IdUser` INT NOT NULL,
13  PRIMARY KEY (`IdCais`),
14  INDEX `fk_Caisse_User1_idx` (`IdUser` ASC),
15  CONSTRAINT `fk_Caisse_User1`
16    FOREIGN KEY (`IdUser`)
17    REFERENCES `GGC`.`User` (`IdUser`))
18ENGINE = InnoDB;