Files
logbuch/drizzle/0010_steady_wither.sql
Matthias G 2fd71fd406 Number entries on publish, delete media, read the cover
- drafts stay unnumbered, the number is handed out when an entry goes live
- DELETE /api/v1/media/:id and a delete control in the media library
- cover_media_id in the draft read, coverMediaId and coverUrl in the archive read
2026-08-01 12:25:01 +02:00

2 lines
139 B
SQL

ALTER TABLE "post" ALTER COLUMN "number" DROP NOT NULL;--> statement-breakpoint
UPDATE "post" SET "number" = NULL WHERE "status" = 'draft';