/**
 * @author sbarthon
 * @date 29/09/21
 * @version 1.0.0
 * @project SIEau
 * @table enquetes_questions
 */

# --- !Ups
ALTER TABLE enquetes_questions ADD COLUMN champSandre character varying(25);
ALTER TABLE enquetes_questions ADD COLUMN saisieCommentaire boolean;

CREATE TABLE enquetes_paragraphes_installations (
idEnquete bigint,
idParagraphe bigint,
typeInstallation bigint
);
CREATE TABLE enquetes_questions_installations (
idEnquete bigint,
idParagraphe bigint,
idQuestion bigint,
typeInstallation bigint
);

# --- !Downs

drop TABLE enquetes_questions_installations;
drop TABLE enquetes_paragraphes_installations ;
