--
-- PostgreSQL database dump
--

-- Dumped from database version 9.6.2
-- Dumped by pg_dump version 9.6.2

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;

--
-- Name: swh_mktemp_content_language(); Type: FUNCTION; Schema: public; Owner: swhstorage
--

CREATE FUNCTION swh_mktemp_content_language() RETURNS void
    LANGUAGE sql
    AS $$
  create temporary table tmp_content_language (
    like content_language including defaults
  ) on commit drop;
  alter table tmp_content_language
    drop column indexer_configuration_id,
    add column tool_name text,
    add column tool_version text;
$$;


ALTER FUNCTION public.swh_mktemp_content_language() OWNER TO swhstorage;

--
-- Name: FUNCTION swh_mktemp_content_language(); Type: COMMENT; Schema: public; Owner: swhstorage
--

COMMENT ON FUNCTION swh_mktemp_content_language() IS 'Helper table to add content language';


--
-- PostgreSQL database dump complete
--

