Digital Ocean managed database issue with Hibernate n..n generated tables

[shopizer-ecommerce]

The reason it fails is that DigitalOcean managed MySQL instances are created with sql_require_primary_key on. The Hibernate version shopizer currently uses fails silently when it executes create table thus not creating all the required tables.

[janarthanan-M2]

Solution - Digital ocean website need subscription to access the mysql instances, so i created new database called database.properties in sm-shop and tested locally in my workbench.
after adding the new database.properties file the non created tables are showing in the salesmanager schema

Changed Properties of Hibernate dialect (added database.properties in sm-shop)

db.jdbcUrl=jdbc:mysql://localhost:3306/SALESMANAGER?autoReconnect=true&serverTimeZone=UTC&useUnicode=true&characterEncoding=UTF-8
db.user=root
db.password=root
db.driverClass=com.mysql.cj.jdbc.Driver
hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect

db.show.sql=true
db.preferredTestQuery=SELECT 1
db.schema=SALESMANAGER
hibernate.hbm2ddl.auto=update