view release on metacpan or  search on metacpan

Changes  view on Meta::CPAN

0.19

* Added a facility for managing which roles can manage other roles.  This allows users to 
  manage roles without needing to have them assigned.  See bug 235 for more details.
  Two new tables have been added to support this facility.  The need to be added to your
  appkit auth schema.

  CREATE TABLE roles_allowed 
  (
      role integer not null references role(id) on delete cascade, 
      role_allowed integer not null references role(id) on delete cascade, 
      primary key (role, role_allowed)
  );
  CREATE TABLE role_admin
  (
      role_id integer not null references role(id) on delete cascade, 
      primary key(role_id)
  );


0.18

* Changed submit button to say save on user roles saving.
* Added a not_found action for producing a 404 because default isn't terribly logical.

0.17

lib/auto/OpusVL/AppKit/root/db/appkit_auth.sql  view on Meta::CPAN

    PRIMARY KEY (users_id, parameter_id)
);
CREATE TABLE aclrule_role (
        aclrule_id          INTEGER     NOT NULL REFERENCES aclrule(id) ON DELETE CASCADE ON UPDATE CASCADE,
        role_id             INTEGER     NOT NULL REFERENCES role(id) ON DELETE CASCADE ON UPDATE CASCADE,
    PRIMARY KEY (aclrule_id, role_id)
);

CREATE TABLE roles_allowed 
(
  role integer not null references role(id) on delete cascade, 
  role_allowed integer not null references role(id) on delete cascade, 
  primary key (role, role_allowed)
);
CREATE TABLE role_admin
(
  role_id integer not null references role(id) on delete cascade, 
  primary key(role_id)
);

CREATE TABLE "aclfeature" (
  "id" serial NOT NULL,
  "feature" text NOT NULL,
  PRIMARY KEY ("id")
);

CREATE TABLE "aclfeature_role" (