I realize we maybe need to force client to fetch migration script from server, otherwise there is no way the client can get the latest migration scripts without upgrade or codepush.
I have sketched some rough strategy but I'm not sure if this is over the top nor do I know what's the best practice for mobile database migration, but here it is:
