Changeset 65 for trunk/dns.sql

Timestamp:

11/25/10 16:26:08 (13 years ago)

Author:

Kris Deugau

Message:

/trunk

checkpoint, adding permissions/ACL support

File:

• trunk/dns.sql (modified) (6 diffs)

trunk/dns.sql

@@ -7 +7 @@
 
 -- tabledefs and preloaded data bits
+CREATE TABLE permissions (
+    permission_id SERIAL NOT NULL,
+    admin boolean DEFAULT 'n' NOT NULL,
+    self_edit boolean DEFAULT 'n' NOT NULL,
+    group_create boolean DEFAULT 'n' NOT NULL,
+    group_edit boolean DEFAULT 'n' NOT NULL,
+    group_delete boolean DEFAULT 'n' NOT NULL,
+    user_create boolean DEFAULT 'n' NOT NULL,
+    user_edit boolean DEFAULT 'n' NOT NULL,
+    user_delete boolean DEFAULT 'n' NOT NULL,
+    domain_create boolean DEFAULT 'n' NOT NULL,
+    domain_edit boolean DEFAULT 'n' NOT NULL,
+    domain_delete boolean DEFAULT 'n' NOT NULL,
+    record_create boolean DEFAULT 'n' NOT NULL,
+    record_edit boolean DEFAULT 'n' NOT NULL,
+    record_delete boolean DEFAULT 'n' NOT NULL
+);
+
+-- Need *two* basic permissions;  one for the initial group, one for the default admin user
+COPY permissions (permission_id, admin, self_edit, group_create, group_edit group_delete, user_create, user_edit, user_delete, domain_create, domain_edit, domain_delete, record_create, record_edit, record_delete) FROM stdin;
+1       n       n       n       n       n       n       n       n       n       n       n       n       n       n
+2       y       n       n       n       n       n       n       n       n       n       n       n       n       n
+\.
+
 CREATE TABLE groups (
     group_id serial NOT NULL,
     parent_group_id integer DEFAULT 1 NOT NULL,
+    permission_id integer DEFAULT 1 NOT NULL,
     group_name character varying(255) DEFAULT ''::character varying NOT NULL
 );
@@ -15 +40 @@
 -- Provide a basic default group
 COPY groups (group_id, parent_group_id, group_name) FROM stdin;
-1       1       default
+1       1       1       default
 \.
 
@@ -151 +176 @@
     "type" character(1) DEFAULT 'S'::bpchar NOT NULL,
     status integer DEFAULT 1 NOT NULL,
-    acl character varying(40) DEFAULT 'b'::character varying NOT NULL
+    acl character varying(40) DEFAULT 'b'::character varying NOT NULL,
+    permission_id DEFAULT 1 NOT NULL,
 );
 
 -- create initial default user?  may be better to create an "initialize" script or something
 COPY users (user_id, group_id, username, "password", firstname, lastname, phone, "type", status, acl) FROM stdin;
-1       1       test@test       $1$BByge8u2$48AaGX3YeHplfErX5Tlqa1      \N      \N      \N      S       1       A
+1       1       test@test       $1$BByge8u2$48AaGX3YeHplfErX5Tlqa1      \N      \N      \N      S       1       A       2
 \.
 
@@ -174 +200 @@
 
 -- primary keys
+ALTER TABLE ONLY permissions
+    ADD CONSTRAINT permissions_permission_id_key UNIQUE (permission_id);
+
 ALTER TABLE ONLY groups
     ADD CONSTRAINT groups_group_id_key UNIQUE (group_id);
@@ -199 +228 @@
 
 -- foreign keys
+-- fixme: permissions FK refs
 ALTER TABLE ONLY domains
     ADD CONSTRAINT "$1" FOREIGN KEY (group_id) REFERENCES groups(group_id);
@@ -216 +246 @@
 -- set sequence start values - make sure we don't screw up adding
 -- records to tables that already have a few entries
+SELECT pg_catalog.setval('permissions_permission_id_seq', 2, true);
 
 SELECT pg_catalog.setval('groups_group_id_seq', 52, true);