doc/development/postgresql_vfs.sql@79029fe26aae (annotated)
doc/development/postgresql_vfs.sql
Mon, 31 Jan 2022 17:18:12 +0100
- author
- Olaf Wintermann <olaf.wintermann@gmail.com>
- date
- Mon, 31 Jan 2022 17:18:12 +0100
- branch
- webdav
- changeset 279
- 79029fe26aae
- parent 278
- 38bf7b42b58c
- child 281
- e9dc53661df4
- permissions
- -rw-r--r--
add basic postgresql vfs directory functions
|
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 | ); |
