Author: echatellier Date: 2014-08-12 17:01:33 +0200 (Tue, 12 Aug 2014) New Revision: 527 Url: http://forge.codelutin.com/projects/faxtomail/repository/revisions/527 Log: Move index queries to migration script Added: trunk/faxtomail-service/src/main/resources/db/migration/V1_0_0_520__add_performance_indexes.sql Removed: trunk/faxtomail-persistence/src/main/resources/important-indexes.sql Deleted: trunk/faxtomail-persistence/src/main/resources/important-indexes.sql =================================================================== --- trunk/faxtomail-persistence/src/main/resources/important-indexes.sql 2014-08-12 14:40:47 UTC (rev 526) +++ trunk/faxtomail-persistence/src/main/resources/important-indexes.sql 2014-08-12 15:01:33 UTC (rev 527) @@ -1,25 +0,0 @@ -CREATE INDEX email_receptionDate_idx ON email (receptionDate ASC); -CREATE INDEX email_archiveDate_idx ON email (archiveDate NULLS FIRST); -CREATE INDEX email_mailFolder_idx ON email (mailFolder); -CREATE INDEX email_demandStatus_idx ON email (demandStatus); - -CREATE INDEX email_takenBy_idx ON email(takenBy); -CREATE INDEX email_client_idx ON email(client); ---CREATE INDEX email_emailGroup_idx ON email(emailGroup); -CREATE INDEX email_etatAttente_idx ON email(etatAttente); -CREATE INDEX email_priority_idx ON email(priority); -CREATE INDEX email_demandType_idx ON email (demandType); - -CREATE INDEX demandType_fields_OWNER_idx ON demandType_fields (OWNER); ---CREATE INDEX rangeRow_email_idx ON rangeRow(email); -CREATE INDEX rangeRow_range_idx ON rangeRow(range); ---CREATE INDEX history_email_idx ON history(email); -CREATE INDEX history_faxToMailUser_idx ON history(faxToMailUser); -CREATE INDEX history_fields_OWNER_idx ON history_fields(OWNER); ---CREATE INDEX reply_email_idx ON reply(email); ---CREATE INDEX attachment_email_idx ON attachment(email); - - -CREATE INDEX mailfolder_readrightusers_readRightUsers_idx ON mailfolder_readrightusers(readRightUsers); -CREATE INDEX mailfolder_readrightgroups_readRightGroups_idx ON mailfolder_readrightgroups(readRightGroups); - Added: trunk/faxtomail-service/src/main/resources/db/migration/V1_0_0_520__add_performance_indexes.sql =================================================================== --- trunk/faxtomail-service/src/main/resources/db/migration/V1_0_0_520__add_performance_indexes.sql (rev 0) +++ trunk/faxtomail-service/src/main/resources/db/migration/V1_0_0_520__add_performance_indexes.sql 2014-08-12 15:01:33 UTC (rev 527) @@ -0,0 +1,18 @@ +CREATE INDEX email_receptionDate_idx ON email(receptionDate ASC); +CREATE INDEX email_archiveDate_idx ON email(archiveDate NULLS FIRST); +CREATE INDEX email_mailFolder_idx ON email(mailFolder); +CREATE INDEX email_demandStatus_idx ON email(demandStatus); + +CREATE INDEX email_takenBy_idx ON email(takenBy); +CREATE INDEX email_client_idx ON email(client); +CREATE INDEX email_etatAttente_idx ON email(etatAttente); +CREATE INDEX email_priority_idx ON email(priority); +CREATE INDEX email_demandType_idx ON email(demandType); + +CREATE INDEX demandType_fields_OWNER_idx ON demandType_fields(OWNER); +CREATE INDEX rangeRow_range_idx ON rangeRow(range); +CREATE INDEX history_faxToMailUser_idx ON history(faxToMailUser); +CREATE INDEX history_fields_OWNER_idx ON history_fields(OWNER); + +CREATE INDEX mailfolder_readrightusers_readRightUsers_idx ON mailfolder_readrightusers(readRightUsers); +CREATE INDEX mailfolder_readrightgroups_readRightGroups_idx ON mailfolder_readrightgroups(readRightGroups);