setup/postgres/psql_create_tables.sql

changeset 345
7a515768c481
parent 284
671c1c8fbf1c
--- a/setup/postgres/psql_create_tables.sql	Tue Jan 14 19:21:48 2025 +0100
+++ b/setup/postgres/psql_create_tables.sql	Tue Jan 14 20:12:25 2025 +0100
@@ -113,6 +113,7 @@
 (
     eventid serial primary key,
     issueid integer                  not null references lpit_issue (issueid) on delete cascade,
+    userid  integer                      null references lpit_user (userid) on delete set null,
     subject text                     not null,
     time    timestamp with time zone not null default now(),
     type    issue_history_event      not null

mercurial