Why do I have serveral same table as user and users

pierrot109 years ago

Good day all,

I just uninstalled traccar 3.1 and reinstall the last version.
Before I cleaned and deleted all table from traccar database.

I easely reinstall tracca 3.2 and it automatically create table on my 'traccar' database.

Then I decided to use MySLQ insetad of the H2 database. I following the procedure
MySQL Database
Then I return to my MySQL database and I was surprised to see new table as

user and users
position and positions
devise and devises

THis is normal, because sinde I did it, new users are saved in 'user' table instead of 'users'

Is thee a way to clean unsufull table?

I will reinstall traccar 3.2 and reinstall it with the goal to use MySQL instead to H2. Is there a way to do it properly without unsefull table?

Many thank

pierrot109 years ago

I may be answer to my question.
I reinstalled traccar 3.2 but when I did it, I have not refresh my web page and start traccar.
I immediately change the databse configuration as described here
https://www.traccar.org/mysql/
When it was done, I strated traccar and it build my tables but I have only the following table

device
position
server
traccar
user
user_device

That correct?

Anton Tananaev9 years ago

Yes, that seems to be correct schema.

Tables with plural names are from Traccar version 2.x (or alternative web interface).

pierrot109 years ago

Great Anton,
Thank for your great support.
I ma going to install now Trccar UI.
Cheers