Revision 6277
Added by ben leinfelder almost 13 years ago
xmltables-postgres.sql | ||
---|---|---|
296 | 296 |
*/ |
297 | 297 |
CREATE TABLE systemMetadata ( |
298 | 298 |
guid text, -- the globally unique string identifier of the object that the system metadata describes |
299 |
provisional boolean, -- for reserved identifiers |
|
299 | 300 |
date_uploaded TIMESTAMP, -- the date/time the document was first submitted |
300 | 301 |
rights_holder VARCHAR(250), --the user who has rights to the document, usually the first persons to upload it |
301 | 302 |
checksum VARCHAR(512), --the checksum of the doc using the given algorithm (see below) |
... | ... | |
316 | 317 |
* ALTER TABLE systemMetadata DROP COLUMN rev; |
317 | 318 |
* ALTER TABLE systemMetadata ADD COLUMN replication_allowed boolean; |
318 | 319 |
* ALTER TABLE systemMetadata ADD COLUMN number_replicas INT8; |
320 |
* ALTER TABLE systemMetadata ADD COLUMN provisional boolean; |
|
319 | 321 |
*/ |
320 | 322 |
|
321 | 323 |
/* |
Also available in: Unified diff
allow for provisional SystemMetadata records (provisional=true)