chore(deps): update dependency tailwindcss to v3.4.19

ci: update concurrency logic (#2481 )
ci: add semantic-pr workflow to enforce conventional commits (#2472 )
2026-02-17 15:16:42 +00:00 · 2026-02-17 14:47:16 +01:00 · 2026-02-17 13:33:41 +00:00 · 2026-02-17 11:47:58 +01:00 · 2026-02-17 05:12:47 +05:00 · 2026-02-17 00:36:55 +08:00
38 changed files with 704 additions and 197 deletions
--- a/.github/ISSUE_TEMPLATE/bug.yml
+++ b/.github/ISSUE_TEMPLATE/bug.yml
@@ -1,6 +1,7 @@
 name: 🐛 Bug Report
 description: Report a problem
-labels: ['bug', 'awaiting triage']
+labels: ['awaiting triage']
+type: bug
 body:
  - type: markdown
    attributes:
--- a/.github/ISSUE_TEMPLATE/documentation.yml
+++ b/.github/ISSUE_TEMPLATE/documentation.yml
@@ -0,0 +1,63 @@
+name: 📚 Documentation
+description: Report a docs problem or suggest a docs improvement
+title: "[Docs]: "
+labels: ["documentation", "awaiting triage"]
+type: task
+body:
+  - type: markdown
+    attributes:
+      value: |
+        Thanks for helping improve the docs!
+
+        Use this template for documentation issues (typos, unclear steps, missing info, outdated screenshots).
+        For app bugs or feature ideas, please use the other templates.
+  - type: input
+    id: doc-location
+    attributes:
+      label: Page / Location
+      description: Link to the docs page or the file/path (e.g. https://docs.seerr.dev/... or README.md)
+      placeholder: "https://docs.seerr.dev/..."
+    validations:
+      required: true
+  - type: dropdown
+    id: doc-area
+    attributes:
+      label: Docs Area
+      options:
+        - docs site
+        - migration guide
+        - README / repo docs
+        - API / integrations
+        - other
+    validations:
+      required: true
+  - type: textarea
+    id: problem
+    attributes:
+      label: What’s wrong / missing?
+      description: Describe the issue in the docs.
+    validations:
+      required: true
+  - type: textarea
+    id: suggested-fix
+    attributes:
+      label: Suggested change
+      description: If you know what should be changed, describe it (or paste proposed wording).
+    validations:
+      required: false
+  - type: checkboxes
+    id: search-existing
+    attributes:
+      label: Search Existing Issues
+      description: Have you searched existing issues to see if this has already been reported?
+      options:
+        - label: Yes, I have searched existing issues.
+          required: true
+  - type: checkboxes
+    id: terms
+    attributes:
+      label: Code of Conduct
+      description: By submitting this issue, you agree to follow our Code of Conduct.
+      options:
+        - label: I agree to follow Seerr's [Code of Conduct](https://github.com/seerr-team/seerr/blob/develop/CODE_OF_CONDUCT.md).
+          required: true
--- a/.github/ISSUE_TEMPLATE/enhancement.yml
+++ b/.github/ISSUE_TEMPLATE/enhancement.yml
@@ -1,6 +1,7 @@
 name: ✨ Feature Request
 description: Suggest an idea
-labels: ['enhancement', 'awaiting triage']
+labels: ['awaiting triage']
+type: feature
 body:
  - type: markdown
    attributes:
--- a/.github/ISSUE_TEMPLATE/maintenance.yml
+++ b/.github/ISSUE_TEMPLATE/maintenance.yml
@@ -0,0 +1,65 @@
+name: 🧰 Maintenance / Chore
+description: CI, GitHub Actions, build, dependencies, refactors (non-feature work)
+title: "[Chore]: "
+labels: ["maintenance", "awaiting triage"]
+type: task
+body:
+  - type: markdown
+    attributes:
+      value: |
+        Maintainers / contributors: use this for internal tasks (CI, workflows, tooling, refactors).
+        If you're reporting a user-facing bug or requesting a feature, use the other templates.
+  - type: dropdown
+    id: area
+    attributes:
+      label: Area
+      options:
+        - CI / GitHub Actions
+        - build / packaging
+        - dependencies
+        - release process
+        - refactor / tech debt
+        - tooling / scripts
+        - other
+    validations:
+      required: true
+  - type: textarea
+    id: summary
+    attributes:
+      label: Summary
+      description: What needs doing and why?
+    validations:
+      required: true
+  - type: textarea
+    id: acceptance
+    attributes:
+      label: Acceptance criteria
+      description: What does "done" look like?
+      placeholder: |
+        - [ ] ...
+        - [ ] ...
+    validations:
+      required: false
+  - type: input
+    id: related
+    attributes:
+      label: Related links
+      description: PRs, failing workflow runs, logs, or relevant issues.
+    validations:
+      required: false
+  - type: checkboxes
+    id: search-existing
+    attributes:
+      label: Search Existing Issues
+      description: Have you searched existing issues to see if this has already been reported?
+      options:
+        - label: Yes, I have searched existing issues.
+          required: true
+  - type: checkboxes
+    id: terms
+    attributes:
+      label: Code of Conduct
+      description: By submitting this issue, you agree to follow our Code of Conduct.
+      options:
+        - label: I agree to follow Seerr's [Code of Conduct](https://github.com/seerr-team/seerr/blob/develop/CODE_OF_CONDUCT.md).
+          required: true
--- a/.github/workflows/ci.yml
+++ b/.github/workflows/ci.yml
@@ -18,7 +18,7 @@ env:
  DOCKER_HUB: seerr/seerr

 concurrency:
-  group: ci-${{ github.ref }}
+  group: ${{ github.workflow }}-${{ github.event.pull_request.number || github.ref }}
  cancel-in-progress: true

 jobs:
--- a/.github/workflows/codeql.yml
+++ b/.github/workflows/codeql.yml
@@ -20,7 +20,7 @@ permissions:
  contents: read

 concurrency:
-  group: codeql-${{ github.ref }}
+  group: ${{ github.workflow }}-${{ github.event.pull_request.number || github.ref }}
  cancel-in-progress: true

 jobs:
--- a/.github/workflows/conflict_labeler.yml
+++ b/.github/workflows/conflict_labeler.yml
@@ -14,7 +14,7 @@ permissions:
  contents: read

 concurrency:
-  group: merge-conflict-${{ github.ref }}
+  group: ${{ github.workflow }}-${{ github.event.pull_request.number || github.ref }}
  cancel-in-progress: true

 jobs:
--- a/.github/workflows/cypress.yml
+++ b/.github/workflows/cypress.yml
@@ -28,7 +28,7 @@ permissions:
  contents: read

 concurrency:
-  group: cypress-${{ github.ref }}
+  group: ${{ github.workflow }}-${{ github.event.pull_request.number || github.ref }}
  cancel-in-progress: true

 jobs:
--- a/.github/workflows/docs-deploy.yml
+++ b/.github/workflows/docs-deploy.yml
@@ -15,7 +15,7 @@ permissions:
  contents: read

 concurrency:
-  group: pages
+  group: ${{ github.workflow }}-${{ github.ref }}
  cancel-in-progress: true

 jobs:
--- a/.github/workflows/docs-link-check.yml
+++ b/.github/workflows/docs-link-check.yml
@@ -25,7 +25,7 @@ permissions:
  contents: read

 concurrency:
-  group: docs-link-check-${{ github.ref }}
+  group: ${{ github.workflow }}-${{ github.event.pull_request.number || github.ref }}
  cancel-in-progress: true

 jobs:
--- a/.github/workflows/helm.yml
+++ b/.github/workflows/helm.yml
@@ -14,7 +14,7 @@ permissions:
  contents: read

 concurrency:
-  group: helm-charts
+  group: ${{ github.workflow }}-${{ github.ref }}
  cancel-in-progress: true

 jobs:
--- a/.github/workflows/lint-helm-charts.yml
+++ b/.github/workflows/lint-helm-charts.yml
@@ -18,7 +18,7 @@ permissions:
  contents: read

 concurrency:
-  group: charts-lint-${{ github.ref }}
+  group: ${{ github.workflow }}-${{ github.event.pull_request.number || github.ref }}
  cancel-in-progress: true

 jobs:
--- a/.github/workflows/preview.yml
+++ b/.github/workflows/preview.yml
@@ -15,7 +15,7 @@ env:
  DOCKER_HUB: seerr/seerr

 concurrency:
-  group: preview-${{ github.ref }}
+  group: ${{ github.workflow }}-${{ github.ref }}
  cancel-in-progress: true

 jobs:
--- a/.github/workflows/release.yml
+++ b/.github/workflows/release.yml
@@ -11,7 +11,7 @@ permissions:
  contents: read

 concurrency:
-  group: release-${{ github.ref }}
+  group: ${{ github.workflow }}-${{ github.ref }}
  cancel-in-progress: true

 env:
--- a/.github/workflows/renovate-helm-custom-hooks.yml
+++ b/.github/workflows/renovate-helm-custom-hooks.yml
@@ -12,7 +12,7 @@ on:
 permissions: {}

 concurrency:
-  group: renovate-helm-hooks-${{ github.ref }}
+  group: ${{ github.workflow }}-${{ github.event.pull_request.number || github.ref }}
  cancel-in-progress: true

 jobs:
--- a/.github/workflows/semantic-pr.yml
+++ b/.github/workflows/semantic-pr.yml
@@ -0,0 +1,28 @@
+name: "Semantic PR"
+
+on:
+  pull_request_target:
+    types:
+      - opened
+      - reopened
+      - edited
+      - synchronize
+
+permissions: {}
+
+concurrency:
+  group: ${{ github.workflow }}-${{ github.event.pull_request.number || github.ref }}
+  cancel-in-progress: true
+
+jobs:
+  main:
+    name: Validate PR Title
+    runs-on: ubuntu-slim
+    permissions:
+      contents: read
+      pull-requests: read
+      checks: write
+    steps:
+      - uses: amannn/action-semantic-pull-request@48f256284bd46cdaab1048c3721360e808335d50 # v6.1.1
+        env:
+          GITHUB_TOKEN: ${{ secrets.GITHUB_TOKEN }}
--- a/.github/workflows/stale.yml
+++ b/.github/workflows/stale.yml
@@ -9,7 +9,7 @@ on:
 permissions: {}

 concurrency:
-  group: close-stale-${{ github.ref }}
+  group: ${{ github.workflow }}-${{ github.ref }}
  cancel-in-progress: true

 jobs:
--- a/.github/workflows/test-docs-deploy.yml
+++ b/.github/workflows/test-docs-deploy.yml
@@ -14,7 +14,7 @@ permissions:
  contents: read

 concurrency:
-  group: docs-pr-${{ github.ref }}
+  group: ${{ github.workflow }}-${{ github.event.pull_request.number || github.ref }}
  cancel-in-progress: true

 jobs:
--- a/.github/workflows/trivy-scan.yml
+++ b/.github/workflows/trivy-scan.yml
@@ -16,7 +16,7 @@ permissions:
  contents: read

 concurrency:
-  group: trivy-scan-${{ github.ref }}
+  group: ${{ github.workflow }}-${{ github.ref }}
  cancel-in-progress: true

 jobs:
--- a/CONTRIBUTING.md
+++ b/CONTRIBUTING.md
@@ -122,7 +122,7 @@ Steps:

 - If you are taking on an existing bug or feature ticket, please comment on the [issue](/../../issues) to avoid multiple people working on the same thing.
 - All commits **must** follow [Conventional Commits](https://www.conventionalcommits.org/en/v1.0.0/)
-  - Pull requests with commits not following this standard will **not** be merged.
+  - Pull requests with titles or commits not following this standard will **not** be merged. PR titles are automatically checked for compliance.
 - Please make meaningful commits, or squash them prior to opening a pull request.
  - Do not squash commits once people have begun reviewing your changes.
 - Always rebase your commit to the latest `develop` branch. Do **not** merge `develop` into your branch.
--- a/charts/seerr-chart/Chart.yaml
+++ b/charts/seerr-chart/Chart.yaml
@@ -3,7 +3,7 @@ kubeVersion: '>=1.23.0-0'
 name: seerr-chart
 description: Seerr helm chart for Kubernetes
 type: application
-version: 3.0.2
+version: 3.1.0
 # renovate: image=ghcr.io/seerr-team/seerr
 appVersion: 'v3.0.1'
 maintainers:
--- a/charts/seerr-chart/README.md
+++ b/charts/seerr-chart/README.md
@@ -1,6 +1,6 @@
 # seerr-chart

-![Version: 3.0.2](https://img.shields.io/badge/Version-3.0.2-informational?style=flat-square) ![Type: application](https://img.shields.io/badge/Type-application-informational?style=flat-square) ![AppVersion: v3.0.1](https://img.shields.io/badge/AppVersion-v3.0.1-informational?style=flat-square)
+![Version: 3.1.0](https://img.shields.io/badge/Version-3.1.0-informational?style=flat-square) ![Type: application](https://img.shields.io/badge/Type-application-informational?style=flat-square) ![AppVersion: v3.0.1](https://img.shields.io/badge/AppVersion-v3.0.1-informational?style=flat-square)

 Seerr helm chart for Kubernetes

@@ -44,9 +44,10 @@ If `replicaCount` value was used - remove it. Helm update should work fine after
 | Key | Type | Default | Description |
 |-----|------|---------|-------------|
 | affinity | object | `{}` |  |
-| config | object | `{"persistence":{"accessModes":["ReadWriteOnce"],"annotations":{},"name":"","size":"5Gi","volumeName":""}}` | Creating PVC to store configuration |
+| config | object | `{"persistence":{"accessModes":["ReadWriteOnce"],"annotations":{},"existingClaim":"","name":"","size":"5Gi","volumeName":""}}` | Creating PVC to store configuration |
 | config.persistence.accessModes | list | `["ReadWriteOnce"]` | Access modes of persistent disk |
 | config.persistence.annotations | object | `{}` | Annotations for PVCs |
+| config.persistence.existingClaim | string | `""` | Specify an existing `PersistentVolumeClaim` to use. If this value is provided, the default PVC will not be created |
 | config.persistence.name | string | `""` | Config name |
 | config.persistence.size | string | `"5Gi"` | Size of persistent disk |
 | config.persistence.volumeName | string | `""` | Name of the permanent volume to reference in the claim. Can be used to bind to existing volumes. |
--- a/charts/seerr-chart/templates/persistentvolumeclaim.yaml
+++ b/charts/seerr-chart/templates/persistentvolumeclaim.yaml
@@ -1,3 +1,4 @@
+{{- if not .Values.config.persistence.existingClaim -}}
 apiVersion: v1
 kind: PersistentVolumeClaim
 metadata:
@@ -22,3 +23,4 @@ spec:
  resources:
    requests:
      storage: "{{ .Values.config.persistence.size }}"
+{{- end -}}
--- a/charts/seerr-chart/templates/statefulset.yaml
+++ b/charts/seerr-chart/templates/statefulset.yaml
@@ -103,7 +103,7 @@ spec:
      volumes:
        - name: config
          persistentVolumeClaim:
-            claimName: {{ include "seerr.configPersistenceName" . }}
+            claimName: {{ if .Values.config.persistence.existingClaim }}{{ .Values.config.persistence.existingClaim }}{{- else }}{{ include "seerr.configPersistenceName" . }}{{- end }}
      {{- with .Values.volumes }}
        {{- toYaml . | nindent 8 }}
      {{- end }}
--- a/charts/seerr-chart/values.yaml
+++ b/charts/seerr-chart/values.yaml
@@ -86,6 +86,8 @@ config:
    # -- Name of the permanent volume to reference in the claim.
    # Can be used to bind to existing volumes.
    volumeName: ''
+    # -- Specify an existing `PersistentVolumeClaim` to use. If this value is provided, the default PVC will not be created
+    existingClaim: ''

 ingress:
  enabled: false
--- a/docs/getting-started/third-parties/unraid.mdx
+++ b/docs/getting-started/third-parties/unraid.mdx
@@ -21,6 +21,14 @@ If an official Unraid Community Applications template for Seerr isn't available

 ### 1. Create the config directory

+:::note
+Seerr is now rootless. Unraid typically runs Docker containers as `nobody:users` (UID 99, GID 100), but Seerr now runs internally as UID 1000, GID 1000. This creates a permission mismatch.
+:::
+
+:::info
+**If migrating**: Copy your existing Jellyseerr/Overseerr config files (e.g., from `/mnt/user/appdata/overseerr/` or `/mnt/user/appdata/jellyseerr`) to `/mnt/user/appdata/seerr`, then apply the permissions below
+:::
+
 Open the Unraid terminal and run:

 ```bash
@@ -78,4 +86,4 @@ Open the WebUI at `http://<your-unraid-ip>:5055` and follow the setup wizard.

 :::info
 The `--init` flag in **Extra Parameters** is required. Seerr does not include its own init process, so `--init` ensures proper signal handling and clean container shutdowns.
-:::
+:::
--- a/docs/using-seerr/notifications/webpush.md
+++ b/docs/using-seerr/notifications/webpush.md
@@ -6,18 +6,22 @@ sidebar_position: 2

 # Web Push

-The web push notification agent enables you and your users to receive Seerr notifications in a supported browser.
-
-This notification agent does not require any configuration, but is not enabled in Seerr
-
 :::warning
 Web push notifications require a secure connection to your Seerr instance. Refer to the [Reverse Proxy](/extending-seerr/reverse-proxy) documentation for more information.
 :::

-To set up web push notifications, simply enable the agent in **Settings → Notifications → Web Push**. You and your users will then be prompted to allow notifications in your web browser.
+The web push notification agent enables you and your users to receive Seerr notifications in a supported browser. This offers a native notification experience without the need to install an app.

-Users can opt out of these notifications, or customize the notification types they would like to subscribe to, in their user settings.
+This notification agent does not require any configuration, but is not enabled by default in Seerr.

-:::info
-Web push notifications offer a native notification experience without the need to install an app.
+To set up web push notifications, simply enable the agent in **Settings → Notifications → Web Push**.
+
+You and your users have the option to enable web push notifications by going to your **User Profile → Edit Settings → Notifications → Web Push → Enable web push**. Here you can also customize the notifications you'd like to receive.
+
+:::info[Mobile Users]
+For Web Push notifications to work on mobile you need to add Seerr to your home screen as progressive web app (PWA). 
+:::
+
+:::info[iOS Users]
+On iOS you may need to enable the Safari notifications feature flag by going to **Settings → Safari → Advanced → Feature Flags** and enabling "Notifications".
 :::
--- a/gen-docs/pnpm-lock.yaml
+++ b/gen-docs/pnpm-lock.yaml
@@ -34,7 +34,7 @@ importers:
        version: 18.3.1(react@18.3.1)
      tailwindcss:
        specifier: ^3.4.4
-        version: 3.4.17
+        version: 3.4.19(yaml@2.8.1)
    devDependencies:
      '@docusaurus/module-type-aliases':
        specifier: 3.9.1
@@ -708,8 +708,8 @@ packages:
    resolution: {integrity: sha512-h7iEYiW4HebClDEhtvFObtPmIvrd1SSfpI9EhOeKk4CtIK/ngBWFpuhCzhdmRKtg71ylcue+9I6dv54XYO1epQ==}
    engines: {node: '>=6.9.0'}

-  '@babel/runtime@7.28.4':
-    resolution: {integrity: sha512-Q/N6JNWvIvPnLDvjlE1OUBLPQHH6l3CltCEsHIujp45zQUSSh8K+gHnaEX45yAT1nyngnINhvWtzN+Nb9D8RAQ==}
+  '@babel/runtime@7.28.6':
+    resolution: {integrity: sha512-05WQkdpL9COIMz4LjTxGpPNCdlpyimKppYNoJ5Di5EUObifl8t4tuLuUBBZEpoLYOmfvIWrsp9fCl0HoPRVTdA==}
    engines: {node: '>=6.9.0'}

  '@babel/template@7.27.2':
@@ -1224,10 +1224,6 @@ packages:
  '@hapi/topo@5.1.0':
    resolution: {integrity: sha512-foQZKJig7Ob0BMAYBfcJk8d77QtOe7Wo4ox7ff1lQYoNNAb6jwcY1ncdoy2e9wQZzvNy7ODZCYJkK8kzmcAnAg==}

-  '@isaacs/cliui@8.0.2':
-    resolution: {integrity: sha512-O8jcjabXaleOG9DQ0+ARXWZBTfnP4WNAqzuiJK7ll44AmxGKv/J2M4TPjxjY3znBCfvBXFzucm1twdyFybFqEA==}
-    engines: {node: '>=12'}
-
  '@jest/schemas@29.6.3':
    resolution: {integrity: sha512-mo5j5X+jIZmJQveBKeS/clAueipV7KgiX1vMgCxam1RNYiqE1w62n0/tJJnHtjW8ZHcQco5gY85jA3mi0L+nSA==}
    engines: {node: ^14.15.0 || ^16.10.0 || >=18.0.0}
@@ -1409,10 +1405,6 @@ packages:
    resolution: {integrity: sha512-3giAOQvZiH5F9bMlMiv8+GSPMeqg0dbaeo58/0SlA9sxSqZhnUtxzX9/2FzyhS9sWQf5S0GJE0AKBrFqjpeYcg==}
    engines: {node: '>=8.0.0'}

-  '@pkgjs/parseargs@0.11.0':
-    resolution: {integrity: sha512-+1VkjdD0QBLPodGrJUeqarH8VAIvQODIbwh9XpP5Syisf7YoQgsJKPNFoqqLQlu+VQ/tVSshMR6loPMn8U+dPg==}
-    engines: {node: '>=14'}
-
  '@pnpm/config.env-replace@1.1.0':
    resolution: {integrity: sha512-htyl8TWnKL7K/ESFa1oW2UB5lVDxuF5DpM7tBi6Hu2LNL3mWkIzNLG6N4zoCUP1lCKNxWy/3iu8mS8MvToGd6w==}
    engines: {node: '>=12.22.0'}
@@ -1943,9 +1935,6 @@ packages:
  brace-expansion@1.1.12:
    resolution: {integrity: sha512-9T9UjW3r0UW5c1Q7GTwllptXwhvYmEzFhzMfZ9H7FQWt+uZePjZPjBP/W1ZEyZ1twGWom5/56TF4lPcqjnDHcg==}

-  brace-expansion@2.0.2:
-    resolution: {integrity: sha512-Jt0vHyM+jmUBqojB7E1NIYadt0vI0Qxjxd2TErW94wDz+E2LAm5vKMXXwg6ZZBTHPuUlDgQHKXvjGBdfcF1ZDQ==}
-
  braces@3.0.3:
    resolution: {integrity: sha512-yQbXgO/OSZVD2IsiLlro+7Hf6Q18EJrKSEsdoMzKePKXct3gvD8oLcOQdIzGupr5Fj+EDe8gO/lxc1BzfMpxvA==}
    engines: {node: '>=8'}
@@ -2684,8 +2673,8 @@ packages:
  fast-uri@3.1.0:
    resolution: {integrity: sha512-iPeeDKJSWf4IEOasVVrknXpaBV0IApz/gp7S2bb7Z4Lljbl2MGJRqInZiUrQwV16cpzw/D3S5j5Julj/gT52AA==}

-  fastq@1.19.1:
-    resolution: {integrity: sha512-GwLTyxkCXjXbxqIhTsMI2Nui8huMPtnxg7krajPJAjnEG/iiOS7i+zCtWGZR9G0NBKbXKh6X9m9UIsYX/N6vvQ==}
+  fastq@1.20.1:
+    resolution: {integrity: sha512-GGToxJ/w1x32s/D2EKND7kTil4n8OVk/9mycTc4VDza13lOvpUZTGX3mFSCtV9ksdGBVzvsyAVLM6mHFThxXxw==}

  fault@2.0.1:
    resolution: {integrity: sha512-WtySTkS4OKev5JtpHXnib4Gxiurzh5NCGvWrFaZ34m6JehfTUhKZvn9njTfw48t6JumVQOmrKqpmGcdwxnhqBQ==}
@@ -2694,6 +2683,15 @@ packages:
    resolution: {integrity: sha512-CzbClwlXAuiRQAlUyfqPgvPoNKTckTPGfwZV4ZdAhVcP2lh9KUxJg2b5GkE7XbjKQ3YJnQ9z6D9ntLAlB+tP8g==}
    engines: {node: '>=0.8.0'}

+  fdir@6.5.0:
+    resolution: {integrity: sha512-tIbYtZbucOs0BRGqPJkshJUYdL+SDH7dVM8gjy+ERp3WAUjLEFJE+02kanyHtwjWOnwrKYBiwAmM0p4kLJAnXg==}
+    engines: {node: '>=12.0.0'}
+    peerDependencies:
+      picomatch: ^3 || ^4
+    peerDependenciesMeta:
+      picomatch:
+        optional: true
+
  feed@4.2.2:
    resolution: {integrity: sha512-u5/sxGfiMfZNtJ3OvQpXcvotFpYkL0n9u9mM2vkui2nGo8b4wvDkJ8gAkYqbA8QpGyFCv3RK0Z+Iv+9veCS9bQ==}
    engines: {node: '>=0.4.0'}
@@ -2737,10 +2735,6 @@ packages:
      debug:
        optional: true

-  foreground-child@3.3.1:
-    resolution: {integrity: sha512-gIXjKqtFuWEgzFRJA9WCQeSJLZDjgJUOMCMzxtvFq/37KojM1BFGufqsCy0r4qSQmYLsZYMeyRqzIWOMup03sw==}
-    engines: {node: '>=14'}
-
  form-data-encoder@2.1.4:
    resolution: {integrity: sha512-yDYSgNMraqvnxiEXO4hi88+YZxaHC6QKzb5N84iRCTDeRO7ZALpir/lVmf/uXUhnwUr2O4HU8s/n6x+yNjQkHw==}
    engines: {node: '>= 14.17'}
@@ -2815,10 +2809,6 @@ packages:
  glob-to-regexp@0.4.1:
    resolution: {integrity: sha512-lkX1HJXwyMcprw/5YUZc2s7DrpAiHB21/V+E1rHUrVNokkvB6bqMzT0VfV6/86ZNabt1k14YOIaT7nDvOX3Iiw==}

-  glob@10.4.5:
-    resolution: {integrity: sha512-7Bv8RF0k6xjo7d4A/PxYLbUCfb6c+Vpd2/mB2yRDlew7Jb5hEXiCD9ibfO7wpk8i4sevK6DFny9h7EYbM3/sHg==}
-    hasBin: true
-
  global-dirs@3.0.1:
    resolution: {integrity: sha512-NBcGGFbBA9s1VzD41QXDG+3++t9Mn5t1FpLdhESY6oKY4gYTFpX4wO3sqGUa0Srjtbfj3szX0RnemmrVRUdULA==}
    engines: {node: '>=10'}
@@ -3202,9 +3192,6 @@ packages:
    resolution: {integrity: sha512-WhB9zCku7EGTj/HQQRz5aUQEUeoQZH2bWcltRErOpymJ4boYE6wL9Tbr23krRPSZ+C5zqNSrSw+Cc7sZZ4b7vg==}
    engines: {node: '>=0.10.0'}

-  jackspeak@3.4.3:
-    resolution: {integrity: sha512-OGlZQpz2yfahA/Rd1Y8Cd9SIEsqvXkLVoSw/cgwhnhFMDbsQFeZYoJJ7bIZBS9BcamUW96asq/npPWugM+RQBw==}
-
  jest-util@29.7.0:
    resolution: {integrity: sha512-z6EbKajIpqGKU56y5KBUgy1dt1ihhQJgWzUlZHArA/+X2ad7Cb5iF+AK1EWVL/Bo7Rz9uurpqw6SiBCefUbCGA==}
    engines: {node: ^14.15.0 || ^16.10.0 || >=18.0.0}
@@ -3333,9 +3320,6 @@ packages:
    resolution: {integrity: sha512-ozCC6gdQ+glXOQsveKD0YsDy8DSQFjDTz4zyzEHNV5+JP5D62LmfDZ6o1cycFx9ouG940M5dE8C8CTewdj2YWQ==}
    engines: {node: ^12.20.0 || ^14.13.1 || >=16.0.0}

-  lru-cache@10.4.3:
-    resolution: {integrity: sha512-JNAzZcXrCt42VGLuYz0zfAzDfAvJWW6AfYlDBQyDV5DClI2m5sAmK+OIO7s59XfsRsWHp02jAJrRadPRGTt6SQ==}
-
  lru-cache@5.1.1:
    resolution: {integrity: sha512-KpNARQA3Iwv+jTA0utUVVbrh+Jlrr1Fv0e56GGzAFOXN7dk/FviaDW8LHmK52DlcH4WP2n6gI8vN1aesBFgo9w==}

@@ -3628,17 +3612,9 @@ packages:
  minimatch@3.1.2:
    resolution: {integrity: sha512-J7p63hRiAjw1NDEww1W7i37+ByIrOWO5XQQAzZ3VOcL0PNybwpfmV/N05zFAzwQ9USyEcX6t3UO+K5aqBQOIHw==}

-  minimatch@9.0.5:
-    resolution: {integrity: sha512-G6T0ZX48xgozx7587koeX9Ys2NYy6Gmv//P89sEte9V9whIapMNF4idKxnW2QtCcLiTWlb/wfCabAtAFWhhBow==}
-    engines: {node: '>=16 || 14 >=14.17'}
-
  minimist@1.2.8:
    resolution: {integrity: sha512-2yyAR8qBkN3YuheJanUpWC5U3bb5osDywNB8RzDVlDwDHbocAJveqqj1u8+SVD7jkWT4yvsHCpWqqWqAxb0zCA==}

-  minipass@7.1.2:
-    resolution: {integrity: sha512-qOOzS1cBTWYF4BH8fVePDBOO9iptMnGUEZwNc/cMWnTV2nVLZ7VoNWEPHkYczZA0pdoA7dl6e7FL659nX9S2aw==}
-    engines: {node: '>=16 || 14 >=14.17'}
-
  mrmime@2.0.1:
    resolution: {integrity: sha512-Y3wQdFg2Va6etvQ5I82yUhGdsKrcYox6p7FfL1LbK2J4V01F9TGlepTIhnK24t7koZibmg82KGglhA1XK5IsLQ==}
    engines: {node: '>=10'}
@@ -3793,9 +3769,6 @@ packages:
    resolution: {integrity: sha512-rhIwUycgwwKcP9yTOOFK/AKsAopjjCakVqLHePO3CC6Mir1Z99xT+R63jZxAT5lFZLa2inS5h+ZS2GvR99/FBg==}
    engines: {node: '>=8'}

-  package-json-from-dist@1.0.1:
-    resolution: {integrity: sha512-UEZIS3/by4OC8vL3P2dTXRETpebLI2NiI5vIrjaD/5UtrkFX/tNbwjTSRAGC/+7CAo2pIcBaRgWmcBBHcsaCIw==}
-
  package-json@8.1.1:
    resolution: {integrity: sha512-cbH9IAIJHNj9uXi196JVsRlt7cHKak6u/e6AkL/bkRelZ7rlL3X1YKxsZwa36xipOEKAsdtmaG6aAJoM1fx2zA==}
    engines: {node: '>=14.16'}
@@ -3847,10 +3820,6 @@ packages:
  path-parse@1.0.7:
    resolution: {integrity: sha512-LDJzPVEEEPR+y48z93A0Ed0yXb8pAByGWo/k5YYdYgpY2/2EsOsksJrq7lOHxryrVOn1ejG6oAp8ahvOIQD8sw==}

-  path-scurry@1.11.1:
-    resolution: {integrity: sha512-Xa4Nw17FS9ApQFJ9umLiJS4orGjm7ZzwUrwamcGQuHSzDyth9boKDaycYdDcZDuqYATXw4HFXgaqWTctW/v1HA==}
-    engines: {node: '>=16 || 14 >=14.18'}
-
  path-to-regexp@0.1.12:
    resolution: {integrity: sha512-RA1GjUVMnvYFxuqovrEqZoxxW5NUZqbwKtYz/Tt7nXerk0LbLblQmrsgdeOxV5SFHf0UDggjS/bSeOZwt1pmEQ==}

@@ -3871,6 +3840,10 @@ packages:
    resolution: {integrity: sha512-JU3teHTNjmE2VCGFzuY8EXzCDVwEqB2a8fsIvwaStHhAWJEeVd1o1QD80CU6+ZdEXXSLbSsuLwJjkCBWqRQUVA==}
    engines: {node: '>=8.6'}

+  picomatch@4.0.3:
+    resolution: {integrity: sha512-5gTmgEY/sqK6gFXLIsQNH19lWb4ebPDLA4SdLP7dsWkIXHWlG66oPuVvXSGFPppYZz8ZDZq0dYYrbHfBCVUb1Q==}
+    engines: {node: '>=12'}
+
  pify@2.3.0:
    resolution: {integrity: sha512-udgsAY+fTnvv7kI7aaxbqwWNb0AHiB0qBO89PZKPkoTmGOgdbrHDKD+0B2X4uTfJ/FT1R09r9gTsjUjNJotuog==}
    engines: {node: '>=0.10.0'}
@@ -4038,16 +4011,22 @@ packages:
    peerDependencies:
      postcss: ^8.4

-  postcss-load-config@4.0.2:
-    resolution: {integrity: sha512-bSVhyJGL00wMVoPUzAVAnbEoWyqRxkjv64tUl427SKnPrENtq6hJwUojroMz2VB+Q1edmi4IfrAPpami5VVgMQ==}
-    engines: {node: '>= 14'}
+  postcss-load-config@6.0.1:
+    resolution: {integrity: sha512-oPtTM4oerL+UXmx+93ytZVN82RrlY/wPUV8IeDxFrzIjXOLF1pN+EmKPLbubvKHT2HC20xXsCAH2Z+CKV6Oz/g==}
+    engines: {node: '>= 18'}
    peerDependencies:
+      jiti: '>=1.21.0'
      postcss: '>=8.0.9'
-      ts-node: '>=9.0.0'
+      tsx: ^4.8.1
+      yaml: ^2.4.2
    peerDependenciesMeta:
+      jiti:
+        optional: true
      postcss:
        optional: true
-      ts-node:
+      tsx:
+        optional: true
+      yaml:
        optional: true

  postcss-loader@7.3.4:
@@ -4269,8 +4248,8 @@ packages:
    resolution: {integrity: sha512-Q8qQfPiZ+THO/3ZrOrO0cJJKfpYCagtMUkXbnEfmgUjwXg6z/WBeOyS9APBBPCTSiDV+s4SwQGu8yFsiMRIudg==}
    engines: {node: '>=4'}

-  postcss-selector-parser@7.1.0:
-    resolution: {integrity: sha512-8sLjZwK0R+JlxlYcTuVnyT2v+htpdrjDOKuMcOVdYjt52Lh8hWRYpxBPoKx/Zg+bcjc3wx6fmQevMmUztS/ccA==}
+  postcss-selector-parser@7.1.1:
+    resolution: {integrity: sha512-orRsuYpJVw8LdAwqqLykBj9ecS5/cRHlI5+nvTo8LcCKmzDmqVORXtOIYEEQuL9D4BxtA1lm5isAqzQZCoQ6Eg==}
    engines: {node: '>=4'}

  postcss-sort-media-queries@5.2.0:
@@ -4541,8 +4520,8 @@ packages:
  resolve-pathname@3.0.0:
    resolution: {integrity: sha512-C7rARubxI8bXFNB/hqcp/4iUeIXJhJZvFPFPiSPRnhU5UPxzMFIl+2E6yY6c4k9giDJAhtV+enfA+G89N6Csng==}

-  resolve@1.22.10:
-    resolution: {integrity: sha512-NPRy+/ncIMeDlTAsuqwKIiferiawhefFJtkNSW0qZJEqMEb+qBt/77B/jGeeek+F0uOeN05CDa6HXbbIgtVX4w==}
+  resolve@1.22.11:
+    resolution: {integrity: sha512-RfqAvLnMl313r7c9oclB1HhUEAezcpLjz95wFH4LVuhk9JF/r22qmVP9AMmOU4vMX7Q8pN8jwNg/CSpdFnMjTQ==}
    engines: {node: '>= 0.4'}
    hasBin: true

@@ -4689,10 +4668,6 @@ packages:
  signal-exit@3.0.7:
    resolution: {integrity: sha512-wnD2ZE+l+SPC/uoS0vXeE9L1+0wuaMqKlfz9AMUo38JsyLSBWSFcHR1Rri62LZc12vLr1gb3jl7iwQhgwpAbGQ==}

-  signal-exit@4.1.0:
-    resolution: {integrity: sha512-bzyZ1e88w9O1iNJbKnOlvYTrWPDl46O1bG0D3XInv+9tkPrxrN8jUUTiFlDkkmKWgn1M6CfIA13SuGqOa9Korw==}
-    engines: {node: '>=14'}
-
  sirv@2.0.4:
    resolution: {integrity: sha512-94Bdh3cC2PKrbgSOUqTiGPWVZeSiXfKOVZNJniWoqrWrRkB1CJzBU3NEbiTsPcYy1lDsANA/THzS+9WBiy5nfQ==}
    engines: {node: '>= 10'}
@@ -4827,8 +4802,8 @@ packages:
    peerDependencies:
      postcss: ^8.4.31

-  sucrase@3.35.0:
-    resolution: {integrity: sha512-8EbVDiu9iN/nESwxeSxDKe0dunta1GOlHufmSSXxMD2z2/tMZpDMpvXQGsc+ajGo8y2uYUmixaSRUc/QPoQ0GA==}
+  sucrase@3.35.1:
+    resolution: {integrity: sha512-DhuTmvZWux4H1UOnWMB3sk0sbaCVOoQZjv8u1rDoTV0HTdGem9hkAZtl4JZy8P2z4Bg0nT+YMeOFyVr4zcG5Tw==}
    engines: {node: '>=16 || 14 >=14.17'}
    hasBin: true

@@ -4857,8 +4832,8 @@ packages:
    peerDependencies:
      react: ^16.11.0 || ^17.0.0 || ^18.0.0 || ^19.0.0

-  tailwindcss@3.4.17:
-    resolution: {integrity: sha512-w33E2aCvSDP0tW9RZuNXadXlkHXqFzSkQew/aIa2i/Sj8fThxwovwlXHSPXTbAHwEIhBFXAedUhP2tueAKP8Og==}
+  tailwindcss@3.4.19:
+    resolution: {integrity: sha512-3ofp+LL8E+pK/JuPLPggVAIaEuhvIz4qNcf3nA1Xn2o/7fb7s/TYpHhwGDv1ZU3PkBluUVaF8PyCHcm48cKLWQ==}
    engines: {node: '>=14.0.0'}
    hasBin: true

@@ -4913,6 +4888,10 @@ packages:
  tiny-warning@1.0.3:
    resolution: {integrity: sha512-lBN9zLN/oAf68o3zNXYrdCt1kP8WsiGW8Oo2ka41b2IM5JL/S1CTyX1rW0mb/zSuJun0ZUrDxx4sqvYS2FWzPA==}

+  tinyglobby@0.2.15:
+    resolution: {integrity: sha512-j2Zq4NyQYG5XMST4cbs02Ak8iJUdxRM0XI5QyxXuZOzKOINmWurp3smXu3y5wDcJrptwpSjgXHzIQxR0omXljQ==}
+    engines: {node: '>=12.0.0'}
+
  tinypool@1.1.1:
    resolution: {integrity: sha512-Zba82s87IFq9A9XmjiX5uZA/ARWDrB03OHlq+Vw1fSdt0I+4/Kutwy8BP4Y/y/aORMo61FQ0vIb5j44vSo5Pkg==}
    engines: {node: ^18.0.0 || >=20.0.0}
@@ -5169,6 +5148,7 @@ packages:
  whatwg-encoding@3.1.1:
    resolution: {integrity: sha512-6qN4hJdMwfYBtE3YBTTHhoeuUrDBPZmbQaxWAqSALV/MeEnR5z1xd8UKud2RAkFoPkmB+hli1TZSnyi84xz1vQ==}
    engines: {node: '>=18'}
+    deprecated: Use @exodus/bytes instead for a more spec-conformant and faster implementation

  whatwg-mimetype@4.0.0:
    resolution: {integrity: sha512-QaKxh0eNIi2mE9p2vEdzfagOKHCcj1pJ56EEHGQOVxp8r9/iszLUUV7v89x9O1p/T+NlTM5W7jW6+cz4Fq1YVg==}
@@ -5465,7 +5445,7 @@ snapshots:
      '@babel/helper-plugin-utils': 7.27.1
      debug: 4.4.3
      lodash.debounce: 4.0.8
-      resolve: 1.22.10
+      resolve: 1.22.11
    transitivePeerDependencies:
      - supports-color

@@ -6118,7 +6098,7 @@ snapshots:
    dependencies:
      core-js-pure: 3.45.1

-  '@babel/runtime@7.28.4': {}
+  '@babel/runtime@7.28.6': {}

  '@babel/template@7.27.2':
    dependencies:
@@ -6187,9 +6167,9 @@ snapshots:

  '@csstools/postcss-cascade-layers@5.0.2(postcss@8.5.6)':
    dependencies:
-      '@csstools/selector-specificity': 5.0.0(postcss-selector-parser@7.1.0)
+      '@csstools/selector-specificity': 5.0.0(postcss-selector-parser@7.1.1)
      postcss: 8.5.6
-      postcss-selector-parser: 7.1.0
+      postcss-selector-parser: 7.1.1

  '@csstools/postcss-color-function-display-p3-linear@1.0.1(postcss@8.5.6)':
    dependencies:
@@ -6295,9 +6275,9 @@ snapshots:

  '@csstools/postcss-is-pseudo-class@5.0.3(postcss@8.5.6)':
    dependencies:
-      '@csstools/selector-specificity': 5.0.0(postcss-selector-parser@7.1.0)
+      '@csstools/selector-specificity': 5.0.0(postcss-selector-parser@7.1.1)
      postcss: 8.5.6
-      postcss-selector-parser: 7.1.0
+      postcss-selector-parser: 7.1.1

  '@csstools/postcss-light-dark-function@2.0.11(postcss@8.5.6)':
    dependencies:
@@ -6389,7 +6369,7 @@ snapshots:
  '@csstools/postcss-scope-pseudo-class@4.0.1(postcss@8.5.6)':
    dependencies:
      postcss: 8.5.6
-      postcss-selector-parser: 7.1.0
+      postcss-selector-parser: 7.1.1

  '@csstools/postcss-sign-functions@1.1.4(postcss@8.5.6)':
    dependencies:
@@ -6422,13 +6402,13 @@ snapshots:
    dependencies:
      postcss: 8.5.6

-  '@csstools/selector-resolve-nested@3.1.0(postcss-selector-parser@7.1.0)':
+  '@csstools/selector-resolve-nested@3.1.0(postcss-selector-parser@7.1.1)':
    dependencies:
-      postcss-selector-parser: 7.1.0
+      postcss-selector-parser: 7.1.1

-  '@csstools/selector-specificity@5.0.0(postcss-selector-parser@7.1.0)':
+  '@csstools/selector-specificity@5.0.0(postcss-selector-parser@7.1.1)':
    dependencies:
-      postcss-selector-parser: 7.1.0
+      postcss-selector-parser: 7.1.1

  '@csstools/utilities@2.0.0(postcss@8.5.6)':
    dependencies:
@@ -6464,7 +6444,7 @@ snapshots:
      '@babel/preset-env': 7.28.3(@babel/core@7.28.4)
      '@babel/preset-react': 7.27.1(@babel/core@7.28.4)
      '@babel/preset-typescript': 7.27.1(@babel/core@7.28.4)
-      '@babel/runtime': 7.28.4
+      '@babel/runtime': 7.28.6
      '@babel/runtime-corejs3': 7.28.4
      '@babel/traverse': 7.28.4
      '@docusaurus/logger': 3.9.1
@@ -7272,15 +7252,6 @@ snapshots:
    dependencies:
      '@hapi/hoek': 9.3.0

-  '@isaacs/cliui@8.0.2':
-    dependencies:
-      string-width: 5.1.2
-      string-width-cjs: string-width@4.2.3
-      strip-ansi: 7.1.2
-      strip-ansi-cjs: strip-ansi@6.0.1
-      wrap-ansi: 8.1.0
-      wrap-ansi-cjs: wrap-ansi@7.0.0
-
  '@jest/schemas@29.6.3':
    dependencies:
      '@sinclair/typebox': 0.27.8
@@ -7469,13 +7440,10 @@ snapshots:
  '@nodelib/fs.walk@1.2.8':
    dependencies:
      '@nodelib/fs.scandir': 2.1.5
-      fastq: 1.19.1
+      fastq: 1.20.1

  '@opentelemetry/api@1.9.0': {}

-  '@pkgjs/parseargs@0.11.0':
-    optional: true
-
  '@pnpm/config.env-replace@1.1.0': {}

  '@pnpm/network.ca-file@1.0.2':
@@ -7506,7 +7474,7 @@ snapshots:

  '@slorber/react-helmet-async@1.3.0(react-dom@18.3.1(react@18.3.1))(react@18.3.1)':
    dependencies:
-      '@babel/runtime': 7.28.4
+      '@babel/runtime': 7.28.6
      invariant: 2.2.4
      prop-types: 15.8.1
      react: 18.3.1
@@ -7759,7 +7727,7 @@ snapshots:

  '@types/sax@1.2.7':
    dependencies:
-      '@types/node': 17.0.45
+      '@types/node': 24.5.2

  '@types/send@0.17.5':
    dependencies:
@@ -8108,10 +8076,6 @@ snapshots:
      balanced-match: 1.0.2
      concat-map: 0.0.1

-  brace-expansion@2.0.2:
-    dependencies:
-      balanced-match: 1.0.2
-
  braces@3.0.3:
    dependencies:
      fill-range: 7.1.1
@@ -8398,7 +8362,7 @@ snapshots:
  css-blank-pseudo@7.0.1(postcss@8.5.6):
    dependencies:
      postcss: 8.5.6
-      postcss-selector-parser: 7.1.0
+      postcss-selector-parser: 7.1.1

  css-declaration-sorter@7.3.0(postcss@8.5.6):
    dependencies:
@@ -8406,9 +8370,9 @@ snapshots:

  css-has-pseudo@7.0.3(postcss@8.5.6):
    dependencies:
-      '@csstools/selector-specificity': 5.0.0(postcss-selector-parser@7.1.0)
+      '@csstools/selector-specificity': 5.0.0(postcss-selector-parser@7.1.1)
      postcss: 8.5.6
-      postcss-selector-parser: 7.1.0
+      postcss-selector-parser: 7.1.1
      postcss-value-parser: 4.2.0

  css-loader@6.11.0(webpack@5.101.3):
@@ -8881,7 +8845,7 @@ snapshots:

  fast-uri@3.1.0: {}

-  fastq@1.19.1:
+  fastq@1.20.1:
    dependencies:
      reusify: 1.1.0

@@ -8893,6 +8857,10 @@ snapshots:
    dependencies:
      websocket-driver: 0.7.4

+  fdir@6.5.0(picomatch@4.0.3):
+    optionalDependencies:
+      picomatch: 4.0.3
+
  feed@4.2.2:
    dependencies:
      xml-js: 1.6.11
@@ -8939,11 +8907,6 @@ snapshots:
    optionalDependencies:
      debug: 4.4.3

-  foreground-child@3.3.1:
-    dependencies:
-      cross-spawn: 7.0.6
-      signal-exit: 4.1.0
-
  form-data-encoder@2.1.4: {}

  format@0.2.2: {}
@@ -9011,15 +8974,6 @@ snapshots:

  glob-to-regexp@0.4.1: {}

-  glob@10.4.5:
-    dependencies:
-      foreground-child: 3.3.1
-      jackspeak: 3.4.3
-      minimatch: 9.0.5
-      minipass: 7.1.2
-      package-json-from-dist: 1.0.1
-      path-scurry: 1.11.1
-
  global-dirs@3.0.1:
    dependencies:
      ini: 2.0.0
@@ -9186,7 +9140,7 @@ snapshots:

  history@4.10.1:
    dependencies:
-      '@babel/runtime': 7.28.4
+      '@babel/runtime': 7.28.6
      loose-envify: 1.4.0
      resolve-pathname: 3.0.0
      tiny-invariant: 1.3.3
@@ -9452,12 +9406,6 @@ snapshots:

  isobject@3.0.1: {}

-  jackspeak@3.4.3:
-    dependencies:
-      '@isaacs/cliui': 8.0.2
-    optionalDependencies:
-      '@pkgjs/parseargs': 0.11.0
-
  jest-util@29.7.0:
    dependencies:
      '@jest/types': 29.6.3
@@ -9580,8 +9528,6 @@ snapshots:

  lowercase-keys@3.0.0: {}

-  lru-cache@10.4.3: {}
-
  lru-cache@5.1.1:
    dependencies:
      yallist: 3.1.1
@@ -10153,14 +10099,8 @@ snapshots:
    dependencies:
      brace-expansion: 1.1.12

-  minimatch@9.0.5:
-    dependencies:
-      brace-expansion: 2.0.2
-
  minimist@1.2.8: {}

-  minipass@7.1.2: {}
-
  mrmime@2.0.1: {}

  ms@2.0.0: {}
@@ -10299,8 +10239,6 @@ snapshots:
    dependencies:
      p-finally: 1.0.0

-  package-json-from-dist@1.0.1: {}
-
  package-json@8.1.1:
    dependencies:
      got: 12.6.1
@@ -10364,11 +10302,6 @@ snapshots:

  path-parse@1.0.7: {}

-  path-scurry@1.11.1:
-    dependencies:
-      lru-cache: 10.4.3
-      minipass: 7.1.2
-
  path-to-regexp@0.1.12: {}

  path-to-regexp@1.9.0:
@@ -10383,6 +10316,8 @@ snapshots:

  picomatch@2.3.1: {}

+  picomatch@4.0.3: {}
+
  pify@2.3.0: {}

  pirates@4.0.7: {}
@@ -10394,7 +10329,7 @@ snapshots:
  postcss-attribute-case-insensitive@7.0.1(postcss@8.5.6):
    dependencies:
      postcss: 8.5.6
-      postcss-selector-parser: 7.1.0
+      postcss-selector-parser: 7.1.1

  postcss-calc@9.0.1(postcss@8.5.6):
    dependencies:
@@ -10465,12 +10400,12 @@ snapshots:
      '@csstools/css-parser-algorithms': 3.0.5(@csstools/css-tokenizer@3.0.4)
      '@csstools/css-tokenizer': 3.0.4
      postcss: 8.5.6
-      postcss-selector-parser: 7.1.0
+      postcss-selector-parser: 7.1.1

  postcss-dir-pseudo-class@9.0.1(postcss@8.5.6):
    dependencies:
      postcss: 8.5.6
-      postcss-selector-parser: 7.1.0
+      postcss-selector-parser: 7.1.1

  postcss-discard-comments@6.0.2(postcss@8.5.6):
    dependencies:
@@ -10503,12 +10438,12 @@ snapshots:
  postcss-focus-visible@10.0.1(postcss@8.5.6):
    dependencies:
      postcss: 8.5.6
-      postcss-selector-parser: 7.1.0
+      postcss-selector-parser: 7.1.1

  postcss-focus-within@9.0.1(postcss@8.5.6):
    dependencies:
      postcss: 8.5.6
-      postcss-selector-parser: 7.1.0
+      postcss-selector-parser: 7.1.1

  postcss-font-variant@5.0.0(postcss@8.5.6):
    dependencies:
@@ -10529,7 +10464,7 @@ snapshots:
      postcss: 8.5.6
      postcss-value-parser: 4.2.0
      read-cache: 1.0.0
-      resolve: 1.22.10
+      resolve: 1.22.11

  postcss-js@4.1.0(postcss@8.5.6):
    dependencies:
@@ -10545,12 +10480,13 @@ snapshots:
      '@csstools/utilities': 2.0.0(postcss@8.5.6)
      postcss: 8.5.6

-  postcss-load-config@4.0.2(postcss@8.5.6):
+  postcss-load-config@6.0.1(jiti@1.21.7)(postcss@8.5.6)(yaml@2.8.1):
    dependencies:
      lilconfig: 3.1.3
-      yaml: 2.8.1
    optionalDependencies:
+      jiti: 1.21.7
      postcss: 8.5.6
+      yaml: 2.8.1

  postcss-loader@7.3.4(postcss@8.5.6)(typescript@5.2.2)(webpack@5.101.3):
    dependencies:
@@ -10619,13 +10555,13 @@ snapshots:
    dependencies:
      icss-utils: 5.1.0(postcss@8.5.6)
      postcss: 8.5.6
-      postcss-selector-parser: 7.1.0
+      postcss-selector-parser: 7.1.1
      postcss-value-parser: 4.2.0

  postcss-modules-scope@3.2.1(postcss@8.5.6):
    dependencies:
      postcss: 8.5.6
-      postcss-selector-parser: 7.1.0
+      postcss-selector-parser: 7.1.1

  postcss-modules-values@4.0.0(postcss@8.5.6):
    dependencies:
@@ -10639,10 +10575,10 @@ snapshots:

  postcss-nesting@13.0.2(postcss@8.5.6):
    dependencies:
-      '@csstools/selector-resolve-nested': 3.1.0(postcss-selector-parser@7.1.0)
-      '@csstools/selector-specificity': 5.0.0(postcss-selector-parser@7.1.0)
+      '@csstools/selector-resolve-nested': 3.1.0(postcss-selector-parser@7.1.1)
+      '@csstools/selector-specificity': 5.0.0(postcss-selector-parser@7.1.1)
      postcss: 8.5.6
-      postcss-selector-parser: 7.1.0
+      postcss-selector-parser: 7.1.1

  postcss-normalize-charset@6.0.2(postcss@8.5.6):
    dependencies:
@@ -10787,7 +10723,7 @@ snapshots:
  postcss-pseudo-class-any-link@10.0.1(postcss@8.5.6):
    dependencies:
      postcss: 8.5.6
-      postcss-selector-parser: 7.1.0
+      postcss-selector-parser: 7.1.1

  postcss-reduce-idents@6.0.3(postcss@8.5.6):
    dependencies:
@@ -10812,14 +10748,14 @@ snapshots:
  postcss-selector-not@8.0.1(postcss@8.5.6):
    dependencies:
      postcss: 8.5.6
-      postcss-selector-parser: 7.1.0
+      postcss-selector-parser: 7.1.1

  postcss-selector-parser@6.1.2:
    dependencies:
      cssesc: 3.0.0
      util-deprecate: 1.0.2

-  postcss-selector-parser@7.1.0:
+  postcss-selector-parser@7.1.1:
    dependencies:
      cssesc: 3.0.0
      util-deprecate: 1.0.2
@@ -10943,19 +10879,19 @@ snapshots:

  react-loadable-ssr-addon-v5-slorber@1.0.1(@docusaurus/react-loadable@6.0.0(react@18.3.1))(webpack@5.101.3):
    dependencies:
-      '@babel/runtime': 7.28.4
+      '@babel/runtime': 7.28.6
      react-loadable: '@docusaurus/react-loadable@6.0.0(react@18.3.1)'
      webpack: 5.101.3

  react-router-config@5.1.1(react-router@5.3.4(react@18.3.1))(react@18.3.1):
    dependencies:
-      '@babel/runtime': 7.28.4
+      '@babel/runtime': 7.28.6
      react: 18.3.1
      react-router: 5.3.4(react@18.3.1)

  react-router-dom@5.3.4(react@18.3.1):
    dependencies:
-      '@babel/runtime': 7.28.4
+      '@babel/runtime': 7.28.6
      history: 4.10.1
      loose-envify: 1.4.0
      prop-types: 15.8.1
@@ -10966,7 +10902,7 @@ snapshots:

  react-router@5.3.4(react@18.3.1):
    dependencies:
-      '@babel/runtime': 7.28.4
+      '@babel/runtime': 7.28.6
      history: 4.10.1
      hoist-non-react-statics: 3.3.2
      loose-envify: 1.4.0
@@ -11168,7 +11104,7 @@ snapshots:

  resolve-pathname@3.0.0: {}

-  resolve@1.22.10:
+  resolve@1.22.11:
    dependencies:
      is-core-module: 2.16.1
      path-parse: 1.0.7
@@ -11354,8 +11290,6 @@ snapshots:

  signal-exit@3.0.7: {}

-  signal-exit@4.1.0: {}
-
  sirv@2.0.4:
    dependencies:
      '@polka/url': 1.0.0-next.29
@@ -11497,14 +11431,14 @@ snapshots:
      postcss: 8.5.6
      postcss-selector-parser: 6.1.2

-  sucrase@3.35.0:
+  sucrase@3.35.1:
    dependencies:
      '@jridgewell/gen-mapping': 0.3.13
      commander: 4.1.1
-      glob: 10.4.5
      lines-and-columns: 1.2.4
      mz: 2.7.0
      pirates: 4.0.7
+      tinyglobby: 0.2.15
      ts-interface-checker: 0.1.13

  supports-color@7.2.0:
@@ -11535,7 +11469,7 @@ snapshots:
      react: 18.3.1
      use-sync-external-store: 1.5.0(react@18.3.1)

-  tailwindcss@3.4.17:
+  tailwindcss@3.4.19(yaml@2.8.1):
    dependencies:
      '@alloc/quick-lru': 5.2.0
      arg: 5.0.2
@@ -11554,13 +11488,14 @@ snapshots:
      postcss: 8.5.6
      postcss-import: 15.1.0(postcss@8.5.6)
      postcss-js: 4.1.0(postcss@8.5.6)
-      postcss-load-config: 4.0.2(postcss@8.5.6)
+      postcss-load-config: 6.0.1(jiti@1.21.7)(postcss@8.5.6)(yaml@2.8.1)
      postcss-nested: 6.2.0(postcss@8.5.6)
      postcss-selector-parser: 6.1.2
-      resolve: 1.22.10
-      sucrase: 3.35.0
+      resolve: 1.22.11
+      sucrase: 3.35.1
    transitivePeerDependencies:
-      - ts-node
+      - tsx
+      - yaml

  tapable@2.2.3: {}

@@ -11600,6 +11535,11 @@ snapshots:

  tiny-warning@1.0.3: {}

+  tinyglobby@0.2.15:
+    dependencies:
+      fdir: 6.5.0(picomatch@4.0.3)
+      picomatch: 4.0.3
+
  tinypool@1.1.1: {}

  to-regex-range@5.0.1:
@@ -11965,7 +11905,8 @@ snapshots:

  yallist@3.1.1: {}

-  yaml@2.8.1: {}
+  yaml@2.8.1:
+    optional: true

  yocto-queue@1.2.1: {}

--- a/server/entity/Blocklist.ts
+++ b/server/entity/Blocklist.ts
@@ -36,6 +36,7 @@ export class Blocklist implements BlocklistItem {
  @ManyToOne(() => User, (user) => user.id, {
    eager: true,
  })
+  @Index()
  user?: User;

  @OneToOne(() => Media, (media) => media.blocklist, {
--- a/server/entity/Issue.ts
+++ b/server/entity/Issue.ts
@@ -5,6 +5,7 @@ import {
  AfterLoad,
  Column,
  Entity,
+  Index,
  ManyToOne,
  OneToMany,
  PrimaryGeneratedColumn,
@@ -19,6 +20,7 @@ class Issue {
  public id: number;

  @Column({ type: 'int' })
+  @Index()
  public issueType: IssueType;

  @Column({ type: 'int', default: IssueStatus.OPEN })
@@ -34,12 +36,14 @@ class Issue {
    eager: true,
    onDelete: 'CASCADE',
  })
+  @Index()
  public media: Media;

  @ManyToOne(() => User, (user) => user.createdIssues, {
    eager: true,
    onDelete: 'CASCADE',
  })
+  @Index()
  public createdBy: User;

  @ManyToOne(() => User, {
@@ -47,6 +51,7 @@ class Issue {
    onDelete: 'CASCADE',
    nullable: true,
  })
+  @Index()
  public modifiedBy?: User;

  @OneToMany(() => IssueComment, (comment) => comment.issue, {
--- a/server/entity/IssueComment.ts
+++ b/server/entity/IssueComment.ts
@@ -1,5 +1,11 @@
 import { DbAwareColumn } from '@server/utils/DbColumnHelper';
-import { Column, Entity, ManyToOne, PrimaryGeneratedColumn } from 'typeorm';
+import {
+  Column,
+  Entity,
+  Index,
+  ManyToOne,
+  PrimaryGeneratedColumn,
+} from 'typeorm';
 import Issue from './Issue';
 import { User } from './User';

@@ -12,11 +18,13 @@ class IssueComment {
    eager: true,
    onDelete: 'CASCADE',
  })
+  @Index()
  public user: User;

  @ManyToOne(() => Issue, (issue) => issue.comments, {
    onDelete: 'CASCADE',
  })
+  @Index()
  public issue: Issue;

  @Column({ type: 'text' })
--- a/server/entity/MediaRequest.ts
+++ b/server/entity/MediaRequest.ts
@@ -521,12 +521,14 @@ export class MediaRequest {
    eager: true,
    onDelete: 'CASCADE',
  })
+  @Index()
  public media: Media;

  @ManyToOne(() => User, (user) => user.requests, {
    eager: true,
    onDelete: 'CASCADE',
  })
+  @Index()
  public requestedBy: User;

  @ManyToOne(() => User, {
@@ -535,6 +537,7 @@ export class MediaRequest {
    eager: true,
    onDelete: 'SET NULL',
  })
+  @Index()
  public modifiedBy?: User;

  @DbAwareColumn({ type: 'datetime', default: () => 'CURRENT_TIMESTAMP' })
--- a/server/entity/Season.ts
+++ b/server/entity/Season.ts
@@ -1,6 +1,12 @@
 import { MediaStatus } from '@server/constants/media';
 import { DbAwareColumn } from '@server/utils/DbColumnHelper';
-import { Column, Entity, ManyToOne, PrimaryGeneratedColumn } from 'typeorm';
+import {
+  Column,
+  Entity,
+  Index,
+  ManyToOne,
+  PrimaryGeneratedColumn,
+} from 'typeorm';
 import Media from './Media';

@Entity()
@@ -20,6 +26,7 @@ class Season {
  @ManyToOne(() => Media, (media) => media.seasons, {
    onDelete: 'CASCADE',
  })
+  @Index()
  public media: Promise<Media>;

  @DbAwareColumn({ type: 'datetime', default: () => 'CURRENT_TIMESTAMP' })
--- a/server/entity/SeasonRequest.ts
+++ b/server/entity/SeasonRequest.ts
@@ -1,6 +1,12 @@
 import { MediaRequestStatus } from '@server/constants/media';
 import { DbAwareColumn } from '@server/utils/DbColumnHelper';
-import { Column, Entity, ManyToOne, PrimaryGeneratedColumn } from 'typeorm';
+import {
+  Column,
+  Entity,
+  Index,
+  ManyToOne,
+  PrimaryGeneratedColumn,
+} from 'typeorm';
 import { MediaRequest } from './MediaRequest';

@Entity()
@@ -17,6 +23,7 @@ class SeasonRequest {
  @ManyToOne(() => MediaRequest, (request) => request.seasons, {
    onDelete: 'CASCADE',
  })
+  @Index()
  public request: MediaRequest;

  @DbAwareColumn({ type: 'datetime', default: () => 'CURRENT_TIMESTAMP' })
--- a/server/entity/UserPushSubscription.ts
+++ b/server/entity/UserPushSubscription.ts
@@ -2,6 +2,7 @@ import { DbAwareColumn } from '@server/utils/DbColumnHelper';
 import {
  Column,
  Entity,
+  Index,
  ManyToOne,
  PrimaryGeneratedColumn,
  Unique,
@@ -18,6 +19,7 @@ export class UserPushSubscription {
    eager: true,
    onDelete: 'CASCADE',
  })
+  @Index()
  public user: User;

  @Column()
--- a/server/entity/Watchlist.ts
+++ b/server/entity/Watchlist.ts
@@ -47,12 +47,14 @@ export class Watchlist implements WatchlistItem {
    eager: true,
    onDelete: 'CASCADE',
  })
+  @Index()
  public requestedBy: User;

  @ManyToOne(() => Media, (media) => media.watchlists, {
    eager: true,
    onDelete: 'CASCADE',
  })
+  @Index()
  public media: Media;

  @DbAwareColumn({ type: 'datetime', default: () => 'CURRENT_TIMESTAMP' })
--- a/server/migration/postgres/1771259406751-AddForeignKeyIndexes.ts
+++ b/server/migration/postgres/1771259406751-AddForeignKeyIndexes.ts
@@ -0,0 +1,153 @@
+import type { MigrationInterface, QueryRunner } from 'typeorm';
+
+export class AddForeignKeyIndexes1771259406751 implements MigrationInterface {
+  name = 'AddForeignKeyIndexes1771259406751';
+
+  public async up(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(
+      `ALTER TABLE "blocklist" DROP CONSTRAINT "FK_53c1ab62c3e5875bc3ac474823e"`
+    );
+    await queryRunner.query(
+      `ALTER TABLE "blocklist" DROP CONSTRAINT "FK_62b7ade94540f9f8d8bede54b99"`
+    );
+    await queryRunner.query(
+      `DROP INDEX "public"."IDX_6bbafa28411e6046421991ea21"`
+    );
+    await queryRunner.query(
+      `CREATE SEQUENCE IF NOT EXISTS "blocklist_id_seq" OWNED BY "blocklist"."id"`
+    );
+    await queryRunner.query(
+      `ALTER TABLE "blocklist" ALTER COLUMN "id" SET DEFAULT nextval('"blocklist_id_seq"')`
+    );
+    await queryRunner.query(
+      `ALTER TABLE "blocklist" ALTER COLUMN "id" DROP DEFAULT`
+    );
+    await queryRunner.query(
+      `CREATE INDEX "IDX_ae34e6b153a90672eb9dc4857d" ON "watchlist" ("requestedById") `
+    );
+    await queryRunner.query(
+      `CREATE INDEX "IDX_6641da8d831b93dfcb429f8b8b" ON "watchlist" ("mediaId") `
+    );
+    await queryRunner.query(
+      `CREATE INDEX "IDX_707b033c2d0653f75213614789" ON "issue_comment" ("userId") `
+    );
+    await queryRunner.query(
+      `CREATE INDEX "IDX_180710fead1c94ca499c57a7d4" ON "issue_comment" ("issueId") `
+    );
+    await queryRunner.query(
+      `CREATE INDEX "IDX_53d04c07c3f4f54eae372ed665" ON "issue" ("issueType") `
+    );
+    await queryRunner.query(
+      `CREATE INDEX "IDX_276e20d053f3cff1645803c95d" ON "issue" ("mediaId") `
+    );
+    await queryRunner.query(
+      `CREATE INDEX "IDX_10b17b49d1ee77e7184216001e" ON "issue" ("createdById") `
+    );
+    await queryRunner.query(
+      `CREATE INDEX "IDX_da88a1019c850d1a7b143ca02e" ON "issue" ("modifiedById") `
+    );
+    await queryRunner.query(
+      `CREATE INDEX "IDX_6f14737e346d6b27d8e50d2157" ON "season_request" ("requestId") `
+    );
+    await queryRunner.query(
+      `CREATE INDEX "IDX_a1aa713f41c99e9d10c48da75a" ON "media_request" ("mediaId") `
+    );
+    await queryRunner.query(
+      `CREATE INDEX "IDX_6997bee94720f1ecb7f3113709" ON "media_request" ("requestedById") `
+    );
+    await queryRunner.query(
+      `CREATE INDEX "IDX_f4fc4efa14c3ba2b29c4525fa1" ON "media_request" ("modifiedById") `
+    );
+    await queryRunner.query(
+      `CREATE INDEX "IDX_03f7958328e311761b0de675fb" ON "user_push_subscription" ("userId") `
+    );
+    await queryRunner.query(
+      `CREATE INDEX "IDX_09b94c932e84635c5461f3c0a9" ON "blocklist" ("tmdbId") `
+    );
+    await queryRunner.query(
+      `CREATE INDEX "IDX_356721a49f145aa439c16e6b99" ON "blocklist" ("userId") `
+    );
+    await queryRunner.query(
+      `CREATE INDEX "IDX_087099b39600be695591da9a49" ON "season" ("mediaId") `
+    );
+    await queryRunner.query(
+      `ALTER TABLE "blocklist" ADD CONSTRAINT "FK_356721a49f145aa439c16e6b999" FOREIGN KEY ("userId") REFERENCES "user"("id") ON DELETE NO ACTION ON UPDATE NO ACTION`
+    );
+    await queryRunner.query(
+      `ALTER TABLE "blocklist" ADD CONSTRAINT "FK_5c8af2d0e83b3be6d250eccc19d" FOREIGN KEY ("mediaId") REFERENCES "media"("id") ON DELETE CASCADE ON UPDATE NO ACTION`
+    );
+  }
+
+  public async down(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(
+      `ALTER TABLE "blocklist" DROP CONSTRAINT "FK_5c8af2d0e83b3be6d250eccc19d"`
+    );
+    await queryRunner.query(
+      `ALTER TABLE "blocklist" DROP CONSTRAINT "FK_356721a49f145aa439c16e6b999"`
+    );
+    await queryRunner.query(
+      `DROP INDEX "public"."IDX_087099b39600be695591da9a49"`
+    );
+    await queryRunner.query(
+      `DROP INDEX "public"."IDX_356721a49f145aa439c16e6b99"`
+    );
+    await queryRunner.query(
+      `DROP INDEX "public"."IDX_09b94c932e84635c5461f3c0a9"`
+    );
+    await queryRunner.query(
+      `DROP INDEX "public"."IDX_03f7958328e311761b0de675fb"`
+    );
+    await queryRunner.query(
+      `DROP INDEX "public"."IDX_f4fc4efa14c3ba2b29c4525fa1"`
+    );
+    await queryRunner.query(
+      `DROP INDEX "public"."IDX_6997bee94720f1ecb7f3113709"`
+    );
+    await queryRunner.query(
+      `DROP INDEX "public"."IDX_a1aa713f41c99e9d10c48da75a"`
+    );
+    await queryRunner.query(
+      `DROP INDEX "public"."IDX_6f14737e346d6b27d8e50d2157"`
+    );
+    await queryRunner.query(
+      `DROP INDEX "public"."IDX_da88a1019c850d1a7b143ca02e"`
+    );
+    await queryRunner.query(
+      `DROP INDEX "public"."IDX_10b17b49d1ee77e7184216001e"`
+    );
+    await queryRunner.query(
+      `DROP INDEX "public"."IDX_276e20d053f3cff1645803c95d"`
+    );
+    await queryRunner.query(
+      `DROP INDEX "public"."IDX_53d04c07c3f4f54eae372ed665"`
+    );
+    await queryRunner.query(
+      `DROP INDEX "public"."IDX_180710fead1c94ca499c57a7d4"`
+    );
+    await queryRunner.query(
+      `DROP INDEX "public"."IDX_707b033c2d0653f75213614789"`
+    );
+    await queryRunner.query(
+      `DROP INDEX "public"."IDX_6641da8d831b93dfcb429f8b8b"`
+    );
+    await queryRunner.query(
+      `DROP INDEX "public"."IDX_ae34e6b153a90672eb9dc4857d"`
+    );
+    await queryRunner.query(
+      `ALTER TABLE "blocklist" ALTER COLUMN "id" SET DEFAULT nextval('blacklist_id_seq')`
+    );
+    await queryRunner.query(
+      `ALTER TABLE "blocklist" ALTER COLUMN "id" DROP DEFAULT`
+    );
+    await queryRunner.query(`DROP SEQUENCE "blocklist_id_seq"`);
+    await queryRunner.query(
+      `CREATE INDEX "IDX_6bbafa28411e6046421991ea21" ON "blocklist" ("tmdbId") `
+    );
+    await queryRunner.query(
+      `ALTER TABLE "blocklist" ADD CONSTRAINT "FK_62b7ade94540f9f8d8bede54b99" FOREIGN KEY ("mediaId") REFERENCES "media"("id") ON DELETE CASCADE ON UPDATE NO ACTION`
+    );
+    await queryRunner.query(
+      `ALTER TABLE "blocklist" ADD CONSTRAINT "FK_53c1ab62c3e5875bc3ac474823e" FOREIGN KEY ("userId") REFERENCES "user"("id") ON DELETE NO ACTION ON UPDATE NO ACTION`
+    );
+  }
+}
--- a/server/migration/sqlite/1771259394105-AddForeignKeyIndexes.ts
+++ b/server/migration/sqlite/1771259394105-AddForeignKeyIndexes.ts
@@ -0,0 +1,203 @@
+import type { MigrationInterface, QueryRunner } from 'typeorm';
+
+export class AddForeignKeyIndexes1771259394105 implements MigrationInterface {
+  name = 'AddForeignKeyIndexes1771259394105';
+
+  public async up(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(`DROP INDEX "IDX_6bbafa28411e6046421991ea21"`);
+    await queryRunner.query(
+      `CREATE TABLE "temporary_blocklist" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "mediaType" varchar NOT NULL, "title" varchar, "tmdbId" integer NOT NULL, "blocklistedTags" varchar, "createdAt" datetime NOT NULL DEFAULT (datetime('now')), "userId" integer, "mediaId" integer, CONSTRAINT "REL_62b7ade94540f9f8d8bede54b9" UNIQUE ("mediaId"), CONSTRAINT "UQ_6bbafa28411e6046421991ea21c" UNIQUE ("tmdbId"))`
+    );
+    await queryRunner.query(
+      `INSERT INTO "temporary_blocklist"("id", "mediaType", "title", "tmdbId", "blocklistedTags", "createdAt", "userId", "mediaId") SELECT "id", "mediaType", "title", "tmdbId", "blocklistedTags", "createdAt", "userId", "mediaId" FROM "blocklist"`
+    );
+    await queryRunner.query(`DROP TABLE "blocklist"`);
+    await queryRunner.query(
+      `ALTER TABLE "temporary_blocklist" RENAME TO "blocklist"`
+    );
+    await queryRunner.query(
+      `CREATE INDEX "IDX_6bbafa28411e6046421991ea21" ON "blocklist" ("tmdbId") `
+    );
+    await queryRunner.query(`DROP INDEX "IDX_6bbafa28411e6046421991ea21"`);
+    await queryRunner.query(
+      `CREATE TABLE "temporary_user_push_subscription" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "endpoint" varchar NOT NULL, "p256dh" varchar NOT NULL, "auth" varchar NOT NULL, "userId" integer, "userAgent" varchar, "createdAt" datetime DEFAULT (CURRENT_TIMESTAMP), CONSTRAINT "UQ_6427d07d9a171a3a1ab87480005" UNIQUE ("endpoint", "userId"), CONSTRAINT "UQ_f90ab5a4ed54905a4bb51a7148b" UNIQUE ("auth"), CONSTRAINT "FK_03f7958328e311761b0de675fbe" FOREIGN KEY ("userId") REFERENCES "user" ("id") ON DELETE CASCADE ON UPDATE NO ACTION)`
+    );
+    await queryRunner.query(
+      `INSERT INTO "temporary_user_push_subscription"("id", "endpoint", "p256dh", "auth", "userId", "userAgent", "createdAt") SELECT "id", "endpoint", "p256dh", "auth", "userId", "userAgent", "createdAt" FROM "user_push_subscription"`
+    );
+    await queryRunner.query(`DROP TABLE "user_push_subscription"`);
+    await queryRunner.query(
+      `ALTER TABLE "temporary_user_push_subscription" RENAME TO "user_push_subscription"`
+    );
+    await queryRunner.query(
+      `CREATE TABLE "temporary_user_push_subscription" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "endpoint" varchar NOT NULL, "p256dh" varchar NOT NULL, "auth" varchar NOT NULL, "userId" integer, "userAgent" varchar, "createdAt" datetime DEFAULT (CURRENT_TIMESTAMP), CONSTRAINT "UQ_6427d07d9a171a3a1ab87480005" UNIQUE ("endpoint", "userId"), CONSTRAINT "UQ_f90ab5a4ed54905a4bb51a7148b" UNIQUE ("auth"), CONSTRAINT "FK_03f7958328e311761b0de675fbe" FOREIGN KEY ("userId") REFERENCES "user" ("id") ON DELETE CASCADE ON UPDATE NO ACTION)`
+    );
+    await queryRunner.query(
+      `INSERT INTO "temporary_user_push_subscription"("id", "endpoint", "p256dh", "auth", "userId", "userAgent", "createdAt") SELECT "id", "endpoint", "p256dh", "auth", "userId", "userAgent", "createdAt" FROM "user_push_subscription"`
+    );
+    await queryRunner.query(`DROP TABLE "user_push_subscription"`);
+    await queryRunner.query(
+      `ALTER TABLE "temporary_user_push_subscription" RENAME TO "user_push_subscription"`
+    );
+    await queryRunner.query(
+      `CREATE TABLE "temporary_blocklist" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "mediaType" varchar NOT NULL, "title" varchar, "tmdbId" integer NOT NULL, "blocklistedTags" varchar, "createdAt" datetime NOT NULL DEFAULT (CURRENT_TIMESTAMP), "userId" integer, "mediaId" integer, CONSTRAINT "REL_62b7ade94540f9f8d8bede54b9" UNIQUE ("mediaId"), CONSTRAINT "UQ_6bbafa28411e6046421991ea21c" UNIQUE ("tmdbId"))`
+    );
+    await queryRunner.query(
+      `INSERT INTO "temporary_blocklist"("id", "mediaType", "title", "tmdbId", "blocklistedTags", "createdAt", "userId", "mediaId") SELECT "id", "mediaType", "title", "tmdbId", "blocklistedTags", "createdAt", "userId", "mediaId" FROM "blocklist"`
+    );
+    await queryRunner.query(`DROP TABLE "blocklist"`);
+    await queryRunner.query(
+      `ALTER TABLE "temporary_blocklist" RENAME TO "blocklist"`
+    );
+    await queryRunner.query(
+      `CREATE INDEX "IDX_ae34e6b153a90672eb9dc4857d" ON "watchlist" ("requestedById") `
+    );
+    await queryRunner.query(
+      `CREATE INDEX "IDX_6641da8d831b93dfcb429f8b8b" ON "watchlist" ("mediaId") `
+    );
+    await queryRunner.query(
+      `CREATE INDEX "IDX_707b033c2d0653f75213614789" ON "issue_comment" ("userId") `
+    );
+    await queryRunner.query(
+      `CREATE INDEX "IDX_180710fead1c94ca499c57a7d4" ON "issue_comment" ("issueId") `
+    );
+    await queryRunner.query(
+      `CREATE INDEX "IDX_53d04c07c3f4f54eae372ed665" ON "issue" ("issueType") `
+    );
+    await queryRunner.query(
+      `CREATE INDEX "IDX_276e20d053f3cff1645803c95d" ON "issue" ("mediaId") `
+    );
+    await queryRunner.query(
+      `CREATE INDEX "IDX_10b17b49d1ee77e7184216001e" ON "issue" ("createdById") `
+    );
+    await queryRunner.query(
+      `CREATE INDEX "IDX_da88a1019c850d1a7b143ca02e" ON "issue" ("modifiedById") `
+    );
+    await queryRunner.query(
+      `CREATE INDEX "IDX_6f14737e346d6b27d8e50d2157" ON "season_request" ("requestId") `
+    );
+    await queryRunner.query(
+      `CREATE INDEX "IDX_a1aa713f41c99e9d10c48da75a" ON "media_request" ("mediaId") `
+    );
+    await queryRunner.query(
+      `CREATE INDEX "IDX_6997bee94720f1ecb7f3113709" ON "media_request" ("requestedById") `
+    );
+    await queryRunner.query(
+      `CREATE INDEX "IDX_f4fc4efa14c3ba2b29c4525fa1" ON "media_request" ("modifiedById") `
+    );
+    await queryRunner.query(
+      `CREATE INDEX "IDX_03f7958328e311761b0de675fb" ON "user_push_subscription" ("userId") `
+    );
+    await queryRunner.query(
+      `CREATE INDEX "IDX_09b94c932e84635c5461f3c0a9" ON "blocklist" ("tmdbId") `
+    );
+    await queryRunner.query(
+      `CREATE INDEX "IDX_356721a49f145aa439c16e6b99" ON "blocklist" ("userId") `
+    );
+    await queryRunner.query(
+      `CREATE INDEX "IDX_087099b39600be695591da9a49" ON "season" ("mediaId") `
+    );
+    await queryRunner.query(`DROP INDEX "IDX_09b94c932e84635c5461f3c0a9"`);
+    await queryRunner.query(`DROP INDEX "IDX_356721a49f145aa439c16e6b99"`);
+    await queryRunner.query(
+      `CREATE TABLE "temporary_blocklist" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "mediaType" varchar NOT NULL, "title" varchar, "tmdbId" integer NOT NULL, "blocklistedTags" varchar, "createdAt" datetime NOT NULL DEFAULT (CURRENT_TIMESTAMP), "userId" integer, "mediaId" integer, CONSTRAINT "REL_62b7ade94540f9f8d8bede54b9" UNIQUE ("mediaId"), CONSTRAINT "UQ_6bbafa28411e6046421991ea21c" UNIQUE ("tmdbId"), CONSTRAINT "FK_356721a49f145aa439c16e6b999" FOREIGN KEY ("userId") REFERENCES "user" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT "FK_5c8af2d0e83b3be6d250eccc19d" FOREIGN KEY ("mediaId") REFERENCES "media" ("id") ON DELETE CASCADE ON UPDATE NO ACTION)`
+    );
+    await queryRunner.query(
+      `INSERT INTO "temporary_blocklist"("id", "mediaType", "title", "tmdbId", "blocklistedTags", "createdAt", "userId", "mediaId") SELECT "id", "mediaType", "title", "tmdbId", "blocklistedTags", "createdAt", "userId", "mediaId" FROM "blocklist"`
+    );
+    await queryRunner.query(`DROP TABLE "blocklist"`);
+    await queryRunner.query(
+      `ALTER TABLE "temporary_blocklist" RENAME TO "blocklist"`
+    );
+    await queryRunner.query(
+      `CREATE INDEX "IDX_09b94c932e84635c5461f3c0a9" ON "blocklist" ("tmdbId") `
+    );
+    await queryRunner.query(
+      `CREATE INDEX "IDX_356721a49f145aa439c16e6b99" ON "blocklist" ("userId") `
+    );
+  }
+
+  public async down(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.query(`DROP INDEX "IDX_356721a49f145aa439c16e6b99"`);
+    await queryRunner.query(`DROP INDEX "IDX_09b94c932e84635c5461f3c0a9"`);
+    await queryRunner.query(
+      `ALTER TABLE "blocklist" RENAME TO "temporary_blocklist"`
+    );
+    await queryRunner.query(
+      `CREATE TABLE "blocklist" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "mediaType" varchar NOT NULL, "title" varchar, "tmdbId" integer NOT NULL, "blocklistedTags" varchar, "createdAt" datetime NOT NULL DEFAULT (CURRENT_TIMESTAMP), "userId" integer, "mediaId" integer, CONSTRAINT "REL_62b7ade94540f9f8d8bede54b9" UNIQUE ("mediaId"), CONSTRAINT "UQ_6bbafa28411e6046421991ea21c" UNIQUE ("tmdbId"))`
+    );
+    await queryRunner.query(
+      `INSERT INTO "blocklist"("id", "mediaType", "title", "tmdbId", "blocklistedTags", "createdAt", "userId", "mediaId") SELECT "id", "mediaType", "title", "tmdbId", "blocklistedTags", "createdAt", "userId", "mediaId" FROM "temporary_blocklist"`
+    );
+    await queryRunner.query(`DROP TABLE "temporary_blocklist"`);
+    await queryRunner.query(
+      `CREATE INDEX "IDX_356721a49f145aa439c16e6b99" ON "blocklist" ("userId") `
+    );
+    await queryRunner.query(
+      `CREATE INDEX "IDX_09b94c932e84635c5461f3c0a9" ON "blocklist" ("tmdbId") `
+    );
+    await queryRunner.query(`DROP INDEX "IDX_087099b39600be695591da9a49"`);
+    await queryRunner.query(`DROP INDEX "IDX_356721a49f145aa439c16e6b99"`);
+    await queryRunner.query(`DROP INDEX "IDX_09b94c932e84635c5461f3c0a9"`);
+    await queryRunner.query(`DROP INDEX "IDX_03f7958328e311761b0de675fb"`);
+    await queryRunner.query(`DROP INDEX "IDX_f4fc4efa14c3ba2b29c4525fa1"`);
+    await queryRunner.query(`DROP INDEX "IDX_6997bee94720f1ecb7f3113709"`);
+    await queryRunner.query(`DROP INDEX "IDX_a1aa713f41c99e9d10c48da75a"`);
+    await queryRunner.query(`DROP INDEX "IDX_6f14737e346d6b27d8e50d2157"`);
+    await queryRunner.query(`DROP INDEX "IDX_da88a1019c850d1a7b143ca02e"`);
+    await queryRunner.query(`DROP INDEX "IDX_10b17b49d1ee77e7184216001e"`);
+    await queryRunner.query(`DROP INDEX "IDX_276e20d053f3cff1645803c95d"`);
+    await queryRunner.query(`DROP INDEX "IDX_53d04c07c3f4f54eae372ed665"`);
+    await queryRunner.query(`DROP INDEX "IDX_180710fead1c94ca499c57a7d4"`);
+    await queryRunner.query(`DROP INDEX "IDX_707b033c2d0653f75213614789"`);
+    await queryRunner.query(`DROP INDEX "IDX_6641da8d831b93dfcb429f8b8b"`);
+    await queryRunner.query(`DROP INDEX "IDX_ae34e6b153a90672eb9dc4857d"`);
+    await queryRunner.query(
+      `ALTER TABLE "blocklist" RENAME TO "temporary_blocklist"`
+    );
+    await queryRunner.query(
+      `CREATE TABLE "blocklist" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "mediaType" varchar NOT NULL, "title" varchar, "tmdbId" integer NOT NULL, "blocklistedTags" varchar, "createdAt" datetime NOT NULL DEFAULT (datetime('now')), "userId" integer, "mediaId" integer, CONSTRAINT "REL_62b7ade94540f9f8d8bede54b9" UNIQUE ("mediaId"), CONSTRAINT "UQ_6bbafa28411e6046421991ea21c" UNIQUE ("tmdbId"))`
+    );
+    await queryRunner.query(
+      `INSERT INTO "blocklist"("id", "mediaType", "title", "tmdbId", "blocklistedTags", "createdAt", "userId", "mediaId") SELECT "id", "mediaType", "title", "tmdbId", "blocklistedTags", "createdAt", "userId", "mediaId" FROM "temporary_blocklist"`
+    );
+    await queryRunner.query(`DROP TABLE "temporary_blocklist"`);
+    await queryRunner.query(
+      `ALTER TABLE "user_push_subscription" RENAME TO "temporary_user_push_subscription"`
+    );
+    await queryRunner.query(
+      `CREATE TABLE "user_push_subscription" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "endpoint" varchar NOT NULL, "p256dh" varchar NOT NULL, "auth" varchar NOT NULL, "userId" integer, "userAgent" varchar, "createdAt" datetime DEFAULT (CURRENT_TIMESTAMP), CONSTRAINT "UQ_6427d07d9a171a3a1ab87480005" UNIQUE ("endpoint", "userId"), CONSTRAINT "UQ_f90ab5a4ed54905a4bb51a7148b" UNIQUE ("auth"), CONSTRAINT "FK_03f7958328e311761b0de675fbe" FOREIGN KEY ("userId") REFERENCES "user" ("id") ON DELETE CASCADE ON UPDATE NO ACTION)`
+    );
+    await queryRunner.query(
+      `INSERT INTO "user_push_subscription"("id", "endpoint", "p256dh", "auth", "userId", "userAgent", "createdAt") SELECT "id", "endpoint", "p256dh", "auth", "userId", "userAgent", "createdAt" FROM "temporary_user_push_subscription"`
+    );
+    await queryRunner.query(`DROP TABLE "temporary_user_push_subscription"`);
+    await queryRunner.query(
+      `ALTER TABLE "user_push_subscription" RENAME TO "temporary_user_push_subscription"`
+    );
+    await queryRunner.query(
+      `CREATE TABLE "user_push_subscription" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "endpoint" varchar NOT NULL, "p256dh" varchar NOT NULL, "auth" varchar NOT NULL, "userId" integer, "userAgent" varchar, "createdAt" datetime DEFAULT (CURRENT_TIMESTAMP), CONSTRAINT "UQ_6427d07d9a171a3a1ab87480005" UNIQUE ("endpoint", "userId"), CONSTRAINT "UQ_f90ab5a4ed54905a4bb51a7148b" UNIQUE ("auth"), CONSTRAINT "FK_03f7958328e311761b0de675fbe" FOREIGN KEY ("userId") REFERENCES "user" ("id") ON DELETE CASCADE ON UPDATE NO ACTION)`
+    );
+    await queryRunner.query(
+      `INSERT INTO "user_push_subscription"("id", "endpoint", "p256dh", "auth", "userId", "userAgent", "createdAt") SELECT "id", "endpoint", "p256dh", "auth", "userId", "userAgent", "createdAt" FROM "temporary_user_push_subscription"`
+    );
+    await queryRunner.query(`DROP TABLE "temporary_user_push_subscription"`);
+    await queryRunner.query(
+      `CREATE INDEX "IDX_6bbafa28411e6046421991ea21" ON "blocklist" ("tmdbId") `
+    );
+    await queryRunner.query(`DROP INDEX "IDX_6bbafa28411e6046421991ea21"`);
+    await queryRunner.query(
+      `ALTER TABLE "blocklist" RENAME TO "temporary_blocklist"`
+    );
+    await queryRunner.query(
+      `CREATE TABLE "blocklist" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "mediaType" varchar NOT NULL, "title" varchar, "tmdbId" integer NOT NULL, "blocklistedTags" varchar, "createdAt" datetime NOT NULL DEFAULT (datetime('now')), "userId" integer, "mediaId" integer, CONSTRAINT "REL_62b7ade94540f9f8d8bede54b9" UNIQUE ("mediaId"), CONSTRAINT "UQ_6bbafa28411e6046421991ea21c" UNIQUE ("tmdbId"), CONSTRAINT "FK_62b7ade94540f9f8d8bede54b99" FOREIGN KEY ("mediaId") REFERENCES "media" ("id") ON DELETE CASCADE ON UPDATE NO ACTION, CONSTRAINT "FK_53c1ab62c3e5875bc3ac474823e" FOREIGN KEY ("userId") REFERENCES "user" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION)`
+    );
+    await queryRunner.query(
+      `INSERT INTO "blocklist"("id", "mediaType", "title", "tmdbId", "blocklistedTags", "createdAt", "userId", "mediaId") SELECT "id", "mediaType", "title", "tmdbId", "blocklistedTags", "createdAt", "userId", "mediaId" FROM "temporary_blocklist"`
+    );
+    await queryRunner.query(`DROP TABLE "temporary_blocklist"`);
+    await queryRunner.query(
+      `CREATE INDEX "IDX_6bbafa28411e6046421991ea21" ON "blocklist" ("tmdbId") `
+    );
+  }
+}
Author	SHA1	Message	Date
renovate[bot]	51f4ce1358	chore(deps): update dependency tailwindcss to v3.4.19	2026-02-17 15:16:42 +00:00
Joe Harrison	4939f13dbe	ci: update concurrency logic (#2481 )	2026-02-17 14:47:16 +01:00
Dallas Gordon	5e57fdcf66	ci: add semantic-pr workflow to enforce conventional commits (#2472 )	2026-02-17 13:33:41 +00:00
fallenbagel	cf4883a55e	chore(github): add docs and maintenance issue templates (#2467 )	2026-02-17 11:47:58 +01:00
blassley	5e64d49c32	docs(unraid): improve unraid migration guide (#2470 )	2026-02-17 05:12:47 +05:00
fallenbagel	c6bcfe0ae4	perf: add missing indexes on all foreign key columns (#2461 )	2026-02-17 00:36:55 +08:00
Jan Kleine	6076878f76	docs(notifications): revise web push notification docs [skip ci] (#2451 ) Co-authored-by: Copilot <175728472+Copilot@users.noreply.github.com>	2026-02-16 17:19:43 +05:00
Sandesh Koirala	8f0c904928	feat(helm): use an existing PVC as config volume (#2447 )	2026-02-16 09:09:11 +01:00