DB Changes

DB Change log

For version 1.9.10, devel branch. Sorted by newest first.

1d3b4d8 (2017-02-01)

ALTER TABLE event_paper_reviewing.review_comments
        ADD COLUMN visibility smallint NOT NULL;

ALTER TABLE event_paper_reviewing.review_comments
        ADD CONSTRAINT ck_review_comments_valid_enum_visibility CHECK ((visibility = ANY (ARRAY[1, 2, 3, 4])));

8bf967b61 (2017-01-18)

ALTER TABLE event_paper_reviewing.revisions
    ADD COLUMN judge_id integer,
    ADD COLUMN judgment_dt timestamp without time zone;

ALTER TABLE event_paper_reviewing.revisions
    ADD CONSTRAINT ck_revisions_judge_if_judged CHECK (((state = ANY (ARRAY[2, 3, 4])) = (judge_id IS NOT NULL)));

ALTER TABLE event_paper_reviewing.revisions
    ADD CONSTRAINT ck_revisions_judgment_dt_if_judged CHECK (((state = ANY (ARRAY[2, 3, 4])) = (judgment_dt IS NOT NULL)));

ALTER TABLE event_paper_reviewing.revisions
    ADD CONSTRAINT fk_revisions_judge_id_users FOREIGN KEY (judge_id) REFERENCES users.users(id);

CREATE INDEX ix_revisions_judge_id ON event_paper_reviewing.revisions USING btree (judge_id);

e75fa78 (2017-01-11)

ALTER TABLE event_paper_reviewing.revisions ADD COLUMN judgment_comment text NOT NULL;

7a2b43d

ALTER TABLE event_paper_reviewing.templates ADD COLUMN description text NOT NULL;
ALTER TABLE event_paper_reviewing.templates ADD COLUMN name text NOT NULL;
ALTER TABLE event_paper_reviewing.review_questions ADD COLUMN type smallint NOT NULL;
ALTER TABLE event_paper_reviewing.review_questions ADD CONSTRAINT ck_review_questions_valid_enum_type CHECK ((type = ANY (ARRAY[1, 2])));