Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 3 17:45:29 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 0 row(s) affected
- 3 17:45:29 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 0 row(s) affected
- 3 17:45:29 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL' 0 row(s) affected
- 3 17:45:29 CREATE SCHEMA IF NOT EXISTS `lekarze` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci 1 row(s) affected
- 3 17:45:29 USE `lekarze` 0 row(s) affected
- 3 17:45:29 -- ----------------------------------------------------- -- 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 0 row(s) affected
- 0 17:45:30 -- ----------------------------------------------------- -- 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 Error Code: 1005. Can't create table 'lekarze.patients' (errno: 150)
Advertisement
Add Comment
Please, Sign In to add comment