04 Configuring the database

Configuring the database

Overall there's only one table you need to change to adapt Localtrade to your own country/region, and that's the communes-table.

You will have to decide how to geographically divide your app, e.g. in communes like we do, in towns, in regions.

If you keep the fields like they are (with id char(4), name, and max_admins) you will not need to change anything in the other tables or in the code.

If you change the datatype or length of the id, you will need to change the same on the foreign key "commune_id" in the tables "users" and "ads".

If you also change the name of the other fields, or adding/removing fields, you will need to change some of the source code in the application. We do NOT recommend this. If you do this, you will have to find out what you need to change in the code yourself.

However, only changing the id should work just fine. e.g. if you use a five-digit zipcode.

Go back to [03 Configure Localtrade]