doc/development/postgresql_vfs.sql@38bf7b42b58c (annotated)
doc/development/postgresql_vfs.sql
Sun, 30 Jan 2022 15:25:29 +0100
- author
- Olaf Wintermann <olaf.wintermann@gmail.com>
- date
- Sun, 30 Jan 2022 15:25:29 +0100
- branch
- webdav
- changeset 278
- 38bf7b42b58c
- child 281
- e9dc53661df4
- permissions
- -rw-r--r--
implement pg_vfs_open
|
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 | ); |
