Peter M. Groen / knowledgetree

role_allocations.sql 472 Bytes
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 
SET FOREIGN_KEY_CHECKS=0;

CREATE TABLE `role_allocations` (
  `id` int(11) NOT NULL default '0',
  `folder_id` int(11) NOT NULL default '0',
  `role_id` int(11) NOT NULL default '0',
  `permission_descriptor_id` int(11) NOT NULL default '0',
  UNIQUE KEY `id` (`id`),
  KEY `folder_id` (`folder_id`)
) TYPE=InnoDB ;

CREATE TABLE `zseq_role_allocations` (
  `id` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM ;


SET FOREIGN_KEY_CHECKS=1;