Duplicate entry error after update e-mail address

[KasumiNinja]

I accidentally used the company (info) email address for a customer. Therefore I changed the customer username email address and customerid, and assigned all tickets to the new customerid. Now I want create a company with the previously used info address. However I get the following error message. Can I remove this previously use info address entirely?

Code: Select all

Duplicate entry 'email@address.com' for key 'PRIMARY', SQL: 'INSERT INTO customer_company ( customer_id , name , street , zip , city , country , url , comments , valid_id , create_time, create_by, change_time, change_by) VALUES ( 'email@address.com', 'Company Name', '', '', '', '', '', '', 1, '2013-07-10 20:18:18' , 2, '2013-07-10 20:18:18' , 2)'