SPB Git forge

spb/rareindex

Public
54commits 1branches 0releases
7.1 MBsize
maindefault branch
10 days agolast push
TypeScript 61.9% HTML 37.2% SQL 0.7%
781 B · 8 lines sql
Raw Blame History
1ALTER TABLE "images" ADD COLUMN IF NOT EXISTS "status" text DEFAULT 'unchecked' NOT NULL;--> statement-breakpoint2ALTER TABLE "images" ADD COLUMN IF NOT EXISTS "checked_at" timestamp with time zone;--> statement-breakpoint3ALTER TABLE "images" ADD COLUMN IF NOT EXISTS "bytes" integer;--> statement-breakpoint4ALTER TABLE "images" ADD COLUMN IF NOT EXISTS "content_type" text;--> statement-breakpoint5ALTER TABLE "images" ADD COLUMN IF NOT EXISTS "cache_key" text;--> statement-breakpoint6ALTER TABLE "images" ADD COLUMN IF NOT EXISTS "error" text;--> statement-breakpoint7CREATE INDEX IF NOT EXISTS "images_cache_key_idx" ON "images" USING btree ("cache_key");--> statement-breakpoint8CREATE INDEX IF NOT EXISTS "images_status_idx" ON "images" USING btree ("status","checked_at");