Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: email_list_subscribersemail_list_subscribers
Do you really want to
ALTER TABLE `email_list_subscribers` DROP PRIMARY KEY, ADD PRIMARY KEY(`confirmcode`) ?