Mercurial > hg > LightPIT / file diff

--- a/setup/postgres/psql_create_tables.sql	Sun Mar 09 17:17:59 2025 +0100
+++ b/setup/postgres/psql_create_tables.sql	Tue Mar 11 13:59:06 2025 +0100
@@ -186,9 +186,10 @@
 
 create table lpit_commit_ref
 (
-    issueid      integer not null references lpit_issue (issueid) on delete cascade,
-    commit_hash  text    not null,
-    commit_brief text    not null
+    issueid      integer                  not null references lpit_issue (issueid) on delete cascade,
+    commit_hash  text                     not null,
+    commit_brief text                     not null,
+    commit_time  timestamp with time zone null -- optional feature added with Lightpit 1.5.0
 );
 
 create unique index lpit_commit_ref_unique on lpit_commit_ref (issueid, commit_hash);