SQLite: error parsing schema with `UNIQUE` about sqlc HOT 2 CLOSED

CREATE TABLE tasks(
  id integer,
  created_at datetime,
  updated_at datetime,
  uuid char(36) UNIQUE DEFAULT '',
  name varchar(64) DEFAULT '',
  type varchar(32) DEFAULT '',
  job_id integer DEFAULT 0,
  priority smallint DEFAULT 50,
  status varchar(16) DEFAULT '',
  worker_id integer,
  last_touched_at datetime,
  commands jsonb,
  activity varchar(255) DEFAULT '',
  PRIMARY KEY(id)
);

-- name: GetTask :one
SELECT * FROM tasks
WHERE uuid = ? LIMIT 1;