#1484: V7.5.1.2__7.5.1.0-POLL.sql

Schema Changes

Table Alterations

SQL Content

-- Table with synchronize infos (Sipgate)

CREATE TABLE T_POLL
(
    pk                    INTEGER                 NOT NULL,
    deleted               BOOLEAN                 NOT NULL,
    created               TIMESTAMP WITHOUT TIME ZONE,
    last_update           TIMESTAMP WITHOUT TIME ZONE,
    title                 CHARACTER VARYING(1000) NOT NULL,
    description           CHARACTER VARYING(1000),
    location              CHARACTER VARYING(1000),
    owner_fk              INTEGER                 NOT NULL,
    deadline              DATE                    NOT NULL,
    state                 CHARACTER VARYING(1000) NOT NULL,
    attendeeIds           VARCHAR(5000),
    groupAttendeeIds      VARCHAR(5000),
    full_access_user_ids  CHARACTER VARYING(255),
    full_access_group_ids CHARACTER VARYING(255),
    inputFields           CHARACTER Varying(100000)
);

ALTER TABLE T_POLL
    ADD CONSTRAINT t_poll_pkey PRIMARY KEY (pk);
ALTER TABLE T_POLL
    ADD CONSTRAINT fk_t_poll_pf_user FOREIGN KEY (owner_fk) REFERENCES t_pf_user (pk);

CREATE TABLE T_POLL_RESPONSE
(
    pk          INTEGER NOT NULL,
    deleted     BOOLEAN NOT NULL,
    created     TIMESTAMP WITHOUT TIME ZONE,
    last_update TIMESTAMP WITHOUT TIME ZONE,
    poll_fk     INTEGER NOT NULL,
    owner_fk    INTEGER NOT NULL,
    responses   CHARACTER Varying(10000)
);

ALTER TABLE T_POLL_RESPONSE
    ADD CONSTRAINT t_poll_response_pkey PRIMARY KEY (pk);
ALTER TABLE T_POLL_RESPONSE
    ADD CONSTRAINT fk_t_poll_response_pf_user FOREIGN KEY (owner_fk) REFERENCES t_pf_user (pk);
ALTER TABLE T_POLL_RESPONSE
    ADD CONSTRAINT fk_t_poll_response_poll FOREIGN KEY (poll_fk) REFERENCES t_poll (pk);

Git History

a6383a950 remove Poll date
ac9c42c1e Merge branch 'fix/changeAllInputsToReadOnly' into fix/enterOnInputPressesButton
25185faa0 Add Attendee and Access filter. Remove "s" from attendeesIds and groupAttendeesIds.
cc14a9ef9 fix
2388c7092 Merge branch 'develop' into feature/antworten
2c9037a19 fixe some things(owner name load after add field)
c5df2c051 merge new dev into branch
13124e3f0 Merge dev into branch
be1f00a8f accessuser and accessgroup