Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on Apr 18th, 2012  |  syntax: None  |  size: 0.90 KB  |  hits: 7  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. MySQL Workbench, Newbie to DB, Constraint Problems - Error 1005, erno 121
  2. CONSTRAINT `dish_type`
  3.     FOREIGN KEY (`dish_type` )
  4.     REFERENCES `acs_operations_dev`.`dish_types` (`id` )
  5.     ON DELETE NO ACTION
  6.     ON UPDATE CASCADE,
  7.   CONSTRAINT `tech_number`
  8.     FOREIGN KEY (`tech_number` )
  9.     REFERENCES `acs_operations_dev`.`employees` (`tech_number` )
  10.     ON DELETE NO ACTION
  11.     ON UPDATE CASCADE)
  12.        
  13. PRIMARY KEY (`id`) ,
  14.   INDEX `tech_number` (`tech_number` ASC) ,
  15.   INDEX `car` (`car` ASC) ,
  16.   INDEX `field_dev_coach` (`field_dev_coach` ASC) ,
  17.   UNIQUE INDEX `etad_user_UNIQUE` (`etad_user` ASC) ,
  18.   CONSTRAINT `tech_number`
  19.     FOREIGN KEY (`tech_number` )
  20.     REFERENCES `acs_operations_dev`.`employees` (`tech_number` )
  21.     ON DELETE NO ACTION
  22.     ON UPDATE CASCADE,
  23.   CONSTRAINT `car`
  24.     FOREIGN KEY (`car` )
  25.     REFERENCES `acs_operations_dev`.`cars` (`id` )
  26.     ON DELETE NO ACTION
  27.     ON UPDATE CASCADE,
create a new version of this paste RAW Paste Data