Add new/custom vb tables

[ptmuldoon]

I'm learning/experimenting at creating a new mod for vb, and have a little bit of php experience, and just learned how to add new menu items to admin_cp.

But now I want to learn how to add/create new tables to include my vbulletin database. I looked through the installation directory, and have seen the below being used to create the initial tables

PHP Code:

$schema['CREATE']['query']['mycustomtable'] = "
CREATE TABLE " . TABLE_PREFIX . "mycustomtable (
    column_1 INT UNSIGNED NOT NULL DEFAULT '0',
    column_2 SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    columns_3 SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    PRIMARY KEY column_1 (column_1, column_2)
)
"; 


I've also been searching and learning about vb database class used to run various queries. Can anyone point me towards a simple howto or sample mod install script to add additional tables to your vb install?