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

[Logician]

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

[Admin]

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.

[Logician]

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