schema.sql

--
-- PostgreSQL database dump
--

-- Dumped from database version 16.4 (Ubuntu 16.4-1.pgdg22.04+1)
-- Dumped by pg_dump version 16.4 (Ubuntu 16.4-1.pgdg22.04+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: public; Type: SCHEMA; Schema: -; Owner: -
--

-- *not* creating schema, since initdb creates it


SET default_tablespace = '';

SET default_table_access_method = heap;

--
-- Name: afk; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.afk (
    user_id bigint,
    added_time timestamp with time zone,
    text text
);


--
-- Name: blacklisted_users; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.blacklisted_users (
    user_id bigint,
    reason text
);


--
-- Name: economy; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.economy (
    user_id bigint NOT NULL,
    bank bigint DEFAULT 0,
    wallet bigint DEFAULT 100
);


--
-- Name: imoog; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.imoog (
    identifier text,
    media bytea,
    mime text
);


--
-- Name: invalidation_config; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.invalidation_config (
    entity_id bigint NOT NULL,
    entity_type smallint NOT NULL
);


--
-- Name: invalidation_out; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.invalidation_out (
    entity_id bigint NOT NULL,
    entity_type smallint NOT NULL
);


--
-- Name: jobs; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.jobs (
    job_name text,
    amount_paid bigint
);


--
-- Name: prefixes; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.prefixes (
    is_dm integer,
    id bigint,
    prefix text
);


--
-- Name: random_history; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.random_history (
    response text
);


--
-- Name: rtfm_dictionary; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.rtfm_dictionary (
    name text,
    link text
);


--
-- Name: subreddits; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.subreddits (
    name text
);


--
-- Name: sus_users; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.sus_users (
    user_id bigint,
    reason text
);


--
-- Name: testers_list; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.testers_list (
    user_id bigint
);


--
-- Name: tickets; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.tickets (
    author_id bigint,
    remote_id bigint,
    end_timestamp bigint
);


--
-- Name: todo; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.todo (
    user_id bigint NOT NULL,
    added_time timestamp with time zone NOT NULL,
    text text NOT NULL,
    jump_url text NOT NULL
);


--
-- Name: economy economy_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.economy
    ADD CONSTRAINT economy_pkey PRIMARY KEY (user_id);


--
-- Name: invalidation_config invalidation_config_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.invalidation_config
    ADD CONSTRAINT invalidation_config_pkey PRIMARY KEY (entity_id, entity_type);


--
-- Name: invalidation_out invalidation_out_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.invalidation_out
    ADD CONSTRAINT invalidation_out_pkey PRIMARY KEY (entity_id, entity_type);


--
-- Name: todo todo_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.todo
    ADD CONSTRAINT todo_pkey PRIMARY KEY (user_id, text);


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

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


--
-- PostgreSQL database dump complete
--