scipostv1db_20151128.sql

--
-- PostgreSQL database dump
--

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

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

--
-- Name: auth_group; Type: TABLE; Schema: public; Owner: scipostv1db; Tablespace: 
--

CREATE TABLE auth_group (
    id integer NOT NULL,
    name character varying(80) NOT NULL
);


ALTER TABLE auth_group OWNER TO scipostv1db;

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

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


ALTER TABLE auth_group_id_seq OWNER TO scipostv1db;

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

ALTER SEQUENCE auth_group_id_seq OWNED BY auth_group.id;


--
-- Name: auth_group_permissions; Type: TABLE; Schema: public; Owner: scipostv1db; Tablespace: 
--

CREATE TABLE auth_group_permissions (
    id integer NOT NULL,
    group_id integer NOT NULL,
    permission_id integer NOT NULL
);


ALTER TABLE auth_group_permissions OWNER TO scipostv1db;

--
-- Name: auth_group_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: scipostv1db
--

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


ALTER TABLE auth_group_permissions_id_seq OWNER TO scipostv1db;

--
-- Name: auth_group_permissions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: scipostv1db
--

ALTER SEQUENCE auth_group_permissions_id_seq OWNED BY auth_group_permissions.id;


--
-- Name: auth_permission; Type: TABLE; Schema: public; Owner: scipostv1db; Tablespace: 
--

CREATE TABLE auth_permission (
    id integer NOT NULL,
    name character varying(255) NOT NULL,
    content_type_id integer NOT NULL,
    codename character varying(100) NOT NULL
);


ALTER TABLE auth_permission OWNER TO scipostv1db;

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

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


ALTER TABLE auth_permission_id_seq OWNER TO scipostv1db;

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

ALTER SEQUENCE auth_permission_id_seq OWNED BY auth_permission.id;


--
-- Name: auth_user; Type: TABLE; Schema: public; Owner: scipostv1db; Tablespace: 
--

CREATE TABLE auth_user (
    id integer NOT NULL,
    password character varying(128) NOT NULL,
    last_login timestamp with time zone,
    is_superuser boolean NOT NULL,
    username character varying(30) NOT NULL,
    first_name character varying(30) NOT NULL,
    last_name character varying(30) NOT NULL,
    email character varying(254) NOT NULL,
    is_staff boolean NOT NULL,
    is_active boolean NOT NULL,
    date_joined timestamp with time zone NOT NULL
);


ALTER TABLE auth_user OWNER TO scipostv1db;

--
-- Name: auth_user_groups; Type: TABLE; Schema: public; Owner: scipostv1db; Tablespace: 
--

CREATE TABLE auth_user_groups (
    id integer NOT NULL,
    user_id integer NOT NULL,
    group_id integer NOT NULL
);


ALTER TABLE auth_user_groups OWNER TO scipostv1db;

--
-- Name: auth_user_groups_id_seq; Type: SEQUENCE; Schema: public; Owner: scipostv1db
--

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


ALTER TABLE auth_user_groups_id_seq OWNER TO scipostv1db;

--
-- Name: auth_user_groups_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: scipostv1db
--

ALTER SEQUENCE auth_user_groups_id_seq OWNED BY auth_user_groups.id;


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

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


ALTER TABLE auth_user_id_seq OWNER TO scipostv1db;

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

ALTER SEQUENCE auth_user_id_seq OWNED BY auth_user.id;


--
-- Name: auth_user_user_permissions; Type: TABLE; Schema: public; Owner: scipostv1db; Tablespace: 
--

CREATE TABLE auth_user_user_permissions (
    id integer NOT NULL,
    user_id integer NOT NULL,
    permission_id integer NOT NULL
);


ALTER TABLE auth_user_user_permissions OWNER TO scipostv1db;

--
-- Name: auth_user_user_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: scipostv1db
--

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


ALTER TABLE auth_user_user_permissions_id_seq OWNER TO scipostv1db;

--
-- Name: auth_user_user_permissions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: scipostv1db
--

