
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




