[Core] Integrate proper SQL migrations

[rohilsurana]

As of now there is just one SQL schema that runs at migration step.

We need proper migrations that allow use to upgrade and downgrade schema.