ALTER SEQUENCE auth_user_user_permissions_id_seq OWNED BY auth_user_user_permissions.id;


--
-- Name: django_admin_log; Type: TABLE; Schema: public; Owner: scipostv1db; Tablespace: 
--

CREATE TABLE django_admin_log (
    id integer NOT NULL,
    action_time timestamp with time zone NOT NULL,
    object_id text,
    object_repr character varying(200) NOT NULL,
    action_flag smallint NOT NULL,
    change_message text NOT NULL,
    content_type_id integer,
    user_id integer NOT NULL,
    CONSTRAINT django_admin_log_action_flag_check CHECK ((action_flag >= 0))
);


ALTER TABLE django_admin_log OWNER TO scipostv1db;

--
-- Name: django_admin_log_id_seq; Type: SEQUENCE; Schema: public; Owner: scipostv1db
--

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


ALTER TABLE django_admin_log_id_seq OWNER TO scipostv1db;

--
-- Name: django_admin_log_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: scipostv1db
--

ALTER SEQUENCE django_admin_log_id_seq OWNED BY django_admin_log.id;


--
-- Name: django_content_type; Type: TABLE; Schema: public; Owner: scipostv1db; Tablespace: 
--

CREATE TABLE django_content_type (
    id integer NOT NULL,
    app_label character varying(100) NOT NULL,
    model character varying(100) NOT NULL
);


ALTER TABLE django_content_type OWNER TO scipostv1db;

--
-- Name: django_content_type_id_seq; Type: SEQUENCE; Schema: public; Owner: scipostv1db
--

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


ALTER TABLE django_content_type_id_seq OWNER TO scipostv1db;

--
-- Name: django_content_type_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: scipostv1db
--

ALTER SEQUENCE django_content_type_id_seq OWNED BY django_content_type.id;


--
-- Name: django_migrations; Type: TABLE; Schema: public; Owner: scipostv1db; Tablespace: 
--

CREATE TABLE django_migrations (
    id integer NOT NULL,
    app character varying(255) NOT NULL,
    name character varying(255) NOT NULL,
    applied timestamp with time zone NOT NULL
);


ALTER TABLE django_migrations OWNER TO scipostv1db;

--
-- Name: django_migrations_id_seq; Type: SEQUENCE; Schema: public; Owner: scipostv1db
--

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


ALTER TABLE django_migrations_id_seq OWNER TO scipostv1db;

--
-- Name: django_migrations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: scipostv1db
--

ALTER SEQUENCE django_migrations_id_seq OWNED BY django_migrations.id;


--
-- Name: django_session; Type: TABLE; Schema: public; Owner: scipostv1db; Tablespace: 
--

CREATE TABLE django_session (
    session_key character varying(40) NOT NULL,
    session_data text NOT NULL,
    expire_date timestamp with time zone NOT NULL
);


ALTER TABLE django_session OWNER TO scipostv1db;

--
-- Name: scipost_authorreply; Type: TABLE; Schema: public; Owner: scipostv1db; Tablespace: 
--

CREATE TABLE scipost_authorreply (
    id integer NOT NULL,
    status smallint NOT NULL,
    reply_text text NOT NULL,
    date_submitted timestamp with time zone NOT NULL,
    nr_ratings integer NOT NULL,
    clarity_rating numeric(3,0) NOT NULL,
    correctness_rating numeric(3,0) NOT NULL,
    usefulness_rating numeric(3,0) NOT NULL,
    author_id integer NOT NULL,
    commentary_id integer,
    in_reply_to_comment_id integer,
    in_reply_to_report_id integer,
    submission_id integer
);


ALTER TABLE scipost_authorreply OWNER TO scipostv1db;

--
-- Name: scipost_authorreply_id_seq; Type: SEQUENCE; Schema: public; Owner: scipostv1db
--

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


ALTER TABLE scipost_authorreply_id_seq OWNER TO scipostv1db;

--
-- Name: scipost_authorreply_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: scipostv1db
--

ALTER SEQUENCE scipost_authorreply_id_seq OWNED BY scipost_authorreply.id;


