database

--
-- PostgreSQL database dump
--

-- Dumped from database version 9.6.2
-- Dumped by pg_dump version 9.6.2

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET row_security = off;

--
-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: 
--

CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;


--
-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: 
--

COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';


SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

CREATE TABLE events (
    event_id bigint NOT NULL,
    name text NOT NULL,
    description text NOT NULL,
    number_of_participants integer NOT NULL,
    event_date date NOT NULL,
    event_time time without time zone NOT NULL,
    individual_participants integer NOT NULL,
    venue text NOT NULL,
    location text NOT NULL,
    link text NOT NULL,
    past money NOT NULL
);


ALTER TABLE events OWNER TO "postgres";

--
-- Name: group_members; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE group_members (
    member_id bigint NOT NULL,
    name text NOT NULL,
    bio text NOT NULL,
    city text NOT NULL,
    country text NOT NULL,
    gender text NOT NULL,
    birthday date NOT NULL,
    meetup_profile_link text NOT NULL
);


ALTER TABLE group_members OWNER TO "postgres";

--
-- Name: groups; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE groups (
    group_id bigint,
    name text,
    category_name text,
    city smallint,
    category_id bigint,
    meta_category_name text,
    organizer_id bigint,
    created_at time without time zone,
    description text,
    lat double precision,
    lon double precision,
    link text,
    meta_category_ids bigint,
    meta_cateogry_ smallint,
    id bigint NOT NULL
);


ALTER TABLE groups OWNER TO "postgres";

--
-- Name: groups_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE groups_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE groups_id_seq OWNER TO "postgres";

--
-- Name: groups_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE groups_id_seq OWNED BY groups.id;


--
-- Name: past_events; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE past_events (
    event_id bigint NOT NULL,
    name text NOT NULL,
    description text NOT NULL,
    number_of_participants integer NOT NULL,
    event_date date NOT NULL,
    event_time time without time zone NOT NULL,
    individual_participants integer NOT NULL,
    venue text NOT NULL,
    location text NOT NULL,
    link text NOT NULL,
    past money NOT NULL
);


ALTER TABLE past_events OWNER TO "postgres";

--
-- Name: rsvp; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE rsvp (
    user_id bigint NOT NULL,
    event_id bigint NOT NULL,
    "time" date NOT NULL
);


ALTER TABLE rsvp OWNER TO "postgres";

--
-- Name: groups id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY groups ALTER COLUMN id SET DEFAULT nextval('groups_id_seq'::regclass);


--
-- Data for Name: events; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY events (event_id, name, description, number_of_participants, event_date, event_time, individual_participants, venue, location, link, past) FROM stdin;
\.


--
-- Data for Name: group_members; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY group_members (member_id, name, bio, city, country, gender, birthday, meetup_profile_link) FROM stdin;
\.


--
-- Data for Name: groups; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY groups (group_id, name, category_name, city, category_id, meta_category_name, organizer_id, created_at, description, lat, lon, link, meta_category_ids, meta_cateogry_, id) FROM stdin;
\N	trial	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	2
\N	trial2	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	3
\.


--
-- Name: groups_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('groups_id_seq', 3, true);


--
-- Data for Name: past_events; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY past_events (event_id, name, description, number_of_participants, event_date, event_time, individual_participants, venue, location, link, past) FROM stdin;
\.


--
-- Data for Name: rsvp; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY rsvp (user_id, event_id, "time") FROM stdin;
\.


--
-- Name: groups groups_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY groups
    ADD CONSTRAINT groups_pkey PRIMARY KEY (id);


--
-- PostgreSQL database dump complete
--