Adding a new column to a vb table. How you done that before?
 

Hey there,

I am planning to add a new column to some vb tables. I will of course assign them a default value (eg. NULL) so that existing sql queries in vb code wont produce any errors but I still cant be sure if this mess things up or not?

Have you ever added a column to a vb table before? Will I be safe if I assign the column a default value? I dont want to go through all .php files and update the existing vb queries.

Thanks in advance..

Regards,
Logician

It should be fine. But I suggest you create the column as NOT NULL, then give it a default value (i.e DEFAULT "0").
The only queries I know in vB that don't use a field list are in register.php and member.php, where it inserts stuff into the useractivation table, but since no one touches that table it doesn't really matter.

ok got it, thx. It would be really arduous otherwise :)