MySQL querys

[DWZ]

I am currently running a hack version of vB 2.2.5. I have decided to upgrade to 2.2.7 and have spent the last few hours adding all my hacks to the 2.2.7 code.

Now, I found a few hacks that I didn't think I really needed and thought I should remove. Some of these were easy, but others had directly changed the database with some MySQL querys. Now, i wanted to know if anyone here can help me reverse these MySQL queries.

The first one is from the proxy hack. In it, I had to run the query:ALTER TABLE post ADD proxyip VARCHAR(255) not null AFTER ipaddress;How can I reverse this? The next one is from the Random Quote On ForumHome hack, in which I had to run the query:CREATE TABLE quote (
id smallint(5) unsigned DEFAULT '0' NOT NULL auto_increment,
userid smallint(4) NOT NULL,
username varchar(255) NOT NULL,
artist varchar(255) NOT NULL,
line1 varchar(255) NOT NULL,
line2 varchar(255) NOT NULL,
ok char(1) NOT NULL default '',
PRIMARY KEY (id)
);


ALTER TABLE user ADD quotes smallint(5) DEFAULT '0'Again, how can I remove everything so it's like it was never there?

Thank you so much to anyone who can help!

Alan (DWZ)

[Issvar]

ALTER TABLE post DROP proxyip
DROP TABLE quote
ALTER TABLE user DROP quotes

[DWZ]

w00t :D

thank you so much!