Upgrade script database 0.5 -> 0.6

[bertt]

Create update script database from 0.5 to 0.6 for existing databases

[justb4]

Question: I am upgrading our GOST DB to work with latest GOST server (Docker). Have applied this script:
https://github.com/Geonovum/smartemission/blob/master/database/upgrades/upgrade3.sql
seems ok, but have the geojson columns for existing records be filled explicitly?

[justb4]

Ok, appears that only new records have the geojson field populated:

So the upgrade script needs to be extended IMO. Typical JSON structure is

{"type": "Point", "coordinates": [5.671321, 51.472583]}

[justb4]

I successfully applied this upgrade script:
https://github.com/Geonovum/smartemission/blob/master/database/upgrades/upgrade3.sql, the essence is to fill the geojson column like:

UPDATE v1.location SET geojson = concat('{"type": "Point", "coordinates": [' || ST_X(location) || ', ' ||  ST_Y(location) || ']}')::jsonb;

Possibly there is a cleaner way using the new json PG-functions but this worked on PG-PostGIS 9.4-2.1.