--
-- 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-07-14 01:32:22

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 = '';

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,
    countchannel bigint[],
    mistakesrole bigint[],
    joinleavelog bigint,
    raidrole bigint,
    isolationtime bigint DEFAULT 0,
    guildmistakes bigint DEFAULT 0 NOT NULL
);


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
);


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 207 (class 1259 OID 24577)
-- Name: user; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public."user" (
    member bigint NOT NULL,
    joincount bigint,
    mistakes bigint DEFAULT 0 NOT NULL
);


ALTER TABLE public."user" OWNER TO postgres;

--
-- TOC entry 2859 (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 2855 (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 2861 (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 2857 (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);


--
-- TOC entry 2863 (class 2606 OID 24582)
-- Name: user user_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public."user"
    ADD CONSTRAINT user_pkey PRIMARY KEY (member);


-- Completed on 2021-07-14 01:32:31

--
-- PostgreSQL database dump complete
--