comparison: src/server/plugins/postgresql/test/postgresql_vfs.sql
src/server/plugins/postgresql/test/postgresql_vfs.sql
- branch
- webdav
- changeset 288
- 7dd45173f68a
equal
deleted
inserted
replaced
| 287:a171da778817 | 288:7dd45173f68a |
|---|---|
| 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 |
