Liron Aravot has uploaded a new change for review. Change subject: db: add logical_name to vm_device ......................................................................
db: add logical_name to vm_device Change-Id: If9b5a8e771a05c1fe44834adfe998cf921f6ae52 Signed-off-by: Liron Aravot <[email protected]> --- M packaging/dbscripts/create_views.sql M packaging/dbscripts/vm_device_sp.sql 2 files changed, 10 insertions(+), 5 deletions(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/72/31672/1 diff --git a/packaging/dbscripts/create_views.sql b/packaging/dbscripts/create_views.sql index d0bdcb3..3c34ec8 100644 --- a/packaging/dbscripts/create_views.sql +++ b/packaging/dbscripts/create_views.sql @@ -1571,7 +1571,7 @@ CREATE OR REPLACE VIEW vm_device_view AS SELECT device_id, vm_id, type, device, address, boot_order, spec_params, - is_managed, is_plugged, is_readonly, alias, custom_properties, snapshot_id + is_managed, is_plugged, is_readonly, alias, custom_properties, snapshot_id, logical_name FROM vm_device; -- Permissions on VNIC Profiles diff --git a/packaging/dbscripts/vm_device_sp.sql b/packaging/dbscripts/vm_device_sp.sql index e711755..63ca74f 100644 --- a/packaging/dbscripts/vm_device_sp.sql +++ b/packaging/dbscripts/vm_device_sp.sql @@ -14,7 +14,8 @@ v_is_readonly boolean, v_alias varchar(255), v_custom_properties text, - v_snapshot_id uuid) + v_snapshot_id uuid, + v_logical_name varchar(30)) RETURNS VOID AS $procedure$ BEGIN @@ -31,7 +32,8 @@ is_readonly, alias, custom_properties, - snapshot_id) + snapshot_id, + logical_name) VALUES( v_device_id , v_vm_id , @@ -45,7 +47,8 @@ v_is_readonly, v_alias, v_custom_properties, - v_snapshot_id); + v_snapshot_id, + v_logical_name); END; $procedure$ LANGUAGE plpgsql; @@ -62,7 +65,8 @@ v_is_readonly boolean, v_alias varchar(255), v_custom_properties text, - v_snapshot_id uuid) + v_snapshot_id uuid, + v_logical_name varchar(30)) RETURNS VOID AS $procedure$ BEGIN @@ -79,6 +83,7 @@ alias = v_alias, custom_properties = v_custom_properties, snapshot_id = v_snapshot_id, + logical_name = v_logical_name, _update_date = current_timestamp WHERE device_id = v_device_id and vm_id = v_vm_id; END; $procedure$ -- To view, visit http://gerrit.ovirt.org/31672 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: If9b5a8e771a05c1fe44834adfe998cf921f6ae52 Gerrit-PatchSet: 1 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Liron Aravot <[email protected]> _______________________________________________ Engine-patches mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/engine-patches
