Someone

      db_query("CREATE TABLE {update_notify} (
        nid int unsigned NOT NULL default '0',
        vid int unsigned NOT NULL default '0',
        module text NOT NULL,
        site text NOT NULL,
        status int unsigned NOT NULL default '0',
        PRIMARY KEY (nid,vid),
        UNIQUE KEY vid (vid),
        KEY nid (nid)
      ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
      db_query("CREATE TABLE {update_notify_keys} (
        name text NOT NULL,
        drupal_key text NOT NULL,
        PRIMARY KEY (name),
        UNIQUE KEY drupal_key,
        KEY name (name)
      ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
      break;