tc_positions id column data type

Gimbusa year ago

Hello,
I'm using version 5.8 of traccar with postgresql database. Databse has been created during the first start and datatype for the column id in tc_positions table is integer (4 bytes) so max value for id is 2,147,483,647. But in the sources (current) id field is referenced as long (8 bytes).
Is it safe to convert the the table id field to postgresql bigint? And of course all the referenced fields in other tables too.
That would give max id value enough for me ;-)
Thanking in advance
Paweł

Anton Tananaeva year ago

Yes, it should be safe.

Gimbusa year ago

Thank You, so i will try.