create unique index aodb_aoid_ptc_xxx on aodb (aoid, patch);
create index aodb_metatype_xxx  on aodb (metatype) where current is true;

create index aodb_eff_xid_idx   on aodb_eff  (xid);
create index aodb_req_xid_idx   on aodb_req  (xid);
create index aodb_other_xid_idx on aodb_other(xid);
create index aodb_skill_xid_idx on aodb_skill(xid, type);

create index aodb_eff_type_idx  on aodb_eff  (type);
create index aodb_eff_val1_idx  on aodb_eff  (value1);

create index aodb_req_attr_idx  on aodb_req  (attribute);
create index aodb_req_val_idx   on aodb_req  (value);