Changeset 387 for trunk/dns-1.0-1.2.sql

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.

File:

• trunk/dns-1.0-1.2.sql (modified) (1 diff)

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;