distro-tools/apollo/schema.sql

1658 lines
45 KiB
MySQL
Raw Permalink Normal View History

2023-02-01 21:37:16 +00:00
SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;
SET default_tablespace = '';
SET default_table_access_method = heap;
2023-02-02 17:44:20 +00:00
--
-- Name: advisories; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.advisories (
id bigint NOT NULL,
created_at timestamp with time zone DEFAULT now() NOT NULL,
updated_at timestamp with time zone,
published_at timestamp with time zone,
name text NOT NULL,
synopsis text NOT NULL,
description text NOT NULL,
kind text NOT NULL,
severity text NOT NULL,
topic text NOT NULL,
red_hat_advisory_id bigint
);
--
-- Name: advisories_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
CREATE SEQUENCE public.advisories_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- Name: advisories_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--
ALTER SEQUENCE public.advisories_id_seq OWNED BY public.advisories.id;
--
-- Name: advisory_affected_products; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.advisory_affected_products (
id bigint NOT NULL,
advisory_id bigint,
variant text NOT NULL,
name text NOT NULL,
major_version numeric NOT NULL,
minor_version numeric,
arch text NOT NULL,
supported_product_id bigint
);
--
-- Name: advisory_affected_products_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
CREATE SEQUENCE public.advisory_affected_products_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- Name: advisory_affected_products_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--
ALTER SEQUENCE public.advisory_affected_products_id_seq OWNED BY public.advisory_affected_products.id;
--
-- Name: advisory_cves; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.advisory_cves (
id bigint NOT NULL,
advisory_id bigint,
cve text NOT NULL,
cvss3_scoring_vector text,
cvss3_base_score text,
cwe text
);
--
-- Name: advisory_cves_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
CREATE SEQUENCE public.advisory_cves_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- Name: advisory_cves_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--
ALTER SEQUENCE public.advisory_cves_id_seq OWNED BY public.advisory_cves.id;
--
-- Name: advisory_fixes; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.advisory_fixes (
id bigint NOT NULL,
advisory_id bigint,
ticket_id text NOT NULL,
source text NOT NULL,
description text
);
--
-- Name: advisory_fixes_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
CREATE SEQUENCE public.advisory_fixes_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- Name: advisory_fixes_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--
ALTER SEQUENCE public.advisory_fixes_id_seq OWNED BY public.advisory_fixes.id;
--
-- Name: advisory_packages; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.advisory_packages (
id bigint NOT NULL,
advisory_id bigint,
nevra text NOT NULL,
checksum text NOT NULL,
checksum_type text NOT NULL,
module_context text,
module_name text,
module_stream text,
module_version text,
repo_name text NOT NULL,
package_name text NOT NULL,
supported_products_rh_mirror_id bigint,
supported_product_id bigint,
product_name text NOT NULL
);
--
-- Name: advisory_packages_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
CREATE SEQUENCE public.advisory_packages_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- Name: advisory_packages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--
ALTER SEQUENCE public.advisory_packages_id_seq OWNED BY public.advisory_packages.id;
2023-02-01 21:37:16 +00:00
--
-- Name: codes; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.codes (
2023-02-02 17:44:20 +00:00
id bigint NOT NULL,
2023-02-01 21:37:16 +00:00
created_at timestamp with time zone DEFAULT now() NOT NULL,
updated_at timestamp with time zone,
archived_at timestamp without time zone,
2023-02-02 17:44:20 +00:00
code text NOT NULL,
2023-02-01 21:37:16 +00:00
description text NOT NULL
);
2023-02-02 17:44:20 +00:00
--
-- Name: codes_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
CREATE SEQUENCE public.codes_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- Name: codes_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--
ALTER SEQUENCE public.codes_id_seq OWNED BY public.codes.id;
--
-- Name: events; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.events (
id bigint NOT NULL,
created_at timestamp with time zone DEFAULT now() NOT NULL,
updated_at timestamp with time zone,
archived_at timestamp without time zone,
description text NOT NULL,
user_id bigint
);
--
-- Name: events_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
CREATE SEQUENCE public.events_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- Name: events_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--
ALTER SEQUENCE public.events_id_seq OWNED BY public.events.id;
2023-02-01 21:37:16 +00:00
--
-- Name: red_hat_advisories; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.red_hat_advisories (
id bigint NOT NULL,
created_at timestamp with time zone DEFAULT now() NOT NULL,
updated_at timestamp with time zone,
red_hat_issued_at timestamp with time zone NOT NULL,
name text NOT NULL,
synopsis text NOT NULL,
description text NOT NULL,
kind text NOT NULL,
2023-02-02 17:44:20 +00:00
severity text NOT NULL,
topic text NOT NULL
2023-02-01 21:37:16 +00:00
);
--
-- Name: red_hat_advisories_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
CREATE SEQUENCE public.red_hat_advisories_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
2023-02-02 17:44:20 +00:00
-- Name: red_hat_advisories_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--
ALTER SEQUENCE public.red_hat_advisories_id_seq OWNED BY public.red_hat_advisories.id;
--
-- Name: red_hat_advisory_affected_products; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.red_hat_advisory_affected_products (
id bigint NOT NULL,
red_hat_advisory_id bigint,
variant text NOT NULL,
name text NOT NULL,
major_version numeric NOT NULL,
minor_version numeric,
arch text NOT NULL
);
--
-- Name: red_hat_advisory_affected_products_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
CREATE SEQUENCE public.red_hat_advisory_affected_products_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- Name: red_hat_advisory_affected_products_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--
ALTER SEQUENCE public.red_hat_advisory_affected_products_id_seq OWNED BY public.red_hat_advisory_affected_products.id;
--
-- Name: red_hat_advisory_bugzilla_bugs; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.red_hat_advisory_bugzilla_bugs (
id bigint NOT NULL,
red_hat_advisory_id bigint,
bugzilla_bug_id text NOT NULL,
description text NOT NULL
);
--
-- Name: red_hat_advisory_bugzilla_bugs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
CREATE SEQUENCE public.red_hat_advisory_bugzilla_bugs_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- Name: red_hat_advisory_bugzilla_bugs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--
ALTER SEQUENCE public.red_hat_advisory_bugzilla_bugs_id_seq OWNED BY public.red_hat_advisory_bugzilla_bugs.id;
--
-- Name: red_hat_advisory_cves; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.red_hat_advisory_cves (
id bigint NOT NULL,
red_hat_advisory_id bigint,
cve text NOT NULL,
cvss3_scoring_vector text,
cvss3_base_score text,
cwe text
);
--
-- Name: red_hat_advisory_cves_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
CREATE SEQUENCE public.red_hat_advisory_cves_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- Name: red_hat_advisory_cves_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--
ALTER SEQUENCE public.red_hat_advisory_cves_id_seq OWNED BY public.red_hat_advisory_cves.id;
--
-- Name: red_hat_advisory_packages; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.red_hat_advisory_packages (
id bigint NOT NULL,
red_hat_advisory_id bigint,
nevra text NOT NULL
);
--
-- Name: red_hat_advisory_packages_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
CREATE SEQUENCE public.red_hat_advisory_packages_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- Name: red_hat_advisory_packages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--
ALTER SEQUENCE public.red_hat_advisory_packages_id_seq OWNED BY public.red_hat_advisory_packages.id;
--
-- Name: red_hat_index_state; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.red_hat_index_state (
id bigint NOT NULL,
last_indexed_at timestamp with time zone
);
--
-- Name: red_hat_index_state_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
CREATE SEQUENCE public.red_hat_index_state_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- Name: red_hat_index_state_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--
ALTER SEQUENCE public.red_hat_index_state_id_seq OWNED BY public.red_hat_index_state.id;
--
-- Name: schema_migrations; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.schema_migrations (
version character varying(255) NOT NULL
);
--
-- Name: settings; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.settings (
id bigint NOT NULL,
created_at timestamp with time zone DEFAULT now() NOT NULL,
updated_at timestamp with time zone,
name text NOT NULL,
value text NOT NULL
);
--
-- Name: settings_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
CREATE SEQUENCE public.settings_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- Name: settings_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--
ALTER SEQUENCE public.settings_id_seq OWNED BY public.settings.id;
--
-- Name: supported_products; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.supported_products (
id bigint NOT NULL,
created_at timestamp with time zone DEFAULT now() NOT NULL,
updated_at timestamp with time zone,
eol_at timestamp with time zone,
variant text NOT NULL,
name text NOT NULL,
vendor text NOT NULL,
code_id bigint
);
--
-- Name: supported_products_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
CREATE SEQUENCE public.supported_products_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- Name: supported_products_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--
ALTER SEQUENCE public.supported_products_id_seq OWNED BY public.supported_products.id;
--
-- Name: supported_products_rh_blocks; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.supported_products_rh_blocks (
id bigint NOT NULL,
created_at timestamp with time zone DEFAULT now() NOT NULL,
updated_at timestamp with time zone,
supported_products_rh_mirror_id bigint,
red_hat_advisory_id bigint
);
--
-- Name: supported_products_rh_blocks_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
CREATE SEQUENCE public.supported_products_rh_blocks_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- Name: supported_products_rh_blocks_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--
ALTER SEQUENCE public.supported_products_rh_blocks_id_seq OWNED BY public.supported_products_rh_blocks.id;
--
-- Name: supported_products_rh_mirrors; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.supported_products_rh_mirrors (
id bigint NOT NULL,
created_at timestamp with time zone DEFAULT now() NOT NULL,
updated_at timestamp with time zone,
supported_product_id bigint,
name text NOT NULL,
match_variant text NOT NULL,
match_major_version numeric NOT NULL,
match_minor_version numeric,
match_arch text NOT NULL
);
--
-- Name: supported_products_rh_mirrors_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
CREATE SEQUENCE public.supported_products_rh_mirrors_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- Name: supported_products_rh_mirrors_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--
ALTER SEQUENCE public.supported_products_rh_mirrors_id_seq OWNED BY public.supported_products_rh_mirrors.id;
--
-- Name: supported_products_rpm_repomds; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.supported_products_rpm_repomds (
id bigint NOT NULL,
created_at timestamp with time zone DEFAULT now() NOT NULL,
updated_at timestamp with time zone,
supported_products_rh_mirror_id bigint,
production boolean NOT NULL,
arch text NOT NULL,
url text NOT NULL,
debug_url text NOT NULL,
source_url text NOT NULL,
repo_name text NOT NULL
);
--
-- Name: supported_products_rpm_repomds_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
CREATE SEQUENCE public.supported_products_rpm_repomds_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- Name: supported_products_rpm_repomds_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--
ALTER SEQUENCE public.supported_products_rpm_repomds_id_seq OWNED BY public.supported_products_rpm_repomds.id;
--
-- Name: supported_products_rpm_rh_overrides; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.supported_products_rpm_rh_overrides (
id bigint NOT NULL,
created_at timestamp with time zone DEFAULT now() NOT NULL,
updated_at timestamp with time zone,
supported_products_rh_mirror_id bigint,
red_hat_advisory_id bigint
);
--
-- Name: supported_products_rpm_rh_overrides_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
CREATE SEQUENCE public.supported_products_rpm_rh_overrides_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- Name: supported_products_rpm_rh_overrides_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--
ALTER SEQUENCE public.supported_products_rpm_rh_overrides_id_seq OWNED BY public.supported_products_rpm_rh_overrides.id;
--
-- Name: users; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE public.users (
id bigint NOT NULL,
created_at timestamp with time zone DEFAULT now() NOT NULL,
updated_at timestamp with time zone,
archived_at timestamp without time zone,
email text NOT NULL,
password text NOT NULL,
name text NOT NULL,
role text NOT NULL
);
--
-- Name: users_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
CREATE SEQUENCE public.users_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- Name: users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--
ALTER SEQUENCE public.users_id_seq OWNED BY public.users.id;
--
-- Name: advisories id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.advisories ALTER COLUMN id SET DEFAULT nextval('public.advisories_id_seq'::regclass);
--
-- Name: advisory_affected_products id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.advisory_affected_products ALTER COLUMN id SET DEFAULT nextval('public.advisory_affected_products_id_seq'::regclass);
--
-- Name: advisory_cves id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.advisory_cves ALTER COLUMN id SET DEFAULT nextval('public.advisory_cves_id_seq'::regclass);
--
-- Name: advisory_fixes id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.advisory_fixes ALTER COLUMN id SET DEFAULT nextval('public.advisory_fixes_id_seq'::regclass);
--
-- Name: advisory_packages id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.advisory_packages ALTER COLUMN id SET DEFAULT nextval('public.advisory_packages_id_seq'::regclass);
--
-- Name: codes id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.codes ALTER COLUMN id SET DEFAULT nextval('public.codes_id_seq'::regclass);
--
-- Name: events id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.events ALTER COLUMN id SET DEFAULT nextval('public.events_id_seq'::regclass);
--
-- Name: red_hat_advisories id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.red_hat_advisories ALTER COLUMN id SET DEFAULT nextval('public.red_hat_advisories_id_seq'::regclass);
--
-- Name: red_hat_advisory_affected_products id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.red_hat_advisory_affected_products ALTER COLUMN id SET DEFAULT nextval('public.red_hat_advisory_affected_products_id_seq'::regclass);
--
-- Name: red_hat_advisory_bugzilla_bugs id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.red_hat_advisory_bugzilla_bugs ALTER COLUMN id SET DEFAULT nextval('public.red_hat_advisory_bugzilla_bugs_id_seq'::regclass);
--
-- Name: red_hat_advisory_cves id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.red_hat_advisory_cves ALTER COLUMN id SET DEFAULT nextval('public.red_hat_advisory_cves_id_seq'::regclass);
--
-- Name: red_hat_advisory_packages id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.red_hat_advisory_packages ALTER COLUMN id SET DEFAULT nextval('public.red_hat_advisory_packages_id_seq'::regclass);
--
-- Name: red_hat_index_state id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.red_hat_index_state ALTER COLUMN id SET DEFAULT nextval('public.red_hat_index_state_id_seq'::regclass);
--
-- Name: settings id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.settings ALTER COLUMN id SET DEFAULT nextval('public.settings_id_seq'::regclass);
--
-- Name: supported_products id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.supported_products ALTER COLUMN id SET DEFAULT nextval('public.supported_products_id_seq'::regclass);
--
-- Name: supported_products_rh_blocks id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.supported_products_rh_blocks ALTER COLUMN id SET DEFAULT nextval('public.supported_products_rh_blocks_id_seq'::regclass);
--
-- Name: supported_products_rh_mirrors id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.supported_products_rh_mirrors ALTER COLUMN id SET DEFAULT nextval('public.supported_products_rh_mirrors_id_seq'::regclass);
--
-- Name: supported_products_rpm_repomds id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.supported_products_rpm_repomds ALTER COLUMN id SET DEFAULT nextval('public.supported_products_rpm_repomds_id_seq'::regclass);
--
-- Name: supported_products_rpm_rh_overrides id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.supported_products_rpm_rh_overrides ALTER COLUMN id SET DEFAULT nextval('public.supported_products_rpm_rh_overrides_id_seq'::regclass);
--
-- Name: users id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.users ALTER COLUMN id SET DEFAULT nextval('public.users_id_seq'::regclass);
--
-- Name: advisories advisories_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.advisories
ADD CONSTRAINT advisories_name_key UNIQUE (name);
--
-- Name: advisories advisories_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.advisories
ADD CONSTRAINT advisories_pkey PRIMARY KEY (id);
--
-- Name: advisory_affected_products advisory_affected_products_advisory_id_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.advisory_affected_products
ADD CONSTRAINT advisory_affected_products_advisory_id_name_key UNIQUE (advisory_id, name);
--
-- Name: advisory_affected_products advisory_affected_products_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.advisory_affected_products
ADD CONSTRAINT advisory_affected_products_pkey PRIMARY KEY (id);
--
-- Name: advisory_cves advisory_cves_advisory_id_cve_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.advisory_cves
ADD CONSTRAINT advisory_cves_advisory_id_cve_key UNIQUE (advisory_id, cve);
--
-- Name: advisory_cves advisory_cves_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.advisory_cves
ADD CONSTRAINT advisory_cves_pkey PRIMARY KEY (id);
--
-- Name: advisory_fixes advisory_fixes_advisory_id_ticket_id_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.advisory_fixes
ADD CONSTRAINT advisory_fixes_advisory_id_ticket_id_key UNIQUE (advisory_id, ticket_id);
--
-- Name: advisory_fixes advisory_fixes_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.advisory_fixes
ADD CONSTRAINT advisory_fixes_pkey PRIMARY KEY (id);
--
-- Name: advisory_packages advisory_packages_advisory_id_nevra_repo_name_supported_pro_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.advisory_packages
ADD CONSTRAINT advisory_packages_advisory_id_nevra_repo_name_supported_pro_key UNIQUE (advisory_id, nevra, repo_name, supported_products_rh_mirror_id);
--
-- Name: advisory_packages advisory_packages_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.advisory_packages
ADD CONSTRAINT advisory_packages_pkey PRIMARY KEY (id);
--
-- Name: codes codes_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.codes
ADD CONSTRAINT codes_pkey PRIMARY KEY (id);
--
-- Name: events events_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.events
ADD CONSTRAINT events_pkey PRIMARY KEY (id);
--
-- Name: red_hat_advisories red_hat_advisories_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.red_hat_advisories
ADD CONSTRAINT red_hat_advisories_name_key UNIQUE (name);
--
-- Name: red_hat_advisories red_hat_advisories_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.red_hat_advisories
ADD CONSTRAINT red_hat_advisories_pkey PRIMARY KEY (id);
--
-- Name: red_hat_advisory_affected_products red_hat_advisory_affected_pro_red_hat_advisory_id_variant_n_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.red_hat_advisory_affected_products
ADD CONSTRAINT red_hat_advisory_affected_pro_red_hat_advisory_id_variant_n_key UNIQUE (red_hat_advisory_id, variant, name, major_version, minor_version, arch);
--
-- Name: red_hat_advisory_affected_products red_hat_advisory_affected_products_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.red_hat_advisory_affected_products
ADD CONSTRAINT red_hat_advisory_affected_products_pkey PRIMARY KEY (id);
--
-- Name: red_hat_advisory_bugzilla_bugs red_hat_advisory_bugzilla_bug_red_hat_advisory_id_bugzilla__key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.red_hat_advisory_bugzilla_bugs
ADD CONSTRAINT red_hat_advisory_bugzilla_bug_red_hat_advisory_id_bugzilla__key UNIQUE (red_hat_advisory_id, bugzilla_bug_id);
--
-- Name: red_hat_advisory_bugzilla_bugs red_hat_advisory_bugzilla_bugs_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.red_hat_advisory_bugzilla_bugs
ADD CONSTRAINT red_hat_advisory_bugzilla_bugs_pkey PRIMARY KEY (id);
--
-- Name: red_hat_advisory_cves red_hat_advisory_cves_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.red_hat_advisory_cves
ADD CONSTRAINT red_hat_advisory_cves_pkey PRIMARY KEY (id);
--
-- Name: red_hat_advisory_cves red_hat_advisory_cves_red_hat_advisory_id_cve_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.red_hat_advisory_cves
ADD CONSTRAINT red_hat_advisory_cves_red_hat_advisory_id_cve_key UNIQUE (red_hat_advisory_id, cve);
--
-- Name: red_hat_advisory_packages red_hat_advisory_packages_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.red_hat_advisory_packages
ADD CONSTRAINT red_hat_advisory_packages_pkey PRIMARY KEY (id);
--
-- Name: red_hat_advisory_packages red_hat_advisory_packages_red_hat_advisory_id_nevra_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.red_hat_advisory_packages
ADD CONSTRAINT red_hat_advisory_packages_red_hat_advisory_id_nevra_key UNIQUE (red_hat_advisory_id, nevra);
--
-- Name: red_hat_index_state red_hat_index_state_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.red_hat_index_state
ADD CONSTRAINT red_hat_index_state_pkey PRIMARY KEY (id);
--
-- Name: schema_migrations schema_migrations_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.schema_migrations
ADD CONSTRAINT schema_migrations_pkey PRIMARY KEY (version);
--
-- Name: settings settings_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.settings
ADD CONSTRAINT settings_name_key UNIQUE (name);
--
-- Name: settings settings_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.settings
ADD CONSTRAINT settings_pkey PRIMARY KEY (id);
--
-- Name: supported_products supported_products_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.supported_products
ADD CONSTRAINT supported_products_name_key UNIQUE (name);
--
-- Name: supported_products supported_products_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.supported_products
ADD CONSTRAINT supported_products_pkey PRIMARY KEY (id);
--
-- Name: supported_products_rh_blocks supported_products_rh_blocks_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.supported_products_rh_blocks
ADD CONSTRAINT supported_products_rh_blocks_pkey PRIMARY KEY (id);
--
-- Name: supported_products_rh_blocks supported_products_rh_blocks_supported_products_rh_mirror_i_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.supported_products_rh_blocks
ADD CONSTRAINT supported_products_rh_blocks_supported_products_rh_mirror_i_key UNIQUE (supported_products_rh_mirror_id, red_hat_advisory_id);
--
-- Name: supported_products_rh_mirrors supported_products_rh_mirrors_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.supported_products_rh_mirrors
ADD CONSTRAINT supported_products_rh_mirrors_pkey PRIMARY KEY (id);
--
-- Name: supported_products_rpm_repomds supported_products_rpm_repomds_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.supported_products_rpm_repomds
ADD CONSTRAINT supported_products_rpm_repomds_pkey PRIMARY KEY (id);
--
-- Name: supported_products_rpm_rh_overrides supported_products_rpm_rh_overrides_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.supported_products_rpm_rh_overrides
ADD CONSTRAINT supported_products_rpm_rh_overrides_pkey PRIMARY KEY (id);
--
-- Name: users users_email_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.users
ADD CONSTRAINT users_email_key UNIQUE (email);
--
-- Name: users users_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.users
ADD CONSTRAINT users_pkey PRIMARY KEY (id);
--
-- Name: advisories_kindx; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX advisories_kindx ON public.advisories USING btree (kind);
--
-- Name: advisories_namex; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX advisories_namex ON public.advisories USING btree (name);
--
-- Name: advisories_published_atx; Type: INDEX; Schema: public; Owner: -
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
CREATE INDEX advisories_published_atx ON public.advisories USING btree (published_at);
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
-- Name: advisories_red_hat_advisory_id; Type: INDEX; Schema: public; Owner: -
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
CREATE INDEX advisories_red_hat_advisory_id ON public.advisories USING btree (red_hat_advisory_id);
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
-- Name: advisories_severityx; Type: INDEX; Schema: public; Owner: -
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
CREATE INDEX advisories_severityx ON public.advisories USING btree (severity);
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
-- Name: advisories_synopsisx; Type: INDEX; Schema: public; Owner: -
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
CREATE INDEX advisories_synopsisx ON public.advisories USING btree (synopsis);
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
-- Name: advisory_affected_products_archx; Type: INDEX; Schema: public; Owner: -
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
CREATE INDEX advisory_affected_products_archx ON public.advisory_affected_products USING btree (arch);
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
-- Name: advisory_affected_products_major_versionx; Type: INDEX; Schema: public; Owner: -
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
CREATE INDEX advisory_affected_products_major_versionx ON public.advisory_affected_products USING btree (major_version);
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
-- Name: advisory_affected_products_minor_versionx; Type: INDEX; Schema: public; Owner: -
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
CREATE INDEX advisory_affected_products_minor_versionx ON public.advisory_affected_products USING btree (minor_version);
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
-- Name: advisory_affected_products_namex; Type: INDEX; Schema: public; Owner: -
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
CREATE INDEX advisory_affected_products_namex ON public.advisory_affected_products USING btree (name);
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
-- Name: advisory_affected_products_supported_product_idx; Type: INDEX; Schema: public; Owner: -
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
CREATE INDEX advisory_affected_products_supported_product_idx ON public.advisory_affected_products USING btree (supported_product_id);
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
-- Name: advisory_affected_products_variantx; Type: INDEX; Schema: public; Owner: -
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
CREATE INDEX advisory_affected_products_variantx ON public.advisory_affected_products USING btree (variant);
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
-- Name: advisory_cvex; Type: INDEX; Schema: public; Owner: -
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
CREATE INDEX advisory_cvex ON public.advisory_cves USING btree (cve);
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
-- Name: advisory_fixes_advisory_id; Type: INDEX; Schema: public; Owner: -
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
CREATE INDEX advisory_fixes_advisory_id ON public.advisory_fixes USING btree (advisory_id);
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
-- Name: advisory_fixes_ticket_id; Type: INDEX; Schema: public; Owner: -
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
CREATE INDEX advisory_fixes_ticket_id ON public.advisory_fixes USING btree (ticket_id);
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
-- Name: advisory_packages_advisory_id; Type: INDEX; Schema: public; Owner: -
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
CREATE INDEX advisory_packages_advisory_id ON public.advisory_packages USING btree (advisory_id);
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
-- Name: advisory_packages_checksumx; Type: INDEX; Schema: public; Owner: -
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
CREATE INDEX advisory_packages_checksumx ON public.advisory_packages USING btree (checksum);
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
-- Name: advisory_packages_nevrax; Type: INDEX; Schema: public; Owner: -
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
CREATE INDEX advisory_packages_nevrax ON public.advisory_packages USING btree (nevra);
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
-- Name: advisory_packages_product_name_idx; Type: INDEX; Schema: public; Owner: -
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
CREATE INDEX advisory_packages_product_name_idx ON public.advisory_packages USING btree (product_name);
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
-- Name: advisory_packages_supported_product_idx; Type: INDEX; Schema: public; Owner: -
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
CREATE INDEX advisory_packages_supported_product_idx ON public.advisory_packages USING btree (supported_product_id);
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
-- Name: advisory_packages_supported_products_rh_mirror_idx; Type: INDEX; Schema: public; Owner: -
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
CREATE INDEX advisory_packages_supported_products_rh_mirror_idx ON public.advisory_packages USING btree (supported_products_rh_mirror_id);
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
-- Name: red_hat_advisories_kindx; Type: INDEX; Schema: public; Owner: -
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
CREATE INDEX red_hat_advisories_kindx ON public.red_hat_advisories USING btree (kind);
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
-- Name: red_hat_advisories_namex; Type: INDEX; Schema: public; Owner: -
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
CREATE INDEX red_hat_advisories_namex ON public.red_hat_advisories USING btree (name);
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
-- Name: red_hat_advisories_red_hat_issued_atx; Type: INDEX; Schema: public; Owner: -
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
CREATE INDEX red_hat_advisories_red_hat_issued_atx ON public.red_hat_advisories USING btree (red_hat_issued_at);
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
-- Name: red_hat_advisories_severityx; Type: INDEX; Schema: public; Owner: -
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
CREATE INDEX red_hat_advisories_severityx ON public.red_hat_advisories USING btree (severity);
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
-- Name: red_hat_advisories_synopsisx; Type: INDEX; Schema: public; Owner: -
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
CREATE INDEX red_hat_advisories_synopsisx ON public.red_hat_advisories USING btree (synopsis);
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
-- Name: red_hat_advisory_affected_products_archx; Type: INDEX; Schema: public; Owner: -
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
CREATE INDEX red_hat_advisory_affected_products_archx ON public.red_hat_advisory_affected_products USING btree (arch);
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
-- Name: red_hat_advisory_affected_products_major_versionx; Type: INDEX; Schema: public; Owner: -
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
CREATE INDEX red_hat_advisory_affected_products_major_versionx ON public.red_hat_advisory_affected_products USING btree (major_version);
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
-- Name: red_hat_advisory_affected_products_minor_versionx; Type: INDEX; Schema: public; Owner: -
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
CREATE INDEX red_hat_advisory_affected_products_minor_versionx ON public.red_hat_advisory_affected_products USING btree (minor_version);
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
-- Name: red_hat_advisory_affected_products_namex; Type: INDEX; Schema: public; Owner: -
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
CREATE INDEX red_hat_advisory_affected_products_namex ON public.red_hat_advisory_affected_products USING btree (name);
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
-- Name: red_hat_advisory_affected_products_variant_namenx; Type: INDEX; Schema: public; Owner: -
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
CREATE UNIQUE INDEX red_hat_advisory_affected_products_variant_namenx ON public.red_hat_advisory_affected_products USING btree (red_hat_advisory_id, variant, name, major_version, minor_version, arch) WHERE (minor_version IS NULL);
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
-- Name: red_hat_advisory_affected_products_variant_namex; Type: INDEX; Schema: public; Owner: -
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
CREATE UNIQUE INDEX red_hat_advisory_affected_products_variant_namex ON public.red_hat_advisory_affected_products USING btree (red_hat_advisory_id, variant, name, major_version, minor_version, arch) WHERE (minor_version IS NOT NULL);
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
-- Name: red_hat_advisory_affected_products_variantx; Type: INDEX; Schema: public; Owner: -
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
CREATE INDEX red_hat_advisory_affected_products_variantx ON public.red_hat_advisory_affected_products USING btree (variant);
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
-- Name: red_hat_advisory_bugzilla_bugs_bugzilla_bug_idx; Type: INDEX; Schema: public; Owner: -
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
CREATE INDEX red_hat_advisory_bugzilla_bugs_bugzilla_bug_idx ON public.red_hat_advisory_bugzilla_bugs USING btree (bugzilla_bug_id);
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
-- Name: red_hat_advisory_cvex; Type: INDEX; Schema: public; Owner: -
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
CREATE INDEX red_hat_advisory_cvex ON public.red_hat_advisory_cves USING btree (cve);
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
-- Name: red_hat_advisory_packages_nevrax; Type: INDEX; Schema: public; Owner: -
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
CREATE INDEX red_hat_advisory_packages_nevrax ON public.red_hat_advisory_packages USING btree (nevra);
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
-- Name: settings_namex; Type: INDEX; Schema: public; Owner: -
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
CREATE INDEX settings_namex ON public.settings USING btree (name);
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
-- Name: supported_products_eol_atx; Type: INDEX; Schema: public; Owner: -
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
CREATE INDEX supported_products_eol_atx ON public.supported_products USING btree (eol_at);
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
-- Name: supported_products_namex; Type: INDEX; Schema: public; Owner: -
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
CREATE INDEX supported_products_namex ON public.supported_products USING btree (name);
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
-- Name: supported_products_rh_blocks_red_hat_advisory_idx; Type: INDEX; Schema: public; Owner: -
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
CREATE INDEX supported_products_rh_blocks_red_hat_advisory_idx ON public.supported_products_rh_blocks USING btree (red_hat_advisory_id);
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
-- Name: supported_products_rh_blocks_supported_products_rh_mirror_idx; Type: INDEX; Schema: public; Owner: -
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
CREATE INDEX supported_products_rh_blocks_supported_products_rh_mirror_idx ON public.supported_products_rh_blocks USING btree (supported_products_rh_mirror_id);
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
-- Name: supported_products_rh_mirrors_match_arch_idx; Type: INDEX; Schema: public; Owner: -
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
CREATE INDEX supported_products_rh_mirrors_match_arch_idx ON public.supported_products_rh_mirrors USING btree (match_arch);
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
-- Name: supported_products_rh_mirrors_match_major_version_idx; Type: INDEX; Schema: public; Owner: -
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
CREATE INDEX supported_products_rh_mirrors_match_major_version_idx ON public.supported_products_rh_mirrors USING btree (match_major_version);
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
-- Name: supported_products_rh_mirrors_match_minor_version_idx; Type: INDEX; Schema: public; Owner: -
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
CREATE INDEX supported_products_rh_mirrors_match_minor_version_idx ON public.supported_products_rh_mirrors USING btree (match_minor_version);
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
-- Name: supported_products_rh_mirrors_match_variant_idx; Type: INDEX; Schema: public; Owner: -
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
CREATE INDEX supported_products_rh_mirrors_match_variant_idx ON public.supported_products_rh_mirrors USING btree (match_variant);
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
-- Name: supported_products_rh_mirrors_supported_product_idx; Type: INDEX; Schema: public; Owner: -
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
CREATE INDEX supported_products_rh_mirrors_supported_product_idx ON public.supported_products_rh_mirrors USING btree (supported_product_id);
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
-- Name: supported_products_rpm_repomds_arch_idx; Type: INDEX; Schema: public; Owner: -
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
CREATE INDEX supported_products_rpm_repomds_arch_idx ON public.supported_products_rpm_repomds USING btree (arch);
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
-- Name: supported_products_rpm_repomds_production_idx; Type: INDEX; Schema: public; Owner: -
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
CREATE INDEX supported_products_rpm_repomds_production_idx ON public.supported_products_rpm_repomds USING btree (production);
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
-- Name: supported_products_rpm_repomds_supporteds_rh_mirror_idx; Type: INDEX; Schema: public; Owner: -
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
CREATE INDEX supported_products_rpm_repomds_supporteds_rh_mirror_idx ON public.supported_products_rpm_repomds USING btree (supported_products_rh_mirror_id);
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
-- Name: supported_products_rpm_rh_overrides_red_hat_advisory_idx; Type: INDEX; Schema: public; Owner: -
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
CREATE INDEX supported_products_rpm_rh_overrides_red_hat_advisory_idx ON public.supported_products_rpm_rh_overrides USING btree (red_hat_advisory_id);
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
-- Name: supported_products_rpm_rh_overrides_supported_products_rh_mirro; Type: INDEX; Schema: public; Owner: -
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
CREATE INDEX supported_products_rpm_rh_overrides_supported_products_rh_mirro ON public.supported_products_rpm_rh_overrides USING btree (supported_products_rh_mirror_id);
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
-- Name: supported_products_variantx; Type: INDEX; Schema: public; Owner: -
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
CREATE INDEX supported_products_variantx ON public.supported_products USING btree (variant);
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
-- Name: advisories advisories_red_hat_advisory_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
ALTER TABLE ONLY public.advisories
ADD CONSTRAINT advisories_red_hat_advisory_id_fkey FOREIGN KEY (red_hat_advisory_id) REFERENCES public.red_hat_advisories(id) ON DELETE CASCADE;
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
-- Name: advisory_affected_products advisory_affected_products_advisory_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
ALTER TABLE ONLY public.advisory_affected_products
ADD CONSTRAINT advisory_affected_products_advisory_id_fkey FOREIGN KEY (advisory_id) REFERENCES public.advisories(id) ON DELETE CASCADE;
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
-- Name: advisory_affected_products advisory_affected_products_supported_product_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
ALTER TABLE ONLY public.advisory_affected_products
ADD CONSTRAINT advisory_affected_products_supported_product_id_fkey FOREIGN KEY (supported_product_id) REFERENCES public.supported_products(id) ON DELETE CASCADE;
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
-- Name: advisory_cves advisory_cves_advisory_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
ALTER TABLE ONLY public.advisory_cves
ADD CONSTRAINT advisory_cves_advisory_id_fkey FOREIGN KEY (advisory_id) REFERENCES public.advisories(id) ON DELETE CASCADE;
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
-- Name: advisory_fixes advisory_fixes_advisory_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
ALTER TABLE ONLY public.advisory_fixes
ADD CONSTRAINT advisory_fixes_advisory_id_fkey FOREIGN KEY (advisory_id) REFERENCES public.advisories(id) ON DELETE CASCADE;
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
-- Name: advisory_packages advisory_packages_advisory_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
ALTER TABLE ONLY public.advisory_packages
ADD CONSTRAINT advisory_packages_advisory_id_fkey FOREIGN KEY (advisory_id) REFERENCES public.advisories(id) ON DELETE CASCADE;
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
-- Name: advisory_packages advisory_packages_supported_product_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
ALTER TABLE ONLY public.advisory_packages
ADD CONSTRAINT advisory_packages_supported_product_id_fkey FOREIGN KEY (supported_product_id) REFERENCES public.supported_products(id) ON DELETE CASCADE;
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
-- Name: advisory_packages advisory_packages_supported_products_rh_mirror_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
ALTER TABLE ONLY public.advisory_packages
ADD CONSTRAINT advisory_packages_supported_products_rh_mirror_id_fkey FOREIGN KEY (supported_products_rh_mirror_id) REFERENCES public.supported_products_rh_mirrors(id) ON DELETE CASCADE;
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
-- Name: events events_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2023-02-01 21:37:16 +00:00
--
2023-02-02 17:44:20 +00:00
ALTER TABLE ONLY public.events
ADD CONSTRAINT events_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id) ON DELETE SET NULL;
2023-02-01 21:37:16 +00:00
--
-- Name: red_hat_advisory_affected_products red_hat_advisory_affected_products_red_hat_advisory_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.red_hat_advisory_affected_products
ADD CONSTRAINT red_hat_advisory_affected_products_red_hat_advisory_id_fkey FOREIGN KEY (red_hat_advisory_id) REFERENCES public.red_hat_advisories(id) ON DELETE CASCADE;
--
-- Name: red_hat_advisory_bugzilla_bugs red_hat_advisory_bugzilla_bugs_red_hat_advisory_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.red_hat_advisory_bugzilla_bugs
ADD CONSTRAINT red_hat_advisory_bugzilla_bugs_red_hat_advisory_id_fkey FOREIGN KEY (red_hat_advisory_id) REFERENCES public.red_hat_advisories(id) ON DELETE CASCADE;
--
-- Name: red_hat_advisory_cves red_hat_advisory_cves_red_hat_advisory_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.red_hat_advisory_cves
ADD CONSTRAINT red_hat_advisory_cves_red_hat_advisory_id_fkey FOREIGN KEY (red_hat_advisory_id) REFERENCES public.red_hat_advisories(id) ON DELETE CASCADE;
--
-- Name: red_hat_advisory_packages red_hat_advisory_packages_red_hat_advisory_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.red_hat_advisory_packages
ADD CONSTRAINT red_hat_advisory_packages_red_hat_advisory_id_fkey FOREIGN KEY (red_hat_advisory_id) REFERENCES public.red_hat_advisories(id) ON DELETE CASCADE;
2023-02-02 17:44:20 +00:00
--
-- Name: supported_products supported_products_code_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.supported_products
ADD CONSTRAINT supported_products_code_id_fkey FOREIGN KEY (code_id) REFERENCES public.codes(id);
--
-- Name: supported_products_rh_blocks supported_products_rh_blocks_red_hat_advisory_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.supported_products_rh_blocks
ADD CONSTRAINT supported_products_rh_blocks_red_hat_advisory_id_fkey FOREIGN KEY (red_hat_advisory_id) REFERENCES public.red_hat_advisories(id) ON DELETE CASCADE;
--
-- Name: supported_products_rh_blocks supported_products_rh_blocks_supported_products_rh_mirror__fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.supported_products_rh_blocks
ADD CONSTRAINT supported_products_rh_blocks_supported_products_rh_mirror__fkey FOREIGN KEY (supported_products_rh_mirror_id) REFERENCES public.supported_products_rh_mirrors(id) ON DELETE CASCADE;
--
-- Name: supported_products_rh_mirrors supported_products_rh_mirrors_supported_product_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.supported_products_rh_mirrors
ADD CONSTRAINT supported_products_rh_mirrors_supported_product_id_fkey FOREIGN KEY (supported_product_id) REFERENCES public.supported_products(id) ON DELETE CASCADE;
--
-- Name: supported_products_rpm_repomds supported_products_rpm_repomd_supported_products_rh_mirror_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.supported_products_rpm_repomds
ADD CONSTRAINT supported_products_rpm_repomd_supported_products_rh_mirror_fkey FOREIGN KEY (supported_products_rh_mirror_id) REFERENCES public.supported_products_rh_mirrors(id) ON DELETE CASCADE;
--
-- Name: supported_products_rpm_rh_overrides supported_products_rpm_rh_ove_supported_products_rh_mirror_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.supported_products_rpm_rh_overrides
ADD CONSTRAINT supported_products_rpm_rh_ove_supported_products_rh_mirror_fkey FOREIGN KEY (supported_products_rh_mirror_id) REFERENCES public.supported_products_rh_mirrors(id) ON DELETE CASCADE;
--
-- Name: supported_products_rpm_rh_overrides supported_products_rpm_rh_overrides_red_hat_advisory_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.supported_products_rpm_rh_overrides
ADD CONSTRAINT supported_products_rpm_rh_overrides_red_hat_advisory_id_fkey FOREIGN KEY (red_hat_advisory_id) REFERENCES public.red_hat_advisories(id) ON DELETE CASCADE;
2023-02-01 21:37:16 +00:00
--
-- PostgreSQL database dump complete
--
--
-- Dbmate schema migrations
--
INSERT INTO public.schema_migrations (version) VALUES
('20230128201227');