webERP Forum
Location of sql setup scripts - Printable Version

+- webERP Forum (http://www.weberp.org/forum)
+-- Forum: webERP Discussion (http://www.weberp.org/forum/forumdisplay.php?fid=1)
+--- Forum: How To ? (http://www.weberp.org/forum/forumdisplay.php?fid=6)
+--- Thread: Location of sql setup scripts (/showthread.php?tid=8409)



Location of sql setup scripts - tomglare - 09-10-2020

Hello - I am ready to set up a new database (have already created the empty database), and am looking for the appropriate script to create/populate tables (I believe I need to use the manual procedure, rather than the built-in installer, to do this, because we have multiple MariaDB servers running on the same machine, so I need to specify the port number by editing config.php).

The documentation refers me to sql/mysql/weberp-new.sql, but this does not exist.  I can see there is a script sql/mysql/country_sql/default.sql, which looks like the appropriate one. Can someone confirm this,please?


RE: Location of sql setup scripts - TimSchofield - 09-10-2020

That is correct. The documentation needs changing.

Tim


RE: Location of sql setup scripts - TurboPT - 09-10-2020

The default.sql file in the country subdirectory is the correct one.

I'll update the documentation reference.


RE: Location of sql setup scripts - tomglare - 09-10-2020

Great - thanks for the rapid response.


RE: Location of sql setup scripts - TurboPT - 09-13-2020

Thanks for the report, Tom.

There were a few places that needed coverage. (commit reference)