Author: bleny Date: 2014-05-19 14:39:04 +0200 (Mon, 19 May 2014) New Revision: 1962 Url: http://forge.codelutin.com/projects/wao/repository/revisions/1962 Log: fixes #5106 change some logins and add constraint Modified: trunk/wao-persistence/src/main/resources/db/migration/V4_0__clean_database.sql Modified: trunk/wao-persistence/src/main/resources/db/migration/V4_0__clean_database.sql =================================================================== --- trunk/wao-persistence/src/main/resources/db/migration/V4_0__clean_database.sql 2014-05-19 12:00:44 UTC (rev 1961) +++ trunk/wao-persistence/src/main/resources/db/migration/V4_0__clean_database.sql 2014-05-19 12:39:04 UTC (rev 1962) @@ -10,3 +10,12 @@ and eb.topiaId not in (select eb2.topiaId from elligibleboat eb2 where eb2.boat = eb.boat and eb2.sampleRow = eb.sampleRow order by topiacreatedate desc limit 1)); alter table elligibleboat add constraint samplerow_boat_uniqueness unique (boat, samplerow); + +-- Doublons dans la table wao user + +update waouser +set login = login || '2' +where login in (select login from waoUser group by login having count(topiaId) > 1) + and company='fr.ifremer.wao.entity.Company#1264666646342#0.19971470116106205' + +alter table waouser add constraint login_uniqueness unique (login);