Changeset 739 for trunk

Timestamp:

08/25/16 16:45:42 (8 years ago)

Author:

Kris Deugau

Message:

/trunk

Update initial tabledef and update SQL for log view tweaks

Location:

trunk

Files:

• dns-upd-1.4.0.sql (modified) (2 diffs)
• dns.sql (modified) (1 diff)

trunk/dns-upd-1.4.0.sql

@@ -1 +1 @@
 -- Updates introduced in 1.4.0 schema
+
+-- Cross-reference field for collapsing large blocks of related log entries
+ALTER TABLE log ADD COLUMN logparent integer;
+-- As a separate statement Just In Case
+UPDATE log SET logparent = 0;
+ALTER TABLE log ALTER COLUMN logparent SET DEFAULT 0;
+ALTER TABLE log ALTER COLUMN logparent SET NOT NULL;
+CREATE INDEX log_logparent_index ON log(logparent);
 
 -- Missing indexes on the log table;  should shave the search/filter
@@ -8 +16 @@
 CREATE INDEX log_rdns_id_index ON log(rdns_id);
 
+-- Matching index on revzones
+CREATE INDEX revzones_rdns_id_index ON revzones(rdns_id);
+
 -- Update dbversion
 UPDATE misc SET value='1.4.0' WHERE key='dbversion';

trunk/dns.sql

@@ -136 +136 @@
     entry text,
     stamp timestamp with time zone DEFAULT now(),
-    rdns_id integer
+    rdns_id integer,
+    logparent integer NOT NULL DEFAULT 0
 );
 CREATE INDEX log_domain_id_index ON log(domain_id);