--
-- Name: scipost_authorreplyrating; Type: TABLE; Schema: public; Owner: scipostv1db; Tablespace: 
--

CREATE TABLE scipost_authorreplyrating (
    id integer NOT NULL,
    clarity smallint NOT NULL,
    correctness smallint NOT NULL,
    usefulness smallint NOT NULL,
    rater_id integer NOT NULL,
    reply_id integer NOT NULL,
    CONSTRAINT scipost_authorreplyrating_clarity_check CHECK ((clarity >= 0)),
    CONSTRAINT scipost_authorreplyrating_correctness_check CHECK ((correctness >= 0)),
    CONSTRAINT scipost_authorreplyrating_usefulness_check CHECK ((usefulness >= 0))
);


ALTER TABLE scipost_authorreplyrating OWNER TO scipostv1db;

--
-- Name: scipost_authorreplyrating_id_seq; Type: SEQUENCE; Schema: public; Owner: scipostv1db
--

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


ALTER TABLE scipost_authorreplyrating_id_seq OWNER TO scipostv1db;

--
-- Name: scipost_authorreplyrating_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: scipostv1db
--

ALTER SEQUENCE scipost_authorreplyrating_id_seq OWNED BY scipost_authorreplyrating.id;


--
-- Name: scipost_comment; Type: TABLE; Schema: public; Owner: scipostv1db; Tablespace: 
--

CREATE TABLE scipost_comment (
    id integer NOT NULL,
    status smallint NOT NULL,
    comment_text text NOT NULL,
    date_submitted timestamp with time zone NOT NULL,
    nr_ratings integer NOT NULL,
    clarity_rating numeric(3,0) NOT NULL,
    correctness_rating numeric(3,0) NOT NULL,
    usefulness_rating numeric(3,0) NOT NULL,
    author_id integer NOT NULL,
    commentary_id integer,
    in_reply_to_id integer,
    submission_id integer
);


ALTER TABLE scipost_comment OWNER TO scipostv1db;

--
-- Name: scipost_comment_id_seq; Type: SEQUENCE; Schema: public; Owner: scipostv1db
--

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


ALTER TABLE scipost_comment_id_seq OWNER TO scipostv1db;

--
-- Name: scipost_comment_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: scipostv1db
--

ALTER SEQUENCE scipost_comment_id_seq OWNED BY scipost_comment.id;


--
-- Name: scipost_commentary; Type: TABLE; Schema: public; Owner: scipostv1db; Tablespace: 
--

CREATE TABLE scipost_commentary (
    id integer NOT NULL,
    vetted boolean NOT NULL,
    type character varying(9) NOT NULL,
    open_for_commenting boolean NOT NULL,
    pub_title character varying(300) NOT NULL,
    arxiv_link character varying(200) NOT NULL,
    "pub_DOI_link" character varying(200) NOT NULL,
    author_list character varying(1000) NOT NULL,
    pub_date date NOT NULL,
    pub_abstract text NOT NULL,
    nr_ratings integer NOT NULL,
    clarity_rating numeric(3,0) NOT NULL,
    correctness_rating numeric(3,0) NOT NULL,
    usefulness_rating numeric(3,0) NOT NULL,
    latest_activity timestamp with time zone NOT NULL,
    vetted_by_id integer
);


ALTER TABLE scipost_commentary OWNER TO scipostv1db;

--
-- Name: scipost_commentary_id_seq; Type: SEQUENCE; Schema: public; Owner: scipostv1db
--

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


ALTER TABLE scipost_commentary_id_seq OWNER TO scipostv1db;

--
-- Name: scipost_commentary_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: scipostv1db
--

ALTER SEQUENCE scipost_commentary_id_seq OWNED BY scipost_commentary.id;


--
-- Name: scipost_commentaryrating; Type: TABLE; Schema: public; Owner: scipostv1db; Tablespace: 
--

