--
-- PostgreSQL database dump
--

-- Dumped from database version 18.4 (Ubuntu 18.4-1.pgdg24.04+1)
-- Dumped by pg_dump version 18.4 (Ubuntu 18.4-1.pgdg24.04+1)

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET transaction_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: cname; Type: TABLE; Schema: public; Owner: areauser
--

CREATE TABLE public.cname (
    areaid text NOT NULL,
    displayid text,
    lname text NOT NULL,
    fmname text,
    aname text,
    gen integer,
    genlab text,
    privacy text NOT NULL,
    touched timestamp with time zone DEFAULT now() NOT NULL,
    id integer NOT NULL,
    CONSTRAINT bad_char_in_id CHECK ((areaid ~ '^[ABCDEFGHIJKLMNOPQRSTUVWXYZ[:digit:]]{1,6}([.][[:digit:]]{2,})?$'::text)),
    CONSTRAINT bad_generation CHECK (((gen > 0) AND (gen < 4000))),
    CONSTRAINT ids_must_match CHECK ((upper(displayid) = areaid)),
    CONSTRAINT missing_gen CHECK (((genlab IS NULL) OR (gen IS NOT NULL))),
    CONSTRAINT missing_lead_zeros CHECK ((areaid !~ '^[[:digit:]]{1,4}([.][[:digit:]]+)?$'::text))
);


ALTER TABLE public.cname OWNER TO areauser;

--
-- Name: cname_id_seq; Type: SEQUENCE; Schema: public; Owner: areauser
--

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


ALTER SEQUENCE public.cname_id_seq OWNER TO areauser;

--
-- Name: cname_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: areauser
--

ALTER SEQUENCE public.cname_id_seq OWNED BY public.cname.id;


--
-- Name: priv; Type: TABLE; Schema: public; Owner: areauser
--

CREATE TABLE public.priv (
    pname text NOT NULL,
    pord integer NOT NULL,
    ptxt text,
    CONSTRAINT pord_nonnegative CHECK ((pord >= 0))
);


ALTER TABLE public.priv OWNER TO areauser;

--
-- Name: cname_web; Type: VIEW; Schema: public; Owner: areauser
--

CREATE VIEW public.cname_web WITH (security_barrier='true') AS
 SELECT cname.areaid,
    cname.displayid,
        CASE
            WHEN (a.pord <= b.pord) THEN cname.lname
            ELSE NULL::text
        END AS lname,
        CASE
            WHEN (a.pord <= b.pord) THEN cname.fmname
            ELSE NULL::text
        END AS fmname,
        CASE
            WHEN (a.pord <= b.pord) THEN cname.aname
            ELSE NULL::text
        END AS aname,
        CASE
            WHEN (a.pord <= b.pord) THEN cname.gen
            ELSE NULL::integer
        END AS gen,
        CASE
            WHEN (a.pord <= b.pord) THEN cname.genlab
            ELSE NULL::text
        END AS genlab,
        CASE
            WHEN (a.pord <= b.pord) THEN cname.touched
            ELSE NULL::timestamp with time zone
        END AS touched
   FROM public.cname,
    public.priv a,
    public.priv b
  WHERE ((a.pname = cname.privacy) AND (b.pname = 'web'::text));


ALTER VIEW public.cname_web OWNER TO areauser;

--
-- Name: contacts; Type: TABLE; Schema: public; Owner: areauser
--

CREATE TABLE public.contacts (
    contact text NOT NULL,
    email text NOT NULL,
    CONSTRAINT bad_char_in_contact CHECK ((contact ~ '^[[:upper:][:digit:]]+$'::text)),
    CONSTRAINT bad_char_in_email CHECK ((email ~ '^[-_.[:alnum:]]+@[-_.[:alnum:]]+$'::text))
);


ALTER TABLE public.contacts OWNER TO areauser;

--
-- Name: crate; Type: TABLE; Schema: public; Owner: areauser
--

