CREATE TABLE IF NOT EXISTS "categories" (
  "id" TEXT PRIMARY KEY, /* UUID */
  "name" TEXT NOT NULL UNIQUE,
  "color" TEXT NOT NULL, /* COLOR */
  "created" TEXT NOT NULL, /* DATETIME */
  "updated" TEXT NOT NULL /* DATETIME */
);

ALTER TABLE "events" ADD COLUMN "category" TEXT REFERENCES "categories" ("id"); /* UUID */

PRAGMA foreign_keys = ON
