Open-source AI coworkers that each get a computer of their own: a browser, files and tools, with every action decided before it happens and recorded after. Bring any AG-UI agent.
CREATE TABLE "learning_open_skills" (
"user_id" text NOT NULL,
"skill_name" text NOT NULL,
"created_at" timestamp with time zone DEFAULT now() NOT NULL,
CONSTRAINT "learning_open_skills_user_id_skill_name_pk" PRIMARY KEY("user_id","skill_name")
);
--> statement-breakpoint
CREATE TABLE "learning_person_spaces" (
"user_id" text PRIMARY KEY NOT NULL,
"container_id" text NOT NULL,
"created_at" timestamp with time zone DEFAULT now() NOT NULL,
CONSTRAINT "learning_person_spaces_container_id_unique" UNIQUE("container_id")
);
--> statement-breakpoint
CREATE TABLE "learning_skill_sharing" (
"user_id" text PRIMARY KEY NOT NULL,
"mode" text DEFAULT 'closed' NOT NULL,
"updated_at" timestamp with time zone DEFAULT now() NOT NULL,
CONSTRAINT "learning_skill_sharing_mode_check" CHECK ("learning_skill_sharing"."mode" IN ('closed', 'open', 'choose'))
);
--> statement-breakpoint
CREATE TABLE "recorder_connect_codes" (
"code_hash" text PRIMARY KEY NOT NULL,
"user_id" text NOT NULL,
"via" text NOT NULL,
"organization_session" text,
"created_at" timestamp with time zone DEFAULT now() NOT NULL,
"expires_at" timestamp with time zone NOT NULL
);
--> statement-breakpoint
CREATE TABLE "recorder_connections" (
"id" text PRIMARY KEY NOT NULL,
"user_id" text NOT NULL,
"token_hash" text NOT NULL,
"label" text NOT NULL,
"via" text NOT NULL,
"extension_id" text NOT NULL,
"install_id" text NOT NULL,
"organization_session" text,
"created_at" timestamp with time zone DEFAULT now() NOT NULL,
"last_used_at" timestamp with time zone,
"revoked_at" timestamp with time zone,
CONSTRAINT "recorder_connections_token_hash_unique" UNIQUE("token_hash")
);
--> statement-breakpoint
CREATE TABLE "recorder_trajectory_bindings" (
"trajectory_id" uuid PRIMARY KEY NOT NULL,
"user_id" text NOT NULL,
"created_at" timestamp with time zone DEFAULT now() NOT NULL
);
--> statement-breakpoint
ALTER TABLE "learning_open_skills" ADD CONSTRAINT "learning_open_skills_user_id_users_id_fk" FOREIGN KEY ("user_id") REFERENCES "public"."users"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
ALTER TABLE "learning_person_spaces" ADD CONSTRAINT "learning_person_spaces_user_id_users_id_fk" FOREIGN KEY ("user_id") REFERENCES "public"."users"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
ALTER TABLE "learning_skill_sharing" ADD CONSTRAINT "learning_skill_sharing_user_id_users_id_fk" FOREIGN KEY ("user_id") REFERENCES "public"."users"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
ALTER TABLE "recorder_connect_codes" ADD CONSTRAINT "recorder_connect_codes_user_id_users_id_fk" FOREIGN KEY ("user_id") REFERENCES "public"."users"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
ALTER TABLE "recorder_connections" ADD CONSTRAINT "recorder_connections_user_id_users_id_fk" FOREIGN KEY ("user_id") REFERENCES "public"."users"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
ALTER TABLE "recorder_trajectory_bindings" ADD CONSTRAINT "recorder_trajectory_bindings_user_id_users_id_fk" FOREIGN KEY ("user_id") REFERENCES "public"."users"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
CREATE INDEX "learning_skill_sharing_open_idx" ON "learning_skill_sharing" USING btree ("user_id") WHERE "learning_skill_sharing"."mode" <> 'closed';--> statement-breakpoint
CREATE INDEX "recorder_connect_codes_user_idx" ON "recorder_connect_codes" USING btree ("user_id");--> statement-breakpoint
CREATE INDEX "recorder_connections_user_idx" ON "recorder_connections" USING btree ("user_id","created_at");--> statement-breakpoint
CREATE UNIQUE INDEX "recorder_connections_live_install_idx" ON "recorder_connections" USING btree ("user_id","install_id") WHERE "recorder_connections"."revoked_at" IS NULL;--> statement-breakpoint
CREATE INDEX "recorder_trajectory_bindings_user_idx" ON "recorder_trajectory_bindings" USING btree ("user_id");