MySQL querys
 

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:[sql]ALTER TABLE post ADD proxyip VARCHAR(255) not null AFTER ipaddress;[/sql]How can I reverse this? The next one is from the Random Quote On ForumHome hack, in which I had to run the query:[sql]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'[/sql]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)

[sql]ALTER TABLE post DROP proxyip[/sql]
[sql]DROP TABLE quote[/sql]
[sql]ALTER TABLE user DROP quotes[/sql]

w00t :D

thank you so much!