source:
trunk/dns-upd-1.4.0.sql
Last change on this file was 739, checked in by , 8 years ago | |
---|---|
File size: 857 bytes |
Line | |
---|---|
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); |
10 | |
11 | -- Missing indexes on the log table; should shave the search/filter |
12 | -- time somewhat on large installs. |
13 | CREATE INDEX log_domain_id_index ON log(domain_id); |
14 | CREATE INDEX log_user_id_index ON log(user_id); |
15 | CREATE INDEX log_group_id_index ON log(group_id); |
16 | CREATE INDEX log_rdns_id_index ON log(rdns_id); |
17 | |
18 | -- Matching index on revzones |
19 | CREATE INDEX revzones_rdns_id_index ON revzones(rdns_id); |
20 | |
21 | -- Update dbversion |
22 | UPDATE misc SET value='1.4.0' WHERE key='dbversion'; |
Note:
See TracBrowser
for help on using the repository browser.