We are developing custom plugin in jive hosted environment to access the database(PostgreSQL) . Following are the steps we did by following the document Accessing the Database from a Plugin
1. changed in schema.xml
2. Added database key and version in plugin.xml
Iam seeing the below statements in logs
But we couldn't see the schema created in our database.
Nothing looks incorrect in the code snippets you have provided. The tables should be there but you might try changing the version and adding a column to one of the tables to see if you can get an error or additional information.
Make sure the user account has full permissions to the schema. This looks more like a database issue than a Jive issue.