Forum Debian Users Gang

CREATE TABLE `acl_action` (
  `id_action` mediumint(8) unsigned NOT NULL auto_increment,
  `id_module` smallint(4) unsigned NOT NULL,
  `action` varchar(32) NOT NULL,
  `inherited` tinyint(1) NOT NULL,
  PRIMARY KEY  (`id_action`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- 
-- Struktura tabeli dla  `acl_resources`
-- 

CREATE TABLE `acl_resources` (
  `id_action` mediumint(8) unsigned NOT NULL auto_increment,    -- edit 
  `id_module` smallint(4) unsigned NOT NULL,                    -- post
  `id_resource` int(10) NOT NULL,                                -- id = 10
  `allow` tinyint(1) NOT NULL,
  PRIMARY KEY  (`id_action`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- 
-- Struktura tabeli dla  `acl_module`
-- 

CREATE TABLE `acl_module` (
  `id_module` smallint(4) unsigned NOT NULL auto_increment,
  `module` varchar(32) NOT NULL,
  PRIMARY KEY  (`id_module`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- 
-- Struktura tabeli dla  `acl_roles`
-- 

CREATE TABLE `acl_roles` (
  `id_group` int(10) unsigned NOT NULL,
  `id_module` smallint(4) unsigned NOT NULL,
  `id_action` mediumint(8) unsigned NOT NULL,
  `allow` tinyint(1) NOT NULL,
  PRIMARY KEY  (`id_group`,`id_module`,`id_action`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



SELECT allow, m.module , a.action 
FROM acl_roles r 

LEFT JOIN acl_module m ON ( r.id_module = m.id_module ) 
LEFT JOIN acl_action a ON ( r.id_action = a.id_action ) 
LEFT JOIN users u ON ( r.id_group = u.group_id ) 
WHERE u.id = 2 
AND m.module = 'admin' 
AND a.action = 'page'