Mercurial > hg > LightPIT / file diff

--- a/setup/postgres/psql_create_tables.sql	Sat Nov 27 12:12:20 2021 +0100
+++ b/setup/postgres/psql_create_tables.sql	Sat Nov 27 13:03:57 2021 +0100
@@ -112,6 +112,7 @@
 (
     eventid serial primary key,
     issueid integer                  not null references lpit_issue (issueid) on delete cascade,
+    subject text                     not null,
     time    timestamp with time zone not null default now(),
     type    issue_history_event      not null
 );
@@ -122,7 +123,6 @@
     component         text,
     status            issue_status   not null,
     category          issue_category not null,
-    subject           text           not null,
     description       text,
     assignee          text,
     eta               date,