I deleted the email_addresses table - can I simply rebuilt it

[PeterBowen]

I'm an idiot I know. I was clearing out a pile of test data and accidentally deleted the email_addresses table.

I have not opened sugarcrm since deleting the table (if that is of any relevance?).

If worst comes to worst I could reinstall the entire system but I would prefer not to do that as I don't want to lose the other stuff on the same database.

Can I simply rebuild the table? If the answer is yes, where can I find the sql query for doing so or definitions for the fields and table?

Thanks in advance.

I'll get back to beating myself up

EDIT:I found the table paramaters in email_addressesMetaData.php

[andopes]

Hi Pit

You can go to Admin -> Repair -> Repair Database.
It will recreate the missed tables and fields.

Cheers

[PeterBowen]

Just did it but it gave this error

Executing repair query: Query Failed:CREATE TABLE email_addresses (id char(36) NOT NULL ,email_address varchar(255) NOT NULL ,email_address_caps varchar(255) NOT NULL ,invalid_email bool DEFAULT '0' NULL ,opt_out bool DEFAULT '0' NULL ,date_created datetime NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL , PRIMARY KEY (id), KEY idx_ea_caps_opt_out_invalid (email_address_caps, opt_out, invalid_email), KEY idx_ea_opt_out_invalid (email_address, opt_out, invalid_email)) CHARACTER SET utf8 COLLATE utf8_general_ci::MySQL error 1050:

Edit - I had phpMyAdmin open so maybe that was the problem. Anyway I just ran the query in phpMyAdmin and it looks like it worked.

Thanks for the quick reply - I am planning on migrating over the weekend and really didn't need this in my life.



Pete