making (or rather converting) a new hack, however... problem hehe - vb.org Archive

		vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > General > Member Archives
making (or rather converting) a new hack, however... problem hehe

Reply

Details »»

MOD Information

Edit Modification

Jump to Comments

The Developer

About Developer

Version: , by LoB (Guest)
Developer Last Online:

Show Printable Version

Email this Page

Version: Unknown			Rating:
Released: 08-27-2001	Last Update: Never		Installs: 0


No support by the author.

how do you add a new column to a database when it contains data, for the hack to work there needs to be an extra field in the user table

Show Your Support

If you like to thanks you by the author -> Click Thanks to the Author
This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments

#2

Old

08-29-2001, 02:32 PM

LoB

Guest

Posts: n/a

Default

bump
urgent

Reply With Quote

#3

Old

08-29-2001, 11:25 PM

Salkiri

Salkiri is offline

Join Date: Sep 2002

Posts: 3

Благодарил(а): 0 раз(а)

Поблагодарили: 0 раз(а) в 0 сообщениях

Default

Here is the SQL statement that will add newcolumn after lastcolumn

ALTER TABLE user ADD newcolumn smallint(6) DEFAULT '1' NOT NULL AFTER lastcolumn

Reply With Quote

Reply

« Previous Thread | Next Thread »

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Forum Rules

Forum Jump

All times are GMT. The time now is 02:36 AM.