Author: bleny Date: 2012-03-20 14:56:25 +0100 (Tue, 20 Mar 2012) New Revision: 1572 Url: http://forge.codelutin.com/repositories/revision/wao/1572 Log: Evolution #1007 Ajouter des index sur les cl?\195?\169s ?\195?\169trang?\195?\168res Modified: trunk/wao-business/src/main/java/fr/ifremer/wao/PostgresMigrationCallback.java trunk/wao-business/src/main/java/fr/ifremer/wao/WaoMigrationCallBack.java Modified: trunk/wao-business/src/main/java/fr/ifremer/wao/PostgresMigrationCallback.java =================================================================== --- trunk/wao-business/src/main/java/fr/ifremer/wao/PostgresMigrationCallback.java 2012-03-20 13:51:45 UTC (rev 1571) +++ trunk/wao-business/src/main/java/fr/ifremer/wao/PostgresMigrationCallback.java 2012-03-20 13:56:25 UTC (rev 1572) @@ -1114,4 +1114,23 @@ queries.add("UPDATE SampleRow SET code=REPLACE(code, '_', '_V') WHERE obsProgramOrdinal=1;"); queries.add("UPDATE SampleRow SET code=REPLACE(code, '_', '_D') WHERE obsProgramOrdinal=2;"); } + + @Override + protected void addAllMissingIndexesOnForeignKeys_3_3(List<String> queries) { + queries.add("CREATE INDEX idx_Boat_elligibleBoat ON elligibleBoat(boat); "); + queries.add("CREATE INDEX idx_Company_waoUser ON waoUser(company); "); + queries.add("CREATE INDEX idx_Contact_secondaryObservers ON contact_secondaryobservers(contact);"); + queries.add("CREATE INDEX idx_FishingZone_sampleRow ON fishingzone_samplerow(fishingZone); "); + queries.add("CREATE INDEX idx_Indicator_indicatorLevel ON indicatorLevel(indicator); "); + queries.add("CREATE INDEX idx_ObsDebCode_obsDebCodeDetails ON obsDebCodeDetails(obsDebCode); "); + queries.add("CREATE INDEX idx_SampleRow_sampleMonth ON sampleMonth(sampleRow); "); + queries.add("CREATE INDEX idx_SampleRow_sampleRowLog ON sampleRowLog(sampleRow); "); + queries.add("CREATE INDEX idx_SampleRow_elligibleBoat ON elligibleBoat(sampleRow); "); + queries.add("CREATE INDEX idx_SampleRow_fishingZone ON fishingzone_samplerow(sampleRow); "); + queries.add("CREATE INDEX idx_SampleRow_dCF5Code ON dcf5code_samplerow(sampleRow); "); + queries.add("CREATE INDEX idx_SampleRow_observers ON observers_samplerow(sampleRow); "); + queries.add("CREATE INDEX idx_WaoUser_userProfile ON userProfile(waoUser); "); + queries.add("CREATE INDEX idx_WaoUser_allegroWallet ON allegrowallet_waouser(waoUser); "); + queries.add("CREATE INDEX idx_WaoUser_canReadBoats ON canreadboats_waouser(waoUser); "); + } } Modified: trunk/wao-business/src/main/java/fr/ifremer/wao/WaoMigrationCallBack.java =================================================================== --- trunk/wao-business/src/main/java/fr/ifremer/wao/WaoMigrationCallBack.java 2012-03-20 13:51:45 UTC (rev 1571) +++ trunk/wao-business/src/main/java/fr/ifremer/wao/WaoMigrationCallBack.java 2012-03-20 13:56:25 UTC (rev 1572) @@ -621,10 +621,14 @@ migrateSampleRowCodes_3_3(queries); + addAllMissingIndexesOnForeignKeys_3_3(queries); + String[] strings = queries.toArray(new String[queries.size()]); executeSQL(tx, showSql, showProgression, strings); } + protected abstract void addAllMissingIndexesOnForeignKeys_3_3(List<String> queries); + protected abstract void migrateSampleRowCodes_3_3(List<String> queries); protected abstract void addWaoUserCguAccepted_3_3(List<String> queries);