diff --git a/packaging/dbscripts/vds_sp.sql b/packaging/dbscripts/vds_sp.sql index fbf9aea..c37c5a7 100644 --- a/packaging/dbscripts/vds_sp.sql +++ b/packaging/dbscripts/vds_sp.sql @@ -718,15 +718,15 @@ RETURNS VOID 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, + INSERT INTO vds_static(vds_id,host_name, free_text_comment, ip, vds_unique_id, port, vds_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_pm_secondary_ip, v_pm_secondary_type, v_pm_secondary_user, + v_pm_secondary_password, v_pm_secondary_port, v_pm_secondary_options, v_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);