public.fetch_history.sql
No OneTemporary
Actions

Size

1 KB

Subscribers

None

public.fetch_history.sql
View Options

	--
	-- PostgreSQL database dump
	--

	-- Dumped from database version 10.1
	-- Dumped by pg_dump version 10.2 (Debian 10.2-1.pgdg+1)

	SET statement_timeout = 0;
	SET lock_timeout = 0;
	SET idle_in_transaction_session_timeout = 0;
	SET client_encoding = 'UTF8';
	SET standard_conforming_strings = on;
	SET check_function_bodies = false;
	SET client_min_messages = warning;
	SET row_security = off;

	SET search_path = public, pg_catalog;

	SET default_tablespace = '';

	SET default_with_oids = false;

	--
	-- Name: fetch_history; Type: TABLE; Schema: public; Owner: -
	--

	CREATE TABLE fetch_history (
	id bigint NOT NULL,
	origin bigint,
	date timestamp with time zone NOT NULL,
	status boolean,
	result jsonb,
	stdout text,
	stderr text,
	duration interval
	);


	--
	-- Name: fetch_history_id_seq; Type: SEQUENCE; Schema: public; Owner: -
	--

	CREATE SEQUENCE fetch_history_id_seq
	START WITH 1
	INCREMENT BY 1
	NO MINVALUE
	NO MAXVALUE
	CACHE 1;


	--
	-- Name: fetch_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
	--

	ALTER SEQUENCE fetch_history_id_seq OWNED BY fetch_history.id;


	--
	-- Name: fetch_history id; Type: DEFAULT; Schema: public; Owner: -
	--

	ALTER TABLE ONLY fetch_history ALTER COLUMN id SET DEFAULT nextval('fetch_history_id_seq'::regclass);


	--
	-- Name: fetch_history fetch_history_pkey; Type: CONSTRAINT; Schema: public; Owner: -
	--

	ALTER TABLE ONLY fetch_history
	ADD CONSTRAINT fetch_history_pkey PRIMARY KEY (id);


	--
	-- Name: fetch_history_origin_idx; Type: INDEX; Schema: public; Owner: -
	--

	CREATE INDEX fetch_history_origin_idx ON fetch_history USING btree (origin);


	--
	-- Name: fetch_history fetch_history_origin_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
	--

	ALTER TABLE ONLY fetch_history
	ADD CONSTRAINT fetch_history_origin_fkey FOREIGN KEY (origin) REFERENCES origin(id);


	--
	-- PostgreSQL database dump complete
	--

File Metadata

Mime Type: text/plain
Expires: Jun 4 2025, 6:58 PM (10 w, 4 d ago)
Storage Engine: blob
Storage Format: Raw Data
Storage Handle: 3398883

public.fetch_history.sqlNo OneTemporaryActions

public.fetch_history.sqlView Options

File Metadata

Event Timeline

public.fetch_history.sql
No OneTemporary
Actions

public.fetch_history.sql
View Options