--
-- PostgreSQL database dump
--

-- Dumped from database version 9.2.4
-- Dumped by pg_dump version 9.2.4
-- Started on 2013-05-31 16:39:58

SET statement_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;

--
-- TOC entry 171 (class 3079 OID 11727)
-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: 
--

CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;


--
-- TOC entry 1941 (class 0 OID 0)
-- Dependencies: 171
-- 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;

--
-- TOC entry 168 (class 1259 OID 385031)
-- Name: label_probabilities; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE label_probabilities (
    mirna character varying NOT NULL,
    gene character varying NOT NULL,
    labelled_probability real,
    labelled_as_positive boolean,
    sample_name character varying NOT NULL,
    in_sample boolean
);


ALTER TABLE public.label_probabilities OWNER TO postgres;

--
-- TOC entry 169 (class 1259 OID 385037)
-- Name: positive_probabilities; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE positive_probabilities (
    mirna character varying NOT NULL,
    gene character varying NOT NULL,
    positive_probability real,
    labelled_as_positive boolean,
    sample_name character varying NOT NULL
);


ALTER TABLE public.positive_probabilities OWNER TO postgres;

--
-- TOC entry 170 (class 1259 OID 385043)
-- Name: positive_weights; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE positive_weights (
    mirna character varying NOT NULL,
    gene character varying NOT NULL,
    avg_labelled_weight real,
    positive_weight real,
    norm_positive_weight real
);


ALTER TABLE public.positive_weights OWNER TO postgres;

--
-- TOC entry 1942 (class 0 OID 0)
-- Dependencies: 170
-- Name: COLUMN positive_weights.avg_labelled_weight; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN positive_weights.avg_labelled_weight IS '
';


--
-- TOC entry 1931 (class 0 OID 385031)
-- Dependencies: 168
-- Data for Name: label_probabilities; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY label_probabilities (mirna, gene, labelled_probability, labelled_as_positive, sample_name, in_sample) FROM stdin;
\.


--
-- TOC entry 1932 (class 0 OID 385037)
-- Dependencies: 169
-- Data for Name: positive_probabilities; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY positive_probabilities (mirna, gene, positive_probability, labelled_as_positive, sample_name) FROM stdin;
\.


--
-- TOC entry 1933 (class 0 OID 385043)
-- Dependencies: 170
-- Data for Name: positive_weights; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY positive_weights (mirna, gene, avg_labelled_weight, positive_weight, norm_positive_weight) FROM stdin;
\.


--
-- TOC entry 1926 (class 2606 OID 385050)
-- Name: pk_classification; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY label_probabilities
    ADD CONSTRAINT pk_classification PRIMARY KEY (mirna, gene, sample_name);


--
-- TOC entry 1928 (class 2606 OID 385054)
-- Name: pk_positive_probabilities; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY positive_probabilities
    ADD CONSTRAINT pk_positive_probabilities PRIMARY KEY (mirna, gene, sample_name);


--
-- TOC entry 1930 (class 2606 OID 385056)
-- Name: pk_weights; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY positive_weights
    ADD CONSTRAINT pk_weights PRIMARY KEY (mirna, gene);


--
-- TOC entry 1940 (class 0 OID 0)
-- Dependencies: 6
-- 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;


-- Completed on 2013-05-31 16:39:58

--
-- PostgreSQL database dump complete
--

