1
CREATE TABLE `run_logs` (
2
	`id` text PRIMARY KEY NOT NULL,
3
	`run_id` text NOT NULL,
4
	`seq` integer NOT NULL,
5
	`stream` text NOT NULL,
6
	`chunk` text NOT NULL,
7
	`created_at` integer NOT NULL
8
);
9
--> statement-breakpoint
10
CREATE UNIQUE INDEX `idx_run_logs_run_seq` ON `run_logs` (`run_id`,`seq`);--> statement-breakpoint
11
CREATE INDEX `idx_run_logs_run_created_at` ON `run_logs` (`run_id`,`created_at`);--> statement-breakpoint
12
CREATE TABLE `run_meta` (
13
	`id` text PRIMARY KEY NOT NULL,
14
	`project_id` text NOT NULL,
15
	`status` text NOT NULL,
16
	`trigger_type` text NOT NULL,
17
	`branch` text NOT NULL,
18
	`commit_sha` text,
19
	`current_step` integer,
20
	`started_at` integer,
21
	`finished_at` integer,
22
	`exit_code` integer,
23
	`error_message` text
24
);
25
--> statement-breakpoint
26
CREATE INDEX `idx_run_meta_project_started_at` ON `run_meta` (`project_id`,`started_at`);--> statement-breakpoint
27
CREATE TABLE `run_steps` (
28
	`id` text PRIMARY KEY NOT NULL,
29
	`run_id` text NOT NULL,
30
	`position` integer NOT NULL,
31
	`name` text NOT NULL,
32
	`command` text NOT NULL,
33
	`status` text NOT NULL,
34
	`started_at` integer,
35
	`finished_at` integer,
36
	`exit_code` integer
37
);
38
--> statement-breakpoint
39
CREATE UNIQUE INDEX `idx_run_steps_run_position` ON `run_steps` (`run_id`,`position`);