diff.sql

SET search_path = event_paper_reviewing, pg_catalog;

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

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

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

CREATE TABLE paper_review_questions (
	is_deleted boolean NOT NULL,
	event_id integer NOT NULL,
	text text NOT NULL,
	no_score boolean NOT NULL,
	"position" integer NOT NULL,
	id integer DEFAULT nextval('paper_review_questions_id_seq'::regclass) NOT NULL
);

CREATE TABLE paper_review_ratings (
	"value" integer NOT NULL,
	question_id integer NOT NULL,
	id integer DEFAULT nextval('paper_review_ratings_id_seq'::regclass) NOT NULL,
	review_id integer NOT NULL
);

CREATE TABLE paper_reviews (
	id integer DEFAULT nextval('paper_reviews_id_seq'::regclass) NOT NULL,
	revision_id integer NOT NULL,
	user_id integer NOT NULL,
	created_dt timestamp without time zone NOT NULL,
	modified_dt timestamp without time zone,
	comment text NOT NULL,
	type smallint NOT NULL,
	proposed_action smallint NOT NULL
);

ALTER SEQUENCE paper_review_questions_id_seq
	OWNED BY paper_review_questions.id;

ALTER SEQUENCE paper_review_ratings_id_seq
	OWNED BY paper_review_ratings.id;

ALTER SEQUENCE paper_reviews_id_seq
	OWNED BY paper_reviews.id;

ALTER TABLE paper_review_questions
	ADD CONSTRAINT pk_paper_review_questions PRIMARY KEY (id);

ALTER TABLE paper_review_ratings
	ADD CONSTRAINT pk_paper_review_ratings PRIMARY KEY (id);

ALTER TABLE paper_reviews
	ADD CONSTRAINT pk_paper_reviews PRIMARY KEY (id);

ALTER TABLE paper_review_questions
	ADD CONSTRAINT fk_paper_review_questions_event_id_events FOREIGN KEY (event_id) REFERENCES events.events(id);

ALTER TABLE paper_review_ratings
	ADD CONSTRAINT uq_paper_review_ratings_review_id_question_id UNIQUE (review_id, question_id);

ALTER TABLE paper_review_ratings
	ADD CONSTRAINT fk_paper_review_ratings_question_id_paper_review_questions FOREIGN KEY (question_id) REFERENCES paper_review_questions(id);

ALTER TABLE paper_review_ratings
	ADD CONSTRAINT fk_paper_review_ratings_review_id_paper_reviews FOREIGN KEY (review_id) REFERENCES paper_reviews(id);

ALTER TABLE paper_reviews
	ADD CONSTRAINT ck_paper_reviews_valid_enum_proposed_action CHECK ((proposed_action = ANY (ARRAY[1, 2, 3])));

ALTER TABLE paper_reviews
	ADD CONSTRAINT ck_paper_reviews_valid_enum_type CHECK ((type = ANY (ARRAY[1, 2])));

ALTER TABLE paper_reviews
	ADD CONSTRAINT uq_paper_reviews_revision_id_user_id_type UNIQUE (revision_id, user_id, type);

ALTER TABLE paper_reviews
	ADD CONSTRAINT fk_paper_reviews_revision_id_revisions FOREIGN KEY (revision_id) REFERENCES revisions(id);

ALTER TABLE paper_reviews
	ADD CONSTRAINT fk_paper_reviews_user_id_users FOREIGN KEY (user_id) REFERENCES users.users(id);

CREATE INDEX ix_paper_review_questions_event_id ON paper_review_questions USING btree (event_id);

CREATE INDEX ix_paper_review_ratings_question_id ON paper_review_ratings USING btree (question_id);

CREATE INDEX ix_paper_review_ratings_review_id ON paper_review_ratings USING btree (review_id);

CREATE INDEX ix_paper_reviews_revision_id ON paper_reviews USING btree (revision_id);

CREATE INDEX ix_paper_reviews_user_id ON paper_reviews USING btree (user_id);