diff -r d0d5a970292f -r e9dc53661df4 doc/development/postgresql_vfs.sql --- 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) ); +