Author: echatellier Date: 2014-08-08 10:15:15 +0200 (Fri, 08 Aug 2014) New Revision: 498 Url: http://forge.codelutin.com/projects/faxtomail/repository/revisions/498 Log: Remove index between email and email group Removed: trunk/faxtomail-service/src/main/resources/db/migration/V1_0_0_492__add_emailGroup_emails_idx.sql Modified: trunk/faxtomail-persistence/src/main/xmi/faxtomail.properties trunk/faxtomail-persistence/src/main/xmi/faxtomail.zargo Modified: trunk/faxtomail-persistence/src/main/xmi/faxtomail.properties =================================================================== --- trunk/faxtomail-persistence/src/main/xmi/faxtomail.properties 2014-08-08 07:13:57 UTC (rev 497) +++ trunk/faxtomail-persistence/src/main/xmi/faxtomail.properties 2014-08-08 08:15:15 UTC (rev 498) @@ -86,6 +86,9 @@ com.franciaflex.faxtomail.persistence.entities.Email.attribute.mailFolder.tagvalue.notNull=true com.franciaflex.faxtomail.persistence.entities.Email.attribute.originalEmail.tagvalue.notNull=true +# EmailGroup +com.franciaflex.faxtomail.persistence.entities.EmailGroup.attribute.email.stereotype=unique + # History com.franciaflex.faxtomail.persistence.entities.History.attribute.type.tagvalue.notNull=true com.franciaflex.faxtomail.persistence.entities.History.attribute.fields.stereotype=unique Modified: trunk/faxtomail-persistence/src/main/xmi/faxtomail.zargo =================================================================== (Binary files differ) Deleted: trunk/faxtomail-service/src/main/resources/db/migration/V1_0_0_492__add_emailGroup_emails_idx.sql =================================================================== --- trunk/faxtomail-service/src/main/resources/db/migration/V1_0_0_492__add_emailGroup_emails_idx.sql 2014-08-08 07:13:57 UTC (rev 497) +++ trunk/faxtomail-service/src/main/resources/db/migration/V1_0_0_492__add_emailGroup_emails_idx.sql 2014-08-08 08:15:15 UTC (rev 498) @@ -1,6 +0,0 @@ -ALTER TABLE email ADD COLUMN emailgroup_idx ${indexType}; - -UPDATE email SET emailgroup_idx = ( - SELECT COUNT(topiaid) FROM email sub - WHERE sub.email = emailgroup.email AND (sub.topiacreatedate || sub.topiaid) < (emailgroup.topiacreatedate || emailgroup.topiaid) -); \ No newline at end of file