[WebERP-developers] Country SQL

[Phil D. <ph...@lo...>]

We are collating country specific SQL databases  - Exson has done one 
for Chinese already and it would be cool if we could get a couple more.

We have them as SQL dump files under sql/mysql/country_sql Exson has 
modified the installer so a base database that contains appropriate base 
info.

You can create one using the webERP/build/make_release.sh If you use 
linux (you may need to make it executable first) and replace all 
occurences of weberpdemo with the database name where you have a 
localised version of webERP populated.

The new database at webERP/sql/mysql/country_sql/default.sql will 
contain no private data only the core tables and the structure for the 
remaining tables to be populated with the country data.

Only the data from the following tables will be in the resulting database:

        accountgroups \
        bankaccounts \
        chartmaster \
        companies \
        cogsglpostings \
        currencies \
        holdreasons \
        locations \
        paymentterms \
        reportlinks \
        salesglpostings \
        systypes \
        taxauthorities \
        taxgroups \
        taxauthrates \
        taxcategories \
        taxprovinces \
        www_users \
        edi_orders_segs \
        edi_orders_seg_groups \
        config \
        unitsofmeasure \
        paymentmethods \
        scripts \
        securitygroups \
        securitytokens \
        securityroles \
        accountsection \

of course you can have a look through the resulting file

sql/mysql/country_sql/default.sql

can be examined and edited to be sure there is nothing sensitive to your 
business. If you could compress and send to sub...@we... that 
would be great.

-- 
Phil

Phil Daintree
Logic Works Ltd - +64 (0)275 567890
http://www.logicworks.co.nz