Author Topic: Plugin roles_permissions sql import: Error #1005  (Read 4673 times)

Offline #1005

  • Newbie
  • *
  • Posts: 8
Plugin roles_permissions sql import: Error #1005
« on: October 30, 2013, 09:11:41 AM »
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:
   
:
Code: [Select]
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:
Code: [Select]
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

Offline #1005

  • Newbie
  • *
  • Posts: 8