Guest User

Untitled

a guest
Mar 31st, 2013
145
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 1.53 KB | None | 0 0
  1. 3   17:45:29    SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 0 row(s) affected
  2.  
  3. 3   17:45:29    SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0  0 row(s) affected
  4.  
  5. 3   17:45:29    SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL'    0 row(s) affected
  6.  
  7. 3   17:45:29    CREATE SCHEMA IF NOT EXISTS `lekarze` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci    1 row(s) affected
  8.  
  9. 3   17:45:29    USE `lekarze`   0 row(s) affected
  10.  
  11. 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
  12.  
  13. 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