CREATE TABLE scipost_commentaryrating (
    id integer NOT NULL,
    clarity smallint NOT NULL,
    correctness smallint NOT NULL,
    usefulness smallint NOT NULL,
    commentary_id integer NOT NULL,
    rater_id integer NOT NULL,
    CONSTRAINT scipost_commentaryrating_clarity_check CHECK ((clarity >= 0)),
    CONSTRAINT scipost_commentaryrating_correctness_check CHECK ((correctness >= 0)),
    CONSTRAINT scipost_commentaryrating_usefulness_check CHECK ((usefulness >= 0))
);


ALTER TABLE scipost_commentaryrating OWNER TO scipostv1db;

--
-- Name: scipost_commentaryrating_id_seq; Type: SEQUENCE; Schema: public; Owner: scipostv1db
--

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


ALTER TABLE scipost_commentaryrating_id_seq OWNER TO scipostv1db;

--
-- Name: scipost_commentaryrating_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: scipostv1db
--

ALTER SEQUENCE scipost_commentaryrating_id_seq OWNED BY scipost_commentaryrating.id;


--
-- Name: scipost_commentrating; Type: TABLE; Schema: public; Owner: scipostv1db; Tablespace: 
--

CREATE TABLE scipost_commentrating (
    id integer NOT NULL,
    clarity smallint NOT NULL,
    correctness smallint NOT NULL,
    usefulness smallint NOT NULL,
    comment_id integer NOT NULL,
    rater_id integer NOT NULL,
    CONSTRAINT scipost_commentrating_clarity_check CHECK ((clarity >= 0)),
    CONSTRAINT scipost_commentrating_correctness_check CHECK ((correctness >= 0)),
    CONSTRAINT scipost_commentrating_usefulness_check CHECK ((usefulness >= 0))
);


ALTER TABLE scipost_commentrating OWNER TO scipostv1db;

--
-- Name: scipost_commentrating_id_seq; Type: SEQUENCE; Schema: public; Owner: scipostv1db
--

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


ALTER TABLE scipost_commentrating_id_seq OWNER TO scipostv1db;

--
-- Name: scipost_commentrating_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: scipostv1db
--

ALTER SEQUENCE scipost_commentrating_id_seq OWNED BY scipost_commentrating.id;


--
-- Name: scipost_contributor; Type: TABLE; Schema: public; Owner: scipostv1db; Tablespace: 
--

CREATE TABLE scipost_contributor (
    id integer NOT NULL,
    rank smallint NOT NULL,
    title character varying(4) NOT NULL,
    orcid_id character varying(20),
    affiliation character varying(300) NOT NULL,
    address character varying(1000) NOT NULL,
    personalwebpage character varying(200) NOT NULL,
    nr_reports smallint NOT NULL,
    report_clarity_rating numeric(3,0) NOT NULL,
    report_correctness_rating numeric(3,0) NOT NULL,
    report_usefulness_rating numeric(3,0) NOT NULL,
    nr_comments smallint NOT NULL,
    comment_clarity_rating numeric(3,0) NOT NULL,
    comment_correctness_rating numeric(3,0) NOT NULL,
    comment_usefulness_rating numeric(3,0) NOT NULL,
    user_id integer NOT NULL,
    CONSTRAINT scipost_contributor_nr_comments_check CHECK ((nr_comments >= 0)),
    CONSTRAINT scipost_contributor_nr_reports_check CHECK ((nr_reports >= 0))
);


ALTER TABLE scipost_contributor OWNER TO scipostv1db;

--
-- Name: scipost_contributor_id_seq; Type: SEQUENCE; Schema: public; Owner: scipostv1db
--

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


ALTER TABLE scipost_contributor_id_seq OWNER TO scipostv1db;

--
-- Name: scipost_contributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: scipostv1db
--

ALTER SEQUENCE scipost_contributor_id_seq OWNED BY scipost_contributor.id;


--
-- Name: scipost_report; Type: TABLE; Schema: public; Owner: scipostv1db; Tablespace: 
--

