n3ANZkjy

1CREATE  TABLE IF NOT EXISTS `kolos`.`klienci` (
2  `id` INT NOT NULL ,
3  `imie` VARCHAR(45) NULL ,
4  `nazwisko` VARCHAR(45) NULL ,
5  PRIMARY KEY (`id`) )
6ENGINE = InnoDB;
7
8CREATE  TABLE IF NOT EXISTS `kolos`.`hotele` (
9  `id` INT NOT NULL ,
10  `nazwa` VARCHAR(45) NULL ,
11  `adres` VARCHAR(45) NULL ,
12  PRIMARY KEY (`id`) )
13ENGINE = InnoDB;
14
15CREATE  TABLE IF NOT EXISTS `kolos`.`noclegi` (
16  `id_hot` INT NOT NULL ,
17  `id_kli` INT NOT NULL ,
18  `data_przyj` DATE NULL ,
19  `data_wyj` DATE NULL ,
20  PRIMARY KEY (`id_hot`, `id_kli`) ,
21  INDEX fk_noclegi_hotele (`id_hot` ASC) ,
22  INDEX fk_noclegi_klienci (`id_kli` ASC) ,
23  CONSTRAINT `fk_noclegi_hotele`
24    FOREIGN KEY (`id_hot` )
25    REFERENCES `kolos`.`hotele` (`id` )
26    ON DELETE NO ACTION
27    ON UPDATE NO ACTION,
28  CONSTRAINT `fk_noclegi_klienci`
29    FOREIGN KEY (`id_kli` )
30    REFERENCES `kolos`.`klienci` (`id` )
31    ON DELETE NO ACTION
32    ON UPDATE NO ACTION)
33ENGINE = InnoDB;