--
--



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





--
-- Name: app_configuration; Type: TABLE; Schema: public; Owner: gazelle
--

CREATE TABLE app_configuration (
    id integer NOT NULL,
    value character varying(255),
    variable character varying(255)
);


ALTER TABLE app_configuration OWNER TO gazelle;

--
-- Name: app_configuration_id_seq; Type: SEQUENCE; Schema: public; Owner: gazelle
--

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


ALTER TABLE app_configuration_id_seq OWNER TO gazelle;

--
-- Name: cmn_home; Type: TABLE; Schema: public; Owner: gazelle
--

CREATE TABLE cmn_home (
    id integer NOT NULL,
    home_title character varying(255),
    iso3_language character varying(255),
    main_content text
);


ALTER TABLE cmn_home OWNER TO gazelle;

--
-- Name: cmn_home_id_seq; Type: SEQUENCE; Schema: public; Owner: gazelle
--

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


ALTER TABLE cmn_home_id_seq OWNER TO gazelle;

--
-- Name: daffodil_transformation_dfdl_file; Type: TABLE; Schema: public; Owner: gazelle
--

CREATE TABLE daffodil_transformation_dfdl_file (
    id integer NOT NULL,
    last_changed timestamp without time zone,
    last_modifier_id character varying(255),
    author character varying(255) NOT NULL,
    available boolean,
    description character varying(255),
    label character varying(255),
    name character varying(255) NOT NULL,
    path character varying(255),
    version character varying(255) NOT NULL,
    object_type_id integer
);


ALTER TABLE daffodil_transformation_dfdl_file OWNER TO gazelle;

--
-- Name: daffodil_transformation_dfdl_file_id_seq; Type: SEQUENCE; Schema: public; Owner: gazelle
--

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


ALTER TABLE daffodil_transformation_dfdl_file_id_seq OWNER TO gazelle;

--
-- Name: daffodil_transformation_object_type; Type: TABLE; Schema: public; Owner: gazelle
--

CREATE TABLE daffodil_transformation_object_type (
    id integer NOT NULL,
    last_changed timestamp without time zone,
    last_modifier_id character varying(255),
    description character varying(255),
    keyword character varying(255),
    label_to_display character varying(255)
);


ALTER TABLE daffodil_transformation_object_type OWNER TO gazelle;

--
-- Name: daffodil_transformation_object_type_id_seq; Type: SEQUENCE; Schema: public; Owner: gazelle
--

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


ALTER TABLE daffodil_transformation_object_type_id_seq OWNER TO gazelle;

--
-- Name: app_configuration_pkey; Type: CONSTRAINT; Schema: public; Owner: gazelle
--

ALTER TABLE ONLY app_configuration
    ADD CONSTRAINT app_configuration_pkey PRIMARY KEY (id);


--
-- Name: cmn_home_pkey; Type: CONSTRAINT; Schema: public; Owner: gazelle
--

ALTER TABLE ONLY cmn_home
    ADD CONSTRAINT cmn_home_pkey PRIMARY KEY (id);


--
-- Name: daffodil_transformation_dfdl_file_pkey; Type: CONSTRAINT; Schema: public; Owner: gazelle
--

ALTER TABLE ONLY daffodil_transformation_dfdl_file
    ADD CONSTRAINT daffodil_transformation_dfdl_file_pkey PRIMARY KEY (id);


--
-- Name: daffodil_transformation_object_type_pkey; Type: CONSTRAINT; Schema: public; Owner: gazelle
--

ALTER TABLE ONLY daffodil_transformation_object_type
    ADD CONSTRAINT daffodil_transformation_object_type_pkey PRIMARY KEY (id);


--
-- Name: uk_lo5cslngngyp0fophmgbvwrdp; Type: CONSTRAINT; Schema: public; Owner: gazelle
--

ALTER TABLE ONLY daffodil_transformation_dfdl_file
    ADD CONSTRAINT uk_lo5cslngngyp0fophmgbvwrdp UNIQUE (label);


--
-- Name: uk_mv2quil5gwcd8bxyc76v4vyy1; Type: CONSTRAINT; Schema: public; Owner: gazelle
--

ALTER TABLE ONLY cmn_home
    ADD CONSTRAINT uk_mv2quil5gwcd8bxyc76v4vyy1 UNIQUE (iso3_language);


--
-- Name: uk_ohkbj3qngl9vkufma34rkn81u; Type: CONSTRAINT; Schema: public; Owner: gazelle
--

ALTER TABLE ONLY daffodil_transformation_object_type
    ADD CONSTRAINT uk_ohkbj3qngl9vkufma34rkn81u UNIQUE (keyword);


--
-- Name: fk_gp55c8vvytvgmhc5abu73rkdg; Type: FK CONSTRAINT; Schema: public; Owner: gazelle
--

ALTER TABLE ONLY daffodil_transformation_dfdl_file
    ADD CONSTRAINT fk_gp55c8vvytvgmhc5abu73rkdg FOREIGN KEY (object_type_id) REFERENCES daffodil_transformation_object_type(id);


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

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


--
--

