Created
November 5, 2023 19:51
-
-
Save wimleers/2556ae589fad400f082bfeb20eace4a4 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| cp mqtt.db ebusd-from-mqtt.db | |
| sqlite3 ebusd-from-mqtt.db "DROP TRIGGER mqtt_after_insert; DROP TRIGGER mqtt_after_update;ALTER TABLE mqtt DROP qos; ALTER TABLE mqtt DROP retain; ALTER TABLE mqtt DROP history_enable; ALTER TABLE mqtt DROP history_diffonly; UPDATE mqtt SET ts=datetime(ts, '-1 hour'); UPDATE mqtt_history SET ts=datetime(ts, '-1 hour');" | |
| sqlite3 ebusd-from-mqtt.db < newtriggers.sql |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment