source: branches/stable/dns-upd-1.4.0.sql@ 864

Last change on this file since 864 was 756, checked in by Kris Deugau, 8 years ago

/branches/stable

Merge /trunk through r749 for 1.4.0

File size: 857 bytes
RevLine 
[734]1-- Updates introduced in 1.4.0 schema
2
[739]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);
10
[734]11-- Missing indexes on the log table; should shave the search/filter
12-- time somewhat on large installs.
13CREATE INDEX log_domain_id_index ON log(domain_id);
14CREATE INDEX log_user_id_index ON log(user_id);
15CREATE INDEX log_group_id_index ON log(group_id);
16CREATE INDEX log_rdns_id_index ON log(rdns_id);
17
[739]18-- Matching index on revzones
19CREATE INDEX revzones_rdns_id_index ON revzones(rdns_id);
20
[734]21-- Update dbversion
22UPDATE misc SET value='1.4.0' WHERE key='dbversion';
Note: See TracBrowser for help on using the repository browser.