View file install/languages/en/sql/packages/subscriptions/activity/base.sql

INSERT INTO `{#}activity_types` (`is_enabled`, `controller`, `name`, `title`, `description`) VALUES
(1, 'subscriptions', 'subscribe', 'Subscription to content', 'subscribes to the %s list');