query to add field?

[vBR]

I need a query I can run in phpMyAdmin to add a new field to the moderator table.
name: cansuspenduser, default value: 0

Thanks.

[Floris]

Originally posted by vBR
I need a query I can run in phpMyAdmin to add a new field to the moderator table.
name: cansuspenduser, default value: 0

Thanks.

ALTER TABLE `moderator` ADD `cansuspenduser` SMALLINT DEFAULT '0' NOT NULL ;