summaryrefslogtreecommitdiffstats
path: root/db/old_migrations/patch-add-docker-columns.sql
blob: 4cea448d7a697d301e8e21f64d5aac9219702d25 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
-- You should not modify if this have pushed to Github, unless it does serious wrong with the db.
BEGIN TRANSACTION;

CREATE TABLE docker_host (
	id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
	user_id INT NOT NULL,
	docker_daemon VARCHAR(255),
	docker_type VARCHAR(255),
	name VARCHAR(255)
);

ALTER TABLE monitor
	ADD docker_host INTEGER REFERENCES docker_host(id);

ALTER TABLE monitor
	ADD docker_container VARCHAR(255);

COMMIT;