src/server/plugins/postgresql/test/postgresql_vfs.sql

Sun, 01 May 2022 10:48:20 +0200

author
Olaf Wintermann <olaf.wintermann@gmail.com>
date
Sun, 01 May 2022 10:48:20 +0200
branch
webdav
changeset 319
a9b9344875aa
parent 288
7dd45173f68a
permissions
-rw-r--r--

add WebdavNSList <-> string converting functions

288
7dd45173f68a create pg test data
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
1
7dd45173f68a create pg test data
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
2 create table Resource (
7dd45173f68a create pg test data
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
3 resource_id serial primary key,
7dd45173f68a create pg test data
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
4 parent_id int references Resource(resource_id),
7dd45173f68a create pg test data
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
5 nodename text not null,
7dd45173f68a create pg test data
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
6 iscollection boolean not null default false,
7dd45173f68a create pg test data
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
7
7dd45173f68a create pg test data
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
8 lastmodified timestamp not null default current_date,
7dd45173f68a create pg test data
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
9 creationdate timestamp not null default current_date,
7dd45173f68a create pg test data
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
10 contentlength bigint not null default 0,
7dd45173f68a create pg test data
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
11
7dd45173f68a create pg test data
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
12 resoid oid,
7dd45173f68a create pg test data
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
13
7dd45173f68a create pg test data
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
14 unique(parent_id, nodename)
7dd45173f68a create pg test data
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
15 );
7dd45173f68a create pg test data
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
16

mercurial