app icon indicating copy to clipboard operation
app copied to clipboard

Update runtime_sensor.occupancy to tinyint(1)

Open ziebelje opened this issue 1 year ago • 0 comments

For some reason this column was created as a tinyint with the standard length of 3 for a boolean field. Somehow in the official beestat database it's showing up as length = 1, even though the show create table disagrees. The only difference I see between this and similar fields is that this is "unsigned".

I think I need to rewrite this entire table to a new table with the correct type. For now it's working, so updating beestat.sql will suffice.

image

ziebelje avatar Dec 07 '23 02:12 ziebelje