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

Sun, 06 Nov 2022 15:53:32 +0100

author
Olaf Wintermann <olaf.wintermann@gmail.com>
date
Sun, 06 Nov 2022 15:53:32 +0100
changeset 415
d938228c382e
parent 288
7dd45173f68a
permissions
-rw-r--r--

switch from ucx 2 to 3

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