source: OpenRLabs-Git/deploy/rlabs_installer/packages/openrlabs.sql @ 335213f

--
-- PostgreSQL database dump
--

-- Dumped from database version 10.17 (Debian 10.17-1.pgdg90+1)
-- Dumped by pg_dump version 10.17 (Ubuntu 10.17-0ubuntu0.18.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: 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 default_tablespace = '';

SET default_with_oids = false;

--
-- Name: active_directory; Type: TABLE; Schema: public; Owner: openrlabs
--

CREATE TABLE public.active_directory (
    id integer NOT NULL,
    admin_ad character varying(128),
    password character varying(128),
    server_ad character varying(512),
    base_db character varying(512)
);


ALTER TABLE public.active_directory OWNER TO openrlabs;

--
-- Name: active_directory_id_seq; Type: SEQUENCE; Schema: public; Owner: openrlabs
--

CREATE SEQUENCE public.active_directory_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.active_directory_id_seq OWNER TO openrlabs;

--
-- Name: active_directory_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: openrlabs
--

ALTER SEQUENCE public.active_directory_id_seq OWNED BY public.active_directory.id;


--
-- Name: reserves; Type: TABLE; Schema: public; Owner: openrlabs
--

CREATE TABLE public.reserves (
    id integer NOT NULL,
    user_id integer,
    ou_id character varying(512),
    lab_id character varying(512),
    pc_id character varying(512),
    pc_name character varying(512),
    expiration_time timestamp without time zone,
    ip character varying(512) NOT NULL,
    protocol character varying(512),
    port character varying(512),
    os character varying(512),
    is_assigned boolean DEFAULT false NOT NULL,
    assigned_init_time timestamp without time zone,
    image_id character varying NOT NULL,
    reserved_init_time timestamp without time zone NOT NULL,
    prereserve_id integer,
    mac character varying NOT NULL
);


ALTER TABLE public.reserves OWNER TO openrlabs;

--
-- Name: active_reserves_id_seq; Type: SEQUENCE; Schema: public; Owner: openrlabs
--

CREATE SEQUENCE public.active_reserves_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.active_reserves_id_seq OWNER TO openrlabs;

--
-- Name: active_reserves_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: openrlabs
--

ALTER SEQUENCE public.active_reserves_id_seq OWNED BY public.reserves.id;


--
-- Name: auth_cas; Type: TABLE; Schema: public; Owner: openrlabs
--

CREATE TABLE public.auth_cas (
    id integer NOT NULL,
    user_id integer,
    created_on timestamp without time zone,
    service character varying(512),
    ticket character varying(512),
    renew character(1)
);


ALTER TABLE public.auth_cas OWNER TO openrlabs;

--
-- Name: auth_cas_id_seq; Type: SEQUENCE; Schema: public; Owner: openrlabs
--

CREATE SEQUENCE public.auth_cas_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.auth_cas_id_seq OWNER TO openrlabs;

--
-- Name: auth_cas_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: openrlabs
--

ALTER SEQUENCE public.auth_cas_id_seq OWNED BY public.auth_cas.id;


--
-- Name: auth_event; Type: TABLE; Schema: public; Owner: openrlabs
--

CREATE TABLE public.auth_event (
    id integer NOT NULL,
    time_stamp timestamp without time zone,
    client_ip character varying(512),
    user_id integer,
    origin character varying(512),
    description text
);


ALTER TABLE public.auth_event OWNER TO openrlabs;

--
-- Name: auth_event_id_seq; Type: SEQUENCE; Schema: public; Owner: openrlabs
--

CREATE SEQUENCE public.auth_event_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.auth_event_id_seq OWNER TO openrlabs;

--
-- Name: auth_event_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: openrlabs
--

ALTER SEQUENCE public.auth_event_id_seq OWNED BY public.auth_event.id;


--
-- Name: auth_group; Type: TABLE; Schema: public; Owner: openrlabs
--

CREATE TABLE public.auth_group (
    id integer NOT NULL,
    role character varying(512),
    description text
);


ALTER TABLE public.auth_group OWNER TO openrlabs;

--
-- Name: auth_group_id_seq; Type: SEQUENCE; Schema: public; Owner: openrlabs
--

CREATE SEQUENCE public.auth_group_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.auth_group_id_seq OWNER TO openrlabs;

--
-- Name: auth_group_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: openrlabs
--

ALTER SEQUENCE public.auth_group_id_seq OWNED BY public.auth_group.id;


--
-- Name: auth_membership; Type: TABLE; Schema: public; Owner: openrlabs
--

CREATE TABLE public.auth_membership (
    id integer NOT NULL,
    user_id integer,
    group_id integer
);


ALTER TABLE public.auth_membership OWNER TO openrlabs;

--
-- Name: auth_membership_id_seq; Type: SEQUENCE; Schema: public; Owner: openrlabs
--

CREATE SEQUENCE public.auth_membership_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.auth_membership_id_seq OWNER TO openrlabs;

--
-- Name: auth_membership_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: openrlabs
--

ALTER SEQUENCE public.auth_membership_id_seq OWNED BY public.auth_membership.id;


--
-- Name: auth_permission; Type: TABLE; Schema: public; Owner: openrlabs
--

CREATE TABLE public.auth_permission (
    id integer NOT NULL,
    group_id integer,
    name character varying(512),
    table_name character varying(512),
    record_id integer
);


ALTER TABLE public.auth_permission OWNER TO openrlabs;

--
-- Name: auth_permission_id_seq; Type: SEQUENCE; Schema: public; Owner: openrlabs
--

CREATE SEQUENCE public.auth_permission_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.auth_permission_id_seq OWNER TO openrlabs;

--
-- Name: auth_permission_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: openrlabs
--

ALTER SEQUENCE public.auth_permission_id_seq OWNED BY public.auth_permission.id;


--
-- Name: auth_user; Type: TABLE; Schema: public; Owner: openrlabs
--

CREATE TABLE public.auth_user (
    id integer NOT NULL,
    first_name character varying(128),
    last_name character varying(128),
    email character varying(512),
    password character varying(512),
    registration_key character varying(512),
    reset_password_key character varying(512),
    registration_id character varying(512),
    username character varying(128)
);


ALTER TABLE public.auth_user OWNER TO openrlabs;

--
-- Name: auth_user_id_seq; Type: SEQUENCE; Schema: public; Owner: openrlabs
--

CREATE SEQUENCE public.auth_user_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.auth_user_id_seq OWNER TO openrlabs;

--
-- Name: auth_user_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: openrlabs
--

ALTER SEQUENCE public.auth_user_id_seq OWNED BY public.auth_user.id;


--
-- Name: labs_timetable; Type: TABLE; Schema: public; Owner: openrlabs
--

CREATE TABLE public.labs_timetable (
    id integer NOT NULL,
    lab_id integer NOT NULL,
    lab_name character varying(512) NOT NULL,
    "Init_Day" integer NOT NULL,
    "End_Day" integer NOT NULL,
    "Init_time" time without time zone NOT NULL,
    "End_time" time without time zone NOT NULL,
    cod_asign character varying
);


ALTER TABLE public.labs_timetable OWNER TO openrlabs;

--
-- Name: labs_timetable_id_seq; Type: SEQUENCE; Schema: public; Owner: openrlabs
--

CREATE SEQUENCE public.labs_timetable_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.labs_timetable_id_seq OWNER TO openrlabs;

--
-- Name: labs_timetable_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: openrlabs
--

ALTER SEQUENCE public.labs_timetable_id_seq OWNED BY public.labs_timetable.id;


--
-- Name: nip_groups; Type: TABLE; Schema: public; Owner: openrlabs
--

CREATE TABLE public.nip_groups (
    id integer NOT NULL,
    nip character varying(128) NOT NULL,
    groups text NOT NULL
);


ALTER TABLE public.nip_groups OWNER TO openrlabs;

--
-- Name: nip_groups_id_seq; Type: SEQUENCE; Schema: public; Owner: openrlabs
--

CREATE SEQUENCE public.nip_groups_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.nip_groups_id_seq OWNER TO openrlabs;

--
-- Name: nip_groups_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: openrlabs
--

ALTER SEQUENCE public.nip_groups_id_seq OWNED BY public.nip_groups.id;


--
-- Name: openRLabs_setup; Type: TABLE; Schema: public; Owner: openrlabs
--

CREATE TABLE public."openRLabs_setup" (
    id integer NOT NULL,
    "URL_Apache_Guacamole_WebSocket" character varying(512),
    "URL_openGnsys_server" character varying(512),
    "URL_openRLabs_server" character varying(512),
    maxtime_reserve character varying(512),
    seconds_to_wait integer DEFAULT 200 NOT NULL,
    auth_mode character varying(512)
);


ALTER TABLE public."openRLabs_setup" OWNER TO openrlabs;

--
-- Name: openRLabs_setup_id_seq; Type: SEQUENCE; Schema: public; Owner: openrlabs
--

CREATE SEQUENCE public."openRLabs_setup_id_seq"
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public."openRLabs_setup_id_seq" OWNER TO openrlabs;

--
-- Name: openRLabs_setup_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: openrlabs
--

ALTER SEQUENCE public."openRLabs_setup_id_seq" OWNED BY public."openRLabs_setup".id;


--
-- Name: ous_setup; Type: TABLE; Schema: public; Owner: openrlabs
--

CREATE TABLE public.ous_setup (
    id integer NOT NULL,
    ou_id character varying(512),
    ou_name character varying(512),
    ou_user character varying(512),
    ou_password character varying(512)
);


ALTER TABLE public.ous_setup OWNER TO openrlabs;

--
-- Name: ous_setup_id_seq; Type: SEQUENCE; Schema: public; Owner: openrlabs
--

CREATE SEQUENCE public.ous_setup_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.ous_setup_id_seq OWNER TO openrlabs;

--
-- Name: ous_setup_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: openrlabs
--

ALTER SEQUENCE public.ous_setup_id_seq OWNED BY public.ous_setup.id;


--
-- Name: pop3_servers; Type: TABLE; Schema: public; Owner: openrlabs
--

CREATE TABLE public.pop3_servers (
    id integer NOT NULL,
    url character varying(512),
    port integer NOT NULL,
    use_tls boolean DEFAULT true NOT NULL,
    default_server boolean DEFAULT false NOT NULL
);


ALTER TABLE public.pop3_servers OWNER TO openrlabs;

--
-- Name: pop3_servers_id_seq; Type: SEQUENCE; Schema: public; Owner: openrlabs
--

CREATE SEQUENCE public.pop3_servers_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.pop3_servers_id_seq OWNER TO openrlabs;

--
-- Name: pop3_servers_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: openrlabs
--

ALTER SEQUENCE public.pop3_servers_id_seq OWNED BY public.pop3_servers.id;


--
-- Name: pre_reserves; Type: TABLE; Schema: public; Owner: openrlabs
--

CREATE TABLE public.pre_reserves (
    id integer NOT NULL,
    lab_id integer NOT NULL,
    lab_name character varying(518) NOT NULL,
    init_time timestamp without time zone NOT NULL,
    finish_time timestamp without time zone NOT NULL,
    num_reserves integer DEFAULT 1 NOT NULL,
    ou_id character varying NOT NULL,
    image_id character varying NOT NULL,
    image_name character varying NOT NULL,
    protocol character varying,
    last_check_time timestamp without time zone
);


ALTER TABLE public.pre_reserves OWNER TO openrlabs;

--
-- Name: pre_reserves_id_seq; Type: SEQUENCE; Schema: public; Owner: openrlabs
--

CREATE SEQUENCE public.pre_reserves_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.pre_reserves_id_seq OWNER TO openrlabs;

--
-- Name: pre_reserves_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: openrlabs
--

ALTER SEQUENCE public.pre_reserves_id_seq OWNED BY public.pre_reserves.id;


--
-- Name: services; Type: TABLE; Schema: public; Owner: openrlabs
--

CREATE TABLE public.services (
    id integer NOT NULL,
    name character varying(512),
    port character varying(512)
);


ALTER TABLE public.services OWNER TO openrlabs;

--
-- Name: services_id_seq; Type: SEQUENCE; Schema: public; Owner: openrlabs
--

CREATE SEQUENCE public.services_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.services_id_seq OWNER TO openrlabs;

--
-- Name: services_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: openrlabs
--

ALTER SEQUENCE public.services_id_seq OWNED BY public.services.id;


--
-- Name: active_directory id; Type: DEFAULT; Schema: public; Owner: openrlabs
--

ALTER TABLE ONLY public.active_directory ALTER COLUMN id SET DEFAULT nextval('public.active_directory_id_seq'::regclass);


--
-- Name: auth_cas id; Type: DEFAULT; Schema: public; Owner: openrlabs
--

ALTER TABLE ONLY public.auth_cas ALTER COLUMN id SET DEFAULT nextval('public.auth_cas_id_seq'::regclass);


--
-- Name: auth_event id; Type: DEFAULT; Schema: public; Owner: openrlabs
--

ALTER TABLE ONLY public.auth_event ALTER COLUMN id SET DEFAULT nextval('public.auth_event_id_seq'::regclass);


--
-- Name: auth_group id; Type: DEFAULT; Schema: public; Owner: openrlabs
--

ALTER TABLE ONLY public.auth_group ALTER COLUMN id SET DEFAULT nextval('public.auth_group_id_seq'::regclass);


--
-- Name: auth_membership id; Type: DEFAULT; Schema: public; Owner: openrlabs
--

ALTER TABLE ONLY public.auth_membership ALTER COLUMN id SET DEFAULT nextval('public.auth_membership_id_seq'::regclass);


--
-- Name: auth_permission id; Type: DEFAULT; Schema: public; Owner: openrlabs
--

ALTER TABLE ONLY public.auth_permission ALTER COLUMN id SET DEFAULT nextval('public.auth_permission_id_seq'::regclass);


--
-- Name: auth_user id; Type: DEFAULT; Schema: public; Owner: openrlabs
--

ALTER TABLE ONLY public.auth_user ALTER COLUMN id SET DEFAULT nextval('public.auth_user_id_seq'::regclass);


--
-- Name: labs_timetable id; Type: DEFAULT; Schema: public; Owner: openrlabs
--

ALTER TABLE ONLY public.labs_timetable ALTER COLUMN id SET DEFAULT nextval('public.labs_timetable_id_seq'::regclass);


--
-- Name: nip_groups id; Type: DEFAULT; Schema: public; Owner: openrlabs
--

ALTER TABLE ONLY public.nip_groups ALTER COLUMN id SET DEFAULT nextval('public.nip_groups_id_seq'::regclass);


--
-- Name: openRLabs_setup id; Type: DEFAULT; Schema: public; Owner: openrlabs
--

ALTER TABLE ONLY public."openRLabs_setup" ALTER COLUMN id SET DEFAULT nextval('public."openRLabs_setup_id_seq"'::regclass);


--
-- Name: ous_setup id; Type: DEFAULT; Schema: public; Owner: openrlabs
--

ALTER TABLE ONLY public.ous_setup ALTER COLUMN id SET DEFAULT nextval('public.ous_setup_id_seq'::regclass);


--
-- Name: pop3_servers id; Type: DEFAULT; Schema: public; Owner: openrlabs
--

ALTER TABLE ONLY public.pop3_servers ALTER COLUMN id SET DEFAULT nextval('public.pop3_servers_id_seq'::regclass);


--
-- Name: pre_reserves id; Type: DEFAULT; Schema: public; Owner: openrlabs
--

ALTER TABLE ONLY public.pre_reserves ALTER COLUMN id SET DEFAULT nextval('public.pre_reserves_id_seq'::regclass);


--
-- Name: reserves id; Type: DEFAULT; Schema: public; Owner: openrlabs
--

ALTER TABLE ONLY public.reserves ALTER COLUMN id SET DEFAULT nextval('public.active_reserves_id_seq'::regclass);


--
-- Name: services id; Type: DEFAULT; Schema: public; Owner: openrlabs
--

ALTER TABLE ONLY public.services ALTER COLUMN id SET DEFAULT nextval('public.services_id_seq'::regclass);


--
-- Name: active_directory active_directory_pkey; Type: CONSTRAINT; Schema: public; Owner: openrlabs
--

ALTER TABLE ONLY public.active_directory
    ADD CONSTRAINT active_directory_pkey PRIMARY KEY (id);


--
-- Name: reserves active_reserves_pkey; Type: CONSTRAINT; Schema: public; Owner: openrlabs
--

ALTER TABLE ONLY public.reserves
    ADD CONSTRAINT active_reserves_pkey PRIMARY KEY (id);


--
-- Name: auth_cas auth_cas_pkey; Type: CONSTRAINT; Schema: public; Owner: openrlabs
--

ALTER TABLE ONLY public.auth_cas
    ADD CONSTRAINT auth_cas_pkey PRIMARY KEY (id);


--
-- Name: auth_event auth_event_pkey; Type: CONSTRAINT; Schema: public; Owner: openrlabs
--

ALTER TABLE ONLY public.auth_event
    ADD CONSTRAINT auth_event_pkey PRIMARY KEY (id);


--
-- Name: auth_group auth_group_pkey; Type: CONSTRAINT; Schema: public; Owner: openrlabs
--

ALTER TABLE ONLY public.auth_group
    ADD CONSTRAINT auth_group_pkey PRIMARY KEY (id);


--
-- Name: auth_membership auth_membership_pkey; Type: CONSTRAINT; Schema: public; Owner: openrlabs
--

ALTER TABLE ONLY public.auth_membership
    ADD CONSTRAINT auth_membership_pkey PRIMARY KEY (id);


--
-- Name: auth_permission auth_permission_pkey; Type: CONSTRAINT; Schema: public; Owner: openrlabs
--

ALTER TABLE ONLY public.auth_permission
    ADD CONSTRAINT auth_permission_pkey PRIMARY KEY (id);


--
-- Name: auth_user auth_user_pkey; Type: CONSTRAINT; Schema: public; Owner: openrlabs
--

ALTER TABLE ONLY public.auth_user
    ADD CONSTRAINT auth_user_pkey PRIMARY KEY (id);


--
-- Name: labs_timetable labs_timetable_pkey; Type: CONSTRAINT; Schema: public; Owner: openrlabs
--

ALTER TABLE ONLY public.labs_timetable
    ADD CONSTRAINT labs_timetable_pkey PRIMARY KEY (id);


--
-- Name: nip_groups nip_groups_nip_unique; Type: CONSTRAINT; Schema: public; Owner: openrlabs
--

ALTER TABLE ONLY public.nip_groups
    ADD CONSTRAINT nip_groups_nip_unique UNIQUE (nip);


--
-- Name: nip_groups nip_groups_pkey; Type: CONSTRAINT; Schema: public; Owner: openrlabs
--

ALTER TABLE ONLY public.nip_groups
    ADD CONSTRAINT nip_groups_pkey PRIMARY KEY (id);


--
-- Name: openRLabs_setup openRLabs_setup_pkey; Type: CONSTRAINT; Schema: public; Owner: openrlabs
--

ALTER TABLE ONLY public."openRLabs_setup"
    ADD CONSTRAINT "openRLabs_setup_pkey" PRIMARY KEY (id);


--
-- Name: ous_setup ous_setup_ou_id_key; Type: CONSTRAINT; Schema: public; Owner: openrlabs
--

ALTER TABLE ONLY public.ous_setup
    ADD CONSTRAINT ous_setup_ou_id_key UNIQUE (ou_id);


--
-- Name: ous_setup ous_setup_ou_name_key; Type: CONSTRAINT; Schema: public; Owner: openrlabs
--

ALTER TABLE ONLY public.ous_setup
    ADD CONSTRAINT ous_setup_ou_name_key UNIQUE (ou_name);


--
-- Name: ous_setup ous_setup_pkey; Type: CONSTRAINT; Schema: public; Owner: openrlabs
--

ALTER TABLE ONLY public.ous_setup
    ADD CONSTRAINT ous_setup_pkey PRIMARY KEY (id);


--
-- Name: pop3_servers pop3_servers_pkey; Type: CONSTRAINT; Schema: public; Owner: openrlabs
--

ALTER TABLE ONLY public.pop3_servers
    ADD CONSTRAINT pop3_servers_pkey PRIMARY KEY (id);


--
-- Name: pre_reserves prereserves_pkey; Type: CONSTRAINT; Schema: public; Owner: openrlabs
--

ALTER TABLE ONLY public.pre_reserves
    ADD CONSTRAINT prereserves_pkey PRIMARY KEY (id);


--
-- Name: services services_name_key; Type: CONSTRAINT; Schema: public; Owner: openrlabs
--

ALTER TABLE ONLY public.services
    ADD CONSTRAINT services_name_key UNIQUE (name);


--
-- Name: services services_pkey; Type: CONSTRAINT; Schema: public; Owner: openrlabs
--

ALTER TABLE ONLY public.services
    ADD CONSTRAINT services_pkey PRIMARY KEY (id);


--
-- Name: services services_port_key; Type: CONSTRAINT; Schema: public; Owner: openrlabs
--

ALTER TABLE ONLY public.services
    ADD CONSTRAINT services_port_key UNIQUE (port);


--
-- Name: reserves active_reserves_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: openrlabs
--

ALTER TABLE ONLY public.reserves
    ADD CONSTRAINT active_reserves_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.auth_user(id) ON DELETE CASCADE;


--
-- Name: auth_cas auth_cas_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: openrlabs
--

ALTER TABLE ONLY public.auth_cas
    ADD CONSTRAINT auth_cas_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.auth_user(id) ON DELETE CASCADE;


--
-- Name: auth_event auth_event_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: openrlabs
--

ALTER TABLE ONLY public.auth_event
    ADD CONSTRAINT auth_event_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.auth_user(id) ON DELETE CASCADE;


--
-- Name: auth_membership auth_membership_group_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: openrlabs
--

ALTER TABLE ONLY public.auth_membership
    ADD CONSTRAINT auth_membership_group_id_fkey FOREIGN KEY (group_id) REFERENCES public.auth_group(id) ON DELETE CASCADE;


--
-- Name: auth_membership auth_membership_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: openrlabs
--

ALTER TABLE ONLY public.auth_membership
    ADD CONSTRAINT auth_membership_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.auth_user(id) ON DELETE CASCADE;


--
-- Name: auth_permission auth_permission_group_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: openrlabs
--

ALTER TABLE ONLY public.auth_permission
    ADD CONSTRAINT auth_permission_group_id_fkey FOREIGN KEY (group_id) REFERENCES public.auth_group(id) ON DELETE CASCADE;


--
-- Name: reserves reserves__prereserve_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: openrlabs
--

ALTER TABLE ONLY public.reserves
    ADD CONSTRAINT reserves__prereserve_id_fkey FOREIGN KEY (prereserve_id) REFERENCES public.pre_reserves(id) ON DELETE CASCADE;


--
-- PostgreSQL database dump complete
--