doc/development/postgresql_vfs.sql

branch
webdav
changeset 278
38bf7b42b58c
child 281
e9dc53661df4
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/doc/development/postgresql_vfs.sql	Sun Jan 30 15:25:29 2022 +0100
@@ -0,0 +1,9 @@
+
+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),
+    
+    unique(parent_id, nodename)
+);

mercurial