--
-- PostgreSQL database dump
--

-- Dumped from database version 12.7 (Ubuntu 12.7-0ubuntu0.20.10.1)
-- Dumped by pg_dump version 13.3

-- Started on 2021-09-01 19:36:53

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;

DROP DATABASE postgres;
--
-- TOC entry 2988 (class 1262 OID 13458)
-- Name: postgres; Type: DATABASE; Schema: -; Owner: postgres
--

CREATE DATABASE postgres WITH TEMPLATE = template0 ENCODING = 'UTF8' LOCALE = 'en_US.UTF-8';


ALTER DATABASE postgres OWNER TO postgres;

\connect postgres

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;

--
-- TOC entry 2989 (class 0 OID 0)
-- Dependencies: 2988
-- Name: DATABASE postgres; Type: COMMENT; Schema: -; Owner: postgres
--

COMMENT ON DATABASE postgres IS 'default administrative connection database';


--
-- TOC entry 3 (class 2615 OID 2200)
-- Name: public; Type: SCHEMA; Schema: -; Owner: postgres
--

CREATE SCHEMA public;


ALTER SCHEMA public OWNER TO postgres;

--
-- TOC entry 2990 (class 0 OID 0)
-- Dependencies: 3
-- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
--

COMMENT ON SCHEMA public IS 'standard public schema';


SET default_tablespace = '';

SET default_table_access_method = heap;

--
-- TOC entry 205 (class 1259 OID 16406)
-- Name: ban; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ban (
    identifier bigint NOT NULL,
    category integer NOT NULL
);


ALTER TABLE public.ban OWNER TO postgres;

--
-- TOC entry 202 (class 1259 OID 16384)
-- Name: data; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.data (
    guild bigint NOT NULL,
    prefix text,
    category bigint,
    accessrole bigint[] NOT NULL,
    logging bigint,
    welcome text,
    goodbye text,
    loggingplus boolean NOT NULL,
    pingrole bigint[] NOT NULL,
    blacklist bigint[] NOT NULL,
    anonymous boolean NOT NULL,
    lockedroles bigint[],
    raidchannel bigint[],
    currentcount bigint DEFAULT 0 NOT NULL,
    raidmode boolean DEFAULT false NOT NULL,
    acc_age bigint DEFAULT 7 NOT NULL,
    raidlog bigint,
    mistakesrole bigint[],
    joinleavelog bigint,
    raidrole bigint,
    isolationtime bigint DEFAULT 0,
    guildmistakes bigint DEFAULT 0 NOT NULL,
    countchannel bigint,
    deletedmessages bigint,
    editedmessages bigint
);


ALTER TABLE public.data OWNER TO postgres;

--
-- TOC entry 206 (class 1259 OID 16411)
-- Name: preference; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.preference (
    identifier bigint NOT NULL,
    confirmation boolean NOT NULL,
    joincount bigint,
    mistakes bigint
);


ALTER TABLE public.preference OWNER TO postgres;

--
-- TOC entry 204 (class 1259 OID 16398)
-- Name: premium; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.premium (
    identifier bigint NOT NULL,
    guild bigint[] NOT NULL,
    expiry bigint
);


ALTER TABLE public.premium OWNER TO postgres;

--
-- TOC entry 203 (class 1259 OID 16392)
-- Name: snippet; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.snippet (
    guild bigint NOT NULL,
    name text NOT NULL,
    content text NOT NULL
);


ALTER TABLE public.snippet OWNER TO postgres;

--
-- TOC entry 2854 (class 2606 OID 16410)
-- Name: ban ban_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.ban
    ADD CONSTRAINT ban_pkey PRIMARY KEY (identifier);


--
-- TOC entry 2850 (class 2606 OID 16391)
-- Name: data data_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.data
    ADD CONSTRAINT data_pkey PRIMARY KEY (guild);


--
-- TOC entry 2856 (class 2606 OID 16415)
-- Name: preference preference_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.preference
    ADD CONSTRAINT preference_pkey PRIMARY KEY (identifier);


--
-- TOC entry 2852 (class 2606 OID 16405)
-- Name: premium premium_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.premium
    ADD CONSTRAINT premium_pkey PRIMARY KEY (identifier);


-- Completed on 2021-09-01 19:37:05

--
-- PostgreSQL database dump complete
--