CREATE TABLE public.crate (
    areaid text NOT NULL,
    gameid text NOT NULL,
    rate integer DEFAULT 5000 NOT NULL,
    frq integer DEFAULT 0 NOT NULL,
    opp integer DEFAULT 0 NOT NULL,
    rmp integer DEFAULT 0 NOT NULL,
    trn integer DEFAULT 0 NOT NULL,
    rmc integer DEFAULT 0 NOT NULL,
    gm text,
    touched timestamp with time zone DEFAULT now() NOT NULL,
    id integer NOT NULL,
    CONSTRAINT frq_nonnegative CHECK ((frq >= 0)),
    CONSTRAINT opp_nonnegative CHECK ((opp >= 0)),
    CONSTRAINT rate_nonnegative CHECK ((rate >= 0)),
    CONSTRAINT rate_other_interested CHECK (((frq > 0) OR (rate = 5000))),
    CONSTRAINT rmc_nonnegative CHECK ((rmc >= 0)),
    CONSTRAINT rmp_nonnegative CHECK ((rmp >= 0)),
    CONSTRAINT trn_nonnegative CHECK ((trn >= 0))
);


ALTER TABLE public.crate OWNER TO areauser;

--
-- Name: crate_id_seq; Type: SEQUENCE; Schema: public; Owner: areauser
--

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


ALTER SEQUENCE public.crate_id_seq OWNER TO areauser;

--
-- Name: crate_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: areauser
--

ALTER SEQUENCE public.crate_id_seq OWNED BY public.crate.id;


--
-- Name: gamepubs; Type: TABLE; Schema: public; Owner: areauser
--

CREATE TABLE public.gamepubs (
    gameid text NOT NULL,
    pubid text NOT NULL,
    id integer NOT NULL
);


ALTER TABLE public.gamepubs OWNER TO areauser;

--
-- Name: gamepubs_id_seq; Type: SEQUENCE; Schema: public; Owner: areauser
--

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


ALTER SEQUENCE public.gamepubs_id_seq OWNER TO areauser;

--
-- Name: gamepubs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: areauser
--

ALTER SEQUENCE public.gamepubs_id_seq OWNED BY public.gamepubs.id;


--
-- Name: games; Type: TABLE; Schema: public; Owner: areauser
--

CREATE TABLE public.games (
    gameid text NOT NULL,
    title text NOT NULL,
    rtype text NOT NULL,
    sol boolean NOT NULL,
    contact text NOT NULL,
    touched timestamp with time zone DEFAULT now() NOT NULL,
    id integer NOT NULL,
    CONSTRAINT bad_char_in_id CHECK ((gameid ~ '^[[:upper:][:digit:]]+$'::text)),
    CONSTRAINT bad_char_in_title CHECK ((title ~ '^[^[:cntrl:][:space:]]+( [^[:cntrl:][:space:]]+)*$'::text))
);


ALTER TABLE public.games OWNER TO areauser;

--
-- Name: games_id_seq; Type: SEQUENCE; Schema: public; Owner: areauser
--

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


ALTER SEQUENCE public.games_id_seq OWNER TO areauser;

--
-- Name: games_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: areauser
--

ALTER SEQUENCE public.games_id_seq OWNED BY public.games.id;


--
-- Name: gameurls; Type: TABLE; Schema: public; Owner: areauser
--

CREATE TABLE public.gameurls (
    gameid text NOT NULL,
    url text NOT NULL,
    comment text NOT NULL,
    expires timestamp with time zone DEFAULT 'infinity'::timestamp with time zone NOT NULL,
    id integer NOT NULL,
    CONSTRAINT bad_char_in_comment CHECK ((comment ~ '^[^[:cntrl:][:space:]]+( [^[:cntrl:][:space:]]+)*$'::text)),
    CONSTRAINT bad_char_in_url CHECK ((url ~ '^[^[:cntrl:][:space:]]+$'::text))
);


ALTER TABLE public.gameurls OWNER TO areauser;

--
-- Name: gameurls_id_seq; Type: SEQUENCE; Schema: public; Owner: areauser
--

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


ALTER SEQUENCE public.gameurls_id_seq OWNER TO areauser;

--
-- Name: gameurls_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: areauser
--

ALTER SEQUENCE public.gameurls_id_seq OWNED BY public.gameurls.id;


--
-- Name: genlabs; Type: TABLE; Schema: public; Owner: areauser
--

CREATE TABLE public.genlabs (
    genlab text NOT NULL,
    gen integer NOT NULL,
    CONSTRAINT bad_generation CHECK (((gen > 0) AND (gen < 4000))),
    CONSTRAINT bad_genlab CHECK ((genlab ~ '^[^[:cntrl:][:space:]]+( [^[:cntrl:][:space:]]+)*$'::text))
);


ALTER TABLE public.genlabs OWNER TO areauser;

