I understand the problem, but before we talk about solutions I would really like to understand how you got there.

One wouldn't expect tables in a relational database to be dropped randomly while working on it with Hibernate ORM.

What is different here, what makes it reasonable for the index to be dropped without the application's knowledge?