Improve Database schema about traccar-web

[tananaev]

I can see the reason to add insertion time to positions table. But why do you want it for all tables? Is there a good reason for that?

I am using GWT-RPC, so if there is implementation for PHP you can try to use it. Maybe gwtphp is what you need.

[Jeferex]

You are right about positions table but I meant for the other tables. It is for control purposes.

I am going to check gwtphp to test if I can do what I want.

Thanks!

[Jeferex]

I have some questions about positions table.

1. What's address column for? It is allways NULL
2. Why power column is allways NULL, too?
3. I told you about other column and the bug in traccar web when I changed it in config.
4. In GPS103, The manufacturer has added some other fields to the protocol, I think. They have added Power: (ON/OFF), Door(ON/OFF) and ACC(ON/OFF)

Can you add them to next version?

[tananaev]

1. Address is for address, if you enable reverse geocoding in config it will be there.
2. Because your tracker doesn't send voltage level or I don't know how to parse it.
3. It's not a question.
4. If you can provide me with documentation I will add it.

[tananaev]

Database schema completely changed in version 3.0:

https://github.com/tananaev/traccar/blob/master/debug.xml#L53