--
-- Name: publishers; Type: TABLE; Schema: public; Owner: areauser
--

CREATE TABLE public.publishers (
    pubid text NOT NULL,
    pubname text NOT NULL,
    puburl text,
    id integer NOT NULL,
    CONSTRAINT bad_char_in_id CHECK ((pubid ~ '^[[:upper:][:digit:]]+$'::text)),
    CONSTRAINT bad_char_in_url CHECK ((puburl ~ '^[^[:cntrl:][:space:]]+$'::text))
);


ALTER TABLE public.publishers OWNER TO areauser;

--
-- Name: publishers_id_seq; Type: SEQUENCE; Schema: public; Owner: areauser
--

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


ALTER SEQUENCE public.publishers_id_seq OWNER TO areauser;

--
-- Name: publishers_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: areauser
--

ALTER SEQUENCE public.publishers_id_seq OWNED BY public.publishers.id;


--
-- Name: rtypes; Type: TABLE; Schema: public; Owner: areauser
--

CREATE TABLE public.rtypes (
    rtype text NOT NULL,
    descr text NOT NULL,
    cell_o5 text DEFAULT ' '::text NOT NULL,
    CONSTRAINT bad_char_in_descr CHECK ((descr ~ '^[^[:cntrl:][:space:]]+( [^[:cntrl:][:space:]]+)*$'::text)),
    CONSTRAINT bad_char_in_rtype CHECK ((rtype ~ '^[[:upper:][:digit:]]+$'::text))
);


ALTER TABLE public.rtypes OWNER TO areauser;

--
-- Name: wbc; Type: TABLE; Schema: public; Owner: areauser
--

CREATE TABLE public.wbc (
    code text NOT NULL,
    event text,
    url text,
    id integer NOT NULL,
    CONSTRAINT bad_char_in_code CHECK ((code ~ '^[^[:cntrl:][:space:]]+$'::text)),
    CONSTRAINT bad_char_in_event CHECK ((event ~ '^[^[:cntrl:][:space:]]+( [^[:cntrl:][:space:]]+)*$'::text)),
    CONSTRAINT bad_char_in_url CHECK ((url ~ '^[^[:cntrl:][:space:]]+$'::text)),
    CONSTRAINT no_slash_in_code CHECK ((code !~ '/'::text))
);


ALTER TABLE public.wbc OWNER TO areauser;

--
-- Name: wbc_id_seq; Type: SEQUENCE; Schema: public; Owner: areauser
--

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


ALTER SEQUENCE public.wbc_id_seq OWNER TO areauser;

--
-- Name: wbc_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: areauser
--

ALTER SEQUENCE public.wbc_id_seq OWNED BY public.wbc.id;


--
-- Name: wbcgames; Type: TABLE; Schema: public; Owner: areauser
--

CREATE TABLE public.wbcgames (
    code text NOT NULL,
    gameid text NOT NULL,
    id integer NOT NULL
);


ALTER TABLE public.wbcgames OWNER TO areauser;

--
-- Name: wbcgames_id_seq; Type: SEQUENCE; Schema: public; Owner: areauser
--

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


ALTER SEQUENCE public.wbcgames_id_seq OWNER TO areauser;

--
-- Name: wbcgames_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: areauser
--

ALTER SEQUENCE public.wbcgames_id_seq OWNED BY public.wbcgames.id;


--
-- Name: cname id; Type: DEFAULT; Schema: public; Owner: areauser
--

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


--
-- Name: crate id; Type: DEFAULT; Schema: public; Owner: areauser
--

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


--
-- Name: gamepubs id; Type: DEFAULT; Schema: public; Owner: areauser
--

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


--
-- Name: games id; Type: DEFAULT; Schema: public; Owner: areauser
--

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


--
-- Name: gameurls id; Type: DEFAULT; Schema: public; Owner: areauser
--

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


--
-- Name: publishers id; Type: DEFAULT; Schema: public; Owner: areauser
--

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


--
-- Name: wbc id; Type: DEFAULT; Schema: public; Owner: areauser
--

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


--
-- Name: wbcgames id; Type: DEFAULT; Schema: public; Owner: areauser
--

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


--
-- Name: cname cname_areaid_unique; Type: CONSTRAINT; Schema: public; Owner: areauser
--

ALTER TABLE ONLY public.cname
    ADD CONSTRAINT cname_areaid_unique UNIQUE (areaid);


