Last change
on this file since 866 was 739, checked in by Kris Deugau, 8 years ago |
/trunk
Update initial tabledef and update SQL for log view tweaks
|
File size:
857 bytes
|
Rev | Line | |
---|
[734] | 1 | -- Updates introduced in 1.4.0 schema
|
---|
| 2 |
|
---|
[739] | 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 |
|
---|
[734] | 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 |
|
---|
[739] | 18 | -- Matching index on revzones
|
---|
| 19 | CREATE INDEX revzones_rdns_id_index ON revzones(rdns_id);
|
---|
| 20 |
|
---|
[734] | 21 | -- Update dbversion
|
---|
| 22 | UPDATE misc SET value='1.4.0' WHERE key='dbversion';
|
---|
Note:
See
TracBrowser
for help on using the repository browser.