Author: bleny Date: 2014-07-29 18:12:43 +0200 (Tue, 29 Jul 2014) New Revision: 2183 Url: http://forge.codelutin.com/projects/wao/repository/revisions/2183 Log: refs #4481 store postal codes as String Modified: trunk/wao-persistence/src/main/resources/db/migration/V4_1__clean_database.sql trunk/wao-persistence/src/main/xmi/wao-model.zargo Modified: trunk/wao-persistence/src/main/resources/db/migration/V4_1__clean_database.sql =================================================================== --- trunk/wao-persistence/src/main/resources/db/migration/V4_1__clean_database.sql 2014-07-29 16:05:17 UTC (rev 2182) +++ trunk/wao-persistence/src/main/resources/db/migration/V4_1__clean_database.sql 2014-07-29 16:12:43 UTC (rev 2183) @@ -140,3 +140,9 @@ ALTER TABLE Boat ALTER COLUMN immatriculation TYPE TEXT; ALTER TABLE Boat RENAME COLUMN immatriculation TO registrationCode; + +-- Les codes postaux ne peuvent être représentés sous forme d'entiers + +ALTER TABLE BoatInfos ALTER COLUMN contactPostalCode TYPE TEXT; +ALTER TABLE Company ALTER COLUMN postalCode TYPE TEXT; + Modified: trunk/wao-persistence/src/main/xmi/wao-model.zargo =================================================================== (Binary files differ)