SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;

SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;

SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';



CREATE SCHEMA IF NOT EXISTS `lekarze` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;

USE `lekarze` ;



-- -----------------------------------------------------

-- Table `lekarze`.`visits`

-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `lekarze`.`visits` (

  `idvisits` INT NOT NULL ,

  `idpatients` VARCHAR(45) NOT NULL ,

  `iddoctor` VARCHAR(45) NOT NULL ,

  `date` VARCHAR(45) NOT NULL ,

  `comments` VARCHAR(45) NULL DEFAULT 'Brak' ,

  PRIMARY KEY (`idvisits`) )

ENGINE = InnoDB;





-- -----------------------------------------------------

-- Table `lekarze`.`patients`

-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `lekarze`.`patients` (

  `idpatients` VARCHAR(45) NOT NULL ,

  `name` VARCHAR(45) NOT NULL ,

  `surname` VARCHAR(45) NOT NULL ,

  `date` DATE NOT NULL ,

  `photo` VARCHAR(45) NULL ,

  PRIMARY KEY (`idpatients`) ,

  CONSTRAINT `fk_patients_visits1`

    FOREIGN KEY (`idpatients` )

    REFERENCES `lekarze`.`visits` (`idpatients` )

    ON DELETE NO ACTION

    ON UPDATE NO ACTION)

ENGINE = InnoDB;





-- -----------------------------------------------------

-- Table `lekarze`.`doctor`

-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `lekarze`.`doctor` (

  `iddoctor` INT NOT NULL ,

  `name` VARCHAR(45) NULL ,

  `surname` VARCHAR(45) NULL ,

  `photo` VARCHAR(45) NULL ,

  `date` DATE NULL ,

  PRIMARY KEY (`iddoctor`) ,

  CONSTRAINT `fk_doctor_visits1`

    FOREIGN KEY (`iddoctor` )

    REFERENCES `lekarze`.`visits` (`iddoctor` )

    ON DELETE NO ACTION

    ON UPDATE NO ACTION)

ENGINE = InnoDB;







SET SQL_MODE=@OLD_SQL_MODE;

SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;

SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;