well I took your guys advice, and tried writing an sql query with what you gave me, this is what I came up with, I didn't know if you shoudl put the ``` things in so I did, please let me know if this would work or not.
[SQL]ALTER TABLE `forum`.`user DROP `hp` INT(6) DEFAULT '0' NOT NULL, DROP `maxhp` INT(6) DEFAULT '0' NOT NULL, ADD `ma` INT(6) DEFAULT '0' NOT NULL, DROP `ma` INT(6) DEFAULT '0' NOT NULL, DROP `maxma` INT(6) DEFAULT '0' NOT NULL, DROP `pp` INT(6) DEFAULT '0' NOT NULL, DROP `maxpp` INT(6) DEFAULT '0' NOT NULL, DROP `ap` INT(6) DEFAULT '0' NOT NULL, DROP `element` INT(3) DEFAULT '0' NOT NULL; [/SQL]
EDIT: this didn't work

can someone give me a clear thing of what to do?