18 lines
409 B
SQL
18 lines
409 B
SQL
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`);
|