[djbaxter]

Oh, and if you are using a table prefix, that needs to be prepended to the SQL statement:

ALTER TABLE {TABLE-PREFIX}user DROP receivebulletin;
ALTER TABLE {TABLE-PREFIX}user DROP INDEX receivebulletin;
ALTER TABLE {TABLE-PREFIX}user DROP receivebulletin_type;

ReplaceE {TABLE-PREFIX} with your actual prefix.