install/sql folder why it is used and how are initial values (seed data) added to databse ?

Question

1)In Sql file , there are some insert , update commands  are they run when i 1st time install the hmdm-server ?
2)Particularly  , device table has no INSERT OR UPDATE  statements in liquibase scripts , but in the database there are initial  values added "h0001".
3)Does this mean other then database changelog  files , application is adding these initial values for devices table in another way (install/sql )?

Answer 1

The database is initialized by the installer script (hmdm_install.sh) in two steps.

Headwind MDM web application itself creates the database scheme only (by using liquibase migration), the database is mostly empty.

Once the scheme is created, the installer script runs the initialization script (install/sql/hmdm_init_en.sql) which creates the initial values.

So if you need to set up a development environment, the best option would be to set up a test instance of Headwind MDM using the installer, then dump the database and deploy a copy on the development computer.