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=0000000000000000000000000000000000000000;hp=92b559cf86e99caa88f886b56d074b87a1ecc30c;hb=66f114e2e5b127115cc127ea23865371f1bea90d;hpb=19417083de9c8b30ac8b590690783b11413e2c58

diff --git a/itkacl-2.0/itkacl.sql b/itkacl-2.0/itkacl.sql
deleted file mode 100644
index 92b559c..0000000
--- a/itkacl-2.0/itkacl.sql
+++ /dev/null
@@ -1,20 +0,0 @@
-CREATE TABLE objects (
-	id SERIAL NOT NULL PRIMARY KEY,
-	name VARCHAR(64) NOT NULL,
-	description VARCHAR(255) NOT NULL,
-	parent INTEGER REFERENCES objects(id),
-
-	UNIQUE ( name, parent )
-);
-
-CREATE TABLE aclentries (
-	object INTEGER NOT NULL REFERENCES objects(id),
-	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 )
-);
-CREATE INDEX object_index ON aclentries ( object );
-