1
CREATE TABLE `pack_catalog` (
2
	`pack_key` text PRIMARY KEY NOT NULL,
3
	`kind` text NOT NULL,
4
	`state` text NOT NULL,
5
	`tier` integer NOT NULL,
6
	`seq_lo` integer NOT NULL,
7
	`seq_hi` integer NOT NULL,
8
	`object_count` integer NOT NULL,
9
	`pack_bytes` integer NOT NULL,
10
	`idx_bytes` integer NOT NULL,
11
	`created_at` integer NOT NULL,
12
	`superseded_by` text,
13
	CONSTRAINT "chk_pack_catalog_kind" CHECK("kind" IN ('receive','compact','legacy')),
14
	CONSTRAINT "chk_pack_catalog_state" CHECK("state" IN ('active','superseded')),
15
	CONSTRAINT "chk_pack_catalog_tier" CHECK("tier" >= 0),
16
	CONSTRAINT "chk_pack_catalog_seq" CHECK("seq_lo" <= "seq_hi"),
17
	CONSTRAINT "chk_pack_catalog_object_count" CHECK("object_count" >= 0),
18
	CONSTRAINT "chk_pack_catalog_pack_bytes" CHECK("pack_bytes" >= 0),
19
	CONSTRAINT "chk_pack_catalog_idx_bytes" CHECK("idx_bytes" >= 0)
20
);
21
--> statement-breakpoint
22
CREATE INDEX `idx_pack_catalog_state_seqhi` ON `pack_catalog` (`state`,"seq_hi" desc);--> statement-breakpoint
23
CREATE INDEX `idx_pack_catalog_state_tier_seqlo` ON `pack_catalog` (`state`,`tier`,`seq_lo`);