--
-- Dump generated by PostgreSQL Anonymizer 1.2.0
--
--
-- PostgreSQL database dump
--

-- Dumped from database version 14.3 (Debian 14.3-1.pgdg110+1)
-- Dumped by pg_dump version 14.1 (Debian 14.1-1.pgdg110+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: FoO; Type: SCHEMA; Schema: -; Owner: postgres
--

CREATE SCHEMA "FoO";


ALTER SCHEMA "FoO" OWNER TO postgres;

--
--



--
--



--
--



--
--



--
-- Name: test_pg_dump_anon; Type: SCHEMA; Schema: -; Owner: postgres
--

CREATE SCHEMA test_pg_dump_anon;


ALTER SCHEMA test_pg_dump_anon OWNER TO postgres;

--
-- Name: BuG_298; Type: SEQUENCE; Schema: FoO; Owner: postgres
--

CREATE SEQUENCE "FoO"."BuG_298"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "FoO"."BuG_298" OWNER TO postgres;

SET default_tablespace = '';

SET default_table_access_method = heap;

--
-- Name: company; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.company (
    id integer NOT NULL,
    name text,
    vat_id text
);


ALTER TABLE public.company OWNER TO postgres;

--
-- Name: company_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.company_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.company_id_seq OWNER TO postgres;

--
-- Name: company_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.company_id_seq OWNED BY public.company.id;


--
-- Name: http_logs; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.http_logs (
    id integer NOT NULL,
    ip_address inet,
    url text
);


ALTER TABLE public.http_logs OWNER TO postgres;

--
-- Name: owner; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.owner (
    firstname text
);


ALTER TABLE public.owner OWNER TO postgres;

--
-- Name: seq42; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.seq42
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.seq42 OWNER TO postgres;

--
-- Name: supplier; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.supplier (
    id integer NOT NULL,
    fk_company_id integer,
    contact text,
    phone text,
    job_title text
);


ALTER TABLE public.supplier OWNER TO postgres;

--
-- Name: supplier_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.supplier_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.supplier_id_seq OWNER TO postgres;

--
-- Name: supplier_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.supplier_id_seq OWNED BY public.supplier.id;


--
-- Name: no_masks; Type: TABLE; Schema: test_pg_dump_anon; Owner: postgres
--

CREATE TABLE test_pg_dump_anon.no_masks (
    "?column?" integer
);


ALTER TABLE test_pg_dump_anon.no_masks OWNER TO postgres;

--
-- Name: three; Type: SEQUENCE; Schema: test_pg_dump_anon; Owner: postgres
--

CREATE SEQUENCE test_pg_dump_anon.three
    START WITH 3
    INCREMENT BY -1
    MINVALUE 1
    MAXVALUE 3
    CACHE 1
    CYCLE;


ALTER TABLE test_pg_dump_anon.three OWNER TO postgres;

--
-- Name: company id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.company ALTER COLUMN id SET DEFAULT nextval('public.company_id_seq'::regclass);


--
-- Name: supplier id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.supplier ALTER COLUMN id SET DEFAULT nextval('public.supplier_id_seq'::regclass);


--
-- PostgreSQL database dump complete
--



COPY public.company FROM STDIN WITH CSV;
952,Shadrach,FR62684255667
194,Johnny's Shoe Store,CHE670945644
346,Capitol Records,GB663829617823
\.


COPY public.http_logs FROM STDIN WITH CSV;
1,178.83.218.166,http://bluehost.com
2,24.54.240.199,https://yandex.ru
3,26.101.173.120,https://cbsnews.com
4,79.134.42.230,http://microsoft.com
5,181.202.212.164,http://studiopress.com
6,48.131.203.247,https://bloglines.com
7,109.57.63.38,http://google.ru
8,91.243.96.208,https://state.tx.us
9,193.190.39.5,https://princeton.edu
10,81.30.58.12,https://forbes.com
11,177.24.171.6,https://psu.edu
12,138.73.192.228,http://cargocollective.com
13,41.53.124.171,https://senate.gov
14,32.172.199.234,http://ed.gov
15,126.56.189.28,http://mozilla.org
16,19.26.123.205,http://feedburner.com
17,56.255.149.74,http://newsvine.com
18,205.246.209.63,https://constantcontact.com
19,125.242.92.8,http://latimes.com
20,99.21.187.67,https://cornell.edu
21,196.114.209.22,https://hostgator.com
22,249.17.78.122,http://indiatimes.com
23,29.189.152.157,https://typepad.com
24,180.58.82.197,https://ftc.gov
25,58.81.31.167,http://businesswire.com
26,194.16.44.36,https://rakuten.co.jp
27,124.78.160.215,https://hibu.com
28,157.179.182.40,http://hibu.com
29,192.33.165.227,https://home.pl
30,0.60.17.105,https://wikia.com
31,211.110.45.67,https://adobe.com
32,91.199.155.90,http://google.com.br
33,39.215.114.86,https://fc2.com
34,247.234.202.57,https://vk.com
35,182.207.200.251,http://amazon.com
36,208.251.81.143,https://drupal.org
37,12.196.146.197,http://hubpages.com
38,217.23.172.97,https://state.tx.us
39,89.19.11.170,http://ustream.tv
40,15.144.237.174,http://businesswire.com
41,108.245.184.91,http://yolasite.com
42,67.72.48.218,https://goo.ne.jp
43,91.20.141.140,http://youtube.com
44,76.35.210.226,https://t-online.de
45,195.247.120.240,http://ask.com
46,40.67.186.129,http://ihg.com
47,115.22.80.58,http://ebay.com
48,104.151.49.202,http://nps.gov
49,17.117.113.112,https://apache.org
50,86.231.162.109,https://tmall.com
51,250.102.66.241,http://vinaora.com
52,20.225.118.184,http://ustream.tv
53,21.109.222.231,http://phoca.cz
54,136.49.193.247,http://ustream.tv
55,94.155.224.179,http://shutterfly.com
56,224.106.255.172,http://eepurl.com
57,69.125.42.134,http://intel.com
58,203.149.36.154,https://hao123.com
59,62.118.236.14,https://arstechnica.com
60,129.8.223.46,http://ow.ly
61,94.230.172.86,https://barnesandnoble.com
62,101.203.169.158,http://wp.com
63,239.188.143.121,http://newyorker.com
64,159.127.74.95,http://flickr.com
65,114.226.147.77,https://ucoz.com
66,148.25.93.199,https://ameblo.jp
67,255.91.125.31,http://mit.edu
68,74.143.18.177,https://usgs.gov
69,199.53.99.240,https://google.com.br
70,197.180.238.154,http://acquirethisname.com
71,58.1.68.195,http://surveymonkey.com
72,108.233.23.96,http://vkontakte.ru
73,197.177.168.123,http://list-manage.com
74,240.34.236.123,http://biglobe.ne.jp
75,56.201.201.170,https://cocolog-nifty.com
76,8.191.189.135,http://sphinn.com
77,197.230.182.61,http://marketwatch.com
78,94.25.158.59,http://businessweek.com
79,102.221.163.253,http://webeden.co.uk
80,46.244.182.93,http://taobao.com
81,245.103.51.232,http://nature.com
82,142.219.100.135,http://rakuten.co.jp
83,249.128.248.178,https://phpbb.com
84,117.94.158.86,http://vk.com
85,49.169.82.156,http://tripod.com
86,140.236.242.149,http://ezinearticles.com
87,45.174.23.157,https://upenn.edu
88,115.130.176.201,https://guardian.co.uk
89,184.248.173.101,http://behance.net
90,85.233.80.180,https://youku.com
91,48.163.77.88,http://amazon.de
92,202.230.111.183,https://issuu.com
93,34.175.234.98,http://phoca.cz
94,241.242.27.211,https://sina.com.cn
95,157.234.126.172,https://t.co
96,9.243.27.97,https://goo.ne.jp
97,225.94.78.148,https://goo.gl
98,64.34.102.161,http://howstuffworks.com
99,14.63.189.172,https://histats.com
100,154.247.8.231,https://fotki.com
\.


COPY public.owner FROM STDIN WITH CSV;
Robert
\.


COPY public.supplier FROM STDIN WITH CSV;
299,194,Johnny Ryall,597-500-569,CEO
157,346,George Clinton,131-002-530,Sales manager
\.


COPY test_pg_dump_anon.no_masks FROM STDIN WITH CSV;
1
\.

--
-- PostgreSQL database dump
--

-- Dumped from database version 14.3 (Debian 14.3-1.pgdg110+1)
-- Dumped by pg_dump version 14.1 (Debian 14.1-1.pgdg110+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: BuG_298; Type: SEQUENCE SET; Schema: FoO; Owner: postgres
--

SELECT pg_catalog.setval('"FoO"."BuG_298"', 298, false);


--
-- Name: company_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.company_id_seq', 1, false);


--
-- Name: seq42; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.seq42', 42, false);


--
-- Name: supplier_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.supplier_id_seq', 1, false);


--
-- Name: three; Type: SEQUENCE SET; Schema: test_pg_dump_anon; Owner: postgres
--

SELECT pg_catalog.setval('test_pg_dump_anon.three', 3, false);


--
-- PostgreSQL database dump complete
--

--
-- PostgreSQL database dump
--

-- Dumped from database version 14.3 (Debian 14.3-1.pgdg110+1)
-- Dumped by pg_dump version 14.1 (Debian 14.1-1.pgdg110+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;

SET default_tablespace = '';

--
-- Name: company company_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.company
    ADD CONSTRAINT company_pkey PRIMARY KEY (id);


--
-- Name: company company_vat_id_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.company
    ADD CONSTRAINT company_vat_id_key UNIQUE (vat_id);


--
-- Name: supplier supplier_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.supplier
    ADD CONSTRAINT supplier_pkey PRIMARY KEY (id);


--
-- Name: supplier supplier_fk_company_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.supplier
    ADD CONSTRAINT supplier_fk_company_id_fkey FOREIGN KEY (fk_company_id) REFERENCES public.company(id);


--
-- PostgreSQL database dump complete
--

