| 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, |