How to insert rows for the first time when database is created

Support
#1

Hi,

when creating a database, we have some reference tables with default rows like status. how can I insert those rows when the database is created for the first time ?

thanks,

#2

Hi @mikemasterplumber1,

There is a subsystem of init/update scripts, you can find more information in the documentation.

Note, that you can use the pre-created 30.create-db.sql file to write your custom sql statements.
image

Regards,
Aleksey

2 Likes