DELETE FROM events
WHERE rowid NOT IN (
  SELECT MIN(rowid)
  FROM events
  GROUP BY uid
);

CREATE TABLE events_new (
  "event_uid" INTEGER PRIMARY KEY,
  "uid" TEXT NOT NULL UNIQUE,
  "title" TEXT NOT NULL,
  "date_at" DATETIME NOT NULL,
  "time_start" TEXT NOT NULL,
  "time_end" TEXT NOT NULL,
  "posted_by" TEXT NOT NULL,
  "location" TEXT NOT NULL,
  "event_type" TEXT NOT NULL,
  "link" TEXT NOT NULL,
  "description" TEXT NOT NULL,
  "timezone" TEXT NOT NULL,
  "notification" TEXT NOT NULL,
  "deleteDate" INTEGER NULL
);

INSERT INTO events_new (event_uid, uid, title, date_at, time_start, time_end, posted_by, location, event_type, link, description, timezone, notification, deleteDate)
SELECT event_uid, uid, title, date_at, time_start, time_end, posted_by, location, event_type, link, description, timezone, notification, deleteDate FROM events;

DROP TABLE events;
ALTER TABLE events_new RENAME TO events;