summaryrefslogtreecommitdiffstats
path: root/db/old_migrations/patch-added-mqtt-monitor.sql
blob: 02b0b09d9e03513cd22d30a9fb769bcecbef7b8e (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
-- 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;