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

Tue, 12 Sep 2023 18:08:11 +0200

author
Olaf Wintermann <olaf.wintermann@gmail.com>
date
Tue, 12 Sep 2023 18:08:11 +0200
changeset 511
a5a142fea2ae
parent 288
7dd45173f68a
permissions
-rw-r--r--

update uwproj

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