Product Creation Help

[Crimm]

I need some help with my first product.

I read the vb.com docs, but I'm having trouble with creating tables in the installation code. Here's what I'm doing:

$db->hide_errors();
$db->query_write("
CREATE TABLE IF NOT EXISTS " . TABLE_PREFIX . "TABLENAME 
    (
      tableid int(32) NOT NULL,
      PRIMARY KEY  (tableid)
    ) TYPE=MyISAM

");

$db->show_errors();

I have tried a few variations of that based off other products I have seen.

It just won't create the table.

Can anyone point out my mistake?

Please?