Changeset 387 for trunk

Timestamp:

09/21/12 13:00:22 (12 years ago)

Author:

Kris Deugau

Message:

/trunk

Add a new permission record_locchg to separate changing the
location of a record from the abaility to edit a record or
change the location definition. See #10.

Location:

trunk

Files:

• DNSDB.pm (modified) (4 diffs)
• dns-1.0-1.2.sql (modified) (1 diff)
• dns.sql (modified) (1 diff)

trunk/DNSDB.pm

@@ -115 +115 @@
         user_edit       user_create     user_delete
         domain_edit     domain_create   domain_delete
-        record_edit     record_create   record_delete
+        record_edit     record_create   record_delete   record_locchg
         location_edit   location_create location_delete location_view
         self_edit       admin
@@ -1477 +1477 @@
         p.user_create,p.user_edit,p.user_delete,
         p.domain_create,p.domain_edit,p.domain_delete,
-        p.record_create,p.record_edit,p.record_delete,
+        p.record_create,p.record_edit,p.record_delete,p.record_locchg,
         p.location_create,p.location_edit,p.location_delete,p.location_view
         FROM permissions p
@@ -1505 +1505 @@
         $hash->{user_create},$hash->{user_edit},$hash->{user_delete},
         $hash->{domain_create},$hash->{domain_edit},$hash->{domain_delete},
-        $hash->{record_create},$hash->{record_edit},$hash->{record_delete},
+        $hash->{record_create},$hash->{record_edit},$hash->{record_delete},$hash->{record_locchg},
         $hash->{location_create},$hash->{location_edit},$hash->{location_delete},$hash->{location_view}
         ) = $sth->fetchrow_array;
@@ -2183 +2183 @@
 
 ## DNSDB::getZoneLocation()
-# Retrieve the default locatino for a zone.
+# Retrieve the default location for a zone.
 # Takes a database handle, forward/reverse flag, and zone ID
 sub getZoneLocation {

trunk/dns-1.0-1.2.sql

@@ -14 +14 @@
     ADD CONSTRAINT "locations_group_id_fkey" FOREIGN KEY (group_id) REFERENCES groups(group_id);
 
+ALTER TABLE permissions ADD COLUMN record_locchg boolean DEFAULT false NOT NULL;
 ALTER TABLE permissions ADD COLUMN location_create boolean DEFAULT false NOT NULL;
 ALTER TABLE permissions ADD COLUMN location_edit boolean DEFAULT false NOT NULL;

trunk/dns.sql

@@ -134 +134 @@
     record_edit boolean DEFAULT false NOT NULL,
     record_delete boolean DEFAULT false NOT NULL,
+    record_locchg boolean DEFAULT false NOT NULL,
     location_create boolean DEFAULT false NOT NULL,
     location_edit boolean DEFAULT false NOT NULL,