how to create custom user fields with code?

[almannai]

Thanks guys that is really a great input..

I think this should work for a text box field <<not sure though
$vbulletin->db->query("ALTER TABLE " . TABLE_PREFIX . "user ADD mynewfield MEDIUMTEXT DEFAULT 'mytxt' NOT NULL");

If that is not correct please advice..

But my real need is to add a single select dropdown list as a custom userfield in the install code. Anybody can help on this?

Regards,