doc/development/postgresql_vfs.sql

Tue, 01 Nov 2022 15:39:21 +0100

author
Olaf Wintermann <olaf.wintermann@gmail.com>
date
Tue, 01 Nov 2022 15:39:21 +0100
changeset 401
d2bfd11d3f8f
parent 366
47bc686fafe4
permissions
-rw-r--r--

fix invalid propfind pg queries created for allprop requests on collections

create table Resource (
    resource_id       serial    primary key,
    parent_id         int       references Resource(resource_id),
    nodename          text      not null,
    iscollection      boolean   not null default false,
	
    lastmodified      timestamp not null default current_date,
    creationdate      timestamp not null default current_date,
    contentlength     bigint    not null default 0,
	
	etag              uuid,

    resoid            oid,
    
    unique(parent_id, nodename)
);

create table Property (
	property_id       serial   primary key,
	resource_id       int      references Resource(resource_id) on delete cascade,
	prefix            text     not null,
	xmlns             text     not null,
	pname             text     not null,
	lang              text,
	nsdeflist         text,
	pvalue            text,
	
	unique(resource_id, xmlns, pname)       
);

create type property_name as (
 xmlns     text,
 name      text
);

mercurial