#add new indexes
drop index field_name_idx if exists;
create index idx_field_name on FIELD (name);
create index idx_field_scope on FIELD (fieldScope);
create index idx_frx_fromfr on FR_EXTRA (fromRevision);
create index idx_frx_fr on FR_EXTRA (fileRevision);
create index idx_frx_review on FR_EXTRA (REVIEW_ID);
create index idx_rc_revision on REVISION_COMMENT (revision);
create index idx_rc_comment on REVISION_COMMENT (comment);
create index idx_rc_frx on REVISION_COMMENT (FRX_ID);

# and finally update the db version
UPDATE CRUVERSION SET version = 10 WHERE version_id = 1;
