Last change
on this file since 776 was 756, checked in by Kris Deugau, 8 years ago |
/branches/stable
Merge /trunk through r749 for 1.4.0
|
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.