Database: improvement of primary keys

all primary keys should be changed (to the newest PostgreSQL standard) from 
```SQL
id SERIAL PRIMARY KEY,
```
 to
```SQL
id INTEGER PRIMARY KEY GENERATED ALWAYS AS IDENTITY,
```
