text: --
  -- PostgreSQL database cluster dump
  --
  
  SET default_transaction_read_only = off;
  
  SET client_encoding = 'UTF8';
  SET standard_conforming_strings = on;
  
  --
  -- Roles
  --
  
  -- CREATE ROLE postgres;
  ALTER ROLE postgres WITH SUPERUSER INHERIT CREATEROLE CREATEDB LOGIN REPLICATION BYPASSRLS PASSWORD 'md55f4dcc3b5aa765d61d8327deb882cf99';
  
  
  
  CREATE ROLE kamailio NOSUPERUSER NOCREATEDB NOCREATEROLE NOINHERIT LOGIN PASSWORD 'password';
  GRANT CREATE ON SCHEMA public TO kamailio;
  GRANT USAGE ON SCHEMA public TO kamailio;
  
  
  --
  -- Databases
  --
  
  --
  -- Database "template1" dump
  --
  
  \connect template1
  
  --
  -- PostgreSQL database dump
  --
  
  -- Dumped from database version 13.1 (Debian 13.1-1.pgdg100+1)
  -- Dumped by pg_dump version 13.1 (Debian 13.1-1.pgdg100+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;
  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;
  
  --
  -- PostgreSQL database dump complete
  --
  
  --
  -- Database "postgres" dump
  --
  
  \connect postgres
  
  --
  -- PostgreSQL database dump
  --
  
  -- Dumped from database version 13.1 (Debian 13.1-1.pgdg100+1)
  -- Dumped by pg_dump version 13.1 (Debian 13.1-1.pgdg100+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;
  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;
  
  --
  -- PostgreSQL database dump complete
  --
  
  --
  -- PostgreSQL database dump
  --
  
  -- Dumped from database version 13.1 (Debian 13.1-1.pgdg100+1)
  -- Dumped by pg_dump version 13.1 (Debian 13.1-1.pgdg100+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;
  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;
  
  --
  -- Name: kamailio; Type: DATABASE; Schema: -; Owner: postgres
  --
  
  CREATE DATABASE kamailio WITH TEMPLATE = template0 ENCODING = 'UTF8' LOCALE = 'en_US.utf8';
  
  
  ALTER DATABASE kamailio OWNER TO postgres;
  
  \connect kamailio
  
  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;
  
  --
  -- Name: acc; Type: TABLE; Schema: public; Owner: postgres
  --
  
  CREATE TABLE public.acc (
      id integer NOT NULL,
      method character varying(16) DEFAULT ''::character varying NOT NULL,
      from_tag character varying(128) DEFAULT ''::character varying NOT NULL,
      to_tag character varying(128) DEFAULT ''::character varying NOT NULL,
      callid character varying(255) DEFAULT ''::character varying NOT NULL,
      sip_code character varying(3) DEFAULT ''::character varying NOT NULL,
      sip_reason character varying(128) DEFAULT ''::character varying NOT NULL,
      "time" timestamp without time zone NOT NULL
  );
  
  
  ALTER TABLE public.acc OWNER TO postgres;
  
  