Changeset 739


Ignore:
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:
2 edited

Legend:

Unmodified
Added
Removed
  • trunk/dns-upd-1.4.0.sql

    r734 r739  
    11-- Updates introduced in 1.4.0 schema
     2
     3-- Cross-reference field for collapsing large blocks of related log entries
     4ALTER TABLE log ADD COLUMN logparent integer;
     5-- As a separate statement Just In Case
     6UPDATE log SET logparent = 0;
     7ALTER TABLE log ALTER COLUMN logparent SET DEFAULT 0;
     8ALTER TABLE log ALTER COLUMN logparent SET NOT NULL;
     9CREATE INDEX log_logparent_index ON log(logparent);
    210
    311-- Missing indexes on the log table;  should shave the search/filter
     
    816CREATE INDEX log_rdns_id_index ON log(rdns_id);
    917
     18-- Matching index on revzones
     19CREATE INDEX revzones_rdns_id_index ON revzones(rdns_id);
     20
    1021-- Update dbversion
    1122UPDATE misc SET value='1.4.0' WHERE key='dbversion';
  • trunk/dns.sql

    r734 r739  
    136136    entry text,
    137137    stamp timestamp with time zone DEFAULT now(),
    138     rdns_id integer
     138    rdns_id integer,
     139    logparent integer NOT NULL DEFAULT 0
    139140);
    140141CREATE INDEX log_domain_id_index ON log(domain_id);
Note: See TracChangeset for help on using the changeset viewer.