1
2 create table Resource (
3 resource_id serial primary key,
4 parent_id int references Resource(resource_id),
5 nodename text not null,
6 iscollection boolean not null default false,
7
8 lastmodified timestamp not null default current_date,
9 creationdate timestamp not null default current_date,
10 contentlength bigint not null default 0,
11
12 resoid oid,
13
14 unique(parent_id, nodename)
15 );
16
17