-- add column prov_server
BEGIN;

CREATE or REPLACE FUNCTION  add_prov_server() RETURNS integer AS '
  BEGIN
    IF SPLIT_PART(VERSION(), '' '', 2) = ''7.4.7''
    THEN
      alter table network add column prov_server varchar(15);
      update network set prov_server = '''' where prov_server is null;
      alter table network alter prov_server set default '''';
      alter table network alter prov_server set not null;
    ELSE
      alter table network add column prov_server varchar(15) not null default '''';
    END IF;
    RETURN 0;
  END;
' LANGUAGE plpgsql;

select add_prov_server(); 
      
DROP FUNCTION add_prov_server();
COMMIT;


