Changeset 370 for trunk/dns.sql

Timestamp:

07/29/12 22:02:48 (12 years ago)

Author:

Kris Deugau

Message:

/trunk

Checkpoint; adding location/view support. See #10.

• add location to menu
• add table and link fields to initial tabledef and upgrade SQL
• add listing subs and list page
• update permissions list and subpage template with new permissions

File:

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

trunk/dns.sql

@@ -16 +16 @@
 1       dbversion       1.2
 \.
+
+CREATE TABLE locations (
+    location character varying (4) PRIMARY KEY,
+    group_id integer NOT NULL DEFAULT 1,
+    iplist text NOT NULL DEFAULT '',
+    description text NOT NULL DEFAULT ''
+);
 
 CREATE TABLE default_records (
@@ -66 +73 @@
     zserial integer,
     sertype character(1) DEFAULT 'D'::bpchar,
-    changed boolean DEFAULT true NOT NULL
+    changed boolean DEFAULT true NOT NULL,
+    default_location character varying (4) DEFAULT '' NOT NULL
 );
 
@@ -77 +85 @@
     zserial integer,
     sertype character(1) DEFAULT 'D'::bpchar,
-    changed boolean DEFAULT true NOT NULL
+    changed boolean DEFAULT true NOT NULL,
+    default_location character varying (4) DEFAULT '' NOT NULL
 );
 
@@ -123 +132 @@
     record_edit boolean DEFAULT false NOT NULL,
     record_delete boolean DEFAULT false NOT NULL,
+    location_create boolean DEFAULT false NOT NULL,
+    location_edit boolean DEFAULT false NOT NULL,
+    location_delete boolean DEFAULT false NOT NULL,
+    location_view boolean DEFAULT false NOT NULL,
     user_id integer UNIQUE,
     group_id integer UNIQUE
@@ -129 +142 @@
 -- 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, user_id, group_id) FROM stdin;
-1       f       f       f       f       f       f       f       f       t       t       t       t       t       t       \N      1
-2       t       f       f       f       f       f       f       f       f       f       f       f       f       f       1       \N
+1       f       f       f       f       f       f       f       f       t       t       t       t       t       t       f       f       f       f       \N      1
+2       t       f       f       f       f       f       f       f       f       f       f       f       f       f       f       f       f       f       1       \N
 \.
 
@@ -145 +158 @@
     port integer DEFAULT 0 NOT NULL,
     ttl integer DEFAULT 7200 NOT NULL,
-    description text
+    description text,
+    default_location character varying (4) DEFAULT '' NOT NULL
 );
 
@@ -289 +303 @@
 -- foreign keys
 -- fixme: permissions FK refs
+ALTER TABLE ONLY locations
+    ADD CONSTRAINT "locations_group_id_fkey" FOREIGN KEY (group_id) REFERENCES groups(group_id);
+
 ALTER TABLE ONLY domains
     ADD CONSTRAINT "$1" FOREIGN KEY (group_id) REFERENCES groups(group_id);