--- a/doc/development/postgresql_vfs.sql Thu Apr 21 17:16:49 2022 +0200 +++ b/doc/development/postgresql_vfs.sql Sun Apr 24 18:35:44 2022 +0200 @@ -14,3 +14,16 @@ unique(parent_id, nodename) ); +create table Property ( + property_id serial primary key, + resource_id int references Resource(resource_id) on delete cascade, + xmlns text not null, + pname text not null, + pvalue text +); + +create type property_name as ( + xmlns text, + name text +); +