Advertisement
Guest User

Untitled

a guest
Sep 26th, 2017
55
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.74 KB | None | 0 0
  1. | adels | CREATE TABLE `adels` (
  2. `name` varchar(255) NOT NULL,
  3. `description` varchar(255) NOT NULL,
  4. `main` varchar(255) DEFAULT NULL,
  5. PRIMARY KEY (`name`),
  6. KEY `main` (`main`),
  7. CONSTRAINT `adels_ibfk_1` FOREIGN KEY (`main`) REFERENCES `adels` (`name`) ON DELETE CASCADE ON UPDATE CASCADE
  8. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
  9.  
  10. perm_name, perm_desc, NULL
  11. role_name, role_desc, perm_name
  12.  
  13. perm_name2, perm_desc, NULL
  14. role_name, role_desc, perm_name2
  15.  
  16. UPDATE `adels` SET `name` = 'perm_name2' WHERE `adels`.`name` = 'perm_name'
  17.  
  18. #1451 - Cannot delete or update a parent row: a foreign key constraint fails (`full`.`adels`, CONSTRAINT `adels_ibfk_1` FOREIGN KEY (`main`) REFERENCES `adels` (`name`) ON DELETE CASCADE ON UPDATE CASCADE)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement