Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- | adels | CREATE TABLE `adels` (
- `name` varchar(255) NOT NULL,
- `description` varchar(255) NOT NULL,
- `main` varchar(255) DEFAULT NULL,
- PRIMARY KEY (`name`),
- KEY `main` (`main`),
- CONSTRAINT `adels_ibfk_1` FOREIGN KEY (`main`) REFERENCES `adels` (`name`) ON DELETE CASCADE ON UPDATE CASCADE
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
- perm_name, perm_desc, NULL
- role_name, role_desc, perm_name
- perm_name2, perm_desc, NULL
- role_name, role_desc, perm_name2
- UPDATE `adels` SET `name` = 'perm_name2' WHERE `adels`.`name` = 'perm_name'
- #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