php forum
php mysql forum
php mysql smarty
 
Topic Options
#262348 - 11/07/03 05:58 PM ALTER TABLE
Guru Offline
Lurker

Registered: 11/07/03
Posts: 1

   ALTER TABLE to Del.icio.us Add to del.icio.us
  Digg ALTER TABLE Digg it
[] ALTER TABLE nuke_modules ADD mcid int(11) NOT NULL default '1'; [/] <br /><br />whats the fuction of this command? and how can i deactivate this command

Top
#262349 - 11/07/03 06:37 PM Re: ALTER TABLE [Re: mototog]
dimopoulos Offline
Kahuna

Registered: 08/18/02
Posts: 1271
Loc: Vienna, Austria
This command is run against your database using shell access and mysql directly or a tool like phpMyAdmin and a web interface.<br /><br />It will ALTER the table nuke_modules and it will ADD the column mcid of type Integer with max length 11 digits which cannot be null and if not specified in an insert query it will always get assigned the value 1.<br /><br />This command is run only by install/upgrade scripts. You either don't run it (if you are doing manually things) or alter the script that has the command.<br /><br />It might fail because the field already exists.<br /><br />BTW: Which part of .threads you saw that? To my knowledge there is no modules table assuming that your prefix is nuke. Is this a custom modification or an addon?
_________________________
Nikos

Top
#262350 - 11/08/03 04:50 AM Re: ALTER TABLE [Re: Hal_dup2]
Astaran Offline
Addict

Registered: 12/21/00
Posts: 1545
Loc: Germany
It seems to be a post nuke query.
_________________________
Running a community? -> Keep informed and take it to the next level

Top


Top Posters Last 30 Days
AllenAyres 13
Gizmo 10
willing 2
S7ARBVCK 2
MattUK 1
Kevin H 1
tackaberry 1
Who's Online
1 Registered (Gizmo), 31 Guests and 10 Spiders online.
Key: Admin, Global Mod, Mod
Shout Box

Latest Posts
Noob - need help, or a reality check!
by Gizmo
Yesterday at 03:21 AM
Here I am! Rock me like a Hurricane!
by AllenAyres
09/02/08 03:05 PM
[7.x] Generic Page Outside of forum directory
by Gizmo
08/30/08 05:43 PM
Team UBBDev Rides Again!
by Gizmo
08/28/08 11:45 PM
Multiple Identity Detector
by MattUK
08/28/08 04:10 PM
[7.3.x] ubb.links
by AllenAyres
08/26/08 09:57 AM
Installing FlashChat with 7.3
by Gizmo
08/23/08 05:36 AM
New Mods
Installing FlashChat with 7.3
by Paug
08/23/08 12:14 AM
[7.3.x] ubb.links
by AllenAyres
06/20/08 11:50 PM
[7.2.1] - Naked shoutbox
by sirdude
08/17/07 10:36 PM
[7.x] Generic Page Outside of forum directory
by
01/14/07 10:58 PM
Multiple Identity Detector
by
12/30/06 06:39 PM
Newest Members
veedubb8, twentyseven, Claus1, welcomeback1, Paug
13327 Registered Users

 

 

 
fusionbb message board php hacks