-- 006_bookmark_kanban_position.sql — persisted card ordering on kanban
-- boards. Every card move normalizes the target column's positions so a
-- drag inside a column survives reloads and concurrent moves stay
-- deterministic. Legacy rows default to 0 and keep their existing
-- updatedAt-descending order until the column is first arranged.
ALTER TABLE "Bookmark" ADD COLUMN IF NOT EXISTS "kanbanPosition" integer NOT NULL DEFAULT 0;
CREATE INDEX IF NOT EXISTS "Bookmark_ownerId_kanbanColumnId_kanbanPosition_idx"
  ON "Bookmark"("ownerId","kanbanColumnId","kanbanPosition",id);