How delete user from mysql and all user information

lusui8 years ago

Ok. I will check.

lusui8 years ago

I full reinstalled traccar.
In my mysql config default-storage-engine=innodb

The programs does not remove all of the information user!
The program cleans only the tables: user_device, user_geofence, user_group

Anton Tananaev8 years ago

What else does it have to remove? Those are the only tables that are link to the user. Everything else can be shared between users, so it's not removed.

lusui8 years ago

The program must delete old user device. Why leave the old device in the system?!

In this tables saved old user info:
devices, device_geofence, events, geofences, groups, group_geofence

Anton Tananaev8 years ago

I already explained why. All that data can be shared between users, so it's not removed automatically.

lusui8 years ago

GPS tracker owned by the user that has been removed is not needed in the system as well as its attribute.

Example:

  1. tables attribute_aliases not shared between users
  2. tables device_geofence not shared between users
  3. tables geofences not shared between users
    ...

This tables not shared between users.

Anton Tananaev8 years ago

All tables that are not cleared, are shared between users, including the ones from your "examples".

lusui8 years ago

If I do not want to delete the user and all of its devices. How to do it?

Anton Tananaev8 years ago

Do you mean you do want to delete everything? You either do it manually, or you would have to change the code to remove it automatically.

lusui8 years ago

I understand that you want to change the code. This is my question, To do this and this topic

Anton Tananaev8 years ago

What is the question exactly? If you want to request some feature, you should do it on GitHub. There is no plan to change the behavior at the moment.