ALTER TABLE `useraccount` DROP INDEX `email`;
ALTER TABLE `useraccount` DROP INDEX `emailPassword`;
ALTER TABLE `useraccount` ADD COLUMN `groupEmail`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' AFTER `password`;
ALTER TABLE `useraccount` ADD COLUMN `groupEmailPassword`  varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' AFTER `groupEmail`;
ALTER TABLE `useraccount` ADD COLUMN `personalEmail`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' AFTER `groupEmailPassword`;
ALTER TABLE `useraccount` DROP COLUMN `email`;
ALTER TABLE `useraccount` DROP COLUMN `emailPassword`;
CREATE INDEX `personalEmail` ON `useraccount`(`personalEmail`) USING BTREE ;
CREATE INDEX `groupEmailPassword` ON `useraccount`(`groupEmailPassword`) USING BTREE ;
CREATE INDEX `groupEmail` ON `useraccount`(`groupEmail`) USING BTREE ;
