diff options
Diffstat (limited to 'db/old_migrations/patch-add-docker-columns.sql')
-rw-r--r-- | db/old_migrations/patch-add-docker-columns.sql | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/db/old_migrations/patch-add-docker-columns.sql b/db/old_migrations/patch-add-docker-columns.sql new file mode 100644 index 0000000..4cea448 --- /dev/null +++ b/db/old_migrations/patch-add-docker-columns.sql @@ -0,0 +1,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; |