diff -r a171da778817 -r 7dd45173f68a src/server/plugins/postgresql/test/postgresql_vfs.sql --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/src/server/plugins/postgresql/test/postgresql_vfs.sql Sat Apr 16 14:36:08 2022 +0200 @@ -0,0 +1,16 @@ + +create table Resource ( + resource_id serial primary key, + parent_id int references Resource(resource_id), + nodename text not null, + 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, + + resoid oid, + + unique(parent_id, nodename) +); +