Skip to content
rachel/bland
File

Blob: drizzle/d1/0006_public_katie_power.sql

sql3 lines
1ALTER TABLE `pages` ADD `archive_root_id` text;--> statement-breakpoint
2CREATE INDEX `idx_pages_archive_operation` ON `pages` (`workspace_id`,`archive_root_id`,`archived_at`);--> statement-breakpoint
3CREATE INDEX `idx_pages_trash_roots` ON `pages` (`workspace_id`,`archived_at`) WHERE "pages"."archived_at" IS NOT NULL AND "pages"."archive_root_id" = "pages"."id";