everything works..except no npc's? help appreciated

[Kintudo]

i setup today using 0.60-Dr1 precompiled.
followed everything as stated on the guides.
Everything runs fine..doors ,zones..etc.
No errors except the failed to load npc. bad query.
ive checked for hours on the message boards..and only see something about a change in the database..yet I have not been able to figure out how to add it.
suggestions welcome.
Thanks

No errors except the failed to load npc. bad query.
ive checked for hours on the message boards..and only see something about a change in the database..yet I have not been able to figure out how to add it.
suggestions welcome.
Thanks

You run the command in mysql.

[Kintudo]

yes ive learned that..but what is the command to alter a table..i keep getting wrong syntax.

[Kintudo]

Ok i used the
ALTER TABLE `npc_types` ADD `AC` smallint(5) not null default 0;

however i then get this message back....
ERROR 1060: Dduplicate column name `AC`

so any suggestions what step to take next?

Thanks