Enforcing email_address to be unique

[datasponge]

Is there a file I can edit to force the email_address (actually email_address_caps) to be enforced by the database as unique?

When someone opts out, I want to make sure there is not a second identical email anywhere in sugar that would also need to be marked. The underlying email_addresses table (by default) has these fields as keys but not unique. In my experience, changes to the underlying tables get restored to settings defined in the php pages when you repair Sugar, so I need to figure out what php file controls this so the change can be retained.

From my (minimal) testing Sugar does a good job matching an email added through the interface to not create a duplicate, but I don't know how import behaves and I'm also importing records directly to MySQL in some cases, so I really want the security of the database enforcing uniqueness.

This is important as in the US you can be sued for sending a bulk email to someone who has opted out.

Also, because of the importance of this, I'd like to be able to record the email to a log including the date someone opted out. There is currently no way to audit email address changes in 5.0b, so I can't even save the date opt_out was selected. What is a good creative way to implement this without auditing? For example how can I add an html link to an external tool that presents it own screens to collect data and writes to a log table all the key info about an opt_out?

Since Email Addresses isn't really a visible module I haven't really figured out how to work with it yet. Any advice is appreciated on this.

Thanks

Phil

[andopes]

Hi, Phil

Just create an extended vardefs for the EmailAddresses with this content:

 $dictionary['email_addresses']['indices'][] = array(
    'name'            => 'email_addressesuniq',
    'type'            => 'unique',
    'fields'        => array('email_address')
); 
  

After that quick repair and rebuild

Cheers

[Denzel]

Hi,

i have the same problem. Added a new field to Contact. Added the uinique-index. Now the problem is: When i add a value to a Contact that i added to an other Contact, i get a mysql-error. The field is not checked by Sugar before the Contact gets saved How do i get this unique-field checked before Sugar tries to save the Contact?

Greetings, Dennis