add install_date field

[monitor.git] / 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
index afcebf8..e18934b 100644 (file)
--- a/upgrade/monitor-server-3.0-19.sql
+++ b/upgrade/monitor-server-3.0-19.sql
@@ -16,3 +16,8 @@ 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;
 
+ALTER TABLE historynoderecord ADD COLUMN firewall boolean DEFAULT false;
+ALTER TABLE historynoderecord_history ADD COLUMN firewall boolean DEFAULT false;
+
+ALTER TABLE historynoderecord ADD COLUMN plc_siteid integer DEFAULT 1;
+ALTER TABLE historynoderecord_history ADD COLUMN plc_siteid integer DEFAULT 1;