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

diff --git a/upgrade/monitor-server-3.0-19.sql b/upgrade/monitor-server-3.0-19.sql
index afcebf8..e18934b 100644
--- 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;