traccar.tc_positions table

Tuomas 7 years ago

Hi,

I'm wondering that why "id" field is not UNSIGNED BIG INTEGER? Why it is just INT?

Cheers!

Anton Tananaev 7 years ago

Mostly to match a Java types, which only has signed integers.

Tuomas 7 years ago

but Java has long type which could be great match for UNSIGNED BIG INTEGER? But ofc there should be careful that it won't overflow.

Anton Tananaev 7 years ago

It's still a signed type.

Tuomas 7 years ago

Ok :). I noticed that and found this weird. But thanks for explanation!

Anton Tananaev 7 years ago

It might not be ideal, but we haven't had any problems so far, so no reason to change.