--
-- PostgreSQL database dump
--

-- Dumped from database version 12.0 (Debian 12.0-1+b1)
-- Dumped by pg_dump version 12.0 (Debian 12.0-1+b1)

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;

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

CREATE TABLE public.content_fossology_license (
    id public.sha1 NOT NULL,
    license_id smallint NOT NULL,
    indexer_configuration_id bigint NOT NULL
);


--
-- Name: TABLE content_fossology_license; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON TABLE public.content_fossology_license IS 'license associated to a raw content';


--
-- Name: COLUMN content_fossology_license.id; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN public.content_fossology_license.id IS 'Raw content identifier';


--
-- Name: COLUMN content_fossology_license.license_id; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN public.content_fossology_license.license_id IS 'One of the content''s license identifier';


--
-- Name: COLUMN content_fossology_license.indexer_configuration_id; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN public.content_fossology_license.indexer_configuration_id IS 'Tool used to compute the information';


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

CREATE SEQUENCE public.content_fossology_license_license_id_seq
    AS smallint
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


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

ALTER SEQUENCE public.content_fossology_license_license_id_seq OWNED BY public.content_fossology_license.license_id;


--
-- Name: content_fossology_license license_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.content_fossology_license ALTER COLUMN license_id SET DEFAULT nextval('public.content_fossology_license_license_id_seq'::regclass);


--
-- Name: content_fossology_license content_fossology_license_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.content_fossology_license
    ADD CONSTRAINT content_fossology_license_pkey PRIMARY KEY (id, license_id, indexer_configuration_id);


--
-- Name: content_fossology_license content_fossology_license_indexer_configuration_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.content_fossology_license
    ADD CONSTRAINT content_fossology_license_indexer_configuration_id_fkey FOREIGN KEY (indexer_configuration_id) REFERENCES public.indexer_configuration(id);


--
-- Name: content_fossology_license content_fossology_license_license_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.content_fossology_license
    ADD CONSTRAINT content_fossology_license_license_id_fkey FOREIGN KEY (license_id) REFERENCES public.fossology_license(id);


--
-- PostgreSQL database dump complete
--