DROP INDEX IF EXISTS iszl.t_schet_sluch_date_1_idx;
CREATE INDEX t_schet_sluch_date_1_idx ON iszl.t_schet_sluch (date_1);

DROP INDEX IF EXISTS iszl.t_schet_sluch_date_2_idx;
CREATE INDEX t_schet_sluch_date_2_idx ON iszl.t_schet_sluch (date_2);

DROP INDEX IF EXISTS iszl.t_mo_attachment_insured_idx;
CREATE INDEX t_mo_attachment_insured_idx ON iszl.t_mo_attachment (insured);

DROP INDEX IF EXISTS iszl.t_mo_attachment_attachdate_idx;
CREATE INDEX t_mo_attachment_attachdate_idx ON iszl.t_mo_attachment (attachdate);

DROP INDEX IF EXISTS iszl.t_mo_attachment_cause_idx;
CREATE INDEX t_mo_attachment_cause_idx ON iszl.t_mo_attachment (cause);

DROP INDEX IF EXISTS iszl.t_mo_attachment_mo_idx;
CREATE INDEX t_mo_attachment_mo_idx ON iszl.t_mo_attachment (mo);

DROP INDEX IF EXISTS iszl.t_mo_attachment_podr_idx;
CREATE INDEX t_mo_attachment_podr_idx ON iszl.t_mo_attachment (podr);

DROP INDEX IF EXISTS iszl.t_mo_attachment_uch_idx;
CREATE INDEX t_mo_attachment_uch_idx ON iszl.t_mo_attachment (uch);

DROP INDEX IF EXISTS iszl.t_mo_attachment_status_idx;
CREATE INDEX t_mo_attachment_status_idx ON iszl.t_mo_attachment (status);

DROP INDEX IF EXISTS iszl.t_insured_contact_contacttype_idx;
CREATE INDEX t_insured_contact_contacttype_idx ON iszl.t_insured_contact (contacttype);

DROP INDEX IF EXISTS iszl.t_insured_contact_contact_idx;
CREATE INDEX t_insured_contact_contact_idx ON iszl.t_insured_contact (contact);

DROP INDEX IF EXISTS iszl.ix_t_schet_sluch_schetsluchaccomplished;
CREATE INDEX ix_t_schet_sluch_schetsluchaccomplished ON iszl.t_schet_sluch (schetsluchaccomplished);

DROP INDEX IF EXISTS iszl.ix_t_schet_sluch_onk_schetsluch;
CREATE INDEX ix_t_schet_sluch_onk_schetsluch ON iszl.t_schet_sluch_onk (schetsluch);

DROP INDEX IF EXISTS iszl.ix_t_schet_schetfile;
CREATE INDEX ix_t_schet_schetfile ON iszl.t_schet (schetfile);

DROP INDEX IF EXISTS iszl.ix_t_schet_zap_schet;
CREATE INDEX ix_t_schet_zap_schet ON iszl.t_schet_zap (schet);

DROP INDEX IF EXISTS iszl.uq_t_schet_sluch_accomplished_schetzap;
CREATE UNIQUE INDEX uq_t_schet_sluch_accomplished_schetzap ON iszl.t_schet_sluch_accomplished (schetzap);
