comparison: doc/development/postgresql_vfs.sql
doc/development/postgresql_vfs.sql
- branch
- webdav
- changeset 281
- e9dc53661df4
- parent 278
- 38bf7b42b58c
- child 283
- 25e5b771677d
equal
deleted
inserted
replaced
| 280:d0d5a970292f | 281:e9dc53661df4 |
|---|---|
| 1 | 1 |
| 2 create table Resource ( | 2 create table Resource ( |
| 3 resource_id serial primary key, | 3 resource_id serial primary key, |
| 4 parent_id int references Resource(resource_id), | 4 parent_id int references Resource(resource_id), |
| 5 nodename text not null, | 5 nodename text not null, |
| 6 iscollection boolean not null default(false), | 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, | |
| 7 | 11 |
| 8 unique(parent_id, nodename) | 12 unique(parent_id, nodename) |
| 9 ); | 13 ); |
| 14 |
