doc/development/postgresql_vfs.sql

changeset 580
315c625bf141
parent 366
47bc686fafe4
equal deleted inserted replaced
579:e10457d74fe1 580:315c625bf141
1 create table Resource ( 1 create table Resource (
2 resource_id serial primary key, 2 resource_id serial primary key,
3 parent_id int references Resource(resource_id), 3 parent_id int references Resource(resource_id),
4 nodename text not null, 4 nodename text not null,
5 displayname text,
6 contenttype text,
5 iscollection boolean not null default false, 7 iscollection boolean not null default false,
6 8
7 lastmodified timestamp not null default current_date, 9 lastmodified timestamp not null default current_date,
8 creationdate timestamp not null default current_date, 10 creationdate timestamp not null default current_date,
9 contentlength bigint not null default 0, 11 contentlength bigint not null default 0,

mercurial