X-Git-Url: https://git.sesse.net/?p=itkacl;a=blobdiff_plain;f=itkacl-2.0%2Fitkacl.sql;fp=itkacl-2.0%2Fitkacl.sql;h=92b559cf86e99caa88f886b56d074b87a1ecc30c;hp=eb38f8750b573d32fbb94885b24b2b658593b42c;hb=b9014762b8051b457c68d8de11a08d64401026fa;hpb=5a4ae0a37159e6af798d19800681f78872fb65a0 diff --git a/itkacl-2.0/itkacl.sql b/itkacl-2.0/itkacl.sql index eb38f87..92b559c 100644 --- a/itkacl-2.0/itkacl.sql +++ b/itkacl-2.0/itkacl.sql @@ -12,6 +12,7 @@ CREATE TABLE aclentries ( entity_type VARCHAR(5) NOT NULL CHECK ( entity_type IN ('group', 'user') ), entity VARCHAR(64) NOT NULL, allow VARCHAR(5) NOT NULL CHECK ( allow IN ('grant', 'deny') ), + comment VARCHAR, UNIQUE ( object, entity_type, entity ) );