feat: Add source field to track bookmark creation sources (#2037)

* feat: Add source field to track bookmark creation sources

Add a new 'source' field to the bookmarks table to track where bookmarks
were created from. Possible values: api, web, cli, mobile, singlefile, rss.

Changes:
- Add source field to bookmarks table schema
- Update Zod schemas to include source field
- Update tRPC createBookmark procedure to store source
- Update all callsites to pass appropriate source value:
  - api: Default to "api" if not provided
  - singlefile: Set to "singlefile"
  - rss: Set to "rss" in feedWorker
  - cli: Set to "cli"
  - mobile: Set to "mobile" in all mobile app bookmark creation
  - browser-extension: Set to "web"
  - web: Set to "web" in all web app bookmark creation
- Create migration file for database schema change

Fixes #2036

🤖 Generated with [Claude Code](https://claude.com/claude-code)

Co-Authored-By: Mohamed Bassem <MohamedBassem@users.noreply.github.com>

* feat: Add extension source type for browser extension

- Add 'extension' to bookmark source enum
- Update browser extension to use 'extension' instead of 'web'

Co-authored-by: Mohamed Bassem <MohamedBassem@users.noreply.github.com>

* fix CI

* fix CI

* fix the migration file

* add import source

* make source nullish

---------

Co-authored-by: claude[bot] <41898282+claude[bot]@users.noreply.github.com>
Co-authored-by: Mohamed Bassem <MohamedBassem@users.noreply.github.com>

1 files changed, 6 insertions, 1 deletions

diff --git a/apps/mobile/lib/upload.ts b/apps/mobile/lib/upload.ts
index a9157d68..0eeab380 100644
--- a/apps/mobile/lib/upload.ts
+++ b/apps/mobile/lib/upload.ts
@@ -61,7 +61,12 @@ export function useUploadAsset(
       const assetId = resp.assetId;
       const assetType =
         resp.contentType === "application/pdf" ? "pdf" : "image";
-      createBookmark({ type: BookmarkTypes.ASSET, assetId, assetType });
+      createBookmark({
+        type: BookmarkTypes.ASSET,
+        assetId,
+        assetType,
+        source: "mobile",
+      });
     },
     onError: (e) => {
       if (options.onError) {