CREATE TABLE scipost_report (
    id integer NOT NULL,
    status smallint NOT NULL,
    qualification smallint NOT NULL,
    strengths text NOT NULL,
    weaknesses text NOT NULL,
    report text NOT NULL,
    requested_changes text NOT NULL,
    recommendation smallint NOT NULL,
    date_invited timestamp with time zone,
    date_submitted timestamp with time zone NOT NULL,
    nr_ratings integer NOT NULL,
    clarity_rating numeric(3,0) NOT NULL,
    correctness_rating numeric(3,0) NOT NULL,
    usefulness_rating numeric(3,0) NOT NULL,
    author_id integer NOT NULL,
    invited_by_id integer,
    submission_id integer NOT NULL,
    CONSTRAINT scipost_report_qualification_check CHECK ((qualification >= 0))
);


ALTER TABLE scipost_report OWNER TO scipostv1db;

--
-- Name: scipost_report_id_seq; Type: SEQUENCE; Schema: public; Owner: scipostv1db
--

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


ALTER TABLE scipost_report_id_seq OWNER TO scipostv1db;

--
-- Name: scipost_report_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: scipostv1db
--

ALTER SEQUENCE scipost_report_id_seq OWNED BY scipost_report.id;


--
-- Name: scipost_reportrating; Type: TABLE; Schema: public; Owner: scipostv1db; Tablespace: 
--

CREATE TABLE scipost_reportrating (
    id integer NOT NULL,
    clarity smallint NOT NULL,
    correctness smallint NOT NULL,
    usefulness smallint NOT NULL,
    rater_id integer NOT NULL,
    report_id integer NOT NULL,
    CONSTRAINT scipost_reportrating_clarity_check CHECK ((clarity >= 0)),
    CONSTRAINT scipost_reportrating_correctness_check CHECK ((correctness >= 0)),
    CONSTRAINT scipost_reportrating_usefulness_check CHECK ((usefulness >= 0))
);


ALTER TABLE scipost_reportrating OWNER TO scipostv1db;

--
-- Name: scipost_reportrating_id_seq; Type: SEQUENCE; Schema: public; Owner: scipostv1db
--

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


ALTER TABLE scipost_reportrating_id_seq OWNER TO scipostv1db;

--
-- Name: scipost_reportrating_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: scipostv1db
--

ALTER SEQUENCE scipost_reportrating_id_seq OWNED BY scipost_reportrating.id;


--
-- Name: scipost_submission; Type: TABLE; Schema: public; Owner: scipostv1db; Tablespace: 
--

CREATE TABLE scipost_submission (
    id integer NOT NULL,
    vetted boolean NOT NULL,
    submitted_to_journal character varying(30) NOT NULL,
    domain character varying(1) NOT NULL,
    specialization character varying(1) NOT NULL,
    status smallint NOT NULL,
    open_for_reporting boolean NOT NULL,
    open_for_commenting boolean NOT NULL,
    title character varying(300) NOT NULL,
    author_list character varying(1000) NOT NULL,
    abstract text NOT NULL,
    arxiv_link character varying(200) NOT NULL,
    submission_date date NOT NULL,
    nr_ratings integer NOT NULL,
    clarity_rating numeric(3,0) NOT NULL,
    correctness_rating numeric(3,0) NOT NULL,
    usefulness_rating numeric(3,0) NOT NULL,
    latest_activity timestamp with time zone NOT NULL,
    editor_in_charge_id integer,
    submitted_by_id integer NOT NULL
);


ALTER TABLE scipost_submission OWNER TO scipostv1db;

--
-- Name: scipost_submission_id_seq; Type: SEQUENCE; Schema: public; Owner: scipostv1db
--

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


ALTER TABLE scipost_submission_id_seq OWNER TO scipostv1db;

--
-- Name: scipost_submission_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: scipostv1db
--

ALTER SEQUENCE scipost_submission_id_seq OWNED BY scipost_submission.id;


--
-- Name: scipost_submissionrating; Type: TABLE; Schema: public; Owner: scipostv1db; Tablespace: 
--

