fix: update logs migrations to remove issues

[nityanandagohain]

The current migrations for logs gets stuck if the schema migrations table is deleted and the entire migrations are rerun as there are some queries which take a lot of time.

This fix ensures that we can run them again and also correct schema is created when a new instance is created.