Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Update runtime_sensor.occupancy to tinyint(1) #401

Open
ziebelje opened this issue Dec 7, 2023 · 0 comments
Open

Update runtime_sensor.occupancy to tinyint(1) #401

ziebelje opened this issue Dec 7, 2023 · 0 comments
Labels
General Affects the system in general. Self-Hosting Related to self-hosting beestat.

Comments

@ziebelje
Copy link
Member

ziebelje commented Dec 7, 2023

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 ziebelje added General Affects the system in general. Self-Hosting Related to self-hosting beestat. labels Dec 7, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
General Affects the system in general. Self-Hosting Related to self-hosting beestat.
Projects
None yet
Development

No branches or pull requests

1 participant