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=e18934bb5042485c938cf0ed815f7599021c5c91;hb=40884a302bf204a7f42044b72d87f9431ad6dd35;hp=77e304ac30f58134ed894cded6e2ba40233a43b8;hpb=09b59c841e16304b3f0826e6866e212bad922840;p=monitor.git

diff --git a/upgrade/monitor-server-3.0-19.sql b/upgrade/monitor-server-3.0-19.sql
index 77e304a..e18934b 100644
--- a/upgrade/monitor-server-3.0-19.sql
+++ b/upgrade/monitor-server-3.0-19.sql
@@ -19,3 +19,5 @@ 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;