an upgrade script to extend convert existing databases

diff --git a/upgrade/monitor-server-3.0-19.sql b/upgrade/monitor-server-3.0-19.sql
new file mode 100644 (file)
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;
+