agonj.dump

PGDMP



%pagonj9.2.29.2.2�
0
0ENCODINGENCODINGSET client_encoding = 'UTF8';






false

�
0
0
STDSTRINGS
STDSTRINGS(SET standard_conforming_strings = 'on';






false

�126216397agonjDATABASEcCREATE DATABASE agonj WITH TEMPLATE = template0 ENCODING = 'UTF8' LC_COLLATE = 'C' LC_CTYPE = 'C';
DROP DATABASE agonj;






postgresfalse

26152200publicSCHEMACREATE SCHEMA public;
DROP SCHEMA public;






postgresfalse

�
0
0
SCHEMA publicCOMMENT
6COMMENT ON SCHEMA public IS 'standard public schema';






postgresfalse
5

�307911995plpgsql	EXTENSION?CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
DROP EXTENSION plpgsql;






false

�
0
0EXTENSION plpgsqlCOMMENT
@COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';






false175

�125916420rolesTABLEPCREATE TABLE roles (
    id integer NOT NULL,
    role character varying(20)
);
DROP TABLE public.roles;


publicpostgresfalse
5

�125916418roles_id_seqSEQUENCEnCREATE SEQUENCE roles_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
#DROP SEQUENCE public.roles_id_seq;


public

postgresfalse172
5

�
0
0roles_id_seqSEQUENCE OWNED BY/ALTER SEQUENCE roles_id_seq OWNED BY roles.id;


public

postgresfalse171

�125916412sessionsTABLEACREATE TABLE sessions (
    session text,
    user_id integer
);
DROP TABLE public.sessions;


publicpostgresfalse
5

�125916400ticksTABLE=CREATE TABLE ticks (
    tick timestamp without time zone
);
DROP TABLE public.ticks;


publicpostgresfalse
5

�125916443	user_roleTABLEECREATE TABLE user_role (
    role_id integer,
    user_id integer
);
DROP TABLE public.user_role;


publicpostgresfalse
5

�125916403usersTABLEOCREATE TABLE users (
    name text,
    email text,
    id integer NOT NULL
);
DROP TABLE public.users;


publicpostgresfalse
5

�125916426users_id_seqSEQUENCEnCREATE SEQUENCE users_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
#DROP SEQUENCE public.users_id_seq;


public

postgresfalse
5169

�
0
0users_id_seqSEQUENCE OWNED BY/ALTER SEQUENCE users_id_seq OWNED BY users.id;


public

postgresfalse173

�260416423idDEFAULTVALTER TABLE ONLY roles ALTER COLUMN id SET DEFAULT nextval('roles_id_seq'::regclass);
7ALTER TABLE public.roles ALTER COLUMN id DROP DEFAULT;


public

postgresfalse171172172

�260416428idDEFAULTVALTER TABLE ONLY users ALTER COLUMN id SET DEFAULT nextval('users_id_seq'::regclass);
7ALTER TABLE public.users ALTER COLUMN id DROP DEFAULT;


public

postgresfalse173169

�

016420roles
TABLE DATA"COPY roles (id, role) FROM stdin;
public

postgresfalse172

��
0
0roles_id_seqSEQUENCE SET3SELECT pg_catalog.setval('roles_id_seq', 3, true);


public

postgresfalse171

�

016412sessions
TABLE DATA-COPY sessions (session, user_id) FROM stdin;
public

postgresfalse170


�

016400ticks
TABLE DATACOPY ticks (tick) FROM stdin;
public

postgresfalse168

H�

016443	user_role
TABLE DATA.COPY user_role (role_id, user_id) FROM stdin;
public

postgresfalse174

~�

016403users
TABLE DATA)COPY users (name, email, id) FROM stdin;
public

postgresfalse169

��
0
0users_id_seqSEQUENCE SET3SELECT pg_catalog.setval('users_id_seq', 1, true);


public

postgresfalse173

�260616425
roles_pkey
CONSTRAINTGALTER TABLE ONLY roles
    ADD CONSTRAINT roles_pkey PRIMARY KEY (id);
:ALTER TABLE ONLY public.roles DROP CONSTRAINT roles_pkey;


publicpostgresfalse172172

�260616436
users_pkey
CONSTRAINTGALTER TABLE ONLY users
    ADD CONSTRAINT users_pkey PRIMARY KEY (id);
:ALTER TABLE ONLY public.users DROP CONSTRAINT users_pkey;


publicpostgresfalse169169

�260616456sessions_user_id_fkey
FK CONSTRAINToALTER TABLE ONLY sessions
    ADD CONSTRAINT sessions_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(id);
HALTER TABLE ONLY public.sessions DROP CONSTRAINT sessions_user_id_fkey;


public

postgresfalse1691702205

�260616446user_role_role_id_fkey
FK CONSTRAINTqALTER TABLE ONLY user_role
    ADD CONSTRAINT user_role_role_id_fkey FOREIGN KEY (role_id) REFERENCES roles(id);
JALTER TABLE ONLY public.user_role DROP CONSTRAINT user_role_role_id_fkey;


public

postgresfalse1721742207

�260616451user_role_user_id_fkey
FK CONSTRAINTqALTER TABLE ONLY user_role
    ADD CONSTRAINT user_role_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(id);
JALTER TABLE ONLY public.user_role DROP CONSTRAINT user_role_user_id_fkey;


public

postgresfalse1742205169


�$x�3�LL����2�,/�,I�2�,JML�����seH
�7x��u1�2300MN1L�0H�L61J6K565M3217263�4L�4�򥪲=...=
�&x�3204�"#K+#+#K=Ss#3�=...d��
�x�3�4�2bc �����(
�2x����/J,I�L+J�K��,�+J��K,MqH�M���K���4�����Q8
