-- Updates introduced in 1.4.0 schema

-- Missing indexes on the log table;  should shave the search/filter
-- time somewhat on large installs.
CREATE INDEX log_domain_id_index ON log(domain_id);
CREATE INDEX log_user_id_index ON log(user_id);
CREATE INDEX log_group_id_index ON log(group_id);
CREATE INDEX log_rdns_id_index ON log(rdns_id);

-- Update dbversion
UPDATE misc SET value='1.4.0' WHERE key='dbversion';