the command line can be a bit tricky and time consuming if you are not familiar with it. I always use HeidiSQL which is a gui frontend to mysql.
this might be helpful to you if you want to do it on the command line:
Type mysql -uroot -p
Hit enter and enter your password. (Hit enter again)
You should now see a prompt that looks like this: (along with "Welcome" text before it)
mysql>_
Type the following (in order):
use peq (Or whichever name you used for your database. Hit enter and you will see a short note saying "Database changed")
Then type the following:
ALTER TABLE `botbuffs` ADD COLUMN `CorruptionCounters` INT(11) UNSIGNED NOT NULL DEFAULT '0' AFTER `CurseCounters`;(when this is done, you will be back at the mysql>_ prompt)
then type this:
ALTER TABLE `bots` ADD COLUMN `Corrup` SMALLINT(5) NOT NULL DEFAULT '0' AFTER `PR`;
|