• patch-added-mqtt-monitor.sql
  • -- You should not modify if this have pushed to Github, unless it does serious wrong with the db.
    BEGIN TRANSACTION;
    
    ALTER TABLE monitor
    	ADD mqtt_topic TEXT;
    
    ALTER TABLE monitor
    	ADD mqtt_success_message VARCHAR(255);
    
    ALTER TABLE monitor
    	ADD mqtt_username VARCHAR(255);
    
    ALTER TABLE monitor
    	ADD mqtt_password VARCHAR(255);
    
    COMMIT;