Database setup: extensions and migrations up

[traveller195]

Database setup: extensions and migrations up compare:

https://github.com/colouring-cities/colouring-dresden/blob/main/migrations/README.md

[traveller195]

done: login via psql

psql "host={hostname} user={username} port={port} sslmode=require dbname=postgres"

dbname 'dresdendb' already exists

check extensions:

> create extension postgis;
> create extension pgcrypto;
> create extension pg_trgm;

navigat to /migrations ls ./*.up.sql 2>/dev/null | while read -r migration; do psql < $migration; done;

[traveller195]

take care, that after inserting buildings and geometries data... the INDEX must be calculated again (first .down.sql , after .up.sql)

see https://github.com/colouring-cities/colouring-dresden/issues/20