[Mapbender-dev] double entries in layer_style & layer_epsg in 2.4.2rc1 dump, primary keys, svn

[Samson, Marko]

Hi devs,

I try to create a new up-to-date database diagramm with dbdesigner4 at the moment. In the process I realised, that the tables layer_style and layer_epsg have no primary-key and have some double entries(dump from 2.4.2rc1 for postgres-utf8).
Is there a reason for double entries and missing pks? (or did we forget the pks for those tables, last time we had the discusson about pks?)

select fkey_layer_id, name, count(*) from layer_style group by fkey_layer_id, name having count(*) >1

select fkey_layer_id, epsg, count(*) from layer_epsg group by fkey_layer_id, epsg having count(*) >1

What about primary keys:

pk_layer_style (fkey_layer_id, name)

pk_layer_epsg (fkey_layer_id,epsg)

Btw.
Perhaps it would be possible to save this or another diagramm at the svn to have an up-to-date diagramm at every time? But we should have an agreement for a standard db-tool or a file-format. (dbdesigner can export to mdb-xml, sql and his own xml-format)
What do you think?

Greetings,
Marko Samson


Marko Samson
Landesbetrieb Wald und Holz NRW
GIS-Anwendungsentwicklung
Referat I-5
Albrecht-Thaer-Straße 34
48147 Münster

Tel.: 0251/91797 - 169
Mail: marko.samson at wald-und-holz.nrw.de