X-Git-Url: http://git.onelab.eu/?a=blobdiff_plain;f=planetlab5.sql;fp=planetlab5.sql;h=c4ef7dc9347cb97a73847f84fdff3cf53bb912c8;hb=db42a908647b5116ecc3d63800fee6662d036914;hp=710e436cb1e0bf2f3164d80fa86ad20ce4f9155b;hpb=a54fc801d75b1d62be7633e01312b9118ba94723;p=plcapi.git

diff --git a/planetlab5.sql b/planetlab5.sql
index 710e436..c4ef7dc 100644
--- a/planetlab5.sql
+++ b/planetlab5.sql
@@ -348,7 +348,7 @@ INSERT INTO network_methods (method) VALUES ('tap');
 INSERT INTO network_methods (method) VALUES ('ipmi');
 INSERT INTO network_methods (method) VALUES ('unknown');
 
--- Node network interfaces
+-- Network interfaces
 CREATE TABLE interfaces (
     -- Mandatory
     interface_id serial PRIMARY KEY,			-- Network interface identifier
@@ -405,6 +405,7 @@ CREATE OR REPLACE VIEW view_interface_tags AS
 SELECT
 interface_tag.interface_tag_id,
 interface_tag.interface_id,
+interfaces.ip,
 tag_types.tag_type_id,
 tag_types.tagname,
 tag_types.description,
@@ -412,7 +413,8 @@ tag_types.category,
 tag_types.min_role_id,
 interface_tag.value
 FROM interface_tag
-INNER JOIN tag_types USING (tag_type_id);
+INNER JOIN tag_types USING (tag_type_id)
+INNER JOIN interfaces USING (interface_id);
 
 CREATE OR REPLACE VIEW view_interfaces AS
 SELECT