Last change
on this file since 737 was 734, checked in by Kris Deugau, 8 years ago |
/trunk
Add some missing indexes in the targeted 1.4.0 SQL schema.
|
File size:
416 bytes
|
Rev | Line | |
---|
[734] | 1 | -- Updates introduced in 1.4.0 schema
|
---|
| 2 |
|
---|
| 3 | -- Missing indexes on the log table; should shave the search/filter
|
---|
| 4 | -- time somewhat on large installs.
|
---|
| 5 | CREATE INDEX log_domain_id_index ON log(domain_id);
|
---|
| 6 | CREATE INDEX log_user_id_index ON log(user_id);
|
---|
| 7 | CREATE INDEX log_group_id_index ON log(group_id);
|
---|
| 8 | CREATE INDEX log_rdns_id_index ON log(rdns_id);
|
---|
| 9 |
|
---|
| 10 | -- Update dbversion
|
---|
| 11 | UPDATE misc SET value='1.4.0' WHERE key='dbversion';
|
---|
Note:
See
TracBrowser
for help on using the repository browser.