Hey,
I want to install the plugin roles_permissions:
Also I have download it from:
http://sourceforge.net/projects/rolespermission/ and it copy to /plugins in RoundCube.
Than I have try to import mysql.initial.sql to the DB over phpmyadmin. The Error:
:
SQL query:
ALTER TABLE `role_users` ADD CONSTRAINT `role_users_ibfk_2` FOREIGN KEY ( `role_id` ) REFERENCES `roles` ( `role_id` ) ON DELETE CASCADE ON UPDATE CASCADE
MySQL said: Documentation
#1005 - Can't create table 'db*******.#sql-2b41_**af6' (errno: 150)
The mysql.initial.sql File:
CREATE TABLE IF NOT EXISTS `roles` (
`role_id` int(11) NOT NULL auto_increment,
`name` text,
PRIMARY KEY (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `permissions` (
`permission_id` int(11) NOT NULL auto_increment,
`code` text,
`name` text,
PRIMARY KEY (`permission_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `role_users` (
`role_user_id` int(11) NOT NULL auto_increment,
`user_id` int(10) unsigned NOT NULL,
`role_id` int(10) unsigned NOT NULL,
PRIMARY KEY (`role_user_id`),
KEY `user_id` (`user_id`),
KEY `role_id` (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Constraints for table `role_users`
--
ALTER TABLE `role_users`
ADD CONSTRAINT `role_users_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE `role_users`
ADD CONSTRAINT `role_users_ibfk_2` FOREIGN KEY (`role_id`) REFERENCES `roles` (`role_id`) ON DELETE CASCADE ON UPDATE CASCADE;
CREATE TABLE IF NOT EXISTS `role_permissions` (
`role_permission_id` int(11) NOT NULL auto_increment,
`permission_id` int(10) unsigned NOT NULL,
`role_id` int(10) unsigned NOT NULL,
PRIMARY KEY (`role_permission_id`),
KEY `permission_id` (`permission_id`),
KEY `role_id` (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Constraints for table `role_permissions`
--
ALTER TABLE `role_permissions`
ADD CONSTRAINT `role_permissions_ibfk_1` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`permission_id`) ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE `role_permissions`
ADD CONSTRAINT `role_permissions_ibfk_2` FOREIGN KEY (`role_id`) REFERENCES `roles` (`role_id`) ON DELETE CASCADE ON UPDATE CASCADE;
Cheers #1005