public.content_fossology_license.sql
No OneTemporary
Actions

Size

3 KB

Subscribers

None

public.content_fossology_license.sql
View Options

	--
	-- 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
	--

File Metadata

Mime Type: text/plain
Expires: Jun 4 2025, 7:46 PM (12 w, 9 h ago)
Storage Engine: blob
Storage Format: Raw Data
Storage Handle: 3399365

public.content_fossology_license.sqlNo OneTemporaryActions

public.content_fossology_license.sqlView Options

File Metadata

Event Timeline

public.content_fossology_license.sql
No OneTemporary
Actions

public.content_fossology_license.sql
View Options