Something went wrong. Try again.
This repository has no description
Something went wrong. Try again.
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372CREATE TYPE "public"."tangled_pipeline_status_status" AS ENUM('pending', 'running', 'failed', 'timeout', 'cancelled', 'success');--> statement-breakpointCREATE TYPE "public"."tangled_pipeline_trigger_metadata_kind" AS ENUM('push', 'pull_request', 'manual');--> statement-breakpointCREATE TYPE "public"."tangled_vouch_kind" AS ENUM('vouch', 'denounce');--> statement-breakpointCREATE TABLE "tangled_artifact" ( "did" text NOT NULL, "rev" text NOT NULL, "rkey" text NOT NULL, "cid" text, "deleted" boolean NOT NULL, "name" text, "repo" text, "repo_did" text, "tag" text, "created_at" timestamp with time zone, "artifact_ref" text, "artifact_size" integer, "artifact_mime_type" text, CONSTRAINT "tangled_artifact_did_rkey_pk" PRIMARY KEY("did","rkey"), CONSTRAINT "tangled_artifact_cid_only_null_if_deleted" CHECK (("tangled_artifact"."cid" is not null or "tangled_artifact"."deleted" = true)), CONSTRAINT "tangled_artifact_non_null_fields" CHECK (("tangled_artifact"."deleted" = true or ("tangled_artifact"."name" is not null and "tangled_artifact"."tag" is not null and "tangled_artifact"."created_at" is not null and "tangled_artifact"."artifact_ref" is not null and "tangled_artifact"."artifact_size" is not null and "tangled_artifact"."artifact_mime_type" is not null))));--> statement-breakpointCREATE TABLE "tangled_collaborator" ( "did" text NOT NULL, "rev" text NOT NULL, "rkey" text NOT NULL, "cid" text, "deleted" boolean NOT NULL, "subject" text, "repo" text, "repo_did" text, "created_at" timestamp with time zone, CONSTRAINT "tangled_collaborator_did_rkey_pk" PRIMARY KEY("did","rkey"), CONSTRAINT "tangled_collaborator_cid_only_null_if_deleted" CHECK (("tangled_collaborator"."cid" is not null or "tangled_collaborator"."deleted" = true)), CONSTRAINT "tangled_collaborator_non_null_fields" CHECK (("tangled_collaborator"."deleted" = true or ("tangled_collaborator"."subject" is not null and "tangled_collaborator"."created_at" is not null))));--> statement-breakpointCREATE TABLE "tangled_follow" ( "did" text NOT NULL, "rev" text NOT NULL, "rkey" text NOT NULL, "cid" text, "deleted" boolean NOT NULL, "subject" text, "created_at" timestamp with time zone, CONSTRAINT "tangled_follow_did_rkey_pk" PRIMARY KEY("did","rkey"), CONSTRAINT "tangled_follow_cid_only_null_if_deleted" CHECK (("tangled_follow"."cid" is not null or "tangled_follow"."deleted" = true)), CONSTRAINT "tangled_follow_non_null_fields" CHECK (("tangled_follow"."deleted" = true or ("tangled_follow"."subject" is not null and "tangled_follow"."created_at" is not null))));--> statement-breakpointCREATE TABLE "tangled_issue" ( "did" text NOT NULL, "rev" text NOT NULL, "rkey" text NOT NULL, "cid" text, "deleted" boolean NOT NULL, "repo" text, "repo_did" text, "title" text, "body" text, "created_at" timestamp with time zone, "mentions" text[], "references" text[], CONSTRAINT "tangled_issue_did_rkey_pk" PRIMARY KEY("did","rkey"), CONSTRAINT "tangled_issue_cid_only_null_if_deleted" CHECK (("tangled_issue"."cid" is not null or "tangled_issue"."deleted" = true)), CONSTRAINT "tangled_issue_non_null_fields" CHECK (("tangled_issue"."deleted" = true or ("tangled_issue"."title" is not null and "tangled_issue"."created_at" is not null))));--> statement-breakpointCREATE TABLE "tangled_issue_comment" ( "did" text NOT NULL, "rev" text NOT NULL, "rkey" text NOT NULL, "cid" text, "deleted" boolean NOT NULL, "issue" text, "body" text, "created_at" timestamp with time zone, "reply_to" text, "mentions" text[], "references" text[], CONSTRAINT "tangled_issue_comment_did_rkey_pk" PRIMARY KEY("did","rkey"), CONSTRAINT "tangled_issue_comment_cid_only_null_if_deleted" CHECK (("tangled_issue_comment"."cid" is not null or "tangled_issue_comment"."deleted" = true)), CONSTRAINT "tangled_issue_comment_non_null_fields" CHECK (("tangled_issue_comment"."deleted" = true or ("tangled_issue_comment"."issue" is not null and "tangled_issue_comment"."body" is not null and "tangled_issue_comment"."created_at" is not null))));--> statement-breakpointCREATE TABLE "tangled_issue_state" ( "did" text NOT NULL, "rev" text NOT NULL, "rkey" text NOT NULL, "cid" text, "deleted" boolean NOT NULL, "issue" text, "state" text, CONSTRAINT "tangled_issue_state_did_rkey_pk" PRIMARY KEY("did","rkey"), CONSTRAINT "tangled_issue_state_cid_only_null_if_deleted" CHECK (("tangled_issue_state"."cid" is not null or "tangled_issue_state"."deleted" = true)), CONSTRAINT "tangled_issue_state_non_null_fields" CHECK (("tangled_issue_state"."deleted" = true or ("tangled_issue_state"."issue" is not null and "tangled_issue_state"."state" is not null))));--> statement-breakpointCREATE TABLE "tangled_knot" ( "did" text NOT NULL, "rev" text NOT NULL, "rkey" text NOT NULL, "cid" text, "deleted" boolean NOT NULL, "created_at" timestamp with time zone, CONSTRAINT "tangled_knot_did_rkey_pk" PRIMARY KEY("did","rkey"), CONSTRAINT "tangled_knot_cid_only_null_if_deleted" CHECK (("tangled_knot"."cid" is not null or "tangled_knot"."deleted" = true)), CONSTRAINT "tangled_knot_non_null_fields" CHECK (("tangled_knot"."deleted" = true or "tangled_knot"."created_at" is not null)));--> statement-breakpointCREATE TABLE "tangled_knot_member" ( "did" text NOT NULL, "rev" text NOT NULL, "rkey" text NOT NULL, "cid" text, "deleted" boolean NOT NULL, "subject" text, "domain" text, "created_at" timestamp with time zone, CONSTRAINT "tangled_knot_member_did_rkey_pk" PRIMARY KEY("did","rkey"), CONSTRAINT "tangled_knot_member_cid_only_null_if_deleted" CHECK (("tangled_knot_member"."cid" is not null or "tangled_knot_member"."deleted" = true)), CONSTRAINT "tangled_knot_member_non_null_fields" CHECK (("tangled_knot_member"."deleted" = true or ("tangled_knot_member"."subject" is not null and "tangled_knot_member"."domain" is not null and "tangled_knot_member"."created_at" is not null))));--> statement-breakpointCREATE TABLE "tangled_label_definition" ( "did" text NOT NULL, "rev" text NOT NULL, "rkey" text NOT NULL, "cid" text, "deleted" boolean NOT NULL, "name" text, "value_type" text, "value_format" text, "value_enum" text[], "scope" text[], "color" text, "created_at" timestamp with time zone, "multiple" boolean, CONSTRAINT "tangled_label_definition_did_rkey_pk" PRIMARY KEY("did","rkey"), CONSTRAINT "tangled_label_definition_cid_only_null_if_deleted" CHECK (("tangled_label_definition"."cid" is not null or "tangled_label_definition"."deleted" = true)), CONSTRAINT "tangled_label_definition_non_null_fields" CHECK (("tangled_label_definition"."deleted" = true or ("tangled_label_definition"."name" is not null and "tangled_label_definition"."value_type" is not null and "tangled_label_definition"."value_format" is not null and "tangled_label_definition"."scope" is not null and "tangled_label_definition"."created_at" is not null))));--> statement-breakpointCREATE TABLE "tangled_label_op" ( "did" text NOT NULL, "rev" text NOT NULL, "rkey" text NOT NULL, "cid" text, "deleted" boolean NOT NULL, "subject" text, "performed_at" timestamp with time zone, "add" jsonb, "delete" jsonb, CONSTRAINT "tangled_label_op_did_rkey_pk" PRIMARY KEY("did","rkey"), CONSTRAINT "tangled_label_op_cid_only_null_if_deleted" CHECK (("tangled_label_op"."cid" is not null or "tangled_label_op"."deleted" = true)), CONSTRAINT "tangled_label_op_non_null_fields" CHECK (("tangled_label_op"."deleted" = true or ("tangled_label_op"."subject" is not null and "tangled_label_op"."add" is not null and "tangled_label_op"."delete" is not null and "tangled_label_op"."performed_at" is not null))));--> statement-breakpointCREATE TABLE "tangled_pipeline" ( "did" text NOT NULL, "rev" text NOT NULL, "rkey" text NOT NULL, "cid" text, "deleted" boolean NOT NULL, "trigger_metadata_kind" "tangled_pipeline_trigger_metadata_kind", "trigger_metadata_repo_knot" text, "trigger_metadata_repo_did" text, "trigger_metadata_repo_repo_did" text, "trigger_metadata_repo_repo" text, "trigger_metadata_repo_default_branch" text, "trigger_metadata_push_ref" text, "trigger_metadata_push_new_sha" text, "trigger_metadata_push_old_sha" text, "trigger_metadata_pull_source_branch" text, "trigger_metadata_pull_target_branch" text, "trigger_metadata_pull_source_sha" text, "trigger_metadata_pull_action" text, "trigger_metadata_manual" jsonb, "workflows" jsonb, CONSTRAINT "tangled_pipeline_did_rkey_pk" PRIMARY KEY("did","rkey"), CONSTRAINT "tangled_pipeline_cid_only_null_if_deleted" CHECK (("tangled_pipeline"."cid" is not null or "tangled_pipeline"."deleted" = true)), CONSTRAINT "tangled_pipeline_non_null_fields" CHECK (("tangled_pipeline"."deleted" = true or ("tangled_pipeline"."trigger_metadata_kind" is not null and "tangled_pipeline"."trigger_metadata_repo_knot" is not null and "tangled_pipeline"."trigger_metadata_repo_did" is not null and "tangled_pipeline"."trigger_metadata_repo_default_branch" is not null and "tangled_pipeline"."workflows" is not null))));--> statement-breakpointCREATE TABLE "tangled_pipeline_status" ( "did" text NOT NULL, "rev" text NOT NULL, "rkey" text NOT NULL, "cid" text, "deleted" boolean NOT NULL, "pipeline" text, "workflow" text, "status" "tangled_pipeline_status_status", "created_at" timestamp with time zone, "error" text, "exit_code" integer, CONSTRAINT "tangled_pipeline_status_did_rkey_pk" PRIMARY KEY("did","rkey"), CONSTRAINT "tangled_pipeline_status_cid_only_null_if_deleted" CHECK (("tangled_pipeline_status"."cid" is not null or "tangled_pipeline_status"."deleted" = true)), CONSTRAINT "tangled_pipeline_status_non_null_fields" CHECK (("tangled_pipeline_status"."deleted" = true or ("tangled_pipeline_status"."pipeline" is not null and "tangled_pipeline_status"."workflow" is not null and "tangled_pipeline_status"."status" is not null and "tangled_pipeline_status"."created_at" is not null))));--> statement-breakpointCREATE TABLE "tangled_public_key" ( "did" text NOT NULL, "rev" text NOT NULL, "rkey" text NOT NULL, "cid" text, "deleted" boolean NOT NULL, "key" text, "name" text, "created_at" timestamp with time zone, CONSTRAINT "tangled_public_key_did_rkey_pk" PRIMARY KEY("did","rkey"), CONSTRAINT "tangled_public_key_cid_only_null_if_deleted" CHECK (("tangled_public_key"."cid" is not null or "tangled_public_key"."deleted" = true)), CONSTRAINT "tangled_public_key_non_null_fields" CHECK (("tangled_public_key"."deleted" = true or ("tangled_public_key"."key" is not null and "tangled_public_key"."name" is not null and "tangled_public_key"."created_at" is not null))));--> statement-breakpointCREATE TABLE "tangled_pull" ( "did" text NOT NULL, "rev" text NOT NULL, "rkey" text NOT NULL, "cid" text, "deleted" boolean NOT NULL, "title" text, "body" text, "rounds" jsonb, "source_branch" text, "source_repo" text, "source_repo_did" text, "target_branch" text, "target_repo" text, "target_repo_did" text, "created_at" timestamp with time zone, "mentions" text[], "references" text[], "dependent_on" text, CONSTRAINT "tangled_pull_did_rkey_pk" PRIMARY KEY("did","rkey"), CONSTRAINT "tangled_pull_cid_only_null_if_deleted" CHECK (("tangled_pull"."cid" is not null or "tangled_pull"."deleted" = true)), CONSTRAINT "tangled_pull_non_null_fields" CHECK (("tangled_pull"."deleted" = true or ("tangled_pull"."target_branch" is not null and "tangled_pull"."title" is not null and "tangled_pull"."created_at" is not null and "tangled_pull"."rounds" is not null))));--> statement-breakpointCREATE TABLE "tangled_pull_comment" ( "did" text NOT NULL, "rev" text NOT NULL, "rkey" text NOT NULL, "cid" text, "deleted" boolean NOT NULL, "pull" text, "body" text, "created_at" timestamp with time zone, "mentions" text[], "references" text[], CONSTRAINT "tangled_pull_comment_did_rkey_pk" PRIMARY KEY("did","rkey"), CONSTRAINT "tangled_pull_comment_cid_only_null_if_deleted" CHECK (("tangled_pull_comment"."cid" is not null or "tangled_pull_comment"."deleted" = true)), CONSTRAINT "tangled_pull_comment_non_null_fields" CHECK (("tangled_pull_comment"."deleted" = true or ("tangled_pull_comment"."pull" is not null and "tangled_pull_comment"."body" is not null and "tangled_pull_comment"."created_at" is not null))));--> statement-breakpointCREATE TABLE "tangled_pull_status" ( "did" text NOT NULL, "rev" text NOT NULL, "rkey" text NOT NULL, "cid" text, "deleted" boolean NOT NULL, "pull" text, "status" text, CONSTRAINT "tangled_pull_status_did_rkey_pk" PRIMARY KEY("did","rkey"), CONSTRAINT "tangled_pull_status_cid_only_null_if_deleted" CHECK (("tangled_pull_status"."cid" is not null or "tangled_pull_status"."deleted" = true)), CONSTRAINT "tangled_pull_status_non_null_fields" CHECK (("tangled_pull_status"."deleted" = true or ("tangled_pull_status"."pull" is not null and "tangled_pull_status"."status" is not null))));--> statement-breakpointCREATE TABLE "tangled_reaction" ( "did" text NOT NULL, "rev" text NOT NULL, "rkey" text NOT NULL, "cid" text, "deleted" boolean NOT NULL, "subject" text, "reaction" text, "created_at" timestamp with time zone, CONSTRAINT "tangled_reaction_did_rkey_pk" PRIMARY KEY("did","rkey"), CONSTRAINT "tangled_reaction_cid_only_null_if_deleted" CHECK (("tangled_reaction"."cid" is not null or "tangled_reaction"."deleted" = true)), CONSTRAINT "tangled_reaction_non_null_fields" CHECK (("tangled_reaction"."deleted" = true or ("tangled_reaction"."subject" is not null and "tangled_reaction"."reaction" is not null and "tangled_reaction"."created_at" is not null))));--> statement-breakpointCREATE TABLE "tangled_ref_update" ( "did" text NOT NULL, "rev" text NOT NULL, "rkey" text NOT NULL, "cid" text, "deleted" boolean NOT NULL, "ref" text, "committer_did" text, "owner_did" text, "repo_did" text, "repo_name" text, "old_sha" text, "new_sha" text, "meta_is_default_ref" boolean, "meta_lang_breakdown" jsonb, "meta_commit_count" jsonb, CONSTRAINT "tangled_ref_update_did_rkey_pk" PRIMARY KEY("did","rkey"), CONSTRAINT "tangled_ref_update_cid_only_null_if_deleted" CHECK (("tangled_ref_update"."cid" is not null or "tangled_ref_update"."deleted" = true)), CONSTRAINT "tangled_ref_update_non_null_fields" CHECK (("tangled_ref_update"."deleted" = true or ("tangled_ref_update"."ref" is not null and "tangled_ref_update"."committer_did" is not null and "tangled_ref_update"."repo_name" is not null and "tangled_ref_update"."old_sha" is not null and "tangled_ref_update"."new_sha" is not null and "tangled_ref_update"."meta_is_default_ref" is not null and "tangled_ref_update"."meta_commit_count" is not null))));--> statement-breakpointCREATE TABLE "tangled_spindle" ( "did" text NOT NULL, "rev" text NOT NULL, "rkey" text NOT NULL, "cid" text, "deleted" boolean NOT NULL, "created_at" timestamp with time zone, CONSTRAINT "tangled_spindle_did_rkey_pk" PRIMARY KEY("did","rkey"), CONSTRAINT "tangled_spindle_cid_only_null_if_deleted" CHECK (("tangled_spindle"."cid" is not null or "tangled_spindle"."deleted" = true)), CONSTRAINT "tangled_spindle_non_null_fields" CHECK (("tangled_spindle"."deleted" = true or "tangled_spindle"."created_at" is not null)));--> statement-breakpointCREATE TABLE "tangled_spindle_member" ( "did" text NOT NULL, "rev" text NOT NULL, "rkey" text NOT NULL, "cid" text, "deleted" boolean NOT NULL, "subject" text, "instance" text, "created_at" timestamp with time zone, CONSTRAINT "tangled_spindle_member_did_rkey_pk" PRIMARY KEY("did","rkey"), CONSTRAINT "tangled_spindle_member_cid_only_null_if_deleted" CHECK (("tangled_spindle_member"."cid" is not null or "tangled_spindle_member"."deleted" = true)), CONSTRAINT "tangled_spindle_member_non_null_fields" CHECK (("tangled_spindle_member"."deleted" = true or ("tangled_spindle_member"."subject" is not null and "tangled_spindle_member"."instance" is not null and "tangled_spindle_member"."created_at" is not null))));--> statement-breakpointCREATE TABLE "tangled_star" ( "did" text NOT NULL, "rev" text NOT NULL, "rkey" text NOT NULL, "cid" text, "deleted" boolean NOT NULL, "subject" text, "subject_did" text, "created_at" timestamp with time zone, CONSTRAINT "tangled_star_did_rkey_pk" PRIMARY KEY("did","rkey"), CONSTRAINT "tangled_star_cid_only_null_if_deleted" CHECK (("tangled_star"."cid" is not null or "tangled_star"."deleted" = true)), CONSTRAINT "tangled_star_non_null_fields" CHECK (("tangled_star"."deleted" = true or "tangled_star"."created_at" is not null)));--> statement-breakpointCREATE TABLE "tangled_string" ( "did" text NOT NULL, "rev" text NOT NULL, "rkey" text NOT NULL, "cid" text, "deleted" boolean NOT NULL, "filename" text, "description" text, "created_at" timestamp with time zone, "contents" text, CONSTRAINT "tangled_string_did_rkey_pk" PRIMARY KEY("did","rkey"), CONSTRAINT "tangled_string_cid_only_null_if_deleted" CHECK (("tangled_string"."cid" is not null or "tangled_string"."deleted" = true)), CONSTRAINT "tangled_string_non_null_fields" CHECK (("tangled_string"."deleted" = true or ("tangled_string"."filename" is not null and "tangled_string"."description" is not null and "tangled_string"."created_at" is not null and "tangled_string"."contents" is not null))));--> statement-breakpointCREATE TABLE "tangled_vouch" ( "did" text NOT NULL, "rev" text NOT NULL, "rkey" text NOT NULL, "cid" text, "deleted" boolean NOT NULL, "kind" "tangled_vouch_kind", "reason" text, "created_at" timestamp with time zone, CONSTRAINT "tangled_vouch_did_rkey_pk" PRIMARY KEY("did","rkey"), CONSTRAINT "tangled_vouch_cid_only_null_if_deleted" CHECK (("tangled_vouch"."cid" is not null or "tangled_vouch"."deleted" = true)), CONSTRAINT "tangled_vouch_non_null_fields" CHECK (("tangled_vouch"."deleted" = true or ("tangled_vouch"."kind" is not null and "tangled_vouch"."created_at" is not null))));