setup/postgres/psql_create_tables.sql

changeset 367
0a9065936aac
parent 360
f60ecdc0431f
--- a/setup/postgres/psql_create_tables.sql	Fri Mar 14 08:09:05 2025 +0100
+++ b/setup/postgres/psql_create_tables.sql	Sat May 17 17:39:48 2025 +0200
@@ -1,10 +1,11 @@
 create table lpit_user
 (
-    userid    serial primary key,
-    username  text not null unique,
-    mail      text,
-    lastname  text,
-    givenname text
+    userid              serial primary key,
+    username            text                     not null unique,
+    mail                text,
+    lastname            text,
+    givenname           text,
+    knows_updates_until timestamp with time zone
 );
 
 create type vcstype as enum ('None', 'Mercurial', 'Git');

mercurial