Author: bleny Date: 2014-06-05 09:36:43 +0200 (Thu, 05 Jun 2014) New Revision: 1994 Url: http://forge.codelutin.com/projects/wao/repository/revisions/1994 Log: in migration affect sample row without company to 'admin' 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-06-04 14:29:43 UTC (rev 1993) +++ trunk/wao-persistence/src/main/resources/db/migration/V4_0__clean_database.sql 2014-06-05 07:36:43 UTC (rev 1994) @@ -22,3 +22,9 @@ -- On mesure les navires en centimètres et non plus en mètres update boat set boatlength = boatlength * 100; + +-- Une ligne sans société : on l'affecte à la société 'ADMIN' + +update sampleRow set company=(select topiaId from company where name='ADMIN') where company is null; + +