--
-- Name: cname cname_pkey; Type: CONSTRAINT; Schema: public; Owner: areauser
--

ALTER TABLE ONLY public.cname
    ADD CONSTRAINT cname_pkey PRIMARY KEY (id);


--
-- Name: contacts contacts_pkey; Type: CONSTRAINT; Schema: public; Owner: areauser
--

ALTER TABLE ONLY public.contacts
    ADD CONSTRAINT contacts_pkey PRIMARY KEY (contact);


--
-- Name: crate crate_pkey; Type: CONSTRAINT; Schema: public; Owner: areauser
--

ALTER TABLE ONLY public.crate
    ADD CONSTRAINT crate_pkey PRIMARY KEY (id);


--
-- Name: gamepubs gamepubs_pkey; Type: CONSTRAINT; Schema: public; Owner: areauser
--

ALTER TABLE ONLY public.gamepubs
    ADD CONSTRAINT gamepubs_pkey PRIMARY KEY (id);


--
-- Name: gamepubs gamepubs_unique_game_pub; Type: CONSTRAINT; Schema: public; Owner: areauser
--

ALTER TABLE ONLY public.gamepubs
    ADD CONSTRAINT gamepubs_unique_game_pub UNIQUE (gameid, pubid);


--
-- Name: games games_gameid_key; Type: CONSTRAINT; Schema: public; Owner: areauser
--

ALTER TABLE ONLY public.games
    ADD CONSTRAINT games_gameid_key UNIQUE (gameid);


--
-- Name: games games_pkey; Type: CONSTRAINT; Schema: public; Owner: areauser
--

ALTER TABLE ONLY public.games
    ADD CONSTRAINT games_pkey PRIMARY KEY (id);


--
-- Name: games games_title_key; Type: CONSTRAINT; Schema: public; Owner: areauser
--

ALTER TABLE ONLY public.games
    ADD CONSTRAINT games_title_key UNIQUE (title);


--
-- Name: games games_unique_gameid; Type: CONSTRAINT; Schema: public; Owner: areauser
--

ALTER TABLE ONLY public.games
    ADD CONSTRAINT games_unique_gameid UNIQUE (gameid);


--
-- Name: gameurls gameurls_pkey; Type: CONSTRAINT; Schema: public; Owner: areauser
--

ALTER TABLE ONLY public.gameurls
    ADD CONSTRAINT gameurls_pkey PRIMARY KEY (id);


--
-- Name: gameurls gameurls_unique_game_url; Type: CONSTRAINT; Schema: public; Owner: areauser
--

ALTER TABLE ONLY public.gameurls
    ADD CONSTRAINT gameurls_unique_game_url UNIQUE (gameid, url);


--
-- Name: genlabs genlab_unique_label; Type: CONSTRAINT; Schema: public; Owner: areauser
--

ALTER TABLE ONLY public.genlabs
    ADD CONSTRAINT genlab_unique_label UNIQUE (genlab);


--
-- Name: genlabs genlabs_pkey; Type: CONSTRAINT; Schema: public; Owner: areauser
--

ALTER TABLE ONLY public.genlabs
    ADD CONSTRAINT genlabs_pkey PRIMARY KEY (gen);


--
-- Name: priv priv_pkey; Type: CONSTRAINT; Schema: public; Owner: areauser
--

ALTER TABLE ONLY public.priv
    ADD CONSTRAINT priv_pkey PRIMARY KEY (pname);


--
-- Name: priv priv_pord_key; Type: CONSTRAINT; Schema: public; Owner: areauser
--

ALTER TABLE ONLY public.priv
    ADD CONSTRAINT priv_pord_key UNIQUE (pord);


--
-- Name: publishers publishers_pkey; Type: CONSTRAINT; Schema: public; Owner: areauser
--

ALTER TABLE ONLY public.publishers
    ADD CONSTRAINT publishers_pkey PRIMARY KEY (id);


--
-- Name: publishers publishers_unique_pubid; Type: CONSTRAINT; Schema: public; Owner: areauser
--

ALTER TABLE ONLY public.publishers
    ADD CONSTRAINT publishers_unique_pubid UNIQUE (pubid);


--
-- Name: rtypes rtypes_pkey; Type: CONSTRAINT; Schema: public; Owner: areauser
--

ALTER TABLE ONLY public.rtypes
    ADD CONSTRAINT rtypes_pkey PRIMARY KEY (rtype);


