The Arcive of vBulletin Modifications Site.

Dribbles · #1 02-17-2003, 04:35 PM

I added a mod which made some new columns in my MySQL database under the field User. I am uninstalling the mod. How do I delete those columns? thnx (columns = pettype, petname, and petgender

Xenon · #2 02-17-2003, 04:50 PM

install phpmyadmin and delete em manually..

mr e · #3 02-17-2003, 05:50 PM

[sql]ALTER TABLE user DROP pettype, DROP petname, DROP petgender[/sql]

Dribbles · #4 02-17-2003, 06:21 PM

thnx for the help, mr e

Just curious, do the extra columns slow down the forum performance any?

mr e · #5 02-17-2003, 06:41 PM

i doubt 3 columns would slow it down a noticable amount

Dribbles · #6 02-17-2003, 06:42 PM

thnx man

I'll be installing the RPG hack by bitsy soon ... so I'm gonna be probably adding 50 tables

Bitsys · #7 02-17-2003, 07:05 PM

Quote:

Originally posted by Dribbles
thnx man I'll be installing the RPG hack by bitsy soon ... so I'm gonna be probably adding 50 tables

Well, its not quite that bad. Only 15 new tables and some modifications to the user table

Dribbles · #8 02-18-2003, 07:37 PM

hehe