doc/development/postgresql_vfs.sql

Mon, 31 Jan 2022 21:33:46 +0100

author
Olaf Wintermann <olaf.wintermann@gmail.com>
date
Mon, 31 Jan 2022 21:33:46 +0100
branch
webdav
changeset 280
d0d5a970292f
parent 278
38bf7b42b58c
child 281
e9dc53661df4
permissions
-rw-r--r--

implement pg_vfs_dirio_close

278
38bf7b42b58c implement pg_vfs_open
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
1
38bf7b42b58c implement pg_vfs_open
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
2 create table Resource (
38bf7b42b58c implement pg_vfs_open
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
3 resource_id serial primary key,
38bf7b42b58c implement pg_vfs_open
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
4 parent_id int references Resource(resource_id),
38bf7b42b58c implement pg_vfs_open
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
5 nodename text not null,
38bf7b42b58c implement pg_vfs_open
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
6 iscollection boolean not null default(false),
38bf7b42b58c implement pg_vfs_open
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
7
38bf7b42b58c implement pg_vfs_open
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
8 unique(parent_id, nodename)
38bf7b42b58c implement pg_vfs_open
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
9 );

mercurial