doc/development/postgresql_vfs.sql

Sun, 08 May 2022 19:29:27 +0200

author
Olaf Wintermann <olaf.wintermann@gmail.com>
date
Sun, 08 May 2022 19:29:27 +0200
branch
webdav
changeset 346
784b24381bed
parent 318
60870dbac94f
child 366
47bc686fafe4
permissions
-rw-r--r--

extend postgresql vfs to store an etag in the file


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