This took me quite a while to find. Here is the query to use in MySql to create the search table in VBulletin. To find the code to create other tables in VBulletin database go to your VB upload files to: install/mysql-schema.php
This was in response to an INVALID SQL error in VB 4.0 where “domainname” is the name of your website url:
MySQL Error : Table ‘domainname.search’ doesn’t exist
Error Number : 1146