Blame · Line-by-line history

`0010_pages.sql`

Each line is annotated with the commit that last touched it. Click any SHA to jump to that commit and see the surrounding change.

0010_pages.sqlBlame34 lines · 1 contributor

Normal view Raw

e2da5c6Claude	1	-- Gluecron migration 0010: Block C3 — Pages / static hosting.
	2	--
	3	-- Tables:
	4	-- pages_deployments — recorded every time the source branch advances
	5	-- pages_settings — per-repo pages config (enabled, source branch/dir, custom domain)
	6
	7	--> statement-breakpoint
	8	CREATE TABLE IF NOT EXISTS "pages_deployments" (
	9	"id" uuid PRIMARY KEY DEFAULT gen_random_uuid() NOT NULL,
	10	"repository_id" uuid NOT NULL,
	11	"ref" text NOT NULL DEFAULT 'refs/heads/gh-pages',
	12	"commit_sha" text NOT NULL,
	13	"status" text NOT NULL DEFAULT 'success',
	14	"triggered_by" uuid,
	15	"created_at" timestamp DEFAULT now() NOT NULL,
	16	CONSTRAINT "pages_deployments_repo_fk" FOREIGN KEY ("repository_id") REFERENCES "repositories"("id") ON DELETE cascade,
	17	CONSTRAINT "pages_deployments_user_fk" FOREIGN KEY ("triggered_by") REFERENCES "users"("id") ON DELETE set null
	18	);
	19
	20	--> statement-breakpoint
	21	CREATE INDEX IF NOT EXISTS "pages_deployments_repo" ON "pages_deployments" ("repository_id");
	22	--> statement-breakpoint
	23	CREATE INDEX IF NOT EXISTS "pages_deployments_created" ON "pages_deployments" ("created_at");
	24
	25	--> statement-breakpoint
	26	CREATE TABLE IF NOT EXISTS "pages_settings" (
	27	"repository_id" uuid PRIMARY KEY NOT NULL,
	28	"enabled" boolean NOT NULL DEFAULT true,
	29	"source_branch" text NOT NULL DEFAULT 'gh-pages',
	30	"source_dir" text NOT NULL DEFAULT '/',
	31	"custom_domain" text,
	32	"updated_at" timestamp DEFAULT now() NOT NULL,
	33	CONSTRAINT "pages_settings_repo_fk" FOREIGN KEY ("repository_id") REFERENCES "repositories"("id") ON DELETE cascade
	34	);