CRVS: Server Version Bug

[ageryck]

On newly created updates on OpenSRP regarding server version as documented on this PR and this PR. There seems to be a bug where by the original migrated records had incrementing values of server version however newly entered records from OpenSRP Web do not seem to increment the value, it saves 0
See sample below from practitioners endpoint;

` {
        "identifier": "4840697e-8048-4c0b-9f51-5c11d57496ee",
        "active": true,
        "name": "crvs9 Trainer",
        "userId": "2ed0df4f-9105-4c48-9298-33264d834874",
        "username": "crvs9",
        "dateCreated": "2022-02-25T08:32:35.831Z",
        "dateEdited": "2022-02-25T08:32:35.831Z",
        "serverVersion": 0
    },`

[ageryck]

Found out that some of the entries did not migrate successfully and were indicating null in the database. Needs to review the Migration script in the above mentioned PR's.
Quick solution was to rerun the server version assignment on the database, we achieved that by a temp query below;

do $$
declare 
   counter integer := 0;
   
begin
   while counter < 48 loop  --SET COUNT TO max rows
      --******************
		begin	  
	  	UPDATE team.organization
		SET server_version = (SELECT nextval('team.organization_server_version_seq'))
		WHERE id = counter;
		end;
	  --******************
	  counter := counter + 1;
   end loop;
end$$;

[ageryck]

we equally validated that the endpoints works well and for new records the serverversion assignment is happening correctly