Help with a db query please

[bashy]

Hi

I had the PM Attachments installed but as it never worked i have decided to uninstall it.
No since doing this i am geting db errors, such as below

When i installed the hack i had to run the following queries

ALTER TABLE attachment add usedin varchar(30) not null;
ALTER TABLE attachment add itemid int not null;
ALTER TABLE pmtext add attach int not null;
ALTER TABLE attachment add index (usedin,itemid);

Now in the instructions there is no advice as to uninstalling the hack nor removing the said queries, it looks like my db error is something to do with the said queries as well.

Can anyone advise on how to undo what the queries did please?

  Database error in vBulletin 3.6.4:
   
  Invalid SQL:
   
        SELECT userid,itemid,usedin
        FROM attachment AS attachment
        WHERE attachmentid = 3920;
   
  MySQL Error  : Unknown column 'itemid' in 'field list'
  Error Number : 1054
  Date         : Sunday, March 25th 2007 @ 04:41:36 PM
  Script       : http://www.bashys-place.com/forums/a...0&d=1174816559
  Referrer     : http://www.bashys-place.com/forums/s...ad.php?t=20049