[OSM-dev] Explanation of database schema

[Achilleas Michailidis]

Hi everyone,

I do not know if this is the right list to ask this question so feel free
to redirect me to the correct one if needed.

I have created a database in MySQL following the database schema provided
here <https://wiki.openstreetmap.org/wiki/Database>.

Then i run the following command
osmosis --read-xml enableDateParsing=no file="YOUR_OSM_IMPORT_FILE"
--buffer --write-apidb dbType="mysql" host="HOSTNAME"
database="DATABASE_NAME" user="USERNAME" password="PASSWORD"
validateSchemaVersion=no

This command was found here
<https://forum.openstreetmap.org/viewtopic.php?id=9870> for reference.

All in all, this solution works fine but i cannot understand what the
current tables are in the database schema, eg current_nodes. With a small
search, i found out the following explanation in the openstreetmap wiki

> The *current table* (e.g. 'current_nodes', 'current_ways') is the latest
> revision, used for drawing the map. The *master table* includes all
> previous edit history. The current table is therefore a subset of the
> master table.


But what does this mean? Do the current tables hold the "live" data? The
data that are presented in the map? If not, what do they stand for?

Thank you,
AM
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20170624/89611904/attachment.html>