janus-ssp / janus

Fully featured metadata registration administration module built on top of simpleSAMLphp.
Other
13 stars 8 forks source link

Duplicate "type" column in both janus__connection and janus__connectionRevision #498

Closed surfnet-niels closed 10 years ago

surfnet-niels commented 10 years ago

Hi,

It seems the "Type" of entity is duplicate in both janusconnection and the janusconnectionRevision table. Given this now very simple data model this seem redundant and may lead to future errors. Is there a need to have the same thing in both places?

lucasvanlierop commented 10 years ago

It's currently used as part of a constraint to make sure each connection name is unique per type.