diff -r 1d48b38ca349 -r 9365c7fb0240 setup/postgres/psql_create_tables.sql --- a/setup/postgres/psql_create_tables.sql Sun Oct 10 15:12:12 2021 +0200 +++ b/setup/postgres/psql_create_tables.sql Sat Nov 27 10:44:17 2021 +0100 @@ -118,16 +118,17 @@ create table lpit_issue_history_data ( - eventid integer not null references lpit_issue_history_event (eventid) on delete cascade, - component text, - status issue_status not null, - category issue_category not null, - subject text not null, - description text, - assignee text, - eta date, - affected text, - resolved text + eventid integer not null references lpit_issue_history_event (eventid) on delete cascade, + component text, + status issue_status not null, + category issue_category not null, + subject text not null, + description text, + assignee_username text, + assignee text, + eta date, + affected text, + resolved text ); create table lpit_issue_comment