$installer->add_query('CREATE','guestbook4u',
  'g_id int(9) NOT NULL auto_increment,
  g_username varchar(50) NOT NULL default "",
  g_email varchar(60) NOT NULL default "",
  g_url varchar(70) NOT NULL default "",
  g_date int(11) NOT NULL default "0",
  g_host varchar(60) NOT NULL default "",
  g_entrytext text NOT NULL,
  g_userid smallint(1) default "0",
  g_active smallint(1) default "0",
  PRIMARY KEY  (g_id)', 'guestbook4u');