5 files changed, 139 insertions, 4 deletions
diff --git a/common/common.pro b/common/common.pro
index eec5b5f..89f0117 100644
--- a/common/common.pro
+++ b/common/common.pro
@@ -10,10 +10,12 @@ TARGET = mastodoncommon
 TARGET = $$qtLibraryTarget($$TARGET)
 
 HEADERS += \
-    $$PWD/mastodonpostsdatabase.h
+    $$PWD/mastodonpostsdatabase.h \
+    $$PWD/mastodonnotificationsdatabase.h
 
 SOURCES += \
-    $$PWD/mastodonpostsdatabase.cpp
+    $$PWD/mastodonpostsdatabase.cpp \
+    $$PWD/mastodonnotificationsdatabase.cpp
 
 TARGETPATH = $$[QT_INSTALL_LIBS]
 target.path = $$TARGETPATH
diff --git a/common/mastodonnotificationsdatabase.cpp b/common/mastodonnotificationsdatabase.cpp
new file mode 100644
index 0000000..abb55b9
--- /dev/null
+++ b/common/mastodonnotificationsdatabase.cpp
@@ -0,0 +1,87 @@
+/*
+ * Copyright (C) 2013-2026 Jolla Ltd.
+ *
+ * This library is free software; you can redistribute it and/or
+ * modify it under the terms of the GNU Lesser General Public
+ * License as published by the Free Software Foundation; either
+ * version 2.1 of the License, or (at your option) any later version.
+ *
+ * This library is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
+ * Lesser General Public License for more details.
+ *
+ * You should have received a copy of the GNU Lesser General Public
+ * License along with this library; if not, write to the Free Software
+ * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301  USA
+ */
+
+#include "mastodonnotificationsdatabase.h"
+
+static const char *DB_NAME = "mastodonNotifications.db";
+static const char *ACCOUNT_NAME_KEY = "account_name";
+static const char *URL_KEY = "url";
+static const char *BOOSTED_BY_KEY = "boosted_by";
+static const char *INSTANCE_URL_KEY = "instance_url";
+
+MastodonNotificationsDatabase::MastodonNotificationsDatabase()
+    : AbstractSocialPostCacheDatabase(QStringLiteral("mastodon"), QLatin1String(DB_NAME))
+{
+}
+
+MastodonNotificationsDatabase::~MastodonNotificationsDatabase()
+{
+}
+
+void MastodonNotificationsDatabase::addMastodonNotification(
+        const QString &identifier,
+        const QString &name,
+        const QString &accountName,
+        const QString &body,
+        const QDateTime &timestamp,
+        const QString &icon,
+        const QList<QPair<QString, SocialPostImage::ImageType> > &images,
+        const QString &url,
+        const QString &boostedBy,
+        const QString &instanceUrl,
+        int account)
+{
+    QVariantMap extra;
+    extra.insert(ACCOUNT_NAME_KEY, accountName);
+    extra.insert(URL_KEY, url);
+    extra.insert(BOOSTED_BY_KEY, boostedBy);
+    extra.insert(INSTANCE_URL_KEY, instanceUrl);
+    addPost(identifier, name, body, timestamp, icon, images, extra, account);
+}
+
+QString MastodonNotificationsDatabase::accountName(const SocialPost::ConstPtr &post)
+{
+    if (post.isNull()) {
+        return QString();
+    }
+    return post->extra().value(ACCOUNT_NAME_KEY).toString();
+}
+
+QString MastodonNotificationsDatabase::url(const SocialPost::ConstPtr &post)
+{
+    if (post.isNull()) {
+        return QString();
+    }
+    return post->extra().value(URL_KEY).toString();
+}
+
+QString MastodonNotificationsDatabase::boostedBy(const SocialPost::ConstPtr &post)
+{
+    if (post.isNull()) {
+        return QString();
+    }
+    return post->extra().value(BOOSTED_BY_KEY).toString();
+}
+
+QString MastodonNotificationsDatabase::instanceUrl(const SocialPost::ConstPtr &post)
+{
+    if (post.isNull()) {
+        return QString();
+    }
+    return post->extra().value(INSTANCE_URL_KEY).toString();
+}
diff --git a/common/mastodonnotificationsdatabase.h b/common/mastodonnotificationsdatabase.h
new file mode 100644
index 0000000..cc69095
--- /dev/null
+++ b/common/mastodonnotificationsdatabase.h
@@ -0,0 +1,46 @@
+/*
+ * Copyright (C) 2013-2026 Jolla Ltd.
+ *
+ * This library is free software; you can redistribute it and/or
+ * modify it under the terms of the GNU Lesser General Public
+ * License as published by the Free Software Foundation; either
+ * version 2.1 of the License, or (at your option) any later version.
+ *
+ * This library is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
+ * Lesser General Public License for more details.
+ *
+ * You should have received a copy of the GNU Lesser General Public
+ * License along with this library; if not, write to the Free Software
+ * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301  USA
+ */
+
+#ifndef MASTODONNOTIFICATIONSDATABASE_H
+#define MASTODONNOTIFICATIONSDATABASE_H
+
+#include <socialcache/abstractsocialpostcachedatabase.h>
+
+class MastodonNotificationsDatabase: public AbstractSocialPostCacheDatabase
+{
+    Q_OBJECT
+public:
+    MastodonNotificationsDatabase();
+    ~MastodonNotificationsDatabase();
+
+    void addMastodonNotification(const QString &identifier, const QString &name,
+                                 const QString &accountName, const QString &body,
+                                 const QDateTime &timestamp,
+                                 const QString &icon,
+                                 const QList<QPair<QString, SocialPostImage::ImageType> > &images,
+                                 const QString &url, const QString &boostedBy,
+                                 const QString &instanceUrl,
+                                 int account);
+
+    static QString accountName(const SocialPost::ConstPtr &post);
+    static QString url(const SocialPost::ConstPtr &post);
+    static QString boostedBy(const SocialPost::ConstPtr &post);
+    static QString instanceUrl(const SocialPost::ConstPtr &post);
+};
+
+#endif // MASTODONNOTIFICATIONSDATABASE_H
diff --git a/common/mastodonpostsdatabase.cpp b/common/mastodonpostsdatabase.cpp
index fa6ddd3..08fc777 100644
--- a/common/mastodonpostsdatabase.cpp
+++ b/common/mastodonpostsdatabase.cpp
@@ -1,5 +1,5 @@
 /*
- * Copyright (C) 2026 Open Mobile Platform LLC.
+ * Copyright (C) 2013-2026 Jolla Ltd.
  *
  * This library is free software; you can redistribute it and/or
  * modify it under the terms of the GNU Lesser General Public
diff --git a/common/mastodonpostsdatabase.h b/common/mastodonpostsdatabase.h
index d5fdea7..b27b626 100644
--- a/common/mastodonpostsdatabase.h
+++ b/common/mastodonpostsdatabase.h
@@ -1,5 +1,5 @@
 /*
- * Copyright (C) 2026 Open Mobile Platform LLC.
+ * Copyright (C) 2013-2026 Jolla Ltd.
  *
  * This library is free software; you can redistribute it and/or
  * modify it under the terms of the GNU Lesser General Public