How to recreate the SQL Schema ?

Here you go (form the .install file)

CREATE TABLE IF NOT EXISTS {helptip} (
  nid int(10) unsigned NOT NULL default '0',
  path varchar(255) NOT NULL default '',
  weight tinyint(4) NOT NULL default '0',
  settings mediumtext NOT NULL default '',
  PRIMARY KEY  (nid),
  KEY path (path)
) /*!40100 DEFAULT CHARACTER SET utf8 */;

CREATE TABLE IF NOT EXISTS {helptip_user_data} (
  nid int(10) unsigned NOT NULL default '0',
  uid int(10) unsigned NOT NULL default '0',
  relation varchar(64) NOT NULL default '',
  PRIMARY KEY (nid, uid, relation)
) /*!40100 DEFAULT CHARACTER SET utf8 */;

Remove the { and } from the table names! If you use a table prefix add it to the table names.

Glad that worked.

The other approach, and this is true for any module using the new install system, would be

DELETE FROM system WHERE name='helptip';

Then, go to admin->modules and re-enable the module.