--
-- Name: wbc wbc_pkey; Type: CONSTRAINT; Schema: public; Owner: areauser
--

ALTER TABLE ONLY public.wbc
    ADD CONSTRAINT wbc_pkey PRIMARY KEY (id);


--
-- Name: wbc wbc_unique_code; Type: CONSTRAINT; Schema: public; Owner: areauser
--

ALTER TABLE ONLY public.wbc
    ADD CONSTRAINT wbc_unique_code UNIQUE (code);


--
-- Name: wbcgames wbcgames_pkey; Type: CONSTRAINT; Schema: public; Owner: areauser
--

ALTER TABLE ONLY public.wbcgames
    ADD CONSTRAINT wbcgames_pkey PRIMARY KEY (id);


--
-- Name: wbcgames wbcgames_unique_code_game; Type: CONSTRAINT; Schema: public; Owner: areauser
--

ALTER TABLE ONLY public.wbcgames
    ADD CONSTRAINT wbcgames_unique_code_game UNIQUE (code, gameid);


--
-- Name: crate_areaid_game; Type: INDEX; Schema: public; Owner: areauser
--

CREATE UNIQUE INDEX crate_areaid_game ON public.crate USING btree (areaid, gameid);


--
-- Name: crate_game; Type: INDEX; Schema: public; Owner: areauser
--

CREATE INDEX crate_game ON public.crate USING btree (gameid, areaid);


--
-- Name: crate_touched; Type: INDEX; Schema: public; Owner: areauser
--

CREATE INDEX crate_touched ON public.crate USING btree (areaid, touched);


--
-- Name: fki_cname_fkey_genlab; Type: INDEX; Schema: public; Owner: areauser
--

CREATE INDEX fki_cname_fkey_genlab ON public.cname USING btree (genlab);


--
-- Name: gameurls_gameid_idx; Type: INDEX; Schema: public; Owner: areauser
--

CREATE INDEX gameurls_gameid_idx ON public.gameurls USING btree (gameid);


--
-- Name: lname_idx; Type: INDEX; Schema: public; Owner: areauser
--

CREATE INDEX lname_idx ON public.cname USING btree (lower(lname));


--
-- Name: title_idx; Type: INDEX; Schema: public; Owner: areauser
--

CREATE INDEX title_idx ON public.games USING btree (lower(title));


--
-- Name: wbc_lower; Type: INDEX; Schema: public; Owner: areauser
--

CREATE UNIQUE INDEX wbc_lower ON public.wbc USING btree (lower(code));


--
-- Name: crate bad_areaid; Type: FK CONSTRAINT; Schema: public; Owner: areauser
--

ALTER TABLE ONLY public.crate
    ADD CONSTRAINT bad_areaid FOREIGN KEY (areaid) REFERENCES public.cname(areaid);


--
-- Name: games bad_contact; Type: FK CONSTRAINT; Schema: public; Owner: areauser
--

ALTER TABLE ONLY public.games
    ADD CONSTRAINT bad_contact FOREIGN KEY (contact) REFERENCES public.contacts(contact);


--
-- Name: crate bad_gameid; Type: FK CONSTRAINT; Schema: public; Owner: areauser
--

ALTER TABLE ONLY public.crate
    ADD CONSTRAINT bad_gameid FOREIGN KEY (gameid) REFERENCES public.games(gameid);


--
-- Name: gamepubs bad_gameid; Type: FK CONSTRAINT; Schema: public; Owner: areauser
--

ALTER TABLE ONLY public.gamepubs
    ADD CONSTRAINT bad_gameid FOREIGN KEY (gameid) REFERENCES public.games(gameid);


--
-- Name: gameurls bad_gameid; Type: FK CONSTRAINT; Schema: public; Owner: areauser
--

ALTER TABLE ONLY public.gameurls
    ADD CONSTRAINT bad_gameid FOREIGN KEY (gameid) REFERENCES public.games(gameid);


--
-- Name: wbcgames bad_gameid; Type: FK CONSTRAINT; Schema: public; Owner: areauser
--

ALTER TABLE ONLY public.wbcgames
    ADD CONSTRAINT bad_gameid FOREIGN KEY (gameid) REFERENCES public.games(gameid);


--
-- Name: cname bad_privacy; Type: FK CONSTRAINT; Schema: public; Owner: areauser
--

ALTER TABLE ONLY public.cname
    ADD CONSTRAINT bad_privacy FOREIGN KEY (privacy) REFERENCES public.priv(pname);


