Eli Mesika has uploaded a new change for review. Change subject: core: [db] removing unsued InsertVds SP ......................................................................
core: [db] removing unsued InsertVds SP This patch removes the unused InsertVds SP. Change-Id: Ie6f019efdabb66d295ef5968203a193668655a6d Signed-off-by: Eli Mesika <[email protected]> --- M packaging/dbscripts/vds_sp.sql 1 file changed, 0 insertions(+), 65 deletions(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/95/20695/1 diff --git a/packaging/dbscripts/vds_sp.sql b/packaging/dbscripts/vds_sp.sql index fbf9aea..c777cc2 100644 --- a/packaging/dbscripts/vds_sp.sql +++ b/packaging/dbscripts/vds_sp.sql @@ -677,71 +677,6 @@ END; $procedure$ LANGUAGE plpgsql; - - - - - - -Create or replace FUNCTION InsertVds( - v_vds_id UUID, - v_host_name VARCHAR(255), - v_free_text_comment text, - v_ip VARCHAR(40) , - v_vds_unique_id VARCHAR(128) , - v_port INTEGER, - v_vds_group_id UUID, - v_vds_name VARCHAR(255), - v_server_SSL_enabled BOOLEAN , - v_vds_type INTEGER, - v_vds_strength INTEGER, - v_pm_type VARCHAR(20) , - v_pm_user VARCHAR(50) , - v_pm_password VARCHAR(50) , - v_pm_port INTEGER , - v_pm_options VARCHAR(4000) , - v_pm_enabled BOOLEAN, - v_pm_proxy_preferences VARCHAR(255), - v_pm_secondary_ip VARCHAR(255), - v_pm_secondary_type VARCHAR(20), - v_pm_secondary_user VARCHAR(50), - v_pm_secondary_password text, - v_pm_secondary_port INTEGER, - v_pm_secondary_options VARCHAR(4000), - v_pm_secondary_concurrent BOOLEAN, - v_vds_spm_priority INTEGER, - v_console_address VARCHAR(255), - v_ssh_port INTEGER, - v_ssh_username VARCHAR(255)) -RETURNS VOID - AS $procedure$ -BEGIN - - BEGIN - INSERT INTO vds_static(vds_id,host_name, free_text_comment, ip, vds_unique_id, port, ds_group_id, vds_name, server_SSL_enabled, - vds_type,vds_strength,pm_type,pm_user,pm_password, pm_port, pm_options, pm_enabled, - pm_secondary_ip, pm_secondary_type, pm_secondary_user, - pm_secondary_password, pm_secondary_port, pm_secondary_options, pm_secondary_concurrent, - pm_proxy_preferences, vds_spm_priority, console_address, ssh_port, ssh_username) - VALUES(v_vds_id,v_host_name, v_free_text_comment, v_ip, v_vds_unique_id, v_port, v_vds_group_id, v_vds_name, v_server_SSL_enabled, - v_vds_type, v_vds_strength,v_pm_type,v_pm_user,v_pm_password,v_pm_port, v_pm_options, v_pm_enabled, - pm_secondary_ip, pm_secondary_type, pm_secondary_user, - pm_secondary_password, pm_secondary_port, pm_secondary_options, pm_secondary_concurrent,v_pm_proxy_preferences, - v_vds_spm_priority, v_console_address, v_ssh_port, v_ssh_username); - - INSERT INTO vds_dynamic(vds_id, status) VALUES(v_vds_id, 0); - - INSERT INTO vds_statistics(vds_id) VALUES(v_vds_id); - END; - - RETURN; -END; $procedure$ -LANGUAGE plpgsql; - - - - - Create or replace FUNCTION DeleteVds(v_vds_id UUID) RETURNS VOID AS $procedure$ -- To view, visit http://gerrit.ovirt.org/20695 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: Ie6f019efdabb66d295ef5968203a193668655a6d Gerrit-PatchSet: 1 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Eli Mesika <[email protected]> _______________________________________________ Engine-patches mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/engine-patches
