basically i want to run these queries, to do the oppisite of what they are doing now ....

i want to remove these entires from my database...
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);

The only one giving me problems is this
ALTER TABLE attachment add index (usedin,itemid);

I dont know what/where usedin, itemid are located or if they are needed for the table to function.

if it's for a mod then just look at the uninstall code.

there is no uninstall code ... i had to manually run the queries.

i dont know what this means
(usedin,itemid)
I have deleted the first 3 tables, of which includes those beforementioned tables....
so why need 4 queries for 3 tables?

what version of vb do you run, You can look in your install file for the table setup.

3.5.4

which install file??
the install file (as i understand it) is a text file telling me what to do, and giving me those queries to run through vB or phpmyadmin.

am i right in assuming that ALTER TABLE attachment add index (usedin,itemid);
means, "to the table 'attachment' add the (rows?tables?) 'index' to BOTH usedin and itemid." ??

The install file is the vBulletin Install file, there is a file which contains the queries needed to make the vB tables.

should work...

Damn beat me to it :p
I suppose paintball was better anyway :p

ya im pretty sure when i deleted those two tables (usedin, itemid) it also removed the table index, as that was inside of usedin and itemid

rogers .... paintball was the better choice indeed.

lol, it is indeed a better choice :p

yeh the index's would've been dropped when you dropped them 2 columns