--
-- Name: gamepubs bad_pubid; Type: FK CONSTRAINT; Schema: public; Owner: areauser
--

ALTER TABLE ONLY public.gamepubs
    ADD CONSTRAINT bad_pubid FOREIGN KEY (pubid) REFERENCES public.publishers(pubid);


--
-- Name: games bad_rtype; Type: FK CONSTRAINT; Schema: public; Owner: areauser
--

ALTER TABLE ONLY public.games
    ADD CONSTRAINT bad_rtype FOREIGN KEY (rtype) REFERENCES public.rtypes(rtype);


--
-- Name: wbcgames bad_wbc_code; Type: FK CONSTRAINT; Schema: public; Owner: areauser
--

ALTER TABLE ONLY public.wbcgames
    ADD CONSTRAINT bad_wbc_code FOREIGN KEY (code) REFERENCES public.wbc(code);


--
-- Name: cname cname_fkey_genlab; Type: FK CONSTRAINT; Schema: public; Owner: areauser
--

ALTER TABLE ONLY public.cname
    ADD CONSTRAINT cname_fkey_genlab FOREIGN KEY (genlab) REFERENCES public.genlabs(genlab);


--
-- Name: SCHEMA public; Type: ACL; Schema: -; Owner: pg_database_owner
--

REVOKE USAGE ON SCHEMA public FROM PUBLIC;
GRANT ALL ON SCHEMA public TO PUBLIC;


--
-- Name: TABLE priv; Type: ACL; Schema: public; Owner: areauser
--

GRANT ALL ON TABLE public.priv TO "www-data";
GRANT SELECT ON TABLE public.priv TO PUBLIC;


--
-- Name: TABLE cname_web; Type: ACL; Schema: public; Owner: areauser
--

GRANT ALL ON TABLE public.cname_web TO "www-data";
GRANT SELECT ON TABLE public.cname_web TO PUBLIC;


--
-- Name: TABLE contacts; Type: ACL; Schema: public; Owner: areauser
--

GRANT ALL ON TABLE public.contacts TO "www-data";
GRANT SELECT ON TABLE public.contacts TO PUBLIC;


--
-- Name: TABLE crate; Type: ACL; Schema: public; Owner: areauser
--

GRANT ALL ON TABLE public.crate TO "www-data";
GRANT SELECT ON TABLE public.crate TO PUBLIC;


--
-- Name: TABLE gamepubs; Type: ACL; Schema: public; Owner: areauser
--

GRANT ALL ON TABLE public.gamepubs TO "www-data";
GRANT SELECT ON TABLE public.gamepubs TO PUBLIC;


--
-- Name: TABLE games; Type: ACL; Schema: public; Owner: areauser
--

GRANT ALL ON TABLE public.games TO "www-data";
GRANT SELECT ON TABLE public.games TO PUBLIC;


--
-- Name: TABLE gameurls; Type: ACL; Schema: public; Owner: areauser
--

GRANT ALL ON TABLE public.gameurls TO "www-data";
GRANT SELECT ON TABLE public.gameurls TO PUBLIC;


--
-- Name: TABLE genlabs; Type: ACL; Schema: public; Owner: areauser
--

GRANT ALL ON TABLE public.genlabs TO "www-data";
GRANT SELECT ON TABLE public.genlabs TO PUBLIC;


--
-- Name: TABLE publishers; Type: ACL; Schema: public; Owner: areauser
--

GRANT ALL ON TABLE public.publishers TO "www-data";
GRANT SELECT ON TABLE public.publishers TO PUBLIC;


--
-- Name: TABLE rtypes; Type: ACL; Schema: public; Owner: areauser
--

GRANT ALL ON TABLE public.rtypes TO "www-data";
GRANT SELECT ON TABLE public.rtypes TO PUBLIC;


--
-- Name: TABLE wbc; Type: ACL; Schema: public; Owner: areauser
--

GRANT ALL ON TABLE public.wbc TO "www-data";
GRANT SELECT ON TABLE public.wbc TO PUBLIC;


--
-- Name: TABLE wbcgames; Type: ACL; Schema: public; Owner: areauser
--

GRANT ALL ON TABLE public.wbcgames TO "www-data";
GRANT SELECT ON TABLE public.wbcgames TO PUBLIC;


--
-- PostgreSQL database dump complete
--