1 files changed, 22 insertions, 0 deletions
diff --git a/app/models/activity_pub/releases_subscription.rb b/app/models/activity_pub/releases_subscription.rb
new file mode 100644
index 00000000000..a6304f1fc35
--- /dev/null
+++ b/app/models/activity_pub/releases_subscription.rb
@@ -0,0 +1,22 @@
+# frozen_string_literal: true
+
+module ActivityPub
+  class ReleasesSubscription < ApplicationRecord
+    belongs_to :project, optional: false
+
+    enum :status, [:requested, :accepted], default: :requested
+
+    attribute :payload, Gitlab::Database::Type::JsonPgSafe.new
+
+    validates :payload, json_schema: { filename: 'activity_pub_follow_payload' }, allow_blank: true
+    validates :subscriber_url, presence: true, uniqueness: { case_sensitive: false, scope: :project_id },
+      public_url: true
+    validates :subscriber_inbox_url, uniqueness: { case_sensitive: false, scope: :project_id },
+      public_url: { allow_nil: true }
+    validates :shared_inbox_url, public_url: { allow_nil: true }
+
+    def self.find_by_subscriber_url(subscriber_url)
+      find_by('LOWER(subscriber_url) = ?', subscriber_url.downcase)
+    end
+  end
+end