CREATE TABLE `acl_role` (
  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(32) NOT NULL DEFAULT '',
  `desc` VARCHAR(255),
  PRIMARY KEY ('id')
) ENGINE=InnoDB;

CREATE TABLE `acl_group` (
  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(32) NOT NULL DEFAULT '',
  `desc` VARCHAR(255),
  PRIMARY KEY ('id')
) ENGINE=InnoDB;

CREATE TABLE `acl_role_group` (
  `role_id` INT UNSIGNED NOT NULL,
  `group_id` INT UNSIGNED NOT NULL,
  UNIQUE KEY 'role_group_idx' ('role_id', 'group_id')
) ENGINE=InnoDB;

CREATE TABLE `acl_user_group` (
  `group_id` INT UNSIGNED NOT NULL,
  `role_id` INT UNSIGNED NOT NULL,
  UNIQUE KEY 'user_group_idx' ('group_id', 'role_id') 
) ENGINE=InnoDB;