Mysql Does Not Permit Users To Purchase Multiple Accounts

I want to permit MULTIPLE accounts for members.

My site currently does not permit members to have more that one account.

I want to change this to PERMIT multiple accounts.
Accounts are based on the users email address.
When a duplicate email address is input. I get this response…
“Duplicate entry ‘[email protected]’ for key 2”

Code snipit from my database;
“”PRIMARY KEY (`id`),

UNIQUE KEY `email` (`email`)””

Can I just change the word `email` (`email`) to `YES` (`YES`)?

The correction must not corrupt or disrupt my current system in any way.

I would like to be able to fix this myself if I knew what to edit from phpmyadmin if that is possible. If not I will need complete comprehensive documentation on what changes were made in case I want to undo and revert back to single accounts only.

Thank you for looking and or bidding on my project.

Leave a Reply

Your email address will not be published. Required fields are marked *