Author: tchemit Date: 2013-12-12 15:23:53 +0100 (Thu, 12 Dec 2013) New Revision: 902 Url: http://forge.codelutin.com/projects/echobase/repository/revisions/902 Log: fixes #3852: Ajout de vues spatiales Modified: trunk/echobase-domain/src/main/java/fr/ifremer/echobase/persistence/migration/workingDb/MigrationCallBackForVersion2_5.java Modified: trunk/echobase-domain/src/main/java/fr/ifremer/echobase/persistence/migration/workingDb/MigrationCallBackForVersion2_5.java =================================================================== --- trunk/echobase-domain/src/main/java/fr/ifremer/echobase/persistence/migration/workingDb/MigrationCallBackForVersion2_5.java 2013-12-12 13:50:57 UTC (rev 901) +++ trunk/echobase-domain/src/main/java/fr/ifremer/echobase/persistence/migration/workingDb/MigrationCallBackForVersion2_5.java 2013-12-12 14:23:53 UTC (rev 902) @@ -359,7 +359,8 @@ " (Select SUM(totalsamplemicrpou.sampleweight) From totalsamplemicrpou Where totalsamplemicrpou.operation_id = echobase_operation_spatial.operationname) as TotalCatchMICRPOU,\n" + " (Select SUM(totalsamplescomsco.sampleweight) From totalsamplescomsco Where totalsamplescomsco.operation_id = echobase_operation_spatial.operationname) as TotalCatchSCOMSCO,\n" + " (Select SUM(totalsampletractru.sampleweight) From totalsampletractru Where totalsampletractru.operation_id = echobase_operation_spatial.operationname) as TotalCatchTRACTRU,\n" + - " echobase_operation_spatial.operationid;"); + " echobase_operation_spatial.operationid\n" + + "From echobase_operation_spatial;"); queries.add("DROP VIEW IF EXISTS cellmapview;"); queries.add("CREATE OR REPLACE VIEW cellmapview AS \n" +