The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Uninstalling queries
Quick question.
If we wish to get rid of a query, how do we uninstall it? |
#2
|
|||
|
|||
queries aren't installed, they are performed on a database to manipulate its data.
are you saying you ran a query and now want to reverse it? This depends on the query... what query did you run? |
#3
|
|||
|
|||
ALTER TABLE user ADD userloc varchar(250) NOT NULL [original]
I want to change it to ALTER TABLE user ADD userloc varchar(250) NOT NULL DEFAULT '0' |
#4
|
|||
|
|||
run the query ...
[SQL] ALTER TABLE user CHANGE userloc userloc VARCHAR(250) DEFAULT '0' NOT NULL [/SQL] that'll change that field for ya |
#5
|
|||
|
|||
Thanks so much for your help. it's working now.
|
#6
|
|||
|
|||
great to hear
your welcome |
#7
|
|||
|
|||
Sorry, apparently, the other query works better. How do I change it back to the initial query? Sorry for that.
|
#8
|
|||
|
|||
Like this
[sql] ALTER TABLE user CHANGE userloc userloc VARCHAR(250) NOT NULL [/sql] |
#9
|
|||
|
|||
Thanks so much. It really helped. My forums just opened yesterday and doing pretty well on its first day already. Thanks to you.
|
#10
|
|||
|
|||
glad I could help mate
|
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|