#
# fe_comment v2 (2026-10-02): server-side feedback with FE-user ownership.
# A summary is one visitor's note pad (open until submitted); feedback rows
# are its items. Written from the FRONTEND via plain inserts (no DataHandler
# available there) - TCA exists for backend read/edit access.
#
CREATE TABLE tx_fecomment_summary (
    fe_user int(11) DEFAULT '0' NOT NULL,
    status varchar(10) DEFAULT 'open' NOT NULL,
    general_notes text,
    recipients varchar(1024) DEFAULT '' NOT NULL,
    sent_at int(11) DEFAULT '0' NOT NULL,
    KEY feuser (fe_user, status)
);

CREATE TABLE tx_fecomment_feedback (
    summary int(11) DEFAULT '0' NOT NULL,
    fe_user int(11) DEFAULT '0' NOT NULL,
    url varchar(2048) DEFAULT '' NOT NULL,
    note mediumtext,
    attachments int(11) DEFAULT '0' NOT NULL,
    sorting int(11) DEFAULT '0' NOT NULL,
    KEY summary (summary)
);