X-Git-Url: http://git.onelab.eu/?a=blobdiff_plain;f=upgrade%2Fmonitor-server-3.0-19.sql;fp=upgrade%2Fmonitor-server-3.0-19.sql;h=afcebf884451051bafe2cf08f179ab4f9a7385de;hb=fa2476a41dcdf191df1026263fdaf1dd5ea3bedd;hp=0000000000000000000000000000000000000000;hpb=12caba68661a8bc1c36d99850e4938ac02dfa0b2;p=monitor.git

diff --git a/upgrade/monitor-server-3.0-19.sql b/upgrade/monitor-server-3.0-19.sql
new file mode 100644
index 0000000..afcebf8
--- /dev/null
+++ b/upgrade/monitor-server-3.0-19.sql
@@ -0,0 +1,18 @@
+-- If there's an existing database, these commands will upgrade it to the
+-- current version
+
+ALTER TABLE findbadnoderecord ADD COLUMN firewall boolean DEFAULT False;
+ALTER TABLE findbadnoderecord_history ADD COLUMN firewall boolean DEFAULT False;
+
+ALTER TABLE findbadnoderecord ADD COLUMN external_dns_status boolean DEFAULT True;
+ALTER TABLE findbadnoderecord_history ADD COLUMN external_dns_status boolean DEFAULT True;
+
+ALTER TABLE findbadnoderecord ADD COLUMN rpms varchar DEFAULT NULL;
+ALTER TABLE findbadnoderecord_history ADD COLUMN rpms varchar DEFAULT NULL;
+
+ALTER TABLE findbadnoderecord ADD COLUMN uptime varchar DEFAULT NULL;
+ALTER TABLE findbadnoderecord_history ADD COLUMN uptime varchar DEFAULT NULL;
+
+ALTER TABLE findbadnoderecord ADD COLUMN traceroute varchar DEFAULT NULL;
+ALTER TABLE findbadnoderecord_history ADD COLUMN traceroute varchar DEFAULT NULL;
+