Mercurial > hg > webserver / file diff

--- a/doc/development/postgresql_vfs.sql	Mon Jan 31 21:33:46 2022 +0100
+++ b/doc/development/postgresql_vfs.sql	Tue Feb 01 17:47:50 2022 +0100
@@ -3,7 +3,12 @@
     resource_id       serial    primary key,
     parent_id         int       references Resource(resource_id),
     nodename          text      not null,
-    iscollection      boolean   not null default(false),
+    iscollection      boolean   not null default false,
+	
+    lastmodified      timestamp not null default current_date,
+    creationdate      timestamp not null default current_date,
+    contentlength     bigint    not null default 0,
     
     unique(parent_id, nodename)
 );
+