CREATE TABLE scipost_submissionrating (
    id integer NOT NULL,
    clarity smallint NOT NULL,
    correctness smallint NOT NULL,
    usefulness smallint NOT NULL,
    rater_id integer NOT NULL,
    submission_id integer NOT NULL,
    CONSTRAINT scipost_submissionrating_clarity_check CHECK ((clarity >= 0)),
    CONSTRAINT scipost_submissionrating_correctness_check CHECK ((correctness >= 0)),
    CONSTRAINT scipost_submissionrating_usefulness_check CHECK ((usefulness >= 0))
);


ALTER TABLE scipost_submissionrating OWNER TO scipostv1db;

--
-- Name: scipost_submissionrating_id_seq; Type: SEQUENCE; Schema: public; Owner: scipostv1db
--

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


ALTER TABLE scipost_submissionrating_id_seq OWNER TO scipostv1db;

--
-- Name: scipost_submissionrating_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: scipostv1db
--

ALTER SEQUENCE scipost_submissionrating_id_seq OWNED BY scipost_submissionrating.id;


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: scipostv1db
--

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


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: scipostv1db
--

ALTER TABLE ONLY auth_group_permissions ALTER COLUMN id SET DEFAULT nextval('auth_group_permissions_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: scipostv1db
--

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


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: scipostv1db
--

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


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: scipostv1db
--

ALTER TABLE ONLY auth_user_groups ALTER COLUMN id SET DEFAULT nextval('auth_user_groups_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: scipostv1db
--

ALTER TABLE ONLY auth_user_user_permissions ALTER COLUMN id SET DEFAULT nextval('auth_user_user_permissions_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: scipostv1db
--

ALTER TABLE ONLY django_admin_log ALTER COLUMN id SET DEFAULT nextval('django_admin_log_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: scipostv1db
--

ALTER TABLE ONLY django_content_type ALTER COLUMN id SET DEFAULT nextval('django_content_type_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: scipostv1db
--

ALTER TABLE ONLY django_migrations ALTER COLUMN id SET DEFAULT nextval('django_migrations_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: scipostv1db
--

ALTER TABLE ONLY scipost_authorreply ALTER COLUMN id SET DEFAULT nextval('scipost_authorreply_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: scipostv1db
--

ALTER TABLE ONLY scipost_authorreplyrating ALTER COLUMN id SET DEFAULT nextval('scipost_authorreplyrating_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: scipostv1db
--

ALTER TABLE ONLY scipost_comment ALTER COLUMN id SET DEFAULT nextval('scipost_comment_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: scipostv1db
--

ALTER TABLE ONLY scipost_commentary ALTER COLUMN id SET DEFAULT nextval('scipost_commentary_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: scipostv1db
--

ALTER TABLE ONLY scipost_commentaryrating ALTER COLUMN id SET DEFAULT nextval('scipost_commentaryrating_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: scipostv1db
--

ALTER TABLE ONLY scipost_commentrating ALTER COLUMN id SET DEFAULT nextval('scipost_commentrating_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: scipostv1db
--

ALTER TABLE ONLY scipost_contributor ALTER COLUMN id SET DEFAULT nextval('scipost_contributor_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: scipostv1db
--

ALTER TABLE ONLY scipost_report ALTER COLUMN id SET DEFAULT nextval('scipost_report_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: scipostv1db
--

ALTER TABLE ONLY scipost_reportrating ALTER COLUMN id SET DEFAULT nextval('scipost_reportrating_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: scipostv1db
--

ALTER TABLE ONLY scipost_submission ALTER COLUMN id SET DEFAULT nextval('scipost_submission_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: scipostv1db
--

ALTER TABLE ONLY scipost_submissionrating ALTER COLUMN id SET DEFAULT nextval('scipost_submissionrating_id_seq'::regclass);


--
-- Data for Name: auth_group; Type: TABLE DATA; Schema: public; Owner: scipostv1db
--

COPY auth_group (id, name) FROM stdin;
\.


--
-- Name: auth_group_id_seq; Type: SEQUENCE SET; Schema: public; Owner: scipostv1db
--