DROP VIEW node_snmp_v1v2_properties_v;
CREATE VIEW node_snmp_v1v2_properties_v AS select
  node_id, 
  version,
  snmp_timeout, 
  snmp_retries,
  snmp_community_ro, 
  snmp_community_rw,
  'filler1' AS snmp_user_name,
  1003 AS snmp_authentication_type,
  'filler2' AS snmp_auth_password,
  2002 AS snmp_privacy_type,
  'filler3' AS snmp_privacy_password
  from node_snmp_v1v2_properties;

DROP VIEW node_snmp_v3_properties_v;
CREATE VIEW node_snmp_v3_properties_v AS select
  node_id, 
  3 AS version,
  snmp_timeout,
  snmp_retries,
  'filler1' AS snmp_community_ro,
  'filler2' AS snmp_community_rw,
  snmp_user_name,
  snmp_authentication_type,
  snmp_auth_password,
  snmp_privacy_type,
  snmp_privacy_password
  from node_snmp_v3_properties;