doc/development/postgresql_vfs.sql

branch
webdav
changeset 306
e03737cea6e2
parent 283
25e5b771677d
child 317
09676b559091
--- 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
+);
+

mercurial