From fa2476a41dcdf191df1026263fdaf1dd5ea3bedd Mon Sep 17 00:00:00 2001 From: Stephen Soltesz Date: Mon, 27 Jul 2009 19:58:58 +0000 Subject: [PATCH 1/1] an upgrade script to extend convert existing databases --- upgrade/monitor-server-3.0-19.sql | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) create mode 100644 upgrade/monitor-server-3.0-19.sql 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; + -- 2.43.0