[Backend] Soft Delete Implementation for Bounties

[gabito1451]

Independence Note: Simply modifying generic Prisma middleware or schema fields.

Context:
If a Guild Admin deletes a bounty, we don't want to permanently wipe the database record due to audit trails and on-chain syncing mismatches.

Objective:
Refactor the Bounty entity to utilize "Soft Deletes".

Acceptance Criteria:

• Add a deletedAt DateTime column (nullable) to the Bounty model in schema.prisma.
• Generate the new Prisma client.
• Update the GET /bounties endpoints to explicitly filter out any records where deletedAt is NOT NULL.
• Change the DELETE /bounties/:id endpoint to perform an UPDATE setting deletedAt = NOW() rather than a destructive Prisma .delete().

Technical Pointers:

• You can use Prisma extensions or explicit query arguments. Avoid Prisma middleware as it is deprecated in Prisma 5.

[Halo11112222]

Hey! I just submitted a PR for this: #343

The schema already had the deletedAt field on the Bounty model, so I just needed to wire up the filtering and the soft delete logic.

What I did:

• Added deletedAt: null to all the query methods so deleted bounties never show up
• Added a remove() method that sets the timestamp instead of hard deleting
• Added the DELETE /bounties/:id endpoint

Let me know what you think!