CREATE TABLE `cache` (
  `scope` text NOT NULL,
  `key` text PRIMARY KEY NOT NULL,
  `json` text,
  `binary` blob,
  `created_at` integer DEFAULT (CURRENT_TIMESTAMP),
  `expires_at` integer
);

--> statement-breakpoint
CREATE INDEX `key_idx` ON `cache` (`key`);

--> statement-breakpoint
CREATE INDEX `scope_idx` ON `cache` (`scope`);

--> statement-breakpoint
CREATE INDEX `name_idx` ON `document` (`name`);