Changeset 739 for trunk/dns-upd-1.4.0.sql
- Timestamp:
- 08/25/16 16:45:42 (8 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/dns-upd-1.4.0.sql
r734 r739 1 1 -- Updates introduced in 1.4.0 schema 2 3 -- Cross-reference field for collapsing large blocks of related log entries 4 ALTER TABLE log ADD COLUMN logparent integer; 5 -- As a separate statement Just In Case 6 UPDATE log SET logparent = 0; 7 ALTER TABLE log ALTER COLUMN logparent SET DEFAULT 0; 8 ALTER TABLE log ALTER COLUMN logparent SET NOT NULL; 9 CREATE INDEX log_logparent_index ON log(logparent); 2 10 3 11 -- Missing indexes on the log table; should shave the search/filter … … 8 16 CREATE INDEX log_rdns_id_index ON log(rdns_id); 9 17 18 -- Matching index on revzones 19 CREATE INDEX revzones_rdns_id_index ON revzones(rdns_id); 20 10 21 -- Update dbversion 11 22 UPDATE misc SET value='1.4.0' WHERE key='dbversion';
Note:
See TracChangeset
for help on using the changeset viewer.