kantatesti.sql

ALTER TABLE poll DROP CONSTRAINT poll_pkey;
ALTER TABLE poll ADD PRIMARY KEY (id);


ALTER TABLE poll_answer DROP CONSTRAINT fk_poll_answer_possible_answer_id;
ALTER TABLE poll_answer DROP CONSTRAINT fk_poll_answer_event_id;
ALTER TABLE poll_answer DROP CONSTRAINT poll_answer_pkey;
ALTER TABLE poll_answer DROP COLUMN event_id;
ALTER TABLE poll_answer ADD PRIMARY KEY (id);


ALTER TABLE possible_answer DROP CONSTRAINT fk_possible_answer_question_id;
ALTER TABLE possible_answer DROP CONSTRAINT fk_possible_answer_event_id;
ALTER TABLE possible_answer DROP CONSTRAINT possible_answer_pkey;
ALTER TABLE possible_answer DROP COLUMN event_id;
ALTER TABLE possible_answer ADD PRIMARY KEY (id);



ALTER TABLE poll_question DROP CONSTRAINT fk_poll_question_poll_id;
ALTER TABLE poll_question DROP CONSTRAINT fk_poll_question_event_id;
ALTER TABLE poll_question DROP CONSTRAINT poll_question_pkey;
ALTER TABLE poll_question DROP COLUMN event_id;
ALTER TABLE poll_question ADD PRIMARY KEY (id);



ALTER TABLE poll DROP CONSTRAINT poll_pkey;
ALTER TABLE poll ADD PRIMARY KEY (id);